eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_ACTIVITY_DETAILS_PKG dependencies on AR_ACTIVITY_DETAILS

Line 1: PACKAGE BODY AR_ACTIVITY_DETAILS_PKG AS

1: PACKAGE BODY AR_ACTIVITY_DETAILS_PKG AS
2: /*$Header: ARRWLLTB.pls 120.12 2010/05/28 22:02:41 nemani ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

Line 49: Select ar_activity_details_s.nextval

45: l_line_id NUMBER;
46:
47: BEGIN
48:
49: Select ar_activity_details_s.nextval
50: INTO l_line_id
51: from dual;
52:
53: INSERT INTO AR_ACTIVITY_DETAILS (

Line 53: INSERT INTO AR_ACTIVITY_DETAILS (

49: Select ar_activity_details_s.nextval
50: INTO l_line_id
51: from dual;
52:
53: INSERT INTO AR_ACTIVITY_DETAILS (
54: LINE_ID,
55: APPLY_TO,
56: TAX_BALANCE,
57: CUSTOMER_TRX_LINE_ID,

Line 189: arp_standard.debug('AR_ACTIVITY_DETAILS_PKG.offset_Row()+');

185: l_line_id NUMBER;
186: BEGIN
187:
188: IF PG_DEBUG in ('Y', 'C') THEN
189: arp_standard.debug('AR_ACTIVITY_DETAILS_PKG.offset_Row()+');
190: END IF;
191:
192: /* Select ar_activity_details_s.nextval
193: INTO l_line_id

Line 192: /* Select ar_activity_details_s.nextval

188: IF PG_DEBUG in ('Y', 'C') THEN
189: arp_standard.debug('AR_ACTIVITY_DETAILS_PKG.offset_Row()+');
190: END IF;
191:
192: /* Select ar_activity_details_s.nextval
193: INTO l_line_id
194: from dual; */
195:
196: INSERT INTO AR_ACTIVITY_DETAILS(

Line 196: INSERT INTO AR_ACTIVITY_DETAILS(

192: /* Select ar_activity_details_s.nextval
193: INTO l_line_id
194: from dual; */
195:
196: INSERT INTO AR_ACTIVITY_DETAILS(
197: CASH_RECEIPT_ID,
198: CUSTOMER_TRX_LINE_ID,
199: ALLOCATED_RECEIPT_AMOUNT,
200: AMOUNT,

Line 290: ar_activity_details_s.nextval,

286: LLD.OBJECT_VERSION_NUMBER,
287: LLD.CREATED_BY_MODULE,
288: LLD.SOURCE_ID,
289: LLD.SOURCE_TABLE,
290: ar_activity_details_s.nextval,
291: 'R'
292: FROM ar_Activity_details LLD
293: WHERE 1 = 1 AND CUSTOMER_TRX_LINE_ID = X_CUSTOMER_TRX_LINE_ID
294: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'

Line 292: FROM ar_Activity_details LLD

288: LLD.SOURCE_ID,
289: LLD.SOURCE_TABLE,
290: ar_activity_details_s.nextval,
291: 'R'
292: FROM ar_Activity_details LLD
293: WHERE 1 = 1 AND CUSTOMER_TRX_LINE_ID = X_CUSTOMER_TRX_LINE_ID
294: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
295: AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID;
296:

Line 298: UPDATE ar_Activity_details

294: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
295: AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID;
296:
297:
298: UPDATE ar_Activity_details
299: set CURRENT_ACTIVITY_FLAG = 'N'
300: WHERE 1 = 1 AND CUSTOMER_TRX_LINE_ID = X_CUSTOMER_TRX_LINE_ID
301: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
302: AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID;

Line 305: arp_standard.debug('AR_ACTIVITY_DETAILS_PKG.offset_Row()-');

301: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
302: AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID;
303:
304: IF PG_DEBUG in ('Y', 'C') THEN
305: arp_standard.debug('AR_ACTIVITY_DETAILS_PKG.offset_Row()-');
306: END IF;
307:
308: END;
309:

Line 317: | line level details under ar_activity_details with the Application |

313: | Update_Row |
314: | |
315: | DESCRIPTION |
316: | This routine changed with the bug 7241111, which deals with sync of |
317: | line level details under ar_activity_details with the Application |
318: | (APP rows ) of the AR_receivable_applications. |
319: | |
320: | This will enable user to get each line level application/unapplication |
321: | details corresponding to the RA ID under AR_receivable_applications |

Line 342: row under ar_activity_details with negative amount of the original row

338:
339: /*===========================================================================+
340: CODE LOGIC
341: 1. Instead of updating the row, now we insert the offset
342: row under ar_activity_details with negative amount of the original row
343: ( routine used 'offset_row') with current_activity_flag as 'R' and source_id
344: is of original row. And Update the current_activity_flag as 'N' for the original row.
345:
346: 2. With the new updated amount we insert the new row under ar_activity_details,

Line 346: 2. With the new updated amount we insert the new row under ar_activity_details,

342: row under ar_activity_details with negative amount of the original row
343: ( routine used 'offset_row') with current_activity_flag as 'R' and source_id
344: is of original row. And Update the current_activity_flag as 'N' for the original row.
345:
346: 2. With the new updated amount we insert the new row under ar_activity_details,
347: having current_activity_flag as 'Y' and source_id as NULL.
348:
349: 3. Also from routine "reversal_insert_oppos_ra_recs " (ARCEAPPB.pls), we call routine
350: 'Chk_offset_Row' to enter the offset rows and new rows for the lines which are

Line 564: DELETE AR_ACTIVITY_DETAILS

560:
561:
562: BEGIN
563:
564: DELETE AR_ACTIVITY_DETAILS
565: WHERE 1 = 1 AND CUSTOMER_TRX_LINE_ID = X_CUSTOMER_TRX_LINE_ID
566: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- BUG 7241111
567: AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
568: ;

Line 630: arp_standard.debug('AR_ACTIVITY_DETAILS_PKG.Chk_offset_Row()+');

626: BEGIN
627:
628:
629: IF PG_DEBUG in ('Y', 'C') THEN
630: arp_standard.debug('AR_ACTIVITY_DETAILS_PKG.Chk_offset_Row()+');
631: END IF;
632:
633: begin
634:

Line 637: from ar_Activity_details

633: begin
634:
635: select sum( nvl(amount,0)+ nvl(tax,0)+ nvl(freight,0)+ nvl(charges,0) )
636: into l_activity_amt
637: from ar_Activity_details
638: where cash_receipt_id = X_CASH_RECEIPT_ID
639: and NVL(source_id,-1) = X_OLD_RECEIVABLE_APP_ID
640: and source_table = 'RA'
641: and nvl(CURRENT_ACTIVITY_FLAG,'Y') = 'R';

Line 661: INSERT INTO AR_ACTIVITY_DETAILS(

657: -- If the RA amount is different then the Activity table amount,we need to insert offset rows.
658:
659: IF NVL(l_activity_amt,0) <> NVL(l_ra_amt,0) THEN
660:
661: INSERT INTO AR_ACTIVITY_DETAILS(
662: CASH_RECEIPT_ID,
663: CUSTOMER_TRX_LINE_ID,
664: ALLOCATED_RECEIPT_AMOUNT,
665: AMOUNT,

Line 756: ar_activity_details_s.nextval,

752: LLD.OBJECT_VERSION_NUMBER,
753: LLD.CREATED_BY_MODULE,
754: LLD.SOURCE_ID,
755: LLD.SOURCE_TABLE,
756: ar_activity_details_s.nextval,
757: 'R',
758: 'Y'
759: FROM ar_Activity_details LLD
760: WHERE cash_receipt_id = X_CASH_RECEIPT_ID

Line 759: FROM ar_Activity_details LLD

755: LLD.SOURCE_TABLE,
756: ar_activity_details_s.nextval,
757: 'R',
758: 'Y'
759: FROM ar_Activity_details LLD
760: WHERE cash_receipt_id = X_CASH_RECEIPT_ID
761: and NVl(source_id,-1) = X_OLD_RECEIVABLE_APP_ID
762: and source_table = 'RA'
763: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';

Line 765: INSERT INTO AR_ACTIVITY_DETAILS(

761: and NVl(source_id,-1) = X_OLD_RECEIVABLE_APP_ID
762: and source_table = 'RA'
763: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
764:
765: INSERT INTO AR_ACTIVITY_DETAILS(
766: CASH_RECEIPT_ID,
767: CUSTOMER_TRX_LINE_ID,
768: ALLOCATED_RECEIPT_AMOUNT,
769: AMOUNT,

Line 860: ar_activity_details_s.nextval,

856: LLD.OBJECT_VERSION_NUMBER,
857: LLD.CREATED_BY_MODULE,
858: NULL,
859: LLD.SOURCE_TABLE,
860: ar_activity_details_s.nextval,
861: 'Y',
862: 'Y'
863: FROM ar_Activity_details LLD
864: WHERE cash_receipt_id = X_CASH_RECEIPT_ID

Line 863: FROM ar_Activity_details LLD

859: LLD.SOURCE_TABLE,
860: ar_activity_details_s.nextval,
861: 'Y',
862: 'Y'
863: FROM ar_Activity_details LLD
864: WHERE cash_receipt_id = X_CASH_RECEIPT_ID
865: and NVL(source_id,-1) = X_OLD_RECEIVABLE_APP_ID
866: and source_table = 'RA'
867: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';

Line 870: UPDATE ar_Activity_details

866: and source_table = 'RA'
867: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
868:
869:
870: UPDATE ar_Activity_details
871: set CURRENT_ACTIVITY_FLAG = 'N'
872: WHERE cash_receipt_id = X_CASH_RECEIPT_ID
873: and NVL(source_id,-1) = X_OLD_RECEIVABLE_APP_ID
874: and source_table = 'RA'

Line 882: arp_standard.debug('Amount total under AR_ACTIVITY_DETAILS : '|| l_activity_amt );

878: END IF;
879:
880:
881: IF PG_DEBUG in ('Y', 'C') THEN
882: arp_standard.debug('Amount total under AR_ACTIVITY_DETAILS : '|| l_activity_amt );
883: arp_standard.debug('Amount total under RECEIVABLE_APPLICATIONS : '|| l_ra_amt );
884: END IF;
885:
886:

Line 888: arp_standard.debug('AR_ACTIVITY_DETAILS_PKG.Chk_offset_Row()-');

884: END IF;
885:
886:
887: IF PG_DEBUG in ('Y', 'C') THEN
888: arp_standard.debug('AR_ACTIVITY_DETAILS_PKG.Chk_offset_Row()-');
889: END IF;
890:
891: END Chk_offset_Row;
892:

Line 894: END AR_ACTIVITY_DETAILS_PKG;

890:
891: END Chk_offset_Row;
892:
893:
894: END AR_ACTIVITY_DETAILS_PKG;