DBA Data[Home] [Help]

APPS.AP_CARDS_PKG dependencies on AP_CARDS_ALL

Line 653: RETURN AP_CARDS_ALL.CARD_ID%TYPE IS

649:
650: -- 8726861
651: FUNCTION GET_CARD_ID(
652: P_CARD_NUMBER IN AP_EXPENSE_FEED_LINES_ALL.CARD_NUMBER%TYPE)
653: RETURN AP_CARDS_ALL.CARD_ID%TYPE IS
654: l_debug_info VARCHAR2(100);
655: x_return_status VARCHAR2(4000);
656: x_msg_count NUMBER;
657: x_msg_data VARCHAR2(4000);

Line 668: null ,trim(P_CARD_NUMBER), -- party id is null as we reference cards through ap_cards_all.employee_id

664: -- Call IBY API to get the card_reference_id.
665:
666: iby_fndcpt_setup_pub.card_exists(1.0,NULL,
667: x_return_status, x_msg_count, x_msg_data,
668: null ,trim(P_CARD_NUMBER), -- party id is null as we reference cards through ap_cards_all.employee_id
669: p_card_instrument, x_response);
670:
671: if (x_return_status = 'S') then
672: x_instr_id := p_card_instrument.card_id;

Line 678: ap_cards_all where card_reference_id=x_instr_id and rownum=1;

674: if (x_instr_id is not null) then
675:
676: begin
677: select card_id into l_card_id from
678: ap_cards_all where card_reference_id=x_instr_id and rownum=1;
679:
680: exception
681: when NO_DATA_FOUND then
682: RETURN -1 ;