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.IGI_EXP_APPROVAL_PKG dependencies on FND_USER

Line 1088: -- Get the fnd user id of the TU transmitter

1084: -- =============== END DEBUG LOG ==================
1085:
1086: IF (funcmode = 'RUN') THEN
1087:
1088: -- Get the fnd user id of the TU transmitter
1089: l_transmitter_fnd_id
1090: := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1091: itemkey => itemkey,
1092: aname => 'TRANSMITTER_FND_ID');

Line 1102: FROM fnd_user

1098:
1099: -- Get the employee id of the transmitter
1100: SELECT employee_id
1101: INTO l_transmitter_emp_id
1102: FROM fnd_user
1103: WHERE user_id = l_transmitter_fnd_id;
1104:
1105: -- =============== START DEBUG LOG ================
1106: DEBUG_LOG_STRING (l_proc_level, 'Is_tu_trans_employee.Msg3',

Line 2165: l_user_name fnd_user.user_name%TYPE;

2161: result OUT NOCOPY VARCHAR2) IS
2162:
2163: l_user_count NUMBER:= 0;
2164: l_user_list VARCHAR2(1000);
2165: l_user_name fnd_user.user_name%TYPE;
2166: l_user_id fnd_user.user_id%TYPE;
2167: l_tu_id igi_exp_tus.tu_id%TYPE;
2168: l_current_position_id per_all_positions.position_id%TYPE;
2169: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

Line 2166: l_user_id fnd_user.user_id%TYPE;

2162:
2163: l_user_count NUMBER:= 0;
2164: l_user_list VARCHAR2(1000);
2165: l_user_name fnd_user.user_name%TYPE;
2166: l_user_id fnd_user.user_id%TYPE;
2167: l_tu_id igi_exp_tus.tu_id%TYPE;
2168: l_current_position_id per_all_positions.position_id%TYPE;
2169: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2170: l_organization_id hr_all_positions_f.organization_id%TYPE;

Line 2180: fnd_user fu

2176: SELECT fu.user_name
2177: FROM hr_all_positions_f hap,
2178: per_all_assignments_f paa,
2179: per_employees_current_x pec,
2180: fnd_user fu
2181: WHERE fu.start_date <= SYSDATE
2182: AND NVL(fu.end_date,SYSDATE) >= SYSDATE
2183: AND fu.employee_id IS NOT NULL
2184: AND fu.employee_id = pec.employee_id

Line 2319: FROM fnd_user

2315: -- Need to update the TU table with the next authorizer of the TU
2316: -- So firstly get the user_id of the current authorizer
2317: SELECT user_id
2318: INTO l_user_id
2319: FROM fnd_user
2320: WHERE user_name = l_user_name;
2321:
2322:
2323: -- =============== START DEBUG LOG ================

Line 2681: l_auth_id fnd_user.user_id%TYPE;

2677: funcmode IN VARCHAR2,
2678: result OUT NOCOPY VARCHAR2) IS
2679:
2680: l_current_auth_role VARCHAR2(240);
2681: l_auth_id fnd_user.user_id%TYPE;
2682: l_tu_id igi_exp_tus.tu_id%TYPE;
2683:
2684: BEGIN
2685:

Line 2719: FROM fnd_user

