APPS.AP_WEB_EXPENSE_WF dependencies on AP_WEB_DB_EXPDIST_PKG

Line 1001: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;

997: l_line_num NUMBER := 0;
998:
999: ExpenseReportLinesCursor AP_WEB_DB_EXPLINE_PKG.XpenseLineAcctCursor;
1000: V_DistLineNumber AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
1001: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;
1002: V_StartExpenseDate AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
1003: V_Amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
1004: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
1005: V_CreditCardTrxID AP_WEB_DB_EXPLINE_PKG.expLines_crdCardTrxID;

Line 1782: p_report_distribution_id IN AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID,

1778:
1779:
1780: ----------------------------------------------------------------------
1781: PROCEDURE HandleInvalidDistCCID(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1782: p_report_distribution_id IN AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID,
1783: p_payment_due IN VARCHAR2,
1784: p_exp_type_parameter_id IN AP_WEB_DB_EXPLINE_PKG.expLines_webParamID,
1785: p_personalParameterId IN AP_WEB_DB_EXPLINE_PKG.expLines_webParamID,
1786: p_CategoryCode IN AP_WEB_DB_EXPLINE_PKG.expLines_categorycode,

Line 1806: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (

1802: if ((p_payment_due = C_CompanyPay AND p_exp_type_parameter_id = p_personalParameterId) or
1803: (p_CategoryCode = C_ROUNDING))then
1804: -- if dist does not exist then it adds dist and then updates
1805: -- ccid and segments based on p_exp_dist_ccid
1806: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (
1807: p_report_header_id => p_report_header_id,
1808: p_report_line_id => p_ReportLineId,
1809: p_report_distribution_id => p_report_distribution_id,
1810: p_ccid => p_exp_dist_ccid);

Line 1827: AP_WEB_DB_EXPDIST_PKG.AddDistributionLine(

1823:
1824: -----------------------------------------------------
1825: l_debug_info := 'Add Dist for Line';
1826: -----------------------------------------------------
1827: AP_WEB_DB_EXPDIST_PKG.AddDistributionLine(
1828: p_segments => l_new_segments,
1829: p_report_line_id => p_ReportLineId,
1830: p_chart_of_accounts_id => p_chart_of_accounts_id);
1831: end if;

Line 1927: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;

1923: V_HeaderAttribute15 AP_WEB_DB_EXPRPT_PKG.expHdr_attr15;
1924:
1925: ExpenseReportLinesCursor AP_WEB_DB_EXPLINE_PKG.XpenseLineAcctCursor;
1926: l_dist_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
1927: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;
1928: V_StartExpenseDate AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
1929: V_Amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
1930: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
1931: V_CreditCardTrxID AP_WEB_DB_EXPLINE_PKG.expLines_crdCardTrxID;

Line 2293: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (

2289: l_debug_info:='Synch Account Segments with CCID';
2290: -- updateAccountValues calls AddDistributionLine if dist does not
2291: -- exist and then updates the ccid and segments based on l_exp_dist_ccid
2292: --------------------------------------------------------------
2293: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (
2294: p_report_header_id => p_report_header_id,
2295: p_report_line_id => V_ReportLineId,
2296: p_report_distribution_id => l_report_distribution_id,
2297: p_ccid => l_exp_dist_ccid);

Line 2351: -- i.e, Removed call to AP_WEB_DB_EXPDIST_PKG.UpdateDistCCID

2347: END IF; /*l_rounding_error_ccid IS NULL*/
2348:
2349: ELSE
2350: -- Removed code for 'LLA Enabled with Online Validation';
2351: -- i.e, Removed call to AP_WEB_DB_EXPDIST_PKG.UpdateDistCCID
2352: -- as there is no change in l_exp_dist_ccid
2353:
2354: IF (l_report_distribution_id is not null) THEN -- Distribution Exist
2355:

Line 2356: IF (NOT AP_WEB_DB_EXPDIST_PKG.foundCCID(l_report_distribution_id, l_exp_dist_ccid)) THEN

2352: -- as there is no change in l_exp_dist_ccid
2353:
2354: IF (l_report_distribution_id is not null) THEN -- Distribution Exist
2355:
2356: IF (NOT AP_WEB_DB_EXPDIST_PKG.foundCCID(l_report_distribution_id, l_exp_dist_ccid)) THEN
2357:
2358: --------------------------------------------------------------
2359: l_debug_info:='LLA Enabled without Online Validation';
2360: --------------------------------------------------------------

Line 2391: END IF; -- (Not AP_WEB_DB_EXPDIST_PKG.foundCCID) 'LLA Enabled without Online Validation';

2387: l_line_error_message := l_line_error_message || l_return_error_message || ' ';
2388: l_add_to_line_error := true;
2389: end if;
2390:
2391: END IF; -- (Not AP_WEB_DB_EXPDIST_PKG.foundCCID) 'LLA Enabled without Online Validation';
2392:
2393: ELSE -- else of Distribution Exist
2394:
2395: --------------------------------------------------------------

Line 2462: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (

2458: l_debug_info:='Synch Account Segments with CCID';
2459: -- updateAccountValues calls AddDistributionLine if dist does not
2460: -- exist and then updates the ccid and segments based on l_exp_dist_ccid
2461: --------------------------------------------------------------
2462: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (
2463: p_report_header_id => p_report_header_id,
2464: p_report_line_id => V_ReportLineId,
2465: p_report_distribution_id => l_report_distribution_id,
2466: p_ccid => l_exp_dist_ccid);