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_AUD_RULE_SETS

Line 80: from AP_AUD_RULE_SETS rs,

76: l_debug_info := 'Check if Notif Rules Setup';
77: ------------------------------------------------------------
78: select 'Y'
79: into l_is_notif_rule_setup
80: from AP_AUD_RULE_SETS rs,
81: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
82: where rsa.org_id = p_org_id
83: and rsa.rule_set_id = rs.rule_set_id
84: and rs.rule_set_type = C_NOTIFY_RULE

Line 524: l_notif_rule AP_AUD_RULE_SETS%ROWTYPE;

520: l_purpose AP_EXPENSE_REPORT_HEADERS.description%type;
521: l_report_submitted_date AP_EXPENSE_REPORT_HEADERS.report_submitted_date%type;
522: l_missing_img_just AP_EXPENSE_REPORT_HEADERS.missing_img_just%type;
523:
524: l_notif_rule AP_AUD_RULE_SETS%ROWTYPE;
525: l_is_notif_rule_setup varchar2(1) := 'N';
526:
527: BEGIN
528:

Line 2555: l_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_RCT_OVERDUE_DAYS%TYPE;

2551: l_report_header_id ap_expense_report_headers.report_header_id%TYPE;
2552: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2553: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2554: l_report_submit_date ap_expense_report_headers.report_submitted_date%TYPE;
2555: l_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_RCT_OVERDUE_DAYS%TYPE;
2556: l_image_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_IMG_RCT_OVERDUE_DAYS%TYPE;
2557:
2558: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2559: l_business_group_id hr_organization_units.business_group_id%TYPE;

Line 2556: l_image_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_IMG_RCT_OVERDUE_DAYS%TYPE;

2552: l_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2553: l_orig_receipts_status ap_expense_report_headers.receipts_status%TYPE;
2554: l_report_submit_date ap_expense_report_headers.report_submitted_date%TYPE;
2555: l_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_RCT_OVERDUE_DAYS%TYPE;
2556: l_image_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_IMG_RCT_OVERDUE_DAYS%TYPE;
2557:
2558: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2559: l_business_group_id hr_organization_units.business_group_id%TYPE;
2560: l_duration AP_AUD_RULE_SETS.audit_term_duration_days%TYPE;

Line 2560: l_duration AP_AUD_RULE_SETS.audit_term_duration_days%TYPE;

2556: l_image_rule_overdue_days AP_AUD_RULE_SETS.NOTIFY_IMG_RCT_OVERDUE_DAYS%TYPE;
2557:
2558: l_employee_id ap_expense_report_headers.employee_id%TYPE;
2559: l_business_group_id hr_organization_units.business_group_id%TYPE;
2560: l_duration AP_AUD_RULE_SETS.audit_term_duration_days%TYPE;
2561: l_emp_rec AP_WEB_AUDIT_LIST_PUB.Employee_Rec_Type;
2562: l_audit_rec AP_WEB_AUDIT_LIST_PUB.Audit_Rec_Type;
2563: l_auto_audit_id NUMBER;
2564: l_x_return_status VARCHAR2(1);

Line 2601: AP_AUD_RULE_SETS rs,

2597: aerh.report_submitted_date,
2598: rs.NOTIFY_RCT_OVERDUE_DAYS,
2599: rs.NOTIFY_IMG_RCT_OVERDUE_DAYS
2600: from AP_EXPENSE_REPORT_HEADERS aerh,
2601: AP_AUD_RULE_SETS rs,
2602: AP_AUD_RULE_ASSIGNMENTS rsa
2603: where (aerh.receipts_status in (C_REQUIRED, C_MISSING)
2604: OR decode(aerh.image_receipts_status, 'PENDING_IMAGE_SUBMISSION', C_REQUIRED, aerh.image_receipts_status) in (C_REQUIRED, C_MISSING))
2605: and aerh.bothpay_parent_id is null

Line 2665: AP_AUD_RULE_SETS rs,

2661: select aerh.report_header_id,
2662: aerh.receipts_status,
2663: 'ORIGINAL'
2664: from AP_EXPENSE_REPORT_HEADERS aerh,
2665: AP_AUD_RULE_SETS rs,
2666: AP_AUD_RULE_ASSIGNMENTS rsa
2667: where aerh.receipts_status in (C_REQUIRED, C_MISSING)
2668: and aerh.bothpay_parent_id is null
2669: and rsa.org_id = nvl(p_org_id, rsa.org_id)

Line 2693: AP_AUD_RULE_SETS rs,

2689: select aerh.report_header_id,
2690: aerh.image_receipts_status,
2691: 'IMAGE'
2692: from AP_EXPENSE_REPORT_HEADERS aerh,
2693: AP_AUD_RULE_SETS rs,
2694: AP_AUD_RULE_ASSIGNMENTS rsa
2695: where aerh.image_receipts_status in (C_REQUIRED, C_MISSING)
2696: and aerh.bothpay_parent_id is null
2697: and rsa.org_id = nvl(p_org_id, rsa.org_id)

Line 2728: AP_AUD_RULE_SETS rs,

2724: hr.business_group_id,
2725: max(rs.audit_term_duration_days)
2726: from AP_EXPENSE_REPORT_HEADERS aerh,
2727: hr_organization_units hr,
2728: AP_AUD_RULE_SETS rs,
2729: AP_AUD_RULE_ASSIGNMENTS rsa
2730: where aerh.org_id = nvl(p_org_id, aerh.org_id)
2731: and aerh.bothpay_parent_id is null
2732: and aerh.report_submitted_date is not null

Line 2995: l_receipt_rule AP_AUD_RULE_SETS%ROWTYPE;

2991: p_result OUT NOCOPY VARCHAR2) IS
2992: ------------------------------------------------------------------------
2993: l_org_id number;
2994: l_expense_report_id number;
2995: l_receipt_rule AP_AUD_RULE_SETS%ROWTYPE;
2996: l_report_submitted_date date;
2997: l_receipts_status VARCHAR2(50) := 'N';
2998: l_image_receipts_status VARCHAR2(50) := 'N';
2999: l_img_missing_event VARCHAR2(1) := 'N';

Line 3431: l_receipt_rule AP_AUD_RULE_SETS%ROWTYPE;

3427: p_result OUT NOCOPY VARCHAR2) IS
3428: ------------------------------------------------------------------------
3429: l_org_id number;
3430: l_expense_report_id number;
3431: l_receipt_rule AP_AUD_RULE_SETS%ROWTYPE;
3432: l_report_submitted_date date;
3433: l_receipts_status varchar2(30);
3434:
3435: BEGIN

Line 3486: l_receipt_rule AP_AUD_RULE_SETS%ROWTYPE;

3482: p_result OUT NOCOPY VARCHAR2) IS
3483: ------------------------------------------------------------------------
3484: l_org_id number;
3485: l_expense_report_id number;
3486: l_receipt_rule AP_AUD_RULE_SETS%ROWTYPE;
3487: l_report_submitted_date date;
3488: l_AMEEnabled VARCHAR2(1);
3489: l_item_key wf_items.item_key%TYPE;
3490: C_WF_Version NUMBER := 0;

Line 3598: l_receipt_rule AP_AUD_RULE_SETS%ROWTYPE;

3594: p_result OUT NOCOPY VARCHAR2) IS
3595: ------------------------------------------------------------------------
3596: l_org_id number;
3597: l_expense_report_id number;
3598: l_receipt_rule AP_AUD_RULE_SETS%ROWTYPE;
3599: l_report_submitted_date date;
3600: l_receipts_status VARCHAR2(30);
3601: l_image_receipts_status VARCHAR2(30);
3602: BEGIN