2715:
2716: -- Get the user_id of the authorizer
2717: SELECT user_id
2718: INTO l_auth_id
2719: FROM fnd_user
2720: WHERE user_name = l_current_auth_role;
2721:
2722: -- =============== START DEBUG LOG ================
2723: DEBUG_LOG_STRING (l_proc_level, 'Set_chosen_user_as_auth.Msg4',

Line 3398: l_prev_authorizer fnd_user.user_name%TYPE;

3394: l_authorizer_history_list VARCHAR2(1000);
3395: l_new_auth_history_list VARCHAR2(1000);
3396: l_num1 NUMBER;
3397: l_num2 NUMBER;
3398: l_prev_authorizer fnd_user.user_name%TYPE;
3399:
3400: e_no_prev_auth EXCEPTION;
3401:
3402: BEGIN

Line 4100: l_du_prep_name fnd_user.user_name%TYPE;

4096:
4097: l_tu_id igi_exp_dus.tu_id%TYPE;
4098: l_du_id igi_exp_dus.du_id%TYPE;
4099: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4100: l_du_prep_name fnd_user.user_name%TYPE;
4101: l_du_by_prep_list VARCHAR2(28000);
4102:
4103: BEGIN
4104:

Line 4156: FROM fnd_user

4152:
4153: -- Get the name of the preparer to send the notification to
4154: SELECT user_name
4155: INTO l_du_prep_name
4156: FROM fnd_user
4157: WHERE user_id = l_du_prep_id;
4158:
4159: -- =============== START DEBUG LOG ================
4160: DEBUG_LOG_STRING (l_proc_level, 'Get_next_du_on_hold.Msg6',

Line 4721: l_du_prep_name fnd_user.user_name%TYPE;

4717:
4718: l_tu_id igi_exp_dus.tu_id%TYPE;
4719: l_du_id igi_exp_dus.du_id%TYPE;
4720: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4721: l_du_prep_name fnd_user.user_name%TYPE;
4722: l_no NUMBER := 0 ;
4723: l_du_rej_list VARCHAR2(28000);
4724:
4725: BEGIN

Line 4781: FROM fnd_user

4777:
4778: -- Get the name of the preparer to send the notification to
4779: SELECT user_name
4780: INTO l_du_prep_name
4781: FROM fnd_user
4782: WHERE user_id = l_du_prep_id;
4783:
4784: -- =============== START DEBUG LOG ================
4785: DEBUG_LOG_STRING (l_proc_level, 'Get_next_rejected_du.Msg6',

Line 5914: l_du_prep_name fnd_user.user_name%TYPE;

5910: funcmode IN VARCHAR2,
5911: result OUT NOCOPY VARCHAR2) IS
5912:
5913: l_tu_id igi_exp_dus.tu_id%TYPE;
5914: l_du_prep_name fnd_user.user_name%TYPE;
5915: l_du_id igi_exp_dus.du_id%TYPE;
5916:
5917: BEGIN
5918:

Line 5939: ,fnd.user_name

5935: -- =============== END DEBUG LOG ==================
5936:
5937: -- Get the next DU which has been approved and needs completing
5938: SELECT du.du_id
5939: ,fnd.user_name
5940: INTO l_du_id
5941: ,l_du_prep_name
5942: FROM igi_exp_dus du
5943: ,fnd_user fnd

Line 5943: ,fnd_user fnd

5939: ,fnd.user_name
5940: INTO l_du_id
5941: ,l_du_prep_name
5942: FROM igi_exp_dus du
5943: ,fnd_user fnd
5944: WHERE du.tu_id = l_tu_id
5945: AND du.du_status = 'ATR'
5946: AND du.du_by_user_id = fnd.user_id
5947: AND rownum = 1;

Line 5946: AND du.du_by_user_id = fnd.user_id

5942: FROM igi_exp_dus du
5943: ,fnd_user fnd
5944: WHERE du.tu_id = l_tu_id
5945: AND du.du_status = 'ATR'
5946: AND du.du_by_user_id = fnd.user_id
5947: AND rownum = 1;
5948:
5949: -- =============== START DEBUG LOG ================
5950: DEBUG_LOG_STRING (l_proc_level, 'Get_next_incomplete_du.Msg1',

Line 6982: l_next_prep_name fnd_user.user_name%TYPE;

6978:
6979: l_num NUMBER;
6980: l_prep_list VARCHAR2(1000);
6981: l_next_prep NUMBER;
6982: l_next_prep_name fnd_user.user_name%TYPE;
6983: l_tu_id igi_exp_dus.tu_id%TYPE;
6984:
6985: l_com_du_list VARCHAR2(28000);
6986:

Line 7062: FROM fnd_user

7058: -- =============== END DEBUG LOG ==================
7059:
7060: SELECT user_name
7061: INTO l_next_prep_name
7062: FROM fnd_user
7063: WHERE user_id = l_next_prep;
7064:
7065: -- =============== START DEBUG LOG ================
7066: DEBUG_LOG_STRING (l_proc_level, 'Get_next_prep.Msg7',

Line 7620: l_du_prep_name fnd_user.user_name%TYPE;

7616:
7617: l_tu_id igi_exp_dus.tu_id%TYPE;
7618: l_du_id igi_exp_dus.du_id%TYPE;
7619: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
7620: l_du_prep_name fnd_user.user_name%TYPE;
7621:
7622: l_du_rej_list VARCHAR2(28000);
7623:
7624:

Line 7680: FROM fnd_user

7676:
7677: -- Get the name of the preparer to send the notification to
7678: SELECT user_name
7679: INTO l_du_prep_name
7680: FROM fnd_user
7681: WHERE user_id = l_du_prep_id;
7682:
7683: -- =============== START DEBUG LOG ================
7684: DEBUG_LOG_STRING (l_proc_level, 'Get_next_rejected_legal_du.Msg6',