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 NVL(org_id,'-99') = NVL(l_org_id,-99);
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 NVL(org_id,'-99') = NVL(l_org_id,-99);
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 NVL(org_id,'-99') = NVL(rec.org_id,-99);
377: nvl(rec.customer_site_use_id,-99),
378: rec.org_id,
379: rec.invoice_currency_code,
380: sysdate,
381: fnd_global.user_id,
382: sysdate,
383: fnd_global.user_id,
384: fnd_global.login_id,
385: DECODE(sign(rec.due_date - trunc(sysdate)),-1,0,
379: rec.invoice_currency_code,
380: sysdate,
381: fnd_global.user_id,
382: sysdate,
383: fnd_global.user_id,
384: fnd_global.login_id,
385: DECODE(sign(rec.due_date - trunc(sysdate)),-1,0,
386: rec.amount_due_original),
387: DECODE(rec.class , 'INV' , rec.amount_due_original,
380: sysdate,
381: fnd_global.user_id,
382: sysdate,
383: fnd_global.user_id,
384: fnd_global.login_id,
385: DECODE(sign(rec.due_date - trunc(sysdate)),-1,0,
386: rec.amount_due_original),
387: DECODE(rec.class , 'INV' , rec.amount_due_original,
388: 'CM', decode(rec.previous_customer_trx_id, null,0,
466: (rec.amount_due_original *
467: (rec.due_date - rec.trx_date)),
468: DAYS_CREDIT_GRANTED_SUM),
469: LAST_UPDATE_DATE = sysdate,
470: LAST_UPDATED_BY = FND_GLOBAL.user_id,
471: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
472: WHERE cust_account_id = rec.customer_id
473: AND site_use_id = nvl(rec.customer_site_use_id,-99)
474: AND currency = rec.invoice_currency_code
467: (rec.due_date - rec.trx_date)),
468: DAYS_CREDIT_GRANTED_SUM),
469: LAST_UPDATE_DATE = sysdate,
470: LAST_UPDATED_BY = FND_GLOBAL.user_id,
471: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
472: WHERE cust_account_id = rec.customer_id
473: AND site_use_id = nvl(rec.customer_site_use_id,-99)
474: AND currency = rec.invoice_currency_code
475: AND NVL(org_id,'-99') = NVL(rec.org_id,-99)
504: rec.org_id,
505: rec.invoice_currency_code,
506: rec.trx_date,
507: sysdate,
508: fnd_global.user_id,
509: sysdate,
510: fnd_global.user_id,
511: fnd_global.login_id,
512: rec.amount_due_original,
506: rec.trx_date,
507: sysdate,
508: fnd_global.user_id,
509: sysdate,
510: fnd_global.user_id,
511: fnd_global.login_id,
512: rec.amount_due_original,
513: rec.amount_due_original,
514: DECODE(rec.class , 'INV',1,null),
507: sysdate,
508: fnd_global.user_id,
509: sysdate,
510: fnd_global.user_id,
511: fnd_global.login_id,
512: rec.amount_due_original,
513: rec.amount_due_original,
514: DECODE(rec.class , 'INV',1,null),
515: DECODE(rec.class , 'INV',
597: nvl(l_past_due_inv_inst_count,0),0),
598: PENDING_ADJ_VALUE = nvl(PENDING_ADJ_VALUE,0)
599: + DECODE(l_special_adj, 'Y', 0, nvl(l_pending_adj_amount,0)),
600: LAST_UPDATE_DATE = sysdate,
601: LAST_UPDATED_BY = FND_GLOBAL.user_id,
602: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
603: WHERE cust_account_id = l_customer_id
604: and site_use_id = l_site_use_id
605: and currency = l_currency_code
598: PENDING_ADJ_VALUE = nvl(PENDING_ADJ_VALUE,0)
599: + DECODE(l_special_adj, 'Y', 0, nvl(l_pending_adj_amount,0)),
600: LAST_UPDATE_DATE = sysdate,
601: LAST_UPDATED_BY = FND_GLOBAL.user_id,
602: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
603: WHERE cust_account_id = l_customer_id
604: and site_use_id = l_site_use_id
605: and currency = l_currency_code
606: and NVL(org_id,'-99') = NVL(l_org_id,-99);
632: l_site_use_id,
633: l_org_id,
634: l_currency_code,
635: sysdate,
636: fnd_global.user_id,
637: sysdate,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: +nvl(l_adj_amount,0),
634: l_currency_code,
635: sysdate,
636: fnd_global.user_id,
637: sysdate,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: +nvl(l_adj_amount,0),
641: + DECODE(l_class,'CM',nvl(l_adj_amount,0),0),
642: DECODE(l_class, 'CM', nvl(l_op_trx_count,0),0),
635: sysdate,
636: fnd_global.user_id,
637: sysdate,
638: fnd_global.user_id,
639: fnd_global.login_id,
640: +nvl(l_adj_amount,0),
641: + DECODE(l_class,'CM',nvl(l_adj_amount,0),0),
642: DECODE(l_class, 'CM', nvl(l_op_trx_count,0),0),
643: + DECODE(l_class,'INV',nvl(l_adj_amount,0),0),
658: + DECODE(l_special_adj, 'Y',0, nvl(l_adj_amount,0)),
659: TOTAL_ADJUSTMENTS_COUNT = nvl(TOTAL_ADJUSTMENTS_COUNT,0)
660: + DECODE(l_special_adj, 'Y',0,nvl(l_op_trx_count,0)),
661: LAST_UPDATE_DATE = sysdate,
662: LAST_UPDATED_BY = FND_GLOBAL.user_id,
663: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
664: where cust_account_id = l_customer_id
665: and site_use_id = l_site_use_id
666: and currency = l_currency_code
659: TOTAL_ADJUSTMENTS_COUNT = nvl(TOTAL_ADJUSTMENTS_COUNT,0)
660: + DECODE(l_special_adj, 'Y',0,nvl(l_op_trx_count,0)),
661: LAST_UPDATE_DATE = sysdate,
662: LAST_UPDATED_BY = FND_GLOBAL.user_id,
663: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
664: where cust_account_id = l_customer_id
665: and site_use_id = l_site_use_id
666: and currency = l_currency_code
667: and as_of_date = l_apply_date
690: l_org_id,
691: l_currency_code,
692: l_apply_date,
693: sysdate,
694: fnd_global.user_id,
695: sysdate,
696: fnd_global.user_id,
697: fnd_global.login_id,
698: nvl(l_adj_amount,0),
692: l_apply_date,
693: sysdate,
694: fnd_global.user_id,
695: sysdate,
696: fnd_global.user_id,
697: fnd_global.login_id,
698: nvl(l_adj_amount,0),
699: nvl(l_op_trx_count,0),
700: nvl(l_adj_amount,0) );
693: sysdate,
694: fnd_global.user_id,
695: sysdate,
696: fnd_global.user_id,
697: fnd_global.login_id,
698: nvl(l_adj_amount,0),
699: nvl(l_op_trx_count,0),
700: nvl(l_adj_amount,0) );
701: END IF;
845: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
846: i.receipt_amount,
847: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,
848: LAST_UPDATE_DATE = sysdate,
849: LAST_UPDATED_BY = FND_GLOBAL.user_id,
850: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
851: where cust_account_id = i.customer_id
852: and site_use_id = nvl(i.site_use_id,-99)
853: and NVL(org_id,'-99') = NVL(p_org_id,-99)
846: i.receipt_amount,
847: total_cash_receipts_count = nvl(total_cash_receipts_count,0) + 1,
848: LAST_UPDATE_DATE = sysdate,
849: LAST_UPDATED_BY = FND_GLOBAL.user_id,
850: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
851: where cust_account_id = i.customer_id
852: and site_use_id = nvl(i.site_use_id,-99)
853: and NVL(org_id,'-99') = NVL(p_org_id,-99)
854: and currency = i.rcpt_currency
874: p_org_id,
875: i.rcpt_currency,
876: i.as_of_date,
877: sysdate,
878: fnd_global.user_id,
879: sysdate,
880: fnd_global.user_id,
881: fnd_global.login_id,
882: i.receipt_amount,
876: i.as_of_date,
877: sysdate,
878: fnd_global.user_id,
879: sysdate,
880: fnd_global.user_id,
881: fnd_global.login_id,
882: i.receipt_amount,
883: 1);
884: END IF;
877: sysdate,
878: fnd_global.user_id,
879: sysdate,
880: fnd_global.user_id,
881: fnd_global.login_id,
882: i.receipt_amount,
883: 1);
884: END IF;
885:
895: -1,last_payment_date,i.last_payment_date),
896: last_payment_number = decode(sign(i.last_payment_date-last_payment_date),
897: -1,last_payment_number,i.last_payment_number),
898: LAST_UPDATE_DATE = sysdate,
899: LAST_UPDATED_BY = FND_GLOBAL.user_id,
900: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
901: where cust_account_id = i.customer_id
902: and site_use_id = nvl(i.site_use_id,-99)
903: and NVL(org_id,'-99') = NVL(p_org_id,-99)
896: last_payment_number = decode(sign(i.last_payment_date-last_payment_date),
897: -1,last_payment_number,i.last_payment_number),
898: LAST_UPDATE_DATE = sysdate,
899: LAST_UPDATED_BY = FND_GLOBAL.user_id,
900: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
901: where cust_account_id = i.customer_id
902: and site_use_id = nvl(i.site_use_id,-99)
903: and NVL(org_id,'-99') = NVL(p_org_id,-99)
904: and currency = i.rcpt_currency;
922: nvl(i.site_use_id,-99),
923: p_org_id,
924: i.rcpt_currency,
925: sysdate,
926: fnd_global.user_id,
927: sysdate,
928: fnd_global.user_id,
929: fnd_global.login_id,
930: i.last_payment_amount,
924: i.rcpt_currency,
925: sysdate,
926: fnd_global.user_id,
927: sysdate,
928: fnd_global.user_id,
929: fnd_global.login_id,
930: i.last_payment_amount,
931: i.last_payment_date,
932: i.last_payment_number
925: sysdate,
926: fnd_global.user_id,
927: sysdate,
928: fnd_global.user_id,
929: fnd_global.login_id,
930: i.last_payment_amount,
931: i.last_payment_date,
932: i.last_payment_number
933: );
961: + nvl(i.count_of_inv_inst_paid_late,0),
962: count_of_disc_inv_inst = nvl(count_of_disc_inv_inst,0) +
963: nvl(i.count_of_disc_inv_inst,0),
964: LAST_UPDATE_DATE = sysdate,
965: LAST_UPDATED_BY = FND_GLOBAL.user_id,
966: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
967: WHERE cust_account_id = i.trx_customer_id
968: and site_use_id = i.trx_site_use_id
969: and currency = i.trx_currency
962: count_of_disc_inv_inst = nvl(count_of_disc_inv_inst,0) +
963: nvl(i.count_of_disc_inv_inst,0),
964: LAST_UPDATE_DATE = sysdate,
965: LAST_UPDATED_BY = FND_GLOBAL.user_id,
966: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
967: WHERE cust_account_id = i.trx_customer_id
968: and site_use_id = i.trx_site_use_id
969: and currency = i.trx_currency
970: and as_of_date = i.apply_date
1099: SAVEPOINT Inv_Complete_Event;
1100: --
1101: --set the application context.
1102: --
1103: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1104: mo_global.init('AR');
1105: mo_global.set_policy_context('S',l_org_id);
1106: --
1107: -- Acquire locks on the payment schedule record so that
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
1141: WHERE customer_trx_id = l_customer_trx_id
1142: and nvl(complete_flag,'N') = 'N';
1143:
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
1141: WHERE customer_trx_id = l_customer_trx_id
1142: and nvl(complete_flag,'N') = 'N';
1143:
1144:
1177: +nvl(l_ps_tab(j).amount_adjusted,0)),0),
1178: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0) +
1179: decode(sign(l_ps_tab(j).due_date - trunc(sysdate)),-1,1,0),
1180: LAST_UPDATE_DATE = sysdate,
1181: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1182: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1183: WHERE cust_account_id = l_ps_tab(j).customer_id
1184: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
1185: and currency = l_ps_tab(j).invoice_currency_code
1178: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0) +
1179: decode(sign(l_ps_tab(j).due_date - trunc(sysdate)),-1,1,0),
1180: LAST_UPDATE_DATE = sysdate,
1181: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1182: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1183: WHERE cust_account_id = l_ps_tab(j).customer_id
1184: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
1185: and currency = l_ps_tab(j).invoice_currency_code
1186: and NVL(org_id,'-99') = NVL(l_org_id,-99);
1207: nvl(l_ps_tab(j).customer_site_use_id,-99),
1208: l_org_id,
1209: l_ps_tab(j).invoice_currency_code,
1210: sysdate,
1211: fnd_global.user_id,
1212: sysdate,
1213: fnd_global.user_id,
1214: fnd_global.login_id,
1215: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
1209: l_ps_tab(j).invoice_currency_code,
1210: sysdate,
1211: fnd_global.user_id,
1212: sysdate,
1213: fnd_global.user_id,
1214: fnd_global.login_id,
1215: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
1216: (l_ps_tab(j).amount_due_original
1217: +nvl(l_ps_tab(j).amount_adjusted,0))),
1210: sysdate,
1211: fnd_global.user_id,
1212: sysdate,
1213: fnd_global.user_id,
1214: fnd_global.login_id,
1215: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
1216: (l_ps_tab(j).amount_due_original
1217: +nvl(l_ps_tab(j).amount_adjusted,0))),
1218: l_ps_tab(j).amount_due_original+nvl(l_ps_tab(j).amount_adjusted,0),
1248: + nvl(l_ps_tab(j).amount_adjusted,0))
1249: * (l_ps_tab(j).due_date
1250: - l_ps_tab(j).trx_date)),
1251: LAST_UPDATE_DATE = sysdate,
1252: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1253: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1254: WHERE cust_account_id = l_ps_tab(j).customer_id
1255: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
1256: and currency = l_ps_tab(j).invoice_currency_code
1249: * (l_ps_tab(j).due_date
1250: - l_ps_tab(j).trx_date)),
1251: LAST_UPDATE_DATE = sysdate,
1252: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1253: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1254: WHERE cust_account_id = l_ps_tab(j).customer_id
1255: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
1256: and currency = l_ps_tab(j).invoice_currency_code
1257: and NVL(org_id,'-99') = NVL(l_org_id,-99)
1283: l_org_id,
1284: l_ps_tab(j).invoice_currency_code,
1285: l_ps_tab(j).trx_date,
1286: sysdate,
1287: fnd_global.user_id,
1288: sysdate,
1289: fnd_global.user_id,
1290: fnd_global.login_id,
1291: l_ps_tab(j).amount_due_original+
1285: l_ps_tab(j).trx_date,
1286: sysdate,
1287: fnd_global.user_id,
1288: sysdate,
1289: fnd_global.user_id,
1290: fnd_global.login_id,
1291: l_ps_tab(j).amount_due_original+
1292: nvl(l_ps_tab(j).amount_adjusted,0),
1293: l_ps_tab(j).amount_due_original,
1286: sysdate,
1287: fnd_global.user_id,
1288: sysdate,
1289: fnd_global.user_id,
1290: fnd_global.login_id,
1291: l_ps_tab(j).amount_due_original+
1292: nvl(l_ps_tab(j).amount_adjusted,0),
1293: l_ps_tab(j).amount_due_original,
1294: 1,
1405: END IF;
1406: --
1407: --set the application context.
1408: --
1409: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1410: mo_global.init('AR');
1411: mo_global.set_policy_context('S',l_org_id);
1412: --
1413: -- No need to acquire locks on the payment schedule record
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
1431: WHERE payment_schedule_id = l_payment_schedule_id
1432: and history_id = l_history_id
1433: and nvl(complete_flag,'N') = 'N';
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
1431: WHERE payment_schedule_id = l_payment_schedule_id
1432: and history_id = l_history_id
1433: and nvl(complete_flag,'N') = 'N';
1434:
1467: +nvl(l_history_rec.amount_adjusted,0)),0)),
1468: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0) -
1469: decode(sign(l_history_rec.due_date - trunc(sysdate)),-1,1,0),
1470: LAST_UPDATE_DATE = sysdate,
1471: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1472: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1473: WHERE cust_account_id = l_history_rec.customer_id
1474: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1475: and currency = l_history_rec.currency_code
1468: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0) -
1469: decode(sign(l_history_rec.due_date - trunc(sysdate)),-1,1,0),
1470: LAST_UPDATE_DATE = sysdate,
1471: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1472: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1473: WHERE cust_account_id = l_history_rec.customer_id
1474: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1475: and currency = l_history_rec.currency_code
1476: and NVL(org_id,'-99') = NVL(l_org_id,-99);
1559: + l_history_rec.amount_adjusted)
1560: * (l_history_rec.due_date
1561: - l_history_rec.trx_date)),
1562: LAST_UPDATE_DATE = sysdate,
1563: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1564: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1565: WHERE cust_account_id = l_history_rec.customer_id
1566: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1567: and currency = l_history_rec.currency_code
1560: * (l_history_rec.due_date
1561: - l_history_rec.trx_date)),
1562: LAST_UPDATE_DATE = sysdate,
1563: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1564: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1565: WHERE cust_account_id = l_history_rec.customer_id
1566: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1567: and currency = l_history_rec.currency_code
1568: and NVL(org_id,'-99') = NVL(l_org_id,-99)
1657: Savepoint Inv_Modify_Event;
1658: --
1659: --set the application context.
1660: --
1661: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1662: mo_global.init('AR');
1663: mo_global.set_policy_context('S',l_org_id);
1664: --Stamp the history record for the modification.
1665: /*bug#5484606-------------------------------------------------------------------+
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
1681: WHERE payment_schedule_id = l_payment_schedule_id
1682: and history_id = l_history_id
1683: and nvl(complete_flag,'N') = 'N';
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
1681: WHERE payment_schedule_id = l_payment_schedule_id
1682: and history_id = l_history_id
1683: and nvl(complete_flag,'N') = 'N';
1684:
1753: - nvl(l_history_rec.amount_in_dispute,0)),
1754: DISPUTED_INV_COUNT = nvl(DISPUTED_INV_COUNT,0)
1755: + nvl(l_inv_dispute_count,0),
1756: LAST_UPDATE_DATE = sysdate,
1757: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1758: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1759: WHERE cust_account_id = l_history_rec.customer_id
1760: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1761: and currency = l_history_rec.currency_code
1754: DISPUTED_INV_COUNT = nvl(DISPUTED_INV_COUNT,0)
1755: + nvl(l_inv_dispute_count,0),
1756: LAST_UPDATE_DATE = sysdate,
1757: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1758: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1759: WHERE cust_account_id = l_history_rec.customer_id
1760: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1761: and currency = l_history_rec.currency_code
1762: and NVL(org_id,'-99') = NVL(l_org_id,-99);
1766: ((l_history_rec.amount_due_original
1767: + l_history_rec.amount_adjusted)
1768: * (l_history_rec2.due_date -l_history_rec.due_date)),
1769: LAST_UPDATE_DATE = sysdate,
1770: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1771: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1772: WHERE cust_account_id = l_history_rec.customer_id
1773: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1774: and currency = l_history_rec.currency_code
1767: + l_history_rec.amount_adjusted)
1768: * (l_history_rec2.due_date -l_history_rec.due_date)),
1769: LAST_UPDATE_DATE = sysdate,
1770: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1771: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1772: WHERE cust_account_id = l_history_rec.customer_id
1773: and site_use_id = nvl(l_history_rec.site_use_id,-99)
1774: and currency = l_history_rec.currency_code
1775: and NVL(org_id,'-99') = NVL(l_org_id,-99)
1898: END IF;
1899: --
1900: --set the application context.
1901: --
1902: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1903: mo_global.init('AR');
1904: mo_global.set_policy_context('S',l_org_id);
1905: --
1906: -- Acquire locks on the payment schedule record so that
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
1940: WHERE customer_trx_id = l_customer_trx_id
1941: and nvl(complete_flag,'N') = 'N';
1942:
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
1940: WHERE customer_trx_id = l_customer_trx_id
1941: and nvl(complete_flag,'N') = 'N';
1942:
1943:
2014: + nvl(l_past_due_inv_amt,0),
2015: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0)
2016: + nvl(l_past_due_inv_count,0),
2017: LAST_UPDATE_DATE = sysdate,
2018: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2019: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2020: WHERE cust_account_id = l_ps_rec.customer_id
2021: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
2022: and currency = l_ps_rec.invoice_currency_code
2015: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0)
2016: + nvl(l_past_due_inv_count,0),
2017: LAST_UPDATE_DATE = sysdate,
2018: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2019: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2020: WHERE cust_account_id = l_ps_rec.customer_id
2021: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
2022: and currency = l_ps_rec.invoice_currency_code
2023: and NVL(org_id,'-99') = NVL(l_org_id,-99);
2053: nvl(l_ps_rec.customer_site_use_id,-99),
2054: l_org_id,
2055: l_ps_rec.invoice_currency_code,
2056: sysdate,
2057: fnd_global.user_id,
2058: sysdate,
2059: fnd_global.user_id,
2060: fnd_global.login_id,
2061: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
2055: l_ps_rec.invoice_currency_code,
2056: sysdate,
2057: fnd_global.user_id,
2058: sysdate,
2059: fnd_global.user_id,
2060: fnd_global.login_id,
2061: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
2062: l_ps_rec.amount_due_original),
2063: DECODE(l_prev_ctx_id, null, l_ps_rec.amount_due_original,
2056: sysdate,
2057: fnd_global.user_id,
2058: sysdate,
2059: fnd_global.user_id,
2060: fnd_global.login_id,
2061: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
2062: l_ps_rec.amount_due_original),
2063: DECODE(l_prev_ctx_id, null, l_ps_rec.amount_due_original,
2064: DECODE(l_prev_trx_class,'CM',l_ps_rec.amount_due_original,0)),
2095: TOTAL_CREDIT_MEMOS_VALUE = nvl(TOTAL_CREDIT_MEMOS_VALUE,0) +
2096: l_ps_rec.amount_due_original,
2097: TOTAL_CREDIT_MEMOS_COUNT = nvl(TOTAL_CREDIT_MEMOS_COUNT,0) + 1,
2098: LAST_UPDATE_DATE = sysdate,
2099: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2100: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2101: WHERE cust_account_id = l_ps_rec.customer_id
2102: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
2103: and currency = l_ps_rec.invoice_currency_code
2096: l_ps_rec.amount_due_original,
2097: TOTAL_CREDIT_MEMOS_COUNT = nvl(TOTAL_CREDIT_MEMOS_COUNT,0) + 1,
2098: LAST_UPDATE_DATE = sysdate,
2099: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2100: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2101: WHERE cust_account_id = l_ps_rec.customer_id
2102: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
2103: and currency = l_ps_rec.invoice_currency_code
2104: and NVL(org_id,'-99') = NVL(l_org_id,-99)
2127: l_org_id,
2128: l_ps_rec.invoice_currency_code,
2129: l_ps_rec.trx_date,
2130: sysdate,
2131: fnd_global.user_id,
2132: sysdate,
2133: fnd_global.user_id,
2134: fnd_global.login_id,
2135: l_ps_rec.amount_due_original+
2129: l_ps_rec.trx_date,
2130: sysdate,
2131: fnd_global.user_id,
2132: sysdate,
2133: fnd_global.user_id,
2134: fnd_global.login_id,
2135: l_ps_rec.amount_due_original+
2136: nvl(l_ps_rec.amount_adjusted,0),
2137: l_ps_rec.amount_due_original,
2130: sysdate,
2131: fnd_global.user_id,
2132: sysdate,
2133: fnd_global.user_id,
2134: fnd_global.login_id,
2135: l_ps_rec.amount_due_original+
2136: nvl(l_ps_rec.amount_adjusted,0),
2137: l_ps_rec.amount_due_original,
2138: 1
2253: SAVEPOINT CM_InComplete_Event;
2254: --
2255: --set the application context.
2256: --
2257: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2258: mo_global.init('AR');
2259: mo_global.set_policy_context('S',l_org_id);
2260:
2261: --
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
2280: WHERE payment_schedule_id = l_payment_schedule_id
2281: and history_id = l_history_id
2282: and nvl(complete_flag,'N') = 'N';
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
2280: WHERE payment_schedule_id = l_payment_schedule_id
2281: and history_id = l_history_id
2282: and nvl(complete_flag,'N') = 'N';
2283:
2348: - nvl(l_past_due_inv_amt,0),
2349: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0)
2350: - nvl(l_past_due_inv_count,0),
2351: LAST_UPDATE_DATE = sysdate,
2352: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2353: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2354: WHERE cust_account_id = l_history_rec.customer_id
2355: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2356: and currency = l_history_rec.currency_code
2349: PAST_DUE_INV_INST_COUNT = nvl(PAST_DUE_INV_INST_COUNT,0)
2350: - nvl(l_past_due_inv_count,0),
2351: LAST_UPDATE_DATE = sysdate,
2352: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2353: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2354: WHERE cust_account_id = l_history_rec.customer_id
2355: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2356: and currency = l_history_rec.currency_code
2357: and NVL(org_id,'-99') = NVL(l_org_id,-99);
2365: TOTAL_CREDIT_MEMOS_VALUE = nvl(TOTAL_CREDIT_MEMOS_VALUE,0) -
2366: l_history_rec.amount_due_original,
2367: TOTAL_CREDIT_MEMOS_COUNT = nvl(TOTAL_CREDIT_MEMOS_COUNT,0) - 1,
2368: LAST_UPDATE_DATE = sysdate,
2369: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2370: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2371: WHERE cust_account_id = l_history_rec.customer_id
2372: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2373: and currency = l_history_rec.currency_code
2366: l_history_rec.amount_due_original,
2367: TOTAL_CREDIT_MEMOS_COUNT = nvl(TOTAL_CREDIT_MEMOS_COUNT,0) - 1,
2368: LAST_UPDATE_DATE = sysdate,
2369: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2370: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2371: WHERE cust_account_id = l_history_rec.customer_id
2372: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2373: and currency = l_history_rec.currency_code
2374: and NVL(org_id,'-99') = NVL(l_org_id,-99)
2462: SAVEPOINT DM_Complete_Event;
2463: --
2464: --set the application context.
2465: --
2466: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2467: mo_global.init('AR');
2468: mo_global.set_policy_context('S',l_org_id);
2469:
2470: --
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
2505: WHERE customer_trx_id = l_customer_trx_id
2506: and nvl(complete_flag,'N') = 'N';
2507:
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
2505: WHERE customer_trx_id = l_customer_trx_id
2506: and nvl(complete_flag,'N') = 'N';
2507:
2508:
2531: = nvl(OP_DEBIT_MEMOS_VALUE,0)
2532: +l_ps_tab(j).amount_due_original,
2533: OP_DEBIT_MEMOS_COUNT = nvl(OP_DEBIT_MEMOS_COUNT,0) + 1,
2534: LAST_UPDATE_DATE = sysdate,
2535: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2536: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2537: WHERE cust_account_id = l_ps_tab(j).customer_id
2538: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2539: and currency = l_ps_tab(j).invoice_currency_code
2532: +l_ps_tab(j).amount_due_original,
2533: OP_DEBIT_MEMOS_COUNT = nvl(OP_DEBIT_MEMOS_COUNT,0) + 1,
2534: LAST_UPDATE_DATE = sysdate,
2535: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2536: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2537: WHERE cust_account_id = l_ps_tab(j).customer_id
2538: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2539: and currency = l_ps_tab(j).invoice_currency_code
2540: and NVL(org_id,'-99') = NVL(l_org_id,-99);
2560: nvl(l_ps_tab(j).customer_site_use_id,-99),
2561: l_org_id,
2562: l_ps_tab(j).invoice_currency_code,
2563: sysdate,
2564: fnd_global.user_id,
2565: sysdate,
2566: fnd_global.user_id,
2567: fnd_global.login_id,
2568: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
2562: l_ps_tab(j).invoice_currency_code,
2563: sysdate,
2564: fnd_global.user_id,
2565: sysdate,
2566: fnd_global.user_id,
2567: fnd_global.login_id,
2568: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
2569: l_ps_tab(j).amount_due_original),
2570: l_ps_tab(j).amount_due_original,
2563: sysdate,
2564: fnd_global.user_id,
2565: sysdate,
2566: fnd_global.user_id,
2567: fnd_global.login_id,
2568: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
2569: l_ps_tab(j).amount_due_original),
2570: l_ps_tab(j).amount_due_original,
2571: 1
2582: TOTAL_DEBIT_MEMOS_VALUE = nvl(TOTAL_DEBIT_MEMOS_VALUE,0) +
2583: l_ps_tab(j).amount_due_original,
2584: TOTAL_DEBIT_MEMOS_COUNT = nvl(TOTAL_DEBIT_MEMOS_COUNT,0) + 1,
2585: LAST_UPDATE_DATE = sysdate,
2586: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2587: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2588: WHERE cust_account_id = l_ps_tab(j).customer_id
2589: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2590: and currency = l_ps_tab(j).invoice_currency_code
2583: l_ps_tab(j).amount_due_original,
2584: TOTAL_DEBIT_MEMOS_COUNT = nvl(TOTAL_DEBIT_MEMOS_COUNT,0) + 1,
2585: LAST_UPDATE_DATE = sysdate,
2586: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2587: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2588: WHERE cust_account_id = l_ps_tab(j).customer_id
2589: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2590: and currency = l_ps_tab(j).invoice_currency_code
2591: and NVL(org_id,'-99') = NVL(l_org_id,-99)
2614: l_org_id,
2615: l_ps_tab(j).invoice_currency_code,
2616: l_ps_tab(j).trx_date,
2617: sysdate,
2618: fnd_global.user_id,
2619: sysdate,
2620: fnd_global.user_id,
2621: fnd_global.login_id,
2622: l_ps_tab(j).amount_due_original,
2616: l_ps_tab(j).trx_date,
2617: sysdate,
2618: fnd_global.user_id,
2619: sysdate,
2620: fnd_global.user_id,
2621: fnd_global.login_id,
2622: l_ps_tab(j).amount_due_original,
2623: l_ps_tab(j).amount_due_original,
2624: 1
2617: sysdate,
2618: fnd_global.user_id,
2619: sysdate,
2620: fnd_global.user_id,
2621: fnd_global.login_id,
2622: l_ps_tab(j).amount_due_original,
2623: l_ps_tab(j).amount_due_original,
2624: 1
2625: );
2715: END IF;
2716: --
2717: --set the application context.
2718: --
2719: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2720: mo_global.init('AR');
2721: mo_global.set_policy_context('S',l_org_id);
2722: --
2723: -- No need to acquire locks on the payment schedule record
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
2741: WHERE payment_schedule_id = l_payment_schedule_id
2742: and history_id = l_history_id
2743: and nvl(complete_flag,'N') = 'N';
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
2741: WHERE payment_schedule_id = l_payment_schedule_id
2742: and history_id = l_history_id
2743: and nvl(complete_flag,'N') = 'N';
2744:
2769: = nvl(OP_DEBIT_MEMOS_VALUE,0)
2770: -l_history_rec.amount_due_original,
2771: OP_DEBIT_MEMOS_COUNT = nvl(OP_DEBIT_MEMOS_COUNT,0) - 1,
2772: LAST_UPDATE_DATE = sysdate,
2773: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2774: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2775: WHERE cust_account_id = l_history_rec.customer_id
2776: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2777: and currency = l_history_rec.currency_code
2770: -l_history_rec.amount_due_original,
2771: OP_DEBIT_MEMOS_COUNT = nvl(OP_DEBIT_MEMOS_COUNT,0) - 1,
2772: LAST_UPDATE_DATE = sysdate,
2773: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2774: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2775: WHERE cust_account_id = l_history_rec.customer_id
2776: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2777: and currency = l_history_rec.currency_code
2778: and NVL(org_id,'-99') = NVL(l_org_id,-99);
2792: TOTAL_DEBIT_MEMOS_VALUE = nvl(TOTAL_DEBIT_MEMOS_VALUE,0) -
2793: l_history_rec.amount_due_original,
2794: TOTAL_DEBIT_MEMOS_COUNT = nvl(TOTAL_DEBIT_MEMOS_COUNT,0) - 1,
2795: LAST_UPDATE_DATE = sysdate,
2796: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2797: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2798: WHERE cust_account_id = l_history_rec.customer_id
2799: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2800: and currency = l_history_rec.currency_code
2793: l_history_rec.amount_due_original,
2794: TOTAL_DEBIT_MEMOS_COUNT = nvl(TOTAL_DEBIT_MEMOS_COUNT,0) - 1,
2795: LAST_UPDATE_DATE = sysdate,
2796: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2797: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2798: WHERE cust_account_id = l_history_rec.customer_id
2799: and site_use_id = nvl(l_history_rec.site_use_id,-99)
2800: and currency = l_history_rec.currency_code
2801: and NVL(org_id,'-99') = NVL(l_org_id,-99)
2903: END IF;
2904: --
2905: --set the application context.
2906: --
2907: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2908: mo_global.init('AR');
2909: mo_global.set_policy_context('S',l_org_id);
2910:
2911: --
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
2946: WHERE customer_trx_id = l_customer_trx_id
2947: and nvl(complete_flag,'N') = 'N';
2948:
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
2946: WHERE customer_trx_id = l_customer_trx_id
2947: and nvl(complete_flag,'N') = 'N';
2948:
2949:
2973: +l_ps_tab(j).amount_due_original
2974: +nvl(l_ps_tab(j).amount_adjusted,0),
2975: OP_DEPOSITS_COUNT = nvl(OP_DEPOSITS_COUNT,0) + 1,
2976: LAST_UPDATE_DATE = sysdate,
2977: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2978: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2979: WHERE cust_account_id = l_ps_tab(j).customer_id
2980: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2981: and currency = l_ps_tab(j).invoice_currency_code
2974: +nvl(l_ps_tab(j).amount_adjusted,0),
2975: OP_DEPOSITS_COUNT = nvl(OP_DEPOSITS_COUNT,0) + 1,
2976: LAST_UPDATE_DATE = sysdate,
2977: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2978: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2979: WHERE cust_account_id = l_ps_tab(j).customer_id
2980: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
2981: and currency = l_ps_tab(j).invoice_currency_code
2982: and NVL(org_id,'-99') = NVL(l_org_id,-99);
3002: nvl(l_ps_tab(j).customer_site_use_id,-99),
3003: l_org_id,
3004: l_ps_tab(j).invoice_currency_code,
3005: sysdate,
3006: fnd_global.user_id,
3007: sysdate,
3008: fnd_global.user_id,
3009: fnd_global.login_id,
3010: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
3004: l_ps_tab(j).invoice_currency_code,
3005: sysdate,
3006: fnd_global.user_id,
3007: sysdate,
3008: fnd_global.user_id,
3009: fnd_global.login_id,
3010: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
3011: l_ps_tab(j).amount_due_original),
3012: l_ps_tab(j).amount_due_original,
3005: sysdate,
3006: fnd_global.user_id,
3007: sysdate,
3008: fnd_global.user_id,
3009: fnd_global.login_id,
3010: DECODE(sign(l_ps_tab(j).due_date - sysdate),-1,0,
3011: l_ps_tab(j).amount_due_original),
3012: l_ps_tab(j).amount_due_original,
3013: 1
3025: TOTAL_DEPOSITS_VALUE = nvl(TOTAL_DEPOSITS_VALUE,0) +
3026: l_ps_tab(j).amount_due_original,
3027: TOTAL_DEPOSITS_COUNT = nvl(TOTAL_DEPOSITS_COUNT,0) + 1,
3028: LAST_UPDATE_DATE = sysdate,
3029: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3030: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3031: WHERE cust_account_id = l_ps_tab(j).customer_id
3032: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
3033: and currency = l_ps_tab(j).invoice_currency_code
3026: l_ps_tab(j).amount_due_original,
3027: TOTAL_DEPOSITS_COUNT = nvl(TOTAL_DEPOSITS_COUNT,0) + 1,
3028: LAST_UPDATE_DATE = sysdate,
3029: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3030: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3031: WHERE cust_account_id = l_ps_tab(j).customer_id
3032: and site_use_id = nvl(l_ps_tab(j).customer_site_use_id,-99)
3033: and currency = l_ps_tab(j).invoice_currency_code
3034: and NVL(org_id,'-99') = NVL(l_org_id,-99)
3057: l_org_id,
3058: l_ps_tab(j).invoice_currency_code,
3059: l_ps_tab(j).trx_date,
3060: sysdate,
3061: fnd_global.user_id,
3062: sysdate,
3063: fnd_global.user_id,
3064: fnd_global.login_id,
3065: l_ps_tab(j).amount_due_original+
3059: l_ps_tab(j).trx_date,
3060: sysdate,
3061: fnd_global.user_id,
3062: sysdate,
3063: fnd_global.user_id,
3064: fnd_global.login_id,
3065: l_ps_tab(j).amount_due_original+
3066: nvl(l_ps_tab(j).amount_adjusted,0),
3067: l_ps_tab(j).amount_due_original,
3060: sysdate,
3061: fnd_global.user_id,
3062: sysdate,
3063: fnd_global.user_id,
3064: fnd_global.login_id,
3065: l_ps_tab(j).amount_due_original+
3066: nvl(l_ps_tab(j).amount_adjusted,0),
3067: l_ps_tab(j).amount_due_original,
3068: 1
3158: SAVEPOINT Dep_InComplete_Event;
3159: --
3160: --set the application context.
3161: --
3162: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3163: mo_global.init('AR');
3164: mo_global.set_policy_context('S',l_org_id);
3165:
3166: --
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
3185: WHERE payment_schedule_id = l_payment_schedule_id
3186: and history_id = l_history_id
3187: and nvl(complete_flag,'N') = 'N';
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
3185: WHERE payment_schedule_id = l_payment_schedule_id
3186: and history_id = l_history_id
3187: and nvl(complete_flag,'N') = 'N';
3188:
3213: = nvl(OP_DEPOSITS_VALUE,0)
3214: -l_history_rec.amount_due_original,
3215: OP_DEPOSITS_COUNT = nvl(OP_DEPOSITS_COUNT,0) - 1,
3216: LAST_UPDATE_DATE = sysdate,
3217: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3218: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3219: WHERE cust_account_id = l_history_rec.customer_id
3220: and site_use_id = nvl(l_history_rec.site_use_id,-99)
3221: and currency = l_history_rec.currency_code
3214: -l_history_rec.amount_due_original,
3215: OP_DEPOSITS_COUNT = nvl(OP_DEPOSITS_COUNT,0) - 1,
3216: LAST_UPDATE_DATE = sysdate,
3217: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3218: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3219: WHERE cust_account_id = l_history_rec.customer_id
3220: and site_use_id = nvl(l_history_rec.site_use_id,-99)
3221: and currency = l_history_rec.currency_code
3222: and NVL(org_id,'-99') = NVL(l_org_id,-99);
3236: TOTAL_DEPOSITS_VALUE = nvl(TOTAL_DEPOSITS_VALUE,0) -
3237: l_history_rec.amount_due_original,
3238: TOTAL_DEPOSITS_COUNT = nvl(TOTAL_DEPOSITS_COUNT,0) - 1,
3239: LAST_UPDATE_DATE = sysdate,
3240: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3241: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3242: WHERE cust_account_id = l_history_rec.customer_id
3243: and site_use_id = nvl(l_history_rec.site_use_id,-99)
3244: and currency = l_history_rec.currency_code
3237: l_history_rec.amount_due_original,
3238: TOTAL_DEPOSITS_COUNT = nvl(TOTAL_DEPOSITS_COUNT,0) - 1,
3239: LAST_UPDATE_DATE = sysdate,
3240: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3241: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3242: WHERE cust_account_id = l_history_rec.customer_id
3243: and site_use_id = nvl(l_history_rec.site_use_id,-99)
3244: and currency = l_history_rec.currency_code
3245: and NVL(org_id,'-99') = NVL(l_org_id,-99)
3349: SAVEPOINT CB_Create;
3350: --
3351: --set the application context.
3352: --
3353: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3354: mo_global.init('AR');
3355: mo_global.set_policy_context('S',l_org_id);
3356: --
3357: -- Acquire locks on the payment schedule record so that
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
3391: WHERE customer_trx_id = l_customer_trx_id
3392: and nvl(complete_flag,'N') = 'N';
3393:
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
3391: WHERE customer_trx_id = l_customer_trx_id
3392: and nvl(complete_flag,'N') = 'N';
3393:
3394:
3415: = nvl(OP_CHARGEBACK_VALUE,0)
3416: +l_ps_rec.amount_due_original,
3417: OP_CHARGEBACK_COUNT = nvl(OP_CHARGEBACK_COUNT,0) + 1,
3418: LAST_UPDATE_DATE = sysdate,
3419: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3420: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3421: WHERE cust_account_id = l_ps_rec.customer_id
3422: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
3423: and currency = l_ps_rec.invoice_currency_code
3416: +l_ps_rec.amount_due_original,
3417: OP_CHARGEBACK_COUNT = nvl(OP_CHARGEBACK_COUNT,0) + 1,
3418: LAST_UPDATE_DATE = sysdate,
3419: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3420: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3421: WHERE cust_account_id = l_ps_rec.customer_id
3422: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
3423: and currency = l_ps_rec.invoice_currency_code
3424: and NVL(org_id,'-99') = NVL(l_org_id,-99);
3444: nvl(l_ps_rec.customer_site_use_id,-99),
3445: l_org_id,
3446: l_ps_rec.invoice_currency_code,
3447: sysdate,
3448: fnd_global.user_id,
3449: sysdate,
3450: fnd_global.user_id,
3451: fnd_global.login_id,
3452: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
3446: l_ps_rec.invoice_currency_code,
3447: sysdate,
3448: fnd_global.user_id,
3449: sysdate,
3450: fnd_global.user_id,
3451: fnd_global.login_id,
3452: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
3453: l_ps_rec.amount_due_original),
3454: l_ps_rec.amount_due_original,
3447: sysdate,
3448: fnd_global.user_id,
3449: sysdate,
3450: fnd_global.user_id,
3451: fnd_global.login_id,
3452: DECODE(sign(l_ps_rec.due_date - sysdate),-1,0,
3453: l_ps_rec.amount_due_original),
3454: l_ps_rec.amount_due_original,
3455: 1
3466: TOTAL_CHARGEBACK_VALUE = nvl(TOTAL_CHARGEBACK_VALUE,0) +
3467: l_ps_rec.amount_due_original,
3468: TOTAL_CHARGEBACK_COUNT = nvl(TOTAL_CHARGEBACK_COUNT,0) + 1,
3469: LAST_UPDATE_DATE = sysdate,
3470: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3471: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3472: WHERE cust_account_id = l_ps_rec.customer_id
3473: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
3474: and currency = l_ps_rec.invoice_currency_code
3467: l_ps_rec.amount_due_original,
3468: TOTAL_CHARGEBACK_COUNT = nvl(TOTAL_CHARGEBACK_COUNT,0) + 1,
3469: LAST_UPDATE_DATE = sysdate,
3470: LAST_UPDATED_BY = FND_GLOBAL.user_id,
3471: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
3472: WHERE cust_account_id = l_ps_rec.customer_id
3473: and site_use_id = nvl(l_ps_rec.customer_site_use_id,-99)
3474: and currency = l_ps_rec.invoice_currency_code
3475: and NVL(org_id,'-99') = NVL(l_org_id,-99)
3498: l_org_id,
3499: l_ps_rec.invoice_currency_code,
3500: l_ps_rec.trx_date,
3501: sysdate,
3502: fnd_global.user_id,
3503: sysdate,
3504: fnd_global.user_id,
3505: fnd_global.login_id,
3506: l_ps_rec.amount_due_original,
3500: l_ps_rec.trx_date,
3501: sysdate,
3502: fnd_global.user_id,
3503: sysdate,
3504: fnd_global.user_id,
3505: fnd_global.login_id,
3506: l_ps_rec.amount_due_original,
3507: l_ps_rec.amount_due_original,
3508: 1
3501: sysdate,
3502: fnd_global.user_id,
3503: sysdate,
3504: fnd_global.user_id,
3505: fnd_global.login_id,
3506: l_ps_rec.amount_due_original,
3507: l_ps_rec.amount_due_original,
3508: 1
3509: );
3680: SAVEPOINT CR_Create_Event;
3681: --
3682: --set the application context.
3683: --
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
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
3696: WHERE payment_schedule_id = l_payment_schedule_id;
3697:
3698: OPEN get_receipt_details (l_payment_schedule_id);
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
3696: WHERE payment_schedule_id = l_payment_schedule_id;
3697:
3698: OPEN get_receipt_details (l_payment_schedule_id);
3699:
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 NVL(org_id,'-99') = NVL(l_org_id,-99)
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 NVL(org_id,'-99') = NVL(l_org_id,-99)
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 NVL(org_id,'-99') = NVL(l_org_id,-99)
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 NVL(org_id,'-99') = NVL(l_org_id,-99)
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;
3963: SAVEPOINT CR_Reverse;
3964: --
3965: --set the application context.
3966: --
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
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
3976: WHERE payment_schedule_id = l_payment_schedule_id;
3977:
3978: OPEN get_receipt_details (l_payment_schedule_id);
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
3976: WHERE payment_schedule_id = l_payment_schedule_id;
3977:
3978: OPEN get_receipt_details (l_payment_schedule_id);
3979:
4024: last_payment_amount = nvl(l_last_receipt_amount,last_payment_amount),
4025: last_payment_date = nvl(l_last_receipt_date,last_payment_date),
4026: last_payment_number = nvl(l_last_receipt_number,last_payment_number),
4027: LAST_UPDATE_DATE = sysdate,
4028: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4029: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4030: where cust_account_id = l_customer_id
4031: and site_use_id = nvl(l_customer_site_use_id,-99)
4032: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4025: last_payment_date = nvl(l_last_receipt_date,last_payment_date),
4026: last_payment_number = nvl(l_last_receipt_number,last_payment_number),
4027: LAST_UPDATE_DATE = sysdate,
4028: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4029: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4030: where cust_account_id = l_customer_id
4031: and site_use_id = nvl(l_customer_site_use_id,-99)
4032: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4033: and currency = l_currency_code;
4041: nsf_stop_payment_amount = nvl(nsf_stop_payment_amount,0)
4042: - nvl(l_receipt_amount,0),
4043: nsf_stop_payment_count = nvl(nsf_stop_payment_count,0) + 1,
4044: LAST_UPDATE_DATE = sysdate,
4045: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4046: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4047: where cust_account_id = l_customer_id
4048: and site_use_id = nvl(l_customer_site_use_id,-99)
4049: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4042: - nvl(l_receipt_amount,0),
4043: nsf_stop_payment_count = nvl(nsf_stop_payment_count,0) + 1,
4044: LAST_UPDATE_DATE = sysdate,
4045: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4046: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4047: where cust_account_id = l_customer_id
4048: and site_use_id = nvl(l_customer_site_use_id,-99)
4049: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4050: and currency = l_currency_code
4148: SAVEPOINT CR_Modify;
4149: --
4150: --set the application context.
4151: --
4152: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4153: mo_global.init('AR');
4154: mo_global.set_policy_context('S',l_org_id);
4155:
4156: OPEN get_receipt_hist(l_history_id);
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
4210: WHERE history_id = l_history_id
4211: and nvl(complete_flag ,'N') = 'N';
4212:
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
4210: WHERE history_id = l_history_id
4211: and nvl(complete_flag ,'N') = 'N';
4212:
4213:
4225: last_payment_amount = l_receipt_amount,
4226: last_payment_date = l_receipt_date,
4227: last_payment_number = l_receipt_number,
4228: LAST_UPDATE_DATE = sysdate,
4229: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4230: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4231: where cust_account_id = l_customer_id
4232: and site_use_id = nvl(l_customer_site_use_id,-99)
4233: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4226: last_payment_date = l_receipt_date,
4227: last_payment_number = l_receipt_number,
4228: LAST_UPDATE_DATE = sysdate,
4229: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4230: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4231: where cust_account_id = l_customer_id
4232: and site_use_id = nvl(l_customer_site_use_id,-99)
4233: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4234: and currency = l_currency_code;
4254: nvl(l_customer_site_use_id,-99),
4255: l_org_id,
4256: l_currency_code,
4257: sysdate,
4258: fnd_global.user_id,
4259: sysdate,
4260: fnd_global.user_id,
4261: fnd_global.login_id,
4262: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4256: l_currency_code,
4257: sysdate,
4258: fnd_global.user_id,
4259: sysdate,
4260: fnd_global.user_id,
4261: fnd_global.login_id,
4262: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4263: 1,
4264: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4257: sysdate,
4258: fnd_global.user_id,
4259: sysdate,
4260: fnd_global.user_id,
4261: fnd_global.login_id,
4262: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4263: 1,
4264: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4265: l_receipt_date,
4274: set total_cash_receipts_value = nvl(total_cash_receipts_value,0) +
4275: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4276: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4277: LAST_UPDATE_DATE = sysdate,
4278: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4279: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4280: where cust_account_id = l_customer_id
4281: and site_use_id = nvl(l_customer_site_use_id,-99)
4282: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4275: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4276: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4277: LAST_UPDATE_DATE = sysdate,
4278: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4279: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4280: where cust_account_id = l_customer_id
4281: and site_use_id = nvl(l_customer_site_use_id,-99)
4282: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4283: and currency = l_currency_code
4304: l_org_id,
4305: l_currency_code,
4306: l_receipt_date,
4307: sysdate,
4308: fnd_global.user_id,
4309: sysdate,
4310: fnd_global.user_id,
4311: fnd_global.login_id,
4312: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4306: l_receipt_date,
4307: sysdate,
4308: fnd_global.user_id,
4309: sysdate,
4310: fnd_global.user_id,
4311: fnd_global.login_id,
4312: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4313: 1);
4314:
4307: sysdate,
4308: fnd_global.user_id,
4309: sysdate,
4310: fnd_global.user_id,
4311: fnd_global.login_id,
4312: (l_receipt_amount - nvl(l_hist_rec.amount_due_original,0)),
4313: 1);
4314:
4315: END IF;
4322: last_payment_amount = nvl(l_hist_rec.amount_due_original,0),
4323: last_payment_date = l_receipt_date,
4324: last_payment_number = l_receipt_number,
4325: LAST_UPDATE_DATE = sysdate,
4326: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4327: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4328: where cust_account_id = l_hist_rec.customer_id
4329: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4330: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4323: last_payment_date = l_receipt_date,
4324: last_payment_number = l_receipt_number,
4325: LAST_UPDATE_DATE = sysdate,
4326: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4327: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4328: where cust_account_id = l_hist_rec.customer_id
4329: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4330: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4331: and currency = l_currency_code;
4351: nvl(l_hist_rec.site_use_id,-99),
4352: l_org_id,
4353: l_currency_code,
4354: sysdate,
4355: fnd_global.user_id,
4356: sysdate,
4357: fnd_global.user_id,
4358: fnd_global.login_id,
4359: l_hist_rec.amount_due_original,
4353: l_currency_code,
4354: sysdate,
4355: fnd_global.user_id,
4356: sysdate,
4357: fnd_global.user_id,
4358: fnd_global.login_id,
4359: l_hist_rec.amount_due_original,
4360: 1,
4361: l_hist_rec.amount_due_original,
4354: sysdate,
4355: fnd_global.user_id,
4356: sysdate,
4357: fnd_global.user_id,
4358: fnd_global.login_id,
4359: l_hist_rec.amount_due_original,
4360: 1,
4361: l_hist_rec.amount_due_original,
4362: l_receipt_date,
4369: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4370: - nvl(l_hist_rec.amount_due_original,0) ,
4371: total_cash_receipts_count = nvl(total_cash_receipts_count,0) -1,
4372: LAST_UPDATE_DATE = sysdate,
4373: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4374: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4375: where cust_account_id = l_hist_rec.customer_id
4376: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4377: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4370: - nvl(l_hist_rec.amount_due_original,0) ,
4371: total_cash_receipts_count = nvl(total_cash_receipts_count,0) -1,
4372: LAST_UPDATE_DATE = sysdate,
4373: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4374: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4375: where cust_account_id = l_hist_rec.customer_id
4376: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4377: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4378: and currency = l_currency_code
4398: l_org_id,
4399: l_currency_code,
4400: l_receipt_date,
4401: sysdate,
4402: fnd_global.user_id,
4403: sysdate,
4404: fnd_global.user_id,
4405: fnd_global.login_id,
4406: l_hist_rec.amount_due_original,
4400: l_receipt_date,
4401: sysdate,
4402: fnd_global.user_id,
4403: sysdate,
4404: fnd_global.user_id,
4405: fnd_global.login_id,
4406: l_hist_rec.amount_due_original,
4407: 1);
4408: END IF;
4401: sysdate,
4402: fnd_global.user_id,
4403: sysdate,
4404: fnd_global.user_id,
4405: fnd_global.login_id,
4406: l_hist_rec.amount_due_original,
4407: 1);
4408: END IF;
4409: ELSIF l_customer_id IS NOT NULL AND l_hist_rec.customer_id IS NULL THEN
4415: last_payment_amount = l_receipt_amount,
4416: last_payment_date = l_receipt_date,
4417: last_payment_number = l_receipt_number,
4418: LAST_UPDATE_DATE = sysdate,
4419: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4420: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4421: where cust_account_id = l_customer_id
4422: and site_use_id = nvl(l_customer_site_use_id,-99)
4423: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4416: last_payment_date = l_receipt_date,
4417: last_payment_number = l_receipt_number,
4418: LAST_UPDATE_DATE = sysdate,
4419: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4420: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4421: where cust_account_id = l_customer_id
4422: and site_use_id = nvl(l_customer_site_use_id,-99)
4423: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4424: and currency = l_currency_code;
4444: nvl(l_customer_site_use_id,-99),
4445: l_org_id,
4446: l_currency_code,
4447: sysdate,
4448: fnd_global.user_id,
4449: sysdate,
4450: fnd_global.user_id,
4451: fnd_global.login_id,
4452: l_receipt_amount,
4446: l_currency_code,
4447: sysdate,
4448: fnd_global.user_id,
4449: sysdate,
4450: fnd_global.user_id,
4451: fnd_global.login_id,
4452: l_receipt_amount,
4453: 1,
4454: l_receipt_amount,
4447: sysdate,
4448: fnd_global.user_id,
4449: sysdate,
4450: fnd_global.user_id,
4451: fnd_global.login_id,
4452: l_receipt_amount,
4453: 1,
4454: l_receipt_amount,
4455: l_receipt_date,
4462: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4463: + l_receipt_amount ,
4464: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4465: LAST_UPDATE_DATE = sysdate,
4466: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4467: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4468: where cust_account_id = l_customer_id
4469: and site_use_id = nvl(l_customer_site_use_id,-99)
4470: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4463: + l_receipt_amount ,
4464: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4465: LAST_UPDATE_DATE = sysdate,
4466: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4467: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4468: where cust_account_id = l_customer_id
4469: and site_use_id = nvl(l_customer_site_use_id,-99)
4470: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4471: and currency = l_currency_code
4491: l_org_id,
4492: l_currency_code,
4493: l_receipt_date,
4494: sysdate,
4495: fnd_global.user_id,
4496: sysdate,
4497: fnd_global.user_id,
4498: fnd_global.login_id,
4499: l_receipt_amount,
4493: l_receipt_date,
4494: sysdate,
4495: fnd_global.user_id,
4496: sysdate,
4497: fnd_global.user_id,
4498: fnd_global.login_id,
4499: l_receipt_amount,
4500: 1);
4501: END IF;
4494: sysdate,
4495: fnd_global.user_id,
4496: sysdate,
4497: fnd_global.user_id,
4498: fnd_global.login_id,
4499: l_receipt_amount,
4500: 1);
4501: END IF;
4502: ELSIF nvl(l_customer_id,0) <> nvl(l_hist_rec.customer_id,0) THEN
4509: last_payment_amount = nvl(l_hist_rec.amount_due_original,0),
4510: last_payment_date = l_receipt_date,
4511: last_payment_number = l_receipt_number,
4512: LAST_UPDATE_DATE = sysdate,
4513: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4514: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4515: where cust_account_id = l_hist_rec.customer_id
4516: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4517: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4510: last_payment_date = l_receipt_date,
4511: last_payment_number = l_receipt_number,
4512: LAST_UPDATE_DATE = sysdate,
4513: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4514: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4515: where cust_account_id = l_hist_rec.customer_id
4516: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4517: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4518: and currency = l_currency_code;
4538: nvl(l_hist_rec.site_use_id,-99),
4539: l_org_id,
4540: l_currency_code,
4541: sysdate,
4542: fnd_global.user_id,
4543: sysdate,
4544: fnd_global.user_id,
4545: fnd_global.login_id,
4546: l_hist_rec.amount_due_original,
4540: l_currency_code,
4541: sysdate,
4542: fnd_global.user_id,
4543: sysdate,
4544: fnd_global.user_id,
4545: fnd_global.login_id,
4546: l_hist_rec.amount_due_original,
4547: 1,
4548: l_hist_rec.amount_due_original,
4541: sysdate,
4542: fnd_global.user_id,
4543: sysdate,
4544: fnd_global.user_id,
4545: fnd_global.login_id,
4546: l_hist_rec.amount_due_original,
4547: 1,
4548: l_hist_rec.amount_due_original,
4549: l_receipt_date,
4556: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4557: - nvl(l_hist_rec.amount_due_original,0) ,
4558: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4559: LAST_UPDATE_DATE = sysdate,
4560: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4561: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4562: where cust_account_id = l_hist_rec.customer_id
4563: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4564: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4557: - nvl(l_hist_rec.amount_due_original,0) ,
4558: total_cash_receipts_count = nvl(total_cash_receipts_count,0),
4559: LAST_UPDATE_DATE = sysdate,
4560: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4561: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4562: where cust_account_id = l_hist_rec.customer_id
4563: and site_use_id = nvl(l_hist_rec.site_use_id,-99)
4564: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4565: and currency = l_currency_code
4585: l_org_id,
4586: l_currency_code,
4587: l_receipt_date,
4588: sysdate,
4589: fnd_global.user_id,
4590: sysdate,
4591: fnd_global.user_id,
4592: fnd_global.login_id,
4593: l_hist_rec.amount_due_original,
4587: l_receipt_date,
4588: sysdate,
4589: fnd_global.user_id,
4590: sysdate,
4591: fnd_global.user_id,
4592: fnd_global.login_id,
4593: l_hist_rec.amount_due_original,
4594: 1);
4595: END IF;
4588: sysdate,
4589: fnd_global.user_id,
4590: sysdate,
4591: fnd_global.user_id,
4592: fnd_global.login_id,
4593: l_hist_rec.amount_due_original,
4594: 1);
4595: END IF;
4596:
4602: last_payment_amount = l_receipt_amount,
4603: last_payment_date = l_receipt_date,
4604: last_payment_number = l_receipt_number,
4605: LAST_UPDATE_DATE = sysdate,
4606: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4607: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4608: where cust_account_id = l_customer_id
4609: and site_use_id = nvl(l_customer_site_use_id,-99)
4610: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4603: last_payment_date = l_receipt_date,
4604: last_payment_number = l_receipt_number,
4605: LAST_UPDATE_DATE = sysdate,
4606: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4607: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4608: where cust_account_id = l_customer_id
4609: and site_use_id = nvl(l_customer_site_use_id,-99)
4610: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4611: and currency = l_currency_code;
4631: nvl(l_customer_site_use_id,-99),
4632: l_org_id,
4633: l_currency_code,
4634: sysdate,
4635: fnd_global.user_id,
4636: sysdate,
4637: fnd_global.user_id,
4638: fnd_global.login_id,
4639: l_receipt_amount,
4633: l_currency_code,
4634: sysdate,
4635: fnd_global.user_id,
4636: sysdate,
4637: fnd_global.user_id,
4638: fnd_global.login_id,
4639: l_receipt_amount,
4640: 1,
4641: l_receipt_amount,
4634: sysdate,
4635: fnd_global.user_id,
4636: sysdate,
4637: fnd_global.user_id,
4638: fnd_global.login_id,
4639: l_receipt_amount,
4640: 1,
4641: l_receipt_amount,
4642: l_receipt_date,
4650: set total_cash_receipts_value = nvl(total_cash_receipts_value,0)
4651: + l_receipt_amount ,
4652: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4653: LAST_UPDATE_DATE = sysdate,
4654: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4655: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4656: where cust_account_id = l_customer_id
4657: and site_use_id = nvl(l_customer_site_use_id,-99)
4658: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4651: + l_receipt_amount ,
4652: total_cash_receipts_count = nvl(total_cash_receipts_count,0)+1,
4653: LAST_UPDATE_DATE = sysdate,
4654: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4655: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4656: where cust_account_id = l_customer_id
4657: and site_use_id = nvl(l_customer_site_use_id,-99)
4658: and NVL(org_id,'-99') = NVL(l_org_id,-99)
4659: and currency = l_currency_code
4679: l_org_id,
4680: l_currency_code,
4681: l_receipt_date,
4682: sysdate,
4683: fnd_global.user_id,
4684: sysdate,
4685: fnd_global.user_id,
4686: fnd_global.login_id,
4687: l_receipt_amount ,
4681: l_receipt_date,
4682: sysdate,
4683: fnd_global.user_id,
4684: sysdate,
4685: fnd_global.user_id,
4686: fnd_global.login_id,
4687: l_receipt_amount ,
4688: 1);
4689: END IF;
4682: sysdate,
4683: fnd_global.user_id,
4684: sysdate,
4685: fnd_global.user_id,
4686: fnd_global.login_id,
4687: l_receipt_amount ,
4688: 1);
4689: END IF;
4690:
4885: SAVEPOINT CR_Delete;
4886: --
4887: --set the application context.
4888: --
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
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
4898: WHERE payment_schedule_id = l_payment_schedule_id;
4899:
4900: FOR k IN hist(l_payment_schedule_id) LOOP
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
4898: WHERE payment_schedule_id = l_payment_schedule_id;
4899:
4900: FOR k IN hist(l_payment_schedule_id) LOOP
4901: IF k.customer_id IS NOT NULL THEN
4932: last_payment_amount = NVL(l_last_receipt_amount,last_payment_amount),
4933: last_payment_date = NVL(l_last_receipt_date,last_payment_date),
4934: last_payment_number = NVL(l_last_receipt_number,last_payment_number),
4935: LAST_UPDATE_DATE = sysdate,
4936: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4937: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4938: WHERE cust_account_id = k.customer_id
4939: AND site_use_id = nvl(k.site_use_id,-99)
4940: AND NVL(org_id,'-99') = NVL(l_org_id,-99)
4933: last_payment_date = NVL(l_last_receipt_date,last_payment_date),
4934: last_payment_number = NVL(l_last_receipt_number,last_payment_number),
4935: LAST_UPDATE_DATE = sysdate,
4936: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4937: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4938: WHERE cust_account_id = k.customer_id
4939: AND site_use_id = nvl(k.site_use_id,-99)
4940: AND NVL(org_id,'-99') = NVL(l_org_id,-99)
4941: AND currency = k.currency_code;
4946: SET total_cash_receipts_value = nvl(total_cash_receipts_value,0) -
4947: nvl(k.amount_due_original * -1, 0),
4948: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,
4949: LAST_UPDATE_DATE = sysdate,
4950: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4951: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4952: WHERE cust_account_id = k.customer_id
4953: AND site_use_id = nvl(k.site_use_id,-99)
4954: AND NVL(org_id,'-99') = NVL(l_org_id,-99)
4947: nvl(k.amount_due_original * -1, 0),
4948: total_cash_receipts_count = nvl(total_cash_receipts_count,0) - 1,
4949: LAST_UPDATE_DATE = sysdate,
4950: LAST_UPDATED_BY = FND_GLOBAL.user_id,
4951: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
4952: WHERE cust_account_id = k.customer_id
4953: AND site_use_id = nvl(k.site_use_id,-99)
4954: AND NVL(org_id,'-99') = NVL(l_org_id,-99)
4955: AND currency = k.currency_code
5061: END IF;
5062: --
5063: --set the application context.
5064: --
5065: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5066: mo_global.init('AR');
5067: mo_global.set_policy_context('S',l_org_id);
5068:
5069: select to_date(l_due_date_str, 'J')
5270: SAVEPOINT CM_UnApply_Event;
5271: --
5272: --set the application context.
5273: --
5274: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5275: mo_global.init('AR');
5276: mo_global.set_policy_context('S',l_org_id);
5277:
5278: select to_date(l_due_date_str, 'J')
5503: END IF;
5504: --
5505: --set the application context.
5506: --
5507: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5508: mo_global.init('AR');
5509: mo_global.set_policy_context('S',l_org_id);
5510:
5511: select to_date(l_due_date_str, 'J')
5802: END IF;
5803: --
5804: --set the application context.
5805: --
5806: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5807: mo_global.init('AR');
5808: mo_global.set_policy_context('S',l_org_id);
5809:
5810: select to_date(l_due_date_str, 'J')
6202: SAVEPOINT AutoInv_Run_Event;
6203: --
6204: --set the application context.
6205: --
6206: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6207: mo_global.init('AR');
6208: mo_global.set_policy_context('S',l_org_id);
6209:
6210: Update_summary_for_request_id(l_request_id);
6266: SAVEPOINT AutoRcpt_Run_Event;
6267: --
6268: --set the application context.
6269: --
6270: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6271: mo_global.init('AR');
6272: mo_global.set_policy_context('S',l_org_id);
6273:
6274: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6357: SAVEPOINT AutoADJ_Run_Event;
6358: --
6359: --set the application context.
6360: --
6361: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6362: mo_global.init('AR');
6363: mo_global.set_policy_context('S',l_org_id);
6364:
6365: OPEN get_adj(l_request_id);
6467: SAVEPOINT QuickCash_PostBatch_pvt;
6468: --
6469: --set the application context.
6470: --
6471: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6472: mo_global.init('AR');
6473: mo_global.set_policy_context('S',l_org_id);
6474:
6475: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6580: SAVEPOINT ADJCreate_Event;
6581: --
6582: --set the application context.
6583: --
6584: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6585: mo_global.init('AR');
6586: mo_global.set_policy_context('S',l_org_id);
6587:
6588: OPEN get_adj_details (l_adjustment_id);
6747: SAVEPOINT ADJApprove_Event;
6748: --
6749: --set the application context.
6750: --
6751: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6752: mo_global.init('AR');
6753: mo_global.set_policy_context('S',l_org_id);
6754:
6755: OPEN get_adj_details (l_adjustment_id);
6883: SAVEPOINT CopyInv_Run_Event;
6884: --
6885: --set the application context.
6886: --
6887: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6888: mo_global.init('AR');
6889: mo_global.set_policy_context('S',l_org_id);
6890:
6891: Update_summary_for_request_id(l_request_id);
7189: group by trx_ps.customer_id, trx_ps.customer_site_use_id,
7190: trx_ps.invoice_currency_code, trx_ps.org_id),
7191: /* WHO columns */
7192: last_update_date = sysdate,
7193: last_updated_by = fnd_global.user_id,
7194: last_update_login= fnd_global.login_id
7195: where cust_account_id = p_customer_id_tab(i)
7196: and site_use_id = p_site_use_id_tab(i)
7197: and currency = p_currency_tab(i)
7190: trx_ps.invoice_currency_code, trx_ps.org_id),
7191: /* WHO columns */
7192: last_update_date = sysdate,
7193: last_updated_by = fnd_global.user_id,
7194: last_update_login= fnd_global.login_id
7195: where cust_account_id = p_customer_id_tab(i)
7196: and site_use_id = p_site_use_id_tab(i)
7197: and currency = p_currency_tab(i)
7198: and NVL(org_id,'-99') = NVL(p_org_id_tab(i),-99);
7262: GROUP BY cr.pay_from_customer, nvl(cr.customer_site_use_id,-99),
7263: cr.currency_code, cr.org_id),
7264: /* WHO columns */
7265: last_update_date = sysdate,
7266: last_updated_by = fnd_global.user_id,
7267: last_update_login= fnd_global.login_id
7268: WHERE cust_account_id = p_customer_id_tab(i)
7269: AND site_use_id = p_site_use_id_tab(i)
7270: AND currency = p_currency_tab(i)
7263: cr.currency_code, cr.org_id),
7264: /* WHO columns */
7265: last_update_date = sysdate,
7266: last_updated_by = fnd_global.user_id,
7267: last_update_login= fnd_global.login_id
7268: WHERE cust_account_id = p_customer_id_tab(i)
7269: AND site_use_id = p_site_use_id_tab(i)
7270: AND currency = p_currency_tab(i)
7271: AND NVL(org_id,'-99') = NVL(p_org_id_tab(i),-99);
7305: GROUP BY cr.pay_from_customer, cr.customer_site_use_id,
7306: cr.currency_code, cr.org_id),
7307: /* WHO columns */
7308: last_update_date = sysdate,
7309: last_updated_by = fnd_global.user_id,
7310: last_update_login= fnd_global.login_id
7311: WHERE cust_account_id = p_customer_id_tab(0)
7312: AND site_use_id = p_site_use_id_tab(0)
7313: AND currency = p_currency_tab(0)
7306: cr.currency_code, cr.org_id),
7307: /* WHO columns */
7308: last_update_date = sysdate,
7309: last_updated_by = fnd_global.user_id,
7310: last_update_login= fnd_global.login_id
7311: WHERE cust_account_id = p_customer_id_tab(0)
7312: AND site_use_id = p_site_use_id_tab(0)
7313: AND currency = p_currency_tab(0)
7314: AND NVL(org_id,'-99') = NVL(p_org_id_tab(0),-99);