DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_WEB_EXPENSE_WF

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

4602: l_personal_total NUMBER := 0;
4603: l_cash_amt NUMBER := 0;
4604: l_ccard_amt NUMBER := 0;
4605: l_total_amt NUMBER := 0;
4606: l_company_pay VARCHAR2(100) := AP_WEB_EXPENSE_WF.C_CompanyPay;
4607: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
4608: BEGIN
4609:
4610: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

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

4646: /**
4647: * Different calculations are different depending on the payment scenario. Branch the code
4648: * depending on the scenario.
4649: */
4650: IF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_CompanyPay) THEN
4651:
4652: IF (NOT AP_WEB_DB_EXPLINE_PKG.GetPersonalTotalOfExpRpt(p_report_header_id, l_personal_total)) THEN
4653: l_personal_total := 0;
4654: END IF;

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

4666: */
4667: p_ccard_amt := l_ccard_amt;
4668: p_total_amt := l_total_amt;
4669:
4670: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_IndividualPay) THEN
4671:
4672: /**
4673: * For individual pay the employee is paying for all the expenses and receiving the reimbursement in cash.
4674: * So the amount due to the employee is the total of the expense report, amount due cc issuer is 0.

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

4676: p_emp_amt := l_total_amt;
4677: p_ccard_amt := 0;
4678: p_total_amt := l_total_amt;
4679:
4680: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_BothPay) THEN
4681:
4682: /**
4683: * For both pay the company is paying for business cc expenses, note this amount includes the auditor
4684: * adjustments, the adjusted amount is displayed to the user as personal cc expense.