APPS.AP_WEB_CC_VALIDATION_WF_PKG dependencies on WF_PARAMETER_LIST_T

Line 12: l_parameter_list wf_parameter_list_t;

8: p_card_program_id in number default null,
9: p_start_date in date default null,
10: p_end_date in date default null)
11: return number is
12: l_parameter_list wf_parameter_list_t;
13: l_event_key number;
14: i number := 0;
15: --Bug 6160290: Add cursor to handle scenario when p_card_program_id is null
16: cursor fetch_card_program_id is

Line 24: l_parameter_list := wf_parameter_list_t(

20: AND validate_code <> 'Y';
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'))

Line 47: l_parameter_list := wf_parameter_list_t(

43:
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')));

Line 231: l_parameter_list wf_parameter_list_t;

227: p_card_program_id in number default null,
228: p_start_date in date default null,
229: p_end_date in date default null)
230: return number is
231: l_parameter_list wf_parameter_list_t;
232: l_event_key number;
233: i number := 0;
234: begin
235: l_parameter_list := wf_parameter_list_t(

Line 235: l_parameter_list := wf_parameter_list_t(

231: l_parameter_list wf_parameter_list_t;
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'))