[Home] [Help]
1: PACKAGE BODY JGRX_WT AS
2: /* $Header: jgrxwtb.pls 120.13 2006/09/22 17:43:34 dbetanco ship $ */
3: /**************************************************************************
4: * Record Structure to hold placeholder values *
5: **************************************************************************/
81: retcode out NOCOPY number,
82: errbuf out NOCOPY varchar2)
83: IS
84: BEGIN
85: fa_rx_util_pkg.debug('jgrx_wt.get_withholding_tax()+');
86:
87: -- Initialize request
88: fa_rx_util_pkg.init_request('jgrx_wt.get_withholding_tax', request_id);
89:
84: BEGIN
85: fa_rx_util_pkg.debug('jgrx_wt.get_withholding_tax()+');
86:
87: -- Initialize request
88: fa_rx_util_pkg.init_request('jgrx_wt.get_withholding_tax', request_id);
89:
90: fa_rx_util_pkg.assign_report(section_name,
91: true,
92: 'jgrx_wt.before_report;',
88: fa_rx_util_pkg.init_request('jgrx_wt.get_withholding_tax', request_id);
89:
90: fa_rx_util_pkg.assign_report(section_name,
91: true,
92: 'jgrx_wt.before_report;',
93: NULL,
94: NULL,
95: NULL);
96:
93: NULL,
94: NULL,
95: NULL);
96:
97: fa_rx_util_pkg.run_report('jgrx_wt.get_withholding_tax', retcode, errbuf);
98:
99: fa_rx_util_pkg.debug('jgrx_wt.get_withholding_tax()-');
100:
101: END GET_WITHHOLDING_TAX;
95: NULL);
96:
97: fa_rx_util_pkg.run_report('jgrx_wt.get_withholding_tax', retcode, errbuf);
98:
99: fa_rx_util_pkg.debug('jgrx_wt.get_withholding_tax()-');
100:
101: END GET_WITHHOLDING_TAX;
102:
103:
132: errbuf out NOCOPY VARCHAR2)
133: IS
134: BEGIN
135:
136: fa_rx_util_pkg.debug('jgrx_wt.jg_wht_extract()+');
137:
138: -- Initialize request
139: fa_rx_util_pkg.init_request('jgrx_wt.jg_wht_extract', request_id);
140:
135:
136: fa_rx_util_pkg.debug('jgrx_wt.jg_wht_extract()+');
137:
138: -- Initialize request
139: fa_rx_util_pkg.init_request('jgrx_wt.jg_wht_extract', request_id);
140:
141: -- Store the parameters in a variable which can be accessed globally across
142: -- all procedures
143: parm.p_gldate_from := p_gldate_from;
161: -- this stage. Plug-in would add what is specific to the report. No data is
162: -- inserted into the interface table at this stage.
163:
164:
165: jgrx_wt.get_withholding_tax( request_id,
166: 'get_withholding_tax',
167: retcode,
168: errbuf);
169:
170: -- Plug-in code is executed here.
171:
172: fa_rx_util_pkg.assign_report('get_withholding_tax',
173: true,
174: 'jgrx_wt.wht_before_report;',
175: 'jgrx_wt.wht_bind(:CURSOR_SELECT);',
176: 'jgrx_wt.wht_after_fetch;',
177: NULL);
178:
171:
172: fa_rx_util_pkg.assign_report('get_withholding_tax',
173: true,
174: 'jgrx_wt.wht_before_report;',
175: 'jgrx_wt.wht_bind(:CURSOR_SELECT);',
176: 'jgrx_wt.wht_after_fetch;',
177: NULL);
178:
179: fa_rx_util_pkg.run_report('jgrx_wt.jg_wht_extract', retcode, errbuf);
172: fa_rx_util_pkg.assign_report('get_withholding_tax',
173: true,
174: 'jgrx_wt.wht_before_report;',
175: 'jgrx_wt.wht_bind(:CURSOR_SELECT);',
176: 'jgrx_wt.wht_after_fetch;',
177: NULL);
178:
179: fa_rx_util_pkg.run_report('jgrx_wt.jg_wht_extract', retcode, errbuf);
180:
175: 'jgrx_wt.wht_bind(:CURSOR_SELECT);',
176: 'jgrx_wt.wht_after_fetch;',
177: NULL);
178:
179: fa_rx_util_pkg.run_report('jgrx_wt.jg_wht_extract', retcode, errbuf);
180:
181: fa_rx_util_pkg.debug('jgrx_wt.jg_wht_extract()-');
182:
183: END jg_wht_extract;
177: NULL);
178:
179: fa_rx_util_pkg.run_report('jgrx_wt.jg_wht_extract', retcode, errbuf);
180:
181: fa_rx_util_pkg.debug('jgrx_wt.jg_wht_extract()-');
182:
183: END jg_wht_extract;
184:
185: /***************************************************************************
191: ***************************************************************************/
192: PROCEDURE before_report
193: IS
194: BEGIN
195: fa_rx_util_pkg.debug('jgrx_wt.before_report(+)');
196:
197: -- Get the Reporting SOB_ID, SOB_NAME, Functional_currency_code
198: fnd_profile.get('GL_SET_OF_BKS_ID', jgrx_wt.var.sob_id);
199:
194: BEGIN
195: fa_rx_util_pkg.debug('jgrx_wt.before_report(+)');
196:
197: -- Get the Reporting SOB_ID, SOB_NAME, Functional_currency_code
198: fnd_profile.get('GL_SET_OF_BKS_ID', jgrx_wt.var.sob_id);
199:
200: begin
201: select name, currency_code, chart_of_accounts_id
202: into jgrx_wt.var.reporting_sob_name,
198: fnd_profile.get('GL_SET_OF_BKS_ID', jgrx_wt.var.sob_id);
199:
200: begin
201: select name, currency_code, chart_of_accounts_id
202: into jgrx_wt.var.reporting_sob_name,
203: jgrx_wt.var.func_currency_code, l_coa_id
204: from gl_sets_of_books
205: where set_of_books_id = jgrx_wt.var.sob_id;
206: exception
199:
200: begin
201: select name, currency_code, chart_of_accounts_id
202: into jgrx_wt.var.reporting_sob_name,
203: jgrx_wt.var.func_currency_code, l_coa_id
204: from gl_sets_of_books
205: where set_of_books_id = jgrx_wt.var.sob_id;
206: exception
207: WHEN no_data_found THEN
201: select name, currency_code, chart_of_accounts_id
202: into jgrx_wt.var.reporting_sob_name,
203: jgrx_wt.var.func_currency_code, l_coa_id
204: from gl_sets_of_books
205: where set_of_books_id = jgrx_wt.var.sob_id;
206: exception
207: WHEN no_data_found THEN
208: RAISE_APPLICATION_ERROR(-20010,sqlerrm);
209: end;
312: l_where_flex := ' and '||l_where_flex;
313: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || l_where_flex;
314: End if;
315:
316: fa_rx_util_pkg.debug('jgrx_wt.wht_before_report()-');
317:
318: END wht_before_report;
319:
320:
343: b_for_inc_categ varchar2(80);
344:
345: BEGIN
346:
347: fa_rx_util_pkg.debug('jgrx_wt.wht_bind()+');
348:
349: If parm.p_gldate_from IS NOT NULL then
350: fa_rx_util_pkg.debug('Binding b_gldate_from');
351: dbms_sql.bind_variable(c, 'b_gldate_from', parm.p_gldate_from);
414: dbms_sql.bind_variable(c, 'b_legal_entity_id', parm.p_legal_entity_id);
415: End If;
416:
417:
418: fa_rx_util_pkg.debug('jgrx_wt.wht_bind()-');
419: END wht_bind;
420:
421: /***************************************************************************
422: * *
428: ***************************************************************************/
429: PROCEDURE wht_after_fetch
430: IS
431: BEGIN
432: fa_rx_util_pkg.debug('jgrx_wt.wht_after_fetch()+');
433:
434: jgrx_wt.var.total_wht_amount := jgrx_wt.var.resident_tax+
435: jgrx_wt.var.income_tax;
436: /* Bug 1339324 */
430: IS
431: BEGIN
432: fa_rx_util_pkg.debug('jgrx_wt.wht_after_fetch()+');
433:
434: jgrx_wt.var.total_wht_amount := jgrx_wt.var.resident_tax+
435: jgrx_wt.var.income_tax;
436: /* Bug 1339324 */
437: IF jgrx_wt.var.amt_subject_to_wh is NULL then
438: jgrx_wt.var.amt_subject_to_wh := jgrx_wt.var.invoice_amount;
431: BEGIN
432: fa_rx_util_pkg.debug('jgrx_wt.wht_after_fetch()+');
433:
434: jgrx_wt.var.total_wht_amount := jgrx_wt.var.resident_tax+
435: jgrx_wt.var.income_tax;
436: /* Bug 1339324 */
437: IF jgrx_wt.var.amt_subject_to_wh is NULL then
438: jgrx_wt.var.amt_subject_to_wh := jgrx_wt.var.invoice_amount;
439: END IF;
433:
434: jgrx_wt.var.total_wht_amount := jgrx_wt.var.resident_tax+
435: jgrx_wt.var.income_tax;
436: /* Bug 1339324 */
437: IF jgrx_wt.var.amt_subject_to_wh is NULL then
438: jgrx_wt.var.amt_subject_to_wh := jgrx_wt.var.invoice_amount;
439: END IF;
440:
441: /* Bug 1347708 */
434: jgrx_wt.var.total_wht_amount := jgrx_wt.var.resident_tax+
435: jgrx_wt.var.income_tax;
436: /* Bug 1339324 */
437: IF jgrx_wt.var.amt_subject_to_wh is NULL then
438: jgrx_wt.var.amt_subject_to_wh := jgrx_wt.var.invoice_amount;
439: END IF;
440:
441: /* Bug 1347708 */
442: IF (jgrx_wt.var.total_wht_amount > 0 and jgrx_wt.var.amt_subject_to_wh > 0)
438: jgrx_wt.var.amt_subject_to_wh := jgrx_wt.var.invoice_amount;
439: END IF;
440:
441: /* Bug 1347708 */
442: IF (jgrx_wt.var.total_wht_amount > 0 and jgrx_wt.var.amt_subject_to_wh > 0)
443: THEN
444: jgrx_wt.var.amt_subject_to_wh := -1 * jgrx_wt.var.amt_subject_to_wh;
445: END IF;
446:
440:
441: /* Bug 1347708 */
442: IF (jgrx_wt.var.total_wht_amount > 0 and jgrx_wt.var.amt_subject_to_wh > 0)
443: THEN
444: jgrx_wt.var.amt_subject_to_wh := -1 * jgrx_wt.var.amt_subject_to_wh;
445: END IF;
446:
447: jgrx_wt.var.recognized_expense_amt := jgrx_wt.var.amt_subject_to_wh*
448: to_number(jgrx_wt.var.recognized_expense_percent)/100;
443: THEN
444: jgrx_wt.var.amt_subject_to_wh := -1 * jgrx_wt.var.amt_subject_to_wh;
445: END IF;
446:
447: jgrx_wt.var.recognized_expense_amt := jgrx_wt.var.amt_subject_to_wh*
448: to_number(jgrx_wt.var.recognized_expense_percent)/100;
449:
450: jgrx_wt.var.nominal_or_reg_tax_rate :=
451: nvl(to_number(jgrx_wt.var.nominal_tax_rate),
444: jgrx_wt.var.amt_subject_to_wh := -1 * jgrx_wt.var.amt_subject_to_wh;
445: END IF;
446:
447: jgrx_wt.var.recognized_expense_amt := jgrx_wt.var.amt_subject_to_wh*
448: to_number(jgrx_wt.var.recognized_expense_percent)/100;
449:
450: jgrx_wt.var.nominal_or_reg_tax_rate :=
451: nvl(to_number(jgrx_wt.var.nominal_tax_rate),
452: jgrx_wt.var.tax_rate);
446:
447: jgrx_wt.var.recognized_expense_amt := jgrx_wt.var.amt_subject_to_wh*
448: to_number(jgrx_wt.var.recognized_expense_percent)/100;
449:
450: jgrx_wt.var.nominal_or_reg_tax_rate :=
451: nvl(to_number(jgrx_wt.var.nominal_tax_rate),
452: jgrx_wt.var.tax_rate);
453:
454: IF (jgrx_wt.var.withholding_tax_type = 'INCOME') THEN
447: jgrx_wt.var.recognized_expense_amt := jgrx_wt.var.amt_subject_to_wh*
448: to_number(jgrx_wt.var.recognized_expense_percent)/100;
449:
450: jgrx_wt.var.nominal_or_reg_tax_rate :=
451: nvl(to_number(jgrx_wt.var.nominal_tax_rate),
452: jgrx_wt.var.tax_rate);
453:
454: IF (jgrx_wt.var.withholding_tax_type = 'INCOME') THEN
455: jgrx_wt.var.inc_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh-
448: to_number(jgrx_wt.var.recognized_expense_percent)/100;
449:
450: jgrx_wt.var.nominal_or_reg_tax_rate :=
451: nvl(to_number(jgrx_wt.var.nominal_tax_rate),
452: jgrx_wt.var.tax_rate);
453:
454: IF (jgrx_wt.var.withholding_tax_type = 'INCOME') THEN
455: jgrx_wt.var.inc_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh-
456: nvl(jgrx_wt.var.recognized_expense_amt,0);
450: jgrx_wt.var.nominal_or_reg_tax_rate :=
451: nvl(to_number(jgrx_wt.var.nominal_tax_rate),
452: jgrx_wt.var.tax_rate);
453:
454: IF (jgrx_wt.var.withholding_tax_type = 'INCOME') THEN
455: jgrx_wt.var.inc_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh-
456: nvl(jgrx_wt.var.recognized_expense_amt,0);
457: jgrx_wt.var.inc_wh_tax_base_amt := Ap_Utilities_Pkg.Ap_Round_Currency
458: (jgrx_wt.var.inc_wh_tax_base_amt,
451: nvl(to_number(jgrx_wt.var.nominal_tax_rate),
452: jgrx_wt.var.tax_rate);
453:
454: IF (jgrx_wt.var.withholding_tax_type = 'INCOME') THEN
455: jgrx_wt.var.inc_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh-
456: nvl(jgrx_wt.var.recognized_expense_amt,0);
457: jgrx_wt.var.inc_wh_tax_base_amt := Ap_Utilities_Pkg.Ap_Round_Currency
458: (jgrx_wt.var.inc_wh_tax_base_amt,
459: jgrx_wt.var.func_currency_code);
452: jgrx_wt.var.tax_rate);
453:
454: IF (jgrx_wt.var.withholding_tax_type = 'INCOME') THEN
455: jgrx_wt.var.inc_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh-
456: nvl(jgrx_wt.var.recognized_expense_amt,0);
457: jgrx_wt.var.inc_wh_tax_base_amt := Ap_Utilities_Pkg.Ap_Round_Currency
458: (jgrx_wt.var.inc_wh_tax_base_amt,
459: jgrx_wt.var.func_currency_code);
460: ELSE
453:
454: IF (jgrx_wt.var.withholding_tax_type = 'INCOME') THEN
455: jgrx_wt.var.inc_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh-
456: nvl(jgrx_wt.var.recognized_expense_amt,0);
457: jgrx_wt.var.inc_wh_tax_base_amt := Ap_Utilities_Pkg.Ap_Round_Currency
458: (jgrx_wt.var.inc_wh_tax_base_amt,
459: jgrx_wt.var.func_currency_code);
460: ELSE
461: jgrx_wt.var.inc_wh_tax_base_amt := 0;
454: IF (jgrx_wt.var.withholding_tax_type = 'INCOME') THEN
455: jgrx_wt.var.inc_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh-
456: nvl(jgrx_wt.var.recognized_expense_amt,0);
457: jgrx_wt.var.inc_wh_tax_base_amt := Ap_Utilities_Pkg.Ap_Round_Currency
458: (jgrx_wt.var.inc_wh_tax_base_amt,
459: jgrx_wt.var.func_currency_code);
460: ELSE
461: jgrx_wt.var.inc_wh_tax_base_amt := 0;
462: END IF;
455: jgrx_wt.var.inc_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh-
456: nvl(jgrx_wt.var.recognized_expense_amt,0);
457: jgrx_wt.var.inc_wh_tax_base_amt := Ap_Utilities_Pkg.Ap_Round_Currency
458: (jgrx_wt.var.inc_wh_tax_base_amt,
459: jgrx_wt.var.func_currency_code);
460: ELSE
461: jgrx_wt.var.inc_wh_tax_base_amt := 0;
462: END IF;
463:
457: jgrx_wt.var.inc_wh_tax_base_amt := Ap_Utilities_Pkg.Ap_Round_Currency
458: (jgrx_wt.var.inc_wh_tax_base_amt,
459: jgrx_wt.var.func_currency_code);
460: ELSE
461: jgrx_wt.var.inc_wh_tax_base_amt := 0;
462: END IF;
463:
464: IF (jgrx_wt.var.withholding_tax_type = 'RESIDENT') THEN
465: jgrx_wt.var.res_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh;
460: ELSE
461: jgrx_wt.var.inc_wh_tax_base_amt := 0;
462: END IF;
463:
464: IF (jgrx_wt.var.withholding_tax_type = 'RESIDENT') THEN
465: jgrx_wt.var.res_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh;
466: ELSE
467: jgrx_wt.var.res_wh_tax_base_amt := 0;
468: END IF;
461: jgrx_wt.var.inc_wh_tax_base_amt := 0;
462: END IF;
463:
464: IF (jgrx_wt.var.withholding_tax_type = 'RESIDENT') THEN
465: jgrx_wt.var.res_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh;
466: ELSE
467: jgrx_wt.var.res_wh_tax_base_amt := 0;
468: END IF;
469:
463:
464: IF (jgrx_wt.var.withholding_tax_type = 'RESIDENT') THEN
465: jgrx_wt.var.res_wh_tax_base_amt := jgrx_wt.var.amt_subject_to_wh;
466: ELSE
467: jgrx_wt.var.res_wh_tax_base_amt := 0;
468: END IF;
469:
470: jgrx_wt.var.total_tax_base_amt := nvl(jgrx_wt.var.res_wh_tax_base_amt,0) +
471: nvl(jgrx_wt.var.inc_wh_tax_base_amt,0);
466: ELSE
467: jgrx_wt.var.res_wh_tax_base_amt := 0;
468: END IF;
469:
470: jgrx_wt.var.total_tax_base_amt := nvl(jgrx_wt.var.res_wh_tax_base_amt,0) +
471: nvl(jgrx_wt.var.inc_wh_tax_base_amt,0);
472:
473: IF (jgrx_wt.var.create_dist = 'PAYMENT') then
474: jgrx_wt.var.net_amount:= jgrx_wt.var.payment_amount;
467: jgrx_wt.var.res_wh_tax_base_amt := 0;
468: END IF;
469:
470: jgrx_wt.var.total_tax_base_amt := nvl(jgrx_wt.var.res_wh_tax_base_amt,0) +
471: nvl(jgrx_wt.var.inc_wh_tax_base_amt,0);
472:
473: IF (jgrx_wt.var.create_dist = 'PAYMENT') then
474: jgrx_wt.var.net_amount:= jgrx_wt.var.payment_amount;
475: ELSIF (jgrx_wt.var.create_dist = 'APPROVAL') then
469:
470: jgrx_wt.var.total_tax_base_amt := nvl(jgrx_wt.var.res_wh_tax_base_amt,0) +
471: nvl(jgrx_wt.var.inc_wh_tax_base_amt,0);
472:
473: IF (jgrx_wt.var.create_dist = 'PAYMENT') then
474: jgrx_wt.var.net_amount:= jgrx_wt.var.payment_amount;
475: ELSIF (jgrx_wt.var.create_dist = 'APPROVAL') then
476: declare
477: l_amount NUMBER := 0;
470: jgrx_wt.var.total_tax_base_amt := nvl(jgrx_wt.var.res_wh_tax_base_amt,0) +
471: nvl(jgrx_wt.var.inc_wh_tax_base_amt,0);
472:
473: IF (jgrx_wt.var.create_dist = 'PAYMENT') then
474: jgrx_wt.var.net_amount:= jgrx_wt.var.payment_amount;
475: ELSIF (jgrx_wt.var.create_dist = 'APPROVAL') then
476: declare
477: l_amount NUMBER := 0;
478: begin
471: nvl(jgrx_wt.var.inc_wh_tax_base_amt,0);
472:
473: IF (jgrx_wt.var.create_dist = 'PAYMENT') then
474: jgrx_wt.var.net_amount:= jgrx_wt.var.payment_amount;
475: ELSIF (jgrx_wt.var.create_dist = 'APPROVAL') then
476: declare
477: l_amount NUMBER := 0;
478: begin
479: select sum(nvl(ind.base_amount,ind.amount))
478: begin
479: select sum(nvl(ind.base_amount,ind.amount))
480: into l_amount
481: from ap_invoice_distributions_all ind
482: where ind.invoice_id = jgrx_wt.var.invoice_id
483: and ind.line_type_lookup_code = 'AWT'
484: and ind.org_id = jgrx_wt.var.org_id;
485: jgrx_wt.var.net_amount:= jgrx_wt.var.invoice_amount + l_amount;
486: exception
480: into l_amount
481: from ap_invoice_distributions_all ind
482: where ind.invoice_id = jgrx_wt.var.invoice_id
483: and ind.line_type_lookup_code = 'AWT'
484: and ind.org_id = jgrx_wt.var.org_id;
485: jgrx_wt.var.net_amount:= jgrx_wt.var.invoice_amount + l_amount;
486: exception
487: WHEN no_data_found THEN
488: RAISE_APPLICATION_ERROR(-20010,sqlerrm);
481: from ap_invoice_distributions_all ind
482: where ind.invoice_id = jgrx_wt.var.invoice_id
483: and ind.line_type_lookup_code = 'AWT'
484: and ind.org_id = jgrx_wt.var.org_id;
485: jgrx_wt.var.net_amount:= jgrx_wt.var.invoice_amount + l_amount;
486: exception
487: WHEN no_data_found THEN
488: RAISE_APPLICATION_ERROR(-20010,sqlerrm);
489: when others then
491: SQLCODE||';'||SQLERRM);
492: end;
493: END IF;
494:
495: jgrx_wt.var.supp_concatenated_address := jgrx_wt.var.supplier_address_line1
496: || jgrx_wt.var.supplier_address_line2|| jgrx_wt.var.supplier_address_line3
497: || jgrx_wt.var.supplier_country|| jgrx_wt.var.supplier_postal_code;
498:
499: jgrx_wt.var.accounting_flexfield := FA_RX_FLEX_PKG.GET_VALUE
492: end;
493: END IF;
494:
495: jgrx_wt.var.supp_concatenated_address := jgrx_wt.var.supplier_address_line1
496: || jgrx_wt.var.supplier_address_line2|| jgrx_wt.var.supplier_address_line3
497: || jgrx_wt.var.supplier_country|| jgrx_wt.var.supplier_postal_code;
498:
499: jgrx_wt.var.accounting_flexfield := FA_RX_FLEX_PKG.GET_VALUE
500: (P_APPLICATION_ID => 101,
493: END IF;
494:
495: jgrx_wt.var.supp_concatenated_address := jgrx_wt.var.supplier_address_line1
496: || jgrx_wt.var.supplier_address_line2|| jgrx_wt.var.supplier_address_line3
497: || jgrx_wt.var.supplier_country|| jgrx_wt.var.supplier_postal_code;
498:
499: jgrx_wt.var.accounting_flexfield := FA_RX_FLEX_PKG.GET_VALUE
500: (P_APPLICATION_ID => 101,
501: P_ID_FLEX_CODE => 'GL#',
495: jgrx_wt.var.supp_concatenated_address := jgrx_wt.var.supplier_address_line1
496: || jgrx_wt.var.supplier_address_line2|| jgrx_wt.var.supplier_address_line3
497: || jgrx_wt.var.supplier_country|| jgrx_wt.var.supplier_postal_code;
498:
499: jgrx_wt.var.accounting_flexfield := FA_RX_FLEX_PKG.GET_VALUE
500: (P_APPLICATION_ID => 101,
501: P_ID_FLEX_CODE => 'GL#',
502: P_ID_FLEX_NUM => L_COA_ID,
503: P_QUALIFIER => 'ALL',
500: (P_APPLICATION_ID => 101,
501: P_ID_FLEX_CODE => 'GL#',
502: P_ID_FLEX_NUM => L_COA_ID,
503: P_QUALIFIER => 'ALL',
504: P_CCID => jgrx_wt.var.dist_code_combination_id);
505:
506: jgrx_wt.var.biz_inc_sub_categ_meaning := get_lookup_meaning('FND',
507: 'JAKR_AP_AWT_BIZ_INC_SUB_CAT',
508: jgrx_wt.var.business_inc_sub_category);
502: P_ID_FLEX_NUM => L_COA_ID,
503: P_QUALIFIER => 'ALL',
504: P_CCID => jgrx_wt.var.dist_code_combination_id);
505:
506: jgrx_wt.var.biz_inc_sub_categ_meaning := get_lookup_meaning('FND',
507: 'JAKR_AP_AWT_BIZ_INC_SUB_CAT',
508: jgrx_wt.var.business_inc_sub_category);
509:
510: jgrx_wt.var.org_type_meaning := get_lookup_meaning('PO',
504: P_CCID => jgrx_wt.var.dist_code_combination_id);
505:
506: jgrx_wt.var.biz_inc_sub_categ_meaning := get_lookup_meaning('FND',
507: 'JAKR_AP_AWT_BIZ_INC_SUB_CAT',
508: jgrx_wt.var.business_inc_sub_category);
509:
510: jgrx_wt.var.org_type_meaning := get_lookup_meaning('PO',
511: 'ORGANIZATION TYPE',
512: jgrx_wt.var.organization_type);
506: jgrx_wt.var.biz_inc_sub_categ_meaning := get_lookup_meaning('FND',
507: 'JAKR_AP_AWT_BIZ_INC_SUB_CAT',
508: jgrx_wt.var.business_inc_sub_category);
509:
510: jgrx_wt.var.org_type_meaning := get_lookup_meaning('PO',
511: 'ORGANIZATION TYPE',
512: jgrx_wt.var.organization_type);
513:
514: jgrx_wt.var.wh_tax_type_meaning := get_lookup_meaning('FND',
508: jgrx_wt.var.business_inc_sub_category);
509:
510: jgrx_wt.var.org_type_meaning := get_lookup_meaning('PO',
511: 'ORGANIZATION TYPE',
512: jgrx_wt.var.organization_type);
513:
514: jgrx_wt.var.wh_tax_type_meaning := get_lookup_meaning('FND',
515: 'JAKR_AP_AWT_TAX_TYPE',
516: jgrx_wt.var.withholding_tax_type);
510: jgrx_wt.var.org_type_meaning := get_lookup_meaning('PO',
511: 'ORGANIZATION TYPE',
512: jgrx_wt.var.organization_type);
513:
514: jgrx_wt.var.wh_tax_type_meaning := get_lookup_meaning('FND',
515: 'JAKR_AP_AWT_TAX_TYPE',
516: jgrx_wt.var.withholding_tax_type);
517:
518: jgrx_wt.var.res_inc_categ_meaning := get_lookup_meaning('FND',
512: jgrx_wt.var.organization_type);
513:
514: jgrx_wt.var.wh_tax_type_meaning := get_lookup_meaning('FND',
515: 'JAKR_AP_AWT_TAX_TYPE',
516: jgrx_wt.var.withholding_tax_type);
517:
518: jgrx_wt.var.res_inc_categ_meaning := get_lookup_meaning('FND',
519: 'JAKR_AP_AWT_INC_CAT_DOMESTIC',
520: jgrx_wt.var.resident_inc_categ_code);
514: jgrx_wt.var.wh_tax_type_meaning := get_lookup_meaning('FND',
515: 'JAKR_AP_AWT_TAX_TYPE',
516: jgrx_wt.var.withholding_tax_type);
517:
518: jgrx_wt.var.res_inc_categ_meaning := get_lookup_meaning('FND',
519: 'JAKR_AP_AWT_INC_CAT_DOMESTIC',
520: jgrx_wt.var.resident_inc_categ_code);
521:
522: jgrx_wt.var.for_inc_categ_meaning := get_lookup_meaning('FND',
516: jgrx_wt.var.withholding_tax_type);
517:
518: jgrx_wt.var.res_inc_categ_meaning := get_lookup_meaning('FND',
519: 'JAKR_AP_AWT_INC_CAT_DOMESTIC',
520: jgrx_wt.var.resident_inc_categ_code);
521:
522: jgrx_wt.var.for_inc_categ_meaning := get_lookup_meaning('FND',
523: 'JAKR_AP_AWT_INC_CAT_FOREIGN',
524: jgrx_wt.var.foreign_inc_categ_code);
518: jgrx_wt.var.res_inc_categ_meaning := get_lookup_meaning('FND',
519: 'JAKR_AP_AWT_INC_CAT_DOMESTIC',
520: jgrx_wt.var.resident_inc_categ_code);
521:
522: jgrx_wt.var.for_inc_categ_meaning := get_lookup_meaning('FND',
523: 'JAKR_AP_AWT_INC_CAT_FOREIGN',
524: jgrx_wt.var.foreign_inc_categ_code);
525:
526: fa_rx_util_pkg.debug('jgrx_wt.wht_after_fetch()-');
520: jgrx_wt.var.resident_inc_categ_code);
521:
522: jgrx_wt.var.for_inc_categ_meaning := get_lookup_meaning('FND',
523: 'JAKR_AP_AWT_INC_CAT_FOREIGN',
524: jgrx_wt.var.foreign_inc_categ_code);
525:
526: fa_rx_util_pkg.debug('jgrx_wt.wht_after_fetch()-');
527:
528: END wht_after_fetch;
522: jgrx_wt.var.for_inc_categ_meaning := get_lookup_meaning('FND',
523: 'JAKR_AP_AWT_INC_CAT_FOREIGN',
524: jgrx_wt.var.foreign_inc_categ_code);
525:
526: fa_rx_util_pkg.debug('jgrx_wt.wht_after_fetch()-');
527:
528: END wht_after_fetch;
529:
530:
578: IS
579: BEGIN
580: -- Write the basic select statement, From and Where clause
581: fa_rx_util_pkg.assign_column('1', 'hrl1.location_code', 'location_name',
582: 'jgrx_wt.var.location_name', 'VARCHAR2', 60);
583: fa_rx_util_pkg.assign_column('2', 'hrl1.address_line_1', 'location_address1',
584: 'jgrx_wt.var.location_address1', 'VARCHAR2', 240);
585: fa_rx_util_pkg.assign_column('3', 'hrl1.address_line_2', 'location_address2',
586: 'jgrx_wt.var.location_address2', 'VARCHAR2', 240);
580: -- Write the basic select statement, From and Where clause
581: fa_rx_util_pkg.assign_column('1', 'hrl1.location_code', 'location_name',
582: 'jgrx_wt.var.location_name', 'VARCHAR2', 60);
583: fa_rx_util_pkg.assign_column('2', 'hrl1.address_line_1', 'location_address1',
584: 'jgrx_wt.var.location_address1', 'VARCHAR2', 240);
585: fa_rx_util_pkg.assign_column('3', 'hrl1.address_line_2', 'location_address2',
586: 'jgrx_wt.var.location_address2', 'VARCHAR2', 240);
587: fa_rx_util_pkg.assign_column('4', 'hrl1.address_line_3', 'location_address3',
588: 'jgrx_wt.var.location_address3', 'VARCHAR2', 240);
582: 'jgrx_wt.var.location_name', 'VARCHAR2', 60);
583: fa_rx_util_pkg.assign_column('2', 'hrl1.address_line_1', 'location_address1',
584: 'jgrx_wt.var.location_address1', 'VARCHAR2', 240);
585: fa_rx_util_pkg.assign_column('3', 'hrl1.address_line_2', 'location_address2',
586: 'jgrx_wt.var.location_address2', 'VARCHAR2', 240);
587: fa_rx_util_pkg.assign_column('4', 'hrl1.address_line_3', 'location_address3',
588: 'jgrx_wt.var.location_address3', 'VARCHAR2', 240);
589: fa_rx_util_pkg.assign_column('5', 'hrl1.country', 'location_country',
590: 'jgrx_wt.var.location_country', 'VARCHAR2', 60);
584: 'jgrx_wt.var.location_address1', 'VARCHAR2', 240);
585: fa_rx_util_pkg.assign_column('3', 'hrl1.address_line_2', 'location_address2',
586: 'jgrx_wt.var.location_address2', 'VARCHAR2', 240);
587: fa_rx_util_pkg.assign_column('4', 'hrl1.address_line_3', 'location_address3',
588: 'jgrx_wt.var.location_address3', 'VARCHAR2', 240);
589: fa_rx_util_pkg.assign_column('5', 'hrl1.country', 'location_country',
590: 'jgrx_wt.var.location_country', 'VARCHAR2', 60);
591: fa_rx_util_pkg.assign_column('6', 'hrl1.postal_code', 'location_zipcode',
592: 'jgrx_wt.var.location_zipcode', 'VARCHAR2', 30);
586: 'jgrx_wt.var.location_address2', 'VARCHAR2', 240);
587: fa_rx_util_pkg.assign_column('4', 'hrl1.address_line_3', 'location_address3',
588: 'jgrx_wt.var.location_address3', 'VARCHAR2', 240);
589: fa_rx_util_pkg.assign_column('5', 'hrl1.country', 'location_country',
590: 'jgrx_wt.var.location_country', 'VARCHAR2', 60);
591: fa_rx_util_pkg.assign_column('6', 'hrl1.postal_code', 'location_zipcode',
592: 'jgrx_wt.var.location_zipcode', 'VARCHAR2', 30);
593: fa_rx_util_pkg.assign_column('7', 'hrl1.telephone_number_1', 'location_phone'
594: , 'jgrx_wt.var.location_phone', 'VARCHAR2', 30);
588: 'jgrx_wt.var.location_address3', 'VARCHAR2', 240);
589: fa_rx_util_pkg.assign_column('5', 'hrl1.country', 'location_country',
590: 'jgrx_wt.var.location_country', 'VARCHAR2', 60);
591: fa_rx_util_pkg.assign_column('6', 'hrl1.postal_code', 'location_zipcode',
592: 'jgrx_wt.var.location_zipcode', 'VARCHAR2', 30);
593: fa_rx_util_pkg.assign_column('7', 'hrl1.telephone_number_1', 'location_phone'
594: , 'jgrx_wt.var.location_phone', 'VARCHAR2', 30);
595: fa_rx_util_pkg.assign_column('8', 'xle.name', 'legal_entity_name',
596: 'jgrx_wt.var.legal_entity_name', 'VARCHAR2',60);
590: 'jgrx_wt.var.location_country', 'VARCHAR2', 60);
591: fa_rx_util_pkg.assign_column('6', 'hrl1.postal_code', 'location_zipcode',
592: 'jgrx_wt.var.location_zipcode', 'VARCHAR2', 30);
593: fa_rx_util_pkg.assign_column('7', 'hrl1.telephone_number_1', 'location_phone'
594: , 'jgrx_wt.var.location_phone', 'VARCHAR2', 30);
595: fa_rx_util_pkg.assign_column('8', 'xle.name', 'legal_entity_name',
596: 'jgrx_wt.var.legal_entity_name', 'VARCHAR2',60);
597: fa_rx_util_pkg.assign_column('9', 'xle.town_or_city', 'legal_entity_city',
598: 'jgrx_wt.var.legal_entity_city', 'VARCHAR2', 30);
592: 'jgrx_wt.var.location_zipcode', 'VARCHAR2', 30);
593: fa_rx_util_pkg.assign_column('7', 'hrl1.telephone_number_1', 'location_phone'
594: , 'jgrx_wt.var.location_phone', 'VARCHAR2', 30);
595: fa_rx_util_pkg.assign_column('8', 'xle.name', 'legal_entity_name',
596: 'jgrx_wt.var.legal_entity_name', 'VARCHAR2',60);
597: fa_rx_util_pkg.assign_column('9', 'xle.town_or_city', 'legal_entity_city',
598: 'jgrx_wt.var.legal_entity_city', 'VARCHAR2', 30);
599: fa_rx_util_pkg.assign_column('10','xle.address_line_1','legal_entity_address1',
600: 'jgrx_wt.var.legal_entity_address1', 'VARCHAR2', 240);
594: , 'jgrx_wt.var.location_phone', 'VARCHAR2', 30);
595: fa_rx_util_pkg.assign_column('8', 'xle.name', 'legal_entity_name',
596: 'jgrx_wt.var.legal_entity_name', 'VARCHAR2',60);
597: fa_rx_util_pkg.assign_column('9', 'xle.town_or_city', 'legal_entity_city',
598: 'jgrx_wt.var.legal_entity_city', 'VARCHAR2', 30);
599: fa_rx_util_pkg.assign_column('10','xle.address_line_1','legal_entity_address1',
600: 'jgrx_wt.var.legal_entity_address1', 'VARCHAR2', 240);
601: fa_rx_util_pkg.assign_column('11', 'xle.address_line_2','legal_entity_address2',
602: 'jgrx_wt.var.legal_entity_address2', 'VARCHAR2', 240);
596: 'jgrx_wt.var.legal_entity_name', 'VARCHAR2',60);
597: fa_rx_util_pkg.assign_column('9', 'xle.town_or_city', 'legal_entity_city',
598: 'jgrx_wt.var.legal_entity_city', 'VARCHAR2', 30);
599: fa_rx_util_pkg.assign_column('10','xle.address_line_1','legal_entity_address1',
600: 'jgrx_wt.var.legal_entity_address1', 'VARCHAR2', 240);
601: fa_rx_util_pkg.assign_column('11', 'xle.address_line_2','legal_entity_address2',
602: 'jgrx_wt.var.legal_entity_address2', 'VARCHAR2', 240);
603: fa_rx_util_pkg.assign_column('12', 'xle.address_line_3','legal_entity_address3',
604: 'jgrx_wt.var.legal_entity_address3', 'VARCHAR2', 240);
598: 'jgrx_wt.var.legal_entity_city', 'VARCHAR2', 30);
599: fa_rx_util_pkg.assign_column('10','xle.address_line_1','legal_entity_address1',
600: 'jgrx_wt.var.legal_entity_address1', 'VARCHAR2', 240);
601: fa_rx_util_pkg.assign_column('11', 'xle.address_line_2','legal_entity_address2',
602: 'jgrx_wt.var.legal_entity_address2', 'VARCHAR2', 240);
603: fa_rx_util_pkg.assign_column('12', 'xle.address_line_3','legal_entity_address3',
604: 'jgrx_wt.var.legal_entity_address3', 'VARCHAR2', 240);
605: fa_rx_util_pkg.assign_column('13', 'xle.country','legal_entity_country',
606: 'jgrx_wt.var.legal_entity_country', 'VARCHAR2', 60);
600: 'jgrx_wt.var.legal_entity_address1', 'VARCHAR2', 240);
601: fa_rx_util_pkg.assign_column('11', 'xle.address_line_2','legal_entity_address2',
602: 'jgrx_wt.var.legal_entity_address2', 'VARCHAR2', 240);
603: fa_rx_util_pkg.assign_column('12', 'xle.address_line_3','legal_entity_address3',
604: 'jgrx_wt.var.legal_entity_address3', 'VARCHAR2', 240);
605: fa_rx_util_pkg.assign_column('13', 'xle.country','legal_entity_country',
606: 'jgrx_wt.var.legal_entity_country', 'VARCHAR2', 60);
607: fa_rx_util_pkg.assign_column('14', 'xle.postal_code','legal_entity_zipcode',
608: 'jgrx_wt.var.legal_entity_zipcode', 'VARCHAR2', 30);
602: 'jgrx_wt.var.legal_entity_address2', 'VARCHAR2', 240);
603: fa_rx_util_pkg.assign_column('12', 'xle.address_line_3','legal_entity_address3',
604: 'jgrx_wt.var.legal_entity_address3', 'VARCHAR2', 240);
605: fa_rx_util_pkg.assign_column('13', 'xle.country','legal_entity_country',
606: 'jgrx_wt.var.legal_entity_country', 'VARCHAR2', 60);
607: fa_rx_util_pkg.assign_column('14', 'xle.postal_code','legal_entity_zipcode',
608: 'jgrx_wt.var.legal_entity_zipcode', 'VARCHAR2', 30);
609: -- Modified the below to NULL for bug 4734440
610: fa_rx_util_pkg.assign_column('15', NULL, 'legal_entity_phone',
604: 'jgrx_wt.var.legal_entity_address3', 'VARCHAR2', 240);
605: fa_rx_util_pkg.assign_column('13', 'xle.country','legal_entity_country',
606: 'jgrx_wt.var.legal_entity_country', 'VARCHAR2', 60);
607: fa_rx_util_pkg.assign_column('14', 'xle.postal_code','legal_entity_zipcode',
608: 'jgrx_wt.var.legal_entity_zipcode', 'VARCHAR2', 30);
609: -- Modified the below to NULL for bug 4734440
610: fa_rx_util_pkg.assign_column('15', NULL, 'legal_entity_phone',
611: 'jgrx_wt.var.legal_entity_phone', 'VARCHAR2', 30);
612: fa_rx_util_pkg.assign_column('16', 'hrl1.global_attribute1',
607: fa_rx_util_pkg.assign_column('14', 'xle.postal_code','legal_entity_zipcode',
608: 'jgrx_wt.var.legal_entity_zipcode', 'VARCHAR2', 30);
609: -- Modified the below to NULL for bug 4734440
610: fa_rx_util_pkg.assign_column('15', NULL, 'legal_entity_phone',
611: 'jgrx_wt.var.legal_entity_phone', 'VARCHAR2', 30);
612: fa_rx_util_pkg.assign_column('16', 'hrl1.global_attribute1',
613: 'hrl_global_attribute1', 'jgrx_wt.var.tax_registration_num', 'VARCHAR2',150);
614: fa_rx_util_pkg.assign_column('17', 'hrl1.global_attribute4',
615: 'hrl_global_attribute4', 'jgrx_wt.var.loc_taxable_person', 'VARCHAR2', 150);
609: -- Modified the below to NULL for bug 4734440
610: fa_rx_util_pkg.assign_column('15', NULL, 'legal_entity_phone',
611: 'jgrx_wt.var.legal_entity_phone', 'VARCHAR2', 30);
612: fa_rx_util_pkg.assign_column('16', 'hrl1.global_attribute1',
613: 'hrl_global_attribute1', 'jgrx_wt.var.tax_registration_num', 'VARCHAR2',150);
614: fa_rx_util_pkg.assign_column('17', 'hrl1.global_attribute4',
615: 'hrl_global_attribute4', 'jgrx_wt.var.loc_taxable_person', 'VARCHAR2', 150);
616: fa_rx_util_pkg.assign_column('18', 'pov.vendor_id', 'supplier_id',
617: 'jgrx_wt.var.supplier_id', 'NUMBER');
611: 'jgrx_wt.var.legal_entity_phone', 'VARCHAR2', 30);
612: fa_rx_util_pkg.assign_column('16', 'hrl1.global_attribute1',
613: 'hrl_global_attribute1', 'jgrx_wt.var.tax_registration_num', 'VARCHAR2',150);
614: fa_rx_util_pkg.assign_column('17', 'hrl1.global_attribute4',
615: 'hrl_global_attribute4', 'jgrx_wt.var.loc_taxable_person', 'VARCHAR2', 150);
616: fa_rx_util_pkg.assign_column('18', 'pov.vendor_id', 'supplier_id',
617: 'jgrx_wt.var.supplier_id', 'NUMBER');
618: fa_rx_util_pkg.assign_column('19', 'pov.vendor_name', 'supplier_name',
619: 'jgrx_wt.var.supplier_name', 'VARCHAR2', 240);
613: 'hrl_global_attribute1', 'jgrx_wt.var.tax_registration_num', 'VARCHAR2',150);
614: fa_rx_util_pkg.assign_column('17', 'hrl1.global_attribute4',
615: 'hrl_global_attribute4', 'jgrx_wt.var.loc_taxable_person', 'VARCHAR2', 150);
616: fa_rx_util_pkg.assign_column('18', 'pov.vendor_id', 'supplier_id',
617: 'jgrx_wt.var.supplier_id', 'NUMBER');
618: fa_rx_util_pkg.assign_column('19', 'pov.vendor_name', 'supplier_name',
619: 'jgrx_wt.var.supplier_name', 'VARCHAR2', 240);
620: fa_rx_util_pkg.assign_column('20', 'pvs.vendor_site_id', 'supplier_site_id',
621: 'jgrx_wt.var.supplier_site_id', 'NUMBER');
615: 'hrl_global_attribute4', 'jgrx_wt.var.loc_taxable_person', 'VARCHAR2', 150);
616: fa_rx_util_pkg.assign_column('18', 'pov.vendor_id', 'supplier_id',
617: 'jgrx_wt.var.supplier_id', 'NUMBER');
618: fa_rx_util_pkg.assign_column('19', 'pov.vendor_name', 'supplier_name',
619: 'jgrx_wt.var.supplier_name', 'VARCHAR2', 240);
620: fa_rx_util_pkg.assign_column('20', 'pvs.vendor_site_id', 'supplier_site_id',
621: 'jgrx_wt.var.supplier_site_id', 'NUMBER');
622: fa_rx_util_pkg.assign_column('21','pvs.vendor_site_code','supplier_site_name'
623: ,'jgrx_wt.var.supplier_site_name','VARCHAR2',100);
617: 'jgrx_wt.var.supplier_id', 'NUMBER');
618: fa_rx_util_pkg.assign_column('19', 'pov.vendor_name', 'supplier_name',
619: 'jgrx_wt.var.supplier_name', 'VARCHAR2', 240);
620: fa_rx_util_pkg.assign_column('20', 'pvs.vendor_site_id', 'supplier_site_id',
621: 'jgrx_wt.var.supplier_site_id', 'NUMBER');
622: fa_rx_util_pkg.assign_column('21','pvs.vendor_site_code','supplier_site_name'
623: ,'jgrx_wt.var.supplier_site_name','VARCHAR2',100);
624: fa_rx_util_pkg.assign_column('22', 'pov.attribute1', ' pv_attribute1',
625: 'jgrx_wt.var.pv_attribute1','VARCHAR2', 150);
619: 'jgrx_wt.var.supplier_name', 'VARCHAR2', 240);
620: fa_rx_util_pkg.assign_column('20', 'pvs.vendor_site_id', 'supplier_site_id',
621: 'jgrx_wt.var.supplier_site_id', 'NUMBER');
622: fa_rx_util_pkg.assign_column('21','pvs.vendor_site_code','supplier_site_name'
623: ,'jgrx_wt.var.supplier_site_name','VARCHAR2',100);
624: fa_rx_util_pkg.assign_column('22', 'pov.attribute1', ' pv_attribute1',
625: 'jgrx_wt.var.pv_attribute1','VARCHAR2', 150);
626: fa_rx_util_pkg.assign_column('23', 'pov.attribute2', ' pv_attribute2',
627: 'jgrx_wt.var.pv_attribute2','VARCHAR2', 150);
621: 'jgrx_wt.var.supplier_site_id', 'NUMBER');
622: fa_rx_util_pkg.assign_column('21','pvs.vendor_site_code','supplier_site_name'
623: ,'jgrx_wt.var.supplier_site_name','VARCHAR2',100);
624: fa_rx_util_pkg.assign_column('22', 'pov.attribute1', ' pv_attribute1',
625: 'jgrx_wt.var.pv_attribute1','VARCHAR2', 150);
626: fa_rx_util_pkg.assign_column('23', 'pov.attribute2', ' pv_attribute2',
627: 'jgrx_wt.var.pv_attribute2','VARCHAR2', 150);
628: fa_rx_util_pkg.assign_column('24', 'pov.attribute3', ' pv_attribute3',
629: 'jgrx_wt.var.pv_attribute3','VARCHAR2', 150);
623: ,'jgrx_wt.var.supplier_site_name','VARCHAR2',100);
624: fa_rx_util_pkg.assign_column('22', 'pov.attribute1', ' pv_attribute1',
625: 'jgrx_wt.var.pv_attribute1','VARCHAR2', 150);
626: fa_rx_util_pkg.assign_column('23', 'pov.attribute2', ' pv_attribute2',
627: 'jgrx_wt.var.pv_attribute2','VARCHAR2', 150);
628: fa_rx_util_pkg.assign_column('24', 'pov.attribute3', ' pv_attribute3',
629: 'jgrx_wt.var.pv_attribute3','VARCHAR2', 150);
630: fa_rx_util_pkg.assign_column('25', 'pov.attribute4', ' pv_attribute4',
631: 'jgrx_wt.var.pv_attribute4','VARCHAR2', 150);
625: 'jgrx_wt.var.pv_attribute1','VARCHAR2', 150);
626: fa_rx_util_pkg.assign_column('23', 'pov.attribute2', ' pv_attribute2',
627: 'jgrx_wt.var.pv_attribute2','VARCHAR2', 150);
628: fa_rx_util_pkg.assign_column('24', 'pov.attribute3', ' pv_attribute3',
629: 'jgrx_wt.var.pv_attribute3','VARCHAR2', 150);
630: fa_rx_util_pkg.assign_column('25', 'pov.attribute4', ' pv_attribute4',
631: 'jgrx_wt.var.pv_attribute4','VARCHAR2', 150);
632: fa_rx_util_pkg.assign_column('26', 'pov.attribute5', ' pv_attribute5',
633: 'jgrx_wt.var.pv_attribute5','VARCHAR2', 150);
627: 'jgrx_wt.var.pv_attribute2','VARCHAR2', 150);
628: fa_rx_util_pkg.assign_column('24', 'pov.attribute3', ' pv_attribute3',
629: 'jgrx_wt.var.pv_attribute3','VARCHAR2', 150);
630: fa_rx_util_pkg.assign_column('25', 'pov.attribute4', ' pv_attribute4',
631: 'jgrx_wt.var.pv_attribute4','VARCHAR2', 150);
632: fa_rx_util_pkg.assign_column('26', 'pov.attribute5', ' pv_attribute5',
633: 'jgrx_wt.var.pv_attribute5','VARCHAR2', 150);
634: fa_rx_util_pkg.assign_column('27', 'pov.attribute6', ' pv_attribute6',
635: 'jgrx_wt.var.pv_attribute6','VARCHAR2', 150);
629: 'jgrx_wt.var.pv_attribute3','VARCHAR2', 150);
630: fa_rx_util_pkg.assign_column('25', 'pov.attribute4', ' pv_attribute4',
631: 'jgrx_wt.var.pv_attribute4','VARCHAR2', 150);
632: fa_rx_util_pkg.assign_column('26', 'pov.attribute5', ' pv_attribute5',
633: 'jgrx_wt.var.pv_attribute5','VARCHAR2', 150);
634: fa_rx_util_pkg.assign_column('27', 'pov.attribute6', ' pv_attribute6',
635: 'jgrx_wt.var.pv_attribute6','VARCHAR2', 150);
636: fa_rx_util_pkg.assign_column('28', 'pov.attribute7', ' pv_attribute7',
637: 'jgrx_wt.var.pv_attribute7','VARCHAR2', 150);
631: 'jgrx_wt.var.pv_attribute4','VARCHAR2', 150);
632: fa_rx_util_pkg.assign_column('26', 'pov.attribute5', ' pv_attribute5',
633: 'jgrx_wt.var.pv_attribute5','VARCHAR2', 150);
634: fa_rx_util_pkg.assign_column('27', 'pov.attribute6', ' pv_attribute6',
635: 'jgrx_wt.var.pv_attribute6','VARCHAR2', 150);
636: fa_rx_util_pkg.assign_column('28', 'pov.attribute7', ' pv_attribute7',
637: 'jgrx_wt.var.pv_attribute7','VARCHAR2', 150);
638: fa_rx_util_pkg.assign_column('29', 'pov.attribute8', ' pv_attribute8',
639: 'jgrx_wt.var.pv_attribute8','VARCHAR2', 150);
633: 'jgrx_wt.var.pv_attribute5','VARCHAR2', 150);
634: fa_rx_util_pkg.assign_column('27', 'pov.attribute6', ' pv_attribute6',
635: 'jgrx_wt.var.pv_attribute6','VARCHAR2', 150);
636: fa_rx_util_pkg.assign_column('28', 'pov.attribute7', ' pv_attribute7',
637: 'jgrx_wt.var.pv_attribute7','VARCHAR2', 150);
638: fa_rx_util_pkg.assign_column('29', 'pov.attribute8', ' pv_attribute8',
639: 'jgrx_wt.var.pv_attribute8','VARCHAR2', 150);
640: fa_rx_util_pkg.assign_column('30', 'pov.attribute9', ' pv_attribute9',
641: 'jgrx_wt.var.pv_attribute9','VARCHAR2', 150);
635: 'jgrx_wt.var.pv_attribute6','VARCHAR2', 150);
636: fa_rx_util_pkg.assign_column('28', 'pov.attribute7', ' pv_attribute7',
637: 'jgrx_wt.var.pv_attribute7','VARCHAR2', 150);
638: fa_rx_util_pkg.assign_column('29', 'pov.attribute8', ' pv_attribute8',
639: 'jgrx_wt.var.pv_attribute8','VARCHAR2', 150);
640: fa_rx_util_pkg.assign_column('30', 'pov.attribute9', ' pv_attribute9',
641: 'jgrx_wt.var.pv_attribute9','VARCHAR2', 150);
642: fa_rx_util_pkg.assign_column('31', 'pov.attribute10', ' pv_attribute10',
643: 'jgrx_wt.var.pv_attribute10','VARCHAR2', 150);
637: 'jgrx_wt.var.pv_attribute7','VARCHAR2', 150);
638: fa_rx_util_pkg.assign_column('29', 'pov.attribute8', ' pv_attribute8',
639: 'jgrx_wt.var.pv_attribute8','VARCHAR2', 150);
640: fa_rx_util_pkg.assign_column('30', 'pov.attribute9', ' pv_attribute9',
641: 'jgrx_wt.var.pv_attribute9','VARCHAR2', 150);
642: fa_rx_util_pkg.assign_column('31', 'pov.attribute10', ' pv_attribute10',
643: 'jgrx_wt.var.pv_attribute10','VARCHAR2', 150);
644: fa_rx_util_pkg.assign_column('32', 'pov.attribute11', ' pv_attribute11',
645: 'jgrx_wt.var.pv_attribute11','VARCHAR2', 150);
639: 'jgrx_wt.var.pv_attribute8','VARCHAR2', 150);
640: fa_rx_util_pkg.assign_column('30', 'pov.attribute9', ' pv_attribute9',
641: 'jgrx_wt.var.pv_attribute9','VARCHAR2', 150);
642: fa_rx_util_pkg.assign_column('31', 'pov.attribute10', ' pv_attribute10',
643: 'jgrx_wt.var.pv_attribute10','VARCHAR2', 150);
644: fa_rx_util_pkg.assign_column('32', 'pov.attribute11', ' pv_attribute11',
645: 'jgrx_wt.var.pv_attribute11','VARCHAR2', 150);
646: fa_rx_util_pkg.assign_column('33', 'pov.attribute12', ' pv_attribute12',
647: 'jgrx_wt.var.pv_attribute12','VARCHAR2', 150);
641: 'jgrx_wt.var.pv_attribute9','VARCHAR2', 150);
642: fa_rx_util_pkg.assign_column('31', 'pov.attribute10', ' pv_attribute10',
643: 'jgrx_wt.var.pv_attribute10','VARCHAR2', 150);
644: fa_rx_util_pkg.assign_column('32', 'pov.attribute11', ' pv_attribute11',
645: 'jgrx_wt.var.pv_attribute11','VARCHAR2', 150);
646: fa_rx_util_pkg.assign_column('33', 'pov.attribute12', ' pv_attribute12',
647: 'jgrx_wt.var.pv_attribute12','VARCHAR2', 150);
648: fa_rx_util_pkg.assign_column('34', 'pov.attribute13', ' pv_attribute13',
649: 'jgrx_wt.var.pv_attribute13','VARCHAR2', 150);
643: 'jgrx_wt.var.pv_attribute10','VARCHAR2', 150);
644: fa_rx_util_pkg.assign_column('32', 'pov.attribute11', ' pv_attribute11',
645: 'jgrx_wt.var.pv_attribute11','VARCHAR2', 150);
646: fa_rx_util_pkg.assign_column('33', 'pov.attribute12', ' pv_attribute12',
647: 'jgrx_wt.var.pv_attribute12','VARCHAR2', 150);
648: fa_rx_util_pkg.assign_column('34', 'pov.attribute13', ' pv_attribute13',
649: 'jgrx_wt.var.pv_attribute13','VARCHAR2', 150);
650: fa_rx_util_pkg.assign_column('35', 'pov.attribute14', ' pv_attribute14',
651: 'jgrx_wt.var.pv_attribute14','VARCHAR2', 150);
645: 'jgrx_wt.var.pv_attribute11','VARCHAR2', 150);
646: fa_rx_util_pkg.assign_column('33', 'pov.attribute12', ' pv_attribute12',
647: 'jgrx_wt.var.pv_attribute12','VARCHAR2', 150);
648: fa_rx_util_pkg.assign_column('34', 'pov.attribute13', ' pv_attribute13',
649: 'jgrx_wt.var.pv_attribute13','VARCHAR2', 150);
650: fa_rx_util_pkg.assign_column('35', 'pov.attribute14', ' pv_attribute14',
651: 'jgrx_wt.var.pv_attribute14','VARCHAR2', 150);
652: fa_rx_util_pkg.assign_column('36', 'pov.attribute15', ' pv_attribute15',
653: 'jgrx_wt.var.pv_attribute15','VARCHAR2', 150);
647: 'jgrx_wt.var.pv_attribute12','VARCHAR2', 150);
648: fa_rx_util_pkg.assign_column('34', 'pov.attribute13', ' pv_attribute13',
649: 'jgrx_wt.var.pv_attribute13','VARCHAR2', 150);
650: fa_rx_util_pkg.assign_column('35', 'pov.attribute14', ' pv_attribute14',
651: 'jgrx_wt.var.pv_attribute14','VARCHAR2', 150);
652: fa_rx_util_pkg.assign_column('36', 'pov.attribute15', ' pv_attribute15',
653: 'jgrx_wt.var.pv_attribute15','VARCHAR2', 150);
654: fa_rx_util_pkg.assign_column('37', 'pvs.attribute1', ' pvs_attribute1',
655: 'jgrx_wt.var.pvs_attribute1','VARCHAR2',150);
649: 'jgrx_wt.var.pv_attribute13','VARCHAR2', 150);
650: fa_rx_util_pkg.assign_column('35', 'pov.attribute14', ' pv_attribute14',
651: 'jgrx_wt.var.pv_attribute14','VARCHAR2', 150);
652: fa_rx_util_pkg.assign_column('36', 'pov.attribute15', ' pv_attribute15',
653: 'jgrx_wt.var.pv_attribute15','VARCHAR2', 150);
654: fa_rx_util_pkg.assign_column('37', 'pvs.attribute1', ' pvs_attribute1',
655: 'jgrx_wt.var.pvs_attribute1','VARCHAR2',150);
656: fa_rx_util_pkg.assign_column('38', 'pvs.attribute2', ' pvs_attribute2',
657: 'jgrx_wt.var.pvs_attribute2','VARCHAR2',150);
651: 'jgrx_wt.var.pv_attribute14','VARCHAR2', 150);
652: fa_rx_util_pkg.assign_column('36', 'pov.attribute15', ' pv_attribute15',
653: 'jgrx_wt.var.pv_attribute15','VARCHAR2', 150);
654: fa_rx_util_pkg.assign_column('37', 'pvs.attribute1', ' pvs_attribute1',
655: 'jgrx_wt.var.pvs_attribute1','VARCHAR2',150);
656: fa_rx_util_pkg.assign_column('38', 'pvs.attribute2', ' pvs_attribute2',
657: 'jgrx_wt.var.pvs_attribute2','VARCHAR2',150);
658: fa_rx_util_pkg.assign_column('39', 'pvs.attribute3', ' pvs_attribute3',
659: 'jgrx_wt.var.pvs_attribute3','VARCHAR2',150);
653: 'jgrx_wt.var.pv_attribute15','VARCHAR2', 150);
654: fa_rx_util_pkg.assign_column('37', 'pvs.attribute1', ' pvs_attribute1',
655: 'jgrx_wt.var.pvs_attribute1','VARCHAR2',150);
656: fa_rx_util_pkg.assign_column('38', 'pvs.attribute2', ' pvs_attribute2',
657: 'jgrx_wt.var.pvs_attribute2','VARCHAR2',150);
658: fa_rx_util_pkg.assign_column('39', 'pvs.attribute3', ' pvs_attribute3',
659: 'jgrx_wt.var.pvs_attribute3','VARCHAR2',150);
660: fa_rx_util_pkg.assign_column('40', 'pvs.attribute4', ' pvs_attribute4',
661: 'jgrx_wt.var.pvs_attribute4','VARCHAR2',150);
655: 'jgrx_wt.var.pvs_attribute1','VARCHAR2',150);
656: fa_rx_util_pkg.assign_column('38', 'pvs.attribute2', ' pvs_attribute2',
657: 'jgrx_wt.var.pvs_attribute2','VARCHAR2',150);
658: fa_rx_util_pkg.assign_column('39', 'pvs.attribute3', ' pvs_attribute3',
659: 'jgrx_wt.var.pvs_attribute3','VARCHAR2',150);
660: fa_rx_util_pkg.assign_column('40', 'pvs.attribute4', ' pvs_attribute4',
661: 'jgrx_wt.var.pvs_attribute4','VARCHAR2',150);
662: fa_rx_util_pkg.assign_column('41', 'pvs.attribute5', ' pvs_attribute5',
663: 'jgrx_wt.var.pvs_attribute5','VARCHAR2',150);
657: 'jgrx_wt.var.pvs_attribute2','VARCHAR2',150);
658: fa_rx_util_pkg.assign_column('39', 'pvs.attribute3', ' pvs_attribute3',
659: 'jgrx_wt.var.pvs_attribute3','VARCHAR2',150);
660: fa_rx_util_pkg.assign_column('40', 'pvs.attribute4', ' pvs_attribute4',
661: 'jgrx_wt.var.pvs_attribute4','VARCHAR2',150);
662: fa_rx_util_pkg.assign_column('41', 'pvs.attribute5', ' pvs_attribute5',
663: 'jgrx_wt.var.pvs_attribute5','VARCHAR2',150);
664: fa_rx_util_pkg.assign_column('42', 'pvs.attribute6', ' pvs_attribute6',
665: 'jgrx_wt.var.pvs_attribute6','VARCHAR2', 150);
659: 'jgrx_wt.var.pvs_attribute3','VARCHAR2',150);
660: fa_rx_util_pkg.assign_column('40', 'pvs.attribute4', ' pvs_attribute4',
661: 'jgrx_wt.var.pvs_attribute4','VARCHAR2',150);
662: fa_rx_util_pkg.assign_column('41', 'pvs.attribute5', ' pvs_attribute5',
663: 'jgrx_wt.var.pvs_attribute5','VARCHAR2',150);
664: fa_rx_util_pkg.assign_column('42', 'pvs.attribute6', ' pvs_attribute6',
665: 'jgrx_wt.var.pvs_attribute6','VARCHAR2', 150);
666: fa_rx_util_pkg.assign_column('43', 'pvs.attribute7', ' pvs_attribute7',
667: 'jgrx_wt.var.pvs_attribute7','VARCHAR2', 150);
661: 'jgrx_wt.var.pvs_attribute4','VARCHAR2',150);
662: fa_rx_util_pkg.assign_column('41', 'pvs.attribute5', ' pvs_attribute5',
663: 'jgrx_wt.var.pvs_attribute5','VARCHAR2',150);
664: fa_rx_util_pkg.assign_column('42', 'pvs.attribute6', ' pvs_attribute6',
665: 'jgrx_wt.var.pvs_attribute6','VARCHAR2', 150);
666: fa_rx_util_pkg.assign_column('43', 'pvs.attribute7', ' pvs_attribute7',
667: 'jgrx_wt.var.pvs_attribute7','VARCHAR2', 150);
668: fa_rx_util_pkg.assign_column('44', 'pvs.attribute8', ' pvs_attribute8',
669: 'jgrx_wt.var.pvs_attribute8','VARCHAR2', 150);
663: 'jgrx_wt.var.pvs_attribute5','VARCHAR2',150);
664: fa_rx_util_pkg.assign_column('42', 'pvs.attribute6', ' pvs_attribute6',
665: 'jgrx_wt.var.pvs_attribute6','VARCHAR2', 150);
666: fa_rx_util_pkg.assign_column('43', 'pvs.attribute7', ' pvs_attribute7',
667: 'jgrx_wt.var.pvs_attribute7','VARCHAR2', 150);
668: fa_rx_util_pkg.assign_column('44', 'pvs.attribute8', ' pvs_attribute8',
669: 'jgrx_wt.var.pvs_attribute8','VARCHAR2', 150);
670: fa_rx_util_pkg.assign_column('45', 'pvs.attribute9', ' pvs_attribute9',
671: 'jgrx_wt.var.pvs_attribute9','VARCHAR2', 150);
665: 'jgrx_wt.var.pvs_attribute6','VARCHAR2', 150);
666: fa_rx_util_pkg.assign_column('43', 'pvs.attribute7', ' pvs_attribute7',
667: 'jgrx_wt.var.pvs_attribute7','VARCHAR2', 150);
668: fa_rx_util_pkg.assign_column('44', 'pvs.attribute8', ' pvs_attribute8',
669: 'jgrx_wt.var.pvs_attribute8','VARCHAR2', 150);
670: fa_rx_util_pkg.assign_column('45', 'pvs.attribute9', ' pvs_attribute9',
671: 'jgrx_wt.var.pvs_attribute9','VARCHAR2', 150);
672: fa_rx_util_pkg.assign_column('46', 'pvs.attribute10', ' pvs_attribute10',
673: 'jgrx_wt.var.pvs_attribute10','VARCHAR2', 150);
667: 'jgrx_wt.var.pvs_attribute7','VARCHAR2', 150);
668: fa_rx_util_pkg.assign_column('44', 'pvs.attribute8', ' pvs_attribute8',
669: 'jgrx_wt.var.pvs_attribute8','VARCHAR2', 150);
670: fa_rx_util_pkg.assign_column('45', 'pvs.attribute9', ' pvs_attribute9',
671: 'jgrx_wt.var.pvs_attribute9','VARCHAR2', 150);
672: fa_rx_util_pkg.assign_column('46', 'pvs.attribute10', ' pvs_attribute10',
673: 'jgrx_wt.var.pvs_attribute10','VARCHAR2', 150);
674: fa_rx_util_pkg.assign_column('47', 'pvs.attribute11', ' pvs_attribute11',
675: 'jgrx_wt.var.pvs_attribute11','VARCHAR2', 150);
669: 'jgrx_wt.var.pvs_attribute8','VARCHAR2', 150);
670: fa_rx_util_pkg.assign_column('45', 'pvs.attribute9', ' pvs_attribute9',
671: 'jgrx_wt.var.pvs_attribute9','VARCHAR2', 150);
672: fa_rx_util_pkg.assign_column('46', 'pvs.attribute10', ' pvs_attribute10',
673: 'jgrx_wt.var.pvs_attribute10','VARCHAR2', 150);
674: fa_rx_util_pkg.assign_column('47', 'pvs.attribute11', ' pvs_attribute11',
675: 'jgrx_wt.var.pvs_attribute11','VARCHAR2', 150);
676: fa_rx_util_pkg.assign_column('48', 'pvs.attribute12', ' pvs_attribute12',
677: 'jgrx_wt.var.pvs_attribute12','VARCHAR2', 150);
671: 'jgrx_wt.var.pvs_attribute9','VARCHAR2', 150);
672: fa_rx_util_pkg.assign_column('46', 'pvs.attribute10', ' pvs_attribute10',
673: 'jgrx_wt.var.pvs_attribute10','VARCHAR2', 150);
674: fa_rx_util_pkg.assign_column('47', 'pvs.attribute11', ' pvs_attribute11',
675: 'jgrx_wt.var.pvs_attribute11','VARCHAR2', 150);
676: fa_rx_util_pkg.assign_column('48', 'pvs.attribute12', ' pvs_attribute12',
677: 'jgrx_wt.var.pvs_attribute12','VARCHAR2', 150);
678: fa_rx_util_pkg.assign_column('49', 'pvs.attribute13', ' pvs_attribute13',
679: 'jgrx_wt.var.pvs_attribute13','VARCHAR2', 150);
673: 'jgrx_wt.var.pvs_attribute10','VARCHAR2', 150);
674: fa_rx_util_pkg.assign_column('47', 'pvs.attribute11', ' pvs_attribute11',
675: 'jgrx_wt.var.pvs_attribute11','VARCHAR2', 150);
676: fa_rx_util_pkg.assign_column('48', 'pvs.attribute12', ' pvs_attribute12',
677: 'jgrx_wt.var.pvs_attribute12','VARCHAR2', 150);
678: fa_rx_util_pkg.assign_column('49', 'pvs.attribute13', ' pvs_attribute13',
679: 'jgrx_wt.var.pvs_attribute13','VARCHAR2', 150);
680: fa_rx_util_pkg.assign_column('50', 'pvs.attribute14', ' pvs_attribute14',
681: 'jgrx_wt.var.pvs_attribute14','VARCHAR2', 150);
675: 'jgrx_wt.var.pvs_attribute11','VARCHAR2', 150);
676: fa_rx_util_pkg.assign_column('48', 'pvs.attribute12', ' pvs_attribute12',
677: 'jgrx_wt.var.pvs_attribute12','VARCHAR2', 150);
678: fa_rx_util_pkg.assign_column('49', 'pvs.attribute13', ' pvs_attribute13',
679: 'jgrx_wt.var.pvs_attribute13','VARCHAR2', 150);
680: fa_rx_util_pkg.assign_column('50', 'pvs.attribute14', ' pvs_attribute14',
681: 'jgrx_wt.var.pvs_attribute14','VARCHAR2', 150);
682: fa_rx_util_pkg.assign_column('51', 'pvs.attribute15', ' pvs_attribute15',
683: 'jgrx_wt.var.pvs_attribute15','VARCHAR2', 150);
677: 'jgrx_wt.var.pvs_attribute12','VARCHAR2', 150);
678: fa_rx_util_pkg.assign_column('49', 'pvs.attribute13', ' pvs_attribute13',
679: 'jgrx_wt.var.pvs_attribute13','VARCHAR2', 150);
680: fa_rx_util_pkg.assign_column('50', 'pvs.attribute14', ' pvs_attribute14',
681: 'jgrx_wt.var.pvs_attribute14','VARCHAR2', 150);
682: fa_rx_util_pkg.assign_column('51', 'pvs.attribute15', ' pvs_attribute15',
683: 'jgrx_wt.var.pvs_attribute15','VARCHAR2', 150);
684: fa_rx_util_pkg.assign_column('52','ap_inv.attribute1', ' inv_attribute1',
685: 'jgrx_wt.var.inv_attribute1','VARCHAR2', 150);
679: 'jgrx_wt.var.pvs_attribute13','VARCHAR2', 150);
680: fa_rx_util_pkg.assign_column('50', 'pvs.attribute14', ' pvs_attribute14',
681: 'jgrx_wt.var.pvs_attribute14','VARCHAR2', 150);
682: fa_rx_util_pkg.assign_column('51', 'pvs.attribute15', ' pvs_attribute15',
683: 'jgrx_wt.var.pvs_attribute15','VARCHAR2', 150);
684: fa_rx_util_pkg.assign_column('52','ap_inv.attribute1', ' inv_attribute1',
685: 'jgrx_wt.var.inv_attribute1','VARCHAR2', 150);
686: fa_rx_util_pkg.assign_column('53', 'ap_inv.attribute2', ' inv_attribute2',
687: 'jgrx_wt.var.inv_attribute2','VARCHAR2', 150);
681: 'jgrx_wt.var.pvs_attribute14','VARCHAR2', 150);
682: fa_rx_util_pkg.assign_column('51', 'pvs.attribute15', ' pvs_attribute15',
683: 'jgrx_wt.var.pvs_attribute15','VARCHAR2', 150);
684: fa_rx_util_pkg.assign_column('52','ap_inv.attribute1', ' inv_attribute1',
685: 'jgrx_wt.var.inv_attribute1','VARCHAR2', 150);
686: fa_rx_util_pkg.assign_column('53', 'ap_inv.attribute2', ' inv_attribute2',
687: 'jgrx_wt.var.inv_attribute2','VARCHAR2', 150);
688: fa_rx_util_pkg.assign_column('54', 'ap_inv.attribute3', ' inv_attribute3',
689: 'jgrx_wt.var.inv_attribute3','VARCHAR2', 150);
683: 'jgrx_wt.var.pvs_attribute15','VARCHAR2', 150);
684: fa_rx_util_pkg.assign_column('52','ap_inv.attribute1', ' inv_attribute1',
685: 'jgrx_wt.var.inv_attribute1','VARCHAR2', 150);
686: fa_rx_util_pkg.assign_column('53', 'ap_inv.attribute2', ' inv_attribute2',
687: 'jgrx_wt.var.inv_attribute2','VARCHAR2', 150);
688: fa_rx_util_pkg.assign_column('54', 'ap_inv.attribute3', ' inv_attribute3',
689: 'jgrx_wt.var.inv_attribute3','VARCHAR2', 150);
690: fa_rx_util_pkg.assign_column('55', 'ap_inv.attribute4', ' inv_attribute4',
691: 'jgrx_wt.var.inv_attribute4','VARCHAR2', 150);
685: 'jgrx_wt.var.inv_attribute1','VARCHAR2', 150);
686: fa_rx_util_pkg.assign_column('53', 'ap_inv.attribute2', ' inv_attribute2',
687: 'jgrx_wt.var.inv_attribute2','VARCHAR2', 150);
688: fa_rx_util_pkg.assign_column('54', 'ap_inv.attribute3', ' inv_attribute3',
689: 'jgrx_wt.var.inv_attribute3','VARCHAR2', 150);
690: fa_rx_util_pkg.assign_column('55', 'ap_inv.attribute4', ' inv_attribute4',
691: 'jgrx_wt.var.inv_attribute4','VARCHAR2', 150);
692: fa_rx_util_pkg.assign_column('56', 'ap_inv.attribute5', ' inv_attribute5',
693: 'jgrx_wt.var.inv_attribute5','VARCHAR2', 150);
687: 'jgrx_wt.var.inv_attribute2','VARCHAR2', 150);
688: fa_rx_util_pkg.assign_column('54', 'ap_inv.attribute3', ' inv_attribute3',
689: 'jgrx_wt.var.inv_attribute3','VARCHAR2', 150);
690: fa_rx_util_pkg.assign_column('55', 'ap_inv.attribute4', ' inv_attribute4',
691: 'jgrx_wt.var.inv_attribute4','VARCHAR2', 150);
692: fa_rx_util_pkg.assign_column('56', 'ap_inv.attribute5', ' inv_attribute5',
693: 'jgrx_wt.var.inv_attribute5','VARCHAR2', 150);
694: fa_rx_util_pkg.assign_column('57', 'ap_inv.attribute6', ' inv_attribute6',
695: 'jgrx_wt.var.inv_attribute6','VARCHAR2', 150);
689: 'jgrx_wt.var.inv_attribute3','VARCHAR2', 150);
690: fa_rx_util_pkg.assign_column('55', 'ap_inv.attribute4', ' inv_attribute4',
691: 'jgrx_wt.var.inv_attribute4','VARCHAR2', 150);
692: fa_rx_util_pkg.assign_column('56', 'ap_inv.attribute5', ' inv_attribute5',
693: 'jgrx_wt.var.inv_attribute5','VARCHAR2', 150);
694: fa_rx_util_pkg.assign_column('57', 'ap_inv.attribute6', ' inv_attribute6',
695: 'jgrx_wt.var.inv_attribute6','VARCHAR2', 150);
696: fa_rx_util_pkg.assign_column('58', 'ap_inv.attribute7', ' inv_attribute7',
697: 'jgrx_wt.var.inv_attribute7','VARCHAR2', 150);
691: 'jgrx_wt.var.inv_attribute4','VARCHAR2', 150);
692: fa_rx_util_pkg.assign_column('56', 'ap_inv.attribute5', ' inv_attribute5',
693: 'jgrx_wt.var.inv_attribute5','VARCHAR2', 150);
694: fa_rx_util_pkg.assign_column('57', 'ap_inv.attribute6', ' inv_attribute6',
695: 'jgrx_wt.var.inv_attribute6','VARCHAR2', 150);
696: fa_rx_util_pkg.assign_column('58', 'ap_inv.attribute7', ' inv_attribute7',
697: 'jgrx_wt.var.inv_attribute7','VARCHAR2', 150);
698: fa_rx_util_pkg.assign_column('59', 'ap_inv.attribute8', ' inv_attribute8',
699: 'jgrx_wt.var.inv_attribute8','VARCHAR2', 150);
693: 'jgrx_wt.var.inv_attribute5','VARCHAR2', 150);
694: fa_rx_util_pkg.assign_column('57', 'ap_inv.attribute6', ' inv_attribute6',
695: 'jgrx_wt.var.inv_attribute6','VARCHAR2', 150);
696: fa_rx_util_pkg.assign_column('58', 'ap_inv.attribute7', ' inv_attribute7',
697: 'jgrx_wt.var.inv_attribute7','VARCHAR2', 150);
698: fa_rx_util_pkg.assign_column('59', 'ap_inv.attribute8', ' inv_attribute8',
699: 'jgrx_wt.var.inv_attribute8','VARCHAR2', 150);
700: fa_rx_util_pkg.assign_column('60', 'ap_inv.attribute9', ' inv_attribute9',
701: 'jgrx_wt.var.inv_attribute9','VARCHAR2', 150);
695: 'jgrx_wt.var.inv_attribute6','VARCHAR2', 150);
696: fa_rx_util_pkg.assign_column('58', 'ap_inv.attribute7', ' inv_attribute7',
697: 'jgrx_wt.var.inv_attribute7','VARCHAR2', 150);
698: fa_rx_util_pkg.assign_column('59', 'ap_inv.attribute8', ' inv_attribute8',
699: 'jgrx_wt.var.inv_attribute8','VARCHAR2', 150);
700: fa_rx_util_pkg.assign_column('60', 'ap_inv.attribute9', ' inv_attribute9',
701: 'jgrx_wt.var.inv_attribute9','VARCHAR2', 150);
702: fa_rx_util_pkg.assign_column('61', 'ap_inv.attribute10', ' inv_attribute10',
703: 'jgrx_wt.var.inv_attribute10','VARCHAR2', 150);
697: 'jgrx_wt.var.inv_attribute7','VARCHAR2', 150);
698: fa_rx_util_pkg.assign_column('59', 'ap_inv.attribute8', ' inv_attribute8',
699: 'jgrx_wt.var.inv_attribute8','VARCHAR2', 150);
700: fa_rx_util_pkg.assign_column('60', 'ap_inv.attribute9', ' inv_attribute9',
701: 'jgrx_wt.var.inv_attribute9','VARCHAR2', 150);
702: fa_rx_util_pkg.assign_column('61', 'ap_inv.attribute10', ' inv_attribute10',
703: 'jgrx_wt.var.inv_attribute10','VARCHAR2', 150);
704: fa_rx_util_pkg.assign_column('62', 'ap_inv.attribute11', ' inv_attribute11',
705: 'jgrx_wt.var.inv_attribute11','VARCHAR2', 150);
699: 'jgrx_wt.var.inv_attribute8','VARCHAR2', 150);
700: fa_rx_util_pkg.assign_column('60', 'ap_inv.attribute9', ' inv_attribute9',
701: 'jgrx_wt.var.inv_attribute9','VARCHAR2', 150);
702: fa_rx_util_pkg.assign_column('61', 'ap_inv.attribute10', ' inv_attribute10',
703: 'jgrx_wt.var.inv_attribute10','VARCHAR2', 150);
704: fa_rx_util_pkg.assign_column('62', 'ap_inv.attribute11', ' inv_attribute11',
705: 'jgrx_wt.var.inv_attribute11','VARCHAR2', 150);
706: fa_rx_util_pkg.assign_column('63', 'ap_inv.attribute12', ' inv_attribute12',
707: 'jgrx_wt.var.inv_attribute12','VARCHAR2', 150);
701: 'jgrx_wt.var.inv_attribute9','VARCHAR2', 150);
702: fa_rx_util_pkg.assign_column('61', 'ap_inv.attribute10', ' inv_attribute10',
703: 'jgrx_wt.var.inv_attribute10','VARCHAR2', 150);
704: fa_rx_util_pkg.assign_column('62', 'ap_inv.attribute11', ' inv_attribute11',
705: 'jgrx_wt.var.inv_attribute11','VARCHAR2', 150);
706: fa_rx_util_pkg.assign_column('63', 'ap_inv.attribute12', ' inv_attribute12',
707: 'jgrx_wt.var.inv_attribute12','VARCHAR2', 150);
708: fa_rx_util_pkg.assign_column('64', 'ap_inv.attribute13', ' inv_attribute13',
709: 'jgrx_wt.var.inv_attribute13','VARCHAR2', 150);
703: 'jgrx_wt.var.inv_attribute10','VARCHAR2', 150);
704: fa_rx_util_pkg.assign_column('62', 'ap_inv.attribute11', ' inv_attribute11',
705: 'jgrx_wt.var.inv_attribute11','VARCHAR2', 150);
706: fa_rx_util_pkg.assign_column('63', 'ap_inv.attribute12', ' inv_attribute12',
707: 'jgrx_wt.var.inv_attribute12','VARCHAR2', 150);
708: fa_rx_util_pkg.assign_column('64', 'ap_inv.attribute13', ' inv_attribute13',
709: 'jgrx_wt.var.inv_attribute13','VARCHAR2', 150);
710: fa_rx_util_pkg.assign_column('65', 'ap_inv.attribute14', ' inv_attribute14',
711: 'jgrx_wt.var.inv_attribute14','VARCHAR2', 150);
705: 'jgrx_wt.var.inv_attribute11','VARCHAR2', 150);
706: fa_rx_util_pkg.assign_column('63', 'ap_inv.attribute12', ' inv_attribute12',
707: 'jgrx_wt.var.inv_attribute12','VARCHAR2', 150);
708: fa_rx_util_pkg.assign_column('64', 'ap_inv.attribute13', ' inv_attribute13',
709: 'jgrx_wt.var.inv_attribute13','VARCHAR2', 150);
710: fa_rx_util_pkg.assign_column('65', 'ap_inv.attribute14', ' inv_attribute14',
711: 'jgrx_wt.var.inv_attribute14','VARCHAR2', 150);
712: fa_rx_util_pkg.assign_column('66', 'ap_inv.attribute15', ' inv_attribute15',
713: 'jgrx_wt.var.inv_attribute15','VARCHAR2', 150);
707: 'jgrx_wt.var.inv_attribute12','VARCHAR2', 150);
708: fa_rx_util_pkg.assign_column('64', 'ap_inv.attribute13', ' inv_attribute13',
709: 'jgrx_wt.var.inv_attribute13','VARCHAR2', 150);
710: fa_rx_util_pkg.assign_column('65', 'ap_inv.attribute14', ' inv_attribute14',
711: 'jgrx_wt.var.inv_attribute14','VARCHAR2', 150);
712: fa_rx_util_pkg.assign_column('66', 'ap_inv.attribute15', ' inv_attribute15',
713: 'jgrx_wt.var.inv_attribute15','VARCHAR2', 150);
714: fa_rx_util_pkg.assign_column('67', 'pvs.country', 'supplier_country',
715: 'jgrx_wt.var.supplier_country','VARCHAR2', 25);
709: 'jgrx_wt.var.inv_attribute13','VARCHAR2', 150);
710: fa_rx_util_pkg.assign_column('65', 'ap_inv.attribute14', ' inv_attribute14',
711: 'jgrx_wt.var.inv_attribute14','VARCHAR2', 150);
712: fa_rx_util_pkg.assign_column('66', 'ap_inv.attribute15', ' inv_attribute15',
713: 'jgrx_wt.var.inv_attribute15','VARCHAR2', 150);
714: fa_rx_util_pkg.assign_column('67', 'pvs.country', 'supplier_country',
715: 'jgrx_wt.var.supplier_country','VARCHAR2', 25);
716: fa_rx_util_pkg.assign_column('68', 'pvs.address_line1',
717: 'supplier_address_line1','jgrx_wt.var.supplier_address_line1','VARCHAR2',240);
711: 'jgrx_wt.var.inv_attribute14','VARCHAR2', 150);
712: fa_rx_util_pkg.assign_column('66', 'ap_inv.attribute15', ' inv_attribute15',
713: 'jgrx_wt.var.inv_attribute15','VARCHAR2', 150);
714: fa_rx_util_pkg.assign_column('67', 'pvs.country', 'supplier_country',
715: 'jgrx_wt.var.supplier_country','VARCHAR2', 25);
716: fa_rx_util_pkg.assign_column('68', 'pvs.address_line1',
717: 'supplier_address_line1','jgrx_wt.var.supplier_address_line1','VARCHAR2',240);
718: fa_rx_util_pkg.assign_column('69', 'pvs.address_line2',
719: 'supplier_address_line2','jgrx_wt.var.supplier_address_line2','VARCHAR2',240);
713: 'jgrx_wt.var.inv_attribute15','VARCHAR2', 150);
714: fa_rx_util_pkg.assign_column('67', 'pvs.country', 'supplier_country',
715: 'jgrx_wt.var.supplier_country','VARCHAR2', 25);
716: fa_rx_util_pkg.assign_column('68', 'pvs.address_line1',
717: 'supplier_address_line1','jgrx_wt.var.supplier_address_line1','VARCHAR2',240);
718: fa_rx_util_pkg.assign_column('69', 'pvs.address_line2',
719: 'supplier_address_line2','jgrx_wt.var.supplier_address_line2','VARCHAR2',240);
720: fa_rx_util_pkg.assign_column('70', 'pvs.address_line3',
721: 'supplier_address_line3','jgrx_wt.var.supplier_address_line3','VARCHAR2',240);
715: 'jgrx_wt.var.supplier_country','VARCHAR2', 25);
716: fa_rx_util_pkg.assign_column('68', 'pvs.address_line1',
717: 'supplier_address_line1','jgrx_wt.var.supplier_address_line1','VARCHAR2',240);
718: fa_rx_util_pkg.assign_column('69', 'pvs.address_line2',
719: 'supplier_address_line2','jgrx_wt.var.supplier_address_line2','VARCHAR2',240);
720: fa_rx_util_pkg.assign_column('70', 'pvs.address_line3',
721: 'supplier_address_line3','jgrx_wt.var.supplier_address_line3','VARCHAR2',240);
722: fa_rx_util_pkg.assign_column('71', 'pvs.city', 'supplier_city',
723: 'jgrx_wt.var.supplier_city','VARCHAR2', 25);
717: 'supplier_address_line1','jgrx_wt.var.supplier_address_line1','VARCHAR2',240);
718: fa_rx_util_pkg.assign_column('69', 'pvs.address_line2',
719: 'supplier_address_line2','jgrx_wt.var.supplier_address_line2','VARCHAR2',240);
720: fa_rx_util_pkg.assign_column('70', 'pvs.address_line3',
721: 'supplier_address_line3','jgrx_wt.var.supplier_address_line3','VARCHAR2',240);
722: fa_rx_util_pkg.assign_column('71', 'pvs.city', 'supplier_city',
723: 'jgrx_wt.var.supplier_city','VARCHAR2', 25);
724: fa_rx_util_pkg.assign_column('72', 'pvs.zip', 'supplier_postal_code',
725: 'jgrx_wt.var.supplier_postal_code','VARCHAR2', 20);
719: 'supplier_address_line2','jgrx_wt.var.supplier_address_line2','VARCHAR2',240);
720: fa_rx_util_pkg.assign_column('70', 'pvs.address_line3',
721: 'supplier_address_line3','jgrx_wt.var.supplier_address_line3','VARCHAR2',240);
722: fa_rx_util_pkg.assign_column('71', 'pvs.city', 'supplier_city',
723: 'jgrx_wt.var.supplier_city','VARCHAR2', 25);
724: fa_rx_util_pkg.assign_column('72', 'pvs.zip', 'supplier_postal_code',
725: 'jgrx_wt.var.supplier_postal_code','VARCHAR2', 20);
726: fa_rx_util_pkg.assign_column('73', 'pvs.province', 'supplier_province',
727: 'jgrx_wt.var.supplier_province','VARCHAR2', 150);
721: 'supplier_address_line3','jgrx_wt.var.supplier_address_line3','VARCHAR2',240);
722: fa_rx_util_pkg.assign_column('71', 'pvs.city', 'supplier_city',
723: 'jgrx_wt.var.supplier_city','VARCHAR2', 25);
724: fa_rx_util_pkg.assign_column('72', 'pvs.zip', 'supplier_postal_code',
725: 'jgrx_wt.var.supplier_postal_code','VARCHAR2', 20);
726: fa_rx_util_pkg.assign_column('73', 'pvs.province', 'supplier_province',
727: 'jgrx_wt.var.supplier_province','VARCHAR2', 150);
728: fa_rx_util_pkg.assign_column('74', 'pvs.county', 'supplier_county',
729: 'jgrx_wt.var.supplier_county','VARCHAR2', 150);
723: 'jgrx_wt.var.supplier_city','VARCHAR2', 25);
724: fa_rx_util_pkg.assign_column('72', 'pvs.zip', 'supplier_postal_code',
725: 'jgrx_wt.var.supplier_postal_code','VARCHAR2', 20);
726: fa_rx_util_pkg.assign_column('73', 'pvs.province', 'supplier_province',
727: 'jgrx_wt.var.supplier_province','VARCHAR2', 150);
728: fa_rx_util_pkg.assign_column('74', 'pvs.county', 'supplier_county',
729: 'jgrx_wt.var.supplier_county','VARCHAR2', 150);
730: fa_rx_util_pkg.assign_column('75', 'pvs.global_attribute1',
731: 'pvs_global_attribute1','jgrx_wt.var.supplier_taxable_person','VARCHAR2',150);
725: 'jgrx_wt.var.supplier_postal_code','VARCHAR2', 20);
726: fa_rx_util_pkg.assign_column('73', 'pvs.province', 'supplier_province',
727: 'jgrx_wt.var.supplier_province','VARCHAR2', 150);
728: fa_rx_util_pkg.assign_column('74', 'pvs.county', 'supplier_county',
729: 'jgrx_wt.var.supplier_county','VARCHAR2', 150);
730: fa_rx_util_pkg.assign_column('75', 'pvs.global_attribute1',
731: 'pvs_global_attribute1','jgrx_wt.var.supplier_taxable_person','VARCHAR2',150);
732: fa_rx_util_pkg.assign_column('76', 'nvl(pvs.vat_registration_num,
733: pov.vat_registration_num)', 'supplier_tax_registration_num',
727: 'jgrx_wt.var.supplier_province','VARCHAR2', 150);
728: fa_rx_util_pkg.assign_column('74', 'pvs.county', 'supplier_county',
729: 'jgrx_wt.var.supplier_county','VARCHAR2', 150);
730: fa_rx_util_pkg.assign_column('75', 'pvs.global_attribute1',
731: 'pvs_global_attribute1','jgrx_wt.var.supplier_taxable_person','VARCHAR2',150);
732: fa_rx_util_pkg.assign_column('76', 'nvl(pvs.vat_registration_num,
733: pov.vat_registration_num)', 'supplier_tax_registration_num',
734: 'jgrx_wt.var.supplier_tax_registration_num','VARCHAR2', 20);
735: fa_rx_util_pkg.assign_column('77','pov.num_1099', 'supplier_taxpayer_id',
730: fa_rx_util_pkg.assign_column('75', 'pvs.global_attribute1',
731: 'pvs_global_attribute1','jgrx_wt.var.supplier_taxable_person','VARCHAR2',150);
732: fa_rx_util_pkg.assign_column('76', 'nvl(pvs.vat_registration_num,
733: pov.vat_registration_num)', 'supplier_tax_registration_num',
734: 'jgrx_wt.var.supplier_tax_registration_num','VARCHAR2', 20);
735: fa_rx_util_pkg.assign_column('77','pov.num_1099', 'supplier_taxpayer_id',
736: 'jgrx_wt.var.supplier_taxpayer_id','VARCHAR2', 30);
737: fa_rx_util_pkg.assign_column('78','pvs.global_attribute2',
738: 'pvs_global_attribute2','jgrx_wt.var.business_inc_sub_category','VARCHAR2',150);
732: fa_rx_util_pkg.assign_column('76', 'nvl(pvs.vat_registration_num,
733: pov.vat_registration_num)', 'supplier_tax_registration_num',
734: 'jgrx_wt.var.supplier_tax_registration_num','VARCHAR2', 20);
735: fa_rx_util_pkg.assign_column('77','pov.num_1099', 'supplier_taxpayer_id',
736: 'jgrx_wt.var.supplier_taxpayer_id','VARCHAR2', 30);
737: fa_rx_util_pkg.assign_column('78','pvs.global_attribute2',
738: 'pvs_global_attribute2','jgrx_wt.var.business_inc_sub_category','VARCHAR2',150);
739: fa_rx_util_pkg.assign_column('79', NULL, 'biz_inc_sub_categ_meaning',
740: 'jgrx_wt.var.biz_inc_sub_categ_meaning','VARCHAR2', 80);
734: 'jgrx_wt.var.supplier_tax_registration_num','VARCHAR2', 20);
735: fa_rx_util_pkg.assign_column('77','pov.num_1099', 'supplier_taxpayer_id',
736: 'jgrx_wt.var.supplier_taxpayer_id','VARCHAR2', 30);
737: fa_rx_util_pkg.assign_column('78','pvs.global_attribute2',
738: 'pvs_global_attribute2','jgrx_wt.var.business_inc_sub_category','VARCHAR2',150);
739: fa_rx_util_pkg.assign_column('79', NULL, 'biz_inc_sub_categ_meaning',
740: 'jgrx_wt.var.biz_inc_sub_categ_meaning','VARCHAR2', 80);
741: fa_rx_util_pkg.assign_column('80', 'ind.dist_code_combination_id',
742: 'dist_code_combination_id','jgrx_wt.var.dist_code_combination_id', 'NUMBER',15);
736: 'jgrx_wt.var.supplier_taxpayer_id','VARCHAR2', 30);
737: fa_rx_util_pkg.assign_column('78','pvs.global_attribute2',
738: 'pvs_global_attribute2','jgrx_wt.var.business_inc_sub_category','VARCHAR2',150);
739: fa_rx_util_pkg.assign_column('79', NULL, 'biz_inc_sub_categ_meaning',
740: 'jgrx_wt.var.biz_inc_sub_categ_meaning','VARCHAR2', 80);
741: fa_rx_util_pkg.assign_column('80', 'ind.dist_code_combination_id',
742: 'dist_code_combination_id','jgrx_wt.var.dist_code_combination_id', 'NUMBER',15);
743: fa_rx_util_pkg.assign_column('81', 'ap_inv.invoice_num', 'transaction_number',
744: 'jgrx_wt.var.transaction_number','VARCHAR2', 50);
738: 'pvs_global_attribute2','jgrx_wt.var.business_inc_sub_category','VARCHAR2',150);
739: fa_rx_util_pkg.assign_column('79', NULL, 'biz_inc_sub_categ_meaning',
740: 'jgrx_wt.var.biz_inc_sub_categ_meaning','VARCHAR2', 80);
741: fa_rx_util_pkg.assign_column('80', 'ind.dist_code_combination_id',
742: 'dist_code_combination_id','jgrx_wt.var.dist_code_combination_id', 'NUMBER',15);
743: fa_rx_util_pkg.assign_column('81', 'ap_inv.invoice_num', 'transaction_number',
744: 'jgrx_wt.var.transaction_number','VARCHAR2', 50);
745: fa_rx_util_pkg.assign_column('82', 'ind.accounting_date', 'accounting_date',
746: 'jgrx_wt.var.accounting_date','DATE');
740: 'jgrx_wt.var.biz_inc_sub_categ_meaning','VARCHAR2', 80);
741: fa_rx_util_pkg.assign_column('80', 'ind.dist_code_combination_id',
742: 'dist_code_combination_id','jgrx_wt.var.dist_code_combination_id', 'NUMBER',15);
743: fa_rx_util_pkg.assign_column('81', 'ap_inv.invoice_num', 'transaction_number',
744: 'jgrx_wt.var.transaction_number','VARCHAR2', 50);
745: fa_rx_util_pkg.assign_column('82', 'ind.accounting_date', 'accounting_date',
746: 'jgrx_wt.var.accounting_date','DATE');
747: fa_rx_util_pkg.assign_column('83', 'ap_inv.voucher_num', 'document_number',
748: 'jgrx_wt.var.document_number','VARCHAR2', 50);
742: 'dist_code_combination_id','jgrx_wt.var.dist_code_combination_id', 'NUMBER',15);
743: fa_rx_util_pkg.assign_column('81', 'ap_inv.invoice_num', 'transaction_number',
744: 'jgrx_wt.var.transaction_number','VARCHAR2', 50);
745: fa_rx_util_pkg.assign_column('82', 'ind.accounting_date', 'accounting_date',
746: 'jgrx_wt.var.accounting_date','DATE');
747: fa_rx_util_pkg.assign_column('83', 'ap_inv.voucher_num', 'document_number',
748: 'jgrx_wt.var.document_number','VARCHAR2', 50);
749: fa_rx_util_pkg.assign_column('84', 'pov.organization_type_lookup_code',
750: 'organization_type', 'jgrx_wt.var.organization_type','VARCHAR2', 25);
744: 'jgrx_wt.var.transaction_number','VARCHAR2', 50);
745: fa_rx_util_pkg.assign_column('82', 'ind.accounting_date', 'accounting_date',
746: 'jgrx_wt.var.accounting_date','DATE');
747: fa_rx_util_pkg.assign_column('83', 'ap_inv.voucher_num', 'document_number',
748: 'jgrx_wt.var.document_number','VARCHAR2', 50);
749: fa_rx_util_pkg.assign_column('84', 'pov.organization_type_lookup_code',
750: 'organization_type', 'jgrx_wt.var.organization_type','VARCHAR2', 25);
751: fa_rx_util_pkg.assign_column('85', NULL, 'org_type_meaning',
752: 'jgrx_wt.var.org_type_meaning','VARCHAR2', 80);
746: 'jgrx_wt.var.accounting_date','DATE');
747: fa_rx_util_pkg.assign_column('83', 'ap_inv.voucher_num', 'document_number',
748: 'jgrx_wt.var.document_number','VARCHAR2', 50);
749: fa_rx_util_pkg.assign_column('84', 'pov.organization_type_lookup_code',
750: 'organization_type', 'jgrx_wt.var.organization_type','VARCHAR2', 25);
751: fa_rx_util_pkg.assign_column('85', NULL, 'org_type_meaning',
752: 'jgrx_wt.var.org_type_meaning','VARCHAR2', 80);
753: fa_rx_util_pkg.assign_column('86', 'atc.tax_id', 'tax_id',
754: 'jgrx_wt.var.tax_id', 'NUMBER', 15);
748: 'jgrx_wt.var.document_number','VARCHAR2', 50);
749: fa_rx_util_pkg.assign_column('84', 'pov.organization_type_lookup_code',
750: 'organization_type', 'jgrx_wt.var.organization_type','VARCHAR2', 25);
751: fa_rx_util_pkg.assign_column('85', NULL, 'org_type_meaning',
752: 'jgrx_wt.var.org_type_meaning','VARCHAR2', 80);
753: fa_rx_util_pkg.assign_column('86', 'atc.tax_id', 'tax_id',
754: 'jgrx_wt.var.tax_id', 'NUMBER', 15);
755: fa_rx_util_pkg.assign_column('87', 'atr.tax_name', 'tax_code',
756: 'jgrx_wt.var.tax_code','VARCHAR2', 15);
750: 'organization_type', 'jgrx_wt.var.organization_type','VARCHAR2', 25);
751: fa_rx_util_pkg.assign_column('85', NULL, 'org_type_meaning',
752: 'jgrx_wt.var.org_type_meaning','VARCHAR2', 80);
753: fa_rx_util_pkg.assign_column('86', 'atc.tax_id', 'tax_id',
754: 'jgrx_wt.var.tax_id', 'NUMBER', 15);
755: fa_rx_util_pkg.assign_column('87', 'atr.tax_name', 'tax_code',
756: 'jgrx_wt.var.tax_code','VARCHAR2', 15);
757: fa_rx_util_pkg.assign_column('88', 'atc.description', 'awt_description',
758: 'jgrx_wt.var.awt_description','VARCHAR2', 240);
752: 'jgrx_wt.var.org_type_meaning','VARCHAR2', 80);
753: fa_rx_util_pkg.assign_column('86', 'atc.tax_id', 'tax_id',
754: 'jgrx_wt.var.tax_id', 'NUMBER', 15);
755: fa_rx_util_pkg.assign_column('87', 'atr.tax_name', 'tax_code',
756: 'jgrx_wt.var.tax_code','VARCHAR2', 15);
757: fa_rx_util_pkg.assign_column('88', 'atc.description', 'awt_description',
758: 'jgrx_wt.var.awt_description','VARCHAR2', 240);
759: fa_rx_util_pkg.assign_column('89', 'atc.tax_type', 'tax_type',
760: 'jgrx_wt.var.tax_type','VARCHAR2', 25);
754: 'jgrx_wt.var.tax_id', 'NUMBER', 15);
755: fa_rx_util_pkg.assign_column('87', 'atr.tax_name', 'tax_code',
756: 'jgrx_wt.var.tax_code','VARCHAR2', 15);
757: fa_rx_util_pkg.assign_column('88', 'atc.description', 'awt_description',
758: 'jgrx_wt.var.awt_description','VARCHAR2', 240);
759: fa_rx_util_pkg.assign_column('89', 'atc.tax_type', 'tax_type',
760: 'jgrx_wt.var.tax_type','VARCHAR2', 25);
761: fa_rx_util_pkg.assign_column('90', 'atr.tax_rate_id', 'tax_rate_id',
762: 'jgrx_wt.var.tax_rate_id','NUMBER', 15);
756: 'jgrx_wt.var.tax_code','VARCHAR2', 15);
757: fa_rx_util_pkg.assign_column('88', 'atc.description', 'awt_description',
758: 'jgrx_wt.var.awt_description','VARCHAR2', 240);
759: fa_rx_util_pkg.assign_column('89', 'atc.tax_type', 'tax_type',
760: 'jgrx_wt.var.tax_type','VARCHAR2', 25);
761: fa_rx_util_pkg.assign_column('90', 'atr.tax_rate_id', 'tax_rate_id',
762: 'jgrx_wt.var.tax_rate_id','NUMBER', 15);
763: fa_rx_util_pkg.assign_column('91', 'atr.tax_rate', 'tax_rate',
764: 'jgrx_wt.var.tax_rate', 'NUMBER');
758: 'jgrx_wt.var.awt_description','VARCHAR2', 240);
759: fa_rx_util_pkg.assign_column('89', 'atc.tax_type', 'tax_type',
760: 'jgrx_wt.var.tax_type','VARCHAR2', 25);
761: fa_rx_util_pkg.assign_column('90', 'atr.tax_rate_id', 'tax_rate_id',
762: 'jgrx_wt.var.tax_rate_id','NUMBER', 15);
763: fa_rx_util_pkg.assign_column('91', 'atr.tax_rate', 'tax_rate',
764: 'jgrx_wt.var.tax_rate', 'NUMBER');
765: fa_rx_util_pkg.assign_column('92', 'atc.global_attribute6',
766: 'atc_global_attribute6','jgrx_wt.var.recognized_expense_percent',
760: 'jgrx_wt.var.tax_type','VARCHAR2', 25);
761: fa_rx_util_pkg.assign_column('90', 'atr.tax_rate_id', 'tax_rate_id',
762: 'jgrx_wt.var.tax_rate_id','NUMBER', 15);
763: fa_rx_util_pkg.assign_column('91', 'atr.tax_rate', 'tax_rate',
764: 'jgrx_wt.var.tax_rate', 'NUMBER');
765: fa_rx_util_pkg.assign_column('92', 'atc.global_attribute6',
766: 'atc_global_attribute6','jgrx_wt.var.recognized_expense_percent',
767: 'VARCHAR2', 150);
768: fa_rx_util_pkg.assign_column('93', 'atc.global_attribute7',
762: 'jgrx_wt.var.tax_rate_id','NUMBER', 15);
763: fa_rx_util_pkg.assign_column('91', 'atr.tax_rate', 'tax_rate',
764: 'jgrx_wt.var.tax_rate', 'NUMBER');
765: fa_rx_util_pkg.assign_column('92', 'atc.global_attribute6',
766: 'atc_global_attribute6','jgrx_wt.var.recognized_expense_percent',
767: 'VARCHAR2', 150);
768: fa_rx_util_pkg.assign_column('93', 'atc.global_attribute7',
769: 'atc_global_attribute7', 'jgrx_wt.var.nominal_tax_rate', 'VARCHAR2',150);
770: fa_rx_util_pkg.assign_column('94', 'atc.global_attribute1',
765: fa_rx_util_pkg.assign_column('92', 'atc.global_attribute6',
766: 'atc_global_attribute6','jgrx_wt.var.recognized_expense_percent',
767: 'VARCHAR2', 150);
768: fa_rx_util_pkg.assign_column('93', 'atc.global_attribute7',
769: 'atc_global_attribute7', 'jgrx_wt.var.nominal_tax_rate', 'VARCHAR2',150);
770: fa_rx_util_pkg.assign_column('94', 'atc.global_attribute1',
771: 'atc_global_attribute1', 'jgrx_wt.var.tax_location', 'VARCHAR2', 150);
772: fa_rx_util_pkg.assign_column('95', 'atc.global_attribute4',
773: 'atc_global_attribute4', 'jgrx_wt.var.withholding_tax_type', 'VARCHAR2',150);
767: 'VARCHAR2', 150);
768: fa_rx_util_pkg.assign_column('93', 'atc.global_attribute7',
769: 'atc_global_attribute7', 'jgrx_wt.var.nominal_tax_rate', 'VARCHAR2',150);
770: fa_rx_util_pkg.assign_column('94', 'atc.global_attribute1',
771: 'atc_global_attribute1', 'jgrx_wt.var.tax_location', 'VARCHAR2', 150);
772: fa_rx_util_pkg.assign_column('95', 'atc.global_attribute4',
773: 'atc_global_attribute4', 'jgrx_wt.var.withholding_tax_type', 'VARCHAR2',150);
774: fa_rx_util_pkg.assign_column('96', NULL,
775: 'wh_tax_type_meaning', 'jgrx_wt.var.wh_tax_type_meaning', 'VARCHAR2',80);
769: 'atc_global_attribute7', 'jgrx_wt.var.nominal_tax_rate', 'VARCHAR2',150);
770: fa_rx_util_pkg.assign_column('94', 'atc.global_attribute1',
771: 'atc_global_attribute1', 'jgrx_wt.var.tax_location', 'VARCHAR2', 150);
772: fa_rx_util_pkg.assign_column('95', 'atc.global_attribute4',
773: 'atc_global_attribute4', 'jgrx_wt.var.withholding_tax_type', 'VARCHAR2',150);
774: fa_rx_util_pkg.assign_column('96', NULL,
775: 'wh_tax_type_meaning', 'jgrx_wt.var.wh_tax_type_meaning', 'VARCHAR2',80);
776: fa_rx_util_pkg.assign_column('97', 'atc.global_attribute9',
777: 'atc_global_attribute9','jgrx_wt.var.resident_inc_categ_code','VARCHAR2',150);
771: 'atc_global_attribute1', 'jgrx_wt.var.tax_location', 'VARCHAR2', 150);
772: fa_rx_util_pkg.assign_column('95', 'atc.global_attribute4',
773: 'atc_global_attribute4', 'jgrx_wt.var.withholding_tax_type', 'VARCHAR2',150);
774: fa_rx_util_pkg.assign_column('96', NULL,
775: 'wh_tax_type_meaning', 'jgrx_wt.var.wh_tax_type_meaning', 'VARCHAR2',80);
776: fa_rx_util_pkg.assign_column('97', 'atc.global_attribute9',
777: 'atc_global_attribute9','jgrx_wt.var.resident_inc_categ_code','VARCHAR2',150);
778: fa_rx_util_pkg.assign_column('98', NULL,
779: 'res_inc_categ_meaning', 'jgrx_wt.var.res_inc_categ_meaning','VARCHAR2',80);
773: 'atc_global_attribute4', 'jgrx_wt.var.withholding_tax_type', 'VARCHAR2',150);
774: fa_rx_util_pkg.assign_column('96', NULL,
775: 'wh_tax_type_meaning', 'jgrx_wt.var.wh_tax_type_meaning', 'VARCHAR2',80);
776: fa_rx_util_pkg.assign_column('97', 'atc.global_attribute9',
777: 'atc_global_attribute9','jgrx_wt.var.resident_inc_categ_code','VARCHAR2',150);
778: fa_rx_util_pkg.assign_column('98', NULL,
779: 'res_inc_categ_meaning', 'jgrx_wt.var.res_inc_categ_meaning','VARCHAR2',80);
780: fa_rx_util_pkg.assign_column('99', 'atc.global_attribute5',
781: 'atc_global_attribute5','jgrx_wt.var.foreign_inc_categ_code','VARCHAR2',150);
775: 'wh_tax_type_meaning', 'jgrx_wt.var.wh_tax_type_meaning', 'VARCHAR2',80);
776: fa_rx_util_pkg.assign_column('97', 'atc.global_attribute9',
777: 'atc_global_attribute9','jgrx_wt.var.resident_inc_categ_code','VARCHAR2',150);
778: fa_rx_util_pkg.assign_column('98', NULL,
779: 'res_inc_categ_meaning', 'jgrx_wt.var.res_inc_categ_meaning','VARCHAR2',80);
780: fa_rx_util_pkg.assign_column('99', 'atc.global_attribute5',
781: 'atc_global_attribute5','jgrx_wt.var.foreign_inc_categ_code','VARCHAR2',150);
782: fa_rx_util_pkg.assign_column('100', NULL,
783: 'for_inc_categ_meaning', 'jgrx_wt.var.for_inc_categ_meaning', 'VARCHAR2',80);
777: 'atc_global_attribute9','jgrx_wt.var.resident_inc_categ_code','VARCHAR2',150);
778: fa_rx_util_pkg.assign_column('98', NULL,
779: 'res_inc_categ_meaning', 'jgrx_wt.var.res_inc_categ_meaning','VARCHAR2',80);
780: fa_rx_util_pkg.assign_column('99', 'atc.global_attribute5',
781: 'atc_global_attribute5','jgrx_wt.var.foreign_inc_categ_code','VARCHAR2',150);
782: fa_rx_util_pkg.assign_column('100', NULL,
783: 'for_inc_categ_meaning', 'jgrx_wt.var.for_inc_categ_meaning', 'VARCHAR2',80);
784: fa_rx_util_pkg.assign_column('101', 'pv1.vendor_name',
785: 'tax_authority_name', 'jgrx_wt.var.tax_authority_name', 'VARCHAR2',240);
779: 'res_inc_categ_meaning', 'jgrx_wt.var.res_inc_categ_meaning','VARCHAR2',80);
780: fa_rx_util_pkg.assign_column('99', 'atc.global_attribute5',
781: 'atc_global_attribute5','jgrx_wt.var.foreign_inc_categ_code','VARCHAR2',150);
782: fa_rx_util_pkg.assign_column('100', NULL,
783: 'for_inc_categ_meaning', 'jgrx_wt.var.for_inc_categ_meaning', 'VARCHAR2',80);
784: fa_rx_util_pkg.assign_column('101', 'pv1.vendor_name',
785: 'tax_authority_name', 'jgrx_wt.var.tax_authority_name', 'VARCHAR2',240);
786: fa_rx_util_pkg.assign_column('102', 'ap_inv.payment_status_flag',
787: 'status', 'jgrx_wt.var.status', 'VARCHAR2',1);
781: 'atc_global_attribute5','jgrx_wt.var.foreign_inc_categ_code','VARCHAR2',150);
782: fa_rx_util_pkg.assign_column('100', NULL,
783: 'for_inc_categ_meaning', 'jgrx_wt.var.for_inc_categ_meaning', 'VARCHAR2',80);
784: fa_rx_util_pkg.assign_column('101', 'pv1.vendor_name',
785: 'tax_authority_name', 'jgrx_wt.var.tax_authority_name', 'VARCHAR2',240);
786: fa_rx_util_pkg.assign_column('102', 'ap_inv.payment_status_flag',
787: 'status', 'jgrx_wt.var.status', 'VARCHAR2',1);
788: fa_rx_util_pkg.assign_column('103', 'decode(atc.global_attribute4,''INCOME'',
789: nvl(ind.base_amount,ind.amount),0)', 'income_tax', 'jgrx_wt.var.income_tax' ,'NUMBER');
783: 'for_inc_categ_meaning', 'jgrx_wt.var.for_inc_categ_meaning', 'VARCHAR2',80);
784: fa_rx_util_pkg.assign_column('101', 'pv1.vendor_name',
785: 'tax_authority_name', 'jgrx_wt.var.tax_authority_name', 'VARCHAR2',240);
786: fa_rx_util_pkg.assign_column('102', 'ap_inv.payment_status_flag',
787: 'status', 'jgrx_wt.var.status', 'VARCHAR2',1);
788: fa_rx_util_pkg.assign_column('103', 'decode(atc.global_attribute4,''INCOME'',
789: nvl(ind.base_amount,ind.amount),0)', 'income_tax', 'jgrx_wt.var.income_tax' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('104','decode(atc.global_attribute4,''RESIDENT'',
791: nvl(ind.base_amount,ind.amount),0)','resident_tax', 'jgrx_wt.var.resident_tax' ,'NUMBER');
785: 'tax_authority_name', 'jgrx_wt.var.tax_authority_name', 'VARCHAR2',240);
786: fa_rx_util_pkg.assign_column('102', 'ap_inv.payment_status_flag',
787: 'status', 'jgrx_wt.var.status', 'VARCHAR2',1);
788: fa_rx_util_pkg.assign_column('103', 'decode(atc.global_attribute4,''INCOME'',
789: nvl(ind.base_amount,ind.amount),0)', 'income_tax', 'jgrx_wt.var.income_tax' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('104','decode(atc.global_attribute4,''RESIDENT'',
791: nvl(ind.base_amount,ind.amount),0)','resident_tax', 'jgrx_wt.var.resident_tax' ,'NUMBER');
792: fa_rx_util_pkg.assign_column('105', NULL, 'total_wht_amount',
793: 'jgrx_wt.var.total_wht_amount' ,'NUMBER');
787: 'status', 'jgrx_wt.var.status', 'VARCHAR2',1);
788: fa_rx_util_pkg.assign_column('103', 'decode(atc.global_attribute4,''INCOME'',
789: nvl(ind.base_amount,ind.amount),0)', 'income_tax', 'jgrx_wt.var.income_tax' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('104','decode(atc.global_attribute4,''RESIDENT'',
791: nvl(ind.base_amount,ind.amount),0)','resident_tax', 'jgrx_wt.var.resident_tax' ,'NUMBER');
792: fa_rx_util_pkg.assign_column('105', NULL, 'total_wht_amount',
793: 'jgrx_wt.var.total_wht_amount' ,'NUMBER');
794: fa_rx_util_pkg.assign_column('106','decode(ap_sp.create_awt_dists_type,''PAYMENT
795: '',ap_inv.payment_currency_code, NULL)','payment_currency',
789: nvl(ind.base_amount,ind.amount),0)', 'income_tax', 'jgrx_wt.var.income_tax' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('104','decode(atc.global_attribute4,''RESIDENT'',
791: nvl(ind.base_amount,ind.amount),0)','resident_tax', 'jgrx_wt.var.resident_tax' ,'NUMBER');
792: fa_rx_util_pkg.assign_column('105', NULL, 'total_wht_amount',
793: 'jgrx_wt.var.total_wht_amount' ,'NUMBER');
794: fa_rx_util_pkg.assign_column('106','decode(ap_sp.create_awt_dists_type,''PAYMENT
795: '',ap_inv.payment_currency_code, NULL)','payment_currency',
796: 'jgrx_wt.var.payment_currency' , 'VARCHAR2', 15);
797: fa_rx_util_pkg.assign_column('107','decode(ap_sp.create_awt_dists_type,''PAYMENT
792: fa_rx_util_pkg.assign_column('105', NULL, 'total_wht_amount',
793: 'jgrx_wt.var.total_wht_amount' ,'NUMBER');
794: fa_rx_util_pkg.assign_column('106','decode(ap_sp.create_awt_dists_type,''PAYMENT
795: '',ap_inv.payment_currency_code, NULL)','payment_currency',
796: 'jgrx_wt.var.payment_currency' , 'VARCHAR2', 15);
797: fa_rx_util_pkg.assign_column('107','decode(ap_sp.create_awt_dists_type,''PAYMENT
798: '',aip.invoice_payment_id, NULL)','invoice_payment_id',
799: 'jgrx_wt.var.invoice_payment_id' , 'NUMBER', 15);
800: fa_rx_util_pkg.assign_column('108','decode(ap_sp.create_awt_dists_type,''PAYMENT''
795: '',ap_inv.payment_currency_code, NULL)','payment_currency',
796: 'jgrx_wt.var.payment_currency' , 'VARCHAR2', 15);
797: fa_rx_util_pkg.assign_column('107','decode(ap_sp.create_awt_dists_type,''PAYMENT
798: '',aip.invoice_payment_id, NULL)','invoice_payment_id',
799: 'jgrx_wt.var.invoice_payment_id' , 'NUMBER', 15);
800: fa_rx_util_pkg.assign_column('108','decode(ap_sp.create_awt_dists_type,''PAYMENT''
801: ,nvl(aip.payment_base_amount,aip.amount), NULL)','payment_amount', 'jgrx_wt.var.payment_amount' , 'NUMBER');
802: fa_rx_util_pkg.assign_column('109','decode(ap_sp.create_awt_dists_type,
803: ''PAYMENT'',apc.check_date, NULL)','payment_date',
797: fa_rx_util_pkg.assign_column('107','decode(ap_sp.create_awt_dists_type,''PAYMENT
798: '',aip.invoice_payment_id, NULL)','invoice_payment_id',
799: 'jgrx_wt.var.invoice_payment_id' , 'NUMBER', 15);
800: fa_rx_util_pkg.assign_column('108','decode(ap_sp.create_awt_dists_type,''PAYMENT''
801: ,nvl(aip.payment_base_amount,aip.amount), NULL)','payment_amount', 'jgrx_wt.var.payment_amount' , 'NUMBER');
802: fa_rx_util_pkg.assign_column('109','decode(ap_sp.create_awt_dists_type,
803: ''PAYMENT'',apc.check_date, NULL)','payment_date',
804: 'jgrx_wt.var.payment_date' , 'DATE');
805: fa_rx_util_pkg.assign_column('110','decode(ap_sp.create_awt_dists_type,
800: fa_rx_util_pkg.assign_column('108','decode(ap_sp.create_awt_dists_type,''PAYMENT''
801: ,nvl(aip.payment_base_amount,aip.amount), NULL)','payment_amount', 'jgrx_wt.var.payment_amount' , 'NUMBER');
802: fa_rx_util_pkg.assign_column('109','decode(ap_sp.create_awt_dists_type,
803: ''PAYMENT'',apc.check_date, NULL)','payment_date',
804: 'jgrx_wt.var.payment_date' , 'DATE');
805: fa_rx_util_pkg.assign_column('110','decode(ap_sp.create_awt_dists_type,
806: ''PAYMENT'', aip.payment_num, NULL)','payment_number',
807: 'jgrx_wt.var.payment_number','NUMBER', 15);
808: fa_rx_util_pkg.assign_column('111','decode(ap_sp.create_awt_dists_type,''PAYMENT''
803: ''PAYMENT'',apc.check_date, NULL)','payment_date',
804: 'jgrx_wt.var.payment_date' , 'DATE');
805: fa_rx_util_pkg.assign_column('110','decode(ap_sp.create_awt_dists_type,
806: ''PAYMENT'', aip.payment_num, NULL)','payment_number',
807: 'jgrx_wt.var.payment_number','NUMBER', 15);
808: fa_rx_util_pkg.assign_column('111','decode(ap_sp.create_awt_dists_type,''PAYMENT''
809: ,apc.check_id, NULL)','check_id', 'jgrx_wt.var.check_id' , 'NUMBER', 15);
810: fa_rx_util_pkg.assign_column('112','decode(ap_sp.create_awt_dists_type,
811: ''PAYMENT'', apc.check_number, NULL)','check_number',
805: fa_rx_util_pkg.assign_column('110','decode(ap_sp.create_awt_dists_type,
806: ''PAYMENT'', aip.payment_num, NULL)','payment_number',
807: 'jgrx_wt.var.payment_number','NUMBER', 15);
808: fa_rx_util_pkg.assign_column('111','decode(ap_sp.create_awt_dists_type,''PAYMENT''
809: ,apc.check_id, NULL)','check_id', 'jgrx_wt.var.check_id' , 'NUMBER', 15);
810: fa_rx_util_pkg.assign_column('112','decode(ap_sp.create_awt_dists_type,
811: ''PAYMENT'', apc.check_number, NULL)','check_number',
812: 'jgrx_wt.var.check_number','NUMBER',15);
813: fa_rx_util_pkg.assign_column('113','decode(ap_sp.create_awt_dists_type,
808: fa_rx_util_pkg.assign_column('111','decode(ap_sp.create_awt_dists_type,''PAYMENT''
809: ,apc.check_id, NULL)','check_id', 'jgrx_wt.var.check_id' , 'NUMBER', 15);
810: fa_rx_util_pkg.assign_column('112','decode(ap_sp.create_awt_dists_type,
811: ''PAYMENT'', apc.check_number, NULL)','check_number',
812: 'jgrx_wt.var.check_number','NUMBER',15);
813: fa_rx_util_pkg.assign_column('113','decode(ap_sp.create_awt_dists_type,
814: ''PAYMENT'', nvl(apc.base_amount,apc.amount), NULL)','check_amount',
815: 'jgrx_wt.var.check_amount' , 'NUMBER');
816: fa_rx_util_pkg.assign_column('114','ap_inv.invoice_id','invoice_id',
811: ''PAYMENT'', apc.check_number, NULL)','check_number',
812: 'jgrx_wt.var.check_number','NUMBER',15);
813: fa_rx_util_pkg.assign_column('113','decode(ap_sp.create_awt_dists_type,
814: ''PAYMENT'', nvl(apc.base_amount,apc.amount), NULL)','check_amount',
815: 'jgrx_wt.var.check_amount' , 'NUMBER');
816: fa_rx_util_pkg.assign_column('114','ap_inv.invoice_id','invoice_id',
817: 'jgrx_wt.var.invoice_id' , 'NUMBER', 15);
818: fa_rx_util_pkg.assign_column('115','ind.invoice_distribution_id',
819: 'invoice_distribution_id','jgrx_wt.var.invoice_distribution_id','NUMBER', 15);
813: fa_rx_util_pkg.assign_column('113','decode(ap_sp.create_awt_dists_type,
814: ''PAYMENT'', nvl(apc.base_amount,apc.amount), NULL)','check_amount',
815: 'jgrx_wt.var.check_amount' , 'NUMBER');
816: fa_rx_util_pkg.assign_column('114','ap_inv.invoice_id','invoice_id',
817: 'jgrx_wt.var.invoice_id' , 'NUMBER', 15);
818: fa_rx_util_pkg.assign_column('115','ind.invoice_distribution_id',
819: 'invoice_distribution_id','jgrx_wt.var.invoice_distribution_id','NUMBER', 15);
820: -- Added to handle foreign currency invoices
821: fa_rx_util_pkg.assign_column('116','nvl(ap_inv.base_amount,ap_inv.invoice_amount)', 'invoice_amount', 'jgrx_wt.var.invoice_amount' , 'NUMBER');
815: 'jgrx_wt.var.check_amount' , 'NUMBER');
816: fa_rx_util_pkg.assign_column('114','ap_inv.invoice_id','invoice_id',
817: 'jgrx_wt.var.invoice_id' , 'NUMBER', 15);
818: fa_rx_util_pkg.assign_column('115','ind.invoice_distribution_id',
819: 'invoice_distribution_id','jgrx_wt.var.invoice_distribution_id','NUMBER', 15);
820: -- Added to handle foreign currency invoices
821: fa_rx_util_pkg.assign_column('116','nvl(ap_inv.base_amount,ap_inv.invoice_amount)', 'invoice_amount', 'jgrx_wt.var.invoice_amount' , 'NUMBER');
822: fa_rx_util_pkg.assign_column('117','ap_inv.invoice_date','invoice_date',
823: 'jgrx_wt.var.invoice_date' , 'DATE');
817: 'jgrx_wt.var.invoice_id' , 'NUMBER', 15);
818: fa_rx_util_pkg.assign_column('115','ind.invoice_distribution_id',
819: 'invoice_distribution_id','jgrx_wt.var.invoice_distribution_id','NUMBER', 15);
820: -- Added to handle foreign currency invoices
821: fa_rx_util_pkg.assign_column('116','nvl(ap_inv.base_amount,ap_inv.invoice_amount)', 'invoice_amount', 'jgrx_wt.var.invoice_amount' , 'NUMBER');
822: fa_rx_util_pkg.assign_column('117','ap_inv.invoice_date','invoice_date',
823: 'jgrx_wt.var.invoice_date' , 'DATE');
824: fa_rx_util_pkg.assign_column('118','ap_inv.invoice_currency_code','currency_code', 'jgrx_wt.var.currency_code' , 'VARCHAR2', 15);
825: fa_rx_util_pkg.assign_column('119',NULL,'func_currency_code',
819: 'invoice_distribution_id','jgrx_wt.var.invoice_distribution_id','NUMBER', 15);
820: -- Added to handle foreign currency invoices
821: fa_rx_util_pkg.assign_column('116','nvl(ap_inv.base_amount,ap_inv.invoice_amount)', 'invoice_amount', 'jgrx_wt.var.invoice_amount' , 'NUMBER');
822: fa_rx_util_pkg.assign_column('117','ap_inv.invoice_date','invoice_date',
823: 'jgrx_wt.var.invoice_date' , 'DATE');
824: fa_rx_util_pkg.assign_column('118','ap_inv.invoice_currency_code','currency_code', 'jgrx_wt.var.currency_code' , 'VARCHAR2', 15);
825: fa_rx_util_pkg.assign_column('119',NULL,'func_currency_code',
826: 'jgrx_wt.var.func_currency_code' , 'VARCHAR2', 15);
827: fa_rx_util_pkg.assign_column('120','ind.awt_gross_amount*nvl(ap_inv.exchange_rate
820: -- Added to handle foreign currency invoices
821: fa_rx_util_pkg.assign_column('116','nvl(ap_inv.base_amount,ap_inv.invoice_amount)', 'invoice_amount', 'jgrx_wt.var.invoice_amount' , 'NUMBER');
822: fa_rx_util_pkg.assign_column('117','ap_inv.invoice_date','invoice_date',
823: 'jgrx_wt.var.invoice_date' , 'DATE');
824: fa_rx_util_pkg.assign_column('118','ap_inv.invoice_currency_code','currency_code', 'jgrx_wt.var.currency_code' , 'VARCHAR2', 15);
825: fa_rx_util_pkg.assign_column('119',NULL,'func_currency_code',
826: 'jgrx_wt.var.func_currency_code' , 'VARCHAR2', 15);
827: fa_rx_util_pkg.assign_column('120','ind.awt_gross_amount*nvl(ap_inv.exchange_rate
828: ,1)','amt_subject_to_wh', 'jgrx_wt.var.amt_subject_to_wh' ,'NUMBER');
822: fa_rx_util_pkg.assign_column('117','ap_inv.invoice_date','invoice_date',
823: 'jgrx_wt.var.invoice_date' , 'DATE');
824: fa_rx_util_pkg.assign_column('118','ap_inv.invoice_currency_code','currency_code', 'jgrx_wt.var.currency_code' , 'VARCHAR2', 15);
825: fa_rx_util_pkg.assign_column('119',NULL,'func_currency_code',
826: 'jgrx_wt.var.func_currency_code' , 'VARCHAR2', 15);
827: fa_rx_util_pkg.assign_column('120','ind.awt_gross_amount*nvl(ap_inv.exchange_rate
828: ,1)','amt_subject_to_wh', 'jgrx_wt.var.amt_subject_to_wh' ,'NUMBER');
829: fa_rx_util_pkg.assign_column('121',NULL, 'recognized_expense_amt',
830: 'jgrx_wt.var.recognized_expense_amt','NUMBER');
824: fa_rx_util_pkg.assign_column('118','ap_inv.invoice_currency_code','currency_code', 'jgrx_wt.var.currency_code' , 'VARCHAR2', 15);
825: fa_rx_util_pkg.assign_column('119',NULL,'func_currency_code',
826: 'jgrx_wt.var.func_currency_code' , 'VARCHAR2', 15);
827: fa_rx_util_pkg.assign_column('120','ind.awt_gross_amount*nvl(ap_inv.exchange_rate
828: ,1)','amt_subject_to_wh', 'jgrx_wt.var.amt_subject_to_wh' ,'NUMBER');
829: fa_rx_util_pkg.assign_column('121',NULL, 'recognized_expense_amt',
830: 'jgrx_wt.var.recognized_expense_amt','NUMBER');
831: fa_rx_util_pkg.assign_column('122',NULL, 'inc_wh_tax_base_amt',
832: 'jgrx_wt.var.inc_wh_tax_base_amt' ,'NUMBER');
826: 'jgrx_wt.var.func_currency_code' , 'VARCHAR2', 15);
827: fa_rx_util_pkg.assign_column('120','ind.awt_gross_amount*nvl(ap_inv.exchange_rate
828: ,1)','amt_subject_to_wh', 'jgrx_wt.var.amt_subject_to_wh' ,'NUMBER');
829: fa_rx_util_pkg.assign_column('121',NULL, 'recognized_expense_amt',
830: 'jgrx_wt.var.recognized_expense_amt','NUMBER');
831: fa_rx_util_pkg.assign_column('122',NULL, 'inc_wh_tax_base_amt',
832: 'jgrx_wt.var.inc_wh_tax_base_amt' ,'NUMBER');
833: fa_rx_util_pkg.assign_column('123',NULL, 'res_wh_tax_base_amt',
834: 'jgrx_wt.var.res_wh_tax_base_amt' ,'NUMBER');
828: ,1)','amt_subject_to_wh', 'jgrx_wt.var.amt_subject_to_wh' ,'NUMBER');
829: fa_rx_util_pkg.assign_column('121',NULL, 'recognized_expense_amt',
830: 'jgrx_wt.var.recognized_expense_amt','NUMBER');
831: fa_rx_util_pkg.assign_column('122',NULL, 'inc_wh_tax_base_amt',
832: 'jgrx_wt.var.inc_wh_tax_base_amt' ,'NUMBER');
833: fa_rx_util_pkg.assign_column('123',NULL, 'res_wh_tax_base_amt',
834: 'jgrx_wt.var.res_wh_tax_base_amt' ,'NUMBER');
835: fa_rx_util_pkg.assign_column('124',NULL, 'total_tax_base_amt',
836: 'jgrx_wt.var.total_tax_base_amt','NUMBER');
830: 'jgrx_wt.var.recognized_expense_amt','NUMBER');
831: fa_rx_util_pkg.assign_column('122',NULL, 'inc_wh_tax_base_amt',
832: 'jgrx_wt.var.inc_wh_tax_base_amt' ,'NUMBER');
833: fa_rx_util_pkg.assign_column('123',NULL, 'res_wh_tax_base_amt',
834: 'jgrx_wt.var.res_wh_tax_base_amt' ,'NUMBER');
835: fa_rx_util_pkg.assign_column('124',NULL, 'total_tax_base_amt',
836: 'jgrx_wt.var.total_tax_base_amt','NUMBER');
837: fa_rx_util_pkg.assign_column('125', NULL, 'net_amount',
838: 'jgrx_wt.var.net_amount', 'NUMBER');
832: 'jgrx_wt.var.inc_wh_tax_base_amt' ,'NUMBER');
833: fa_rx_util_pkg.assign_column('123',NULL, 'res_wh_tax_base_amt',
834: 'jgrx_wt.var.res_wh_tax_base_amt' ,'NUMBER');
835: fa_rx_util_pkg.assign_column('124',NULL, 'total_tax_base_amt',
836: 'jgrx_wt.var.total_tax_base_amt','NUMBER');
837: fa_rx_util_pkg.assign_column('125', NULL, 'net_amount',
838: 'jgrx_wt.var.net_amount', 'NUMBER');
839: fa_rx_util_pkg.assign_column('126','ind.distribution_line_number',
840: 'line_number', 'jgrx_wt.var.line_number' , 'NUMBER', 15);
834: 'jgrx_wt.var.res_wh_tax_base_amt' ,'NUMBER');
835: fa_rx_util_pkg.assign_column('124',NULL, 'total_tax_base_amt',
836: 'jgrx_wt.var.total_tax_base_amt','NUMBER');
837: fa_rx_util_pkg.assign_column('125', NULL, 'net_amount',
838: 'jgrx_wt.var.net_amount', 'NUMBER');
839: fa_rx_util_pkg.assign_column('126','ind.distribution_line_number',
840: 'line_number', 'jgrx_wt.var.line_number' , 'NUMBER', 15);
841: fa_rx_util_pkg.assign_column('127','ind.type_1099','TYPE_1099',
842: 'jgrx_wt.var.type_1099' , 'VARCHAR2', 10);
836: 'jgrx_wt.var.total_tax_base_amt','NUMBER');
837: fa_rx_util_pkg.assign_column('125', NULL, 'net_amount',
838: 'jgrx_wt.var.net_amount', 'NUMBER');
839: fa_rx_util_pkg.assign_column('126','ind.distribution_line_number',
840: 'line_number', 'jgrx_wt.var.line_number' , 'NUMBER', 15);
841: fa_rx_util_pkg.assign_column('127','ind.type_1099','TYPE_1099',
842: 'jgrx_wt.var.type_1099' , 'VARCHAR2', 10);
843: fa_rx_util_pkg.assign_column('128','ind.description', 'item_description',
844: 'jgrx_wt.var.item_description' , 'VARCHAR2', 240);
838: 'jgrx_wt.var.net_amount', 'NUMBER');
839: fa_rx_util_pkg.assign_column('126','ind.distribution_line_number',
840: 'line_number', 'jgrx_wt.var.line_number' , 'NUMBER', 15);
841: fa_rx_util_pkg.assign_column('127','ind.type_1099','TYPE_1099',
842: 'jgrx_wt.var.type_1099' , 'VARCHAR2', 10);
843: fa_rx_util_pkg.assign_column('128','ind.description', 'item_description',
844: 'jgrx_wt.var.item_description' , 'VARCHAR2', 240);
845: fa_rx_util_pkg.assign_column('129', 'xle.registration_number',
846: 'hrl_global_attribute11', 'jgrx_wt.var.corporate_id_number', 'VARCHAR2', 150);
840: 'line_number', 'jgrx_wt.var.line_number' , 'NUMBER', 15);
841: fa_rx_util_pkg.assign_column('127','ind.type_1099','TYPE_1099',
842: 'jgrx_wt.var.type_1099' , 'VARCHAR2', 10);
843: fa_rx_util_pkg.assign_column('128','ind.description', 'item_description',
844: 'jgrx_wt.var.item_description' , 'VARCHAR2', 240);
845: fa_rx_util_pkg.assign_column('129', 'xle.registration_number',
846: 'hrl_global_attribute11', 'jgrx_wt.var.corporate_id_number', 'VARCHAR2', 150);
847: fa_rx_util_pkg.assign_column('130','hrl1.telephone_number_2','location_fax',
848: 'jgrx_wt.var.location_fax', 'VARCHAR2', 60);
842: 'jgrx_wt.var.type_1099' , 'VARCHAR2', 10);
843: fa_rx_util_pkg.assign_column('128','ind.description', 'item_description',
844: 'jgrx_wt.var.item_description' , 'VARCHAR2', 240);
845: fa_rx_util_pkg.assign_column('129', 'xle.registration_number',
846: 'hrl_global_attribute11', 'jgrx_wt.var.corporate_id_number', 'VARCHAR2', 150);
847: fa_rx_util_pkg.assign_column('130','hrl1.telephone_number_2','location_fax',
848: 'jgrx_wt.var.location_fax', 'VARCHAR2', 60);
849: fa_rx_util_pkg.assign_column('131', NULL, 'accounting_flexfield',
850: 'jgrx_wt.var.accounting_flexfield', 'VARCHAR2', 1000);
844: 'jgrx_wt.var.item_description' , 'VARCHAR2', 240);
845: fa_rx_util_pkg.assign_column('129', 'xle.registration_number',
846: 'hrl_global_attribute11', 'jgrx_wt.var.corporate_id_number', 'VARCHAR2', 150);
847: fa_rx_util_pkg.assign_column('130','hrl1.telephone_number_2','location_fax',
848: 'jgrx_wt.var.location_fax', 'VARCHAR2', 60);
849: fa_rx_util_pkg.assign_column('131', NULL, 'accounting_flexfield',
850: 'jgrx_wt.var.accounting_flexfield', 'VARCHAR2', 1000);
851: fa_rx_util_pkg.assign_column('132',NULL, 'supp_concatenated_address',
852: 'jgrx_wt.var.supp_concatenated_address' , 'VARCHAR2', 800);
846: 'hrl_global_attribute11', 'jgrx_wt.var.corporate_id_number', 'VARCHAR2', 150);
847: fa_rx_util_pkg.assign_column('130','hrl1.telephone_number_2','location_fax',
848: 'jgrx_wt.var.location_fax', 'VARCHAR2', 60);
849: fa_rx_util_pkg.assign_column('131', NULL, 'accounting_flexfield',
850: 'jgrx_wt.var.accounting_flexfield', 'VARCHAR2', 1000);
851: fa_rx_util_pkg.assign_column('132',NULL, 'supp_concatenated_address',
852: 'jgrx_wt.var.supp_concatenated_address' , 'VARCHAR2', 800);
853: fa_rx_util_pkg.assign_column('133','ou.name','organization_name',
854: 'jgrx_wt.var.organization_name' , 'VARCHAR2', 60);
848: 'jgrx_wt.var.location_fax', 'VARCHAR2', 60);
849: fa_rx_util_pkg.assign_column('131', NULL, 'accounting_flexfield',
850: 'jgrx_wt.var.accounting_flexfield', 'VARCHAR2', 1000);
851: fa_rx_util_pkg.assign_column('132',NULL, 'supp_concatenated_address',
852: 'jgrx_wt.var.supp_concatenated_address' , 'VARCHAR2', 800);
853: fa_rx_util_pkg.assign_column('133','ou.name','organization_name',
854: 'jgrx_wt.var.organization_name' , 'VARCHAR2', 60);
855: fa_rx_util_pkg.assign_column('134',NULL,'reporting_entity_name',
856: 'jgrx_wt.var.reporting_entity_name','VARCHAR2', 15);
850: 'jgrx_wt.var.accounting_flexfield', 'VARCHAR2', 1000);
851: fa_rx_util_pkg.assign_column('132',NULL, 'supp_concatenated_address',
852: 'jgrx_wt.var.supp_concatenated_address' , 'VARCHAR2', 800);
853: fa_rx_util_pkg.assign_column('133','ou.name','organization_name',
854: 'jgrx_wt.var.organization_name' , 'VARCHAR2', 60);
855: fa_rx_util_pkg.assign_column('134',NULL,'reporting_entity_name',
856: 'jgrx_wt.var.reporting_entity_name','VARCHAR2', 15);
857: fa_rx_util_pkg.assign_column('135',NULL,'reporting_sob_name',
858: 'jgrx_wt.var.reporting_sob_name' , 'VARCHAR2', 15);
852: 'jgrx_wt.var.supp_concatenated_address' , 'VARCHAR2', 800);
853: fa_rx_util_pkg.assign_column('133','ou.name','organization_name',
854: 'jgrx_wt.var.organization_name' , 'VARCHAR2', 60);
855: fa_rx_util_pkg.assign_column('134',NULL,'reporting_entity_name',
856: 'jgrx_wt.var.reporting_entity_name','VARCHAR2', 15);
857: fa_rx_util_pkg.assign_column('135',NULL,'reporting_sob_name',
858: 'jgrx_wt.var.reporting_sob_name' , 'VARCHAR2', 15);
859: fa_rx_util_pkg.assign_column('136', NULL, 'sob_id','jgrx_wt.var.sob_id' ,
860: 'VARCHAR2', 15);
854: 'jgrx_wt.var.organization_name' , 'VARCHAR2', 60);
855: fa_rx_util_pkg.assign_column('134',NULL,'reporting_entity_name',
856: 'jgrx_wt.var.reporting_entity_name','VARCHAR2', 15);
857: fa_rx_util_pkg.assign_column('135',NULL,'reporting_sob_name',
858: 'jgrx_wt.var.reporting_sob_name' , 'VARCHAR2', 15);
859: fa_rx_util_pkg.assign_column('136', NULL, 'sob_id','jgrx_wt.var.sob_id' ,
860: 'VARCHAR2', 15);
861: fa_rx_util_pkg.assign_column('137','ap_sp.create_awt_dists_type',
862: NULL, 'jgrx_wt.var.create_dist' , 'VARCHAR2', 15);
855: fa_rx_util_pkg.assign_column('134',NULL,'reporting_entity_name',
856: 'jgrx_wt.var.reporting_entity_name','VARCHAR2', 15);
857: fa_rx_util_pkg.assign_column('135',NULL,'reporting_sob_name',
858: 'jgrx_wt.var.reporting_sob_name' , 'VARCHAR2', 15);
859: fa_rx_util_pkg.assign_column('136', NULL, 'sob_id','jgrx_wt.var.sob_id' ,
860: 'VARCHAR2', 15);
861: fa_rx_util_pkg.assign_column('137','ap_sp.create_awt_dists_type',
862: NULL, 'jgrx_wt.var.create_dist' , 'VARCHAR2', 15);
863: fa_rx_util_pkg.assign_column('138','ap_inv.org_id',
858: 'jgrx_wt.var.reporting_sob_name' , 'VARCHAR2', 15);
859: fa_rx_util_pkg.assign_column('136', NULL, 'sob_id','jgrx_wt.var.sob_id' ,
860: 'VARCHAR2', 15);
861: fa_rx_util_pkg.assign_column('137','ap_sp.create_awt_dists_type',
862: NULL, 'jgrx_wt.var.create_dist' , 'VARCHAR2', 15);
863: fa_rx_util_pkg.assign_column('138','ap_inv.org_id',
864: NULL, 'jgrx_wt.var.org_id' , 'NUMBER', 15);
865: fa_rx_util_pkg.assign_column('139',NULL, 'nominal_or_reg_tax_rate',
866: 'jgrx_wt.var.nominal_or_reg_tax_rate', 'NUMBER');
860: 'VARCHAR2', 15);
861: fa_rx_util_pkg.assign_column('137','ap_sp.create_awt_dists_type',
862: NULL, 'jgrx_wt.var.create_dist' , 'VARCHAR2', 15);
863: fa_rx_util_pkg.assign_column('138','ap_inv.org_id',
864: NULL, 'jgrx_wt.var.org_id' , 'NUMBER', 15);
865: fa_rx_util_pkg.assign_column('139',NULL, 'nominal_or_reg_tax_rate',
866: 'jgrx_wt.var.nominal_or_reg_tax_rate', 'NUMBER');
867: fa_rx_util_pkg.assign_column('140','ind.invoice_line_number',
868: 'invoice_line_num', 'jgrx_wt.var.invoice_line_number', 'NUMBER');
862: NULL, 'jgrx_wt.var.create_dist' , 'VARCHAR2', 15);
863: fa_rx_util_pkg.assign_column('138','ap_inv.org_id',
864: NULL, 'jgrx_wt.var.org_id' , 'NUMBER', 15);
865: fa_rx_util_pkg.assign_column('139',NULL, 'nominal_or_reg_tax_rate',
866: 'jgrx_wt.var.nominal_or_reg_tax_rate', 'NUMBER');
867: fa_rx_util_pkg.assign_column('140','ind.invoice_line_number',
868: 'invoice_line_num', 'jgrx_wt.var.invoice_line_number', 'NUMBER');
869:
870:
864: NULL, 'jgrx_wt.var.org_id' , 'NUMBER', 15);
865: fa_rx_util_pkg.assign_column('139',NULL, 'nominal_or_reg_tax_rate',
866: 'jgrx_wt.var.nominal_or_reg_tax_rate', 'NUMBER');
867: fa_rx_util_pkg.assign_column('140','ind.invoice_line_number',
868: 'invoice_line_num', 'jgrx_wt.var.invoice_line_number', 'NUMBER');
869:
870:
871: END CONSTRUCT_SELECT;
872:
873: PROCEDURE CONSTRUCT_FROM
874: IS
875: BEGIN
876: -- Assign the FROM clause
877: fa_rx_util_pkg.debug('jgrx_wt.construct_from()-');
878: fa_rx_util_pkg.From_clause := 'ap_invoices_all ap_inv,
879: ap_invoice_distributions_all ind,
880: po_vendors pov,
881: po_vendors pv1,
891: hr_all_organization_units ou,
892: hr_organization_information oi';
893:
894:
895: fa_rx_util_pkg.debug('jgrx_wt.construct_from()+');
896:
897: END CONSTRUCT_FROM;
898:
899: PROCEDURE CONSTRUCT_WHERE
909: l_where_reporting_context_asp VARCHAR2(500);
910:
911: BEGIN
912: -- Assign the WHERE clause
913: fa_rx_util_pkg.debug('jgrx_wt.construct_Where()-');
914:
915: -- This call to be Changed due to MOAC uptake
916: -- Condition to check if the report is run for LE or for cross-org
917:
1051: END IF;
1052: end if;
1053: END set_retcode;
1054:
1055: END jgrx_wt;