APPS.AP_WEB_CC_VALIDATION_WF_PKG dependencies on AP_CARD_PROGRAMS_ALL

Line 282: from ap_card_programs_all

278: l_request_id := wf_engine.getitemattrnumber(itemtype,itemkey,'REQUEST_ID', true);
279: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID', true);
280:
281: select card_emp_matching_rule into l_match_rule
282: from ap_card_programs_all
283: where card_program_id = l_card_program_id;
284:
285: if l_match_rule is not null then
286: l_stmt := 'begin '||

Line 667: from ap_card_programs_all

663: l_card_program_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CARD_PROGRAM_ID',false);
664:
665: IF(l_card_program_id IS NOT NULL) THEN
666: select sysadmin_role_name, admin_employee_id into l_role_name, l_person_id
667: from ap_card_programs_all
668: where card_program_id = l_card_program_id;
669: ELSE
670: l_role_name := NULL;
671: l_person_id := NULL;

Line 737: from ap_card_programs_all

733: return;
734: end if;
735:
736: select card_program_name into l_name
737: from ap_card_programs_all
738: where card_program_id = l_id;
739: wf_engine.setitemattrtext(itemtype,itemkey,'CARD_PROGRAM_NAME',l_name);
740:
741: resultout := 'COMPLETE';