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 1048: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 1051: FROM AR_TRX_SUMMARY_HIST

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

Line 1074: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 1134: UPDATE ar_trx_summary_hist

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

Line 1336: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 1340: FROM AR_TRX_SUMMARY_HIST

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

Line 1368: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 1424: UPDATE ar_trx_summary_hist

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

Line 1601: FROM AR_TRX_SUMMARY_HIST

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

Line 1607: from ar_trx_summary_hist

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

Line 1624: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 1625: l_history_rec2 ar_trx_summary_hist%rowtype;

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

Line 1674: UPDATE ar_trx_summary_hist

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

Line 1824: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 1827: FROM AR_TRX_SUMMARY_HIST

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

Line 1859: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 1933: UPDATE ar_trx_summary_hist

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

Line 2174: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 2178: FROM AR_TRX_SUMMARY_HIST

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

Line 2198: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 2273: UPDATE ar_trx_summary_hist

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

Line 2411: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 2415: FROM AR_TRX_SUMMARY_HIST

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

Line 2438: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 2497: UPDATE ar_trx_summary_hist

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

Line 2660: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 2664: FROM AR_TRX_SUMMARY_HIST

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

Line 2681: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 2733: UPDATE ar_trx_summary_hist

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

Line 2851: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

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

Line 2855: FROM AR_TRX_SUMMARY_HIST

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

Line 2878: l_history_rec ar_trx_summary_hist%rowtype;

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

Line 2937: UPDATE ar_trx_summary_hist

2933: --Update the transaction history table
2934: --set the complete_flag = 'Y'
2935: --if history records exist.
2936: --
2937: UPDATE ar_trx_summary_hist
2938: set complete_flag = 'Y',
2939: LAST_UPDATE_DATE = sysdate,
2940: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2941: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3101: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

3097: , p_event IN OUT NOCOPY WF_EVENT_T
3098: )
3099: RETURN VARCHAR2 IS
3100: l_ps_tab ps_tab_type;
3101: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3102:
3103: CURSOR get_trx_history(p_hist_id IN NUMBER) IS
3104: SELECT *
3105: FROM AR_TRX_SUMMARY_HIST

Line 3105: FROM AR_TRX_SUMMARY_HIST

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

Line 3122: l_history_rec ar_trx_summary_hist%rowtype;

3118: l_security_gr_id NUMBER;
3119: l_counter NUMBER;
3120: l_history_exists_flag BOOLEAN;
3121: l_ps_exists BOOLEAN;
3122: l_history_rec ar_trx_summary_hist%rowtype;
3123: l_tot_inv_amt NUMBER;
3124: l_inv_inst_count NUMBER;
3125: l_larg_inv_cust_trx_id NUMBER;
3126: l_text VARCHAR2(2000);

Line 3176: UPDATE ar_trx_summary_hist

3172: --
3173: -- Update the transaction history table set the complete_flag = 'Y'
3174: -- if history records exist.
3175: --
3176: UPDATE ar_trx_summary_hist
3177: set complete_flag = 'Y',
3178: LAST_UPDATE_DATE = sysdate,
3179: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3180: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 3294: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;

3290: )
3291: RETURN VARCHAR2 IS
3292:
3293: l_ps_rec AR_PAYMENT_SCHEDULES%rowtype;
3294: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
3295:
3296: CURSOR get_trx_history(p_cust_trx_id IN NUMBER) IS
3297: SELECT *
3298: FROM AR_TRX_SUMMARY_HIST

Line 3298: FROM AR_TRX_SUMMARY_HIST

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

Line 3322: l_history_rec ar_trx_summary_hist%rowtype;

3318: l_security_gr_id NUMBER;
3319: l_counter NUMBER;
3320: l_history_exists_flag BOOLEAN;
3321: l_ps_exists BOOLEAN;
3322: l_history_rec ar_trx_summary_hist%rowtype;
3323: l_tot_inv_amt NUMBER;
3324: l_inv_inst_count NUMBER;
3325: BEGIN
3326: IF pg_debug = 'Y'

Line 3381: UPDATE ar_trx_summary_hist

3377: --Update the transaction history table
3378: --set the complete_flag = 'Y'
3379: --if history records exist.
3380: --
3381: UPDATE ar_trx_summary_hist
3382: set complete_flag = 'Y',
3383: LAST_UPDATE_DATE = sysdate,
3384: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3385: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

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

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

Line 3688: UPDATE ar_trx_summary_hist

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

Line 3960: UPDATE ar_trx_summary_hist

3956: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3957: mo_global.init('AR');
3958: mo_global.set_policy_context('S',l_org_id);
3959:
3960: UPDATE ar_trx_summary_hist
3961: set complete_flag = 'Y',
3962: LAST_UPDATE_DATE = sysdate,
3963: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3964: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4093: from ar_trx_summary_hist

4089: WHERE payment_schedule_id = p_ps_id;
4090:
4091: CURSOR get_receipt_hist (p_hist_id IN NUMBER) IS
4092: select *
4093: from ar_trx_summary_hist
4094: where history_id = p_hist_id
4095: and nvl(complete_flag ,'N') = 'N'
4096: for update;
4097:

Line 4102: from ar_trx_summary_hist hist,

4098: CURSOR get_receipt_hist2 (p_hist_id IN NUMBER) IS
4099: select ps.cash_receipt_id, ps.trx_date, hist.amount_due_original,
4100: ps.trx_number, hist.customer_id, hist.site_use_id,
4101: ps.invoice_currency_code
4102: from ar_trx_summary_hist hist,
4103: ar_payment_schedules ps
4104: where previous_history_id = p_hist_id
4105: and ps.payment_schedule_id = hist.payment_schedule_id;
4106:

Line 4107: l_hist_rec ar_trx_summary_hist%rowtype;

4103: ar_payment_schedules ps
4104: where previous_history_id = p_hist_id
4105: and ps.payment_schedule_id = hist.payment_schedule_id;
4106:
4107: l_hist_rec ar_trx_summary_hist%rowtype;
4108: l_hist_rec2 ar_trx_summary_hist%rowtype;
4109: l_receipt_status VARCHAR2(30);
4110: l_receipt_exists VARCHAR2(10);
4111: l_history_id NUMBER;

Line 4108: l_hist_rec2 ar_trx_summary_hist%rowtype;

4104: where previous_history_id = p_hist_id
4105: and ps.payment_schedule_id = hist.payment_schedule_id;
4106:
4107: l_hist_rec ar_trx_summary_hist%rowtype;
4108: l_hist_rec2 ar_trx_summary_hist%rowtype;
4109: l_receipt_status VARCHAR2(30);
4110: l_receipt_exists VARCHAR2(10);
4111: l_history_id NUMBER;
4112: l_history2_exists_flag VARCHAR2(1);

Line 4195: UPDATE ar_trx_summary_hist

4191:
4192: END IF;
4193: CLOSE get_receipt_hist;
4194:
4195: UPDATE ar_trx_summary_hist
4196: set complete_flag = 'Y',
4197: LAST_UPDATE_DATE = sysdate,
4198: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4199: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 4789: FROM ar_trx_summary_hist

4785: RETURN VARCHAR2
4786: IS
4787: CURSOR hist(ps_id in number) IS
4788: SELECT *
4789: FROM ar_trx_summary_hist
4790: WHERE payment_schedule_id = ps_id;
4791:
4792: CURSOR is_this_last_payment (p_customer_id IN NUMBER,
4793: p_site_use_id IN NUMBER,

Line 4882: UPDATE ar_trx_summary_hist

4878: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4879: mo_global.init('AR');
4880: mo_global.set_policy_context('S',l_org_id);
4881:
4882: UPDATE ar_trx_summary_hist
4883: SET complete_flag = 'Y',
4884: LAST_UPDATE_DATE = sysdate,
4885: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4886: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id