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_DB_CCARD_PKG dependencies on AP_WEB_DB_EXPRPT_PKG

Line 1177: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,

1173: WHERE report_header_id IN (SELECT report_header_id
1174: FROM ap_expense_report_headers
1175: WHERE report_header_id = p_report_header_id
1176: AND workflow_approved_flag in
1177: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
1178: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
1179: --ER 1552747 - withdraw expense report
1180: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW));
1181:

Line 1178: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,

1174: FROM ap_expense_report_headers
1175: WHERE report_header_id = p_report_header_id
1176: AND workflow_approved_flag in
1177: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
1178: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
1179: --ER 1552747 - withdraw expense report
1180: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW));
1181:
1182: RETURN TRUE;

Line 1180: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW));

1176: AND workflow_approved_flag in
1177: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
1178: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
1179: --ER 1552747 - withdraw expense report
1180: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW));
1181:
1182: RETURN TRUE;
1183:
1184: EXCEPTION

Line 1235: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,

1231: WHERE cc.report_header_id IN (SELECT report_header_id erh_headerID
1232: FROM ap_expense_report_headers
1233: WHERE report_header_id = p_report_header_id
1234: AND workflow_approved_flag in
1235: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
1236: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
1237: --ER 1552747 - withdraw expense report
1238: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW))
1239: AND category = c_personal;

Line 1236: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,

1232: FROM ap_expense_report_headers
1233: WHERE report_header_id = p_report_header_id
1234: AND workflow_approved_flag in
1235: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
1236: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
1237: --ER 1552747 - withdraw expense report
1238: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW))
1239: AND category = c_personal;
1240:

Line 1238: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW))

1234: AND workflow_approved_flag in
1235: (AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_REJECTED,
1236: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_RETURNED,
1237: --ER 1552747 - withdraw expense report
1238: AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW))
1239: AND category = c_personal;
1240:
1241: RETURN TRUE;
1242: