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 1101: l_expense_status_code ap_expense_report_headers.expense_status_code%type;

1097: p_holding_report_header_id IN NUMBER) IS
1098: ------------------------------------------------------------------------
1099: l_debug_info VARCHAR2(200);
1100:
1101: l_expense_status_code ap_expense_report_headers.expense_status_code%type;
1102:
1103: BEGIN
1104:
1105: ------------------------------------------------------------

Line 1111: from ap_expense_report_headers

1107: fnd_file.put_line(fnd_file.log, l_debug_info);
1108: ------------------------------------------------------------
1109: select expense_status_code
1110: into l_expense_status_code
1111: from ap_expense_report_headers
1112: where report_header_id = p_report_header_id
1113: for update of expense_status_code nowait;
1114:
1115: ------------------------------------------------------------

Line 1119: update ap_expense_report_headers

1115: ------------------------------------------------------------
1116: l_debug_info := 'Update current Expense Status to: '||p_expense_status_code||' for: '||p_report_header_id;
1117: fnd_file.put_line(fnd_file.log, l_debug_info);
1118: ------------------------------------------------------------
1119: update ap_expense_report_headers
1120: set expense_status_code = p_expense_status_code,
1121: holding_report_header_id = p_holding_report_header_id,
1122: expense_last_status_date = sysdate,
1123: request_id = fnd_global.conc_request_id

Line 1284: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

1280: ----------------------------------------------------------------------
1281:
1282: l_debug_info VARCHAR2(200);
1283:
1284: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1285: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1286: l_source ap_expense_report_headers.source%TYPE;
1287: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1288: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

Line 1285: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;

1281:
1282: l_debug_info VARCHAR2(200);
1283:
1284: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1285: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1286: l_source ap_expense_report_headers.source%TYPE;
1287: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1288: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1289:

Line 1286: l_source ap_expense_report_headers.source%TYPE;

1282: l_debug_info VARCHAR2(200);
1283:
1284: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1285: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1286: l_source ap_expense_report_headers.source%TYPE;
1287: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1288: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1289:
1290:

Line 1287: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

