DBA Data[Home] [Help]

APPS.AP_WEB_CUST_AME_PKG dependencies on AP_WEB_AME_PKG

Line 151: l_approver_id := AP_WEB_AME_PKG.getAwardManagerID(l_award_id, nvl(l_week_end_date,trunc(sysdate)));

147: from ap_expense_report_lines_all line
148: where line.report_header_id = dist.report_header_id
149: and web_parameter_id in (l_personalParameterId, l_roundingParameterId));
150:
151: l_approver_id := AP_WEB_AME_PKG.getAwardManagerID(l_award_id, nvl(l_week_end_date,trunc(sysdate)));
152: RETURN checkAndGetApprover(l_approver_id,l_employee_id);
153: END IF;
154:
155: -----------------------------------------------------

Line 180: l_approver_id := AP_WEB_AME_PKG.getProjectManagerID(l_project_id, nvl(l_week_end_date,trunc(sysdate)));

176: from ap_expense_report_lines_all line
177: where line.report_header_id = dist.report_header_id
178: and web_parameter_id in (l_personalParameterId, l_roundingParameterId));
179:
180: l_approver_id := AP_WEB_AME_PKG.getProjectManagerID(l_project_id, nvl(l_week_end_date,trunc(sysdate)));
181: RETURN checkAndGetApprover(l_approver_id,l_employee_id);
182: END IF;
183: -----------------------------------------------------
184: -- End of getting Project Manager ID.

Line 337: RETURN AP_WEB_AME_PKG.getCostCenterOwner(p_report_header_id, p_cost_center);

333: -- RETURN NULL;
334: -- END IF;
335: --
336:
337: RETURN AP_WEB_AME_PKG.getCostCenterOwner(p_report_header_id, p_cost_center);
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: IF (SQLCODE <> -20001) THEN

Line 684: return AP_WEB_AME_PKG.getProjectManagerID(to_number(p_project_id), trunc(sysdate));

680: l_debug_info VARCHAR2(200);
681:
682: BEGIN
683:
684: return AP_WEB_AME_PKG.getProjectManagerID(to_number(p_project_id), trunc(sysdate));
685:
686: EXCEPTION
687: WHEN OTHERS THEN
688: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getProjectApprover',

Line 700: return AP_WEB_AME_PKG.getAwardManagerID(to_number(p_award_id), trunc(sysdate));

696: l_debug_info VARCHAR2(200);
697:
698: BEGIN
699:
700: return AP_WEB_AME_PKG.getAwardManagerID(to_number(p_award_id), trunc(sysdate));
701:
702: EXCEPTION
703: WHEN OTHERS THEN
704: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getAwardApprover',