128: tag number; /* bug 5724171*/
129:
130:
131: begin
132: fa_rx_util_pkg.debug('arrx_rc.before_report()+');
133:
134: -- define common lexical params and assign_column
135:
136: fa_rx_util_pkg.debug('Get SOB ID'||var.books_id);
132: fa_rx_util_pkg.debug('arrx_rc.before_report()+');
133:
134: -- define common lexical params and assign_column
135:
136: fa_rx_util_pkg.debug('Get SOB ID'||var.books_id);
137:
138: /*Bug 5244313
139: IF var.ca_sob_type = 'P'
140: THEN
146: */
147: --
148: -- Get CHART_OF_ACCOUNTS_ID
149: --
150: fa_rx_util_pkg.debug('Get COA ID');
151:
152: select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
153: into var.chart_of_accounts_id,var.currency_code,var.org_name
154: from GL_SETS_OF_BOOKS
156:
157: --
158: -- Figure out NOCOPY the where clause for the parameters
159: --
160: fa_rx_util_pkg.debug('Build Where clauses based on parameters');
161:
162: IF var.p_batch_name_low IS NULL AND var.p_batch_name_high IS NULL THEN
163: BATCH_NAME_WHERE := NULL;
164: ELSIF var.p_batch_name_low IS NULL THEN
197: CUSTOMER_NAME_WHERE := ' AND substrb(PARTY.PARTY_NAME,1,:len1) >= :p_customer_name_low ' ||
198: ' AND substrb(PARTY.PARTY_NAME,1,:len2) <= :p_customer_name_high';
199: END IF;
200:
201: fa_rx_util_pkg.debug('CUSTOMER_NAME_WHERE = ' || CUSTOMER_NAME_WHERE);
202:
203: IF var.p_deposit_date_low IS NULL AND var.p_deposit_date_high IS NULL THEN
204: DEPOSIT_DATE_WHERE := NULL;
205: ELSIF var.p_deposit_date_low IS NULL THEN
322: DOC_SEQUENCE_NUMBER_WHERE := ' AND CR.DOC_SEQUENCE_VALUE between '''|| var.p_doc_sequence_number_from ||
323: ''' AND '''|| var.p_doc_sequence_number_to ||'''';
324: END IF;
325:
326: fa_rx_util_pkg.debug('Define DECODE strings');
327:
328: DECODE_CR_TYPE := 'DECODE(CR.TYPE,''CASH'',:L_CASH,''MISC'',:L_MISC)';
329: DECODE_CR_STATUS := 'DECODE(CR.STATUS,''APP'',:L_APP,''NSF'',:L_NSF,''REV'',:L_REV,''STOP'',:L_STOP, ' ||
330: ' ''UNAPP'',:L_UNAPP,''UNID'',:L_UNID)';
335: DECODE_CRH_ACCTD_AMOUNT := 'DECODE(CRH.STATUS,''REVERSED'',CRH.ACCTD_AMOUNT*-1,CRH.ACCTD_AMOUNT)';
336: DECODE_CRH_FD_AMOUNT := 'DECODE(CRH.STATUS,''REVERSED'',CRH.FACTOR_DISCOUNT_AMOUNT*-1,CRH.FACTOR_DISCOUNT_AMOUNT)';
337: DECODE_CRH_AFD_AMOUNT := 'DECODE(CRH.STATUS,''REVERSED'',CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT*-1,CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT)';
338:
339: fa_rx_util_pkg.debug('Start Assign_columns');
340: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
341:
342: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
343: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
336: DECODE_CRH_FD_AMOUNT := 'DECODE(CRH.STATUS,''REVERSED'',CRH.FACTOR_DISCOUNT_AMOUNT*-1,CRH.FACTOR_DISCOUNT_AMOUNT)';
337: DECODE_CRH_AFD_AMOUNT := 'DECODE(CRH.STATUS,''REVERSED'',CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT*-1,CRH.ACCTD_FACTOR_DISCOUNT_AMOUNT)';
338:
339: fa_rx_util_pkg.debug('Start Assign_columns');
340: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
341:
342: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
343: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
344: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
338:
339: fa_rx_util_pkg.debug('Start Assign_columns');
340: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
341:
342: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
343: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
344: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
345: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
346: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
340: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
341:
342: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
343: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
344: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
345: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
346: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
347: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
348: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
342: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
343: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
344: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
345: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
346: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
347: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
348: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
349: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
350: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
344: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
345: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
346: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
347: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
348: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
349: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
350: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
351: 'arrx_rc.var.batch_id' ,'NUMBER');
352: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
346: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
347: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
348: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
349: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
350: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
351: 'arrx_rc.var.batch_id' ,'NUMBER');
352: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
353: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
354: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
348: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
349: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
350: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
351: 'arrx_rc.var.batch_id' ,'NUMBER');
352: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
353: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
354: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
355: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
356: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
350: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
351: 'arrx_rc.var.batch_id' ,'NUMBER');
352: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
353: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
354: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
355: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
356: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
357: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
358: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
352: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
353: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
354: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
355: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
356: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
357: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
358: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
359: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
360: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
354: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
355: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
356: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
357: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
358: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
359: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
360: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
361: 'arrx_rc.var.exchange_rate' ,'NUMBER');
362: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
356: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
357: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
358: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
359: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
360: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
361: 'arrx_rc.var.exchange_rate' ,'NUMBER');
362: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
363: 'arrx_rc.var.exchange_date' ,'DATE');
364: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
358: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
359: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
360: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
361: 'arrx_rc.var.exchange_rate' ,'NUMBER');
362: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
363: 'arrx_rc.var.exchange_date' ,'DATE');
364: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
365: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
366: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
360: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
361: 'arrx_rc.var.exchange_rate' ,'NUMBER');
362: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
363: 'arrx_rc.var.exchange_date' ,'DATE');
364: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
365: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
366: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
367: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
368: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
362: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
363: 'arrx_rc.var.exchange_date' ,'DATE');
364: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
365: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
366: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
367: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
368: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
369: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
370: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
364: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
365: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
366: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
367: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
368: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
369: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
370: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
371: 'arrx_rc.var.deposit_date' ,'DATE');
372: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
366: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
367: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
368: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
369: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
370: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
371: 'arrx_rc.var.deposit_date' ,'DATE');
372: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
373: 'arrx_rc.var.receipt_date' ,'DATE');
374: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
368: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
369: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
370: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
371: 'arrx_rc.var.deposit_date' ,'DATE');
372: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
373: 'arrx_rc.var.receipt_date' ,'DATE');
374: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
375: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
376: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
370: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
371: 'arrx_rc.var.deposit_date' ,'DATE');
372: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
373: 'arrx_rc.var.receipt_date' ,'DATE');
374: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
375: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
376: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
377: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
378: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
372: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
373: 'arrx_rc.var.receipt_date' ,'DATE');
374: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
375: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
376: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
377: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
378: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
379: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
380: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
374: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
375: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
376: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
377: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
378: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
379: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
380: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
381: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
382: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
376: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
377: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
378: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
379: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
380: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
381: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
382: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
383: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
384: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
378: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
379: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
380: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
381: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
382: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
383: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
384: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
385: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
386: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
380: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
381: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
382: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
383: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
384: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
385: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
386: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
387: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
388: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
382: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
383: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
384: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
385: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
386: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
387: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
388: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
389: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
390: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
384: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
385: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
386: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
387: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
388: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
389: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
390: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
391: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
392: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
386: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
387: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
388: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
389: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
390: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
391: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
392: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
393: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
394: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
388: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
389: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
390: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
391: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
392: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
393: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
394: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
395: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
396: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
390: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
391: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
392: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
393: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
394: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
395: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
396: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
397: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
398: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
392: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
393: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
394: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
395: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
396: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
397: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
398: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
399: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
400: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
394: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
395: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
396: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
397: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
398: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
399: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
400: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
401: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
402: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
396: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
397: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
398: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
399: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
400: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
401: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
402: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
403: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
404: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
398: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
399: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
400: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
401: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
402: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
403: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
404: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
405: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
406: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
400: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
401: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
402: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
403: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
404: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
405: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
406: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
407: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
408: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
402: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
403: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
404: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
405: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
406: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
407: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
408: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
409: 'arrx_rc.var.gl_date' ,'DATE');
410: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
404: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
405: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
406: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
407: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
408: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
409: 'arrx_rc.var.gl_date' ,'DATE');
410: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
411: 'arrx_rc.var.receipt_amount' ,'NUMBER');
412: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
406: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
407: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
408: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
409: 'arrx_rc.var.gl_date' ,'DATE');
410: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
411: 'arrx_rc.var.receipt_amount' ,'NUMBER');
412: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
413: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
414: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
408: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
409: 'arrx_rc.var.gl_date' ,'DATE');
410: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
411: 'arrx_rc.var.receipt_amount' ,'NUMBER');
412: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
413: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
414: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
415: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
416: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
410: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
411: 'arrx_rc.var.receipt_amount' ,'NUMBER');
412: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
413: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
414: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
415: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
416: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
417: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
418: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
412: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
413: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
414: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
415: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
416: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
417: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
418: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
419: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
420: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
414: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
415: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
416: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
417: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
418: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
419: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
420: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
421: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
422: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
416: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
417: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
418: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
419: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
420: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
421: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
422: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
423: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
424: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
418: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
419: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
420: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
421: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
422: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
423: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
424: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
425: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
426: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
420: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
421: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
422: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
423: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
424: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
425: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
426: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
427: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
428: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
422: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
423: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
424: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
425: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
426: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
427: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
428: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
429: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
430: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
424: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
425: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
426: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
427: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
428: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
429: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
430: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
431: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
432: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
426: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
427: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
428: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
429: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
430: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
431: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
432: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
433: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
434: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
428: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
429: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
430: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
431: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
432: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
433: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
434: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
435: 'arrx_rc.var.customer_id' ,'NUMBER');
436: /* bug 5724171*/
430: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
431: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
432: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
433: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
434: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
435: 'arrx_rc.var.customer_id' ,'NUMBER');
436: /* bug 5724171*/
437: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
438: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
433: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
434: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
435: 'arrx_rc.var.customer_id' ,'NUMBER');
436: /* bug 5724171*/
437: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
438: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
439: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
440: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
435: 'arrx_rc.var.customer_id' ,'NUMBER');
436: /* bug 5724171*/
437: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
438: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
439: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
440: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
442: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);
443:
437: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
438: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
439: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
440: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
442: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);
443:
444: -- define FROM_CLAUSE
445: IF var.calling_program in ('RECEIPT','APPLIED','MISC','ACTUAL') then
443:
444: -- define FROM_CLAUSE
445: IF var.calling_program in ('RECEIPT','APPLIED','MISC','ACTUAL') then
446:
447: fa_rx_util_pkg.debug('Define FROM_CLAUSE using _ALL tables');
448:
449: IF NVL(var.ca_sob_type,'P') = 'P' THEN
450: fa_rx_util_pkg.From_Clause :=
451: 'AR_CASH_RECEIPTS_ALL CR,
446:
447: fa_rx_util_pkg.debug('Define FROM_CLAUSE using _ALL tables');
448:
449: IF NVL(var.ca_sob_type,'P') = 'P' THEN
450: fa_rx_util_pkg.From_Clause :=
451: 'AR_CASH_RECEIPTS_ALL CR,
452: FND_DOCUMENT_SEQUENCES DOCSEQ,
453: AR_VAT_TAX_ALL TAX,
454: CE_BANK_ACCOUNTS CBA,
462: AR_BATCHES_ALL BATCH,
463: AR_CASH_RECEIPT_HISTORY_ALL CRHFIRST,
464: AR_BATCHES_ALL BATCHFIRST';
465: ELSE
466: fa_rx_util_pkg.From_Clause :=
467: 'AR_CASH_RECEIPTS_ALL_MRC_V CR,
468: FND_DOCUMENT_SEQUENCES DOCSEQ,
469: AR_VAT_TAX_ALL TAX,
470: CE_BANK_ACCOUNTS CBA,
481: END IF;
482:
483: ELSE
484:
485: fa_rx_util_pkg.debug('Define FROM_CLAUSE using org-striped views');
486:
487: IF NVL(var.ca_sob_type,'P') = 'P' THEN
488: fa_rx_util_pkg.From_Clause :=
489: 'AR_CASH_RECEIPTS CR,
484:
485: fa_rx_util_pkg.debug('Define FROM_CLAUSE using org-striped views');
486:
487: IF NVL(var.ca_sob_type,'P') = 'P' THEN
488: fa_rx_util_pkg.From_Clause :=
489: 'AR_CASH_RECEIPTS CR,
490: FND_DOCUMENT_SEQUENCES DOCSEQ,
491: AR_VAT_TAX TAX,
492: -- AP_BANK_ACCOUNTS ABA,
502: AR_BATCHES BATCH,
503: AR_CASH_RECEIPT_HISTORY CRHFIRST,
504: AR_BATCHES BATCHFIRST';
505: ELSE
506: fa_rx_util_pkg.From_Clause :=
507: 'AR_CASH_RECEIPTS_MRC_V CR,
508: FND_DOCUMENT_SEQUENCES DOCSEQ,
509: AR_VAT_TAX TAX,
510: -- AP_BANK_ACCOUNTS ABA,
523: END IF;
524:
525: END IF;
526:
527: fa_rx_util_pkg.debug('Define WHERE_CLAUSE');
528:
529: fa_rx_util_pkg.Where_Clause := '
530: CR.CASH_RECEIPT_ID = CRHFIRST.CASH_RECEIPT_ID
531: AND CRHFIRST.FIRST_POSTED_RECORD_FLAG = ''Y''
525: END IF;
526:
527: fa_rx_util_pkg.debug('Define WHERE_CLAUSE');
528:
529: fa_rx_util_pkg.Where_Clause := '
530: CR.CASH_RECEIPT_ID = CRHFIRST.CASH_RECEIPT_ID
531: AND CRHFIRST.FIRST_POSTED_RECORD_FLAG = ''Y''
532: AND CRHFIRST.BATCH_ID = BATCHFIRST.BATCH_ID(+)
533: AND CRH.BATCH_ID = BATCH.BATCH_ID(+)
557: CRH_GL_DATE_WHERE;
558:
559: if var.calling_program in ('RECEIPT','APPLIED','MISC','ACTUAL') THEN
560:
561: fa_rx_util_pkg.debug('Define Multi-org logic');
562:
563: --Bug 5244313 added the var.books_id in the where clause to pickup the sob based on the reporting context
564: -- if p_sob_id is null
565: select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
566: into var.p_coa_id,var.functional_currency_code,var.organization_name
567: from GL_SETS_OF_BOOKS
568: where SET_OF_BOOKS_ID =nvl( var.p_sob_id,var.books_id);
569:
570: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
571: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
572: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
573: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
574:
567: from GL_SETS_OF_BOOKS
568: where SET_OF_BOOKS_ID =nvl( var.p_sob_id,var.books_id);
569:
570: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
571: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
572: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
573: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
574:
575: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
568: where SET_OF_BOOKS_ID =nvl( var.p_sob_id,var.books_id);
569:
570: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
571: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
572: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
573: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
574:
575: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
576:
569:
570: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
571: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.p_coa_id);
572: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
573: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
574:
575: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
576:
577: L_CR_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CR',NULL);
633: end if;
634:
635: if var.calling_program = 'RECEIPT' then
636:
637: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Register');
638:
639: IF var.p_gl_date_low is NOT NULL THEN
640: fa_rx_util_pkg.Where_Clause :=
641: fa_rx_util_pkg.Where_Clause ||'
636:
637: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Register');
638:
639: IF var.p_gl_date_low is NOT NULL THEN
640: fa_rx_util_pkg.Where_Clause :=
641: fa_rx_util_pkg.Where_Clause ||'
642: AND ( NOT EXISTS
643: (SELECT ''App Exists''
644: FROM AR_RECEIVABLE_APPLICATIONS_ALL RA
637: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Register');
638:
639: IF var.p_gl_date_low is NOT NULL THEN
640: fa_rx_util_pkg.Where_Clause :=
641: fa_rx_util_pkg.Where_Clause ||'
642: AND ( NOT EXISTS
643: (SELECT ''App Exists''
644: FROM AR_RECEIVABLE_APPLICATIONS_ALL RA
645: WHERE CR.CASH_RECEIPT_ID = RA.CASH_RECEIPT_ID
657: OR CRH.STATUS = ''REVERSED'' )';
658: END IF;
659:
660:
661: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Registe Pos1');
662:
663: IF NVL(var.ca_sob_type,'P') = 'P' THEN
664: fa_rx_util_pkg.Where_Clause :=
665: fa_rx_util_pkg.Where_Clause ||
660:
661: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Registe Pos1');
662:
663: IF NVL(var.ca_sob_type,'P') = 'P' THEN
664: fa_rx_util_pkg.Where_Clause :=
665: fa_rx_util_pkg.Where_Clause ||
666: ' AND ((CRH.CURRENT_RECORD_FLAG = ''Y'' AND CRH.STATUS = ''REVERSED'' )
667: OR (CRH.CASH_RECEIPT_HISTORY_ID IN (
668: SELECT MAX(INCRH.CASH_RECEIPT_HISTORY_ID)
661: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Registe Pos1');
662:
663: IF NVL(var.ca_sob_type,'P') = 'P' THEN
664: fa_rx_util_pkg.Where_Clause :=
665: fa_rx_util_pkg.Where_Clause ||
666: ' AND ((CRH.CURRENT_RECORD_FLAG = ''Y'' AND CRH.STATUS = ''REVERSED'' )
667: OR (CRH.CASH_RECEIPT_HISTORY_ID IN (
668: SELECT MAX(INCRH.CASH_RECEIPT_HISTORY_ID)
669: FROM AR_CASH_RECEIPT_HISTORY_ALL INCRH
671: AND INCRH.STATUS <> ''REVERSED'' ' ||
672: INCRH_GL_DATE_WHERE ||
673: L_INCRH_ORG_WHERE || ' )))' || CO_SEG_WHERE;
674: ELSE
675: fa_rx_util_pkg.Where_Clause :=
676: fa_rx_util_pkg.Where_Clause ||
677: ' AND ((CRH.CURRENT_RECORD_FLAG = ''Y'' AND CRH.STATUS = ''REVERSED'' )
678: OR (CRH.CASH_RECEIPT_HISTORY_ID IN (
679: SELECT MAX(INCRH.CASH_RECEIPT_HISTORY_ID)
672: INCRH_GL_DATE_WHERE ||
673: L_INCRH_ORG_WHERE || ' )))' || CO_SEG_WHERE;
674: ELSE
675: fa_rx_util_pkg.Where_Clause :=
676: fa_rx_util_pkg.Where_Clause ||
677: ' AND ((CRH.CURRENT_RECORD_FLAG = ''Y'' AND CRH.STATUS = ''REVERSED'' )
678: OR (CRH.CASH_RECEIPT_HISTORY_ID IN (
679: SELECT MAX(INCRH.CASH_RECEIPT_HISTORY_ID)
680: FROM AR_CASH_RECEIPT_HIST_ALL_MRC_V INCRH
682: AND INCRH.STATUS <> ''REVERSED'' ' ||
683: INCRH_GL_DATE_WHERE ||
684: L_INCRH_ORG_WHERE || ' )))' || CO_SEG_WHERE;
685: END IF;
686: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Registe Pos2');
687:
688: fa_rx_util_pkg.Where_Clause :=
689: fa_rx_util_pkg.Where_Clause || ' ' ||
690: L_CR_ORG_WHERE || ' ' ||
684: L_INCRH_ORG_WHERE || ' )))' || CO_SEG_WHERE;
685: END IF;
686: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Registe Pos2');
687:
688: fa_rx_util_pkg.Where_Clause :=
689: fa_rx_util_pkg.Where_Clause || ' ' ||
690: L_CR_ORG_WHERE || ' ' ||
691: L_TAX_ORG_WHERE || ' ' ||
692: L_ABA_ORG_WHERE || ' ' ||
685: END IF;
686: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Registe Pos2');
687:
688: fa_rx_util_pkg.Where_Clause :=
689: fa_rx_util_pkg.Where_Clause || ' ' ||
690: L_CR_ORG_WHERE || ' ' ||
691: L_TAX_ORG_WHERE || ' ' ||
692: L_ABA_ORG_WHERE || ' ' ||
693: L_CRH_ORG_WHERE || ' ' ||
694: L_CUST_ORG_WHERE || ' ' ||
695: L_BATCH_ORG_WHERE || ' ' ||
696: L_CRHFIRST_ORG_WHERE || ' ' ||
697: L_BATCHFIRST_ORG_WHERE;
698: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Receipts Registe Pos3');
699:
700: -----------------------------------------
701: ELSIF var.calling_program = 'ACTUAL' then
702: -----------------------------------------
700: -----------------------------------------
701: ELSIF var.calling_program = 'ACTUAL' then
702: -----------------------------------------
703:
704: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMN for Actual Receipts Register');
705:
706: DECODE_RA_STATUS := 'DECODE(RA.STATUS,''ACC'',:L_ACCO,''APP'',:L_APPL,''UNAPP'',:L_UNAPPL,''UNID'',:L_UNIDE)';
707:
708: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
704: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMN for Actual Receipts Register');
705:
706: DECODE_RA_STATUS := 'DECODE(RA.STATUS,''ACC'',:L_ACCO,''APP'',:L_APPL,''UNAPP'',:L_UNAPPL,''UNID'',:L_UNIDE)';
707:
708: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
709: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
710: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
711: 'arrx_rc.var.apply_date' ,'DATE');
712: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
706: DECODE_RA_STATUS := 'DECODE(RA.STATUS,''ACC'',:L_ACCO,''APP'',:L_APPL,''UNAPP'',:L_UNAPPL,''UNID'',:L_UNIDE)';
707:
708: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
709: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
710: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
711: 'arrx_rc.var.apply_date' ,'DATE');
712: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
713: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
714: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
708: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
709: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
710: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
711: 'arrx_rc.var.apply_date' ,'DATE');
712: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
713: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
714: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
715: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
716: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
710: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
711: 'arrx_rc.var.apply_date' ,'DATE');
712: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
713: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
714: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
715: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
716: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
717: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
718: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
712: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
713: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
714: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
715: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
716: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
717: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
718: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
719: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
720: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
714: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
715: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
716: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
717: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
718: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
719: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
720: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
721: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
722: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
716: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
717: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
718: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
719: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
720: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
721: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
722: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
723: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
724: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
718: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
719: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
720: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
721: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
722: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
723: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
724: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
725: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
726: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
720: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
721: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
722: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
723: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
724: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
725: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
726: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
727: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
728: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
722: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
723: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
724: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
725: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
726: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
727: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
728: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
729: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
730: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
724: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
725: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
726: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
727: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
728: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
729: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
730: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
731: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
732: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
726: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
727: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
728: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
729: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
730: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
731: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
732: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
733: 'arrx_rc.var.trx_number','VARCHAR2', 20);
734: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
728: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
729: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
730: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
731: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
732: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
733: 'arrx_rc.var.trx_number','VARCHAR2', 20);
734: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
735: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
736: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
730: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
731: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
732: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
733: 'arrx_rc.var.trx_number','VARCHAR2', 20);
734: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
735: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
736: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
737: 'arrx_rc.var.trx_date','DATE');
738: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
732: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
733: 'arrx_rc.var.trx_number','VARCHAR2', 20);
734: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
735: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
736: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
737: 'arrx_rc.var.trx_date','DATE');
738: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
739: 'arrx_rc.var.trx_amount','NUMBER');
740: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
734: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
735: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
736: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
737: 'arrx_rc.var.trx_date','DATE');
738: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
739: 'arrx_rc.var.trx_amount','NUMBER');
740: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
741: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
742:
736: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
737: 'arrx_rc.var.trx_date','DATE');
738: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
739: 'arrx_rc.var.trx_amount','NUMBER');
740: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
741: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
742:
743: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
744:
739: 'arrx_rc.var.trx_amount','NUMBER');
740: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
741: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
742:
743: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
744:
745: IF NVL(var.ca_sob_type,'P') = 'P' THEN
746: fa_rx_util_pkg.From_Clause :=
747: fa_rx_util_pkg.From_Clause || ',
742:
743: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
744:
745: IF NVL(var.ca_sob_type,'P') = 'P' THEN
746: fa_rx_util_pkg.From_Clause :=
747: fa_rx_util_pkg.From_Clause || ',
748: AR_RECEIVABLE_APPLICATIONS_ALL RA,
749: RA_CUSTOMER_TRX_ALL TRX,
750: RA_CUST_TRX_LINE_GL_DIST_ALL REC';
743: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
744:
745: IF NVL(var.ca_sob_type,'P') = 'P' THEN
746: fa_rx_util_pkg.From_Clause :=
747: fa_rx_util_pkg.From_Clause || ',
748: AR_RECEIVABLE_APPLICATIONS_ALL RA,
749: RA_CUSTOMER_TRX_ALL TRX,
750: RA_CUST_TRX_LINE_GL_DIST_ALL REC';
751: ELSE
748: AR_RECEIVABLE_APPLICATIONS_ALL RA,
749: RA_CUSTOMER_TRX_ALL TRX,
750: RA_CUST_TRX_LINE_GL_DIST_ALL REC';
751: ELSE
752: fa_rx_util_pkg.From_Clause :=
753: fa_rx_util_pkg.From_Clause || ',
754: AR_RECEIVABLE_APPS_ALL_MRC_V RA,
755: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
756: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC';
749: RA_CUSTOMER_TRX_ALL TRX,
750: RA_CUST_TRX_LINE_GL_DIST_ALL REC';
751: ELSE
752: fa_rx_util_pkg.From_Clause :=
753: fa_rx_util_pkg.From_Clause || ',
754: AR_RECEIVABLE_APPS_ALL_MRC_V RA,
755: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
756: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC';
757: END IF;
755: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
756: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC';
757: END IF;
758:
759: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register');
760:
761: fa_rx_util_pkg.Where_Clause :=
762: fa_rx_util_pkg.Where_Clause || '
763: AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
757: END IF;
758:
759: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register');
760:
761: fa_rx_util_pkg.Where_Clause :=
762: fa_rx_util_pkg.Where_Clause || '
763: AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
764: AND RA.DISPLAY = ''Y''
765: AND RA.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID(+)
758:
759: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register');
760:
761: fa_rx_util_pkg.Where_Clause :=
762: fa_rx_util_pkg.Where_Clause || '
763: AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
764: AND RA.DISPLAY = ''Y''
765: AND RA.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID(+)
766: AND RA.APPLIED_CUSTOMER_TRX_ID = REC.CUSTOMER_TRX_ID(+)
766: AND RA.APPLIED_CUSTOMER_TRX_ID = REC.CUSTOMER_TRX_ID(+)
767: AND REC.LATEST_REC_FLAG(+) = ''Y''
768: AND CRH.FIRST_POSTED_RECORD_FLAG = ''Y'' ';
769:
770: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register Pos2');
771:
772: fa_rx_util_pkg.Where_Clause :=
773: fa_rx_util_pkg.Where_Clause || ' ' ||
774: L_CR_ORG_WHERE || ' ' ||
768: AND CRH.FIRST_POSTED_RECORD_FLAG = ''Y'' ';
769:
770: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register Pos2');
771:
772: fa_rx_util_pkg.Where_Clause :=
773: fa_rx_util_pkg.Where_Clause || ' ' ||
774: L_CR_ORG_WHERE || ' ' ||
775: L_TAX_ORG_WHERE || ' ' ||
776: L_ABA_ORG_WHERE || ' ' ||
769:
770: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Actual Receipts Register Pos2');
771:
772: fa_rx_util_pkg.Where_Clause :=
773: fa_rx_util_pkg.Where_Clause || ' ' ||
774: L_CR_ORG_WHERE || ' ' ||
775: L_TAX_ORG_WHERE || ' ' ||
776: L_ABA_ORG_WHERE || ' ' ||
777: L_CRH_ORG_WHERE || ' ' ||
786: ------------------------------------------
787: ELSIF var.calling_program = 'APPLIED' then
788: ------------------------------------------
789:
790: fa_rx_util_pkg.debug('Define additional WHERE_CLAUSE for Applied Receipts Register');
791:
792: IF var.p_apply_date_low IS NULL AND var.p_apply_date_high IS NULL THEN
793: APPLY_DATE_WHERE := NULL;
794: ELSIF var.p_apply_date_low IS NULL THEN
877: SHOW_BILL_FROM := NULL;
878: L_CI_ORG_WHERE := NULL;
879: END IF;
880:
881: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Applied Receipts Register');
882:
883: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
884: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
885: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
879: END IF;
880:
881: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Applied Receipts Register');
882:
883: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
884: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
885: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
886: 'arrx_rc.var.apply_date','DATE');
887: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
881: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Applied Receipts Register');
882:
883: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
884: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
885: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
886: 'arrx_rc.var.apply_date','DATE');
887: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
888: 'arrx_rc.var.related_customer','VARCHAR2', 50);
889: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
883: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
884: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
885: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
886: 'arrx_rc.var.apply_date','DATE');
887: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
888: 'arrx_rc.var.related_customer','VARCHAR2', 50);
889: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
890: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
891: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
885: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
886: 'arrx_rc.var.apply_date','DATE');
887: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
888: 'arrx_rc.var.related_customer','VARCHAR2', 50);
889: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
890: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
891: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
892: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
893: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
887: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
888: 'arrx_rc.var.related_customer','VARCHAR2', 50);
889: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
890: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
891: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
892: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
893: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
894: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
895: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
889: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
890: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
891: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
892: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
893: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
894: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
895: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
896: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
897: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
891: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
892: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
893: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
894: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
895: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
896: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
897: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
898: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
899: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
893: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
894: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
895: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
896: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
897: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
898: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
899: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
900: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
901: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
895: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
896: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
897: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
898: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
899: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
900: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
901: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
902: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
903: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
897: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
898: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
899: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
900: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
901: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
902: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
903: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
904: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
905: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
899: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
900: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
901: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
902: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
903: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
904: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
905: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
906: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
907:
901: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
902: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
903: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
904: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
905: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
906: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
907:
908: IF (BILL_FLAG = 'Y') THEN
909: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT
905: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
906: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
907:
908: IF (BILL_FLAG = 'Y') THEN
909: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT
910: , decode(ci.cons_billing_number, null, ps.trx_number
911: , substrb(rtrim(ci.cons_billing_number)||''/''||rtrim(to_char(trx.trx_number)),1,30)))' ,'TRX_NUMBER',
912: 'arrx_rc.var.trx_number' ,'VARCHAR2', 30);-- bug 5767413
913: ELSE
910: , decode(ci.cons_billing_number, null, ps.trx_number
911: , substrb(rtrim(ci.cons_billing_number)||''/''||rtrim(to_char(trx.trx_number)),1,30)))' ,'TRX_NUMBER',
912: 'arrx_rc.var.trx_number' ,'VARCHAR2', 30);-- bug 5767413
913: ELSE
914: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT, PS.TRX_NUMBER)','TRX_NUMBER' ,
915: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
916: END IF;
917:
918: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
914: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT, PS.TRX_NUMBER)','TRX_NUMBER' ,
915: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
916: END IF;
917:
918: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
919: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
920: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
921: 'arrx_rc.var.trx_date','DATE');
922: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
916: END IF;
917:
918: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
919: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
920: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
921: 'arrx_rc.var.trx_date','DATE');
922: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
923: 'arrx_rc.var.trx_amount','NUMBER');
924: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
918: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
919: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
920: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
921: 'arrx_rc.var.trx_date','DATE');
922: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
923: 'arrx_rc.var.trx_amount','NUMBER');
924: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
925: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
926: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
920: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
921: 'arrx_rc.var.trx_date','DATE');
922: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
923: 'arrx_rc.var.trx_amount','NUMBER');
924: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
925: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
926: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
927: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
928: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
922: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
923: 'arrx_rc.var.trx_amount','NUMBER');
924: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
925: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
926: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
927: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
928: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
929: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
930: 'arrx_rc.var.gl_date','DATE');
925: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
926: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
927: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
928: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
929: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
930: 'arrx_rc.var.gl_date','DATE');
931: -- bug 2379856. Override CRH.ccid with RA.ccid
932: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
933: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
928: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
929: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
930: 'arrx_rc.var.gl_date','DATE');
931: -- bug 2379856. Override CRH.ccid with RA.ccid
932: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
933: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
934:
935: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
936:
931: -- bug 2379856. Override CRH.ccid with RA.ccid
932: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
933: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
934:
935: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
936:
937: IF NVL(var.ca_sob_type,'P') = 'P' THEN
938: fa_rx_util_pkg.From_Clause :=
939: fa_rx_util_pkg.From_Clause ||
934:
935: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
936:
937: IF NVL(var.ca_sob_type,'P') = 'P' THEN
938: fa_rx_util_pkg.From_Clause :=
939: fa_rx_util_pkg.From_Clause ||
940: ', AR_RECEIVABLE_APPLICATIONS_ALL RA,
941: RA_CUSTOMER_TRX_ALL TRX,
942: RA_CUST_TRX_LINE_GL_DIST_ALL REC,
935: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
936:
937: IF NVL(var.ca_sob_type,'P') = 'P' THEN
938: fa_rx_util_pkg.From_Clause :=
939: fa_rx_util_pkg.From_Clause ||
940: ', AR_RECEIVABLE_APPLICATIONS_ALL RA,
941: RA_CUSTOMER_TRX_ALL TRX,
942: RA_CUST_TRX_LINE_GL_DIST_ALL REC,
943: HZ_CUST_ACCOUNTS_ALL RAC ,
943: HZ_CUST_ACCOUNTS_ALL RAC ,
944: AR_PAYMENT_SCHEDULES_ALL PS ,
945: GL_CODE_COMBINATIONS CC2 ' || SHOW_BILL_FROM;
946: ELSE
947: fa_rx_util_pkg.From_Clause :=
948: fa_rx_util_pkg.From_Clause ||
949: ', AR_RECEIVABLE_APPS_ALL_MRC_V RA,
950: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
951: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC,
944: AR_PAYMENT_SCHEDULES_ALL PS ,
945: GL_CODE_COMBINATIONS CC2 ' || SHOW_BILL_FROM;
946: ELSE
947: fa_rx_util_pkg.From_Clause :=
948: fa_rx_util_pkg.From_Clause ||
949: ', AR_RECEIVABLE_APPS_ALL_MRC_V RA,
950: RA_CUSTOMER_TRX_ALL_MRC_V TRX,
951: RA_TRX_LINE_GL_DIST_ALL_MRC_V REC,
952: HZ_CUST_ACCOUNTS_ALL RAC ,
953: AR_PAYMENT_SCHEDULES_ALL_MRC_V PS ,
954: GL_CODE_COMBINATIONS CC2 ' || SHOW_BILL_FROM;
955: END IF;
956:
957: fa_rx_util_pkg.Where_Clause :=
958: fa_rx_util_pkg.Where_Clause ||
959: ' AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
960: AND ( RA.STATUS = ''APP'' OR
961: (RA.STATUS = ''ACTIVITY'' AND
954: GL_CODE_COMBINATIONS CC2 ' || SHOW_BILL_FROM;
955: END IF;
956:
957: fa_rx_util_pkg.Where_Clause :=
958: fa_rx_util_pkg.Where_Clause ||
959: ' AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
960: AND ( RA.STATUS = ''APP'' OR
961: (RA.STATUS = ''ACTIVITY'' AND
962: RA.RECEIVABLES_TRX_ID = -16))
992: ---------------------------------------
993: ELSIF var.calling_program = 'MISC' then
994: ---------------------------------------
995:
996: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Misc Receipts Register');
997:
998: fa_rx_util_pkg.assign_column('A1 ','decode(ARD.SOURCE_TYPE,''TAX'',NULL,MCD.PERCENT)' ,'MISC_PERCENT',
999: 'arrx_rc.var.percent' ,'NUMBER');
1000: -- bug5444415
994: ---------------------------------------
995:
996: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Misc Receipts Register');
997:
998: fa_rx_util_pkg.assign_column('A1 ','decode(ARD.SOURCE_TYPE,''TAX'',NULL,MCD.PERCENT)' ,'MISC_PERCENT',
999: 'arrx_rc.var.percent' ,'NUMBER');
1000: -- bug5444415
1001: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1002: fa_rx_util_pkg.assign_column('A2 ','decode(SIGN(MCD.AMOUNT), 1, ARD.AMOUNT_CR,-1, SIGN(MCD.AMOUNT) * ARD.AMOUNT_DR, 0)' ,'MISC_AMOUNT' ,
998: fa_rx_util_pkg.assign_column('A1 ','decode(ARD.SOURCE_TYPE,''TAX'',NULL,MCD.PERCENT)' ,'MISC_PERCENT',
999: 'arrx_rc.var.percent' ,'NUMBER');
1000: -- bug5444415
1001: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1002: fa_rx_util_pkg.assign_column('A2 ','decode(SIGN(MCD.AMOUNT), 1, ARD.AMOUNT_CR,-1, SIGN(MCD.AMOUNT) * ARD.AMOUNT_DR, 0)' ,'MISC_AMOUNT' ,
1003: 'arrx_rc.var.misc_amount' ,'NUMBER');
1004: ELSE
1005: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1006: END IF ;
1001: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1002: fa_rx_util_pkg.assign_column('A2 ','decode(SIGN(MCD.AMOUNT), 1, ARD.AMOUNT_CR,-1, SIGN(MCD.AMOUNT) * ARD.AMOUNT_DR, 0)' ,'MISC_AMOUNT' ,
1003: 'arrx_rc.var.misc_amount' ,'NUMBER');
1004: ELSE
1005: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1006: END IF ;
1007: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1008: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1009: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1003: 'arrx_rc.var.misc_amount' ,'NUMBER');
1004: ELSE
1005: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1006: END IF ;
1007: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1008: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1009: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1010: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1011: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1006: END IF ;
1007: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1008: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1009: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1010: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1011: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1012: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1013: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1014: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1009: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1010: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1011: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1012: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1013: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1014: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1015:
1016: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1017:
1012: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1013: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1014: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1015:
1016: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1017:
1018: /* Bugfix 2842928. Added GL_CODE_COMBINATIONS CC2, AR_DISTRIBUTIONS ARD */
1019: fa_rx_util_pkg.From_Clause :=
1020: fa_rx_util_pkg.From_Clause ||
1015:
1016: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1017:
1018: /* Bugfix 2842928. Added GL_CODE_COMBINATIONS CC2, AR_DISTRIBUTIONS ARD */
1019: fa_rx_util_pkg.From_Clause :=
1020: fa_rx_util_pkg.From_Clause ||
1021: ' ,AR_MISC_CASH_DISTRIBUTIONS_ALL MCD,
1022: AR_DISTRIBUTIONS_ALL ARD,
1023: GL_CODE_COMBINATIONS CC2,
1016: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1017:
1018: /* Bugfix 2842928. Added GL_CODE_COMBINATIONS CC2, AR_DISTRIBUTIONS ARD */
1019: fa_rx_util_pkg.From_Clause :=
1020: fa_rx_util_pkg.From_Clause ||
1021: ' ,AR_MISC_CASH_DISTRIBUTIONS_ALL MCD,
1022: AR_DISTRIBUTIONS_ALL ARD,
1023: GL_CODE_COMBINATIONS CC2,
1024: AR_BATCH_SOURCES_ALL BS ';
1080:
1081: /*bug 5444415, Changed ARD.SOURCE_ID to ARD.SOURCE_ID(+), ARD.SOURCE_TABLE to ARD.SOURCE_TABLE(+) and
1082: ARD.CODE_COMBINATION_ID to MCD.CODE_COMBINATION_ID */
1083: /*bug 5030073-5039469 Added Co_seg_where*/
1084: fa_rx_util_pkg.Where_Clause :=
1085: fa_rx_util_pkg.Where_Clause ||
1086: ' AND MCD.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID ' ||
1087: ' AND MCD.MISC_CASH_DISTRIBUTION_ID = ARD.SOURCE_ID(+) AND ARD.SOURCE_TABLE(+) = ''MCD'''||
1088: ' AND MCD.CODE_COMBINATION_ID = CC2.CODE_COMBINATION_ID'||
1081: /*bug 5444415, Changed ARD.SOURCE_ID to ARD.SOURCE_ID(+), ARD.SOURCE_TABLE to ARD.SOURCE_TABLE(+) and
1082: ARD.CODE_COMBINATION_ID to MCD.CODE_COMBINATION_ID */
1083: /*bug 5030073-5039469 Added Co_seg_where*/
1084: fa_rx_util_pkg.Where_Clause :=
1085: fa_rx_util_pkg.Where_Clause ||
1086: ' AND MCD.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID ' ||
1087: ' AND MCD.MISC_CASH_DISTRIBUTION_ID = ARD.SOURCE_ID(+) AND ARD.SOURCE_TABLE(+) = ''MCD'''||
1088: ' AND MCD.CODE_COMBINATION_ID = CC2.CODE_COMBINATION_ID'||
1089: ' AND NVL(BATCH.BATCH_SOURCE_ID,-1) = BS.BATCH_SOURCE_ID(+) ' ||
1096: L_BS_ORG_WHERE;
1097: END IF;
1098:
1099:
1100: fa_rx_util_pkg.debug('arrx_rc.before_report()-');
1101:
1102: end before_report;
1103:
1104: procedure bind(c in integer)
1119: L_UNIDE varchar2(80);
1120: L_ONACCOUNT VARCHAR2(80);
1121:
1122: begin
1123: fa_rx_util_pkg.debug('Define BIND variables');
1124:
1125: -- Bug 4219081
1126: IF var.p_reporting_level = 3000 then
1127: IF var.p_reporting_entity_id IS NOT NULL THEN
1238: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
1239:
1240: if var.calling_program = 'ACTUAL' then
1241:
1242: fa_rx_util_pkg.debug('Define additional BIND variables for Actual Receipts Register');
1243:
1244: select MEANING into L_ACCO from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='ACC';
1245: select MEANING into L_APPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='APP';
1246: select MEANING into L_UNAPPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNAPP';
1253: dbms_sql.bind_variable(c, 'l_trx_on_acc', l_acco);
1254:
1255: elsif var.calling_program = 'APPLIED' then
1256:
1257: fa_rx_util_pkg.debug('Define additional BIND variables for Applied Receipts Register');
1258:
1259: SELECT substrb(meaning,1,20) INTO L_ONACCOUNT FROM ar_lookups WHERE lookup_type='PAYMENT_TYPE' AND lookup_code='ACC';
1260:
1261: dbms_sql.bind_variable(c, 'L_ONACCOUNT' , L_ONACCOUNT);
1288:
1289: procedure after_fetch
1290: is
1291: begin
1292: fa_rx_util_pkg.debug('Get Flexfield value and Description');
1293:
1294: var.functional_currency_code := var.currency_code;
1295: var.organization_name := var.org_name;
1296:
1405: is
1406: l_profile_rsob_id NUMBER := NULL;
1407: l_client_info_rsob_id NUMBER := NULL;
1408: begin
1409: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()+');
1410:
1411: -- initialize all var to null
1412: arrx_rc.init_var;
1413:
1464: mo_global.set_policy_context('S',p_reporting_entity_id);
1465:
1466: end if;
1467:
1468: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1469: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1470: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1471: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1472: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1465:
1466: end if;
1467:
1468: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1469: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1470: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1471: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1472: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1473: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1466: end if;
1467:
1468: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1469: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1470: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1471: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1472: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1473: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1474: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1467:
1468: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1469: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1470: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1471: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1472: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1473: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1474: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1475: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1468: fa_rx_util_pkg.debug('p_reporting_level = '||var.p_reporting_level);
1469: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1470: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1471: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1472: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1473: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1474: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1475: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1476: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1469: fa_rx_util_pkg.debug('p_reporting_entity_id = '||var.p_reporting_entity_id);
1470: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1471: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1472: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1473: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1474: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1475: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1476: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1477: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1470: fa_rx_util_pkg.debug('p_sob_id = '||var.p_sob_id);
1471: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1472: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1473: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1474: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1475: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1476: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1477: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1478: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1471: fa_rx_util_pkg.debug('p_coa_id = '||var.p_coa_id);
1472: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1473: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1474: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1475: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1476: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1477: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1478: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1479: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1472: fa_rx_util_pkg.debug('p_co_seg_low = '||var.p_co_seg_low);
1473: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1474: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1475: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1476: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1477: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1478: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1479: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1480: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1473: fa_rx_util_pkg.debug('p_co_seg_high = '||var.p_co_seg_high);
1474: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1475: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1476: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1477: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1478: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1479: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1480: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1481: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1474: fa_rx_util_pkg.debug('p_gl_date_from = '||var.p_gl_date_low);
1475: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1476: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1477: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1478: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1479: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1480: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1481: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1482: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1475: fa_rx_util_pkg.debug('p_gl_date_to = '||var.p_gl_date_high);
1476: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1477: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1478: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1479: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1480: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1481: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1482: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1483: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1476: fa_rx_util_pkg.debug('p_entered_currency = '||var.p_currency_code);
1477: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1478: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1479: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1480: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1481: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1482: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1483: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1484: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1477: fa_rx_util_pkg.debug('p_batch_name_low = '||var.p_batch_name_low);
1478: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1479: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1480: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1481: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1482: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1483: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1484: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1485: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1478: fa_rx_util_pkg.debug('p_batch_name_high = '||var.p_batch_name_high);
1479: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1480: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1481: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1482: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1483: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1484: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1485: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1486: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1479: fa_rx_util_pkg.debug('p_customer_name_low = '||var.p_customer_name_low);
1480: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1481: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1482: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1483: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1484: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1485: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1486: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1487: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1480: fa_rx_util_pkg.debug('p_customer_name_high = '||var.p_customer_name_high);
1481: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1482: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1483: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1484: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1485: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1486: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1487: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1488: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1481: fa_rx_util_pkg.debug('p_deposit_date_low = '||var.p_deposit_date_low);
1482: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1483: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1484: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1485: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1486: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1487: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1488: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1489: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1482: fa_rx_util_pkg.debug('p_deposit_date_high = '||var.p_deposit_date_high);
1483: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1484: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1485: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1486: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1487: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1488: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1489: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1490: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1483: fa_rx_util_pkg.debug('p_receipt_status_low = '||var.p_receipt_status_low);
1484: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1485: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1486: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1487: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1488: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1489: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1490: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1491: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1484: fa_rx_util_pkg.debug('p_receipt_status_high = '||var.p_receipt_status_high);
1485: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1486: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1487: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1488: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1489: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1490: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1491: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1492: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1485: fa_rx_util_pkg.debug('p_receipt_number_low = '||var.p_receipt_number_low);
1486: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1487: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1488: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1489: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1490: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1491: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1492: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1493: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1486: fa_rx_util_pkg.debug('p_receipt_number_high = '||var.p_receipt_number_high);
1487: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1488: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1489: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1490: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1491: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1492: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1493: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1494: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1487: fa_rx_util_pkg.debug('p_invoice_number_low = '||var.p_invoice_number_low);
1488: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1489: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1490: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1491: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1492: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1493: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1494: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1495: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1488: fa_rx_util_pkg.debug('p_invoice_number_high = '||var.p_invoice_number_high);
1489: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1490: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1491: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1492: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1493: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1494: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1495: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1496: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1489: fa_rx_util_pkg.debug('p_receipt_date_low = '||var.p_receipt_date_low);
1490: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1491: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1492: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1493: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1494: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1495: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1496: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1497: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1490: fa_rx_util_pkg.debug('p_receipt_date_high = '||var.p_receipt_date_high);
1491: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1492: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1493: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1494: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1495: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1496: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1497: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1498:
1491: fa_rx_util_pkg.debug('p_bank_account_name = '||var.p_bank_account_name);
1492: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1493: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1494: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1495: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1496: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1497: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1498:
1499: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1492: fa_rx_util_pkg.debug('p_payment_method = '||var.p_payment_method);
1493: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1494: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1495: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1496: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1497: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1498:
1499: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1500: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1493: fa_rx_util_pkg.debug('p_confirmed_flag = '||var.p_confirmed_flag);
1494: fa_rx_util_pkg.debug('p_doc_sequence_name = '||var.p_doc_sequence_name);
1495: fa_rx_util_pkg.debug('p_doc_sequence_number_from = '||var.p_doc_sequence_number_from);
1496: fa_rx_util_pkg.debug('p_doc_sequence_number_to = '||var.p_doc_sequence_number_to);
1497: fa_rx_util_pkg.debug('request_id = '||var.request_id);
1498:
1499: /* Set the appropriate sob type into the global variable var.ca_sob_type */
1500: select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
1501: into l_client_info_rsob_id
1504: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1505: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1506: (l_client_info_rsob_id = -99)
1507: THEN
1508: fa_rx_util_pkg.debug('Setting the sob type to P');
1509: var.ca_sob_type := 'P';
1510: ELSE
1511: fa_rx_util_pkg.debug('Setting the sob type to R');
1512: var.ca_sob_id := l_client_info_rsob_id;
1507: THEN
1508: fa_rx_util_pkg.debug('Setting the sob type to P');
1509: var.ca_sob_type := 'P';
1510: ELSE
1511: fa_rx_util_pkg.debug('Setting the sob type to R');
1512: var.ca_sob_id := l_client_info_rsob_id;
1513: var.ca_sob_type := 'R';
1514: END IF;
1515: --
1513: var.ca_sob_type := 'R';
1514: END IF;
1515: --
1516: -- Initialize request
1517: fa_rx_util_pkg.debug('Initializing the request');
1518: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1519:
1520: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1521: true,
1514: END IF;
1515: --
1516: -- Initialize request
1517: fa_rx_util_pkg.debug('Initializing the request');
1518: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1519:
1520: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1521: true,
1522: 'arrx_rc.before_report;',
1516: -- Initialize request
1517: fa_rx_util_pkg.debug('Initializing the request');
1518: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1519:
1520: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1521: true,
1522: 'arrx_rc.before_report;',
1523: 'arrx_rc.bind(:CURSOR_SELECT);',
1524: 'arrx_rc.after_fetch;',
1526:
1527: --
1528: -- Run the report.
1529: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1530: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1531:
1532: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1533:
1534: exception
1528: -- Run the report.
1529: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1530: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1531:
1532: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1533:
1534: exception
1535: when others then
1536: fa_rx_util_pkg.log(sqlcode);
1532: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1533:
1534: exception
1535: when others then
1536: fa_rx_util_pkg.log(sqlcode);
1537: fa_rx_util_pkg.log(sqlerrm);
1538: fa_rx_util_pkg.debug(sqlcode);
1539: fa_rx_util_pkg.debug(sqlerrm);
1540: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1533:
1534: exception
1535: when others then
1536: fa_rx_util_pkg.log(sqlcode);
1537: fa_rx_util_pkg.log(sqlerrm);
1538: fa_rx_util_pkg.debug(sqlcode);
1539: fa_rx_util_pkg.debug(sqlerrm);
1540: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1541: end arrc_rep;
1534: exception
1535: when others then
1536: fa_rx_util_pkg.log(sqlcode);
1537: fa_rx_util_pkg.log(sqlerrm);
1538: fa_rx_util_pkg.debug(sqlcode);
1539: fa_rx_util_pkg.debug(sqlerrm);
1540: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1541: end arrc_rep;
1542:
1535: when others then
1536: fa_rx_util_pkg.log(sqlcode);
1537: fa_rx_util_pkg.log(sqlerrm);
1538: fa_rx_util_pkg.debug(sqlcode);
1539: fa_rx_util_pkg.debug(sqlerrm);
1540: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1541: end arrc_rep;
1542:
1543: ------------------
1536: fa_rx_util_pkg.log(sqlcode);
1537: fa_rx_util_pkg.log(sqlerrm);
1538: fa_rx_util_pkg.debug(sqlcode);
1539: fa_rx_util_pkg.debug(sqlerrm);
1540: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1541: end arrc_rep;
1542:
1543: ------------------
1544: -- Actual Register
1572: is
1573: l_profile_rsob_id NUMBER := NULL;
1574: l_client_info_rsob_id NUMBER := NULL;
1575: begin
1576: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()+');
1577:
1578: -- initialize all var to null
1579: arrx_rc.init_var;
1580:
1628: fnd_profile.get('MRC_REPORTING_SOB_ID', l_profile_rsob_id);
1629: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1630: (l_client_info_rsob_id = -99)
1631: THEN
1632: fa_rx_util_pkg.debug('Setting the sob type to P');
1633: fa_rx_util_pkg.debug(l_client_info_rsob_id);
1634: var.ca_sob_type := 'P';
1635: ELSE
1636: fa_rx_util_pkg.debug('Setting the sob type to R');
1629: IF (l_client_info_rsob_id = NVL(l_profile_rsob_id,-1)) OR
1630: (l_client_info_rsob_id = -99)
1631: THEN
1632: fa_rx_util_pkg.debug('Setting the sob type to P');
1633: fa_rx_util_pkg.debug(l_client_info_rsob_id);
1634: var.ca_sob_type := 'P';
1635: ELSE
1636: fa_rx_util_pkg.debug('Setting the sob type to R');
1637: var.ca_sob_id := l_client_info_rsob_id;
1632: fa_rx_util_pkg.debug('Setting the sob type to P');
1633: fa_rx_util_pkg.debug(l_client_info_rsob_id);
1634: var.ca_sob_type := 'P';
1635: ELSE
1636: fa_rx_util_pkg.debug('Setting the sob type to R');
1637: var.ca_sob_id := l_client_info_rsob_id;
1638: var.ca_sob_type := 'R';
1639: END IF;
1640:
1638: var.ca_sob_type := 'R';
1639: END IF;
1640:
1641: -- Initialize request
1642: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep_actual',request_id,'AR_RECEIPTS_REP_ITF');
1643:
1644: --
1645: -- Assign triggers specific to this report
1646: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1643:
1644: --
1645: -- Assign triggers specific to this report
1646: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1647: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1648: true,
1649: 'arrx_rc.before_report;',
1650: 'arrx_rc.bind(:CURSOR_SELECT);',
1651: 'arrx_rc.after_fetch;',
1653:
1654: --
1655: -- Run the report.
1656: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1657: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1658:
1659: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1660:
1661: exception
1655: -- Run the report.
1656: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1657: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1658:
1659: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1660:
1661: exception
1662: when others then
1663: fa_rx_util_pkg.log(sqlcode);
1659: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1660:
1661: exception
1662: when others then
1663: fa_rx_util_pkg.log(sqlcode);
1664: fa_rx_util_pkg.log(sqlerrm);
1665: fa_rx_util_pkg.debug(sqlcode);
1666: fa_rx_util_pkg.debug(sqlerrm);
1667: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1660:
1661: exception
1662: when others then
1663: fa_rx_util_pkg.log(sqlcode);
1664: fa_rx_util_pkg.log(sqlerrm);
1665: fa_rx_util_pkg.debug(sqlcode);
1666: fa_rx_util_pkg.debug(sqlerrm);
1667: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1668: end arrc_rep_actual;
1661: exception
1662: when others then
1663: fa_rx_util_pkg.log(sqlcode);
1664: fa_rx_util_pkg.log(sqlerrm);
1665: fa_rx_util_pkg.debug(sqlcode);
1666: fa_rx_util_pkg.debug(sqlerrm);
1667: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1668: end arrc_rep_actual;
1669:
1662: when others then
1663: fa_rx_util_pkg.log(sqlcode);
1664: fa_rx_util_pkg.log(sqlerrm);
1665: fa_rx_util_pkg.debug(sqlcode);
1666: fa_rx_util_pkg.debug(sqlerrm);
1667: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1668: end arrc_rep_actual;
1669:
1670: -------------------
1663: fa_rx_util_pkg.log(sqlcode);
1664: fa_rx_util_pkg.log(sqlerrm);
1665: fa_rx_util_pkg.debug(sqlcode);
1666: fa_rx_util_pkg.debug(sqlerrm);
1667: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1668: end arrc_rep_actual;
1669:
1670: -------------------
1671: -- Applied Register
1703:
1704:
1705: begin
1706:
1707: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1708:
1709: -- initialize all var to null
1710: arrx_rc.init_var;
1711:
1773: END IF;
1774:
1775: --
1776: -- Initialize request
1777: fa_rx_util_pkg.init_request('arrx_rc.arar_rep',request_id,'AR_RECEIPTS_REP_ITF');
1778:
1779: -- Assign triggers specific to this report
1780: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1781:
1778:
1779: -- Assign triggers specific to this report
1780: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1781:
1782: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1783: true,
1784: 'arrx_rc.before_report;',
1785: 'arrx_rc.bind(:CURSOR_SELECT);',
1786: 'arrx_rc.after_fetch;',
1787: null);
1788: --
1789: -- Run the report.
1790: -- Make sure to pass the p_calling_proc assigned from within this procedure
1791: fa_rx_util_pkg.run_report('arrx_rc.arar_rep', retcode, errbuf);
1792:
1793: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1794: exception
1795: when others then
1789: -- Run the report.
1790: -- Make sure to pass the p_calling_proc assigned from within this procedure
1791: fa_rx_util_pkg.run_report('arrx_rc.arar_rep', retcode, errbuf);
1792:
1793: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1794: exception
1795: when others then
1796: fa_rx_util_pkg.log(sqlcode);
1797: fa_rx_util_pkg.log(sqlerrm);
1792:
1793: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1794: exception
1795: when others then
1796: fa_rx_util_pkg.log(sqlcode);
1797: fa_rx_util_pkg.log(sqlerrm);
1798: fa_rx_util_pkg.debug(sqlcode);
1799: fa_rx_util_pkg.debug(sqlerrm);
1800: end arar_rep;
1793: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1794: exception
1795: when others then
1796: fa_rx_util_pkg.log(sqlcode);
1797: fa_rx_util_pkg.log(sqlerrm);
1798: fa_rx_util_pkg.debug(sqlcode);
1799: fa_rx_util_pkg.debug(sqlerrm);
1800: end arar_rep;
1801:
1794: exception
1795: when others then
1796: fa_rx_util_pkg.log(sqlcode);
1797: fa_rx_util_pkg.log(sqlerrm);
1798: fa_rx_util_pkg.debug(sqlcode);
1799: fa_rx_util_pkg.debug(sqlerrm);
1800: end arar_rep;
1801:
1802: -----------------------------------
1795: when others then
1796: fa_rx_util_pkg.log(sqlcode);
1797: fa_rx_util_pkg.log(sqlerrm);
1798: fa_rx_util_pkg.debug(sqlcode);
1799: fa_rx_util_pkg.debug(sqlerrm);
1800: end arar_rep;
1801:
1802: -----------------------------------
1803: -- Miscellaneous Receipts Register
1826: errbuf out NOCOPY varchar2)
1827: is
1828: begin
1829:
1830: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1831:
1832: -- initialize all var to null
1833: arrx_rc.init_var;
1834: --
1880: var.ca_sob_type := 'P';
1881:
1882: --
1883: -- Initialize request
1884: fa_rx_util_pkg.init_request('arrx_rc.armtr_rep',request_id,'AR_RECEIPTS_REP_ITF');
1885:
1886: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1887: true,
1888: 'arrx_rc.before_report;',
1882: --
1883: -- Initialize request
1884: fa_rx_util_pkg.init_request('arrx_rc.armtr_rep',request_id,'AR_RECEIPTS_REP_ITF');
1885:
1886: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1887: true,
1888: 'arrx_rc.before_report;',
1889: 'arrx_rc.bind(:CURSOR_SELECT);',
1890: 'arrx_rc.after_fetch;',
1891: null);
1892: --
1893: -- Run the report.
1894: -- Make sure to pass the p_calling_proc assigned from within this procedure
1895: fa_rx_util_pkg.run_report('arrx_rc.armtr_rep', retcode, errbuf);
1896:
1897: exception
1898: when others then
1899: fa_rx_util_pkg.log(sqlcode);
1895: fa_rx_util_pkg.run_report('arrx_rc.armtr_rep', retcode, errbuf);
1896:
1897: exception
1898: when others then
1899: fa_rx_util_pkg.log(sqlcode);
1900: fa_rx_util_pkg.log(sqlerrm);
1901: fa_rx_util_pkg.debug(sqlcode);
1902: fa_rx_util_pkg.debug(sqlerrm);
1903: end armtr_rep;
1896:
1897: exception
1898: when others then
1899: fa_rx_util_pkg.log(sqlcode);
1900: fa_rx_util_pkg.log(sqlerrm);
1901: fa_rx_util_pkg.debug(sqlcode);
1902: fa_rx_util_pkg.debug(sqlerrm);
1903: end armtr_rep;
1904:
1897: exception
1898: when others then
1899: fa_rx_util_pkg.log(sqlcode);
1900: fa_rx_util_pkg.log(sqlerrm);
1901: fa_rx_util_pkg.debug(sqlcode);
1902: fa_rx_util_pkg.debug(sqlerrm);
1903: end armtr_rep;
1904:
1905: end ARRX_RC;
1898: when others then
1899: fa_rx_util_pkg.log(sqlcode);
1900: fa_rx_util_pkg.log(sqlerrm);
1901: fa_rx_util_pkg.debug(sqlcode);
1902: fa_rx_util_pkg.debug(sqlerrm);
1903: end armtr_rep;
1904:
1905: end ARRX_RC;
1906: