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

Line 101: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;

97: l_debug_info VARCHAR2(200);
98:
99: l_org_id number;
100: l_expense_report_id number;
101: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
102:
103: l_is_notif_rule_setup VARCHAR2(1);
104:
105: BEGIN

Line 132: from ap_expense_report_headers

128: l_debug_info := 'Get Expense Report data';
129: ----------------------------------------------------------
130: select report_submitted_date
131: into l_report_submitted_date
132: from ap_expense_report_headers
133: where report_header_id = l_expense_report_id;
134:
135: ------------------------------------------------------------
136: l_debug_info := 'Check if Holds Rule Setup';

Line 344: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;

340: l_preparer_display_name wf_users.display_name%type;
341: l_employee_id number;
342: l_employee_name wf_users.name%type;
343: l_employee_display_name wf_users.display_name%type;
344: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
345: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
346: l_total varchar2(80);
347: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
348: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;

Line 345: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;

341: l_employee_id number;
342: l_employee_name wf_users.name%type;
343: l_employee_display_name wf_users.display_name%type;
344: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
345: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
346: l_total varchar2(80);
347: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
348: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
349: l_holding_report_header_id AP_EXPENSE_REPORT_HEADERS.holding_report_header_id%type;

Line 347: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;

343: l_employee_display_name wf_users.display_name%type;
344: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
345: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
346: l_total varchar2(80);
347: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
348: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
349: l_holding_report_header_id AP_EXPENSE_REPORT_HEADERS.holding_report_header_id%type;
350: l_holding_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
351:

Line 348: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;

344: l_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
345: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
346: l_total varchar2(80);
347: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
348: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
349: l_holding_report_header_id AP_EXPENSE_REPORT_HEADERS.holding_report_header_id%type;
350: l_holding_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
351:
352: BEGIN

Line 349: l_holding_report_header_id AP_EXPENSE_REPORT_HEADERS.holding_report_header_id%type;

345: l_cost_center AP_EXPENSE_REPORT_HEADERS.flex_concatenated%type;
346: l_total varchar2(80);
347: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
348: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
349: l_holding_report_header_id AP_EXPENSE_REPORT_HEADERS.holding_report_header_id%type;
350: l_holding_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
351:
352: BEGIN
353:

Line 350: l_holding_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;

346: l_total varchar2(80);
347: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
348: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
349: l_holding_report_header_id AP_EXPENSE_REPORT_HEADERS.holding_report_header_id%type;
350: l_holding_invoice_num AP_EXPENSE_REPORT_HEADERS.invoice_num%type;
351:
352: BEGIN
353:
354: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start Init');

Line 395: from ap_expense_report_headers

391: l_total,
392: l_purpose,
393: l_report_submitted_date,
394: l_holding_report_header_id
395: from ap_expense_report_headers
396: where report_header_id = l_expense_report_id;
397:
398: ----------------------------------------------------------
399: l_debug_info := 'Get Holding Expense Report data';

Line 405: from ap_expense_report_headers

401: if (l_holding_report_header_id is not null) then
402: begin
403: select invoice_num
404: into l_holding_invoice_num
405: from ap_expense_report_headers
406: where report_header_id = l_holding_report_header_id;
407:
408: exception
409: when no_data_found then

Line 662: from ap_expense_report_headers

658: l_debug_info := 'Any Holds Pending?';
659: ----------------------------------------------------------
660: select 'Y'
661: into l_any_holds_pending
662: from ap_expense_report_headers
663: where report_header_id <> holding_report_header_id
664: and holding_report_header_id = l_report_header_id
665: and rownum = 1;
666:

Line 831: l_holding_invoice_num ap_expense_report_headers.invoice_num%type;

827: l_debug_info VARCHAR2(200);
828:
829: l_fnd_message fnd_new_messages.message_name%type;
830: l_note_text varchar2(2000);
831: l_holding_invoice_num ap_expense_report_headers.invoice_num%type;
832:
833: l_orig_language_code ap_expense_params.note_language_code%type := null;
834: l_orig_language fnd_languages.nls_language%type := null;
835: l_new_language_code ap_expense_params.note_language_code%type := null;

Line 1107: l_expense_status_code ap_expense_report_headers.expense_status_code%type;

1103: p_holding_report_header_id IN NUMBER) IS
1104: ------------------------------------------------------------------------
1105: l_debug_info VARCHAR2(200);
1106:
1107: l_expense_status_code ap_expense_report_headers.expense_status_code%type;
1108:
1109: BEGIN
1110:
1111: ------------------------------------------------------------

Line 1117: from ap_expense_report_headers

1113: fnd_file.put_line(fnd_file.log, l_debug_info);
1114: ------------------------------------------------------------
1115: select expense_status_code
1116: into l_expense_status_code
1117: from ap_expense_report_headers
1118: where report_header_id = p_report_header_id
1119: for update of expense_status_code nowait;
1120:
1121: ------------------------------------------------------------

Line 1125: update ap_expense_report_headers

1121: ------------------------------------------------------------
1122: l_debug_info := 'Update current Expense Status to: '||p_expense_status_code||' for: '||p_report_header_id;
1123: fnd_file.put_line(fnd_file.log, l_debug_info);
1124: ------------------------------------------------------------
1125: update ap_expense_report_headers
1126: set expense_status_code = p_expense_status_code,
1127: holding_report_header_id = p_holding_report_header_id,
1128: expense_last_status_date = sysdate,
1129: request_id = fnd_global.conc_request_id

Line 1291: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

1287:
1288: l_debug_info VARCHAR2(200);
1289: l_receipts_required VARCHAR2(1);
1290:
1291: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1292: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1293: l_image_receipts_status ap_expense_report_headers.image_receipts_status%TYPE;
1294: l_source ap_expense_report_headers.source%TYPE;
1295: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

Line 1292: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;

1288: l_debug_info VARCHAR2(200);
1289: l_receipts_required VARCHAR2(1);
1290:
1291: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1292: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1293: l_image_receipts_status ap_expense_report_headers.image_receipts_status%TYPE;
1294: l_source ap_expense_report_headers.source%TYPE;
1295: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1296: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

Line 1293: l_image_receipts_status ap_expense_report_headers.image_receipts_status%TYPE;

1289: l_receipts_required VARCHAR2(1);
1290:
1291: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1292: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1293: l_image_receipts_status ap_expense_report_headers.image_receipts_status%TYPE;
1294: l_source ap_expense_report_headers.source%TYPE;
1295: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1296: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1297: l_report_submitted_date ap_expense_report_headers.report_submitted_date%TYPE;

Line 1294: l_source ap_expense_report_headers.source%TYPE;

1290:
1291: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1292: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1293: l_image_receipts_status ap_expense_report_headers.image_receipts_status%TYPE;
1294: l_source ap_expense_report_headers.source%TYPE;
1295: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1296: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1297: l_report_submitted_date ap_expense_report_headers.report_submitted_date%TYPE;
1298: l_org_id ap_expense_report_headers.org_id%TYPE;

Line 1295: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

1291: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1292: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1293: l_image_receipts_status ap_expense_report_headers.image_receipts_status%TYPE;
1294: l_source ap_expense_report_headers.source%TYPE;
1295: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1296: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1297: l_report_submitted_date ap_expense_report_headers.report_submitted_date%TYPE;
1298: l_org_id ap_expense_report_headers.org_id%TYPE;
1299:

Line 1296: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

1292: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1293: l_image_receipts_status ap_expense_report_headers.image_receipts_status%TYPE;
1294: l_source ap_expense_report_headers.source%TYPE;
1295: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1296: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1297: l_report_submitted_date ap_expense_report_headers.report_submitted_date%TYPE;
1298: l_org_id ap_expense_report_headers.org_id%TYPE;
1299:
1300:

Line 1297: l_report_submitted_date ap_expense_report_headers.report_submitted_date%TYPE;

1293: l_image_receipts_status ap_expense_report_headers.image_receipts_status%TYPE;
1294: l_source ap_expense_report_headers.source%TYPE;
1295: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1296: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1297: l_report_submitted_date ap_expense_report_headers.report_submitted_date%TYPE;
1298: l_org_id ap_expense_report_headers.org_id%TYPE;
1299:
1300:
1301: /*

Line 1298: l_org_id ap_expense_report_headers.org_id%TYPE;

1294: l_source ap_expense_report_headers.source%TYPE;
1295: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1296: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1297: l_report_submitted_date ap_expense_report_headers.report_submitted_date%TYPE;
1298: l_org_id ap_expense_report_headers.org_id%TYPE;
1299:
1300:
1301: /*
1302: Criteria for this cursor is:

Line 1319: from AP_EXPENSE_REPORT_HEADERS aerh,

1315: aerh.expense_status_code,
1316: aerh.holding_report_header_id,
1317: aerh.report_submitted_date,
1318: aerh.org_id
1319: from AP_EXPENSE_REPORT_HEADERS aerh,
1320: AP_AUD_RULE_SETS rs,
1321: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1322: where aerh.source = AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE
1323: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)

Line 1471: from AP_EXPENSE_REPORT_HEADERS aerh

1467: -- NOTE: need index on aerh.receipts_status/employee_id
1468: ------------------------------------------------------------
1469: CURSOR c_oldest_overdue_receipts IS
1470: select aerh.report_header_id
1471: from AP_EXPENSE_REPORT_HEADERS aerh
1472: where (aerh.source <> 'NonValidatedWebExpense' or aerh.workflow_approved_flag is null)
1473: and aerh.receipts_status is not null
1474: and aerh.receipts_status in (AP_WEB_RECEIPTS_WF.C_REQUIRED, AP_WEB_RECEIPTS_WF.C_MISSING, AP_WEB_RECEIPTS_WF.C_OVERDUE, AP_WEB_RECEIPTS_WF.C_IN_TRANSIT, AP_WEB_RECEIPTS_WF.C_RESOLUTN)
1475: -- and aerh.expense_status_code not in (AP_WEB_RECEIPTS_WF.C_INVOICED, AP_WEB_RECEIPTS_WF.C_PARPAID, AP_WEB_RECEIPTS_WF.C_PAID)

Line 1536: from AP_EXPENSE_REPORT_HEADERS aerh

1532: -- NOTE: need index on aerh.receipts_status/employee_id
1533: ------------------------------------------------------------
1534: CURSOR c_oldest_overdue_receipts IS
1535: select aerh.report_header_id
1536: from AP_EXPENSE_REPORT_HEADERS aerh
1537: where (aerh.source <> 'NonValidatedWebExpense' or aerh.workflow_approved_flag is null)
1538: and aerh.image_receipts_status is not null
1539: and aerh.image_receipts_status in (AP_WEB_RECEIPTS_WF.C_REQUIRED, AP_WEB_RECEIPTS_WF.C_MISSING, AP_WEB_RECEIPTS_WF.C_OVERDUE, AP_WEB_RECEIPTS_WF.C_IN_TRANSIT, AP_WEB_RECEIPTS_WF.C_RESOLUTN)
1540: -- and aerh.expense_status_code not in (AP_WEB_RECEIPTS_WF.C_INVOICED, AP_WEB_RECEIPTS_WF.C_PARPAID, AP_WEB_RECEIPTS_WF.C_PAID)

Line 1619: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;

1615: ----------------------------------------------------------------------
1616:
1617: l_debug_info VARCHAR2(200);
1618:
1619: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1620: l_overdue_img_report_hdr_id ap_expense_report_headers.report_header_id%TYPE;
1621: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1622: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1623: l_source ap_expense_report_headers.source%TYPE;

Line 1620: l_overdue_img_report_hdr_id ap_expense_report_headers.report_header_id%TYPE;

1616:
1617: l_debug_info VARCHAR2(200);
1618:
1619: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1620: l_overdue_img_report_hdr_id ap_expense_report_headers.report_header_id%TYPE;
1621: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1622: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1623: l_source ap_expense_report_headers.source%TYPE;
1624: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

Line 1621: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

1617: l_debug_info VARCHAR2(200);
1618:
1619: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1620: l_overdue_img_report_hdr_id ap_expense_report_headers.report_header_id%TYPE;
1621: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1622: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1623: l_source ap_expense_report_headers.source%TYPE;
1624: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1625: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

Line 1622: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;

1618:
1619: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1620: l_overdue_img_report_hdr_id ap_expense_report_headers.report_header_id%TYPE;
1621: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1622: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1623: l_source ap_expense_report_headers.source%TYPE;
1624: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1625: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1626: l_employee_id ap_expense_report_headers.employee_id%TYPE;

Line 1623: l_source ap_expense_report_headers.source%TYPE;

1619: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1620: l_overdue_img_report_hdr_id ap_expense_report_headers.report_header_id%TYPE;
1621: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1622: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1623: l_source ap_expense_report_headers.source%TYPE;
1624: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1625: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1626: l_employee_id ap_expense_report_headers.employee_id%TYPE;
1627: l_hold_rct_overdue_days ap_aud_rule_sets.hold_rct_overdue_days%TYPE;

Line 1624: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

1620: l_overdue_img_report_hdr_id ap_expense_report_headers.report_header_id%TYPE;
1621: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1622: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1623: l_source ap_expense_report_headers.source%TYPE;
1624: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1625: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1626: l_employee_id ap_expense_report_headers.employee_id%TYPE;
1627: l_hold_rct_overdue_days ap_aud_rule_sets.hold_rct_overdue_days%TYPE;
1628:

Line 1625: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

1621: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1622: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1623: l_source ap_expense_report_headers.source%TYPE;
1624: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1625: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1626: l_employee_id ap_expense_report_headers.employee_id%TYPE;
1627: l_hold_rct_overdue_days ap_aud_rule_sets.hold_rct_overdue_days%TYPE;
1628:
1629:

Line 1626: l_employee_id ap_expense_report_headers.employee_id%TYPE;

1622: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1623: l_source ap_expense_report_headers.source%TYPE;
1624: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1625: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1626: l_employee_id ap_expense_report_headers.employee_id%TYPE;
1627: l_hold_rct_overdue_days ap_aud_rule_sets.hold_rct_overdue_days%TYPE;
1628:
1629:
1630: /*

Line 1647: from AP_EXPENSE_REPORT_HEADERS aerh,

1643: aerh.expense_status_code,
1644: aerh.holding_report_header_id,
1645: aerh.employee_id,
1646: rs.hold_rct_overdue_days
1647: from AP_EXPENSE_REPORT_HEADERS aerh,
1648: AP_AUD_RULE_SETS rs,
1649: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1650: where aerh.source = AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE
1651: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)

Line 1820: from AP_EXPENSE_REPORT_HEADERS aerh

1816: fnd_file.put_line(fnd_file.log, l_debug_info);
1817: ------------------------------------------------------------
1818: select 'Y'
1819: into l_is_cc_receipts_required
1820: from AP_EXPENSE_REPORT_HEADERS aerh
1821: where aerh.report_header_id = p_report_header_id
1822: and
1823: exists
1824: (select 1

Line 1873: from AP_EXPENSE_REPORT_HEADERS aerh

1869: fnd_file.put_line(fnd_file.log, l_debug_info);
1870: ------------------------------------------------------------
1871: select 'Y'
1872: into l_is_cc_receipts_required
1873: from AP_EXPENSE_REPORT_HEADERS aerh
1874: where aerh.report_header_id = p_report_header_id
1875: and
1876: exists
1877: (select 1

Line 1957: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

1953: ------------------------------------------------------------------------
1954:
1955: l_debug_info VARCHAR2(200);
1956:
1957: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1958: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1959: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1960: l_image_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1961: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;

Line 1958: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;

1954:
1955: l_debug_info VARCHAR2(200);
1956:
1957: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1958: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1959: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1960: l_image_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1961: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1962: l_source ap_expense_report_headers.source%TYPE;

Line 1959: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;

1955: l_debug_info VARCHAR2(200);
1956:
1957: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1958: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1959: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1960: l_image_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1961: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1962: l_source ap_expense_report_headers.source%TYPE;
1963: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

Line 1960: l_image_receipts_status ap_expense_report_headers.receipts_status%TYPE;

1956:
1957: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1958: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1959: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1960: l_image_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1961: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1962: l_source ap_expense_report_headers.source%TYPE;
1963: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1964: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

Line 1961: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;

1957: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1958: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1959: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1960: l_image_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1961: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1962: l_source ap_expense_report_headers.source%TYPE;
1963: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1964: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1965: l_hold_rct_overdue_bp_cc_code ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%TYPE;

Line 1962: l_source ap_expense_report_headers.source%TYPE;

1958: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1959: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1960: l_image_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1961: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1962: l_source ap_expense_report_headers.source%TYPE;
1963: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1964: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1965: l_hold_rct_overdue_bp_cc_code ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%TYPE;
1966:

Line 1963: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

1959: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1960: l_image_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1961: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1962: l_source ap_expense_report_headers.source%TYPE;
1963: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1964: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1965: l_hold_rct_overdue_bp_cc_code ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%TYPE;
1966:
1967: /*

Line 1964: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

1960: l_image_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1961: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1962: l_source ap_expense_report_headers.source%TYPE;
1963: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1964: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1965: l_hold_rct_overdue_bp_cc_code ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%TYPE;
1966:
1967: /*
1968: Criteria for this cursor is:

Line 1987: from AP_EXPENSE_REPORT_HEADERS aerh,

1983: aerh.source,
1984: aerh.expense_status_code,
1985: aerh.holding_report_header_id,
1986: rs.hold_rct_overdue_bp_cc_code
1987: from AP_EXPENSE_REPORT_HEADERS aerh,
1988: AP_EXPENSE_REPORT_HEADERS aerh2,
1989: AP_AUD_RULE_SETS rs,
1990: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1991: where aerh.source in (AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE, AP_WEB_RECEIPTS_WF.C_BOTHPAY)

Line 1988: AP_EXPENSE_REPORT_HEADERS aerh2,

1984: aerh.expense_status_code,
1985: aerh.holding_report_header_id,
1986: rs.hold_rct_overdue_bp_cc_code
1987: from AP_EXPENSE_REPORT_HEADERS aerh,
1988: AP_EXPENSE_REPORT_HEADERS aerh2,
1989: AP_AUD_RULE_SETS rs,
1990: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1991: where aerh.source in (AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE, AP_WEB_RECEIPTS_WF.C_BOTHPAY)
1992: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)

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_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
2197: l_source ap_expense_report_headers.source%TYPE;
2198: l_expense_status_code ap_expense_report_headers.expense_status_code%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_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
2197: l_source ap_expense_report_headers.source%TYPE;
2198: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
2199:

Line 2196: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%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_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
2197: l_source ap_expense_report_headers.source%TYPE;
2198: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
2199:
2200:

Line 2197: l_source ap_expense_report_headers.source%TYPE;

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_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
2197: l_source ap_expense_report_headers.source%TYPE;
2198: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
2199:
2200:
2201: /*

Line 2198: l_expense_status_code ap_expense_report_headers.expense_status_code%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_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
2197: l_source ap_expense_report_headers.source%TYPE;
2198: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
2199:
2200:
2201: /*
2202: Criteria for this cursor is:

Line 2214: from AP_EXPENSE_REPORT_HEADERS aerh

2210: CURSOR c_obsolete_holds IS
2211: select aerh.report_header_id,
2212: aerh.source,
2213: aerh.expense_status_code
2214: from AP_EXPENSE_REPORT_HEADERS aerh
2215: where aerh.source in (AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE, AP_WEB_RECEIPTS_WF.C_BOTHPAY)
2216: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)
2217: and
2218: not exists

Line 2243: from AP_EXPENSE_REPORT_HEADERS aerh

2239: ------------------------------------------------------------
2240: CURSOR c_obsolete_bothpay_holds IS
2241: select aerh.report_header_id,
2242: aerh.expense_status_code
2243: from AP_EXPENSE_REPORT_HEADERS aerh
2244: where aerh.source = AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE
2245: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)
2246: and aerh.bothpay_parent_id is null
2247: and

Line 2257: from ap_expense_report_headers aerh2

2253: and rownum = 1)
2254: and
2255: exists
2256: (select 1
2257: from ap_expense_report_headers aerh2
2258: where aerh2.bothpay_parent_id = aerh.report_header_id
2259: and aerh2.expense_status_code = AP_WEB_RECEIPTS_WF.C_INVOICED
2260: and rownum = 1);
2261: