eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_CUST_AME_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 68: FUNCTION getHeaderLevelApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN VARCHAR2 IS

64: | - Return NULL means default manager will be used to build
65: | the approver list.
66: *----------------------------------------------------------------------------*/
67: -------------------------------------------------------------------------
68: FUNCTION getHeaderLevelApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN VARCHAR2 IS
69: -------------------------------------------------------------------------
70: l_debug_info VARCHAR2(200);
71: l_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
72: l_employee_id NUMBER;

Line 133: from ap_expense_report_lines_all line

129: from ap_exp_report_dists_all dist
130: where report_header_id = p_report_header_id
131: and report_line_id not in (
132: select report_line_id
133: from ap_expense_report_lines_all line
134: where line.report_header_id = dist.report_header_id
135: and web_parameter_id in (l_personalParameterId, l_roundingParameterId));
136:
137: -----------------------------------------------------

Line 147: from ap_expense_report_lines_all line

143: from ap_exp_report_dists_all dist
144: where report_header_id = p_report_header_id
145: and report_line_id not in (
146: select report_line_id
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)));

Line 176: from ap_expense_report_lines_all line

172: from ap_exp_report_dists_all dist
173: where report_header_id = p_report_header_id
174: and report_line_id not in (
175: select report_line_id
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)));

Line 270: FUNCTION getLineLevelApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,

266: | Approver ID - Employee id of Line-Level Approver.
267: |
268: *----------------------------------------------------------------------------*/
269: -------------------------------------------------------------------------
270: FUNCTION getLineLevelApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
271: p_dist_line_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE) RETURN VARCHAR2 IS
272: -------------------------------------------------------------------------
273: l_debug_info VARCHAR2(200);
274:

Line 271: p_dist_line_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE) RETURN VARCHAR2 IS

267: |
268: *----------------------------------------------------------------------------*/
269: -------------------------------------------------------------------------
270: FUNCTION getLineLevelApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
271: p_dist_line_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE) RETURN VARCHAR2 IS
272: -------------------------------------------------------------------------
273: l_debug_info VARCHAR2(200);
274:
275: BEGIN

Line 318: FUNCTION getCustomCostCenterOwner(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,

314: | AME attributes will have null value at run-time.
315: | The corresponding AME rules won't take affect.
316: *----------------------------------------------------------------------------*/
317: -------------------------------------------------------------------------
318: FUNCTION getCustomCostCenterOwner(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
319: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2
320: -------------------------------------------------------------------------
321: IS
322: l_debug_info VARCHAR2(200);

Line 319: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2

315: | The corresponding AME rules won't take affect.
316: *----------------------------------------------------------------------------*/
317: -------------------------------------------------------------------------
318: FUNCTION getCustomCostCenterOwner(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
319: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2
320: -------------------------------------------------------------------------
321: IS
322: l_debug_info VARCHAR2(200);
323:

Line 369: FUNCTION getCCBusinessManager(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,

365: | RETURNS
366: | Cost Center Business Manager ID - Employee ID of Cost Center Business Owner.
367: *----------------------------------------------------------------------------*/
368: -------------------------------------------------------------------------
369: FUNCTION getCCBusinessManager(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
370: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2
371: -------------------------------------------------------------------------
372: IS
373: l_debug_info VARCHAR2(200);

Line 370: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2

366: | Cost Center Business Manager ID - Employee ID of Cost Center Business Owner.
367: *----------------------------------------------------------------------------*/
368: -------------------------------------------------------------------------
369: FUNCTION getCCBusinessManager(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
370: p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2
371: -------------------------------------------------------------------------
372: IS
373: l_debug_info VARCHAR2(200);
374: l_cc_business_mgr_id HR_ORGANIZATION_INFORMATION.ATTRIBUTE2%TYPE := NULL;

Line 514: FUNCTION getCostCenterApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN VARCHAR2 IS

510: | - Return NULL means no post-chain-of-authority approval
511: | is required.
512: *----------------------------------------------------------------------------*/
513: -------------------------------------------------------------------------
514: FUNCTION getCostCenterApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN VARCHAR2 IS
515: -------------------------------------------------------------------------
516: l_debug_info VARCHAR2(200);
517: l_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
518: l_employee_id NUMBER;

Line 643: FUNCTION getTransactionRequestor(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN NUMBER

639: RETURNS
640: Return employee_id if the employee is Active i.e, Not suspended/terminated
641: Return employee's manager if the employee is inactive
642: *----------------------------------------------------------------------------*/
643: FUNCTION getTransactionRequestor(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN NUMBER
644: IS
645: -------------------------------------------------------------------------
646: l_debug_info VARCHAR2(200);
647: l_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;

Line 710: FUNCTION getDistCostCenterApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,

706: APP_EXCEPTION.RAISE_EXCEPTION;
707: END getAwardApprover;
708:
709: -------------------------------------------------------------------------
710: FUNCTION getDistCostCenterApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
711: p_cost_center IN VARCHAR2) RETURN NUMBER IS
712: -------------------------------------------------------------------------
713: l_debug_info VARCHAR2(200);
714: l_cost_center_manager_id NUMBER;