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

Line 2393: 'AR_ACTIVITY_DETAILS',

2389: IF l_llca_type = 'S' OR l_llca_type = 'G'
2390: OR (l_llca_type = 'L' AND p_llca_trx_lines_tbl.COUNT = 0) THEN
2391: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
2392: l_line_attribute_rec,
2393: 'AR_ACTIVITY_DETAILS',
2394: l_ad_dflex_val_return_status
2395: );
2396: END IF;
2397: IF PG_DEBUG in ('Y', 'C') THEN

Line 2664: update ar_activity_details

2660: -- So, it can used to perform follow on operation on given application
2661:
2662: apply_out_rec.receivable_application_id := llca_ra_rec.receivable_application_id;
2663:
2664: update ar_activity_details
2665: set source_table = 'RA',
2666: source_id = llca_ra_rec.receivable_application_id
2667: where source_id is null
2668: and nvl(current_activity_flag, 'Y') = 'Y' -- Bug 7241111

Line 3090: -- logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead of

3086: arp_util.debug('Apply: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
3087: END IF;
3088:
3089: -- LLCA - Delete the activity record if llca exists. We need to modify the LLCA update
3090: -- logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead of
3091: --- removing it. Open bug exist for this issue.
3092: /*
3093: delete from ar_activity_details ad
3094: where ad.cash_receipt_id = l_cash_receipt_id

Line 3093: delete from ar_activity_details ad

3089: -- LLCA - Delete the activity record if llca exists. We need to modify the LLCA update
3090: -- logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead of
3091: --- removing it. Open bug exist for this issue.
3092: /*
3093: delete from ar_activity_details ad
3094: where ad.cash_receipt_id = l_cash_receipt_id
3095: and ad.customer_trx_line_id in
3096: (select customer_trx_line_id from ra_customer_trx_lines
3097: where customer_trx_id = l_customer_trx_id);

Line 3102: INSERT INTO AR_ACTIVITY_DETAILS(

3098: */
3099:
3100: -- Bug 7241111 to retain the old application record under activity details
3101:
3102: INSERT INTO AR_ACTIVITY_DETAILS(
3103: CASH_RECEIPT_ID,
3104: CUSTOMER_TRX_LINE_ID,
3105: ALLOCATED_RECEIPT_AMOUNT,
3106: AMOUNT,

Line 3196: ar_Activity_details_s.nextval,

3192: LLD.OBJECT_VERSION_NUMBER,
3193: LLD.CREATED_BY_MODULE,
3194: LLD.SOURCE_ID,
3195: LLD.SOURCE_TABLE,
3196: ar_Activity_details_s.nextval,
3197: 'R'
3198: FROM ar_Activity_details LLD
3199: where LLD.cash_receipt_id = l_cash_receipt_id
3200: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'

Line 3198: FROM ar_Activity_details LLD

3194: LLD.SOURCE_ID,
3195: LLD.SOURCE_TABLE,
3196: ar_Activity_details_s.nextval,
3197: 'R'
3198: FROM ar_Activity_details LLD
3199: where LLD.cash_receipt_id = l_cash_receipt_id
3200: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
3201: and LLD.customer_trx_line_id in
3202: (select customer_trx_line_id

Line 3206: UPDATE ar_Activity_details dtl

3202: (select customer_trx_line_id
3203: from ra_customer_trx_lines
3204: where customer_trx_id = l_customer_trx_id);
3205:
3206: UPDATE ar_Activity_details dtl
3207: set CURRENT_ACTIVITY_FLAG = 'N'
3208: where dtl.cash_receipt_id = l_cash_receipt_id
3209: and nvl(dtl.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
3210: and dtl.customer_trx_line_id in

Line 5691: -- LLCA update logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead

5687: Return;
5688: END IF;
5689:
5690: -- Bug 5438627 : LLCA - Delete the activity record if llca exists. We need to modify the
5691: -- LLCA update logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead
5692: --- of removing it. Open bug 5397350 exist for this issue.
5693: /*
5694: delete from ar_activity_details
5695: where cash_receipt_id = l_cash_receipt_id;

Line 5694: delete from ar_activity_details

5690: -- Bug 5438627 : LLCA - Delete the activity record if llca exists. We need to modify the
5691: -- LLCA update logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead
5692: --- of removing it. Open bug 5397350 exist for this issue.
5693: /*
5694: delete from ar_activity_details
5695: where cash_receipt_id = l_cash_receipt_id;
5696: */
5697:
5698: -- Bug 7241111 to retain the old application record under activity details

Line 5700: INSERT INTO AR_ACTIVITY_DETAILS(

5696: */
5697:
5698: -- Bug 7241111 to retain the old application record under activity details
5699:
5700: INSERT INTO AR_ACTIVITY_DETAILS(
5701: CASH_RECEIPT_ID,
5702: CUSTOMER_TRX_LINE_ID,
5703: ALLOCATED_RECEIPT_AMOUNT,
5704: AMOUNT,

Line 5794: ar_Activity_details_s.nextval,

5790: LLD.OBJECT_VERSION_NUMBER,
5791: LLD.CREATED_BY_MODULE,
5792: LLD.SOURCE_ID,
5793: LLD.SOURCE_TABLE,
5794: ar_Activity_details_s.nextval,
5795: 'R'
5796: FROM ar_Activity_details LLD
5797: where LLD.cash_receipt_id = l_cash_receipt_id
5798: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';

Line 5796: FROM ar_Activity_details LLD

5792: LLD.SOURCE_ID,
5793: LLD.SOURCE_TABLE,
5794: ar_Activity_details_s.nextval,
5795: 'R'
5796: FROM ar_Activity_details LLD
5797: where LLD.cash_receipt_id = l_cash_receipt_id
5798: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
5799:
5800: UPDATE ar_Activity_details dtl

Line 5800: UPDATE ar_Activity_details dtl

5796: FROM ar_Activity_details LLD
5797: where LLD.cash_receipt_id = l_cash_receipt_id
5798: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
5799:
5800: UPDATE ar_Activity_details dtl
5801: set CURRENT_ACTIVITY_FLAG = 'N'
5802: where dtl.cash_receipt_id = l_cash_receipt_id
5803: and nvl(dtl.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
5804: