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.IBU_DYN_USER_GROUPS_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 35: x_resource_id OUT NOCOPY jtf_rs_resource_extns.resource_id%TYPE,

31: End;
32: -- =================================================================================================================
33: PROCEDURE get_curr_usr_resouce_info
34: (
35: x_resource_id OUT NOCOPY jtf_rs_resource_extns.resource_id%TYPE,
36: x_resource_number OUT NOCOPY jtf_rs_resource_extns.resource_number%TYPE
37: )
38: IS
39: l_current_user_id NUMBER := FND_GLOBAL.User_Id;

Line 36: x_resource_number OUT NOCOPY jtf_rs_resource_extns.resource_number%TYPE

32: -- =================================================================================================================
33: PROCEDURE get_curr_usr_resouce_info
34: (
35: x_resource_id OUT NOCOPY jtf_rs_resource_extns.resource_id%TYPE,
36: x_resource_number OUT NOCOPY jtf_rs_resource_extns.resource_number%TYPE
37: )
38: IS
39: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
40:

Line 42: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;

38: IS
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;

Line 46: l_creby_category jtf_rs_resource_extns.category%TYPE;

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:
50: Begin

Line 77: from jtf_rs_resource_extns

73: end;
74: begin
75: select resource_id, resource_number
76: into x_resource_id, x_resource_number
77: from jtf_rs_resource_extns
78: where source_id = l_creby_source_id
79: and category = l_creby_category
80: and ( (end_date_active is null) or (end_date_active > sysdate) );
81: exception

Line 91: Procedure GetFndUserActiveCnt (p_source_id IN jtf_rs_resource_extns.source_id%TYPE,

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
95: Begin

Line 92: p_category IN jtf_rs_resource_extns.category%TYPE,

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
95: Begin
96: If p_category = 'EMPLOYEE' Then

Line 117: Procedure Get_UserID (p_source_id IN jtf_rs_resource_extns.source_id%TYPE,

113: End If;
114:
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;

Line 118: p_category IN jtf_rs_resource_extns.category%TYPE,

114:
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

Line 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

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
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;

Line 352: from jtf_rs_group_members_vl A, jtf_rs_resource_extns B

348: B.resource_id,
349: B.resource_number ,
350: B.source_id,
351: A.object_version_number
352: from jtf_rs_group_members_vl A, jtf_rs_resource_extns B
353: where group_id = p_group_id
354: and A.resource_id = B.resource_id
355: and A.delete_flag = 'N'
356: and A.resource_id not in ( select resource_id

Line 357: from jtf_rs_resource_extns C, ibu_usergroups_temp D

353: where group_id = p_group_id
354: and A.resource_id = B.resource_id
355: and A.delete_flag = 'N'
356: and A.resource_id not in ( select resource_id
357: from jtf_rs_resource_extns C, ibu_usergroups_temp D
358: where C.source_id = D.source_id
359: and C.category = D.category);
360:
361: Cursor l_cre_res_csr

Line 366: from jtf_rs_resource_extns

362: IS
363: select source_id, category
364: from ibu_usergroups_temp A
365: where not exists (select source_id
366: from jtf_rs_resource_extns
367: where source_id = A.source_id
368: and category = A.category
369: and ( (end_date_active is null ) OR (end_date_active > sysdate) )
370: );

Line 376: from ibu_usergroups_temp A, jtf_rs_resource_extns B

372: -- Do not create members whose resource records are end dated
373: Cursor l_cre_csr (p_group_id jtf_rs_groups_vl.group_id%TYPE)
374: IS
375: select B.resource_id, B.resource_number
376: from ibu_usergroups_temp A, jtf_rs_resource_extns B
377: where A.source_id = B.source_id
378: and A.category = B.category
379: and not exists ( select resource_id
380: from jtf_rs_group_members

Line 387: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

383: and delete_flag = 'N')
384: and ( ( B.end_date_active is null ) or (B.end_date_active > sysdate) ) ;
385:
386: l_resource_cnt number;
387: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
388: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
389: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
390:
391: l_fndactive_cnt NUMBER;

Line 388: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;

384: and ( ( B.end_date_active is null ) or (B.end_date_active > sysdate) ) ;
385:
386: l_resource_cnt number;
387: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
388: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
389: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
390:
391: l_fndactive_cnt NUMBER;
392: l_res_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;

Line 392: l_res_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;

388: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
389: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
390:
391: l_fndactive_cnt NUMBER;
392: l_res_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
393: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
394: l_source_name jtf_rs_resource_extns.source_name%TYPE;
395: l_dbl_res_cnt NUMBER;
396:

Line 393: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;

389: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
390:
391: l_fndactive_cnt NUMBER;
392: l_res_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
393: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
394: l_source_name jtf_rs_resource_extns.source_name%TYPE;
395: l_dbl_res_cnt NUMBER;
396:
397: -- bug 3032219

Line 394: l_source_name jtf_rs_resource_extns.source_name%TYPE;

390:
391: l_fndactive_cnt NUMBER;
392: l_res_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
393: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
394: l_source_name jtf_rs_resource_extns.source_name%TYPE;
395: l_dbl_res_cnt NUMBER;
396:
397: -- bug 3032219
398: -- to get the first start date of the employee

Line 508: from jtf_rs_resource_extns

504: /* Create resources for new members if they are not already resources */
505:
506: For l_cre_res_rec IN l_cre_res_csr Loop
507: select count(*) into l_resource_cnt
508: from jtf_rs_resource_extns
509: where source_id = l_cre_res_rec.source_id
510: and category = l_cre_res_rec.category;
511:
512: If l_resource_cnt = 0 then

Line 573: from jtf_rs_resource_extns

569: End If;
570: Else -- If l_resource_cnt = 0 then
571: select count(*)
572: into l_dbl_res_cnt
573: from jtf_rs_resource_extns
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

Line 586: from jtf_rs_resource_extns

582: ElsIf l_dbl_res_cnt = 0 Then
583: -- All the resource records are end_dated
584: select resource_id, resource_number, object_version_number, end_date_active
585: into l_resource_id, l_resource_number , l_object_version_number, l_res_end_date_active
586: from jtf_rs_resource_extns
587: where source_id = l_cre_res_rec.source_id
588: and category = l_cre_res_rec.category
589: and resource_id = (select max(resource_id)
590: from jtf_rs_resource_extns

Line 590: from jtf_rs_resource_extns

586: from jtf_rs_resource_extns
587: where source_id = l_cre_res_rec.source_id
588: and category = l_cre_res_rec.category
589: and resource_id = (select max(resource_id)
590: from jtf_rs_resource_extns
591: Where source_id = l_cre_res_rec.source_id
592: and category = l_cre_res_rec.category);
593: -- Check if resource records are end dated
594: GetFndUserActiveCnt(l_cre_res_rec.source_id, l_cre_res_rec.category, l_fndactive_cnt);

Line 697: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

693:
694: -- IN/OUT variables for APIs
695: l_group_id jtf_rs_groups_vl.group_id%type;
696: l_group_number jtf_rs_groups_vl.group_number%type;
697: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
698: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
699: l_channel_rec AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE;
700:
701: -- constants in this program

Line 698: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;

694: -- IN/OUT variables for APIs
695: l_group_id jtf_rs_groups_vl.group_id%type;
696: l_group_number jtf_rs_groups_vl.group_number%type;
697: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
698: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
699: l_channel_rec AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE;
700:
701: -- constants in this program
702: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE DEFAULT 'N';

Line 707: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;

703: l_role_code jtf_rs_role_relations_vl.ROLE_TYPE_CODE%TYPE := 'IBUUG';
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;

Line 711: l_creby_category jtf_rs_resource_extns.category%TYPE;

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;
715: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;

Line 713: l_creby_resource_id jtf_rs_resource_extns.resource_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;
715: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
716: l_channel_id NUMBER;
717: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

Line 714: l_creby_resource_number jtf_rs_resource_extns.resource_number%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;
715: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
716: l_channel_id NUMBER;
717: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
718: l_group_usage_id JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE;

Line 715: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%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;
715: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
716: l_channel_id NUMBER;
717: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
718: l_group_usage_id JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE;
719: l_category varchar2(50);

Line 722: l_object_version_number jtf_rs_resource_extns.object_version_number%TYPE;

718: l_group_usage_id JTF_RS_GROUP_USAGES.GROUP_USAGE_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;

Line 726: l_res_end_date_active jtf_rs_resource_extns.end_date_active%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;
728:
729: l_source_name jtf_rs_resource_extns.source_name%TYPE;
730: l_address_id jtf_rs_resource_extns.address_id%TYPE;

Line 727: l_res_start_date_active jtf_rs_resource_extns.start_date_active%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;
728:
729: l_source_name jtf_rs_resource_extns.source_name%TYPE;
730: l_address_id jtf_rs_resource_extns.address_id%TYPE;
731: l_temp_cnt NUMBER;

Line 729: l_source_name jtf_rs_resource_extns.source_name%TYPE;

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;
728:
729: l_source_name jtf_rs_resource_extns.source_name%TYPE;
730: l_address_id jtf_rs_resource_extns.address_id%TYPE;
731: l_temp_cnt NUMBER;
732: l_dbl_res_cnt NUMBER;
733: Begin

Line 730: l_address_id jtf_rs_resource_extns.address_id%TYPE;

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;
728:
729: l_source_name jtf_rs_resource_extns.source_name%TYPE;
730: l_address_id jtf_rs_resource_extns.address_id%TYPE;
731: l_temp_cnt NUMBER;
732: l_dbl_res_cnt NUMBER;
733: Begin
734: Log_Message('Begin ibu_user_group_cre procedure.... ');

Line 885: FROM jtf_rs_resource_extns a

881: /* Check for each member, a resouce exists, if not create a resource. Then make this user member of the group*/
882: For l_cre_mem_rec IN l_cre_mem_csr Loop
883: -- check if resource needs to be created - begin
884: SELECT count(*) INTO l_res_cnt
885: FROM jtf_rs_resource_extns a
886: WHERE a.source_id = l_cre_mem_rec.source_id
887: and category = l_cre_mem_rec.category;
888:
889: If l_res_cnt = 0 Then

Line 951: from jtf_rs_resource_extns

947: End If;
948: Else -- Resource already exists -- If l_res_cnt = 0 Then
949: select count(*)
950: into l_dbl_res_cnt
951: from jtf_rs_resource_extns
952: where source_id = l_cre_mem_rec.source_id
953: and category = l_cre_mem_rec.category
954: and ( (end_date_active is null ) OR (end_date_active > sysdate) );
955:

Line 960: from jtf_rs_resource_extns

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
962: and category = l_cre_mem_rec.category
963: and resource_id = (select max(resource_id)
964: from jtf_rs_resource_extns

Line 964: from jtf_rs_resource_extns

960: from jtf_rs_resource_extns
961: where source_id = l_cre_mem_rec.source_id
962: and category = l_cre_mem_rec.category
963: and resource_id = (select max(resource_id)
964: from jtf_rs_resource_extns
965: Where source_id = l_cre_mem_rec.source_id
966: and category = l_cre_mem_rec.category);
967: GetFndUserActiveCnt(l_cre_mem_rec.source_id, l_cre_mem_rec.category, l_fndactive_cnt);
968: If l_fndactive_cnt = 0 Then

Line 995: ' from jtf_rs_resource_extns ' ||

991: ' multiple active resource record are found. please correct it and rerun the concurrent program'
992: );
993: log_message ( ' Use this following query to find the duplicate resource records for this user');
994: log_message ( 'select resource_number, end_date_active, start_date ' ||
995: ' from jtf_rs_resource_extns ' ||
996: ' where source_id = ? ' ||
997: ' and category_id = ? ' );
998: l_resource_id := 0;
999: l_resource_number := 0;

Line 1004: from jtf_rs_resource_extns

1000: Else
1001: -- only one resource is active.
1002: select resource_id, resource_number, object_version_number, end_date_active
1003: into l_resource_id, l_resource_number, l_object_version_number , l_res_end_date_active
1004: from jtf_rs_resource_extns
1005: where source_id = l_cre_mem_rec.source_id
1006: and category = l_cre_mem_rec.category
1007: and ( (end_date_active is null ) OR (end_date_active > sysdate) );
1008: End If;

Line 1092: from jtf_rs_groups_vl A, jtf_rs_group_members B, jtf_rs_resource_extns C

1088: A.group_number,
1089: B.object_version_number,
1090: B.resource_id,
1091: C.resource_number
1092: from jtf_rs_groups_vl A, jtf_rs_group_members B, jtf_rs_resource_extns C
1093: Where A.group_id = p_group_id
1094: and A.group_id = B.group_id
1095: and B.resource_id = C.resource_id
1096: and B.delete_flag = 'N' ;

Line 1099: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;

1095: and B.resource_id = C.resource_id
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;

Line 1103: l_creby_category jtf_rs_resource_extns.category%TYPE;

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;
1107: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;

Line 1105: l_creby_resource_id jtf_rs_resource_extns.resource_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;
1107: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1108: l_category varchar2(50);
1109: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;

Line 1106: l_creby_resource_number jtf_rs_resource_extns.resource_number%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;
1107: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1108: l_category varchar2(50);
1109: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
1110: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;

Line 1107: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%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;
1107: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1108: l_category varchar2(50);
1109: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
1110: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
1111:

Line 1115: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;

1111:
1112: -- constant
1113: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
1114:
1115: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1116: l_source_name jtf_rs_resource_extns.source_name%TYPE;
1117: l_address_id jtf_rs_resource_extns.address_id%TYPE;
1118:
1119: creByFndUserExp Exception;

Line 1116: l_source_name jtf_rs_resource_extns.source_name%TYPE;

1112: -- constant
1113: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
1114:
1115: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1116: l_source_name jtf_rs_resource_extns.source_name%TYPE;
1117: l_address_id jtf_rs_resource_extns.address_id%TYPE;
1118:
1119: creByFndUserExp Exception;
1120: Begin

Line 1117: l_address_id jtf_rs_resource_extns.address_id%TYPE;

1113: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
1114:
1115: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1116: l_source_name jtf_rs_resource_extns.source_name%TYPE;
1117: l_address_id jtf_rs_resource_extns.address_id%TYPE;
1118:
1119: creByFndUserExp Exception;
1120: Begin
1121: Log_Message('Inside ibu_user_group_del procedure.... ');

Line 1229: x_resource_id OUT NOCOPY jtf_rs_resource_extns.resource_id%TYPE,

1225: End;
1226: -- =================================================================================================================
1227: PROCEDURE check_resource_setup
1228: (
1229: x_resource_id OUT NOCOPY jtf_rs_resource_extns.resource_id%TYPE,
1230: x_resource_number OUT NOCOPY jtf_rs_resource_extns.resource_number%TYPE,
1231: x_setup_success OUT NOCOPY NUMBER
1232: )
1233: IS

Line 1230: x_resource_number OUT NOCOPY jtf_rs_resource_extns.resource_number%TYPE,

1226: -- =================================================================================================================
1227: PROCEDURE check_resource_setup
1228: (
1229: x_resource_id OUT NOCOPY jtf_rs_resource_extns.resource_id%TYPE,
1230: x_resource_number OUT NOCOPY jtf_rs_resource_extns.resource_number%TYPE,
1231: x_setup_success OUT NOCOPY NUMBER
1232: )
1233: IS
1234: l_current_user_id NUMBER := FND_GLOBAL.User_Id;

Line 1237: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;

1233: IS
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;

Line 1241: l_creby_category jtf_rs_resource_extns.category%TYPE;

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;
1245: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;

Line 1243: l_creby_resource_id jtf_rs_resource_extns.resource_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;
1245: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1246: l_category varchar2(50);
1247: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;

Line 1244: l_creby_resource_number jtf_rs_resource_extns.resource_number%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;
1245: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1246: l_category varchar2(50);
1247: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
1248: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;

Line 1245: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%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;
1245: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1246: l_category varchar2(50);
1247: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
1248: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
1249:

Line 1255: l_res_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;

1251: l_msg_count number;
1252: l_msg_data varchar2(2000);
1253: l_dbl_res_cnt number;
1254:
1255: l_res_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1256: l_source_name jtf_rs_resource_extns.source_name%TYPE;
1257:
1258: -- bug 3032219
1259: -- to get the first start date of the employee

Line 1256: l_source_name jtf_rs_resource_extns.source_name%TYPE;

1252: l_msg_data varchar2(2000);
1253: l_dbl_res_cnt number;
1254:
1255: l_res_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1256: l_source_name jtf_rs_resource_extns.source_name%TYPE;
1257:
1258: -- bug 3032219
1259: -- to get the first start date of the employee
1260: CURSOR c_emp_start_date(c_person_id IN NUMBER) IS

Line 1294: from jtf_rs_resource_extns

1290: l_creby_source_id := 0;
1291: End If;
1292:
1293: select count(*) into l_creby_res_cnt
1294: from jtf_rs_resource_extns
1295: where source_id = l_creby_source_id
1296: and category = l_creby_category;
1297:
1298: If l_creby_res_cnt = 0 then

Line 1383: from jtf_rs_resource_extns

1379: l_return_status , l_msg_count , l_msg_data );
1380: Else
1381: select count(*)
1382: into l_dbl_res_cnt
1383: from jtf_rs_resource_extns
1384: where source_id = l_creby_source_id
1385: and category = l_creby_category
1386: and ( (end_date_active is null) or (end_date_active > sysdate) );
1387:

Line 1398: ' from jtf_rs_resource_extns ' ||

1394: ' category = ' || l_creby_category
1395: );
1396: log_message ( 'In sqlplus Use this following query to find the resource numbers for the current login user');
1397: log_message ( 'select resource_number, end_date_active, start_date ' ||
1398: ' from jtf_rs_resource_extns ' ||
1399: ' where source_id = ' || l_creby_source_id ||
1400: ' and category = ' || '''' || l_creby_category || '''' );
1401: log_message('Log in to FORMS env with responsibility - CRM Resource Manager, Vision Enterprises');
1402: log_message(' Maintain Resources -> Resources -> Enter resource_number from the above query -> Un End date the resource record or Create a new Resource record');

Line 1413: ' from jtf_rs_resource_extns ' ||

1409: ' category = ' || l_creby_category
1410: );
1411: log_message ( '2. In sqlplus Use this following query to find the duplicate resource records for the current login user');
1412: log_message ( 'select resource_number, end_date_active, start_date ' ||
1413: ' from jtf_rs_resource_extns ' ||
1414: ' where source_id = ' || l_creby_source_id ||
1415: ' and category = ' || '''' || l_creby_category || '''' );
1416: log_message('3. Log in to FORMS env with responsibility - CRM Resource Manager, Vision Enterprises');
1417: log_message(' Maintain Resources -> Resources -> Enter resource_number from the above query -> End date the unwanted resource record');

Line 1421: from jtf_rs_resource_extns

1417: log_message(' Maintain Resources -> Resources -> Enter resource_number from the above query -> End date the unwanted resource record');
1418: Else
1419: select resource_id, resource_number
1420: into x_resource_id, x_resource_number
1421: from jtf_rs_resource_extns
1422: where source_id = l_creby_source_id
1423: and category = l_creby_category
1424: and ( (end_date_active is null) or (end_date_active > sysdate) );
1425:

Line 1471: x_resource_id jtf_rs_resource_extns.resource_id%TYPE;

1467: ERRBUF OUT NOCOPY VARCHAR2,
1468: RETCODE OUT NOCOPY NUMBER
1469: )
1470: IS
1471: x_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1472: x_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1473: x_setup_success NUMBER;
1474:
1475: mesSysAdminSetupException Exception;

Line 1472: x_resource_number jtf_rs_resource_extns.resource_number%TYPE;

1468: RETCODE OUT NOCOPY NUMBER
1469: )
1470: IS
1471: x_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1472: x_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1473: x_setup_success NUMBER;
1474:
1475: mesSysAdminSetupException Exception;
1476: Begin