APPS.AP_WEB_EXPENSE_WF dependencies on AP_WEB_DB_EXPDIST_PKG

Line 1018: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;

1014: l_line_num NUMBER := 0;
1015:
1016: ExpenseReportLinesCursor AP_WEB_DB_EXPLINE_PKG.XpenseLineAcctCursor;
1017: V_DistLineNumber AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
1018: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;
1019: V_StartExpenseDate AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
1020: V_Amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
1021: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
1022: V_CreditCardTrxID AP_WEB_DB_EXPLINE_PKG.expLines_crdCardTrxID;

Line 1799: p_report_distribution_id IN AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID,

1795:
1796:
1797: ----------------------------------------------------------------------
1798: PROCEDURE HandleInvalidDistCCID(p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1799: p_report_distribution_id IN AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID,
1800: p_payment_due IN VARCHAR2,
1801: p_exp_type_parameter_id IN AP_WEB_DB_EXPLINE_PKG.expLines_webParamID,
1802: p_personalParameterId IN AP_WEB_DB_EXPLINE_PKG.expLines_webParamID,
1803: p_CategoryCode IN AP_WEB_DB_EXPLINE_PKG.expLines_categorycode,

Line 1823: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (

1819: if ((p_payment_due = C_CompanyPay AND p_exp_type_parameter_id = p_personalParameterId) or
1820: (p_CategoryCode = C_ROUNDING))then
1821: -- if dist does not exist then it adds dist and then updates
1822: -- ccid and segments based on p_exp_dist_ccid
1823: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (
1824: p_report_header_id => p_report_header_id,
1825: p_report_line_id => p_ReportLineId,
1826: p_report_distribution_id => p_report_distribution_id,
1827: p_ccid => p_exp_dist_ccid);

Line 1844: AP_WEB_DB_EXPDIST_PKG.AddDistributionLine(

1840:
1841: -----------------------------------------------------
1842: l_debug_info := 'Add Dist for Line';
1843: -----------------------------------------------------
1844: AP_WEB_DB_EXPDIST_PKG.AddDistributionLine(
1845: p_segments => l_new_segments,
1846: p_report_line_id => p_ReportLineId,
1847: p_chart_of_accounts_id => p_chart_of_accounts_id);
1848: end if;

Line 1944: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;

1940: V_HeaderAttribute15 AP_WEB_DB_EXPRPT_PKG.expHdr_attr15;
1941:
1942: ExpenseReportLinesCursor AP_WEB_DB_EXPLINE_PKG.XpenseLineAcctCursor;
1943: l_dist_line_number AP_WEB_DB_EXPLINE_PKG.expLines_distLineNum;
1944: l_report_distribution_id AP_WEB_DB_EXPDIST_PKG.expDist_REPORT_DISTRIBUTION_ID;
1945: V_StartExpenseDate AP_WEB_DB_EXPLINE_PKG.expLines_startExpDate;
1946: V_Amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
1947: V_ExpenseType AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
1948: V_CreditCardTrxID AP_WEB_DB_EXPLINE_PKG.expLines_crdCardTrxID;

Line 2310: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (

2306: l_debug_info:='Synch Account Segments with CCID';
2307: -- updateAccountValues calls AddDistributionLine if dist does not
2308: -- exist and then updates the ccid and segments based on l_exp_dist_ccid
2309: --------------------------------------------------------------
2310: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (
2311: p_report_header_id => p_report_header_id,
2312: p_report_line_id => V_ReportLineId,
2313: p_report_distribution_id => l_report_distribution_id,
2314: p_ccid => l_exp_dist_ccid);

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

2364: END IF; /*l_rounding_error_ccid IS NULL*/
2365:
2366: ELSE
2367: -- Removed code for 'LLA Enabled with Online Validation';
2368: -- i.e, Removed call to AP_WEB_DB_EXPDIST_PKG.UpdateDistCCID
2369: -- as there is no change in l_exp_dist_ccid
2370:
2371: IF (l_report_distribution_id is not null) THEN -- Distribution Exist
2372:

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

2369: -- as there is no change in l_exp_dist_ccid
2370:
2371: IF (l_report_distribution_id is not null) THEN -- Distribution Exist
2372:
2373: IF (NOT AP_WEB_DB_EXPDIST_PKG.foundCCID(l_report_distribution_id, l_exp_dist_ccid)) THEN
2374:
2375: --------------------------------------------------------------
2376: l_debug_info:='LLA Enabled without Online Validation';
2377: --------------------------------------------------------------

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

2404: l_line_error_message := l_line_error_message || l_return_error_message || ' ';
2405: l_add_to_line_error := true;
2406: end if;
2407:
2408: END IF; -- (Not AP_WEB_DB_EXPDIST_PKG.foundCCID) 'LLA Enabled without Online Validation';
2409:
2410: ELSE -- else of Distribution Exist
2411:
2412: --------------------------------------------------------------

Line 2479: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (

2475: l_debug_info:='Synch Account Segments with CCID';
2476: -- updateAccountValues calls AddDistributionLine if dist does not
2477: -- exist and then updates the ccid and segments based on l_exp_dist_ccid
2478: --------------------------------------------------------------
2479: AP_WEB_DB_EXPDIST_PKG.updateAccountValues (
2480: p_report_header_id => p_report_header_id,
2481: p_report_line_id => V_ReportLineId,
2482: p_report_distribution_id => l_report_distribution_id,
2483: p_ccid => l_exp_dist_ccid);