APPS.AP_WEB_CC_VALIDATION_WF_PKG dependencies on WF_PARAMETER_T

Line 25: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),

21:
22: begin
23: if (p_card_program_id is not null) then
24: l_parameter_list := wf_parameter_list_t(
25: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
26: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),
27: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
28: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))
29: );

Line 26: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),

22: begin
23: if (p_card_program_id is not null) then
24: l_parameter_list := wf_parameter_list_t(
25: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
26: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),
27: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
28: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))
29: );
30:

Line 27: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),

23: if (p_card_program_id is not null) then
24: l_parameter_list := wf_parameter_list_t(
25: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
26: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),
27: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
28: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))
29: );
30:
31: -- select ap_oie_workflow_s.nextval into l_event_key

Line 28: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))

24: l_parameter_list := wf_parameter_list_t(
25: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
26: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),
27: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
28: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))
29: );
30:
31: -- select ap_oie_workflow_s.nextval into l_event_key
32: select ap_ccard_notification_id_s.nextval into l_event_key

Line 48: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),

44: else
45:
46: for l_fetch_card_program_id in fetch_card_program_id loop
47: l_parameter_list := wf_parameter_list_t(
48: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
49: wf_parameter_t('CARD_PROGRAM_ID', to_char(l_fetch_card_program_id.card_program_id)),
50: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
51: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD')));
52:

Line 49: wf_parameter_t('CARD_PROGRAM_ID', to_char(l_fetch_card_program_id.card_program_id)),

45:
46: for l_fetch_card_program_id in fetch_card_program_id loop
47: l_parameter_list := wf_parameter_list_t(
48: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
49: wf_parameter_t('CARD_PROGRAM_ID', to_char(l_fetch_card_program_id.card_program_id)),
50: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
51: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD')));
52:
53: select ap_ccard_notification_id_s.nextval into l_event_key from dual;

Line 50: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),

46: for l_fetch_card_program_id in fetch_card_program_id loop
47: l_parameter_list := wf_parameter_list_t(
48: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
49: wf_parameter_t('CARD_PROGRAM_ID', to_char(l_fetch_card_program_id.card_program_id)),
50: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
51: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD')));
52:
53: select ap_ccard_notification_id_s.nextval into l_event_key from dual;
54:

Line 51: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD')));

47: l_parameter_list := wf_parameter_list_t(
48: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
49: wf_parameter_t('CARD_PROGRAM_ID', to_char(l_fetch_card_program_id.card_program_id)),
50: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
51: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD')));
52:
53: select ap_ccard_notification_id_s.nextval into l_event_key from dual;
54:
55: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.transaction.error',

Line 236: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),

232: l_event_key number;
233: i number := 0;
234: begin
235: l_parameter_list := wf_parameter_list_t(
236: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
237: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),
238: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
239: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))
240: );

Line 237: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),

233: i number := 0;
234: begin
235: l_parameter_list := wf_parameter_list_t(
236: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
237: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),
238: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
239: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))
240: );
241:

Line 238: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),

234: begin
235: l_parameter_list := wf_parameter_list_t(
236: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
237: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),
238: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
239: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))
240: );
241:
242: select ap_ccard_notification_id_s.nextval into l_event_key

Line 239: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))

235: l_parameter_list := wf_parameter_list_t(
236: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
237: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),
238: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
239: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))
240: );
241:
242: select ap_ccard_notification_id_s.nextval into l_event_key
243: from dual;