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_CREDIT_CARD_INVOICE_PKG dependencies on AP_WEB_DB_CCARD_PKG

Line 45: l_card_trxn_id AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;

41: p_invoiceId OUT NOCOPY NUMBER )
42: IS
43: l_count NUMBER := 0;
44: l_sum AP_WEB_DB_AP_INT_PKG.invIntf_invAmt := 0;
45: l_card_trxn_id AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
46: l_transaction_date DATE; --3028505, renamed this variable
47: l_invoice_id AP_WEB_DB_AP_INT_PKG.invLines_invID;
48: l_invoice_id_temp AP_WEB_DB_AP_INT_PKG.invLines_invID; -- Bug 6687752
49: l_invoice_line_id AP_WEB_DB_AP_INT_PKG.invLines_invLineID;

Line 52: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;

48: l_invoice_id_temp AP_WEB_DB_AP_INT_PKG.invLines_invID; -- Bug 6687752
49: l_invoice_line_id AP_WEB_DB_AP_INT_PKG.invLines_invLineID;
50: l_party_id ap_suppliers.party_id%TYPE;
51: l_party_site_id ap_supplier_sites.party_site_id%TYPE;
52: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
53: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID;
54: l_terms_id AP_TERMS.TERM_ID%TYPE; -- Bug: 7234744 populate terms-id in the interface table.
55: l_ccid AP_WEB_DB_AP_INT_PKG.invLines_distCodeCombID;
56: l_invoice_currency_code AP_WEB_DB_AP_INT_PKG.invIntf_invCurrCode;

Line 53: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID;

49: l_invoice_line_id AP_WEB_DB_AP_INT_PKG.invLines_invLineID;
50: l_party_id ap_suppliers.party_id%TYPE;
51: l_party_site_id ap_supplier_sites.party_site_id%TYPE;
52: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
53: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID;
54: l_terms_id AP_TERMS.TERM_ID%TYPE; -- Bug: 7234744 populate terms-id in the interface table.
55: l_ccid AP_WEB_DB_AP_INT_PKG.invLines_distCodeCombID;
56: l_invoice_currency_code AP_WEB_DB_AP_INT_PKG.invIntf_invCurrCode;
57: l_pay_group_lookup_code AP_WEB_DB_AP_INT_PKG.vendorSites_payGroupLookupCode;

Line 63: l_ccard_trxn_cursor AP_WEB_DB_CCARD_PKG.UnpaidCreditCardTrxnCursor;

59:
60: l_debugInfo VARCHAR2(2000);
61: l_payment_due_code VARCHAR2(15);
62: l_result BOOLEAN;
63: l_ccard_trxn_cursor AP_WEB_DB_CCARD_PKG.UnpaidCreditCardTrxnCursor;
64: l_billed_amt AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
65: l_billed_curr_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
66: l_masked_cc_number AP_WEB_DB_CCARD_PKG.ccTrxn_cardId;
67:

Line 64: l_billed_amt AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;

60: l_debugInfo VARCHAR2(2000);
61: l_payment_due_code VARCHAR2(15);
62: l_result BOOLEAN;
63: l_ccard_trxn_cursor AP_WEB_DB_CCARD_PKG.UnpaidCreditCardTrxnCursor;
64: l_billed_amt AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
65: l_billed_curr_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
66: l_masked_cc_number AP_WEB_DB_CCARD_PKG.ccTrxn_cardId;
67:
68: --3028505, added variables below

Line 65: l_billed_curr_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;

61: l_payment_due_code VARCHAR2(15);
62: l_result BOOLEAN;
63: l_ccard_trxn_cursor AP_WEB_DB_CCARD_PKG.UnpaidCreditCardTrxnCursor;
64: l_billed_amt AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
65: l_billed_curr_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
66: l_masked_cc_number AP_WEB_DB_CCARD_PKG.ccTrxn_cardId;
67:
68: --3028505, added variables below
69: l_period_name gl_period_statuses.period_name%TYPE;

Line 66: l_masked_cc_number AP_WEB_DB_CCARD_PKG.ccTrxn_cardId;

62: l_result BOOLEAN;
63: l_ccard_trxn_cursor AP_WEB_DB_CCARD_PKG.UnpaidCreditCardTrxnCursor;
64: l_billed_amt AP_WEB_DB_CCARD_PKG.ccTrxn_billedAmount;
65: l_billed_curr_code AP_WEB_DB_CCARD_PKG.ccTrxn_billedCurrCode;
66: l_masked_cc_number AP_WEB_DB_CCARD_PKG.ccTrxn_cardId;
67:
68: --3028505, added variables below
69: l_period_name gl_period_statuses.period_name%TYPE;
70: l_open_date date;

Line 109: IF ( AP_WEB_DB_CCARD_PKG.GetUnpaidCreditCardTrxnCursor(

105:
106: -------------------------------------------------------------------
107: l_debugInfo := 'Loop through each of every transaction';
108: -------------------------------------------------------------------
109: IF ( AP_WEB_DB_CCARD_PKG.GetUnpaidCreditCardTrxnCursor(
110: l_ccard_trxn_cursor,
111: p_cardProgramID,
112: l_payment_due_code,
113: p_startDate,

Line 218: l_result := AP_WEB_DB_CCARD_PKG.SetCCTrxnInvoiceId(

214:
215: ----------------------------------------------------------------------
216: l_debugInfo := 'Update AP_CREDIT_CARD_TRXNS_ALL.COMPANY_PREPAID_INVOICE_ID';
217: ----------------------------------------------------------------------
218: l_result := AP_WEB_DB_CCARD_PKG.SetCCTrxnInvoiceId(
219: l_card_trxn_id,
220: l_invoice_id );
221:
222: END LOOP;

Line 242: l_result := AP_WEB_DB_CCARD_PKG.GetCardProgramInfo(

238: THEN
239: -----------------------------------------------------------------------
240: l_debugInfo := 'Retrieving vendor info from card program';
241: -----------------------------------------------------------------------
242: l_result := AP_WEB_DB_CCARD_PKG.GetCardProgramInfo(
243: p_cardProgramID,
244: l_vendor_id,
245: l_vendor_site_id,
246: l_invoice_currency_code );

Line 422: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;

418: l_callingSequence varchar2(100);
419: l_minAcctUnit AP_WEB_DB_COUNTRY_PKG.curr_minAcctUnit ;
420: l_precision AP_WEB_DB_COUNTRY_PKG.curr_precision;
421: l_exchangeRate AP_WEB_DB_AP_INT_PKG.invAll_exchangeRate;
422: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
423: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
424: l_cardProgramID NUMBER;
425: l_Personal VARCHAR2(10);
426: l_org_id NUMBER;

Line 560: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;

556: l_debugInfo VARCHAR2(2000);
557: l_clearingCCID NUMBER;
558: l_invoiceAmt AP_WEB_DB_AP_INT_PKG.invLines_amount := p_invoiceTotal;
559: l_totalCCardAmt NUMBER := 0;
560: l_prepaidInvId AP_WEB_DB_CCARD_PKG.ccTrxn_companyPrepaidInvID;
561: l_cCardLineAmt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
562: l_cardProgramID NUMBER;
563: l_Personal VARCHAR2(10);
564: l_callingSequence varchar2(100);