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_AUD_RULE_SETS

Line 65: from AP_AUD_RULE_SETS rs,

61: l_debug_info := 'Check if Holds Rule Setup';
62: ------------------------------------------------------------
63: select 'Y'
64: into l_is_holds_rule_setup
65: from AP_AUD_RULE_SETS rs,
66: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
67: where rsa.org_id = p_org_id
68: and rsa.rule_set_id = rs.rule_set_id
69: and rs.rule_set_type = C_HOLD_RULE

Line 689: l_hold_code AP_AUD_RULE_SETS.hold_code%type;

685: ------------------------------------------------------------------------
686: l_debug_info VARCHAR2(200);
687:
688: l_is_holds_rule_setup VARCHAR2(1);
689: l_hold_code AP_AUD_RULE_SETS.hold_code%type;
690:
691: BEGIN
692:
693: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start GetHoldsScenario');

Line 700: from AP_AUD_RULE_SETS rs,

696: l_debug_info := 'Check if Holds Rule Setup';
697: ------------------------------------------------------------
698: select rs.hold_code
699: into l_hold_code
700: from AP_AUD_RULE_SETS rs,
701: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
702: where rsa.org_id = p_org_id
703: and rsa.rule_set_id = rs.rule_set_id
704: and rs.rule_set_type = C_HOLD_RULE

Line 743: l_holds_scenario AP_AUD_RULE_SETS.hold_code%type;

739:
740: l_org_id number;
741: l_report_submitted_date date;
742:
743: l_holds_scenario AP_AUD_RULE_SETS.hold_code%type;
744:
745: BEGIN
746:
747: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start GetHoldsScenario');

Line 1320: AP_AUD_RULE_SETS rs,

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)
1324: and aerh.bothpay_parent_id is null

Line 1627: l_hold_rct_overdue_days ap_aud_rule_sets.hold_rct_overdue_days%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: /*
1631: Criteria for this cursor is:

Line 1648: AP_AUD_RULE_SETS rs,

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)
1652: and aerh.bothpay_parent_id is null

Line 1965: l_hold_rct_overdue_bp_cc_code ap_aud_rule_sets.hold_rct_overdue_bp_cc_code%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:
1969: - source is 'SelfService' or 'Both Pay'

Line 1989: AP_AUD_RULE_SETS rs,

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)
1993: and aerh.bothpay_parent_id is not null

Line 2220: from AP_AUD_RULE_SETS rs,

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
2219: (select 1
2220: from AP_AUD_RULE_SETS rs,
2221: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
2222: where rsa.org_id = aerh.org_id
2223: and rsa.rule_set_id = rs.rule_set_id
2224: and rs.rule_set_type = C_HOLD_RULE

Line 2369: FROM AP_AUD_RULE_SETS rs,

2365: FUNCTION GetReceiptsRequired(p_report_date IN DATE, p_org_id IN NUMBER) RETURN VARCHAR2 IS
2366:
2367: CURSOR ReceiptRuleCur IS
2368: SELECT rs.*
2369: FROM AP_AUD_RULE_SETS rs,
2370: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
2371: WHERE rsa.org_id = p_org_id
2372: AND rsa.rule_set_id = rs.rule_set_id
2373: AND rs.rule_set_type = 'RECEIPT'