eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: 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'))
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 241: wf_parameter_t('REQUEST_ID', to_char(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'))
245: );

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

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

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

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'))
245: );
246:
247: select ap_ccard_notification_id_s.nextval into l_event_key from dual;

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

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'))
245: );
246:
247: select ap_ccard_notification_id_s.nextval into l_event_key from dual;
248:

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

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

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

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

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

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'))
264: );
265:
266: select ap_ccard_notification_id_s.nextval into l_event_key from dual;

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

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'))
264: );
265:
266: select ap_ccard_notification_id_s.nextval into l_event_key from dual;
267: