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_ITR_APPROVAL_PKG dependencies on FND_USER

Line 66: p_preparer_fnd_user_id IN NUMBER,

62: -- Start_Approval_Workflow
63: -- ****************************************************************************
64: PROCEDURE start_approval_workflow (p_cc_id IN NUMBER,
65: p_cc_line_num IN NUMBER,
66: p_preparer_fnd_user_id IN NUMBER,
67: p_cc_name IN VARCHAR2,
68: p_prep_auth IN VARCHAR2,
69: p_sec_apprv_fnd_id IN NUMBER) IS
70:

Line 159: FROM fnd_user

155:
156: -- Get employee ID
157: SELECT employee_id
158: INTO l_preparer_id
159: FROM fnd_user
160: WHERE user_id = p_preparer_fnd_user_id;
161:
162: -- Set PersonID attribute (HR personID from PER_PERSONS_F)
163: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

Line 160: WHERE user_id = p_preparer_fnd_user_id;

156: -- Get employee ID
157: SELECT employee_id
158: INTO l_preparer_id
159: FROM fnd_user
160: WHERE user_id = p_preparer_fnd_user_id;
161:
162: -- Set PersonID attribute (HR personID from PER_PERSONS_F)
163: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
164: itemkey => l_itemkey,

Line 169: -- Set UserID attribute (AOL userID from FND_USER table).

165: aname => 'PREPARER_ID',
166: avalue => l_preparer_id);
167: diagn_msg(l_state_level,'start_approval_workflow','Attribute PREPARER_ID set to ' ||l_preparer_id );
168:
169: -- Set UserID attribute (AOL userID from FND_USER table).
170: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
171: itemkey => l_itemkey,
172: aname => 'PREPARER_FND_ID',
173: avalue => p_preparer_fnd_user_id);

Line 173: avalue => p_preparer_fnd_user_id);

169: -- Set UserID attribute (AOL userID from FND_USER table).
170: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
171: itemkey => l_itemkey,
172: aname => 'PREPARER_FND_ID',
173: avalue => p_preparer_fnd_user_id);
174:
175: -- Retrieve preparer's User name (Login name for Apps) and displayed name
176: wf_directory.GetUserName(p_orig_system => 'PER',
177: p_orig_system_id => l_preparer_id,

Line 209: FROM fnd_user

205:
206: -- Get employee ID of secondary approver
207: SELECT employee_id
208: INTO l_sec_approver_id
209: FROM fnd_user
210: WHERE user_id = p_sec_apprv_fnd_id;
211:
212: -- Set PersonID attribute (HR personID from PER_PERSONS_F)
213: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

Line 219: -- Set UserID attribute (AOL userID from FND_USER table).

215: aname => 'SEC_APPROVER_ID',
216: avalue => l_sec_approver_id);
217: diagn_msg(l_state_level,'start_approval_workflow','Attribute SEC_APPROVER_ID set to ' ||l_sec_approver_id );
218:
219: -- Set UserID attribute (AOL userID from FND_USER table).
220: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
221: itemkey => l_itemkey,
222: aname => 'SEC_APPROVER_FND_ID',
223: avalue => p_sec_apprv_fnd_id);

Line 911: l_rec_fnd_user_id NUMBER;

907:
908: l_cross_charge_id NUMBER;
909: l_cc_line_num NUMBER;
910: l_charge_range_id NUMBER;
911: l_rec_fnd_user_id NUMBER;
912: l_receiver_id NUMBER;
913: l_receiver_name VARCHAR2(240);
914: l_receiver_display_name VARCHAR2(240);
915:

Line 934: -- Get the receiver fnd user id for the service line

930: itemkey => itemkey,
931: aname => 'CC_LINE_NUM');
932:
933:
934: -- Get the receiver fnd user id for the service line
935: -- This is found using the charge_range_id of the charge range
936: -- which was valid at the time of charge entry.
937:
938: SELECT auth.authoriser_id

Line 939: INTO l_rec_fnd_user_id

935: -- This is found using the charge_range_id of the charge range
936: -- which was valid at the time of charge entry.
937:
938: SELECT auth.authoriser_id
939: INTO l_rec_fnd_user_id
940: FROM igi_itr_charge_ranges auth
941: ,igi_itr_charge_lines itrl
942: WHERE itrl.it_header_id = l_cross_charge_id
943: AND itrl.it_line_num = l_cc_line_num

Line 947: -- Set Receiver fnd user ID attribute (AOL user ID from FND_USER)

943: AND itrl.it_line_num = l_cc_line_num
944: AND itrl.charge_range_id = auth.charge_range_id;
945:
946:
947: -- Set Receiver fnd user ID attribute (AOL user ID from FND_USER)
948: wf_engine.SetItemAttrNumber( itemtype => itemtype,
949: itemkey => itemkey,
950: aname => 'RECEIVER_FND_ID',
951: avalue => l_rec_fnd_user_id);

Line 951: avalue => l_rec_fnd_user_id);

947: -- Set Receiver fnd user ID attribute (AOL user ID from FND_USER)
948: wf_engine.SetItemAttrNumber( itemtype => itemtype,
949: itemkey => itemkey,
950: aname => 'RECEIVER_FND_ID',
951: avalue => l_rec_fnd_user_id);
952: diagn_msg(l_state_level,'find_cc_receiver','Attribute RECEIVER_FND_ID set to ' ||l_rec_fnd_user_id );
953:
954:
955: -- Get employee ID of receiver

Line 952: diagn_msg(l_state_level,'find_cc_receiver','Attribute RECEIVER_FND_ID set to ' ||l_rec_fnd_user_id );

948: wf_engine.SetItemAttrNumber( itemtype => itemtype,
949: itemkey => itemkey,
950: aname => 'RECEIVER_FND_ID',
951: avalue => l_rec_fnd_user_id);
952: diagn_msg(l_state_level,'find_cc_receiver','Attribute RECEIVER_FND_ID set to ' ||l_rec_fnd_user_id );
953:
954:
955: -- Get employee ID of receiver
956: SELECT employee_id

Line 958: FROM fnd_user

954:
955: -- Get employee ID of receiver
956: SELECT employee_id
957: INTO l_receiver_id
958: FROM fnd_user
959: WHERE user_id = l_rec_fnd_user_id;
960:
961: -- Set PersonID attribute (HR personID from PER_PERSONS_F)
962: wf_engine.SetItemAttrNumber( itemtype => itemtype,

Line 959: WHERE user_id = l_rec_fnd_user_id;

955: -- Get employee ID of receiver
956: SELECT employee_id
957: INTO l_receiver_id
958: FROM fnd_user
959: WHERE user_id = l_rec_fnd_user_id;
960:
961: -- Set PersonID attribute (HR personID from PER_PERSONS_F)
962: wf_engine.SetItemAttrNumber( itemtype => itemtype,
963: itemkey => itemkey,