APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_WEB_DB_EXPTEMPLATE_PKG

Line 61: l_default_template_name AP_WEB_DB_EXPTEMPLATE_PKG.expTypes_reportType;

57: l_bUserPrefResult BOOLEAN;
58:
59: -- Default expense template ID in Payables
60: l_defaultAPTemplateId AP_SYSTEM_PARAMETERS.expense_report_id%TYPE;
61: l_default_template_name AP_WEB_DB_EXPTEMPLATE_PKG.expTypes_reportType;
62:
63: -- Preparer's user preference
64: l_userPrefs AP_WEB_DB_USER_PREF_PKG.UserPrefsInfoRec;
65:

Line 82: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetDefaultTemplateId(l_defaultAPTemplateId)) THEN

78: -- Get user preferences
79: l_bUserPrefResult := AP_WEB_DB_USER_PREF_PKG.GetUserPrefs(p_preparer_id, l_userPrefs);
80:
81: -- Get default expense template ID from Payables Options
82: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetDefaultTemplateId(l_defaultAPTemplateId)) THEN
83: p_default_expense_template_id := l_defaultAPTemplateId;
84: END IF;
85:
86: -- Default expense template ID

Line 89: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetTemplateName(l_userPrefs.default_expense_template_id,

85:
86: -- Default expense template ID
87: IF (l_userPrefs.default_expense_template_id IS NOT NULL) THEN
88: -- Want to be sure that the template ID is valid for this org
89: IF (AP_WEB_DB_EXPTEMPLATE_PKG.GetTemplateName(l_userPrefs.default_expense_template_id,
90: l_default_template_name)) THEN
91: p_default_expense_template_id := l_userPrefs.default_expense_template_id;
92: ELSE
93: p_default_expense_template_id := NULL;

Line 434: l_expenditure_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paExpenditureType := NULL;

430: l_receipt_line_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;
431: l_validate_receipt_errors AP_WEB_UTILITIES_PKG.receipt_error_stack;
432: l_receipt_with_error NUMBER;
433: current_calling_sequence varchar2(100) := 'ValidateReceiptLine';
434: l_expenditure_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paExpenditureType := NULL;
435:
436: ExpReportLinesInfo_A AP_WEB_DFLEX_PKG.ExpReportLines_A;
437: CustomValuesArray AP_WEB_PARENT_PKG.BigString_Array;
438: l_calculate_amt_index INTEGER := p_calculate_amt_index;

Line 715: | Wrapper for calling AP_WEB_DB_EXPTEMPLATE_PKG.Get_ItemDesc_LookupCode |

711: | Procedure |
712: | GetItemDescLookupCode |
713: | |
714: | DESCRIPTION |
715: | Wrapper for calling AP_WEB_DB_EXPTEMPLATE_PKG.Get_ItemDesc_LookupCode |
716: | |
717: | PARAMETERS |
718: | INPUT |
719: | p_parameter_id VARCHAR2 -- web parameter id |

Line 741: bResult := AP_WEB_DB_EXPTEMPLATE_PKG.Get_ItemDesc_LookupCode(

737:
738: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',
739: 'start GetItemDescLookupCode');
740:
741: bResult := AP_WEB_DB_EXPTEMPLATE_PKG.Get_ItemDesc_LookupCode(
742: p_parameter_id,
743: p_item_description,
744: p_line_type_lookup_code,
745: l_require_receipt_amount);