1283:
1284: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1285: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1286: l_source ap_expense_report_headers.source%TYPE;
1287: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1288: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1289:
1290:
1291: /*

Line 1288: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

1284: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1285: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1286: l_source ap_expense_report_headers.source%TYPE;
1287: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1288: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1289:
1290:
1291: /*
1292: Criteria for this cursor is:

Line 1306: from AP_EXPENSE_REPORT_HEADERS aerh,

1302: aerh.receipts_status,
1303: aerh.source,
1304: aerh.expense_status_code,
1305: aerh.holding_report_header_id
1306: from AP_EXPENSE_REPORT_HEADERS aerh,
1307: AP_AUD_RULE_SETS rs,
1308: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1309: where aerh.source = AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE
1310: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)

Line 1420: from AP_EXPENSE_REPORT_HEADERS aerh

1416: -- NOTE: need index on aerh.receipts_status/employee_id
1417: ------------------------------------------------------------
1418: CURSOR c_oldest_overdue_receipts IS
1419: select aerh.report_header_id
1420: from AP_EXPENSE_REPORT_HEADERS aerh
1421: where (aerh.source <> 'NonValidatedWebExpense' or aerh.workflow_approved_flag is null)
1422: and aerh.receipts_status is not null
1423: 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)
1424: and aerh.bothpay_parent_id is null

Line 1499: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;

1495: ----------------------------------------------------------------------
1496:
1497: l_debug_info VARCHAR2(200);
1498:
1499: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1500: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1501: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1502: l_source ap_expense_report_headers.source%TYPE;
1503: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

Line 1500: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

1496:
1497: l_debug_info VARCHAR2(200);
1498:
1499: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1500: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1501: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1502: l_source ap_expense_report_headers.source%TYPE;
1503: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1504: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

Line 1501: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;

1497: l_debug_info VARCHAR2(200);
1498:
1499: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1500: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1501: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1502: l_source ap_expense_report_headers.source%TYPE;
1503: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1504: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1505: l_employee_id ap_expense_report_headers.employee_id%TYPE;

Line 1502: l_source ap_expense_report_headers.source%TYPE;

1498:
1499: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1500: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1501: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1502: l_source ap_expense_report_headers.source%TYPE;
1503: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1504: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1505: l_employee_id ap_expense_report_headers.employee_id%TYPE;
1506: l_hold_rct_overdue_days ap_aud_rule_sets.hold_rct_overdue_days%TYPE;

Line 1503: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

1499: l_overdue_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1500: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1501: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1502: l_source ap_expense_report_headers.source%TYPE;
1503: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1504: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1505: l_employee_id ap_expense_report_headers.employee_id%TYPE;
1506: l_hold_rct_overdue_days ap_aud_rule_sets.hold_rct_overdue_days%TYPE;
1507:

Line 1504: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

1500: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1501: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1502: l_source ap_expense_report_headers.source%TYPE;
1503: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1504: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1505: l_employee_id ap_expense_report_headers.employee_id%TYPE;
1506: l_hold_rct_overdue_days ap_aud_rule_sets.hold_rct_overdue_days%TYPE;
1507:
1508:

Line 1505: l_employee_id ap_expense_report_headers.employee_id%TYPE;

1501: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1502: l_source ap_expense_report_headers.source%TYPE;
1503: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1504: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1505: l_employee_id ap_expense_report_headers.employee_id%TYPE;
1506: l_hold_rct_overdue_days ap_aud_rule_sets.hold_rct_overdue_days%TYPE;
1507:
1508:
1509: /*

Line 1526: from AP_EXPENSE_REPORT_HEADERS aerh,

1522: aerh.expense_status_code,
1523: aerh.holding_report_header_id,
1524: aerh.employee_id,
1525: rs.hold_rct_overdue_days
1526: from AP_EXPENSE_REPORT_HEADERS aerh,
1527: AP_AUD_RULE_SETS rs,
1528: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1529: where aerh.source = AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE
1530: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)

Line 1665: from AP_EXPENSE_REPORT_HEADERS aerh

1661: fnd_file.put_line(fnd_file.log, l_debug_info);
1662: ------------------------------------------------------------
1663: select 'Y'
1664: into l_is_cc_receipts_required
1665: from AP_EXPENSE_REPORT_HEADERS aerh
1666: where aerh.report_header_id = p_report_header_id
1667: and
1668: exists
1669: (select 1

Line 1749: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

1745: ------------------------------------------------------------------------
1746:
1747: l_debug_info VARCHAR2(200);
1748:
1749: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1750: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1751: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1752: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1753: l_source ap_expense_report_headers.source%TYPE;

Line 1750: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;

1746:
1747: l_debug_info VARCHAR2(200);
1748:
1749: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1750: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1751: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1752: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1753: l_source ap_expense_report_headers.source%TYPE;
1754: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

Line 1751: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;

1747: l_debug_info VARCHAR2(200);
1748:
1749: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1750: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1751: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1752: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1753: l_source ap_expense_report_headers.source%TYPE;
1754: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1755: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

Line 1752: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;

1748:
1749: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1750: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1751: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1752: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1753: l_source ap_expense_report_headers.source%TYPE;
1754: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1755: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1756: l_hold_rct_overdue_bp_cc_code ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%TYPE;

Line 1753: l_source ap_expense_report_headers.source%TYPE;

1749: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1750: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1751: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1752: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1753: l_source ap_expense_report_headers.source%TYPE;
1754: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1755: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1756: l_hold_rct_overdue_bp_cc_code ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%TYPE;
1757:

Line 1754: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

1750: l_bothpay_parent_id ap_expense_report_headers.bothpay_parent_id%TYPE;
1751: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1752: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1753: l_source ap_expense_report_headers.source%TYPE;
1754: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1755: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1756: l_hold_rct_overdue_bp_cc_code ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%TYPE;
1757:
1758: /*

Line 1755: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

1751: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1752: l_parent_status ap_expense_report_headers.expense_status_code%TYPE;
1753: l_source ap_expense_report_headers.source%TYPE;
1754: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1755: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1756: l_hold_rct_overdue_bp_cc_code ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%TYPE;
1757:
1758: /*
1759: Criteria for this cursor is:

Line 1777: from AP_EXPENSE_REPORT_HEADERS aerh,

1773: aerh.source,
1774: aerh.expense_status_code,
1775: aerh.holding_report_header_id,
1776: rs.hold_rct_overdue_bp_cc_code
1777: from AP_EXPENSE_REPORT_HEADERS aerh,
1778: AP_EXPENSE_REPORT_HEADERS aerh2,
1779: AP_AUD_RULE_SETS rs,
1780: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1781: where aerh.source in (AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE, AP_WEB_RECEIPTS_WF.C_BOTHPAY)

Line 1778: AP_EXPENSE_REPORT_HEADERS aerh2,

1774: aerh.expense_status_code,
1775: aerh.holding_report_header_id,
1776: rs.hold_rct_overdue_bp_cc_code
1777: from AP_EXPENSE_REPORT_HEADERS aerh,
1778: AP_EXPENSE_REPORT_HEADERS aerh2,
1779: AP_AUD_RULE_SETS rs,
1780: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1781: where aerh.source in (AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE, AP_WEB_RECEIPTS_WF.C_BOTHPAY)
1782: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)

Line 1956: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;

1952: ------------------------------------------------------------------------
1953:
1954: l_debug_info VARCHAR2(200);
1955:
1956: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1957: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1958: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1959: l_source ap_expense_report_headers.source%TYPE;
1960: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

Line 1957: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;

1953:
1954: l_debug_info VARCHAR2(200);
1955:
1956: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1957: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1958: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1959: l_source ap_expense_report_headers.source%TYPE;
1960: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1961:

Line 1958: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;

1954: l_debug_info VARCHAR2(200);
1955:
1956: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1957: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1958: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1959: l_source ap_expense_report_headers.source%TYPE;
1960: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1961:
1962:

Line 1959: l_source ap_expense_report_headers.source%TYPE;

1955:
1956: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1957: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1958: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1959: l_source ap_expense_report_headers.source%TYPE;
1960: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1961:
1962:
1963: /*

Line 1960: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;

1956: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
1957: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
1958: l_holding_report_header_id ap_expense_report_headers.holding_report_header_id%TYPE;
1959: l_source ap_expense_report_headers.source%TYPE;
1960: l_expense_status_code ap_expense_report_headers.expense_status_code%TYPE;
1961:
1962:
1963: /*
1964: Criteria for this cursor is:

Line 1976: from AP_EXPENSE_REPORT_HEADERS aerh

1972: CURSOR c_obsolete_holds IS
1973: select aerh.report_header_id,
1974: aerh.source,
1975: aerh.expense_status_code
1976: from AP_EXPENSE_REPORT_HEADERS aerh
1977: where aerh.source in (AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE, AP_WEB_RECEIPTS_WF.C_BOTHPAY)
1978: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)
1979: and
1980: not exists

Line 2005: from AP_EXPENSE_REPORT_HEADERS aerh

2001: ------------------------------------------------------------
2002: CURSOR c_obsolete_bothpay_holds IS
2003: select aerh.report_header_id,
2004: aerh.expense_status_code
2005: from AP_EXPENSE_REPORT_HEADERS aerh
2006: where aerh.source = AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE
2007: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)
2008: and aerh.bothpay_parent_id is null
2009: and

Line 2019: from ap_expense_report_headers aerh2

2015: and rownum = 1)
2016: and
2017: exists
2018: (select 1
2019: from ap_expense_report_headers aerh2
2020: where aerh2.bothpay_parent_id = aerh.report_header_id
2021: and aerh2.expense_status_code = AP_WEB_RECEIPTS_WF.C_INVOICED
2022: and rownum = 1);
2023: