[Home] [Help]
116: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0)
117: - DECODE(l_trx_class,'INV',
118: nvl(l_past_due_inv_inst_count,0),0),
119: LAST_UPDATE_DATE = sysdate,
120: LAST_UPDATED_BY = FND_GLOBAL.user_id,
121: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
122: WHERE cust_account_id = l_trx_customer_id
123: and site_use_id = l_trx_site_use_id
124: and currency = l_trx_currency_code
117: - DECODE(l_trx_class,'INV',
118: nvl(l_past_due_inv_inst_count,0),0),
119: LAST_UPDATE_DATE = sysdate,
120: LAST_UPDATED_BY = FND_GLOBAL.user_id,
121: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
122: WHERE cust_account_id = l_trx_customer_id
123: and site_use_id = l_trx_site_use_id
124: and currency = l_trx_currency_code
125: and org_id = l_org_id;
130: + nvl(l_unresolved_cash_value,0),
131: UNRESOLVED_CASH_COUNT = nvl(UNRESOLVED_CASH_COUNT,0) -
132: nvl(l_unresolved_cash_count,0),
133: LAST_UPDATE_DATE = sysdate,
134: LAST_UPDATED_BY = FND_GLOBAL.user_id,
135: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
136: WHERE cust_account_id = l_rcpt_customer_id
137: and site_use_id = l_rcpt_site_use_id
138: and currency = l_rcpt_currency_code
131: UNRESOLVED_CASH_COUNT = nvl(UNRESOLVED_CASH_COUNT,0) -
132: nvl(l_unresolved_cash_count,0),
133: LAST_UPDATE_DATE = sysdate,
134: LAST_UPDATED_BY = FND_GLOBAL.user_id,
135: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
136: WHERE cust_account_id = l_rcpt_customer_id
137: and site_use_id = l_rcpt_site_use_id
138: and currency = l_rcpt_currency_code
139: and org_id = l_org_id;
162: + nvl(l_count_of_inv_inst_paid_late,0),
163: COUNT_OF_DISC_INV_INST = nvl(COUNT_OF_DISC_INV_INST,0) +
164: nvl(l_count_of_disc_inv_inst,0),
165: LAST_UPDATE_DATE = sysdate,
166: LAST_UPDATED_BY = FND_GLOBAL.user_id,
167: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
168: -- DAYS_CREDIT_GRANTED_SUM = nvl(DAYS_CREDIT_GRANTED_SUM)
169: WHERE cust_account_id = l_rcpt_customer_id
170: and site_use_id = l_rcpt_site_use_id
163: COUNT_OF_DISC_INV_INST = nvl(COUNT_OF_DISC_INV_INST,0) +
164: nvl(l_count_of_disc_inv_inst,0),
165: LAST_UPDATE_DATE = sysdate,
166: LAST_UPDATED_BY = FND_GLOBAL.user_id,
167: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
168: -- DAYS_CREDIT_GRANTED_SUM = nvl(DAYS_CREDIT_GRANTED_SUM)
169: WHERE cust_account_id = l_rcpt_customer_id
170: and site_use_id = l_rcpt_site_use_id
171: and currency = l_rcpt_currency_code
342: DECODE(rec.previous_customer_trx_id, null,0,
343: DECODE(rec.prev_trx_type,'DM',
344: -rec.cm_closed_dm_count,0)),0),
345: LAST_UPDATE_DATE = sysdate,
346: LAST_UPDATED_BY = FND_GLOBAL.user_id,
347: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
348: WHERE cust_account_id = rec.customer_id
349: and site_use_id = nvl(rec.customer_site_use_id,-99)
350: and currency = rec.invoice_currency_code
343: DECODE(rec.prev_trx_type,'DM',
344: -rec.cm_closed_dm_count,0)),0),
345: LAST_UPDATE_DATE = sysdate,
346: LAST_UPDATED_BY = FND_GLOBAL.user_id,
347: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
348: WHERE cust_account_id = rec.customer_id
349: and site_use_id = nvl(rec.customer_site_use_id,-99)
350: and currency = rec.invoice_currency_code
351: and org_id = rec.org_id;
376: nvl(rec.customer_site_use_id,-99),
377: rec.org_id,
378: rec.invoice_currency_code,
379: sysdate,
380: fnd_global.user_id,
381: sysdate,
382: fnd_global.user_id,
383: fnd_global.login_id,
384: DECODE(sign(rec.due_date - trunc(sysdate)),-1,0,
378: rec.invoice_currency_code,
379: sysdate,
380: fnd_global.user_id,
381: sysdate,
382: fnd_global.user_id,
383: fnd_global.login_id,
384: DECODE(sign(rec.due_date - trunc(sysdate)),-1,0,
385: rec.amount_due_original),
386: DECODE(rec.class , 'INV' , rec.amount_due_original,
379: sysdate,
380: fnd_global.user_id,
381: sysdate,
382: fnd_global.user_id,
383: fnd_global.login_id,
384: DECODE(sign(rec.due_date - trunc(sysdate)),-1,0,
385: rec.amount_due_original),
386: DECODE(rec.class , 'INV' , rec.amount_due_original,
387: 'CM', decode(rec.previous_customer_trx_id, null,0,
465: (rec.amount_due_original *
466: (rec.due_date - rec.trx_date)),
467: DAYS_CREDIT_GRANTED_SUM),
468: LAST_UPDATE_DATE = sysdate,
469: LAST_UPDATED_BY = FND_GLOBAL.user_id,
470: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
471: WHERE cust_account_id = rec.customer_id
472: AND site_use_id = nvl(rec.customer_site_use_id,-99)
473: AND currency = rec.invoice_currency_code
466: (rec.due_date - rec.trx_date)),
467: DAYS_CREDIT_GRANTED_SUM),
468: LAST_UPDATE_DATE = sysdate,
469: LAST_UPDATED_BY = FND_GLOBAL.user_id,
470: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
471: WHERE cust_account_id = rec.customer_id
472: AND site_use_id = nvl(rec.customer_site_use_id,-99)
473: AND currency = rec.invoice_currency_code
474: AND org_id = rec.org_id
503: rec.org_id,
504: rec.invoice_currency_code,
505: rec.trx_date,
506: sysdate,
507: fnd_global.user_id,
508: sysdate,
509: fnd_global.user_id,
510: fnd_global.login_id,
511: rec.amount_due_original,
505: rec.trx_date,
506: sysdate,
507: fnd_global.user_id,
508: sysdate,
509: fnd_global.user_id,
510: fnd_global.login_id,
511: rec.amount_due_original,
512: rec.amount_due_original,
513: DECODE(rec.class , 'INV',1,null),
506: sysdate,
507: fnd_global.user_id,
508: sysdate,
509: fnd_global.user_id,
510: fnd_global.login_id,
511: rec.amount_due_original,
512: rec.amount_due_original,
513: DECODE(rec.class , 'INV',1,null),
514: DECODE(rec.class , 'INV',
596: nvl(l_past_due_inv_inst_count,0),0),
597: PENDING_ADJ_VALUE = nvl(PENDING_ADJ_VALUE,0)
598: + DECODE(l_special_adj, 'Y', 0, nvl(l_pending_adj_amount,0)),
599: LAST_UPDATE_DATE = sysdate,
600: LAST_UPDATED_BY = FND_GLOBAL.user_id,
601: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
602: WHERE cust_account_id = l_customer_id
603: and site_use_id = l_site_use_id
604: and currency = l_currency_code
597: PENDING_ADJ_VALUE = nvl(PENDING_ADJ_VALUE,0)
598: + DECODE(l_special_adj, 'Y', 0, nvl(l_pending_adj_amount,0)),
599: LAST_UPDATE_DATE = sysdate,
600: LAST_UPDATED_BY = FND_GLOBAL.user_id,
601: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
602: WHERE cust_account_id = l_customer_id
603: and site_use_id = l_site_use_id
604: and currency = l_currency_code
605: and org_id = l_org_id;
631: l_site_use_id,
632: l_org_id,
633: l_currency_code,
634: sysdate,
635: fnd_global.user_id,
636: sysdate,
637: fnd_global.user_id,
638: fnd_global.login_id,
639: +nvl(l_adj_amount,0),
633: l_currency_code,
634: sysdate,
635: fnd_global.user_id,
636: sysdate,
637: fnd_global.user_id,
638: fnd_global.login_id,
639: +nvl(l_adj_amount,0),
640: + DECODE(l_class,'CM',nvl(l_adj_amount,0),0),
641: DECODE(l_class, 'CM', nvl(l_op_trx_count,0),0),
634: sysdate,
635: fnd_global.user_id,
636: sysdate,
637: fnd_global.user_id,
638: fnd_global.login_id,
639: +nvl(l_adj_amount,0),
640: + DECODE(l_class,'CM',nvl(l_adj_amount,0),0),
641: DECODE(l_class, 'CM', nvl(l_op_trx_count,0),0),
642: + DECODE(l_class,'INV',nvl(l_adj_amount,0),0),
657: + DECODE(l_special_adj, 'Y',0, nvl(l_adj_amount,0)),
658: TOTAL_ADJUSTMENTS_COUNT = nvl(TOTAL_ADJUSTMENTS_COUNT,0)
659: + DECODE(l_special_adj, 'Y',0,nvl(l_op_trx_count,0)),
660: LAST_UPDATE_DATE = sysdate,
661: LAST_UPDATED_BY = FND_GLOBAL.user_id,
662: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
663: where cust_account_id = l_customer_id
664: and site_use_id = l_site_use_id
665: and currency = l_currency_code
658: TOTAL_ADJUSTMENTS_COUNT = nvl(TOTAL_ADJUSTMENTS_COUNT,0)
659: + DECODE(l_special_adj, 'Y',0,nvl(l_op_trx_count,0)),
660: LAST_UPDATE_DATE = sysdate,
661: LAST_UPDATED_BY = FND_GLOBAL.user_id,
662: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
663: where cust_account_id = l_customer_id
664: and site_use_id = l_site_use_id
665: and currency = l_currency_code
666: and as_of_date = l_apply_date
689: l_org_id,
690: l_currency_code,
691: l_apply_date,
692: sysdate,
693: fnd_global.user_id,
694: sysdate,
695: fnd_global.user_id,
696: fnd_global.login_id,
697: nvl(l_adj_amount,0),
691: l_apply_date,
692: sysdate,
693: fnd_global.user_id,
694: sysdate,
695: fnd_global.user_id,
696: fnd_global.login_id,
697: nvl(l_adj_amount,0),
698: nvl(l_op_trx_count,0),
699: nvl(l_adj_amount,0) );
692: sysdate,
693: fnd_global.user_id,
694: sysdate,
695: fnd_global.user_id,
696: fnd_global.login_id,
697: nvl(l_adj_amount,0),
698: nvl(l_op_trx_count,0),
699: nvl(l_adj_amount,0) );
700: END IF;
844: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
845: i.receipt_amount,
846: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,
847: LAST_UPDATE_DATE = sysdate,
848: LAST_UPDATED_BY = FND_GLOBAL.user_id,
849: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
850: where cust_account_id = i.customer_id
851: and site_use_id = nvl(i.site_use_id,-99)
852: and org_id = p_org_id
845: i.receipt_amount,
846: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,
847: LAST_UPDATE_DATE = sysdate,
848: LAST_UPDATED_BY = FND_GLOBAL.user_id,
849: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
850: where cust_account_id = i.customer_id
851: and site_use_id = nvl(i.site_use_id,-99)
852: and org_id = p_org_id
853: and currency = i.rcpt_currency
873: p_org_id,
874: i.rcpt_currency,
875: i.as_of_date,
876: sysdate,
877: fnd_global.user_id,
878: sysdate,
879: fnd_global.user_id,
880: fnd_global.login_id,
881: i.receipt_amount,
875: i.as_of_date,
876: sysdate,
877: fnd_global.user_id,
878: sysdate,
879: fnd_global.user_id,
880: fnd_global.login_id,
881: i.receipt_amount,
882: 1);
883: END IF;
876: sysdate,
877: fnd_global.user_id,
878: sysdate,
879: fnd_global.user_id,
880: fnd_global.login_id,
881: i.receipt_amount,
882: 1);
883: END IF;
884:
894: -1,last_payment_date,i.last_payment_date),
895: last_payment_number = decode(sign(i.last_payment_date-last_payment_date),
896: -1,last_payment_number,i.last_payment_number),
897: LAST_UPDATE_DATE = sysdate,
898: LAST_UPDATED_BY = FND_GLOBAL.user_id,
899: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
900: where cust_account_id = i.customer_id
901: and site_use_id = nvl(i.site_use_id,-99)
902: and org_id = p_org_id
895: last_payment_number = decode(sign(i.last_payment_date-last_payment_date),
896: -1,last_payment_number,i.last_payment_number),
897: LAST_UPDATE_DATE = sysdate,
898: LAST_UPDATED_BY = FND_GLOBAL.user_id,
899: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
900: where cust_account_id = i.customer_id
901: and site_use_id = nvl(i.site_use_id,-99)
902: and org_id = p_org_id
903: and currency = i.rcpt_currency;
921: nvl(i.site_use_id,-99),
922: p_org_id,
923: i.rcpt_currency,
924: sysdate,
925: fnd_global.user_id,
926: sysdate,
927: fnd_global.user_id,
928: fnd_global.login_id,
929: i.last_payment_amount,
923: i.rcpt_currency,
924: sysdate,
925: fnd_global.user_id,
926: sysdate,
927: fnd_global.user_id,
928: fnd_global.login_id,
929: i.last_payment_amount,
930: i.last_payment_date,
931: i.last_payment_number
924: sysdate,
925: fnd_global.user_id,
926: sysdate,
927: fnd_global.user_id,
928: fnd_global.login_id,
929: i.last_payment_amount,
930: i.last_payment_date,
931: i.last_payment_number
932: );
960: + nvl(i.count_of_inv_inst_paid_late,0),
961: count_of_disc_inv_inst = nvl(count_of_disc_inv_inst,0) +
962: nvl(i.count_of_disc_inv_inst,0),
963: LAST_UPDATE_DATE = sysdate,
964: LAST_UPDATED_BY = FND_GLOBAL.user_id,
965: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
966: WHERE cust_account_id = i.trx_customer_id
967: and site_use_id = i.trx_site_use_id
968: and currency = i.trx_currency
961: count_of_disc_inv_inst = nvl(count_of_disc_inv_inst,0) +
962: nvl(i.count_of_disc_inv_inst,0),
963: LAST_UPDATE_DATE = sysdate,
964: LAST_UPDATED_BY = FND_GLOBAL.user_id,
965: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
966: WHERE cust_account_id = i.trx_customer_id
967: and site_use_id = i.trx_site_use_id
968: and currency = i.trx_currency
969: and as_of_date = i.apply_date
1098: SAVEPOINT Inv_Complete_Event;
1099: --
1100: --set the application context.
1101: --
1102: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1103: mo_global.init('AR');
1104: mo_global.set_policy_context('S',l_org_id);
1105: --
1106: -- Acquire locks on the payment schedule record so that
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
1139: WHERE customer_trx_id = l_customer_trx_id
1140: and nvl(complete_flag,'N') = 'N';
1141:
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
1139: WHERE customer_trx_id = l_customer_trx_id
1140: and nvl(complete_flag,'N') = 'N';
1141:
1142:
1175: +nvl(l_ps_tab(j).amount_adjusted,0)),0),
1176: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0) +
1177: decode(sign(l_ps_tab(j).due_date - trunc(sysdate)),-1,1,0),
1178: LAST_UPDATE_DATE = sysdate,
1179: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1180: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1181: WHERE cust_account_id = l_ps_tab(j).customer_id
1182: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
1183: and currency = l_ps_tab(j).invoice_currency_code
1176: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0) +
1177: decode(sign(l_ps_tab(j).due_date - trunc(sysdate)),-1,1,0),
1178: LAST_UPDATE_DATE = sysdate,
1179: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1180: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1181: WHERE cust_account_id = l_ps_tab(j).customer_id
1182: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
1183: and currency = l_ps_tab(j).invoice_currency_code
1184: and org_id = l_org_id;
1205: nvl(l_ps_tab(j).customer_site_use_id,-99),
1206: l_org_id,
1207: l_ps_tab(j).invoice_currency_code,
1208: sysdate,
1209: fnd_global.user_id,
1210: sysdate,
1211: fnd_global.user_id,
1212: fnd_global.login_id,
1213: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
1207: l_ps_tab(j).invoice_currency_code,
1208: sysdate,
1209: fnd_global.user_id,
1210: sysdate,
1211: fnd_global.user_id,
1212: fnd_global.login_id,
1213: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
1214: (l_ps_tab(j).amount_due_original
1215: +nvl(l_ps_tab(j).amount_adjusted,0))),
1208: sysdate,
1209: fnd_global.user_id,
1210: sysdate,
1211: fnd_global.user_id,
1212: fnd_global.login_id,
1213: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
1214: (l_ps_tab(j).amount_due_original
1215: +nvl(l_ps_tab(j).amount_adjusted,0))),
1216: l_ps_tab(j).amount_due_original+nvl(l_ps_tab(j).amount_adjusted,0),
1246: + nvl(l_ps_tab(j).amount_adjusted,0))
1247: * (l_ps_tab(j).due_date
1248: - l_ps_tab(j).trx_date)),
1249: LAST_UPDATE_DATE = sysdate,
1250: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1251: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1252: WHERE cust_account_id = l_ps_tab(j).customer_id
1253: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
1254: and currency = l_ps_tab(j).invoice_currency_code
1247: * (l_ps_tab(j).due_date
1248: - l_ps_tab(j).trx_date)),
1249: LAST_UPDATE_DATE = sysdate,
1250: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1251: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1252: WHERE cust_account_id = l_ps_tab(j).customer_id
1253: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
1254: and currency = l_ps_tab(j).invoice_currency_code
1255: and org_id = l_org_id
1281: l_org_id,
1282: l_ps_tab(j).invoice_currency_code,
1283: l_ps_tab(j).trx_date,
1284: sysdate,
1285: fnd_global.user_id,
1286: sysdate,
1287: fnd_global.user_id,
1288: fnd_global.login_id,
1289: l_ps_tab(j).amount_due_original+
1283: l_ps_tab(j).trx_date,
1284: sysdate,
1285: fnd_global.user_id,
1286: sysdate,
1287: fnd_global.user_id,
1288: fnd_global.login_id,
1289: l_ps_tab(j).amount_due_original+
1290: nvl(l_ps_tab(j).amount_adjusted,0),
1291: l_ps_tab(j).amount_due_original,
1284: sysdate,
1285: fnd_global.user_id,
1286: sysdate,
1287: fnd_global.user_id,
1288: fnd_global.login_id,
1289: l_ps_tab(j).amount_due_original+
1290: nvl(l_ps_tab(j).amount_adjusted,0),
1291: l_ps_tab(j).amount_due_original,
1292: 1,
1403: END IF;
1404: --
1405: --set the application context.
1406: --
1407: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1408: mo_global.init('AR');
1409: mo_global.set_policy_context('S',l_org_id);
1410: --
1411: -- No need to acquire locks on the payment schedule record
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
1429: WHERE payment_schedule_id = l_payment_schedule_id
1430: and history_id = l_history_id
1431: and nvl(complete_flag,'N') = 'N';
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
1429: WHERE payment_schedule_id = l_payment_schedule_id
1430: and history_id = l_history_id
1431: and nvl(complete_flag,'N') = 'N';
1432:
1465: +nvl(l_history_rec.amount_adjusted,0)),0)),
1466: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0) -
1467: decode(sign(l_history_rec.due_date - trunc(sysdate)),-1,1,0),
1468: LAST_UPDATE_DATE = sysdate,
1469: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1470: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1471: WHERE cust_account_id = l_history_rec.customer_id
1472: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1473: and currency = l_history_rec.currency_code
1466: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0) -
1467: decode(sign(l_history_rec.due_date - trunc(sysdate)),-1,1,0),
1468: LAST_UPDATE_DATE = sysdate,
1469: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1470: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1471: WHERE cust_account_id = l_history_rec.customer_id
1472: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1473: and currency = l_history_rec.currency_code
1474: and org_id = l_org_id;
1557: + l_history_rec.amount_adjusted)
1558: * (l_history_rec.due_date
1559: - l_history_rec.trx_date)),
1560: LAST_UPDATE_DATE = sysdate,
1561: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1562: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1563: WHERE cust_account_id = l_history_rec.customer_id
1564: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1565: and currency = l_history_rec.currency_code
1558: * (l_history_rec.due_date
1559: - l_history_rec.trx_date)),
1560: LAST_UPDATE_DATE = sysdate,
1561: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1562: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1563: WHERE cust_account_id = l_history_rec.customer_id
1564: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1565: and currency = l_history_rec.currency_code
1566: and org_id = l_org_id
1655: Savepoint Inv_Modify_Event;
1656: --
1657: --set the application context.
1658: --
1659: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1660: mo_global.init('AR');
1661: mo_global.set_policy_context('S',l_org_id);
1662: --Stamp the history record for the modification.
1663: /*bug#5484606-------------------------------------------------------------------+
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
1679: WHERE payment_schedule_id = l_payment_schedule_id
1680: and history_id = l_history_id
1681: and nvl(complete_flag,'N') = 'N';
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
1679: WHERE payment_schedule_id = l_payment_schedule_id
1680: and history_id = l_history_id
1681: and nvl(complete_flag,'N') = 'N';
1682:
1751: - nvl(l_history_rec.amount_in_dispute,0)),
1752: DISPUTED_INV_COUNT = nvl(DISPUTED_INV_COUNT,0)
1753: + nvl(l_inv_dispute_count,0),
1754: LAST_UPDATE_DATE = sysdate,
1755: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1756: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1757: WHERE cust_account_id = l_history_rec.customer_id
1758: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1759: and currency = l_history_rec.currency_code
1752: DISPUTED_INV_COUNT = nvl(DISPUTED_INV_COUNT,0)
1753: + nvl(l_inv_dispute_count,0),
1754: LAST_UPDATE_DATE = sysdate,
1755: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1756: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1757: WHERE cust_account_id = l_history_rec.customer_id
1758: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1759: and currency = l_history_rec.currency_code
1760: and org_id = l_org_id;
1764: ((l_history_rec.amount_due_original
1765: + l_history_rec.amount_adjusted)
1766: * (l_history_rec2.due_date -l_history_rec.due_date)),
1767: LAST_UPDATE_DATE = sysdate,
1768: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1769: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1770: WHERE cust_account_id = l_history_rec.customer_id
1771: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1772: and currency = l_history_rec.currency_code
1765: + l_history_rec.amount_adjusted)
1766: * (l_history_rec2.due_date -l_history_rec.due_date)),
1767: LAST_UPDATE_DATE = sysdate,
1768: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1769: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1770: WHERE cust_account_id = l_history_rec.customer_id
1771: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1772: and currency = l_history_rec.currency_code
1773: and org_id = l_org_id
1896: END IF;
1897: --
1898: --set the application context.
1899: --
1900: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1901: mo_global.init('AR');
1902: mo_global.set_policy_context('S',l_org_id);
1903: --
1904: -- Acquire locks on the payment schedule record so that
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
1938: WHERE customer_trx_id = l_customer_trx_id
1939: and nvl(complete_flag,'N') = 'N';
1940:
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
1938: WHERE customer_trx_id = l_customer_trx_id
1939: and nvl(complete_flag,'N') = 'N';
1940:
1941:
2012: + nvl(l_past_due_inv_amt,0),
2013: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0)
2014: + nvl(l_past_due_inv_count,0),
2015: LAST_UPDATE_DATE = sysdate,
2016: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2017: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2018: WHERE cust_account_id = l_ps_rec.customer_id
2019: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
2020: and currency = l_ps_rec.invoice_currency_code
2013: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0)
2014: + nvl(l_past_due_inv_count,0),
2015: LAST_UPDATE_DATE = sysdate,
2016: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2017: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2018: WHERE cust_account_id = l_ps_rec.customer_id
2019: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
2020: and currency = l_ps_rec.invoice_currency_code
2021: and org_id = l_org_id;
2051: nvl(l_ps_rec.customer_site_use_id,-99),
2052: l_org_id,
2053: l_ps_rec.invoice_currency_code,
2054: sysdate,
2055: fnd_global.user_id,
2056: sysdate,
2057: fnd_global.user_id,
2058: fnd_global.login_id,
2059: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
2053: l_ps_rec.invoice_currency_code,
2054: sysdate,
2055: fnd_global.user_id,
2056: sysdate,
2057: fnd_global.user_id,
2058: fnd_global.login_id,
2059: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
2060: l_ps_rec.amount_due_original),
2061: DECODE(l_prev_ctx_id, null, l_ps_rec.amount_due_original,
2054: sysdate,
2055: fnd_global.user_id,
2056: sysdate,
2057: fnd_global.user_id,
2058: fnd_global.login_id,
2059: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
2060: l_ps_rec.amount_due_original),
2061: DECODE(l_prev_ctx_id, null, l_ps_rec.amount_due_original,
2062: DECODE(l_prev_trx_class,'CM',l_ps_rec.amount_due_original,0)),
2093: TOTAL_CREDIT_MEMOS_VALUE = nvl(TOTAL_CREDIT_MEMOS_VALUE,0) +
2094: l_ps_rec.amount_due_original,
2095: TOTAL_CREDIT_MEMOS_COUNT = nvl(TOTAL_CREDIT_MEMOS_COUNT,0) + 1,
2096: LAST_UPDATE_DATE = sysdate,
2097: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2098: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2099: WHERE cust_account_id = l_ps_rec.customer_id
2100: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
2101: and currency = l_ps_rec.invoice_currency_code
2094: l_ps_rec.amount_due_original,
2095: TOTAL_CREDIT_MEMOS_COUNT = nvl(TOTAL_CREDIT_MEMOS_COUNT,0) + 1,
2096: LAST_UPDATE_DATE = sysdate,
2097: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2098: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2099: WHERE cust_account_id = l_ps_rec.customer_id
2100: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
2101: and currency = l_ps_rec.invoice_currency_code
2102: and org_id = l_org_id
2125: l_org_id,
2126: l_ps_rec.invoice_currency_code,
2127: l_ps_rec.trx_date,
2128: sysdate,
2129: fnd_global.user_id,
2130: sysdate,
2131: fnd_global.user_id,
2132: fnd_global.login_id,
2133: l_ps_rec.amount_due_original+
2127: l_ps_rec.trx_date,
2128: sysdate,
2129: fnd_global.user_id,
2130: sysdate,
2131: fnd_global.user_id,
2132: fnd_global.login_id,
2133: l_ps_rec.amount_due_original+
2134: nvl(l_ps_rec.amount_adjusted,0),
2135: l_ps_rec.amount_due_original,
2128: sysdate,
2129: fnd_global.user_id,
2130: sysdate,
2131: fnd_global.user_id,
2132: fnd_global.login_id,
2133: l_ps_rec.amount_due_original+
2134: nvl(l_ps_rec.amount_adjusted,0),
2135: l_ps_rec.amount_due_original,
2136: 1
2251: SAVEPOINT CM_InComplete_Event;
2252: --
2253: --set the application context.
2254: --
2255: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2256: mo_global.init('AR');
2257: mo_global.set_policy_context('S',l_org_id);
2258:
2259: --
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
2278: WHERE payment_schedule_id = l_payment_schedule_id
2279: and history_id = l_history_id
2280: and nvl(complete_flag,'N') = 'N';
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
2278: WHERE payment_schedule_id = l_payment_schedule_id
2279: and history_id = l_history_id
2280: and nvl(complete_flag,'N') = 'N';
2281:
2346: - nvl(l_past_due_inv_amt,0),
2347: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0)
2348: - nvl(l_past_due_inv_count,0),
2349: LAST_UPDATE_DATE = sysdate,
2350: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2351: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2352: WHERE cust_account_id = l_history_rec.customer_id
2353: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2354: and currency = l_history_rec.currency_code
2347: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0)
2348: - nvl(l_past_due_inv_count,0),
2349: LAST_UPDATE_DATE = sysdate,
2350: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2351: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2352: WHERE cust_account_id = l_history_rec.customer_id
2353: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2354: and currency = l_history_rec.currency_code
2355: and org_id = l_org_id;
2363: TOTAL_CREDIT_MEMOS_VALUE = nvl(TOTAL_CREDIT_MEMOS_VALUE,0) -
2364: l_history_rec.amount_due_original,
2365: TOTAL_CREDIT_MEMOS_COUNT = nvl(TOTAL_CREDIT_MEMOS_COUNT,0) - 1,
2366: LAST_UPDATE_DATE = sysdate,
2367: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2368: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2369: WHERE cust_account_id = l_history_rec.customer_id
2370: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2371: and currency = l_history_rec.currency_code
2364: l_history_rec.amount_due_original,
2365: TOTAL_CREDIT_MEMOS_COUNT = nvl(TOTAL_CREDIT_MEMOS_COUNT,0) - 1,
2366: LAST_UPDATE_DATE = sysdate,
2367: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2368: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2369: WHERE cust_account_id = l_history_rec.customer_id
2370: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2371: and currency = l_history_rec.currency_code
2372: and org_id = l_org_id
2460: SAVEPOINT DM_Complete_Event;
2461: --
2462: --set the application context.
2463: --
2464: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2465: mo_global.init('AR');
2466: mo_global.set_policy_context('S',l_org_id);
2467:
2468: --
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
2502: WHERE customer_trx_id = l_customer_trx_id
2503: and nvl(complete_flag,'N') = 'N';
2504:
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
2502: WHERE customer_trx_id = l_customer_trx_id
2503: and nvl(complete_flag,'N') = 'N';
2504:
2505:
2528: = nvl(OP_DEBIT_MEMOS_VALUE,0)
2529: +l_ps_tab(j).amount_due_original,
2530: OP_DEBIT_MEMOS_COUNT = nvl(OP_DEBIT_MEMOS_COUNT,0) + 1,
2531: LAST_UPDATE_DATE = sysdate,
2532: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2533: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2534: WHERE cust_account_id = l_ps_tab(j).customer_id
2535: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2536: and currency = l_ps_tab(j).invoice_currency_code
2529: +l_ps_tab(j).amount_due_original,
2530: OP_DEBIT_MEMOS_COUNT = nvl(OP_DEBIT_MEMOS_COUNT,0) + 1,
2531: LAST_UPDATE_DATE = sysdate,
2532: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2533: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2534: WHERE cust_account_id = l_ps_tab(j).customer_id
2535: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2536: and currency = l_ps_tab(j).invoice_currency_code
2537: and org_id = l_org_id;
2557: nvl(l_ps_tab(j).customer_site_use_id,-99),
2558: l_org_id,
2559: l_ps_tab(j).invoice_currency_code,
2560: sysdate,
2561: fnd_global.user_id,
2562: sysdate,
2563: fnd_global.user_id,
2564: fnd_global.login_id,
2565: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
2559: l_ps_tab(j).invoice_currency_code,
2560: sysdate,
2561: fnd_global.user_id,
2562: sysdate,
2563: fnd_global.user_id,
2564: fnd_global.login_id,
2565: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
2566: l_ps_tab(j).amount_due_original),
2567: l_ps_tab(j).amount_due_original,
2560: sysdate,
2561: fnd_global.user_id,
2562: sysdate,
2563: fnd_global.user_id,
2564: fnd_global.login_id,
2565: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
2566: l_ps_tab(j).amount_due_original),
2567: l_ps_tab(j).amount_due_original,
2568: 1
2579: TOTAL_DEBIT_MEMOS_VALUE = nvl(TOTAL_DEBIT_MEMOS_VALUE,0) +
2580: l_ps_tab(j).amount_due_original,
2581: TOTAL_DEBIT_MEMOS_COUNT = nvl(TOTAL_DEBIT_MEMOS_COUNT,0) + 1,
2582: LAST_UPDATE_DATE = sysdate,
2583: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2584: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2585: WHERE cust_account_id = l_ps_tab(j).customer_id
2586: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2587: and currency = l_ps_tab(j).invoice_currency_code
2580: l_ps_tab(j).amount_due_original,
2581: TOTAL_DEBIT_MEMOS_COUNT = nvl(TOTAL_DEBIT_MEMOS_COUNT,0) + 1,
2582: LAST_UPDATE_DATE = sysdate,
2583: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2584: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2585: WHERE cust_account_id = l_ps_tab(j).customer_id
2586: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2587: and currency = l_ps_tab(j).invoice_currency_code
2588: and org_id = l_org_id
2611: l_org_id,
2612: l_ps_tab(j).invoice_currency_code,
2613: l_ps_tab(j).trx_date,
2614: sysdate,
2615: fnd_global.user_id,
2616: sysdate,
2617: fnd_global.user_id,
2618: fnd_global.login_id,
2619: l_ps_tab(j).amount_due_original,
2613: l_ps_tab(j).trx_date,
2614: sysdate,
2615: fnd_global.user_id,
2616: sysdate,
2617: fnd_global.user_id,
2618: fnd_global.login_id,
2619: l_ps_tab(j).amount_due_original,
2620: l_ps_tab(j).amount_due_original,
2621: 1
2614: sysdate,
2615: fnd_global.user_id,
2616: sysdate,
2617: fnd_global.user_id,
2618: fnd_global.login_id,
2619: l_ps_tab(j).amount_due_original,
2620: l_ps_tab(j).amount_due_original,
2621: 1
2622: );
2712: END IF;
2713: --
2714: --set the application context.
2715: --
2716: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2717: mo_global.init('AR');
2718: mo_global.set_policy_context('S',l_org_id);
2719: --
2720: -- No need to acquire locks on the payment schedule record
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
2738: WHERE payment_schedule_id = l_payment_schedule_id
2739: and history_id = l_history_id
2740: and nvl(complete_flag,'N') = 'N';
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
2738: WHERE payment_schedule_id = l_payment_schedule_id
2739: and history_id = l_history_id
2740: and nvl(complete_flag,'N') = 'N';
2741:
2766: = nvl(OP_DEBIT_MEMOS_VALUE,0)
2767: -l_history_rec.amount_due_original,
2768: OP_DEBIT_MEMOS_COUNT = nvl(OP_DEBIT_MEMOS_COUNT,0) - 1,
2769: LAST_UPDATE_DATE = sysdate,
2770: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2771: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2772: WHERE cust_account_id = l_history_rec.customer_id
2773: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2774: and currency = l_history_rec.currency_code
2767: -l_history_rec.amount_due_original,
2768: OP_DEBIT_MEMOS_COUNT = nvl(OP_DEBIT_MEMOS_COUNT,0) - 1,
2769: LAST_UPDATE_DATE = sysdate,
2770: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2771: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2772: WHERE cust_account_id = l_history_rec.customer_id
2773: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2774: and currency = l_history_rec.currency_code
2775: and org_id = l_org_id;
2789: TOTAL_DEBIT_MEMOS_VALUE = nvl(TOTAL_DEBIT_MEMOS_VALUE,0) -
2790: l_history_rec.amount_due_original,
2791: TOTAL_DEBIT_MEMOS_COUNT = nvl(TOTAL_DEBIT_MEMOS_COUNT,0) - 1,
2792: LAST_UPDATE_DATE = sysdate,
2793: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2794: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2795: WHERE cust_account_id = l_history_rec.customer_id
2796: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2797: and currency = l_history_rec.currency_code
2790: l_history_rec.amount_due_original,
2791: TOTAL_DEBIT_MEMOS_COUNT = nvl(TOTAL_DEBIT_MEMOS_COUNT,0) - 1,
2792: LAST_UPDATE_DATE = sysdate,
2793: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2794: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2795: WHERE cust_account_id = l_history_rec.customer_id
2796: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2797: and currency = l_history_rec.currency_code
2798: and org_id = l_org_id
2900: END IF;
2901: --
2902: --set the application context.
2903: --
2904: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2905: mo_global.init('AR');
2906: mo_global.set_policy_context('S',l_org_id);
2907:
2908: --
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
2942: WHERE customer_trx_id = l_customer_trx_id
2943: and nvl(complete_flag,'N') = 'N';
2944:
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
2942: WHERE customer_trx_id = l_customer_trx_id
2943: and nvl(complete_flag,'N') = 'N';
2944:
2945:
2969: +l_ps_tab(j).amount_due_original
2970: +nvl(l_ps_tab(j).amount_adjusted,0),
2971: OP_DEPOSITS_COUNT = nvl(OP_DEPOSITS_COUNT,0) + 1,
2972: LAST_UPDATE_DATE = sysdate,
2973: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2974: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2975: WHERE cust_account_id = l_ps_tab(j).customer_id
2976: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2977: and currency = l_ps_tab(j).invoice_currency_code
2970: +nvl(l_ps_tab(j).amount_adjusted,0),
2971: OP_DEPOSITS_COUNT = nvl(OP_DEPOSITS_COUNT,0) + 1,
2972: LAST_UPDATE_DATE = sysdate,
2973: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2974: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2975: WHERE cust_account_id = l_ps_tab(j).customer_id
2976: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2977: and currency = l_ps_tab(j).invoice_currency_code
2978: and org_id = l_org_id;
2998: nvl(l_ps_tab(j).customer_site_use_id,-99),
2999: l_org_id,
3000: l_ps_tab(j).invoice_currency_code,
3001: sysdate,
3002: fnd_global.user_id,
3003: sysdate,
3004: fnd_global.user_id,
3005: fnd_global.login_id,
3006: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
3000: l_ps_tab(j).invoice_currency_code,
3001: sysdate,
3002: fnd_global.user_id,
3003: sysdate,
3004: fnd_global.user_id,
3005: fnd_global.login_id,
3006: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
3007: l_ps_tab(j).amount_due_original),
3008: l_ps_tab(j).amount_due_original,
3001: sysdate,
3002: fnd_global.user_id,
3003: sysdate,
3004: fnd_global.user_id,
3005: fnd_global.login_id,
3006: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
3007: l_ps_tab(j).amount_due_original),
3008: l_ps_tab(j).amount_due_original,
3009: 1
3021: TOTAL_DEPOSITS_VALUE = nvl(TOTAL_DEPOSITS_VALUE,0) +
3022: l_ps_tab(j).amount_due_original,
3023: TOTAL_DEPOSITS_COUNT = nvl(TOTAL_DEPOSITS_COUNT,0) + 1,
3024: LAST_UPDATE_DATE = sysdate,
3025: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3026: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3027: WHERE cust_account_id = l_ps_tab(j).customer_id
3028: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
3029: and currency = l_ps_tab(j).invoice_currency_code
3022: l_ps_tab(j).amount_due_original,
3023: TOTAL_DEPOSITS_COUNT = nvl(TOTAL_DEPOSITS_COUNT,0) + 1,
3024: LAST_UPDATE_DATE = sysdate,
3025: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3026: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3027: WHERE cust_account_id = l_ps_tab(j).customer_id
3028: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
3029: and currency = l_ps_tab(j).invoice_currency_code
3030: and org_id = l_org_id
3053: l_org_id,
3054: l_ps_tab(j).invoice_currency_code,
3055: l_ps_tab(j).trx_date,
3056: sysdate,
3057: fnd_global.user_id,
3058: sysdate,
3059: fnd_global.user_id,
3060: fnd_global.login_id,
3061: l_ps_tab(j).amount_due_original+
3055: l_ps_tab(j).trx_date,
3056: sysdate,
3057: fnd_global.user_id,
3058: sysdate,
3059: fnd_global.user_id,
3060: fnd_global.login_id,
3061: l_ps_tab(j).amount_due_original+
3062: nvl(l_ps_tab(j).amount_adjusted,0),
3063: l_ps_tab(j).amount_due_original,
3056: sysdate,
3057: fnd_global.user_id,
3058: sysdate,
3059: fnd_global.user_id,
3060: fnd_global.login_id,
3061: l_ps_tab(j).amount_due_original+
3062: nvl(l_ps_tab(j).amount_adjusted,0),
3063: l_ps_tab(j).amount_due_original,
3064: 1
3154: SAVEPOINT Dep_InComplete_Event;
3155: --
3156: --set the application context.
3157: --
3158: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3159: mo_global.init('AR');
3160: mo_global.set_policy_context('S',l_org_id);
3161:
3162: --
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
3181: WHERE payment_schedule_id = l_payment_schedule_id
3182: and history_id = l_history_id
3183: and nvl(complete_flag,'N') = 'N';
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
3181: WHERE payment_schedule_id = l_payment_schedule_id
3182: and history_id = l_history_id
3183: and nvl(complete_flag,'N') = 'N';
3184:
3209: = nvl(OP_DEPOSITS_VALUE,0)
3210: -l_history_rec.amount_due_original,
3211: OP_DEPOSITS_COUNT = nvl(OP_DEPOSITS_COUNT,0) - 1,
3212: LAST_UPDATE_DATE = sysdate,
3213: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3214: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3215: WHERE cust_account_id = l_history_rec.customer_id
3216: and site_use_id = nvl(l_history_rec.site_use_id,-99)
3217: and currency = l_history_rec.currency_code
3210: -l_history_rec.amount_due_original,
3211: OP_DEPOSITS_COUNT = nvl(OP_DEPOSITS_COUNT,0) - 1,
3212: LAST_UPDATE_DATE = sysdate,
3213: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3214: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3215: WHERE cust_account_id = l_history_rec.customer_id
3216: and site_use_id = nvl(l_history_rec.site_use_id,-99)
3217: and currency = l_history_rec.currency_code
3218: and org_id = l_org_id;
3232: TOTAL_DEPOSITS_VALUE = nvl(TOTAL_DEPOSITS_VALUE,0) -
3233: l_history_rec.amount_due_original,
3234: TOTAL_DEPOSITS_COUNT = nvl(TOTAL_DEPOSITS_COUNT,0) - 1,
3235: LAST_UPDATE_DATE = sysdate,
3236: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3237: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3238: WHERE cust_account_id = l_history_rec.customer_id
3239: and site_use_id = nvl(l_history_rec.site_use_id,-99)
3240: and currency = l_history_rec.currency_code
3233: l_history_rec.amount_due_original,
3234: TOTAL_DEPOSITS_COUNT = nvl(TOTAL_DEPOSITS_COUNT,0) - 1,
3235: LAST_UPDATE_DATE = sysdate,
3236: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3237: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3238: WHERE cust_account_id = l_history_rec.customer_id
3239: and site_use_id = nvl(l_history_rec.site_use_id,-99)
3240: and currency = l_history_rec.currency_code
3241: and org_id = l_org_id
3345: SAVEPOINT CB_Create;
3346: --
3347: --set the application context.
3348: --
3349: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3350: mo_global.init('AR');
3351: mo_global.set_policy_context('S',l_org_id);
3352: --
3353: -- Acquire locks on the payment schedule record so that
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
3386: WHERE customer_trx_id = l_customer_trx_id
3387: and nvl(complete_flag,'N') = 'N';
3388:
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
3386: WHERE customer_trx_id = l_customer_trx_id
3387: and nvl(complete_flag,'N') = 'N';
3388:
3389:
3410: = nvl(OP_CHARGEBACK_VALUE,0)
3411: +l_ps_rec.amount_due_original,
3412: OP_CHARGEBACK_COUNT = nvl(OP_CHARGEBACK_COUNT,0) + 1,
3413: LAST_UPDATE_DATE = sysdate,
3414: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3415: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3416: WHERE cust_account_id = l_ps_rec.customer_id
3417: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
3418: and currency = l_ps_rec.invoice_currency_code
3411: +l_ps_rec.amount_due_original,
3412: OP_CHARGEBACK_COUNT = nvl(OP_CHARGEBACK_COUNT,0) + 1,
3413: LAST_UPDATE_DATE = sysdate,
3414: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3415: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3416: WHERE cust_account_id = l_ps_rec.customer_id
3417: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
3418: and currency = l_ps_rec.invoice_currency_code
3419: and org_id = l_org_id;
3439: nvl(l_ps_rec.customer_site_use_id,-99),
3440: l_org_id,
3441: l_ps_rec.invoice_currency_code,
3442: sysdate,
3443: fnd_global.user_id,
3444: sysdate,
3445: fnd_global.user_id,
3446: fnd_global.login_id,
3447: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
3441: l_ps_rec.invoice_currency_code,
3442: sysdate,
3443: fnd_global.user_id,
3444: sysdate,
3445: fnd_global.user_id,
3446: fnd_global.login_id,
3447: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
3448: l_ps_rec.amount_due_original),
3449: l_ps_rec.amount_due_original,
3442: sysdate,
3443: fnd_global.user_id,
3444: sysdate,
3445: fnd_global.user_id,
3446: fnd_global.login_id,
3447: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
3448: l_ps_rec.amount_due_original),
3449: l_ps_rec.amount_due_original,
3450: 1
3461: TOTAL_CHARGEBACK_VALUE = nvl(TOTAL_CHARGEBACK_VALUE,0) +
3462: l_ps_rec.amount_due_original,
3463: TOTAL_CHARGEBACK_COUNT = nvl(TOTAL_CHARGEBACK_COUNT,0) + 1,
3464: LAST_UPDATE_DATE = sysdate,
3465: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3466: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3467: WHERE cust_account_id = l_ps_rec.customer_id
3468: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
3469: and currency = l_ps_rec.invoice_currency_code
3462: l_ps_rec.amount_due_original,
3463: TOTAL_CHARGEBACK_COUNT = nvl(TOTAL_CHARGEBACK_COUNT,0) + 1,
3464: LAST_UPDATE_DATE = sysdate,
3465: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3466: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3467: WHERE cust_account_id = l_ps_rec.customer_id
3468: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
3469: and currency = l_ps_rec.invoice_currency_code
3470: and org_id = l_org_id
3493: l_org_id,
3494: l_ps_rec.invoice_currency_code,
3495: l_ps_rec.trx_date,
3496: sysdate,
3497: fnd_global.user_id,
3498: sysdate,
3499: fnd_global.user_id,
3500: fnd_global.login_id,
3501: l_ps_rec.amount_due_original,
3495: l_ps_rec.trx_date,
3496: sysdate,
3497: fnd_global.user_id,
3498: sysdate,
3499: fnd_global.user_id,
3500: fnd_global.login_id,
3501: l_ps_rec.amount_due_original,
3502: l_ps_rec.amount_due_original,
3503: 1
3496: sysdate,
3497: fnd_global.user_id,
3498: sysdate,
3499: fnd_global.user_id,
3500: fnd_global.login_id,
3501: l_ps_rec.amount_due_original,
3502: l_ps_rec.amount_due_original,
3503: 1
3504: );
3677: SAVEPOINT CR_Create_Event;
3678: --
3679: --set the application context.
3680: --
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
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
3693: WHERE payment_schedule_id = l_payment_schedule_id;
3694:
3695: OPEN get_receipt_details (l_payment_schedule_id);
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
3693: WHERE payment_schedule_id = l_payment_schedule_id;
3694:
3695: OPEN get_receipt_details (l_payment_schedule_id);
3696:
3731: -1,last_payment_date,l_receipt_date),
3732: last_payment_number = DECODE(sign(l_receipt_date-last_payment_date),
3733: -1,last_payment_number,l_receipt_number),
3734: LAST_UPDATE_DATE = sysdate,
3735: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3736: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3737: where cust_account_id = l_customer_id
3738: and site_use_id = nvl(l_customer_site_use_id,-99)
3739: and org_id = l_org_id
3732: last_payment_number = DECODE(sign(l_receipt_date-last_payment_date),
3733: -1,last_payment_number,l_receipt_number),
3734: LAST_UPDATE_DATE = sysdate,
3735: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3736: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3737: where cust_account_id = l_customer_id
3738: and site_use_id = nvl(l_customer_site_use_id,-99)
3739: and org_id = l_org_id
3740: and currency = l_currency_code;
3760: nvl(l_customer_site_use_id,-99),
3761: l_org_id,
3762: l_currency_code,
3763: sysdate,
3764: fnd_global.user_id,
3765: sysdate,
3766: fnd_global.user_id,
3767: fnd_global.login_id,
3768: l_receipt_amount,
3762: l_currency_code,
3763: sysdate,
3764: fnd_global.user_id,
3765: sysdate,
3766: fnd_global.user_id,
3767: fnd_global.login_id,
3768: l_receipt_amount,
3769: 1,
3770: l_receipt_amount,
3763: sysdate,
3764: fnd_global.user_id,
3765: sysdate,
3766: fnd_global.user_id,
3767: fnd_global.login_id,
3768: l_receipt_amount,
3769: 1,
3770: l_receipt_amount,
3771: l_receipt_date,
3778: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
3779: l_receipt_amount,
3780: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,
3781: LAST_UPDATE_DATE = sysdate,
3782: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3783: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3784: where cust_account_id = l_customer_id
3785: and site_use_id = nvl(l_customer_site_use_id,-99)
3786: and org_id = l_org_id
3779: l_receipt_amount,
3780: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,
3781: LAST_UPDATE_DATE = sysdate,
3782: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3783: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3784: where cust_account_id = l_customer_id
3785: and site_use_id = nvl(l_customer_site_use_id,-99)
3786: and org_id = l_org_id
3787: and currency = l_currency_code
3807: l_org_id,
3808: l_currency_code,
3809: l_receipt_date,
3810: sysdate,
3811: fnd_global.user_id,
3812: sysdate,
3813: fnd_global.user_id,
3814: fnd_global.login_id,
3815: l_receipt_amount,
3809: l_receipt_date,
3810: sysdate,
3811: fnd_global.user_id,
3812: sysdate,
3813: fnd_global.user_id,
3814: fnd_global.login_id,
3815: l_receipt_amount,
3816: 1);
3817:
3810: sysdate,
3811: fnd_global.user_id,
3812: sysdate,
3813: fnd_global.user_id,
3814: fnd_global.login_id,
3815: l_receipt_amount,
3816: 1);
3817:
3818: END IF;
3952: SAVEPOINT CR_Reverse;
3953: --
3954: --set the application context.
3955: --
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
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
3965: WHERE payment_schedule_id = l_payment_schedule_id;
3966:
3967: OPEN get_receipt_details (l_payment_schedule_id);
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
3965: WHERE payment_schedule_id = l_payment_schedule_id;
3966:
3967: OPEN get_receipt_details (l_payment_schedule_id);
3968:
4013: last_payment_amount = nvl(l_last_receipt_amount,last_payment_amount),
4014: last_payment_date = nvl(l_last_receipt_date,last_payment_date),
4015: last_payment_number = nvl(l_last_receipt_number,last_payment_number),
4016: LAST_UPDATE_DATE = sysdate,
4017: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4018: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4019: where cust_account_id = l_customer_id
4020: and site_use_id = nvl(l_customer_site_use_id,-99)
4021: and org_id = l_org_id
4014: last_payment_date = nvl(l_last_receipt_date,last_payment_date),
4015: last_payment_number = nvl(l_last_receipt_number,last_payment_number),
4016: LAST_UPDATE_DATE = sysdate,
4017: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4018: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4019: where cust_account_id = l_customer_id
4020: and site_use_id = nvl(l_customer_site_use_id,-99)
4021: and org_id = l_org_id
4022: and currency = l_currency_code;
4030: nsf_stop_payment_amount = nvl(nsf_stop_payment_amount,0)
4031: - nvl(l_receipt_amount,0),
4032: nsf_stop_payment_count = nvl(nsf_stop_payment_count,0) + 1,
4033: LAST_UPDATE_DATE = sysdate,
4034: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4035: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4036: where cust_account_id = l_customer_id
4037: and site_use_id = nvl(l_customer_site_use_id,-99)
4038: and org_id = l_org_id
4031: - nvl(l_receipt_amount,0),
4032: nsf_stop_payment_count = nvl(nsf_stop_payment_count,0) + 1,
4033: LAST_UPDATE_DATE = sysdate,
4034: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4035: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4036: where cust_account_id = l_customer_id
4037: and site_use_id = nvl(l_customer_site_use_id,-99)
4038: and org_id = l_org_id
4039: and currency = l_currency_code
4138: SAVEPOINT CR_Modify;
4139: --
4140: --set the application context.
4141: --
4142: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4143: mo_global.init('AR');
4144: mo_global.set_policy_context('S',l_org_id);
4145:
4146: OPEN get_receipt_hist(l_history_id);
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
4200: WHERE history_id = l_history_id
4201: and nvl(complete_flag ,'N') = 'N';
4202:
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
4200: WHERE history_id = l_history_id
4201: and nvl(complete_flag ,'N') = 'N';
4202:
4203:
4214: last_payment_amount = l_receipt_amount,
4215: last_payment_date = l_receipt_date,
4216: last_payment_number = l_receipt_number,
4217: LAST_UPDATE_DATE = sysdate,
4218: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4219: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4220: where cust_account_id = l_customer_id
4221: and site_use_id = nvl(l_customer_site_use_id,-99)
4222: and org_id = l_org_id
4215: last_payment_date = l_receipt_date,
4216: last_payment_number = l_receipt_number,
4217: LAST_UPDATE_DATE = sysdate,
4218: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4219: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4220: where cust_account_id = l_customer_id
4221: and site_use_id = nvl(l_customer_site_use_id,-99)
4222: and org_id = l_org_id
4223: and currency = l_currency_code;
4243: nvl(l_customer_site_use_id,-99),
4244: l_org_id,
4245: l_currency_code,
4246: sysdate,
4247: fnd_global.user_id,
4248: sysdate,
4249: fnd_global.user_id,
4250: fnd_global.login_id,
4251: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4245: l_currency_code,
4246: sysdate,
4247: fnd_global.user_id,
4248: sysdate,
4249: fnd_global.user_id,
4250: fnd_global.login_id,
4251: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4252: 1,
4253: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4246: sysdate,
4247: fnd_global.user_id,
4248: sysdate,
4249: fnd_global.user_id,
4250: fnd_global.login_id,
4251: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4252: 1,
4253: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4254: l_receipt_date,
4263: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
4264: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4265: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4266: LAST_UPDATE_DATE = sysdate,
4267: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4268: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4269: where cust_account_id = l_customer_id
4270: and site_use_id = nvl(l_customer_site_use_id,-99)
4271: and org_id = l_org_id
4264: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4265: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4266: LAST_UPDATE_DATE = sysdate,
4267: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4268: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4269: where cust_account_id = l_customer_id
4270: and site_use_id = nvl(l_customer_site_use_id,-99)
4271: and org_id = l_org_id
4272: and currency = l_currency_code
4293: l_org_id,
4294: l_currency_code,
4295: l_receipt_date,
4296: sysdate,
4297: fnd_global.user_id,
4298: sysdate,
4299: fnd_global.user_id,
4300: fnd_global.login_id,
4301: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4295: l_receipt_date,
4296: sysdate,
4297: fnd_global.user_id,
4298: sysdate,
4299: fnd_global.user_id,
4300: fnd_global.login_id,
4301: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4302: 1);
4303:
4296: sysdate,
4297: fnd_global.user_id,
4298: sysdate,
4299: fnd_global.user_id,
4300: fnd_global.login_id,
4301: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4302: 1);
4303:
4304: END IF;
4311: last_payment_amount = nvl(l_hist_rec.amount_due_original,0),
4312: last_payment_date = l_receipt_date,
4313: last_payment_number = l_receipt_number,
4314: LAST_UPDATE_DATE = sysdate,
4315: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4316: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4317: where cust_account_id = l_hist_rec.customer_id
4318: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4319: and org_id = l_org_id
4312: last_payment_date = l_receipt_date,
4313: last_payment_number = l_receipt_number,
4314: LAST_UPDATE_DATE = sysdate,
4315: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4316: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4317: where cust_account_id = l_hist_rec.customer_id
4318: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4319: and org_id = l_org_id
4320: and currency = l_currency_code;
4340: nvl(l_hist_rec.site_use_id,-99),
4341: l_org_id,
4342: l_currency_code,
4343: sysdate,
4344: fnd_global.user_id,
4345: sysdate,
4346: fnd_global.user_id,
4347: fnd_global.login_id,
4348: l_hist_rec.amount_due_original,
4342: l_currency_code,
4343: sysdate,
4344: fnd_global.user_id,
4345: sysdate,
4346: fnd_global.user_id,
4347: fnd_global.login_id,
4348: l_hist_rec.amount_due_original,
4349: 1,
4350: l_hist_rec.amount_due_original,
4343: sysdate,
4344: fnd_global.user_id,
4345: sysdate,
4346: fnd_global.user_id,
4347: fnd_global.login_id,
4348: l_hist_rec.amount_due_original,
4349: 1,
4350: l_hist_rec.amount_due_original,
4351: l_receipt_date,
4358: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4359: - nvl(l_hist_rec.amount_due_original,0) ,
4360: total_cash_receipts_count = nvl(total_cash_receipts_count,0) -1,
4361: LAST_UPDATE_DATE = sysdate,
4362: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4363: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4364: where cust_account_id = l_hist_rec.customer_id
4365: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4366: and org_id = l_org_id
4359: - nvl(l_hist_rec.amount_due_original,0) ,
4360: total_cash_receipts_count = nvl(total_cash_receipts_count,0) -1,
4361: LAST_UPDATE_DATE = sysdate,
4362: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4363: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4364: where cust_account_id = l_hist_rec.customer_id
4365: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4366: and org_id = l_org_id
4367: and currency = l_currency_code
4387: l_org_id,
4388: l_currency_code,
4389: l_receipt_date,
4390: sysdate,
4391: fnd_global.user_id,
4392: sysdate,
4393: fnd_global.user_id,
4394: fnd_global.login_id,
4395: l_hist_rec.amount_due_original,
4389: l_receipt_date,
4390: sysdate,
4391: fnd_global.user_id,
4392: sysdate,
4393: fnd_global.user_id,
4394: fnd_global.login_id,
4395: l_hist_rec.amount_due_original,
4396: 1);
4397: END IF;
4390: sysdate,
4391: fnd_global.user_id,
4392: sysdate,
4393: fnd_global.user_id,
4394: fnd_global.login_id,
4395: l_hist_rec.amount_due_original,
4396: 1);
4397: END IF;
4398: ELSIF l_customer_id IS NOT NULL AND l_hist_rec.customer_id IS NULL THEN
4404: last_payment_amount = l_receipt_amount,
4405: last_payment_date = l_receipt_date,
4406: last_payment_number = l_receipt_number,
4407: LAST_UPDATE_DATE = sysdate,
4408: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4409: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4410: where cust_account_id = l_customer_id
4411: and site_use_id = nvl(l_customer_site_use_id,-99)
4412: and org_id = l_org_id
4405: last_payment_date = l_receipt_date,
4406: last_payment_number = l_receipt_number,
4407: LAST_UPDATE_DATE = sysdate,
4408: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4409: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4410: where cust_account_id = l_customer_id
4411: and site_use_id = nvl(l_customer_site_use_id,-99)
4412: and org_id = l_org_id
4413: and currency = l_currency_code;
4433: nvl(l_customer_site_use_id,-99),
4434: l_org_id,
4435: l_currency_code,
4436: sysdate,
4437: fnd_global.user_id,
4438: sysdate,
4439: fnd_global.user_id,
4440: fnd_global.login_id,
4441: l_receipt_amount,
4435: l_currency_code,
4436: sysdate,
4437: fnd_global.user_id,
4438: sysdate,
4439: fnd_global.user_id,
4440: fnd_global.login_id,
4441: l_receipt_amount,
4442: 1,
4443: l_receipt_amount,
4436: sysdate,
4437: fnd_global.user_id,
4438: sysdate,
4439: fnd_global.user_id,
4440: fnd_global.login_id,
4441: l_receipt_amount,
4442: 1,
4443: l_receipt_amount,
4444: l_receipt_date,
4451: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4452: + l_receipt_amount ,
4453: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4454: LAST_UPDATE_DATE = sysdate,
4455: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4456: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4457: where cust_account_id = l_customer_id
4458: and site_use_id = nvl(l_customer_site_use_id,-99)
4459: and org_id = l_org_id
4452: + l_receipt_amount ,
4453: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4454: LAST_UPDATE_DATE = sysdate,
4455: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4456: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4457: where cust_account_id = l_customer_id
4458: and site_use_id = nvl(l_customer_site_use_id,-99)
4459: and org_id = l_org_id
4460: and currency = l_currency_code
4480: l_org_id,
4481: l_currency_code,
4482: l_receipt_date,
4483: sysdate,
4484: fnd_global.user_id,
4485: sysdate,
4486: fnd_global.user_id,
4487: fnd_global.login_id,
4488: l_receipt_amount,
4482: l_receipt_date,
4483: sysdate,
4484: fnd_global.user_id,
4485: sysdate,
4486: fnd_global.user_id,
4487: fnd_global.login_id,
4488: l_receipt_amount,
4489: 1);
4490: END IF;
4483: sysdate,
4484: fnd_global.user_id,
4485: sysdate,
4486: fnd_global.user_id,
4487: fnd_global.login_id,
4488: l_receipt_amount,
4489: 1);
4490: END IF;
4491: ELSIF nvl(l_customer_id,0) <> nvl(l_hist_rec.customer_id,0) THEN
4498: last_payment_amount = nvl(l_hist_rec.amount_due_original,0),
4499: last_payment_date = l_receipt_date,
4500: last_payment_number = l_receipt_number,
4501: LAST_UPDATE_DATE = sysdate,
4502: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4503: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4504: where cust_account_id = l_hist_rec.customer_id
4505: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4506: and org_id = l_org_id
4499: last_payment_date = l_receipt_date,
4500: last_payment_number = l_receipt_number,
4501: LAST_UPDATE_DATE = sysdate,
4502: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4503: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4504: where cust_account_id = l_hist_rec.customer_id
4505: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4506: and org_id = l_org_id
4507: and currency = l_currency_code;
4527: nvl(l_hist_rec.site_use_id,-99),
4528: l_org_id,
4529: l_currency_code,
4530: sysdate,
4531: fnd_global.user_id,
4532: sysdate,
4533: fnd_global.user_id,
4534: fnd_global.login_id,
4535: l_hist_rec.amount_due_original,
4529: l_currency_code,
4530: sysdate,
4531: fnd_global.user_id,
4532: sysdate,
4533: fnd_global.user_id,
4534: fnd_global.login_id,
4535: l_hist_rec.amount_due_original,
4536: 1,
4537: l_hist_rec.amount_due_original,
4530: sysdate,
4531: fnd_global.user_id,
4532: sysdate,
4533: fnd_global.user_id,
4534: fnd_global.login_id,
4535: l_hist_rec.amount_due_original,
4536: 1,
4537: l_hist_rec.amount_due_original,
4538: l_receipt_date,
4545: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4546: - nvl(l_hist_rec.amount_due_original,0) ,
4547: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4548: LAST_UPDATE_DATE = sysdate,
4549: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4550: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4551: where cust_account_id = l_hist_rec.customer_id
4552: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4553: and org_id = l_org_id
4546: - nvl(l_hist_rec.amount_due_original,0) ,
4547: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4548: LAST_UPDATE_DATE = sysdate,
4549: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4550: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4551: where cust_account_id = l_hist_rec.customer_id
4552: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4553: and org_id = l_org_id
4554: and currency = l_currency_code
4574: l_org_id,
4575: l_currency_code,
4576: l_receipt_date,
4577: sysdate,
4578: fnd_global.user_id,
4579: sysdate,
4580: fnd_global.user_id,
4581: fnd_global.login_id,
4582: l_hist_rec.amount_due_original,
4576: l_receipt_date,
4577: sysdate,
4578: fnd_global.user_id,
4579: sysdate,
4580: fnd_global.user_id,
4581: fnd_global.login_id,
4582: l_hist_rec.amount_due_original,
4583: 1);
4584: END IF;
4577: sysdate,
4578: fnd_global.user_id,
4579: sysdate,
4580: fnd_global.user_id,
4581: fnd_global.login_id,
4582: l_hist_rec.amount_due_original,
4583: 1);
4584: END IF;
4585:
4591: last_payment_amount = l_receipt_amount,
4592: last_payment_date = l_receipt_date,
4593: last_payment_number = l_receipt_number,
4594: LAST_UPDATE_DATE = sysdate,
4595: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4596: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4597: where cust_account_id = l_customer_id
4598: and site_use_id = nvl(l_customer_site_use_id,-99)
4599: and org_id = l_org_id
4592: last_payment_date = l_receipt_date,
4593: last_payment_number = l_receipt_number,
4594: LAST_UPDATE_DATE = sysdate,
4595: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4596: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4597: where cust_account_id = l_customer_id
4598: and site_use_id = nvl(l_customer_site_use_id,-99)
4599: and org_id = l_org_id
4600: and currency = l_currency_code;
4620: nvl(l_customer_site_use_id,-99),
4621: l_org_id,
4622: l_currency_code,
4623: sysdate,
4624: fnd_global.user_id,
4625: sysdate,
4626: fnd_global.user_id,
4627: fnd_global.login_id,
4628: l_receipt_amount,
4622: l_currency_code,
4623: sysdate,
4624: fnd_global.user_id,
4625: sysdate,
4626: fnd_global.user_id,
4627: fnd_global.login_id,
4628: l_receipt_amount,
4629: 1,
4630: l_receipt_amount,
4623: sysdate,
4624: fnd_global.user_id,
4625: sysdate,
4626: fnd_global.user_id,
4627: fnd_global.login_id,
4628: l_receipt_amount,
4629: 1,
4630: l_receipt_amount,
4631: l_receipt_date,
4639: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4640: + l_receipt_amount ,
4641: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4642: LAST_UPDATE_DATE = sysdate,
4643: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4644: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4645: where cust_account_id = l_customer_id
4646: and site_use_id = nvl(l_customer_site_use_id,-99)
4647: and org_id = l_org_id
4640: + l_receipt_amount ,
4641: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4642: LAST_UPDATE_DATE = sysdate,
4643: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4644: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4645: where cust_account_id = l_customer_id
4646: and site_use_id = nvl(l_customer_site_use_id,-99)
4647: and org_id = l_org_id
4648: and currency = l_currency_code
4668: l_org_id,
4669: l_currency_code,
4670: l_receipt_date,
4671: sysdate,
4672: fnd_global.user_id,
4673: sysdate,
4674: fnd_global.user_id,
4675: fnd_global.login_id,
4676: l_receipt_amount ,
4670: l_receipt_date,
4671: sysdate,
4672: fnd_global.user_id,
4673: sysdate,
4674: fnd_global.user_id,
4675: fnd_global.login_id,
4676: l_receipt_amount ,
4677: 1);
4678: END IF;
4671: sysdate,
4672: fnd_global.user_id,
4673: sysdate,
4674: fnd_global.user_id,
4675: fnd_global.login_id,
4676: l_receipt_amount ,
4677: 1);
4678: END IF;
4679:
4874: SAVEPOINT CR_Delete;
4875: --
4876: --set the application context.
4877: --
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
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
4887: WHERE payment_schedule_id = l_payment_schedule_id;
4888:
4889: FOR k IN hist(l_payment_schedule_id) LOOP
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
4887: WHERE payment_schedule_id = l_payment_schedule_id;
4888:
4889: FOR k IN hist(l_payment_schedule_id) LOOP
4890: IF k.customer_id IS NOT NULL THEN
4921: last_payment_amount = NVL(l_last_receipt_amount,last_payment_amount),
4922: last_payment_date = NVL(l_last_receipt_date,last_payment_date),
4923: last_payment_number = NVL(l_last_receipt_number,last_payment_number),
4924: LAST_UPDATE_DATE = sysdate,
4925: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4926: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4927: WHERE cust_account_id = k.customer_id
4928: AND site_use_id = nvl(k.site_use_id,-99)
4929: AND org_id = l_org_id
4922: last_payment_date = NVL(l_last_receipt_date,last_payment_date),
4923: last_payment_number = NVL(l_last_receipt_number,last_payment_number),
4924: LAST_UPDATE_DATE = sysdate,
4925: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4926: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4927: WHERE cust_account_id = k.customer_id
4928: AND site_use_id = nvl(k.site_use_id,-99)
4929: AND org_id = l_org_id
4930: AND currency = k.currency_code;
4935: SET total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4936: nvl(k.amount_due_original,0),
4937: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,
4938: LAST_UPDATE_DATE = sysdate,
4939: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4940: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4941: WHERE cust_account_id = k.customer_id
4942: AND site_use_id = nvl(k.site_use_id,-99)
4943: AND org_id = l_org_id
4936: nvl(k.amount_due_original,0),
4937: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,
4938: LAST_UPDATE_DATE = sysdate,
4939: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4940: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4941: WHERE cust_account_id = k.customer_id
4942: AND site_use_id = nvl(k.site_use_id,-99)
4943: AND org_id = l_org_id
4944: AND currency = k.currency_code
5050: END IF;
5051: --
5052: --set the application context.
5053: --
5054: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5055: mo_global.init('AR');
5056: mo_global.set_policy_context('S',l_org_id);
5057:
5058: select to_date(l_due_date_str, 'J')
5255: SAVEPOINT CM_UnApply_Event;
5256: --
5257: --set the application context.
5258: --
5259: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5260: mo_global.init('AR');
5261: mo_global.set_policy_context('S',l_org_id);
5262:
5263: select to_date(l_due_date_str, 'J')
5485: END IF;
5486: --
5487: --set the application context.
5488: --
5489: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5490: mo_global.init('AR');
5491: mo_global.set_policy_context('S',l_org_id);
5492:
5493: select to_date(l_due_date_str, 'J')
5779: END IF;
5780: --
5781: --set the application context.
5782: --
5783: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5784: mo_global.init('AR');
5785: mo_global.set_policy_context('S',l_org_id);
5786:
5787: select to_date(l_due_date_str, 'J')
6174: SAVEPOINT AutoInv_Run_Event;
6175: --
6176: --set the application context.
6177: --
6178: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6179: mo_global.init('AR');
6180: mo_global.set_policy_context('S',l_org_id);
6181:
6182: Update_summary_for_request_id(l_request_id);
6238: SAVEPOINT AutoRcpt_Run_Event;
6239: --
6240: --set the application context.
6241: --
6242: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6243: mo_global.init('AR');
6244: mo_global.set_policy_context('S',l_org_id);
6245:
6246: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6329: SAVEPOINT AutoADJ_Run_Event;
6330: --
6331: --set the application context.
6332: --
6333: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6334: mo_global.init('AR');
6335: mo_global.set_policy_context('S',l_org_id);
6336:
6337: OPEN get_adj(l_request_id);
6439: SAVEPOINT QuickCash_PostBatch_pvt;
6440: --
6441: --set the application context.
6442: --
6443: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6444: mo_global.init('AR');
6445: mo_global.set_policy_context('S',l_org_id);
6446:
6447: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6552: SAVEPOINT ADJCreate_Event;
6553: --
6554: --set the application context.
6555: --
6556: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6557: mo_global.init('AR');
6558: mo_global.set_policy_context('S',l_org_id);
6559:
6560: OPEN get_adj_details (l_adjustment_id);
6707: SAVEPOINT ADJApprove_Event;
6708: --
6709: --set the application context.
6710: --
6711: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6712: mo_global.init('AR');
6713: mo_global.set_policy_context('S',l_org_id);
6714:
6715: OPEN get_adj_details (l_adjustment_id);
6838: SAVEPOINT CopyInv_Run_Event;
6839: --
6840: --set the application context.
6841: --
6842: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6843: mo_global.init('AR');
6844: mo_global.set_policy_context('S',l_org_id);
6845:
6846: Update_summary_for_request_id(l_request_id);
7144: group by trx_ps.customer_id, trx_ps.customer_site_use_id,
7145: trx_ps.invoice_currency_code, trx_ps.org_id),
7146: /* WHO columns */
7147: last_update_date = sysdate,
7148: last_updated_by = fnd_global.user_id,
7149: last_update_login= fnd_global.login_id
7150: where cust_account_id = p_customer_id_tab(i)
7151: and site_use_id = p_site_use_id_tab(i)
7152: and currency = p_currency_tab(i)
7145: trx_ps.invoice_currency_code, trx_ps.org_id),
7146: /* WHO columns */
7147: last_update_date = sysdate,
7148: last_updated_by = fnd_global.user_id,
7149: last_update_login= fnd_global.login_id
7150: where cust_account_id = p_customer_id_tab(i)
7151: and site_use_id = p_site_use_id_tab(i)
7152: and currency = p_currency_tab(i)
7153: and org_id = p_org_id_tab(i);