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

Line 15: p_user_id fnd_user.user_id%TYPE) AS

11: ******************************************************************/
12:
13: PROCEDURE submit_approval( p_template_id igp_wz_templates.template_id%TYPE,
14: p_template_name igp_wz_templates.template_name%TYPE,
15: p_user_id fnd_user.user_id%TYPE) AS
16: /******************************************************************
17: Created By : Prabhat Patel
18: Date Created By : 20-Feb-2004
19: Purpose : Procedure for raising the business event for template approval

Line 187: l_approver fnd_user.user_name%TYPE;

183: remarks :
184: Change History
185: Who When What
186: ******************************************************************/
187: l_approver fnd_user.user_name%TYPE;
188: l_approver_name hz_parties.party_name%TYPE;
189: l_login_user_id fnd_user.user_id%TYPE;
190: l_login_user_name fnd_user.user_name%TYPE;
191: l_item_key wf_items.item_key%TYPE;

Line 189: l_login_user_id fnd_user.user_id%TYPE;

185: Who When What
186: ******************************************************************/
187: l_approver fnd_user.user_name%TYPE;
188: l_approver_name hz_parties.party_name%TYPE;
189: l_login_user_id fnd_user.user_id%TYPE;
190: l_login_user_name fnd_user.user_name%TYPE;
191: l_item_key wf_items.item_key%TYPE;
192: l_item_exists VARCHAR2(1);
193: l_template_id igp_wz_templates.template_id%TYPE;

Line 190: l_login_user_name fnd_user.user_name%TYPE;

186: ******************************************************************/
187: l_approver fnd_user.user_name%TYPE;
188: l_approver_name hz_parties.party_name%TYPE;
189: l_login_user_id fnd_user.user_id%TYPE;
190: l_login_user_name fnd_user.user_name%TYPE;
191: l_item_key wf_items.item_key%TYPE;
192: l_item_exists VARCHAR2(1);
193: l_template_id igp_wz_templates.template_id%TYPE;
194: l_template_name igp_wz_templates.template_name%TYPE;

Line 203: CURSOR login_person_cur (cp_user_id fnd_user.user_id%TYPE) IS

199: l_protocol_port VARCHAR2(240);
200: l_virtual_path VARCHAR2(240);
201: l_protocol_port_value VARCHAR2(240);
202:
203: CURSOR login_person_cur (cp_user_id fnd_user.user_id%TYPE) IS
204: SELECT usr.user_name, hz.person_last_name||', '||hz.person_first_name person_name, usr.email_address
205: FROM fnd_user usr, hz_parties hz
206: WHERE usr.user_id = cp_user_id AND
207: usr.person_party_id = hz.party_id;

Line 205: FROM fnd_user usr, hz_parties hz

201: l_protocol_port_value VARCHAR2(240);
202:
203: CURSOR login_person_cur (cp_user_id fnd_user.user_id%TYPE) IS
204: SELECT usr.user_name, hz.person_last_name||', '||hz.person_first_name person_name, usr.email_address
205: FROM fnd_user usr, hz_parties hz
206: WHERE usr.user_id = cp_user_id AND
207: usr.person_party_id = hz.party_id;
208:
209: CURSOR approver_name_cur (cp_approver fnd_user.user_name%TYPE) IS

Line 209: CURSOR approver_name_cur (cp_approver fnd_user.user_name%TYPE) IS

205: FROM fnd_user usr, hz_parties hz
206: WHERE usr.user_id = cp_user_id AND
207: usr.person_party_id = hz.party_id;
208:
209: CURSOR approver_name_cur (cp_approver fnd_user.user_name%TYPE) IS
210: SELECT hz.party_name
211: FROM fnd_user usr, hz_parties hz
212: WHERE usr.user_name = cp_approver AND
213: usr.person_party_id = hz.party_id;

Line 211: FROM fnd_user usr, hz_parties hz

207: usr.person_party_id = hz.party_id;
208:
209: CURSOR approver_name_cur (cp_approver fnd_user.user_name%TYPE) IS
210: SELECT hz.party_name
211: FROM fnd_user usr, hz_parties hz
212: WHERE usr.user_name = cp_approver AND
213: usr.person_party_id = hz.party_id;
214:
215: CURSOR temp_dtl_cur(cp_template_id IN NUMBER, cp_lookup_type IN VARCHAR2) IS