APPS.AP_WEB_CC_VALIDATION_WF_PKG dependencies on DUAL

Line 33: from dual;

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
33: from dual;
34: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.transaction.error',
35: p_event_key => to_char(l_event_key),
36: p_parameters => l_parameter_list);
37:

Line 53: select ap_ccard_notification_id_s.nextval into l_event_key from dual;

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',
56: p_event_key => to_char(l_event_key),
57: p_parameters => l_parameter_list);

Line 247: select ap_ccard_notification_id_s.nextval into l_event_key from dual;

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:
249: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.account.create',
250: p_event_key => to_char(l_event_key),
251: p_parameters => l_parameter_list);

Line 266: select ap_ccard_notification_id_s.nextval into l_event_key from dual;

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:
268: wf_event.raise(p_event_name => 'oracle.apps.ap.oie.creditcard.account.create',
269: p_event_key => to_char(l_event_key),
270: p_parameters => l_parameter_list);

Line 403: select count(*) into l_exist from dual

399: l_exist number;
400: begin
401: if ( funcmode = 'RUN' ) then
402: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
403: select count(*) into l_exist from dual
404: where exists (select 1 from ap_cards_all where request_id = l_request_id);
405:
406: if l_exist = 0 then
407: resultout := 'COMPLETE:F';

Line 445: select count(*) into l_exist from dual

441: l_exist number;
442: begin
443: if ( funcmode = 'RUN' ) then
444: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
445: select count(*) into l_exist from dual
446: where exists (select 1 from ap_cards_all where request_id = l_request_id and employee_id is null);
447:
448: if l_exist = 0 then
449: resultout := 'COMPLETE:F';

Line 496: select count(*) into l_exist1 from dual

492: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
493: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
494: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
495: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
496: select count(*) into l_exist1 from dual
497: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');
498: SELECT COUNT(*) INTO l_exist2 FROM dual
499: WHERE exists (SELECT 1 FROM ap_credit_card_trxns_all
500: WHERE (l_card_program_id IS NULL OR card_program_id = l_card_program_id) -- Bug 6829024(sodash)

Line 498: SELECT COUNT(*) INTO l_exist2 FROM dual

494: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
495: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
496: select count(*) into l_exist1 from dual
497: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');
498: SELECT COUNT(*) INTO l_exist2 FROM dual
499: WHERE exists (SELECT 1 FROM ap_credit_card_trxns_all
500: WHERE (l_card_program_id IS NULL OR card_program_id = l_card_program_id) -- Bug 6829024(sodash)
501: AND (l_start_date IS NULL OR transaction_date IS NULL OR transaction_date >= l_start_date)
502: AND (l_end_date IS NULL OR transaction_date IS NULL OR transaction_date <= l_end_date)