APPS.AP_WEB_CC_VALIDATIONS_PKG dependencies on AP_CARDS_ALL

Line 464: from ap_cards_all apc

460: 'update ap_credit_card_trxns_all cc
461: set validate_code = ''INACTIVE_CARD_NUMBER''
462: where cc.transaction_date >=
463: (select max(nvl(apc.inactive_date,cc.transaction_date+1))
464: from ap_cards_all apc
465: where apc.card_program_id = cc.card_program_id
466: and apc.card_id = cc.card_id)', p_valid_only
467: );
468: return num_rows;

Line 484: from ap_cards_all apc, iby_creditcard icc

480: num_rows := execute_update('update ap_credit_card_trxns_all cc
481: set validate_code = ''INVALID_CARD_NUMBER''
482: where card_id in
483: (select card_id
484: from ap_cards_all apc, iby_creditcard icc
485: where apc.card_program_id = cc.card_program_id and
486: apc.card_id = cc.card_id and
487: icc.instrid = apc.card_reference_id and
488: icc.invalid_flag = ''Y'')

Line 496: from ap_cards_all apc

492: num_rows := execute_update('update ap_credit_card_trxns_all cc
493: set validate_code = ''INVALID_CARD_NUMBER''
494: where card_id not in
495: (select card_id
496: from ap_cards_all apc
497: where apc.card_program_id = cc.card_program_id and
498: apc.card_id = cc.card_id)
499: and cc.card_number is null
500: and cc.validate_code != ''Y''', p_valid_only);

Line 698: update ap_cards_all

694: x_response IBY_FNDCPT_COMMON_PUB.RESULT_REC_TYPE;
695: l_bool boolean := true;
696:
697: begin
698: update ap_cards_all
699: set employee_id = p_employee_id,
700: cardmember_name = null,
701: physical_card_flag = 'Y',
702: paper_statement_req_flag = 'N',

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

709: -- 8799736 - PADSS- Setting card_member_name to IBY tables
710: p_card_instrument.Card_Holder_Name := p_full_name;
711:
712: -- this part of code keeps iby in synch with party assignments for a card
713: -- note that source of truth is oie (ap_cards_all.employee_id)
714: -- and not iby for assignments check.
715: begin
716: select card_reference_id into l_instrid
717: from ap_cards_all

Line 717: from ap_cards_all

713: -- note that source of truth is oie (ap_cards_all.employee_id)
714: -- and not iby for assignments check.
715: begin
716: select card_reference_id into l_instrid
717: from ap_cards_all
718: where card_id = p_card_id;
719: p_card_instrument.card_id := l_instrid;
720: exception when others then
721: p_card_instrument.card_id := null;

Line 846: FROM AP_CARDS_ALL CARD,

842: 'UPDATE AP_CREDIT_CARD_TRXNS_ALL CC
843: SET CATEGORY = ''PERSONAL''
844: WHERE CATEGORY <> ''PERSONAL''
845: AND EXISTS (SELECT 1
846: FROM AP_CARDS_ALL CARD,
847: PER_EMPLOYEES_X P
848: WHERE AP_WEB_DB_HR_INT_PKG.IsPersonTerminated(CARD.employee_id)=''Y''
849: AND CARD.employee_id=P.employee_id
850: AND P.inactive_date < CC.transaction_date

Line 918: from ap_cards_all apc, iby_creditcard icc

914: --------------------------------------------------------------------
915: IF(IBY_FNDCPT_SETUP_PUB.Get_Encryption_Patch_Level = 'PADSS') THEN
916: num_rows := execute_update('delete ap_credit_card_trxns_all cc where card_id in
917: (select card_id
918: from ap_cards_all apc, iby_creditcard icc
919: where apc.card_program_id = cc.card_program_id and
920: apc.card_id = cc.card_id and
921: icc.instrid = apc.card_reference_id and
922: icc.invalid_flag = ''Y'')

Line 928: from ap_cards_all apc

924: and cc.validate_code != ''Y''' || card_prog_where, p_valid_only);
925: ELSE
926: num_rows := execute_update('delete ap_credit_card_trxns_all cc where card_id not in
927: (select card_id
928: from ap_cards_all apc
929: where apc.card_program_id = cc.card_program_id and
930: apc.card_id = cc.card_id)
931: and cc.card_number is null
932: and cc.validate_code != ''Y''' || card_prog_where, p_valid_only);