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_LL_RCV_SUMMARY_PKG dependencies on AR_ACTIVITY_DETAILS

Line 11: DELETE AR_ACTIVITY_DETAILS

7: X_CASH_RECEIPT_ID IN NUMBER
8: ) IS
9: BEGIN
10:
11: DELETE AR_ACTIVITY_DETAILS
12: WHERE 1 = 1
13: AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
14: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- BUG 7241111
15: AND CUSTOMER_TRX_LINE_ID in (select customer_trx_line_id

Line 339: Select ar_Activity_details_s.nextval

335: 'alloc_rct_amt='||to_char(cross_currency_2b_applied)||'.'
336: , 'plsql',
337: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
338:
339: Select ar_Activity_details_s.nextval
340: INTO l_line_id
341: FROM DUAL;
342:
343: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/

Line 343: /Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS./

339: Select ar_Activity_details_s.nextval
340: INTO l_line_id
341: FROM DUAL;
342:
343: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
344: INSERT INTO AR_ACTIVITY_DETAILS (
345: LINE_ID,
346: APPLY_TO,
347: customer_trx_line_id,

Line 344: INSERT INTO AR_ACTIVITY_DETAILS (

340: INTO l_line_id
341: FROM DUAL;
342:
343: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
344: INSERT INTO AR_ACTIVITY_DETAILS (
345: LINE_ID,
346: APPLY_TO,
347: customer_trx_line_id,
348: CASH_RECEIPT_ID,

Line 544: Select ar_Activity_details_s.nextval

540: 'frt_discount='||to_char(frtdsc_2b_applied)||'.'
541: , 'plsql',
542: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
543:
544: Select ar_Activity_details_s.nextval
545: INTO l_line_id
546: FROM DUAL;
547:
548: -- Calculate the Allocated Receipt Amount for the line

Line 556: /Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS./

552: 'alloc_rct_amt='||to_char(cross_currency_2b_applied)||'.'
553: , 'plsql',
554: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
555:
556: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
557: INSERT INTO AR_ACTIVITY_DETAILS (
558: LINE_ID,
559: APPLY_TO,
560: customer_trx_line_id,

Line 557: INSERT INTO AR_ACTIVITY_DETAILS (

553: , 'plsql',
554: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
555:
556: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
557: INSERT INTO AR_ACTIVITY_DETAILS (
558: LINE_ID,
559: APPLY_TO,
560: customer_trx_line_id,
561: CASH_RECEIPT_ID,

Line 743: Select ar_Activity_details_s.nextval

739: 'chg_amount='||to_char(chg_2b_applied)||'.'
740: , 'plsql',
741: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
742:
743: Select ar_Activity_details_s.nextval
744: INTO l_line_id
745: FROM DUAL;
746:
747:

Line 757: /Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS./

753: 'alloc_rct_amt='||to_char(cross_currency_2b_applied)||'.'
754: , 'plsql',
755: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
756:
757: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
758: INSERT INTO AR_ACTIVITY_DETAILS (
759: LINE_ID,
760: APPLY_TO,
761: customer_trx_line_id,

Line 758: INSERT INTO AR_ACTIVITY_DETAILS (

754: , 'plsql',
755: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
756:
757: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
758: INSERT INTO AR_ACTIVITY_DETAILS (
759: LINE_ID,
760: APPLY_TO,
761: customer_trx_line_id,
762: CASH_RECEIPT_ID,

Line 849: INSERT INTO AR_ACTIVITY_DETAILS(

845: )
846: IS
847: BEGIN
848:
849: INSERT INTO AR_ACTIVITY_DETAILS(
850: CASH_RECEIPT_ID,
851: CUSTOMER_TRX_LINE_ID,
852: ALLOCATED_RECEIPT_AMOUNT,
853: AMOUNT,

Line 943: ar_activity_details_s.nextval,

939: LLD.OBJECT_VERSION_NUMBER,
940: LLD.CREATED_BY_MODULE,
941: LLD.SOURCE_ID,
942: LLD.SOURCE_TABLE,
943: ar_activity_details_s.nextval,
944: 'R'
945: FROM ar_Activity_details LLD,
946: ra_customer_trx_lines rctl
947: WHERE rctl.CUSTOMER_TRX_ID = X_CUSTOMER_TRX_ID

Line 945: FROM ar_Activity_details LLD,

941: LLD.SOURCE_ID,
942: LLD.SOURCE_TABLE,
943: ar_activity_details_s.nextval,
944: 'R'
945: FROM ar_Activity_details LLD,
946: ra_customer_trx_lines rctl
947: WHERE rctl.CUSTOMER_TRX_ID = X_CUSTOMER_TRX_ID
948: AND LLD.CUSTOMER_TRX_LINE_ID = rctl.CUSTOMER_TRX_LINE_ID
949: AND LLD.CASH_RECEIPT_ID = X_CASH_RECEIPT_ID

Line 953: UPDATE ar_Activity_details

949: AND LLD.CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
950: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
951:
952:
953: UPDATE ar_Activity_details
954: set CURRENT_ACTIVITY_FLAG = 'N'
955: WHERE CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
956: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
957: AND CUSTOMER_TRX_LINE_ID IN