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_CREDIT_CARD_PKG dependencies on AP_CARDS_ALL

Line 57: null , p_card_number, -- party id is null as we reference cards through ap_cards_all.employee_id

53: begin
54: -- return instrument id if card already exists in oracle payments
55: iby_fndcpt_setup_pub.card_exists(1.0,NULL,
56: x_return_status, x_msg_count, x_msg_data,
57: null , p_card_number, -- party id is null as we reference cards through ap_cards_all.employee_id
58: p_card_instrument, x_response);
59: if (x_return_status = 'S') then
60: x_instr_id := p_card_instrument.card_id;
61: if (x_instr_id is not null) then

Line 86: /* This function returns card_id from ap_cards_all for a

82: return -1;
83: -- raise;
84: end create_iby_card;
85:
86: /* This function returns card_id from ap_cards_all for a
87: given credit card number. If card numbers does not
88: exist then it creates a card in oracle payments and
89: in ap_cards_all with appropriate references. Avoiding
90: calls to diagnostic since these are used in bulk uploading.

Line 89: in ap_cards_all with appropriate references. Avoiding

85:
86: /* This function returns card_id from ap_cards_all for a
87: given credit card number. If card numbers does not
88: exist then it creates a card in oracle payments and
89: in ap_cards_all with appropriate references. Avoiding
90: calls to diagnostic since these are used in bulk uploading.
91: */
92: function get_card_id(p_card_number IN VARCHAR2,
93: p_card_program_id IN VARCHAR2 DEFAULT NULL,

Line 112: from ap_cards_all

108: l_instr_id := create_iby_card(p_card_number, p_party_id);
109: begin
110: if (l_instr_id > 0) then
111: select card_id into l_card_id
112: from ap_cards_all
113: where card_reference_id = l_instr_id
114: and card_program_id = p_card_program_id
115: and rownum = 1;
116: return l_card_id;

Line 122: -- create a row in ap_cards_all and get card_id

118: return -1;
119: end if;
120: exception when no_data_found then
121: l_user_id := fnd_global.user_id;
122: -- create a row in ap_cards_all and get card_id
123: insert into ap_cards_all (card_id,
124: card_program_id,
125: org_id,
126: card_reference_id,

Line 123: insert into ap_cards_all (card_id,

119: end if;
120: exception when no_data_found then
121: l_user_id := fnd_global.user_id;
122: -- create a row in ap_cards_all and get card_id
123: insert into ap_cards_all (card_id,
124: card_program_id,
125: org_id,
126: card_reference_id,
127: request_id,

Line 169: l_card_reference_id ap_cards_all.card_reference_id%type;

165:
166: /* Returns card_reference_id (IBY_CREDITCARD.instrid) */
167: FUNCTION get_card_reference_id(p_document_payable_id IN NUMBER)
168: RETURN NUMBER IS
169: l_card_reference_id ap_cards_all.card_reference_id%type;
170: BEGIN
171:
172: select crd.card_reference_id -- Instrument ID
173: into l_card_reference_id

Line 178: ap_cards_all crd

174: from ap_invoices_all inv,
175: iby_docs_payable_all iby,
176: ap_expense_report_headers_all erh,
177: ap_credit_card_trxns_all ctx,
178: ap_cards_all crd
179: where iby.document_payable_id = p_document_payable_id
180: and iby.calling_app_doc_unique_ref2 = inv.invoice_id
181: and inv.invoice_id = erh.vouchno
182: and inv.invoice_type_lookup_code in ('EXPENSE REPORT', 'MIXED')