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 243: from dual;

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

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

375: l_exist number;
376: begin
377: if ( funcmode = 'RUN' ) then
378: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
379: select count(*) into l_exist from dual
380: where exists (select 1 from ap_cards_all where request_id = l_request_id);
381:
382: if l_exist = 0 then
383: resultout := 'COMPLETE:F';

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

417: l_exist number;
418: begin
419: if ( funcmode = 'RUN' ) then
420: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
421: select count(*) into l_exist from dual
422: where exists (select 1 from ap_cards_all where request_id = l_request_id and employee_id is null);
423:
424: if l_exist = 0 then
425: resultout := 'COMPLETE:F';

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

468: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID',false);
469: l_card_program_id := wf_engine.getitemattrnumber(itemtype, itemkey,'CARD_PROGRAM_ID',FALSE);
470: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
471: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
472: select count(*) into l_exist1 from dual
473: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');
474: SELECT COUNT(*) INTO l_exist2 FROM dual
475: WHERE exists (SELECT 1 FROM ap_credit_card_trxns_all
476: WHERE (l_card_program_id IS NULL OR card_program_id = l_card_program_id) -- Bug 6829024(sodash)

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

470: l_start_date := wf_engine.getitemattrdate(itemtype, itemkey,'START_DATE',FALSE);
471: l_end_date := wf_engine.getitemattrdate(itemtype, itemkey,'END_DATE',FALSE);
472: select count(*) into l_exist1 from dual
473: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');
474: SELECT COUNT(*) INTO l_exist2 FROM dual
475: WHERE exists (SELECT 1 FROM ap_credit_card_trxns_all
476: WHERE (l_card_program_id IS NULL OR card_program_id = l_card_program_id) -- Bug 6829024(sodash)
477: AND (l_start_date IS NULL OR transaction_date IS NULL OR transaction_date >= l_start_date)
478: AND (l_end_date IS NULL OR transaction_date IS NULL OR transaction_date <= l_end_date)