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.OE_APPROVALS_WF dependencies on WF_ROLES

Line 1353: l_orig_system wf_roles.orig_system%TYPE;

1349: l_application_id NUMBER := 660;
1350: --l_transaction_id VARCHAR2(100); --'232349';
1351: l_transaction_type_id VARCHAR2 (100); --'OENH';
1352: l_user_id VARCHAR2 (100);
1353: l_orig_system wf_roles.orig_system%TYPE;
1354: l_orig_system_id wf_roles.orig_system_id%TYPE;
1355: l_person_id NUMBER;
1356: l_item_key VARCHAR2 (100);
1357: -- used to get child item keys.

Line 1354: l_orig_system_id wf_roles.orig_system_id%TYPE;

1350: --l_transaction_id VARCHAR2(100); --'232349';
1351: l_transaction_type_id VARCHAR2 (100); --'OENH';
1352: l_user_id VARCHAR2 (100);
1353: l_orig_system wf_roles.orig_system%TYPE;
1354: l_orig_system_id wf_roles.orig_system_id%TYPE;
1355: l_person_id NUMBER;
1356: l_item_key VARCHAR2 (100);
1357: -- used to get child item keys.
1358: l_approver_sequence NUMBER := 0;

Line 2328: l_orig_system wf_roles.orig_system%TYPE;

2324: l_application_id NUMBER := 660;
2325: --l_transaction_id VARCHAR2(100); --'232349';
2326: l_transaction_type_id VARCHAR2 (100); --'OENH';
2327: l_user_id VARCHAR2 (100);
2328: l_orig_system wf_roles.orig_system%TYPE;
2329: l_orig_system_id wf_roles.orig_system_id%TYPE;
2330: l_person_id NUMBER;
2331: l_s_count NUMBER := 0;
2332: l_step VARCHAR2 (200);

Line 2329: l_orig_system_id wf_roles.orig_system_id%TYPE;

2325: --l_transaction_id VARCHAR2(100); --'232349';
2326: l_transaction_type_id VARCHAR2 (100); --'OENH';
2327: l_user_id VARCHAR2 (100);
2328: l_orig_system wf_roles.orig_system%TYPE;
2329: l_orig_system_id wf_roles.orig_system_id%TYPE;
2330: l_person_id NUMBER;
2331: l_s_count NUMBER := 0;
2332: l_step VARCHAR2 (200);
2333: xx_ame EXCEPTION;

Line 2654: l_orig_system wf_roles.orig_system%TYPE;

2650: l_application_id NUMBER := 660;
2651: --l_transaction_id VARCHAR2(100); --'232349';
2652: l_transaction_type_id VARCHAR2 (100); --'OENH';
2653: l_user_id VARCHAR2 (100);
2654: l_orig_system wf_roles.orig_system%TYPE;
2655: l_orig_system_id wf_roles.orig_system_id%TYPE;
2656: l_person_id NUMBER;
2657: l_s_count NUMBER := 0;
2658: l_step VARCHAR2 (200);

Line 2655: l_orig_system_id wf_roles.orig_system_id%TYPE;

2651: --l_transaction_id VARCHAR2(100); --'232349';
2652: l_transaction_type_id VARCHAR2 (100); --'OENH';
2653: l_user_id VARCHAR2 (100);
2654: l_orig_system wf_roles.orig_system%TYPE;
2655: l_orig_system_id wf_roles.orig_system_id%TYPE;
2656: l_person_id NUMBER;
2657: l_s_count NUMBER := 0;
2658: l_step VARCHAR2 (200);
2659: xx_ame EXCEPTION;