291: -- Add Context values to the list
292: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
293:
294: -- add more parameters to the parameters list
295: wf_event.AddParameterToList(p_name => 'CUSTOMER_TRX_ID',
296: p_value => p_customer_trx_id,
297: p_parameterlist => l_list);
298:
299:
337:
338: l_prev_trx_op_count := l_cm_op_trx_count - l_cm_cl_trx_count;
339:
340: -- add more parameters to the parameters list
341: wf_event.AddParameterToList(p_name => 'PREV_TRX_OP_COUNT',
342: p_value => l_prev_trx_op_count,
343: p_parameterlist => l_list);
344:
345: wf_event.AddParameterToList(p_name => 'PREV_TRX_APP_AMT',
341: wf_event.AddParameterToList(p_name => 'PREV_TRX_OP_COUNT',
342: p_value => l_prev_trx_op_count,
343: p_parameterlist => l_list);
344:
345: wf_event.AddParameterToList(p_name => 'PREV_TRX_APP_AMT',
346: p_value => l_prev_trx_app_amt,
347: p_parameterlist => l_list);
348:
349: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_AMT',
345: wf_event.AddParameterToList(p_name => 'PREV_TRX_APP_AMT',
346: p_value => l_prev_trx_app_amt,
347: p_parameterlist => l_list);
348:
349: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_AMT',
350: p_value => l_past_due_inv_amt,
351: p_parameterlist => l_list);
352: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_COUNT',
353: p_value => l_past_due_inv_count,
348:
349: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_AMT',
350: p_value => l_past_due_inv_amt,
351: p_parameterlist => l_list);
352: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_COUNT',
353: p_value => l_past_due_inv_count,
354: p_parameterlist => l_list);
355:
356: END IF;
451: -- Add Context values to the list
452: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
453:
454: -- add more parameters to the parameters list
455: wf_event.AddParameterToList(p_name => 'CUSTOMER_TRX_ID',
456: p_value => p_customer_trx_id,
457: p_parameterlist => l_list);
458:
459: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
455: wf_event.AddParameterToList(p_name => 'CUSTOMER_TRX_ID',
456: p_value => p_customer_trx_id,
457: p_parameterlist => l_list);
458:
459: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
460: p_value => p_ps_id,
461: p_parameterlist => l_list);
462:
463: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
459: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
460: p_value => p_ps_id,
461: p_parameterlist => l_list);
462:
463: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
464: p_value => p_history_id,
465: p_parameterlist => l_list);
466: IF p_doc_type = 'CM' THEN
467: l_cm_cl_trx_count := 0;
505:
506: l_prev_trx_op_count := l_cm_op_trx_count - l_cm_cl_trx_count;
507:
508: -- add more parameters to the parameters list
509: wf_event.AddParameterToList(p_name => 'PREV_TRX_OP_COUNT',
510: p_value => l_prev_trx_op_count,
511: p_parameterlist => l_list);
512:
513: wf_event.AddParameterToList(p_name => 'PREV_TRX_APP_AMT',
509: wf_event.AddParameterToList(p_name => 'PREV_TRX_OP_COUNT',
510: p_value => l_prev_trx_op_count,
511: p_parameterlist => l_list);
512:
513: wf_event.AddParameterToList(p_name => 'PREV_TRX_APP_AMT',
514: p_value => l_prev_trx_app_amt,
515: p_parameterlist => l_list);
516:
517: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_AMT',
513: wf_event.AddParameterToList(p_name => 'PREV_TRX_APP_AMT',
514: p_value => l_prev_trx_app_amt,
515: p_parameterlist => l_list);
516:
517: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_AMT',
518: p_value => l_past_due_inv_amt,
519: p_parameterlist => l_list);
520:
521: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_COUNT',
517: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_AMT',
518: p_value => l_past_due_inv_amt,
519: p_parameterlist => l_list);
520:
521: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_COUNT',
522: p_value => l_past_due_inv_count,
523: p_parameterlist => l_list);
524:
525: wf_event.AddParameterToList(p_name => 'PREV_TRX_TYPE',
521: wf_event.AddParameterToList(p_name => 'PAST_DUE_INV_COUNT',
522: p_value => l_past_due_inv_count,
523: p_parameterlist => l_list);
524:
525: wf_event.AddParameterToList(p_name => 'PREV_TRX_TYPE',
526: p_value => l_prev_trx_type,
527: p_parameterlist => l_list);
528:
529: wf_event.AddParameterToList(p_name => 'PREV_TRX_ID',
525: wf_event.AddParameterToList(p_name => 'PREV_TRX_TYPE',
526: p_value => l_prev_trx_type,
527: p_parameterlist => l_list);
528:
529: wf_event.AddParameterToList(p_name => 'PREV_TRX_ID',
530: p_value => l_prev_ctx_id,
531: p_parameterlist => l_list);
532:
533: END IF;
603: -- Add Context values to the list
604: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
605:
606: -- add more parameters to the parameters list
607: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
608: p_value => p_payment_schedule_id,
609: p_parameterlist => l_list);
610:
611: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
607: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
608: p_value => p_payment_schedule_id,
609: p_parameterlist => l_list);
610:
611: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
612: p_value => p_history_id,
613: p_parameterlist => l_list);
614:
615: -- Raise Event
676: OPEN getCustomerC;
677: FETCH getCustomerC INTO l_cust_account_id;
678: CLOSE getCustomerC;
679: -- add more parameters to the parameters list
680: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
681: p_value => p_payment_schedule_id,
682: p_parameterlist => l_list);
683:
684: wf_event.AddParameterToList(p_name => 'CUST_ACCOUNT_ID',
680: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
681: p_value => p_payment_schedule_id,
682: p_parameterlist => l_list);
683:
684: wf_event.AddParameterToList(p_name => 'CUST_ACCOUNT_ID',
685: p_value => l_cust_account_id,
686: p_parameterlist => l_list);
687:
688: -- Raise Event
742: -- Add Context values to the list
743: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
744:
745: -- add more parameters to the parameters list
746: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
747: p_value => p_payment_schedule_id,
748: p_parameterlist => l_list);
749:
750: wf_event.AddParameterToList(p_name => 'CASH_RECEIPT_ID',
746: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
747: p_value => p_payment_schedule_id,
748: p_parameterlist => l_list);
749:
750: wf_event.AddParameterToList(p_name => 'CASH_RECEIPT_ID',
751: p_value => p_cash_receipt_id,
752: p_parameterlist => l_list);
753:
754: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
750: wf_event.AddParameterToList(p_name => 'CASH_RECEIPT_ID',
751: p_value => p_cash_receipt_id,
752: p_parameterlist => l_list);
753:
754: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
755: p_value => p_history_id,
756: p_parameterlist => l_list);
757:
758: -- Raise Event
809: -- Add Context values to the list
810: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
811:
812: -- add more parameters to the parameters list
813: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
814: p_value => p_payment_schedule_id,
815: p_parameterlist => l_list);
816:
817: wf_event.AddParameterToList(p_name => 'CASH_RECEIPT_ID',
813: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
814: p_value => p_payment_schedule_id,
815: p_parameterlist => l_list);
816:
817: wf_event.AddParameterToList(p_name => 'CASH_RECEIPT_ID',
818: p_value => p_cash_receipt_id,
819: p_parameterlist => l_list);
820:
821: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
817: wf_event.AddParameterToList(p_name => 'CASH_RECEIPT_ID',
818: p_value => p_cash_receipt_id,
819: p_parameterlist => l_list);
820:
821: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
822: p_value => p_history_id,
823: p_parameterlist => l_list);
824:
825: -- Raise Event
876: -- Add Context values to the list
877: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
878:
879: -- add more parameters to the parameters list
880: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
881: p_value => p_payment_schedule_id,
882: p_parameterlist => l_list);
883:
884: wf_event.AddParameterToList(p_name => 'CASH_RECEIPT_ID',
880: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
881: p_value => p_payment_schedule_id,
882: p_parameterlist => l_list);
883:
884: wf_event.AddParameterToList(p_name => 'CASH_RECEIPT_ID',
885: p_value => p_cash_receipt_id,
886: p_parameterlist => l_list);
887:
888: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
884: wf_event.AddParameterToList(p_name => 'CASH_RECEIPT_ID',
885: p_value => p_cash_receipt_id,
886: p_parameterlist => l_list);
887:
888: wf_event.AddParameterToList(p_name => 'HISTORY_ID',
889: p_value => p_history_id,
890: p_parameterlist => l_list);
891:
892: -- Raise Event
979: -- Add Context values to the list
980: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
981:
982: -- add more parameters to the parameters list
983: wf_event.AddParameterToList(p_name => 'RECEIVABLE_APPLICATION_ID',
984: p_value => p_receivable_application_id,
985: p_parameterlist => l_list);
986: wf_event.AddParameterToList(p_name => 'TRX_PS_STATUS',
987: p_value => l_trx_ps_status,
982: -- add more parameters to the parameters list
983: wf_event.AddParameterToList(p_name => 'RECEIVABLE_APPLICATION_ID',
984: p_value => p_receivable_application_id,
985: p_parameterlist => l_list);
986: wf_event.AddParameterToList(p_name => 'TRX_PS_STATUS',
987: p_value => l_trx_ps_status,
988: p_parameterlist => l_list);
989: wf_event.AddParameterToList(p_name => 'RCPT_PS_STATUS',
990: p_value => l_rcpt_ps_status,
985: p_parameterlist => l_list);
986: wf_event.AddParameterToList(p_name => 'TRX_PS_STATUS',
987: p_value => l_trx_ps_status,
988: p_parameterlist => l_list);
989: wf_event.AddParameterToList(p_name => 'RCPT_PS_STATUS',
990: p_value => l_rcpt_ps_status,
991: p_parameterlist => l_list);
992: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
993: p_value => l_due_date,
988: p_parameterlist => l_list);
989: wf_event.AddParameterToList(p_name => 'RCPT_PS_STATUS',
990: p_value => l_rcpt_ps_status,
991: p_parameterlist => l_list);
992: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
993: p_value => l_due_date,
994: p_parameterlist => l_list);
995: wf_event.AddParameterToList(p_name => 'TRX_APP_AMT',
996: p_value => l_trx_amt_applied,
991: p_parameterlist => l_list);
992: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
993: p_value => l_due_date,
994: p_parameterlist => l_list);
995: wf_event.AddParameterToList(p_name => 'TRX_APP_AMT',
996: p_value => l_trx_amt_applied,
997: p_parameterlist => l_list);
998:
999:
1123: -- Add Context values to the list
1124: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1125:
1126: -- add more parameters to the parameters list
1127: wf_event.AddParameterToList(p_name => 'RECEIVABLE_APPLICATION_ID',
1128: p_value => p_receivable_application_id,
1129: p_parameterlist => l_list);
1130: wf_event.AddParameterToList(p_name => 'OLD_TRX_PS_STATUS',
1131: p_value => l_old_trx_ps_status,
1126: -- add more parameters to the parameters list
1127: wf_event.AddParameterToList(p_name => 'RECEIVABLE_APPLICATION_ID',
1128: p_value => p_receivable_application_id,
1129: p_parameterlist => l_list);
1130: wf_event.AddParameterToList(p_name => 'OLD_TRX_PS_STATUS',
1131: p_value => l_old_trx_ps_status,
1132: p_parameterlist => l_list);
1133: wf_event.AddParameterToList(p_name => 'NEW_TRX_PS_STATUS',
1134: p_value => l_new_trx_ps_status,
1129: p_parameterlist => l_list);
1130: wf_event.AddParameterToList(p_name => 'OLD_TRX_PS_STATUS',
1131: p_value => l_old_trx_ps_status,
1132: p_parameterlist => l_list);
1133: wf_event.AddParameterToList(p_name => 'NEW_TRX_PS_STATUS',
1134: p_value => l_new_trx_ps_status,
1135: p_parameterlist => l_list);
1136: wf_event.AddParameterToList(p_name => 'OLD_RCPT_PS_STATUS',
1137: p_value => l_old_rcpt_ps_status,
1132: p_parameterlist => l_list);
1133: wf_event.AddParameterToList(p_name => 'NEW_TRX_PS_STATUS',
1134: p_value => l_new_trx_ps_status,
1135: p_parameterlist => l_list);
1136: wf_event.AddParameterToList(p_name => 'OLD_RCPT_PS_STATUS',
1137: p_value => l_old_rcpt_ps_status,
1138: p_parameterlist => l_list);
1139: wf_event.AddParameterToList(p_name => 'NEW_RCPT_PS_STATUS',
1140: p_value => l_new_rcpt_ps_status,
1135: p_parameterlist => l_list);
1136: wf_event.AddParameterToList(p_name => 'OLD_RCPT_PS_STATUS',
1137: p_value => l_old_rcpt_ps_status,
1138: p_parameterlist => l_list);
1139: wf_event.AddParameterToList(p_name => 'NEW_RCPT_PS_STATUS',
1140: p_value => l_new_rcpt_ps_status,
1141: p_parameterlist => l_list);
1142: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
1143: p_value => l_due_date,
1138: p_parameterlist => l_list);
1139: wf_event.AddParameterToList(p_name => 'NEW_RCPT_PS_STATUS',
1140: p_value => l_new_rcpt_ps_status,
1141: p_parameterlist => l_list);
1142: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
1143: p_value => l_due_date,
1144: p_parameterlist => l_list);
1145: wf_event.AddParameterToList(p_name => 'TRX_APP_AMT',
1146: p_value =>l_tot_amt_applied,
1141: p_parameterlist => l_list);
1142: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
1143: p_value => l_due_date,
1144: p_parameterlist => l_list);
1145: wf_event.AddParameterToList(p_name => 'TRX_APP_AMT',
1146: p_value =>l_tot_amt_applied,
1147: p_parameterlist => l_list);
1148: wf_event.AddParameterToList(p_name => 'AMT_DUE_REMAINING',
1149: p_value =>l_trx_adr,
1144: p_parameterlist => l_list);
1145: wf_event.AddParameterToList(p_name => 'TRX_APP_AMT',
1146: p_value =>l_tot_amt_applied,
1147: p_parameterlist => l_list);
1148: wf_event.AddParameterToList(p_name => 'AMT_DUE_REMAINING',
1149: p_value =>l_trx_adr,
1150: p_parameterlist => l_list);
1151: wf_event.AddParameterToList(p_name => 'OLD_AMT_DUE_REMAINING',
1152: p_value => ( nvl(l_trx_adr,0) +
1147: p_parameterlist => l_list);
1148: wf_event.AddParameterToList(p_name => 'AMT_DUE_REMAINING',
1149: p_value =>l_trx_adr,
1150: p_parameterlist => l_list);
1151: wf_event.AddParameterToList(p_name => 'OLD_AMT_DUE_REMAINING',
1152: p_value => ( nvl(l_trx_adr,0) +
1153: ( nvl(l_amount_applied,0)
1154: + nvl(l_earned_discount_taken,0)
1155: + nvl(l_unearned_discount_taken,0)
1235: -- Add Context values to the list
1236: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1237:
1238: -- add more parameters to the parameters list
1239: wf_event.AddParameterToList(p_name => 'RECEIVABLE_APPLICATION_ID',
1240: p_value => p_receivable_application_id,
1241: p_parameterlist => l_list);
1242: wf_event.AddParameterToList(p_name => 'TRX_PS_STATUS',
1243: p_value => l_trx_ps_status,
1238: -- add more parameters to the parameters list
1239: wf_event.AddParameterToList(p_name => 'RECEIVABLE_APPLICATION_ID',
1240: p_value => p_receivable_application_id,
1241: p_parameterlist => l_list);
1242: wf_event.AddParameterToList(p_name => 'TRX_PS_STATUS',
1243: p_value => l_trx_ps_status,
1244: p_parameterlist => l_list);
1245: wf_event.AddParameterToList(p_name => 'CM_PS_STATUS',
1246: p_value => l_cm_ps_status,
1241: p_parameterlist => l_list);
1242: wf_event.AddParameterToList(p_name => 'TRX_PS_STATUS',
1243: p_value => l_trx_ps_status,
1244: p_parameterlist => l_list);
1245: wf_event.AddParameterToList(p_name => 'CM_PS_STATUS',
1246: p_value => l_cm_ps_status,
1247: p_parameterlist => l_list);
1248: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
1249: p_value => l_due_date,
1244: p_parameterlist => l_list);
1245: wf_event.AddParameterToList(p_name => 'CM_PS_STATUS',
1246: p_value => l_cm_ps_status,
1247: p_parameterlist => l_list);
1248: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
1249: p_value => l_due_date,
1250: p_parameterlist => l_list);
1251: wf_event.AddParameterToList(p_name => 'TRX_APP_AMT',
1252: p_value => l_trx_amt_applied,
1247: p_parameterlist => l_list);
1248: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
1249: p_value => l_due_date,
1250: p_parameterlist => l_list);
1251: wf_event.AddParameterToList(p_name => 'TRX_APP_AMT',
1252: p_value => l_trx_amt_applied,
1253: p_parameterlist => l_list);
1254:
1255: -- Raise Event
1325: -- Add Context values to the list
1326: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1327:
1328: -- add more parameters to the parameters list
1329: wf_event.AddParameterToList(p_name => 'RECEIVABLE_APPLICATION_ID',
1330: p_value => p_receivable_application_id,
1331: p_parameterlist => l_list);
1332: wf_event.AddParameterToList(p_name => 'TRX_PS_STATUS',
1333: p_value => l_trx_ps_status,
1328: -- add more parameters to the parameters list
1329: wf_event.AddParameterToList(p_name => 'RECEIVABLE_APPLICATION_ID',
1330: p_value => p_receivable_application_id,
1331: p_parameterlist => l_list);
1332: wf_event.AddParameterToList(p_name => 'TRX_PS_STATUS',
1333: p_value => l_trx_ps_status,
1334: p_parameterlist => l_list);
1335: wf_event.AddParameterToList(p_name => 'CM_PS_STATUS',
1336: p_value => l_cm_ps_status,
1331: p_parameterlist => l_list);
1332: wf_event.AddParameterToList(p_name => 'TRX_PS_STATUS',
1333: p_value => l_trx_ps_status,
1334: p_parameterlist => l_list);
1335: wf_event.AddParameterToList(p_name => 'CM_PS_STATUS',
1336: p_value => l_cm_ps_status,
1337: p_parameterlist => l_list);
1338: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
1339: p_value => l_due_date,
1334: p_parameterlist => l_list);
1335: wf_event.AddParameterToList(p_name => 'CM_PS_STATUS',
1336: p_value => l_cm_ps_status,
1337: p_parameterlist => l_list);
1338: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
1339: p_value => l_due_date,
1340: p_parameterlist => l_list);
1341: wf_event.AddParameterToList(p_name => 'TRX_APP_AMT',
1342: p_value => l_trx_amt_applied,
1337: p_parameterlist => l_list);
1338: wf_event.AddParameterToList(p_name => 'TRX_DUE_DATE',
1339: p_value => l_due_date,
1340: p_parameterlist => l_list);
1341: wf_event.AddParameterToList(p_name => 'TRX_APP_AMT',
1342: p_value => l_trx_amt_applied,
1343: p_parameterlist => l_list);
1344:
1345: -- Raise Event
1395: -- Add Context values to the list
1396: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1397:
1398: -- add more parameters to the parameters list
1399: wf_event.AddParameterToList(p_name => 'ADJUSTMENT_ID',
1400: p_value => p_adjustment_id,
1401: p_parameterlist => l_list);
1402: wf_event.AddParameterToList(p_name => 'APPLIED_PS_STATUS',
1403: p_value => p_app_ps_status,
1398: -- add more parameters to the parameters list
1399: wf_event.AddParameterToList(p_name => 'ADJUSTMENT_ID',
1400: p_value => p_adjustment_id,
1401: p_parameterlist => l_list);
1402: wf_event.AddParameterToList(p_name => 'APPLIED_PS_STATUS',
1403: p_value => p_app_ps_status,
1404: p_parameterlist => l_list);
1405:
1406: wf_event.AddParameterToList(p_name => 'ADJ_STATUS',
1402: wf_event.AddParameterToList(p_name => 'APPLIED_PS_STATUS',
1403: p_value => p_app_ps_status,
1404: p_parameterlist => l_list);
1405:
1406: wf_event.AddParameterToList(p_name => 'ADJ_STATUS',
1407: p_value => p_adj_status,
1408: p_parameterlist => l_list);
1409:
1410:
1460: -- Add Context values to the list
1461: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1462:
1463: -- add more parameters to the parameters list
1464: wf_event.AddParameterToList(p_name => 'ADJUSTMENT_ID',
1465: p_value => p_adjustment_id,
1466: p_parameterlist => l_list);
1467:
1468: wf_event.AddParameterToList(p_name => 'APPROVAL_ACTN_HIST_ID',
1464: wf_event.AddParameterToList(p_name => 'ADJUSTMENT_ID',
1465: p_value => p_adjustment_id,
1466: p_parameterlist => l_list);
1467:
1468: wf_event.AddParameterToList(p_name => 'APPROVAL_ACTN_HIST_ID',
1469: p_value => p_approval_actn_hist_id,
1470: p_parameterlist => l_list);
1471: wf_event.AddParameterToList(p_name => 'APPLIED_PS_STATUS',
1472: p_value => p_app_ps_status,
1467:
1468: wf_event.AddParameterToList(p_name => 'APPROVAL_ACTN_HIST_ID',
1469: p_value => p_approval_actn_hist_id,
1470: p_parameterlist => l_list);
1471: wf_event.AddParameterToList(p_name => 'APPLIED_PS_STATUS',
1472: p_value => p_app_ps_status,
1473: p_parameterlist => l_list);
1474:
1475: -- Raise Event
1521: -- Add Context values to the list
1522: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1523:
1524: -- add more parameters to the parameters list
1525: wf_event.AddParameterToList(p_name => 'REQUEST_ID',
1526: p_value => p_request_id,
1527: p_parameterlist => l_list);
1528:
1529: -- Raise Event
1582: -- Add Context values to the list
1583: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1584:
1585: -- add more parameters to the parameters list
1586: wf_event.AddParameterToList(p_name => 'REQUEST_ID',
1587: p_value => p_request_id,
1588: p_parameterlist => l_list);
1589:
1590: -- Raise Event
1639: -- Add Context values to the list
1640: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1641:
1642: -- add more parameters to the parameters list
1643: wf_event.AddParameterToList(p_name => 'REQUEST_ID',
1644: p_value => p_request_id,
1645: p_parameterlist => l_list);
1646:
1647: -- Raise Event
1700: -- Add Context values to the list
1701: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1702:
1703: -- add more parameters to the parameters list
1704: wf_event.AddParameterToList(p_name => 'REQUEST_ID',
1705: p_value => p_request_id,
1706: p_parameterlist => l_list);
1707:
1708: -- Raise Event
1755: -- Add Context values to the list
1756: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1757:
1758: -- add more parameters to the parameters list
1759: wf_event.AddParameterToList(p_name => 'REQUEST_ID',
1760: p_value => p_request_id,
1761: p_parameterlist => l_list);
1762:
1763: -- Raise Event
1815: -- Add Context values to the list
1816: ar_cmgt_event_pkg.AddParamEnvToList(l_list);
1817:
1818: -- add more parameters to the parameters list
1819: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
1820: p_value => p_payment_schedule_id,
1821: p_parameterlist => l_list);
1822:
1823: wf_event.AddParameterToList(p_name => 'DELETION_DATE',
1819: wf_event.AddParameterToList(p_name => 'PAYMENT_SCHEDULE_ID',
1820: p_value => p_payment_schedule_id,
1821: p_parameterlist => l_list);
1822:
1823: wf_event.AddParameterToList(p_name => 'DELETION_DATE',
1824: p_value => trunc(sysdate),
1825: p_parameterlist => l_list);
1826:
1827: wf_event.AddParameterToList(p_name => 'RECEIPT_NUMBER',
1823: wf_event.AddParameterToList(p_name => 'DELETION_DATE',
1824: p_value => trunc(sysdate),
1825: p_parameterlist => l_list);
1826:
1827: wf_event.AddParameterToList(p_name => 'RECEIPT_NUMBER',
1828: p_value => p_receipt_number,
1829: p_parameterlist => l_list);
1830:
1831: wf_event.AddParameterToList(p_name => 'RECEIPT_DATE',
1827: wf_event.AddParameterToList(p_name => 'RECEIPT_NUMBER',
1828: p_value => p_receipt_number,
1829: p_parameterlist => l_list);
1830:
1831: wf_event.AddParameterToList(p_name => 'RECEIPT_DATE',
1832: p_value => p_receipt_date,
1833: p_parameterlist => l_list);
1834: -- Raise Event
1835: AR_CMGT_EVENT_PKG.raise_event(