APPS.AP_WEB_CUST_AME_PKG dependencies on AP_WEB_DB_EXPTEMPLATE_PKG

Line 88: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

84: l_employee_name VARCHAR2(240);
85: l_project_id NUMBER;
86: l_award_id NUMBER;
87: l_week_end_date DATE;
88: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
89: l_roundingParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
90: BEGIN
91: SELECT aeh.week_end_date, aeh.employee_id, flex_concatenated
92: INTO l_week_end_date, l_employee_id, l_cost_center

Line 89: l_roundingParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;

85: l_project_id NUMBER;
86: l_award_id NUMBER;
87: l_week_end_date DATE;
88: l_personalParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
89: l_roundingParameterId AP_WEB_DB_EXPTEMPLATE_PKG.expTempl_paramID;
90: BEGIN
91: SELECT aeh.week_end_date, aeh.employee_id, flex_concatenated
92: INTO l_week_end_date, l_employee_id, l_cost_center
93: FROM ap_expense_report_headers_all aeh

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

111: -- the Award Manager be included in the Approver list under any
112: -- circumstance.
113: -----------------------------------------------------
114:
115: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
116: APP_EXCEPTION.RAISE_EXCEPTION;
117: END IF;
118:
119: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetRoundingParamID(l_roundingParameterId)) THEN

Line 119: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetRoundingParamID(l_roundingParameterId)) THEN

115: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
116: APP_EXCEPTION.RAISE_EXCEPTION;
117: END IF;
118:
119: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetRoundingParamID(l_roundingParameterId)) THEN
120: APP_EXCEPTION.RAISE_EXCEPTION;
121: END IF;
122:
123: -----------------------------------------------------