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 4714: l_du_prep_name fnd_user.user_name%TYPE;

4710:
4711: l_tu_id igi_exp_dus.tu_id%TYPE;
4712: l_du_id igi_exp_dus.du_id%TYPE;
4713: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;
4714: l_du_prep_name fnd_user.user_name%TYPE;
4715: l_no NUMBER := 0 ;
4716: l_du_rej_list VARCHAR2(28000);
4717:
4718: BEGIN

Line 4774: FROM fnd_user

4770:
4771: -- Get the name of the preparer to send the notification to
4772: SELECT user_name
4773: INTO l_du_prep_name
4774: FROM fnd_user
4775: WHERE user_id = l_du_prep_id;
4776:
4777: -- =============== START DEBUG LOG ================
4778: DEBUG_LOG_STRING (l_proc_level, 'Get_next_rejected_du.Msg6',

Line 5907: l_du_prep_name fnd_user.user_name%TYPE;

5903: funcmode IN VARCHAR2,
5904: result OUT NOCOPY VARCHAR2) IS
5905:
5906: l_tu_id igi_exp_dus.tu_id%TYPE;
5907: l_du_prep_name fnd_user.user_name%TYPE;
5908: l_du_id igi_exp_dus.du_id%TYPE;
5909:
5910: BEGIN
5911:

Line 5932: ,fnd.user_name

5928: -- =============== END DEBUG LOG ==================
5929:
5930: -- Get the next DU which has been approved and needs completing
5931: SELECT du.du_id
5932: ,fnd.user_name
5933: INTO l_du_id
5934: ,l_du_prep_name
5935: FROM igi_exp_dus du
5936: ,fnd_user fnd

Line 5936: ,fnd_user fnd

5932: ,fnd.user_name
5933: INTO l_du_id
5934: ,l_du_prep_name
5935: FROM igi_exp_dus du
5936: ,fnd_user fnd
5937: WHERE du.tu_id = l_tu_id
5938: AND du.du_status = 'ATR'
5939: AND du.du_by_user_id = fnd.user_id
5940: AND rownum = 1;

Line 5939: AND du.du_by_user_id = fnd.user_id

5935: FROM igi_exp_dus du
5936: ,fnd_user fnd
5937: WHERE du.tu_id = l_tu_id
5938: AND du.du_status = 'ATR'
5939: AND du.du_by_user_id = fnd.user_id
5940: AND rownum = 1;
5941:
5942: -- =============== START DEBUG LOG ================
5943: DEBUG_LOG_STRING (l_proc_level, 'Get_next_incomplete_du.Msg1',

Line 6975: l_next_prep_name fnd_user.user_name%TYPE;

6971:
6972: l_num NUMBER;
6973: l_prep_list VARCHAR2(1000);
6974: l_next_prep NUMBER;
6975: l_next_prep_name fnd_user.user_name%TYPE;
6976: l_tu_id igi_exp_dus.tu_id%TYPE;
6977:
6978: l_com_du_list VARCHAR2(28000);
6979:

Line 7055: FROM fnd_user

7051: -- =============== END DEBUG LOG ==================
7052:
7053: SELECT user_name
7054: INTO l_next_prep_name
7055: FROM fnd_user
7056: WHERE user_id = l_next_prep;
7057:
7058: -- =============== START DEBUG LOG ================
7059: DEBUG_LOG_STRING (l_proc_level, 'Get_next_prep.Msg7',

Line 7617: l_du_prep_name fnd_user.user_name%TYPE;

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

Line 7677: FROM fnd_user

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