APPS.AP_WEB_CC_VALIDATIONS_PKG dependencies on AP_CARDS_ALL

Line 448: from ap_cards_all apc

444: 'update ap_credit_card_trxns_all cc
445: set validate_code = ''INACTIVE_CARD_NUMBER''
446: where cc.transaction_date >=
447: (select max(nvl(apc.inactive_date,cc.transaction_date+1))
448: from ap_cards_all apc
449: where apc.card_program_id = cc.card_program_id
450: and apc.card_id = cc.card_id)', p_valid_only
451: );
452: return num_rows;

Line 467: (select apc.card_id from ap_cards_all apc

463: num_rows := execute_update(
464: 'update ap_credit_card_trxns_all cc
465: set validate_code = ''INVALID_CARD_NUMBER''
466: where card_id not in
467: (select apc.card_id from ap_cards_all apc
468: where apc.card_program_id = cc.card_program_id
469: and apc.card_id = cc.card_id)', p_valid_only
470: );
471: return num_rows;

Line 663: update ap_cards_all

659: x_response APPS.IBY_FNDCPT_COMMON_PUB.RESULT_REC_TYPE;
660: l_bool boolean := true;
661:
662: begin
663: update ap_cards_all
664: set employee_id = p_employee_id,
665: cardmember_name = p_full_name,
666: physical_card_flag = 'Y',
667: paper_statement_req_flag = 'N'

Line 672: -- note that source of truth is oie (ap_cards_all.employee_id)

668: where card_id = p_card_id
669: and employee_id is null;-- bug 5224047
670:
671: -- this part of code keeps iby in synch with party assignments for a card
672: -- note that source of truth is oie (ap_cards_all.employee_id)
673: -- and not iby for assignments check.
674: begin
675: select card_reference_id into l_instrid
676: from ap_cards_all

Line 676: from ap_cards_all

672: -- note that source of truth is oie (ap_cards_all.employee_id)
673: -- and not iby for assignments check.
674: begin
675: select card_reference_id into l_instrid
676: from ap_cards_all
677: where card_id = p_card_id;
678: p_card_instrument.card_id := l_instrid;
679: exception when others then
680: p_card_instrument.card_id := null;

Line 805: FROM AP_CARDS_ALL CARD,

801: 'UPDATE AP_CREDIT_CARD_TRXNS_ALL CC
802: SET CATEGORY = ''PERSONAL''
803: WHERE CATEGORY <> ''PERSONAL''
804: AND EXISTS (SELECT 1
805: FROM AP_CARDS_ALL CARD,
806: PER_EMPLOYEES_X P
807: WHERE AP_WEB_DB_HR_INT_PKG.IsPersonTerminated(CARD.employee_id)=''Y''
808: AND CARD.employee_id=P.employee_id
809: AND P.inactive_date < CC.transaction_date

Line 876: from ap_cards_all apc

872: -- Delete invalid records
873: --------------------------------------------------------------------
874: num_rows := execute_update('delete ap_credit_card_trxns_all cc where card_id not in
875: (select card_id
876: from ap_cards_all apc
877: where apc.card_program_id = cc.card_program_id and
878: apc.card_id = cc.card_id)
879: and cc.card_number is null
880: and cc.validate_code != ''Y''' || card_prog_where, p_valid_only);