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_BUS_EVENT_SUB_PVT dependencies on AR_TRX_SUMMARY_HIST

Line 1049: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

1045: )
1046: RETURN VARCHAR2 IS
1047:
1048: l_ps_tab ps_tab_type;
1049: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1050: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
1051: SELECT *
1052: FROM AR_TRX_SUMMARY_HIST
1053: WHERE customer_trx_id = p_cust_trx_id

Line 1052: FROM AR_TRX_SUMMARY_HIST

1048: l_ps_tab ps_tab_type;
1049: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1050: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
1051: SELECT *
1052: FROM AR_TRX_SUMMARY_HIST
1053: WHERE customer_trx_id = p_cust_trx_id
1054: and nvl(complete_flag,'N') = 'N'
1055: and amount_due_original is not null
1056: for update;

Line 1075: l_history_rec ar_trx_summary_hist%rowtype;

1071: l_security_gr_id NUMBER;
1072: l_counter NUMBER;
1073: l_history_exists_flag BOOLEAN;
1074: l_ps_exists BOOLEAN;
1075: l_history_rec ar_trx_summary_hist%rowtype;
1076: l_tot_inv_amt NUMBER;
1077: l_inv_inst_count NUMBER;
1078: BEGIN
1079:

Line 1136: UPDATE ar_trx_summary_hist

1132: --Update the transaction history table
1133: --set the complete_flag = 'Y'
1134: --if history records exist.
1135: --
1136: UPDATE ar_trx_summary_hist
1137: set complete_flag = 'Y',
1138: LAST_UPDATE_DATE = sysdate,
1139: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1140: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1338: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

1334: , p_event IN OUT NOCOPY WF_EVENT_T
1335: )
1336: RETURN VARCHAR2 IS
1337: l_ps_tab ps_tab_type;
1338: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1339:
1340: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
1341: SELECT *
1342: FROM AR_TRX_SUMMARY_HIST

Line 1342: FROM AR_TRX_SUMMARY_HIST

1338: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1339:
1340: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
1341: SELECT *
1342: FROM AR_TRX_SUMMARY_HIST
1343: WHERE history_id = p_hist_id;
1344: -- and nvl(complete_flag,'N') = 'N';
1345:
1346: CURSOR get_curr_larg_inv_info(p_cust_account_id IN NUMBER,

Line 1370: l_history_rec ar_trx_summary_hist%rowtype;

1366: l_security_gr_id NUMBER;
1367: l_counter NUMBER;
1368: l_history_exists_flag BOOLEAN;
1369: l_ps_exists BOOLEAN;
1370: l_history_rec ar_trx_summary_hist%rowtype;
1371: l_tot_inv_amt NUMBER;
1372: l_inv_inst_count NUMBER;
1373: l_larg_inv_cust_trx_id NUMBER;
1374: l_text VARCHAR2(2000);

Line 1426: UPDATE ar_trx_summary_hist

1422: --
1423: -- Update the transaction history table set the complete_flag = 'Y'
1424: -- if history records exist.
1425: --
1426: UPDATE ar_trx_summary_hist
1427: set complete_flag = 'Y',
1428: LAST_UPDATE_DATE = sysdate,
1429: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1430: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1603: FROM AR_TRX_SUMMARY_HIST

1599: RETURN VARCHAR2 IS
1600:
1601: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
1602: SELECT *
1603: FROM AR_TRX_SUMMARY_HIST
1604: WHERE history_id = p_hist_id;
1605: -- and nvl(complete_flag,'N') = 'N';
1606:
1607: CURSOR get_trx_history2 (p_history_id IN NUMBER) IS

Line 1609: from ar_trx_summary_hist

1605: -- and nvl(complete_flag,'N') = 'N';
1606:
1607: CURSOR get_trx_history2 (p_history_id IN NUMBER) IS
1608: select *
1609: from ar_trx_summary_hist
1610: where previous_history_id = p_history_id;
1611:
1612: CURSOR get_ps_info (p_ps_id IN NUMBER) IS
1613: select due_date, amount_in_dispute

Line 1626: l_history_rec ar_trx_summary_hist%rowtype;

1622: l_application_id NUMBER;
1623: l_security_gr_id NUMBER;
1624: l_history_exists_flag BOOLEAN;
1625: l_ps_exists BOOLEAN;
1626: l_history_rec ar_trx_summary_hist%rowtype;
1627: l_history_rec2 ar_trx_summary_hist%rowtype;
1628: l_tot_inv_amt NUMBER;
1629: l_history_id NUMBER(15);
1630:

Line 1627: l_history_rec2 ar_trx_summary_hist%rowtype;

1623: l_security_gr_id NUMBER;
1624: l_history_exists_flag BOOLEAN;
1625: l_ps_exists BOOLEAN;
1626: l_history_rec ar_trx_summary_hist%rowtype;
1627: l_history_rec2 ar_trx_summary_hist%rowtype;
1628: l_tot_inv_amt NUMBER;
1629: l_history_id NUMBER(15);
1630:
1631: l_due_date_change VARCHAR2(1);

Line 1676: UPDATE ar_trx_summary_hist

1672:
1673: BEGIN
1674:
1675: --Stamp the history record for the modification.
1676: UPDATE ar_trx_summary_hist
1677: set complete_flag = 'Y',
1678: LAST_UPDATE_DATE = sysdate,
1679: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1680: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1826: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

1822: , p_event IN OUT NOCOPY WF_EVENT_T
1823: )
1824: RETURN VARCHAR2 IS
1825: l_ps_rec AR_PAYMENT_SCHEDULES%rowtype;
1826: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1827: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
1828: SELECT *
1829: FROM AR_TRX_SUMMARY_HIST
1830: WHERE customer_trx_id = p_cust_trx_id

