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

Line 1871: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;

1867:
1868: l_employee_ccid AP_WEB_DB_EXPRPT_PKG.expHdr_employeeCCID;
1869: l_employee_id AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1870: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1871: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1872: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
1873: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1874: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1875: exchange_rate_exception EXCEPTION;

Line 3923: IF (NOT AP_WEB_DB_CCARD_PKG.SetStatus(l_report_header_id, 'APPROVED')) THEN

3919: l_debug_info := 'Update the Credit Card Trxns associated with the Expense
3920: Report as Approved';
3921: ----------------------------------------------------------------------
3922: IF (l_payment_due = C_BothPay OR l_payment_due = C_CompanyPay) THEN
3923: IF (NOT AP_WEB_DB_CCARD_PKG.SetStatus(l_report_header_id, 'APPROVED')) THEN
3924: NULL;
3925: END IF;
3926: END IF;
3927:

Line 4310: IF (NOT AP_WEB_DB_CCARD_PKG.SetCCPolicyShortpaidReportID(p_orig_expense_report_id, p_new_expense_report_id)) THEN

4306: l_debug_info := 'Set the report header id of the CC charges that
4307: are attached to the shortpaid report due to policy
4308: violation with the new expense report id';
4309: --------------------------------------------------------------------
4310: IF (NOT AP_WEB_DB_CCARD_PKG.SetCCPolicyShortpaidReportID(p_orig_expense_report_id, p_new_expense_report_id)) THEN
4311: NULL;
4312: END IF;
4313:
4314: --------------------------------------------------------------------

Line 4338: IF (NOT AP_WEB_DB_CCARD_PKG.SetCCReceiptShortpaidReportID(

4334: l_debug_info := 'Set the report header id of the CC charges that
4335: are attached to the shortpaid report due to missing
4336: receipts with the new expense report id';
4337: --------------------------------------------------------------------
4338: IF (NOT AP_WEB_DB_CCARD_PKG.SetCCReceiptShortpaidReportID(
4339: p_orig_expense_report_id, p_new_expense_report_id)) THEN
4340: NULL;
4341: END IF;
4342:

Line 4697: IF (NOT AP_WEB_DB_CCARD_PKG.ResetCCMgrRejectedCCLines(p_report_header_id)) THEN

4693: l_debug_info := 'Update manager rejected/returned credit card transactions that
4694: are deleted after a timeout';
4695: ---------------------------------------------------------------------
4696: IF (l_payment_due = C_BothPay OR l_payment_due = C_CompanyPay) THEN
4697: IF (NOT AP_WEB_DB_CCARD_PKG.ResetCCMgrRejectedCCLines(p_report_header_id)) THEN
4698: NULL;
4699: END IF;
4700: END IF;
4701:

Line 4707: IF (NOT AP_WEB_DB_CCARD_PKG.ResetCCLines(p_report_header_id)) THEN

4703:
4704: ---------------------------------------------------------------------------
4705: l_debug_info := 'Update shortpaid credit card transactions';
4706: ---------------------------------------------------------------------------
4707: IF (NOT AP_WEB_DB_CCARD_PKG.ResetCCLines(p_report_header_id)) THEN
4708: NULL;
4709: END IF;
4710:
4711: ---------------------------------------------------------------------------

Line 5025: IF (NOT AP_WEB_DB_CCARD_PKG.ResetMgrRejectPersonalTrxns(

5021: data on rejected reports.
5022: l_debug_info := 'Update for Credit Card Integration Bothpay';
5023: IF (l_payment_due = C_CompanyPay OR
5024: l_payment_due = AP_WEB_EXPENSE_WF.C_BothPay) THEN
5025: IF (NOT AP_WEB_DB_CCARD_PKG.ResetMgrRejectPersonalTrxns(
5026: p_report_header_id)) THEN
5027: NULL;
5028: END IF;
5029: END IF;

Line 5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;

5763: l_total AP_WEB_DB_EXPRPT_PKG.expHdr_total := NULL;
5764: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5765: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
5768: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;
5769: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;
5770: l_XpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
5771: l_accts_pay_comb_id AP_WEB_DB_EXPRPT_PKG.expHdr_acctsPayCodeCombID := NULL;

Line 5768: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;

5764: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
5765: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
5766: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
5767: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
5768: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;
5769: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;
5770: l_XpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
5771: l_accts_pay_comb_id AP_WEB_DB_EXPRPT_PKG.expHdr_acctsPayCodeCombID := NULL;
5772: l_debug_info VARCHAR2(2000);

Line 6003: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;

5999: p_funmode IN VARCHAR2,
6000: p_result OUT NOCOPY VARCHAR2) IS
6001: ----------------------------------------------------------------------
6002: l_debug_info VARCHAR2(200);
6003: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6004: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6005: l_report_header_id AP_WEB_DB_CCARD_PKG.ccTrxn_headerID;
6006: l_crd_card_count NUMBER := 0;
6007:

Line 6004: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;

6000: p_result OUT NOCOPY VARCHAR2) IS
6001: ----------------------------------------------------------------------
6002: l_debug_info VARCHAR2(200);
6003: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6004: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6005: l_report_header_id AP_WEB_DB_CCARD_PKG.ccTrxn_headerID;
6006: l_crd_card_count NUMBER := 0;
6007:
6008: BEGIN

Line 6005: l_report_header_id AP_WEB_DB_CCARD_PKG.ccTrxn_headerID;

6001: ----------------------------------------------------------------------
6002: l_debug_info VARCHAR2(200);
6003: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6004: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6005: l_report_header_id AP_WEB_DB_CCARD_PKG.ccTrxn_headerID;
6006: l_crd_card_count NUMBER := 0;
6007:
6008: BEGIN
6009:

Line 6024: IF (NOT AP_WEB_DB_CCARD_PKG.GetVendorIDs(l_report_header_id, l_vendor_id,

6020:
6021: ----------------------------------------------------------------
6022: l_debug_info := 'Retrieve Vendor IDs from the table';
6023: ------------------------------------------------------------
6024: IF (NOT AP_WEB_DB_CCARD_PKG.GetVendorIDs(l_report_header_id, l_vendor_id,
6025: l_vendor_site_id)) THEN
6026: l_vendor_id := NULL;
6027: l_vendor_site_id := NULL;
6028: END IF;

Line 10398: IF (NOT AP_WEB_DB_CCARD_PKG.ResetMgrRejectPersonalTrxns(

10394:
10395: /* Bug 6502501: cc trxns are detached from expense report when an
10396: expense report is returned.
10397: IF (l_payment_due = C_CompanyPay OR l_payment_due = C_BothPay) THEN
10398: IF (NOT AP_WEB_DB_CCARD_PKG.ResetMgrRejectPersonalTrxns(
10399: l_report_header_id)) THEN
10400: NULL;
10401: END IF;
10402: END IF;