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_RECEIPTS_WF dependencies on AP_EXPENSE_REPORT_HEADERS

Line 107: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;

103: l_debug_info VARCHAR2(200);
104:
105: l_org_id number;
106: l_expense_report_id number;
107: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
108:
109: l_is_notif_rule_setup VARCHAR2(1);
110:
111: BEGIN

Line 138: from ap_expense_report_headers_all

134: l_debug_info := 'Get Expense Report data';
135: ----------------------------------------------------------
136: select report_submitted_date
137: into l_report_submitted_date
138: from ap_expense_report_headers_all
139: where report_header_id = l_expense_report_id;
140:
141: ------------------------------------------------------------
142: l_debug_info := 'Check if Notif Rules Setup';

Line 357: update ap_expense_report_headers_all

353: ----------------------------------------------------------
354: l_debug_info := 'Update Receipts Status if not Received or Waived';
355: ----------------------------------------------------------
356: begin
357: update ap_expense_report_headers_all
358: set receipts_status = ''
359: where report_header_id = p_expense_report_id
360: and nvl(receipts_status, AP_WEB_RECEIPTS_WF.C_NOT_REQUIRED) not in (AP_WEB_RECEIPTS_WF.C_RECEIVED, AP_WEB_RECEIPTS_WF.C_RECEIVED_RESUBMITTED, AP_WEB_RECEIPTS_WF.C_WAIVED)
361: and receipts_received_date is null;

Line 371: update ap_expense_report_headers_all

367: l_debug_info := 'Reset Held Reports';
368: ----------------------------------------------------------
369: -- Bug 4075804
370: begin
371: update ap_expense_report_headers_all
372: set expense_status_code = C_PENDING_HOLDS,
373: holding_report_header_id = null,
374: expense_last_status_date = sysdate
375: where holding_report_header_id = p_expense_report_id

Line 460: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;

456: l_preparer_display_name wf_users.display_name%type;
457: l_employee_id number;
458: l_employee_name wf_users.name%type;
459: l_employee_display_name wf_users.display_name%type;
460: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
461: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
462: l_total varchar2(80);
463: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
464: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;

Line 461: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;

457: l_employee_id number;
458: l_employee_name wf_users.name%type;
459: l_employee_display_name wf_users.display_name%type;
460: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
461: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
462: l_total varchar2(80);
463: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
464: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
465:

Line 463: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;

459: l_employee_display_name wf_users.display_name%type;
460: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
461: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
462: l_total varchar2(80);
463: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
464: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
465:
466: l_notif_rule AP_AUD_RULE_SETS%ROWTYPE;
467: l_is_notif_rule_setup varchar2(1) := 'N';

Line 464: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;

460: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
461: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
462: l_total varchar2(80);
463: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
464: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
465:
466: l_notif_rule AP_AUD_RULE_SETS%ROWTYPE;
467: l_is_notif_rule_setup varchar2(1) := 'N';
468:

Line 510: from ap_expense_report_headers_all

506: l_cost_center,
507: l_total,
508: l_purpose,
509: l_report_submitted_date
510: from ap_expense_report_headers_all
511: where report_header_id = l_expense_report_id;
512:
513: ----------------------------------------------------------
514: l_debug_info := 'Get Preparer Id using Created By';

Line 1155: from ap_expense_report_headers_all

1151: l_debug_info := 'Retrieve current Receipt Status';
1152: ------------------------------------------------------------
1153: select receipts_status
1154: into l_receipts_status
1155: from ap_expense_report_headers_all
1156: where report_header_id = p_report_header_id;
1157:
1158: return l_receipts_status;
1159:

Line 1233: from ap_expense_report_headers_all

1229: l_debug_info := 'Lock current Receipt Status';
1230: ------------------------------------------------------------
1231: select receipts_status
1232: into l_orig_receipts_status
1233: from ap_expense_report_headers_all
1234: where report_header_id = p_report_header_id
1235: for update of receipts_status nowait;
1236:
1237: ------------------------------------------------------------

Line 1240: update ap_expense_report_headers_all

1236:
1237: ------------------------------------------------------------
1238: l_debug_info := 'Update current Receipt Status';
1239: ------------------------------------------------------------
1240: update ap_expense_report_headers_all
1241: set receipts_status = p_receipts_status
1242: where report_header_id = p_report_header_id;
1243:
1244: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end SetReceiptsStatus');

Line 1583: from ap_expense_report_headers_all aerh,

1579: l_debug_info := 'Check if Missing or Policy Shortpay';
1580: ------------------------------------------------------------
1581: select 'Y'
1582: into l_is_shortpay
1583: from ap_expense_report_headers_all aerh,
1584: wf_items wf
1585: where aerh.report_header_id = l_report_header_id
1586: and aerh.shortpay_parent_id is not null
1587: and wf.item_type = C_APEXP

Line 1941: from ap_expense_report_headers_all

1937: -- bug 6361555
1938: begin
1939: select created_by
1940: into l_created_by
1941: from ap_expense_report_headers_all
1942: where report_header_id = l_report_header_id;
1943: exception
1944: when others then
1945: null;

Line 2194: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

2190: ----------------------------------------------------------------------
2191:
2192: l_debug_info VARCHAR2(200);
2193:
2194: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
2195: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2196: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2197:
2198: l_employee_id ap_expense_report_headers.employee_id%TYPE;

Line 2195: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;

2191:
2192: l_debug_info VARCHAR2(200);
2193:
2194: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
2195: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2196: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2197:
2198: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2199: l_business_group_id hr_organization_units.business_group_id%TYPE;

Line 2196: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;

2192: l_debug_info VARCHAR2(200);
2193:
2194: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
2195: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2196: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2197:
2198: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2199: l_business_group_id hr_organization_units.business_group_id%TYPE;
2200: l_duration AP_AUD_RULE_SETS.audit_term_duration_days%TYPE;

Line 2198: l_employee_id ap_expense_report_headers.employee_id%TYPE;

2194: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
2195: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2196: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2197:
2198: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2199: l_business_group_id hr_organization_units.business_group_id%TYPE;
2200: l_duration AP_AUD_RULE_SETS.audit_term_duration_days%TYPE;
2201: l_emp_rec AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type;
2202: l_audit_rec AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type;

Line 2224: from AP_EXPENSE_REPORT_HEADERS aerh,

2220: -- cursor for overdue required/missing receipts
2221: CURSOR c_overdue_receipts IS
2222: select aerh.report_header_id,
2223: aerh.receipts_status
2224: from AP_EXPENSE_REPORT_HEADERS aerh,
2225: AP_AUD_RULE_SETS rs,
2226: AP_AUD_RULE_ASSIGNMENTS rsa
2227: where aerh.receipts_status in (C_REQUIRED, C_MISSING)
2228: and aerh.bothpay_parent_id is null

Line 2258: from AP_EXPENSE_REPORT_HEADERS aerh,

2254: CURSOR c_audit_list_receipts IS
2255: select aerh.employee_id,
2256: hr.business_group_id,
2257: max(rs.audit_term_duration_days)
2258: from AP_EXPENSE_REPORT_HEADERS aerh,
2259: hr_organization_units hr,
2260: AP_AUD_RULE_SETS rs,
2261: AP_AUD_RULE_ASSIGNMENTS rsa
2262: where aerh.org_id = nvl(p_org_id, aerh.org_id)