BI Publisher (MOSC)

MOSC Banner

Group filter in XML Data Template

edited Aug 24, 2017 5:00AM in BI Publisher (MOSC) 6 commentsAnswered

Hi All,

How to call Group filter which is having update table code(calling update table procedure) in XML data template

FUNCTION G_inv_termgroupfilter(customer_trx_id    IN NUMBER,
                           term_count         IN NUMBER,
                           term_relative_amount   IN NUMBER,
                           term_sequence_number   IN NUMBER,
                           trx_type           IN VARCHAR2,
                           printing_original_date IN DATE,
                           printing_count     IN NUMBER)

RETURN BOOLEAN

IS

  cust_trx_id  NUMBER;

  v_term_amt   NUMBER;

  v_term_num   NUMBER;

  v_date   DATE;

  v_print_cnt  NUMBER;

  v_trx_type   VARCHAR2(80);

  v_term_count NUMBER;

BEGIN

v_term_amt:=term_relative_amount;
v_term_num:=term_sequence_number;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center