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 1888: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;

1884:
1885: l_employee_ccid AP_WEB_DB_EXPRPT_PKG.expHdr_employeeCCID;
1886: l_employee_id AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1887: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1888: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1889: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
1890: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1891: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1892: exchange_rate_exception EXCEPTION;

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

3970: l_debug_info := 'Update the Credit Card Trxns associated with the Expense
3971: Report as Approved';
3972: ----------------------------------------------------------------------
3973: IF (l_payment_due = C_BothPay OR l_payment_due = C_CompanyPay) THEN
3974: IF (NOT AP_WEB_DB_CCARD_PKG.SetStatus(l_report_header_id, 'APPROVED')) THEN
3975: NULL;
3976: END IF;
3977: END IF;
3978:

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

4432: l_debug_info := 'Set the report header id of the CC charges that
4433: are attached to the shortpaid report due to policy
4434: violation with the new expense report id';
4435: --------------------------------------------------------------------
4436: IF (NOT AP_WEB_DB_CCARD_PKG.SetCCPolicyShortpaidReportID(p_orig_expense_report_id, p_new_expense_report_id)) THEN
4437: NULL;
4438: END IF;
4439:
4440: --------------------------------------------------------------------

Line 4478: IF (NOT AP_WEB_DB_CCARD_PKG.SetCCReceiptShortpaidReportID(

4474: l_debug_info := 'Set the report header id of the CC charges that
4475: are attached to the shortpaid report due to missing
4476: receipts with the new expense report id';
4477: --------------------------------------------------------------------
4478: IF (NOT AP_WEB_DB_CCARD_PKG.SetCCReceiptShortpaidReportID(
4479: p_orig_expense_report_id, p_new_expense_report_id)) THEN
4480: NULL;
4481: END IF;
4482:

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

4999: l_debug_info := 'Update manager rejected/returned credit card transactions that
5000: are deleted after a timeout';
5001: ---------------------------------------------------------------------
5002: IF (l_payment_due = C_BothPay OR l_payment_due = C_CompanyPay) THEN
5003: IF (NOT AP_WEB_DB_CCARD_PKG.ResetCCMgrRejectedCCLines(p_report_header_id)) THEN
5004: NULL;
5005: END IF;
5006: END IF;
5007:

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

5009:
5010: ---------------------------------------------------------------------------
5011: l_debug_info := 'Update shortpaid credit card transactions';
5012: ---------------------------------------------------------------------------
5013: IF (NOT AP_WEB_DB_CCARD_PKG.ResetCCLines(p_report_header_id)) THEN
5014: NULL;
5015: END IF;
5016:
5017: ---------------------------------------------------------------------------

Line 5344: IF (NOT AP_WEB_DB_CCARD_PKG.ResetMgrRejectPersonalTrxns(

5340: data on rejected reports.
5341: l_debug_info := 'Update for Credit Card Integration Bothpay';
5342: IF (l_payment_due = C_CompanyPay OR
5343: l_payment_due = AP_WEB_EXPENSE_WF.C_BothPay) THEN
5344: IF (NOT AP_WEB_DB_CCARD_PKG.ResetMgrRejectPersonalTrxns(
5345: p_report_header_id)) THEN
5346: NULL;
5347: END IF;
5348: END IF;

Line 6130: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;

6126: l_total AP_WEB_DB_EXPRPT_PKG.expHdr_total := NULL;
6127: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
6128: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
6129: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
6130: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
6131: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;
6132: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;
6133: l_XpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
6134: l_accts_pay_comb_id AP_WEB_DB_EXPRPT_PKG.expHdr_acctsPayCodeCombID := NULL;

Line 6131: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;

6127: l_new_report_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
6128: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
6129: l_description AP_WEB_DB_EXPRPT_PKG.expHdr_description := NULL;
6130: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID := NULL;
6131: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID := NULL;
6132: l_ccard_amt AP_WEB_DB_EXPRPT_PKG.expHdr_amtDueCcardCompany := 0;
6133: l_XpenseRec AP_WEB_DB_EXPRPT_PKG.XpenseInfoRec;
6134: l_accts_pay_comb_id AP_WEB_DB_EXPRPT_PKG.expHdr_acctsPayCodeCombID := NULL;
6135: l_debug_info VARCHAR2(2000);

Line 6384: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;

6380: p_funmode IN VARCHAR2,
6381: p_result OUT NOCOPY VARCHAR2) IS
6382: ----------------------------------------------------------------------
6383: l_debug_info VARCHAR2(200);
6384: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6385: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6386: l_report_header_id AP_WEB_DB_CCARD_PKG.ccTrxn_headerID;
6387: l_crd_card_count NUMBER := 0;
6388:

Line 6385: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;

6381: p_result OUT NOCOPY VARCHAR2) IS
6382: ----------------------------------------------------------------------
6383: l_debug_info VARCHAR2(200);
6384: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6385: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6386: l_report_header_id AP_WEB_DB_CCARD_PKG.ccTrxn_headerID;
6387: l_crd_card_count NUMBER := 0;
6388:
6389: BEGIN

Line 6386: l_report_header_id AP_WEB_DB_CCARD_PKG.ccTrxn_headerID;

6382: ----------------------------------------------------------------------
6383: l_debug_info VARCHAR2(200);
6384: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6385: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
6386: l_report_header_id AP_WEB_DB_CCARD_PKG.ccTrxn_headerID;
6387: l_crd_card_count NUMBER := 0;
6388:
6389: BEGIN
6390:

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

6401:
6402: ----------------------------------------------------------------
6403: l_debug_info := 'Retrieve Vendor IDs from the table';
6404: ------------------------------------------------------------
6405: IF (NOT AP_WEB_DB_CCARD_PKG.GetVendorIDs(l_report_header_id, l_vendor_id,
6406: l_vendor_site_id)) THEN
6407: l_vendor_id := NULL;
6408: l_vendor_site_id := NULL;
6409: END IF;

Line 11125: IF (NOT AP_WEB_DB_CCARD_PKG.ResetMgrRejectPersonalTrxns(

11121:
11122: /* Bug 6502501: cc trxns are detached from expense report when an
11123: expense report is returned.
11124: IF (l_payment_due = C_CompanyPay OR l_payment_due = C_BothPay) THEN
11125: IF (NOT AP_WEB_DB_CCARD_PKG.ResetMgrRejectPersonalTrxns(
11126: l_report_header_id)) THEN
11127: NULL;
11128: END IF;
11129: END IF;