Line 1829: FROM AR_TRX_SUMMARY_HIST

1825: l_ps_rec AR_PAYMENT_SCHEDULES%rowtype;
1826: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
1827: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
1828: SELECT *
1829: FROM AR_TRX_SUMMARY_HIST
1830: WHERE customer_trx_id = p_cust_trx_id
1831: and nvl(complete_flag,'N') = 'N'
1832: and amount_due_original is not null
1833: for update;

Line 1861: l_history_rec ar_trx_summary_hist%rowtype;

1857: l_security_gr_id NUMBER;
1858: l_counter NUMBER;
1859: l_history_exists_flag BOOLEAN;
1860: l_ps_exists BOOLEAN;
1861: l_history_rec ar_trx_summary_hist%rowtype;
1862: l_tot_inv_amt NUMBER;
1863: l_inv_inst_count NUMBER;
1864: l_prev_trx_op_count NUMBER;
1865: l_prev_trx_app_amt NUMBER;

Line 1935: UPDATE ar_trx_summary_hist

1931: --Update the transaction history table
1932: --set the complete_flag = 'Y'
1933: --if history records exist.
1934: --
1935: UPDATE ar_trx_summary_hist
1936: set complete_flag = 'Y',
1937: LAST_UPDATE_DATE = sysdate,
1938: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1939: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 2176: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

2172: )
2173: RETURN VARCHAR2 IS
2174:
2175: l_ps_tab ps_tab_type;
2176: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2177:
2178: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
2179: SELECT *
2180: FROM AR_TRX_SUMMARY_HIST

Line 2180: FROM AR_TRX_SUMMARY_HIST

2176: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2177:
2178: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
2179: SELECT *
2180: FROM AR_TRX_SUMMARY_HIST
2181: WHERE history_id = p_hist_id;
2182:
2183: CURSOR get_prev_ctx_id (ctx_id IN NUMBER) IS
2184: select previous_customer_trx_id

Line 2200: l_history_rec ar_trx_summary_hist%rowtype;

2196: l_security_gr_id NUMBER;
2197: l_counter NUMBER;
2198: l_history_exists_flag BOOLEAN;
2199: l_ps_exists BOOLEAN;
2200: l_history_rec ar_trx_summary_hist%rowtype;
2201: l_tot_inv_amt NUMBER;
2202: l_inv_inst_count NUMBER;
2203: l_larg_inv_cust_trx_id NUMBER;
2204: l_text VARCHAR2(2000);

