DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on AP_WEB_DB_EXPTEMPLATE_PKG

Line 1870: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

1866: l_id_flex_structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE;
1867:
1868: l_employee_ccid AP_WEB_DB_EXPRPT_PKG.expHdr_employeeCCID;
1869: l_employee_id AP_WEB_DB_EXPRPT_PKG.expHdr_employeeID;
1870: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
1871: l_category AP_WEB_DB_CCARD_PKG.ccTrxn_category;
1872: l_default_exchange_rate AP_WEB_DB_EXPRPT_PKG.expHdr_defaultExchRate;
1873: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1874: l_sys_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;

Line 2114: l_debug_info := 'calling AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID';

2110: l_payment_due := WF_ENGINE.GetItemAttrText(p_item_type,p_item_key,'PAYMENT_DUE_FROM');
2111:
2112: IF (l_payment_due = C_CompanyPay) then
2113: ------------------------------------------------------------------------
2114: l_debug_info := 'calling AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID';
2115: ------------------------------------------------------------------------
2116: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
2117: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_PERSONAL_EXP_TYPE');
2118: AddToHeaderErrors(p_item_type,

Line 2116: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN

2112: IF (l_payment_due = C_CompanyPay) then
2113: ------------------------------------------------------------------------
2114: l_debug_info := 'calling AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID';
2115: ------------------------------------------------------------------------
2116: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
2117: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_PERSONAL_EXP_TYPE');
2118: AddToHeaderErrors(p_item_type,
2119: p_item_key,
2120: FND_MESSAGE.GET);

Line 3415: l_expense_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;

3411: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;
3412: l_orig_expe_report_amt NUMBER;
3413: l_exp_report_amount AP_WEB_DB_EXPRPT_PKG.expHdr_total;
3414: l_orig_exp_report_amt NUMBER;
3415: l_expense_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
3416: l_amount AP_WEB_DB_EXPLINE_PKG.expLines_amount;
3417: l_adjustment_reason AP_WEB_DB_EXPLINE_PKG.expLines_adjReason;
3418:
3419: l_currency VARCHAR2(50);

Line 11211: l_expense_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;

11207: l_total_amt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
11208: l_expense_report_total_amt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
11209: l_cc_personal_total_amt AP_WEB_DB_EXPLINE_PKG.expLines_amount;
11210: l_justification AP_WEB_DB_EXPLINE_PKG.expLines_justification;
11211: l_expense_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_webFriendlyPrompt;
11212: l_project_number PA_PROJECTS.segment1%TYPE;
11213: l_task_number AP_WEB_DB_PA_INT_PKG.tasks_taskNum;
11214: l_award_number GMS_OIE_INT_PKG.gms_awardNum;
11215: l_credit_card_trx_id AP_WEB_DB_EXPLINE_PKG.expLines_crdCardTrxID;