APPS.AP_WEB_RECEIPTS_WF dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

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 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;