Line 2275: UPDATE ar_trx_summary_hist

2271: --
2272: -- Update the transaction history table set the complete_flag = 'Y'
2273: -- if history records exist.
2274: --
2275: UPDATE ar_trx_summary_hist
2276: set complete_flag = 'Y',
2277: LAST_UPDATE_DATE = sysdate,
2278: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2279: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 2413: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

2409: ( p_subscription_guid In RAW
2410: , p_event IN OUT NOCOPY WF_EVENT_T
2411: ) RETURN VARCHAR2 IS
2412: l_ps_tab ps_tab_type;
2413: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2414:
2415: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
2416: SELECT *
2417: FROM AR_TRX_SUMMARY_HIST

Line 2417: FROM AR_TRX_SUMMARY_HIST

2413: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2414:
2415: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
2416: SELECT *
2417: FROM AR_TRX_SUMMARY_HIST
2418: WHERE customer_trx_id = p_cust_trx_id
2419: and nvl(complete_flag,'N') = 'N'
2420: and amount_due_original is not null
2421: for update;

Line 2440: l_history_rec ar_trx_summary_hist%rowtype;

2436: l_security_gr_id NUMBER;
2437: l_counter NUMBER;
2438: l_history_exists_flag BOOLEAN;
2439: l_ps_exists BOOLEAN;
2440: l_history_rec ar_trx_summary_hist%rowtype;
2441: BEGIN
2442:
2443: IF pg_debug = 'Y'
2444: THEN

Line 2500: UPDATE ar_trx_summary_hist

2496: --Update the transaction history table
2497: --set the complete_flag = 'Y'
2498: --if history records exist.
2499: --
2500: UPDATE ar_trx_summary_hist
2501: set complete_flag = 'Y',
2502: LAST_UPDATE_DATE = sysdate,
2503: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2504: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 2663: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

2659: , p_event IN OUT NOCOPY WF_EVENT_T
2660: )
2661: RETURN VARCHAR2 IS
2662: l_ps_tab ps_tab_type;
2663: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2664:
2665: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
2666: SELECT *
2667: FROM AR_TRX_SUMMARY_HIST

Line 2667: FROM AR_TRX_SUMMARY_HIST

2663: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2664:
2665: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
2666: SELECT *
2667: FROM AR_TRX_SUMMARY_HIST
2668: WHERE history_id = p_hist_id;
2669: -- and nvl(complete_flag,'N') = 'N';
2670:
2671:

Line 2684: l_history_rec ar_trx_summary_hist%rowtype;

2680: l_security_gr_id NUMBER;
2681: l_counter NUMBER;
2682: l_history_exists_flag BOOLEAN;
2683: l_ps_exists BOOLEAN;
2684: l_history_rec ar_trx_summary_hist%rowtype;
2685: l_tot_inv_amt NUMBER;
2686: l_inv_inst_count NUMBER;
2687: l_larg_inv_cust_trx_id NUMBER;
2688: l_text VARCHAR2(2000);

Line 2736: UPDATE ar_trx_summary_hist

2732: --
2733: -- Update the transaction history table set the complete_flag = 'Y'
2734: -- if history records exist.
2735: --
2736: UPDATE ar_trx_summary_hist
2737: set complete_flag = 'Y',
2738: LAST_UPDATE_DATE = sysdate,
2739: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2740: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 2854: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

2850: )
2851: RETURN VARCHAR2 IS
2852:
2853: l_ps_tab ps_tab_type;
2854: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2855:
2856: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
2857: SELECT *
2858: FROM AR_TRX_SUMMARY_HIST

Line 2858: FROM AR_TRX_SUMMARY_HIST

2854: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
2855:
2856: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
2857: SELECT *
2858: FROM AR_TRX_SUMMARY_HIST
2859: WHERE customer_trx_id = p_cust_trx_id
2860: and nvl(complete_flag,'N') = 'N'
2861: and amount_due_original is not null
2862: for update;

Line 2881: l_history_rec ar_trx_summary_hist%rowtype;

2877: l_security_gr_id NUMBER;
2878: l_counter NUMBER;
2879: l_history_exists_flag BOOLEAN;
2880: l_ps_exists BOOLEAN;
2881: l_history_rec ar_trx_summary_hist%rowtype;
2882: BEGIN
2883:
2884: IF pg_debug = 'Y'
2885: THEN

Line 2941: UPDATE ar_trx_summary_hist

2937: --Update the transaction history table
2938: --set the complete_flag = 'Y'
2939: --if history records exist.
2940: --
2941: UPDATE ar_trx_summary_hist
2942: set complete_flag = 'Y',
2943: LAST_UPDATE_DATE = sysdate,
2944: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2945: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3105: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

3101: , p_event IN OUT NOCOPY WF_EVENT_T
3102: )
3103: RETURN VARCHAR2 IS
3104: l_ps_tab ps_tab_type;
3105: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3106:
3107: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
3108: SELECT *
3109: FROM AR_TRX_SUMMARY_HIST

Line 3109: FROM AR_TRX_SUMMARY_HIST

3105: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3106:
3107: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
3108: SELECT *
3109: FROM AR_TRX_SUMMARY_HIST
3110: WHERE history_id = p_hist_id;
3111: -- and nvl(complete_flag,'N') = 'N';
3112:
3113:

Line 3126: l_history_rec ar_trx_summary_hist%rowtype;

3122: l_security_gr_id NUMBER;
3123: l_counter NUMBER;
3124: l_history_exists_flag BOOLEAN;
3125: l_ps_exists BOOLEAN;
3126: l_history_rec ar_trx_summary_hist%rowtype;
3127: l_tot_inv_amt NUMBER;
3128: l_inv_inst_count NUMBER;
3129: l_larg_inv_cust_trx_id NUMBER;
3130: l_text VARCHAR2(2000);

Line 3180: UPDATE ar_trx_summary_hist

3176: --
3177: -- Update the transaction history table set the complete_flag = 'Y'
3178: -- if history records exist.
3179: --
3180: UPDATE ar_trx_summary_hist
3181: set complete_flag = 'Y',
3182: LAST_UPDATE_DATE = sysdate,
3183: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3184: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3298: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

3294: )
3295: RETURN VARCHAR2 IS
3296:
3297: l_ps_rec AR_PAYMENT_SCHEDULES%rowtype;
3298: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3299:
3300: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
3301: SELECT *
3302: FROM AR_TRX_SUMMARY_HIST

Line 3302: FROM AR_TRX_SUMMARY_HIST

3298: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3299:
3300: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
3301: SELECT *
3302: FROM AR_TRX_SUMMARY_HIST
3303: WHERE customer_trx_id = p_cust_trx_id
3304: and nvl(complete_flag,'N') = 'N'
3305: and amount_due_original is not null
3306: for update;

Line 3326: l_history_rec ar_trx_summary_hist%rowtype;

3322: l_security_gr_id NUMBER;
3323: l_counter NUMBER;
3324: l_history_exists_flag BOOLEAN;
3325: l_ps_exists BOOLEAN;
3326: l_history_rec ar_trx_summary_hist%rowtype;
3327: l_tot_inv_amt NUMBER;
3328: l_inv_inst_count NUMBER;
3329: BEGIN
3330: IF pg_debug = 'Y'

Line 3386: UPDATE ar_trx_summary_hist

3382: --Update the transaction history table
3383: --set the complete_flag = 'Y'
3384: --if history records exist.
3385: --
3386: UPDATE ar_trx_summary_hist
3387: set complete_flag = 'Y',
3388: LAST_UPDATE_DATE = sysdate,
3389: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3390: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3688: --we would stamp the complete_flag on the ar_trx_summary_hist

3684: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3685: mo_global.init('AR');
3686: mo_global.set_policy_context('S',l_org_id);
3687:
3688: --we would stamp the complete_flag on the ar_trx_summary_hist
3689: --for any records for this cash receipt. They could be due to
3690: -- receipt deletion or modification.
3691: UPDATE ar_trx_summary_hist
3692: set complete_flag = 'Y',

