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 536: Select ar_Activity_details_s.nextval

532: 'frt_discount='||to_char(frtdsc_2b_applied)||'.'
533: , 'plsql',
534: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
535:
536: Select ar_Activity_details_s.nextval
537: INTO l_line_id
538: FROM DUAL;
539:
540: -- Calculate the Allocated Receipt Amount for the line

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

544: 'alloc_rct_amt='||to_char(cross_currency_2b_applied)||'.'
545: , 'plsql',
546: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
547:
548: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
549: INSERT INTO AR_ACTIVITY_DETAILS (
550: LINE_ID,
551: APPLY_TO,
552: customer_trx_line_id,

Line 549: INSERT INTO AR_ACTIVITY_DETAILS (

545: , 'plsql',
546: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
547:
548: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
549: INSERT INTO AR_ACTIVITY_DETAILS (
550: LINE_ID,
551: APPLY_TO,
552: customer_trx_line_id,
553: CASH_RECEIPT_ID,

Line 727: Select ar_Activity_details_s.nextval

723: 'chg_amount='||to_char(chg_2b_applied)||'.'
724: , 'plsql',
725: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
726:
727: Select ar_Activity_details_s.nextval
728: INTO l_line_id
729: FROM DUAL;
730:
731:

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

737: 'alloc_rct_amt='||to_char(cross_currency_2b_applied)||'.'
738: , 'plsql',
739: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
740:
741: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
742: INSERT INTO AR_ACTIVITY_DETAILS (
743: LINE_ID,
744: APPLY_TO,
745: customer_trx_line_id,

Line 742: INSERT INTO AR_ACTIVITY_DETAILS (

738: , 'plsql',
739: 'AR_LL_RCV_SUMMARY_PKG.INSERT_ROW', 1);
740:
741: /*Bug 7311231,Modified the code to insert Flexfield info in AR_ACTIVITY_DETAILS.*/
742: INSERT INTO AR_ACTIVITY_DETAILS (
743: LINE_ID,
744: APPLY_TO,
745: customer_trx_line_id,
746: CASH_RECEIPT_ID,

Line 833: INSERT INTO AR_ACTIVITY_DETAILS(

829: )
830: IS
831: BEGIN
832:
833: INSERT INTO AR_ACTIVITY_DETAILS(
834: CASH_RECEIPT_ID,
835: CUSTOMER_TRX_LINE_ID,
836: ALLOCATED_RECEIPT_AMOUNT,
837: AMOUNT,

Line 927: ar_activity_details_s.nextval,

923: LLD.OBJECT_VERSION_NUMBER,
924: LLD.CREATED_BY_MODULE,
925: LLD.SOURCE_ID,
926: LLD.SOURCE_TABLE,
927: ar_activity_details_s.nextval,
928: 'R'
929: FROM ar_Activity_details LLD,
930: ra_customer_trx_lines rctl
931: WHERE rctl.CUSTOMER_TRX_ID = X_CUSTOMER_TRX_ID

Line 929: FROM ar_Activity_details LLD,

925: LLD.SOURCE_ID,
926: LLD.SOURCE_TABLE,
927: ar_activity_details_s.nextval,
928: 'R'
929: FROM ar_Activity_details LLD,
930: ra_customer_trx_lines rctl
931: WHERE rctl.CUSTOMER_TRX_ID = X_CUSTOMER_TRX_ID
932: AND LLD.CUSTOMER_TRX_LINE_ID = rctl.CUSTOMER_TRX_LINE_ID
933: AND LLD.CASH_RECEIPT_ID = X_CASH_RECEIPT_ID

Line 937: UPDATE ar_Activity_details

933: AND LLD.CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
934: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
935:
936:
937: UPDATE ar_Activity_details
938: set CURRENT_ACTIVITY_FLAG = 'N'
939: WHERE CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
940: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
941: AND CUSTOMER_TRX_LINE_ID IN