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

Line 17: stutta 14-Apr-2005 Replaced all references to FND_USER.customer_id to

13: --kkillams 10-03-2003 Replaced wf_event_t.AddParameterToList with wf_event.AddParameterToList api
14: -- to show params in the workflow out queue and able to derive the parameters
15: from the outside after event is raised, w.r.t. bug 2840171
16: knaraset 18-Nov-2003 Added procedure student_placement_event, for placement build
17: stutta 14-Apr-2005 Replaced all references to FND_USER.customer_id to
18: FND_USER.person_party_id. Bug #4293911
19:
20: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL) in ENR_NOTIFICATION
21: procedure as a part of bug#4958173.

Line 18: FND_USER.person_party_id. Bug #4293911

14: -- to show params in the workflow out queue and able to derive the parameters
15: from the outside after event is raised, w.r.t. bug 2840171
16: knaraset 18-Nov-2003 Added procedure student_placement_event, for placement build
17: stutta 14-Apr-2005 Replaced all references to FND_USER.customer_id to
18: FND_USER.person_party_id. Bug #4293911
19:
20: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL) in ENR_NOTIFICATION
21: procedure as a part of bug#4958173.
22: smaddali 10-apr-06 Added new procedure raise_spi_rcond_event for bug#5091858 BUILD EN324

Line 892: FROM fnd_user

888: -- cursor to get the user_name corresponding to the person_id
889:
890: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
891: SELECT user_name
892: FROM fnd_user
893: WHERE person_party_id = cp_person_id;
894:
895: l_user_name fnd_user.user_name%TYPE;
896:

Line 895: l_user_name fnd_user.user_name%TYPE;

891: SELECT user_name
892: FROM fnd_user
893: WHERE person_party_id = cp_person_id;
894:
895: l_user_name fnd_user.user_name%TYPE;
896:
897: CURSOR c_dup_user (cp_user_name VARCHAR2,
898: cp_role_name VARCHAR2) IS
899: SELECT count(1)

Line 1036: FROM fnd_user

1032: -- cursor to get the user_name corresponding to the person_id
1033:
1034: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
1035: SELECT user_name
1036: FROM fnd_user
1037: WHERE person_party_id = cp_person_id
1038: AND ( end_date IS NULL OR end_date > SYSDATE );
1039:
1040: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

Line 1040: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

1036: FROM fnd_user
1037: WHERE person_party_id = cp_person_id
1038: AND ( end_date IS NULL OR end_date > SYSDATE );
1039:
1040: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1041: SELECT user_name
1042: FROM fnd_user
1043: WHERE user_id = cp_person_id
1044: AND ( end_date IS NULL OR end_date > SYSDATE );

Line 1042: FROM fnd_user

1038: AND ( end_date IS NULL OR end_date > SYSDATE );
1039:
1040: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1041: SELECT user_name
1042: FROM fnd_user
1043: WHERE user_id = cp_person_id
1044: AND ( end_date IS NULL OR end_date > SYSDATE );
1045:
1046:

Line 1047: l_user_name fnd_user.user_name%TYPE;

1043: WHERE user_id = cp_person_id
1044: AND ( end_date IS NULL OR end_date > SYSDATE );
1045:
1046:
1047: l_user_name fnd_user.user_name%TYPE;
1048: l_user_name_admin fnd_user.user_name%TYPE;
1049:
1050: CURSOR c_dup_user (cp_user_name VARCHAR2,
1051: cp_role_name VARCHAR2) IS

Line 1048: l_user_name_admin fnd_user.user_name%TYPE;

1044: AND ( end_date IS NULL OR end_date > SYSDATE );
1045:
1046:
1047: l_user_name fnd_user.user_name%TYPE;
1048: l_user_name_admin fnd_user.user_name%TYPE;
1049:
1050: CURSOR c_dup_user (cp_user_name VARCHAR2,
1051: cp_role_name VARCHAR2) IS
1052: SELECT count(1)

Line 1187: FROM fnd_user

1183: -- cursor to get the user_name corresponding to the person_id
1184:
1185: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
1186: SELECT user_name
1187: FROM fnd_user
1188: WHERE person_party_id = cp_person_id;
1189:
1190: -- cursor to get the user_name corresponding to the user_id
1191:

Line 1192: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

1188: WHERE person_party_id = cp_person_id;
1189:
1190: -- cursor to get the user_name corresponding to the user_id
1191:
1192: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1193: SELECT user_name
1194: FROM fnd_user
1195: WHERE user_id = cp_person_id
1196: AND ( end_date IS NULL OR end_date > SYSDATE );

Line 1194: FROM fnd_user

1190: -- cursor to get the user_name corresponding to the user_id
1191:
1192: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1193: SELECT user_name
1194: FROM fnd_user
1195: WHERE user_id = cp_person_id
1196: AND ( end_date IS NULL OR end_date > SYSDATE );
1197:
1198: l_user_name fnd_user.user_name%TYPE;

Line 1198: l_user_name fnd_user.user_name%TYPE;

1194: FROM fnd_user
1195: WHERE user_id = cp_person_id
1196: AND ( end_date IS NULL OR end_date > SYSDATE );
1197:
1198: l_user_name fnd_user.user_name%TYPE;
1199: l_user_name_admin fnd_user.user_name%TYPE;
1200:
1201: CURSOR c_dup_user (cp_user_name VARCHAR2,
1202: cp_role_name VARCHAR2) IS

Line 1199: l_user_name_admin fnd_user.user_name%TYPE;

1195: WHERE user_id = cp_person_id
1196: AND ( end_date IS NULL OR end_date > SYSDATE );
1197:
1198: l_user_name fnd_user.user_name%TYPE;
1199: l_user_name_admin fnd_user.user_name%TYPE;
1200:
1201: CURSOR c_dup_user (cp_user_name VARCHAR2,
1202: cp_role_name VARCHAR2) IS
1203: SELECT count(1)

Line 1341: FROM fnd_user

1337: -- cursor to get the user_name corresponding to the person_id
1338:
1339: CURSOR c_user_name (cp_person_id igs_as_ord_itm_int.person_id%TYPE) IS
1340: SELECT user_name
1341: FROM fnd_user
1342: WHERE person_party_id = cp_person_id
1343: AND ( end_date IS NULL OR end_date > SYSDATE );
1344:
1345: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

Line 1345: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS

1341: FROM fnd_user
1342: WHERE person_party_id = cp_person_id
1343: AND ( end_date IS NULL OR end_date > SYSDATE );
1344:
1345: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1346: SELECT user_name
1347: FROM fnd_user
1348: WHERE user_id = cp_person_id
1349: AND ( end_date IS NULL OR end_date > SYSDATE );

Line 1347: FROM fnd_user

1343: AND ( end_date IS NULL OR end_date > SYSDATE );
1344:
1345: CURSOR c_user_name_admin (cp_person_id fnd_user.user_id%TYPE) IS
1346: SELECT user_name
1347: FROM fnd_user
1348: WHERE user_id = cp_person_id
1349: AND ( end_date IS NULL OR end_date > SYSDATE );
1350:
1351:

Line 1352: l_user_name fnd_user.user_name%TYPE;

1348: WHERE user_id = cp_person_id
1349: AND ( end_date IS NULL OR end_date > SYSDATE );
1350:
1351:
1352: l_user_name fnd_user.user_name%TYPE;
1353: l_user_name_admin fnd_user.user_name%TYPE;
1354:
1355: CURSOR c_dup_user (cp_user_name VARCHAR2,
1356: cp_role_name VARCHAR2) IS

Line 1353: l_user_name_admin fnd_user.user_name%TYPE;

1349: AND ( end_date IS NULL OR end_date > SYSDATE );
1350:
1351:
1352: l_user_name fnd_user.user_name%TYPE;
1353: l_user_name_admin fnd_user.user_name%TYPE;
1354:
1355: CURSOR c_dup_user (cp_user_name VARCHAR2,
1356: cp_role_name VARCHAR2) IS
1357: SELECT count(1)

Line 1691: FROM fnd_user

1687: WHERE person_id = cp_n_person_id;
1688:
1689: CURSOR c_user_name (cp_n_person_id IN NUMBER) IS
1690: SELECT user_name
1691: FROM fnd_user
1692: WHERE person_party_id = cp_n_person_id;
1693:
1694: l_t_temp NUMBER;
1695: l_c_person_num igs_pe_person_base_v.person_number%TYPE;

Line 1697: l_c_user_name fnd_user.user_name%TYPE;

1693:
1694: l_t_temp NUMBER;
1695: l_c_person_num igs_pe_person_base_v.person_number%TYPE;
1696: l_n_instuctor_id igs_ps_usec_tch_resp.instructor_id%TYPE;
1697: l_c_user_name fnd_user.user_name%TYPE;
1698: l_c_perm_type VARCHAR2(2000);
1699:
1700: BEGIN
1701: -- initialize the wf_event_t object

Line 1801: l_user_name fnd_user.user_name%TYPE;

1797: WHERE party_id = cp_person_id;
1798:
1799: l_person_number hz_parties.party_number%TYPE;
1800: l_person_name hz_parties.party_name%TYPE;
1801: l_user_name fnd_user.user_name%TYPE;
1802:
1803: l_cur_seq_val cur_seq_val%ROWTYPE;
1804: l_wf_parameter_list_t WF_PARAMETER_LIST_T:= wf_parameter_list_t();
1805: l_wf_installed fnd_lookups.lookup_code%TYPE;