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 AP_CREDIT_CARD_TRXNS_ALL

Line 17: SELECT distinct card_program_id FROM ap_credit_card_trxns_all

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
17: SELECT distinct card_program_id FROM ap_credit_card_trxns_all
18: WHERE (p_start_date IS NULL OR transaction_date IS NULL OR transaction_date >= p_start_date)
19: AND (p_end_date IS NULL OR transaction_date IS NULL OR transaction_date <= p_end_date)
20: AND validate_code <> 'Y'
21: AND validate_request_id = p_request_id; --Bug#14084710 Show notification only for present request id

Line 100: 'from ap_credit_card_trxns_all '||

96: l_start_date := wf_engine.getitemattrdate(itemtype,itemkey,'START_DATE',true);
97: l_end_date := wf_engine.getitemattrdate(itemtype,itemkey,'END_DATE',true);
98:
99: stmt := 'select validate_code, count(*) '||
100: 'from ap_credit_card_trxns_all '||
101: 'where validate_code not in (''Y'', ''N'', ''UNTESTED'') ';
102: if l_request_id is null then
103: stmt := stmt || 'and :reqId is null ';
104: else

Line 497: where exists (select 1 from ap_credit_card_trxns_all where request_id = l_request_id and validate_code <> 'Y');

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)
501: AND (l_start_date IS NULL OR transaction_date IS NULL OR transaction_date >= l_start_date)

Line 499: WHERE exists (SELECT 1 FROM ap_credit_card_trxns_all

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