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 435: l_expenditure_type AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paExpenditureType := NULL;

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

Line 717: | Wrapper for calling AP_WEB_DB_EXPTEMPLATE_PKG.Get_ItemDesc_LookupCode |

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

Line 743: bResult := AP_WEB_DB_EXPTEMPLATE_PKG.Get_ItemDesc_LookupCode(

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