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: AND validate_request_id = p_request_id; --Bug#14084710 Show notification only for present request 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'))

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:
235: cursor fetch_card_program_id is

Line 240: l_parameter_list := wf_parameter_list_t(

236: SELECT distinct card_program_id FROM ap_cards_all WHERE request_id = p_request_id;
237:
238: begin
239: if (p_card_program_id is not null and p_card_program_id <> 0) then
240: l_parameter_list := wf_parameter_list_t(
241: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
242: wf_parameter_t('CARD_PROGRAM_ID', to_char(p_card_program_id)),
243: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
244: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))

Line 259: l_parameter_list := wf_parameter_list_t(

255: 'Raised new card event with key = '||to_char(l_event_key));
256: end if;
257: else
258: for l_fetch_card_program_id in fetch_card_program_id loop
259: l_parameter_list := wf_parameter_list_t(
260: wf_parameter_t('REQUEST_ID', to_char(p_request_id)),
261: wf_parameter_t('CARD_PROGRAM_ID', to_char(l_fetch_card_program_id.card_program_id)),
262: wf_parameter_t('START_DATE', to_char(p_start_date, 'YYYY/MM/DD')),
263: wf_parameter_t('END_DATE', to_char(p_end_date, 'YYYY/MM/DD'))