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 2436: 'AR_ACTIVITY_DETAILS',

2432: IF l_llca_type = 'S' OR l_llca_type = 'G'
2433: OR (l_llca_type = 'L' AND p_llca_trx_lines_tbl.COUNT = 0) THEN
2434: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
2435: l_line_attribute_rec,
2436: 'AR_ACTIVITY_DETAILS',
2437: l_ad_dflex_val_return_status
2438: );
2439: END IF;
2440: IF PG_DEBUG in ('Y', 'C') THEN

Line 2709: update ar_activity_details

2705: -- So, it can used to perform follow on operation on given application
2706:
2707: apply_out_rec.receivable_application_id := llca_ra_rec.receivable_application_id;
2708:
2709: update ar_activity_details
2710: set source_table = 'RA',
2711: source_id = llca_ra_rec.receivable_application_id
2712: where source_id is null
2713: and nvl(current_activity_flag, 'Y') = 'Y' -- Bug 7241111

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

3132: arp_util.debug('Apply: ' || 'l_reversal_gl_date :'||to_char(l_reversal_gl_date,'DD-MON-YY'));
3133: END IF;
3134:
3135: -- LLCA - Delete the activity record if llca exists. We need to modify the LLCA update
3136: -- logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead of
3137: --- removing it. Open bug exist for this issue.
3138: /*
3139: delete from ar_activity_details ad
3140: where ad.cash_receipt_id = l_cash_receipt_id

Line 3139: delete from ar_activity_details ad

3135: -- LLCA - Delete the activity record if llca exists. We need to modify the LLCA update
3136: -- logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead of
3137: --- removing it. Open bug exist for this issue.
3138: /*
3139: delete from ar_activity_details ad
3140: where ad.cash_receipt_id = l_cash_receipt_id
3141: and ad.customer_trx_line_id in
3142: (select customer_trx_line_id from ra_customer_trx_lines
3143: where customer_trx_id = l_customer_trx_id);

Line 3148: INSERT INTO AR_ACTIVITY_DETAILS(

3144: */
3145:
3146: -- Bug 7241111 to retain the old application record under activity details
3147:
3148: INSERT INTO AR_ACTIVITY_DETAILS(
3149: CASH_RECEIPT_ID,
3150: CUSTOMER_TRX_LINE_ID,
3151: ALLOCATED_RECEIPT_AMOUNT,
3152: AMOUNT,

Line 3242: ar_Activity_details_s.nextval,

3238: LLD.OBJECT_VERSION_NUMBER,
3239: LLD.CREATED_BY_MODULE,
3240: LLD.SOURCE_ID,
3241: LLD.SOURCE_TABLE,
3242: ar_Activity_details_s.nextval,
3243: 'R'
3244: FROM ar_Activity_details LLD
3245: where LLD.cash_receipt_id = l_cash_receipt_id
3246: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'

Line 3244: FROM ar_Activity_details LLD

3240: LLD.SOURCE_ID,
3241: LLD.SOURCE_TABLE,
3242: ar_Activity_details_s.nextval,
3243: 'R'
3244: FROM ar_Activity_details LLD
3245: where LLD.cash_receipt_id = l_cash_receipt_id
3246: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
3247: and LLD.customer_trx_line_id in
3248: (select customer_trx_line_id

Line 3252: UPDATE ar_Activity_details dtl

3248: (select customer_trx_line_id
3249: from ra_customer_trx_lines
3250: where customer_trx_id = l_customer_trx_id);
3251:
3252: UPDATE ar_Activity_details dtl
3253: set CURRENT_ACTIVITY_FLAG = 'N'
3254: where dtl.cash_receipt_id = l_cash_receipt_id
3255: and nvl(dtl.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'
3256: and dtl.customer_trx_line_id in

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

5919: Return;
5920: END IF;
5921:
5922: -- Bug 5438627 : LLCA - Delete the activity record if llca exists. We need to modify the
5923: -- LLCA update logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead
5924: --- of removing it. Open bug 5397350 exist for this issue.
5925: /*
5926: delete from ar_activity_details
5927: where cash_receipt_id = l_cash_receipt_id;

Line 5926: delete from ar_activity_details

5922: -- Bug 5438627 : LLCA - Delete the activity record if llca exists. We need to modify the
5923: -- LLCA update logic to preserve the previous record details on AR_ACTIVITY_DETAILS instead
5924: --- of removing it. Open bug 5397350 exist for this issue.
5925: /*
5926: delete from ar_activity_details
5927: where cash_receipt_id = l_cash_receipt_id;
5928: */
5929:
5930: -- Bug 7241111 to retain the old application record under activity details

Line 5932: INSERT INTO AR_ACTIVITY_DETAILS(

5928: */
5929:
5930: -- Bug 7241111 to retain the old application record under activity details
5931:
5932: INSERT INTO AR_ACTIVITY_DETAILS(
5933: CASH_RECEIPT_ID,
5934: CUSTOMER_TRX_LINE_ID,
5935: ALLOCATED_RECEIPT_AMOUNT,
5936: AMOUNT,

Line 6026: ar_Activity_details_s.nextval,

6022: LLD.OBJECT_VERSION_NUMBER,
6023: LLD.CREATED_BY_MODULE,
6024: LLD.SOURCE_ID,
6025: LLD.SOURCE_TABLE,
6026: ar_Activity_details_s.nextval,
6027: 'R'
6028: FROM ar_Activity_details LLD
6029: where LLD.cash_receipt_id = l_cash_receipt_id
6030: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';

Line 6028: FROM ar_Activity_details LLD

6024: LLD.SOURCE_ID,
6025: LLD.SOURCE_TABLE,
6026: ar_Activity_details_s.nextval,
6027: 'R'
6028: FROM ar_Activity_details LLD
6029: where LLD.cash_receipt_id = l_cash_receipt_id
6030: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
6031:
6032: UPDATE ar_Activity_details dtl

Line 6032: UPDATE ar_Activity_details dtl

6028: FROM ar_Activity_details LLD
6029: where LLD.cash_receipt_id = l_cash_receipt_id
6030: and nvl(LLD.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
6031:
6032: UPDATE ar_Activity_details dtl
6033: set CURRENT_ACTIVITY_FLAG = 'N'
6034: where dtl.cash_receipt_id = l_cash_receipt_id
6035: and nvl(dtl.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y';
6036: