DBA Data[Home] [Help]

APPS.IBU_DYN_USER_GROUPS_PKG dependencies on FND_USER

Line 43: l_creby_empid fnd_user.employee_id%TYPE;

39: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
40:
41: -- Temporary variables
42: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
43: l_creby_empid fnd_user.employee_id%TYPE;
44: l_creby_custid fnd_user.customer_id%TYPE;
45: l_creby_supid fnd_user.supplier_id%TYPE;
46: l_creby_category jtf_rs_resource_extns.category%TYPE;
47: l_creby_res_cnt NUMBER;

Line 44: l_creby_custid fnd_user.customer_id%TYPE;

40:
41: -- Temporary variables
42: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
43: l_creby_empid fnd_user.employee_id%TYPE;
44: l_creby_custid fnd_user.customer_id%TYPE;
45: l_creby_supid fnd_user.supplier_id%TYPE;
46: l_creby_category jtf_rs_resource_extns.category%TYPE;
47: l_creby_res_cnt NUMBER;
48: l_category varchar2(50);

Line 45: l_creby_supid fnd_user.supplier_id%TYPE;

41: -- Temporary variables
42: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
43: l_creby_empid fnd_user.employee_id%TYPE;
44: l_creby_custid fnd_user.customer_id%TYPE;
45: l_creby_supid fnd_user.supplier_id%TYPE;
46: l_creby_category jtf_rs_resource_extns.category%TYPE;
47: l_creby_res_cnt NUMBER;
48: l_category varchar2(50);
49:

Line 54: from fnd_user

50: Begin
51: begin
52: select employee_id, customer_id, supplier_id
53: into l_creby_empid, l_creby_custid, l_creby_supid
54: from fnd_user
55: where user_id = l_current_user_id;
56:
57: If l_creby_empid is not null Then
58: l_creby_category := 'EMPLOYEE';

Line 90: -- For a given source_id, it returns count>0 if atleast there is one fnd_user record which is not end_dated.

86: raise;
87: end;
88: END;
89: -- =================================================================================================================
90: -- For a given source_id, it returns count>0 if atleast there is one fnd_user record which is not end_dated.
91: Procedure GetFndUserActiveCnt (p_source_id IN jtf_rs_resource_extns.source_id%TYPE,
92: p_category IN jtf_rs_resource_extns.category%TYPE,
93: x_Cnt OUT NOCOPY NUMBER )
94: IS

Line 98: from fnd_user

94: IS
95: Begin
96: If p_category = 'EMPLOYEE' Then
97: select count(*) into x_cnt
98: from fnd_user
99: where employee_id = p_source_id
100: and ( ( end_date is null) or (end_date > sysdate) ) ;
101: ElsIf p_category = 'PARTY' Then
102: select max(user_id) into x_cnt

Line 103: from fnd_user

99: where employee_id = p_source_id
100: and ( ( end_date is null) or (end_date > sysdate) ) ;
101: ElsIf p_category = 'PARTY' Then
102: select max(user_id) into x_cnt
103: from fnd_user
104: where customer_id = p_source_id
105: and ( ( end_date is null) or (end_date > sysdate) ) ;
106: ElsIf p_category = 'SUPPLIER_CONTACT' Then
107: select max(user_id) into x_cnt

Line 108: from fnd_user

104: where customer_id = p_source_id
105: and ( ( end_date is null) or (end_date > sysdate) ) ;
106: ElsIf p_category = 'SUPPLIER_CONTACT' Then
107: select max(user_id) into x_cnt
108: from fnd_user
109: where supplier_id = p_source_id
110: and ( ( end_date is null) or (end_date > sysdate) ) ;
111: Else
112: x_cnt := 0;

Line 119: x_user_id OUT NOCOPY fnd_user.user_id%TYPE )

115: End;
116: -- =================================================================================================================
117: Procedure Get_UserID (p_source_id IN jtf_rs_resource_extns.source_id%TYPE,
118: p_category IN jtf_rs_resource_extns.category%TYPE,
119: x_user_id OUT NOCOPY fnd_user.user_id%TYPE )
120: IS
121: l_cnt NUMBER;
122: Begin
123: -- Find out user_id for the source_id, we need to have a link for user_id, source_id, category in jtf_rs_resource_extns table

Line 126: from fnd_user

122: Begin
123: -- Find out user_id for the source_id, we need to have a link for user_id, source_id, category in jtf_rs_resource_extns table
124: If p_category = 'EMPLOYEE' Then
125: select max(user_id) into x_user_id
126: from fnd_user
127: where employee_id = p_source_id;
128: ElsIf p_category = 'PARTY' Then
129: select max(user_id) into x_user_id
130: from fnd_user

Line 130: from fnd_user

126: from fnd_user
127: where employee_id = p_source_id;
128: ElsIf p_category = 'PARTY' Then
129: select max(user_id) into x_user_id
130: from fnd_user
131: where customer_id = p_source_id;
132: ElsIf p_category = 'SUPPLIER_CONTACT' Then
133: select max(user_id) into x_user_id
134: from fnd_user

Line 134: from fnd_user

130: from fnd_user
131: where customer_id = p_source_id;
132: ElsIf p_category = 'SUPPLIER_CONTACT' Then
133: select max(user_id) into x_user_id
134: from fnd_user
135: where supplier_id = p_source_id;
136: Else
137: x_user_id := 0;
138: End If;

Line 229: l_emp_id fnd_user.employee_id%TYPE;

225:
226: -- =================================================================================================================
227: Procedure Update_Category_SourceID (p_category varchar2)
228: Is
229: l_emp_id fnd_user.employee_id%TYPE;
230:
231: Cursor l_source_csr IS
232: select source_id
233: from ibu_usergroups_temp ;

Line 240: from fnd_user A

236: If p_category = 'PARTY' Then
237: For l_source_rec in l_source_csr Loop
238:
239: select max(employee_id) into l_emp_id
240: from fnd_user A
241: Where A.customer_id = l_source_rec.source_id
242: and A.employee_id is not null
243: and exists ( select person_id
244: from per_workforce_current_x

Line 343: l_user_id fnd_user.user_id%TYPE;

339: l_sql_text jtf_rs_dynamic_groups_vl.sql_text%TYPE;
340: l_category varchar2(50);
341: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
342: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
343: l_user_id fnd_user.user_id%TYPE;
344:
345: Cursor l_del_mem_csr(p_group_id jtf_rs_groups_vl.group_id%TYPE)
346: IS
347: select A.group_member_id,

Line 578: -- Multiple active resource records for one fnd_user record.

574: where source_id = l_cre_res_rec.source_id
575: and category = l_cre_res_rec.category
576: and ( (end_date_active is null) or (end_date_active > sysdate) );
577: If l_dbl_res_cnt > 1 Then
578: -- Multiple active resource records for one fnd_user record.
579: Log_Message( 'This user has not been added to user group. This fnd_user record has mutltiple active resource records. Please correct this.' ||
580: ' source_id = ' || l_cre_res_rec.source_id ||
581: ' category = ' || l_cre_res_rec.category);
582: ElsIf l_dbl_res_cnt = 0 Then

Line 579: Log_Message( 'This user has not been added to user group. This fnd_user record has mutltiple active resource records. Please correct this.' ||

575: and category = l_cre_res_rec.category
576: and ( (end_date_active is null) or (end_date_active > sysdate) );
577: If l_dbl_res_cnt > 1 Then
578: -- Multiple active resource records for one fnd_user record.
579: Log_Message( 'This user has not been added to user group. This fnd_user record has mutltiple active resource records. Please correct this.' ||
580: ' source_id = ' || l_cre_res_rec.source_id ||
581: ' category = ' || l_cre_res_rec.category);
582: ElsIf l_dbl_res_cnt = 0 Then
583: -- All the resource records are end_dated

Line 600: ' Safely skip this record, all fnd_user records belonging to this source_id are' ||

596: Log_Message( ' resource_id = ' || to_char(l_resource_id) ||
597: ' resource_number = ' || l_resource_number ||
598: ' ; source_id = ' || to_char(l_cre_res_rec.source_id) ||
599: ' ; category = ' || l_cre_res_rec.category ||
600: ' Safely skip this record, all fnd_user records belonging to this source_id are' ||
601: ' end_dated. So, resource record is also end dated ;'
602: );
603: Else
604: -- Atleast one fnd_user record is still active. So, Log_Message a message that Resource is end_dated even though fnd_user is valid

Line 604: -- Atleast one fnd_user record is still active. So, Log_Message a message that Resource is end_dated even though fnd_user is valid

600: ' Safely skip this record, all fnd_user records belonging to this source_id are' ||
601: ' end_dated. So, resource record is also end dated ;'
602: );
603: Else
604: -- Atleast one fnd_user record is still active. So, Log_Message a message that Resource is end_dated even though fnd_user is valid
605: Log_Message(' * resource_id = ' || to_char(l_resource_id) ||
606: ' resource_number = ' || l_resource_number ||
607: ' ; source_id = ' || to_char(l_cre_res_rec.source_id) ||
608: ' ; category = ' || l_cre_res_rec.category ||

Line 609: ' This user has not been added to user group. Fnd User record is active.' ||

605: Log_Message(' * resource_id = ' || to_char(l_resource_id) ||
606: ' resource_number = ' || l_resource_number ||
607: ' ; source_id = ' || to_char(l_cre_res_rec.source_id) ||
608: ' ; category = ' || l_cre_res_rec.category ||
609: ' This user has not been added to user group. Fnd User record is active.' ||
610: ' But resource record is end dated. ' ||
611: ' Correct the end_date_active of resource record' );
612: End If;
613: End If; -- If l_dbl_res_cnt > 1 Then

Line 708: l_creby_empid fnd_user.employee_id%TYPE;

704: l_usage JTF_RS_GROUP_USAGES.USAGE%TYPE := 'ISUPPORT';
705:
706: -- Temporary variables
707: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
708: l_creby_empid fnd_user.employee_id%TYPE;
709: l_creby_custid fnd_user.customer_id%TYPE;
710: l_creby_supid fnd_user.supplier_id%TYPE;
711: l_creby_category jtf_rs_resource_extns.category%TYPE;
712: l_creby_res_cnt NUMBER;

Line 709: l_creby_custid fnd_user.customer_id%TYPE;

705:
706: -- Temporary variables
707: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
708: l_creby_empid fnd_user.employee_id%TYPE;
709: l_creby_custid fnd_user.customer_id%TYPE;
710: l_creby_supid fnd_user.supplier_id%TYPE;
711: l_creby_category jtf_rs_resource_extns.category%TYPE;
712: l_creby_res_cnt NUMBER;
713: l_creby_resource_id jtf_rs_resource_extns.resource_id%TYPE;

Line 710: l_creby_supid fnd_user.supplier_id%TYPE;

706: -- Temporary variables
707: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
708: l_creby_empid fnd_user.employee_id%TYPE;
709: l_creby_custid fnd_user.customer_id%TYPE;
710: l_creby_supid fnd_user.supplier_id%TYPE;
711: l_creby_category jtf_rs_resource_extns.category%TYPE;
712: l_creby_res_cnt NUMBER;
713: l_creby_resource_id jtf_rs_resource_extns.resource_id%TYPE;
714: l_creby_resource_number jtf_rs_resource_extns.resource_number%TYPE;

Line 723: l_user_id fnd_user.user_id%TYPE;

719: l_category varchar2(50);
720: l_res_cnt NUMBER;
721: l_group_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE;
722: l_object_version_number jtf_rs_resource_extns.object_version_number%TYPE;
723: l_user_id fnd_user.user_id%TYPE;
724:
725: l_fndactive_cnt NUMBER;
726: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
727: l_res_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;

Line 957: -- No active resources. So, see if there are active fnd user records.

953: and category = l_cre_mem_rec.category
954: and ( (end_date_active is null ) OR (end_date_active > sysdate) );
955:
956: If l_dbl_res_cnt = 0 Then
957: -- No active resources. So, see if there are active fnd user records.
958: select resource_id, resource_number, object_version_number, end_date_active
959: into l_resource_id, l_resource_number, l_object_version_number , l_res_end_date_active
960: from jtf_rs_resource_extns
961: where source_id = l_cre_mem_rec.source_id

Line 972: ' Safely skip this record, all fnd_user records belonging to this source_id are' ||

968: If l_fndactive_cnt = 0 Then
969: Log_Message( ' resource_number = ' || l_resource_number ||
970: ' ; source_id = ' || to_char(l_cre_mem_rec.source_id) ||
971: ' ; category = ' || l_cre_mem_rec.category ||
972: ' Safely skip this record, all fnd_user records belonging to this source_id are' ||
973: ' end_dated. So, resource record is also end dated ;'
974: );
975: Else
976: -- Atleast one fnd_user record is still active. So, Log_Message a message that Resource is end_dated even though fnd_user is valid

Line 976: -- Atleast one fnd_user record is still active. So, Log_Message a message that Resource is end_dated even though fnd_user is valid

972: ' Safely skip this record, all fnd_user records belonging to this source_id are' ||
973: ' end_dated. So, resource record is also end dated ;'
974: );
975: Else
976: -- Atleast one fnd_user record is still active. So, Log_Message a message that Resource is end_dated even though fnd_user is valid
977: Log_Message(' * resource_number = ' || l_resource_number ||
978: ' ; source_id = ' || to_char(l_cre_mem_rec.source_id) ||
979: ' ; category = ' || l_cre_mem_rec.category ||
980: ' This user has not been added to user group. Fnd User record is active.' ||

Line 980: ' This user has not been added to user group. Fnd User record is active.' ||

976: -- Atleast one fnd_user record is still active. So, Log_Message a message that Resource is end_dated even though fnd_user is valid
977: Log_Message(' * resource_number = ' || l_resource_number ||
978: ' ; source_id = ' || to_char(l_cre_mem_rec.source_id) ||
979: ' ; category = ' || l_cre_mem_rec.category ||
980: ' This user has not been added to user group. Fnd User record is active.' ||
981: ' But resource record is end dated. ' ||
982: ' Correct the end_date_active of resource record' );
983: End If;
984: l_resource_id := 0;

Line 1100: l_creby_empid fnd_user.employee_id%TYPE;

1096: and B.delete_flag = 'N' ;
1097:
1098: -- Temporary variables
1099: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
1100: l_creby_empid fnd_user.employee_id%TYPE;
1101: l_creby_custid fnd_user.customer_id%TYPE;
1102: l_creby_supid fnd_user.supplier_id%TYPE;
1103: l_creby_category jtf_rs_resource_extns.category%TYPE;
1104: l_creby_res_cnt NUMBER;

Line 1101: l_creby_custid fnd_user.customer_id%TYPE;

1097:
1098: -- Temporary variables
1099: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
1100: l_creby_empid fnd_user.employee_id%TYPE;
1101: l_creby_custid fnd_user.customer_id%TYPE;
1102: l_creby_supid fnd_user.supplier_id%TYPE;
1103: l_creby_category jtf_rs_resource_extns.category%TYPE;
1104: l_creby_res_cnt NUMBER;
1105: l_creby_resource_id jtf_rs_resource_extns.resource_id%TYPE;

Line 1102: l_creby_supid fnd_user.supplier_id%TYPE;

1098: -- Temporary variables
1099: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
1100: l_creby_empid fnd_user.employee_id%TYPE;
1101: l_creby_custid fnd_user.customer_id%TYPE;
1102: l_creby_supid fnd_user.supplier_id%TYPE;
1103: l_creby_category jtf_rs_resource_extns.category%TYPE;
1104: l_creby_res_cnt NUMBER;
1105: l_creby_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1106: l_creby_resource_number jtf_rs_resource_extns.resource_number%TYPE;

Line 1238: l_creby_empid fnd_user.employee_id%TYPE;

1234: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
1235:
1236: -- Temporary variables
1237: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
1238: l_creby_empid fnd_user.employee_id%TYPE;
1239: l_creby_custid fnd_user.customer_id%TYPE;
1240: l_creby_supid fnd_user.supplier_id%TYPE;
1241: l_creby_category jtf_rs_resource_extns.category%TYPE;
1242: l_creby_res_cnt NUMBER;

Line 1239: l_creby_custid fnd_user.customer_id%TYPE;

1235:
1236: -- Temporary variables
1237: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
1238: l_creby_empid fnd_user.employee_id%TYPE;
1239: l_creby_custid fnd_user.customer_id%TYPE;
1240: l_creby_supid fnd_user.supplier_id%TYPE;
1241: l_creby_category jtf_rs_resource_extns.category%TYPE;
1242: l_creby_res_cnt NUMBER;
1243: l_creby_resource_id jtf_rs_resource_extns.resource_id%TYPE;

Line 1240: l_creby_supid fnd_user.supplier_id%TYPE;

1236: -- Temporary variables
1237: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
1238: l_creby_empid fnd_user.employee_id%TYPE;
1239: l_creby_custid fnd_user.customer_id%TYPE;
1240: l_creby_supid fnd_user.supplier_id%TYPE;
1241: l_creby_category jtf_rs_resource_extns.category%TYPE;
1242: l_creby_res_cnt NUMBER;
1243: l_creby_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1244: l_creby_resource_number jtf_rs_resource_extns.resource_number%TYPE;

Line 1277: from fnd_user

1273:
1274: Begin
1275: x_setup_success := 1;
1276: select employee_id, customer_id, supplier_id into l_creby_empid, l_creby_custid, l_creby_supid
1277: from fnd_user
1278: where user_id = l_current_user_id;
1279: If l_creby_empid is not null Then
1280: l_creby_category := 'EMPLOYEE';
1281: l_creby_source_id := l_creby_empid ;