Line 3691: UPDATE ar_trx_summary_hist

3687:
3688: --we would stamp the complete_flag on the ar_trx_summary_hist
3689: --for any records for this cash receipt. They could be due to
3690: -- receipt deletion or modification.
3691: UPDATE ar_trx_summary_hist
3692: set complete_flag = 'Y',
3693: LAST_UPDATE_DATE = sysdate,
3694: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3695: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3971: UPDATE ar_trx_summary_hist

3967: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3968: mo_global.init('AR');
3969: mo_global.set_policy_context('S',l_org_id);
3970:
3971: UPDATE ar_trx_summary_hist
3972: set complete_flag = 'Y',
3973: LAST_UPDATE_DATE = sysdate,
3974: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3975: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4104: from ar_trx_summary_hist

4100: WHERE payment_schedule_id = p_ps_id;
4101:
4102: CURSOR get_receipt_hist (p_hist_id IN NUMBER) IS
4103: select *
4104: from ar_trx_summary_hist
4105: where history_id = p_hist_id
4106: and nvl(complete_flag ,'N') = 'N'
4107: for update;
4108:

Line 4113: from ar_trx_summary_hist hist,

4109: CURSOR get_receipt_hist2 (p_hist_id IN NUMBER) IS
4110: select ps.cash_receipt_id, ps.trx_date, hist.amount_due_original * -1,
4111: ps.trx_number, hist.customer_id, hist.site_use_id,
4112: ps.invoice_currency_code
4113: from ar_trx_summary_hist hist,
4114: ar_payment_schedules ps
4115: where previous_history_id = p_hist_id
4116: and ps.payment_schedule_id = hist.payment_schedule_id;
4117:

Line 4118: l_hist_rec ar_trx_summary_hist%rowtype;

4114: ar_payment_schedules ps
4115: where previous_history_id = p_hist_id
4116: and ps.payment_schedule_id = hist.payment_schedule_id;
4117:
4118: l_hist_rec ar_trx_summary_hist%rowtype;
4119: l_hist_rec2 ar_trx_summary_hist%rowtype;
4120: l_receipt_exists VARCHAR2(10);
4121: l_history_id NUMBER;
4122: l_history2_exists_flag VARCHAR2(1);

Line 4119: l_hist_rec2 ar_trx_summary_hist%rowtype;

4115: where previous_history_id = p_hist_id
4116: and ps.payment_schedule_id = hist.payment_schedule_id;
4117:
4118: l_hist_rec ar_trx_summary_hist%rowtype;
4119: l_hist_rec2 ar_trx_summary_hist%rowtype;
4120: l_receipt_exists VARCHAR2(10);
4121: l_history_id NUMBER;
4122: l_history2_exists_flag VARCHAR2(1);
4123: l_history_exists_flag VARCHAR2(1);

Line 4205: UPDATE ar_trx_summary_hist

4201:
4202: END IF;
4203: CLOSE get_receipt_hist;
4204:
4205: UPDATE ar_trx_summary_hist
4206: set complete_flag = 'Y',
4207: LAST_UPDATE_DATE = sysdate,
4208: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4209: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4800: FROM ar_trx_summary_hist

4796: RETURN VARCHAR2
4797: IS
4798: CURSOR hist(ps_id in number) IS
4799: SELECT *
4800: FROM ar_trx_summary_hist
4801: WHERE payment_schedule_id = ps_id;
4802:
4803: CURSOR is_this_last_payment (p_customer_id IN NUMBER,
4804: p_site_use_id IN NUMBER,

Line 4893: UPDATE ar_trx_summary_hist

4889: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4890: mo_global.init('AR');
4891: mo_global.set_policy_context('S',l_org_id);
4892:
4893: UPDATE ar_trx_summary_hist
4894: SET complete_flag = 'Y',
4895: LAST_UPDATE_DATE = sysdate,
4896: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4897: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id