DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_WEB_EXPENSE_WF

Line 4920: l_company_pay VARCHAR2(100) := AP_WEB_EXPENSE_WF.C_CompanyPay;

4916: l_personal_total NUMBER := 0;
4917: l_cash_amt NUMBER := 0;
4918: l_ccard_amt NUMBER := 0;
4919: l_total_amt NUMBER := 0;
4920: l_company_pay VARCHAR2(100) := AP_WEB_EXPENSE_WF.C_CompanyPay;
4921: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
4922: BEGIN
4923:
4924: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

Line 4964: IF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_CompanyPay) THEN

4960: /**
4961: * Different calculations are different depending on the payment scenario. Branch the code
4962: * depending on the scenario.
4963: */
4964: IF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_CompanyPay) THEN
4965:
4966: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetPersonalTotalOfExpRpt(p_report_header_id, l_personal_total)) THEN
4967: l_personal_total := 0;
4968: END IF;

Line 4984: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_IndividualPay) THEN

4980: */
4981: p_ccard_amt := l_ccard_amt;
4982: p_total_amt := l_total_amt;
4983:
4984: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_IndividualPay) THEN
4985:
4986: /**
4987: * For individual pay the employee is paying for all the expenses and receiving the reimbursement in cash.
4988: * So the amount due to the employee is the total of the expense report, amount due cc issuer is 0.

Line 4994: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_BothPay) THEN

4990: p_emp_amt := l_total_amt;
4991: p_ccard_amt := 0;
4992: p_total_amt := l_total_amt;
4993:
4994: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_BothPay) THEN
4995:
4996: /**
4997: * For both pay the company is paying for business cc expenses, note this amount includes the auditor
4998: * adjustments, the adjusted amount is displayed to the user as personal cc expense.