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.JTF_RS_GROUP_RELATE_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 27: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

23: P_INIT_MSG_LIST IN VARCHAR2,
24: P_COMMIT IN VARCHAR2,
25: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
26: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
27: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,

Line 28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

24: P_COMMIT IN VARCHAR2,
25: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
26: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
27: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,

Line 29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,

25: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
26: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
27: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,

Line 30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,

26: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
27: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,

Line 31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,

27: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,

Line 32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,

28: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,

Line 33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,

29: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,

Line 34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,

30: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,

Line 35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,

31: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,

Line 36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,

32: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,

Line 37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,

33: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,

Line 38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,

34: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE,

Line 39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,

35: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE,

Line 40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,

36: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE,

Line 41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,

37: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,

Line 42: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE,

38: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 43: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE,

39: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 44: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE,

40: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 45: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,

41: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2,
49: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE

Line 49: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE

45: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2,
49: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE
50: )
51: IS
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP_RELATE';
53: l_api_version CONSTANT NUMBER :=1.0;

Line 68: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_group_id;

64: l_date Date;
65: l_user_id Number;
66: l_login_id Number;
67:
68: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_group_id;
69: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_related_group_id;
70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;
71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;

Line 69: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_related_group_id;

65: l_user_id Number;
66: l_login_id Number;
67:
68: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_group_id;
69: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_related_group_id;
70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;
71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;
73: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;

Line 70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;

66: l_login_id Number;
67:
68: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_group_id;
69: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_related_group_id;
70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;
71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;
73: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
74: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;

Line 71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;

67:
68: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_group_id;
69: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_related_group_id;
70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;
71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;
73: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
74: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;
75:

Line 72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;

68: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_group_id;
69: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_related_group_id;
70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;
71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;
73: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
74: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;
75:
76: l_g_miss_date date := to_date(to_char(fnd_api.g_miss_date,'DD-MM-RRRR'),'DD-MM-RRRR') ;

Line 73: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;

69: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE := p_related_group_id;
70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;
71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;
73: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
74: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;
75:
76: l_g_miss_date date := to_date(to_char(fnd_api.g_miss_date,'DD-MM-RRRR'),'DD-MM-RRRR') ;
77:

Line 74: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;

70: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE := p_relation_type;
71: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE := p_start_date_active;
72: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE := p_end_date_active;
73: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
74: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE;
75:
76: l_g_miss_date date := to_date(to_char(fnd_api.g_miss_date,'DD-MM-RRRR'),'DD-MM-RRRR') ;
77:
78: --CHECK THIS CURSOR FOR VALIDITY OF DATES

Line 80: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE,

76: l_g_miss_date date := to_date(to_char(fnd_api.g_miss_date,'DD-MM-RRRR'),'DD-MM-RRRR') ;
77:
78: --CHECK THIS CURSOR FOR VALIDITY OF DATES
79:
80: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE,
81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
83: IS
84: SELECT 'X'

Line 81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

77:
78: --CHECK THIS CURSOR FOR VALIDITY OF DATES
79:
80: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE,
81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
83: IS
84: SELECT 'X'
85: FROM jtf_rs_grp_relations rel

Line 82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)

78: --CHECK THIS CURSOR FOR VALIDITY OF DATES
79:
80: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE,
81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
83: IS
84: SELECT 'X'
85: FROM jtf_rs_grp_relations rel
86: WHERE rel.group_id = l_group_id

Line 85: FROM jtf_rs_grp_relations rel

81: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
82: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
83: IS
84: SELECT 'X'
85: FROM jtf_rs_grp_relations rel
86: WHERE rel.group_id = l_group_id
87: AND NVL(rel.delete_flag,'N') <> 'Y'
88: AND rel.relation_type = 'PARENT_GROUP'
89: AND ((l_start_date_active between rel.start_date_active and

Line 106: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,

102: AND rel.end_date_active IS NULL));*/
103:
104: check_overlap_rec check_overlap_cur%ROWTYPE;
105:
106: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
109: IS
110: SELECT 'X'

Line 107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

103:
104: check_overlap_rec check_overlap_cur%ROWTYPE;
105:
106: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
109: IS
110: SELECT 'X'
111: FROM jtf_rs_groups_b grp

Line 108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)

104: check_overlap_rec check_overlap_cur%ROWTYPE;
105:
106: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
107: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
108: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
109: IS
110: SELECT 'X'
111: FROM jtf_rs_groups_b grp
112: WHERE grp.group_id = l_group_id

Line 174: SELECT jtf_rs_grp_relations_s.nextval

170:
171:
172: CURSOR seq_cur
173: IS
174: SELECT jtf_rs_grp_relations_s.nextval
175: FROM dual;
176:
177:
178: CURSOR parent_count_cur(l_group_id number)

Line 181: from jtf_rs_grp_relations rel

177:
178: CURSOR parent_count_cur(l_group_id number)
179: IS
180: SELECT count(*) par_count
181: from jtf_rs_grp_relations rel
182: where rel.relation_type = 'PARENT_GROUP'
183: connect by rel.group_id = prior related_group_id
184: and nvl(delete_flag, 'N') <> 'Y'
185: and rel.related_group_id <> l_group_id

Line 199: from jtf_rs_grp_relations rel

195:
196: CURSOR child_count_cur(l_group_id number)
197: IS
198: SELECT count(*) par_count
199: from jtf_rs_grp_relations rel
200: where rel.relation_type = 'PARENT_GROUP'
201: connect by rel.related_group_id = prior group_id
202: and nvl(delete_flag, 'N') <> 'Y'
203: and rel.group_id <> l_group_id

Line 464: jtf_rs_grp_relations_pkg.insert_row(

460: END IF;
461:
462:
463: --call table handler to insert record
464: jtf_rs_grp_relations_pkg.insert_row(
465: X_ROWID => l_rowid,
466: X_GROUP_RELATE_ID => l_group_relate_id,
467: X_GROUP_ID => l_group_id,
468: X_RELATED_GROUP_ID => l_related_group_id,

Line 808: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

804: PROCEDURE update_resource_group_relate
805: (P_API_VERSION IN NUMBER,
806: P_INIT_MSG_LIST IN VARCHAR2,
807: P_COMMIT IN VARCHAR2,
808: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
809: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
810: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
811: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
812: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,

Line 809: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

805: (P_API_VERSION IN NUMBER,
806: P_INIT_MSG_LIST IN VARCHAR2,
807: P_COMMIT IN VARCHAR2,
808: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
809: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
810: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
811: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
812: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
813: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

Line 810: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,

806: P_INIT_MSG_LIST IN VARCHAR2,
807: P_COMMIT IN VARCHAR2,
808: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
809: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
810: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
811: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
812: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
813: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
814: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,

Line 850: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;

846: l_user_id Number;
847: l_login_id Number;
848:
849:
850: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
851: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ;
852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;
853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;

Line 851: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ;

847: l_login_id Number;
848:
849:
850: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
851: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ;
852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;
853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;

Line 852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;

848:
849:
850: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
851: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ;
852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;
853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;

Line 853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;

849:
850: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
851: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ;
852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;
853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
857: l_delete_flag JTF_RS_GRP_RELATIONS.DELETE_FLAG%TYPE;

Line 854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;

850: l_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE;
851: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ;
852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;
853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
857: l_delete_flag JTF_RS_GRP_RELATIONS.DELETE_FLAG%TYPE;
858:

Line 855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;

851: l_RELATED_GROUP_ID JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ;
852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;
853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
857: l_delete_flag JTF_RS_GRP_RELATIONS.DELETE_FLAG%TYPE;
858:
859: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := p_group_relate_id;

Line 856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;

852: l_RELATION_TYPE JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE ;
853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
857: l_delete_flag JTF_RS_GRP_RELATIONS.DELETE_FLAG%TYPE;
858:
859: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := p_group_relate_id;
860:

Line 857: l_delete_flag JTF_RS_GRP_RELATIONS.DELETE_FLAG%TYPE;

853: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE ;
854: l_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
857: l_delete_flag JTF_RS_GRP_RELATIONS.DELETE_FLAG%TYPE;
858:
859: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := p_group_relate_id;
860:
861: l_g_miss_date date := to_date(to_char(fnd_api.g_miss_date,'DD-MM-RRRR'),'DD-MM-RRRR') ;

Line 859: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := p_group_relate_id;

855: l_temp_end_date_active JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE ;
856: l_object_version_number JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
857: l_delete_flag JTF_RS_GRP_RELATIONS.DELETE_FLAG%TYPE;
858:
859: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := p_group_relate_id;
860:
861: l_g_miss_date date := to_date(to_char(fnd_api.g_miss_date,'DD-MM-RRRR'),'DD-MM-RRRR') ;
862:
863: L_ATTRIBUTE1 JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE;

Line 863: L_ATTRIBUTE1 JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE;

859: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE := p_group_relate_id;
860:
861: l_g_miss_date date := to_date(to_char(fnd_api.g_miss_date,'DD-MM-RRRR'),'DD-MM-RRRR') ;
862:
863: L_ATTRIBUTE1 JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE;
864: L_ATTRIBUTE2 JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE;
865: L_ATTRIBUTE3 JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE;
866: L_ATTRIBUTE4 JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE;
867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;

Line 864: L_ATTRIBUTE2 JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE;

860:
861: l_g_miss_date date := to_date(to_char(fnd_api.g_miss_date,'DD-MM-RRRR'),'DD-MM-RRRR') ;
862:
863: L_ATTRIBUTE1 JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE;
864: L_ATTRIBUTE2 JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE;
865: L_ATTRIBUTE3 JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE;
866: L_ATTRIBUTE4 JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE;
867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;
868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;

Line 865: L_ATTRIBUTE3 JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE;

861: l_g_miss_date date := to_date(to_char(fnd_api.g_miss_date,'DD-MM-RRRR'),'DD-MM-RRRR') ;
862:
863: L_ATTRIBUTE1 JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE;
864: L_ATTRIBUTE2 JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE;
865: L_ATTRIBUTE3 JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE;
866: L_ATTRIBUTE4 JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE;
867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;
868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;
869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;

Line 866: L_ATTRIBUTE4 JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE;

862:
863: L_ATTRIBUTE1 JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE;
864: L_ATTRIBUTE2 JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE;
865: L_ATTRIBUTE3 JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE;
866: L_ATTRIBUTE4 JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE;
867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;
868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;
869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;
870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;

Line 867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;

863: L_ATTRIBUTE1 JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE;
864: L_ATTRIBUTE2 JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE;
865: L_ATTRIBUTE3 JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE;
866: L_ATTRIBUTE4 JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE;
867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;
868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;
869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;
870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;
871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;

Line 868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;

864: L_ATTRIBUTE2 JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE;
865: L_ATTRIBUTE3 JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE;
866: L_ATTRIBUTE4 JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE;
867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;
868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;
869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;
870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;
871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;
872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;

Line 869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;

865: L_ATTRIBUTE3 JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE;
866: L_ATTRIBUTE4 JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE;
867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;
868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;
869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;
870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;
871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;
872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;
873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;

Line 870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;

866: L_ATTRIBUTE4 JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE;
867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;
868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;
869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;
870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;
871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;
872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;
873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;
874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;

Line 871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;

867: L_ATTRIBUTE5 JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE;
868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;
869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;
870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;
871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;
872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;
873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;
874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;
875: L_ATTRIBUTE13 JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE;

Line 872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;

868: L_ATTRIBUTE6 JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE;
869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;
870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;
871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;
872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;
873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;
874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;
875: L_ATTRIBUTE13 JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE;
876: L_ATTRIBUTE14 JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE;

Line 873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;

869: L_ATTRIBUTE7 JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE;
870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;
871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;
872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;
873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;
874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;
875: L_ATTRIBUTE13 JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE;
876: L_ATTRIBUTE14 JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE;
877: L_ATTRIBUTE15 JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE;

Line 874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;

870: L_ATTRIBUTE8 JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE;
871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;
872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;
873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;
874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;
875: L_ATTRIBUTE13 JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE;
876: L_ATTRIBUTE14 JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE;
877: L_ATTRIBUTE15 JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE;
878: L_ATTRIBUTE_CATEGORY JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

Line 875: L_ATTRIBUTE13 JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE;

871: L_ATTRIBUTE9 JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE;
872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;
873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;
874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;
875: L_ATTRIBUTE13 JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE;
876: L_ATTRIBUTE14 JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE;
877: L_ATTRIBUTE15 JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE;
878: L_ATTRIBUTE_CATEGORY JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
879:

Line 876: L_ATTRIBUTE14 JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE;

872: L_ATTRIBUTE10 JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE;
873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;
874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;
875: L_ATTRIBUTE13 JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE;
876: L_ATTRIBUTE14 JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE;
877: L_ATTRIBUTE15 JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE;
878: L_ATTRIBUTE_CATEGORY JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
879:
880:

Line 877: L_ATTRIBUTE15 JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE;

873: L_ATTRIBUTE11 JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE;
874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;
875: L_ATTRIBUTE13 JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE;
876: L_ATTRIBUTE14 JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE;
877: L_ATTRIBUTE15 JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE;
878: L_ATTRIBUTE_CATEGORY JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
879:
880:
881:

Line 878: L_ATTRIBUTE_CATEGORY JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;

874: L_ATTRIBUTE12 JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE;
875: L_ATTRIBUTE13 JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE;
876: L_ATTRIBUTE14 JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE;
877: L_ATTRIBUTE15 JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE;
878: L_ATTRIBUTE_CATEGORY JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
879:
880:
881:
882: CURSOR grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE )

Line 882: CURSOR grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE )

878: L_ATTRIBUTE_CATEGORY JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE;
879:
880:
881:
882: CURSOR grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE )
883: IS
884: SELECT group_id,
885: related_group_id,
886: start_date_active,

Line 907: FROM jtf_rs_grp_relations

903: attribute13,
904: attribute14,
905: attribute15,
906: attribute_category
907: FROM jtf_rs_grp_relations
908: WHERE group_relate_id = l_group_relate_id;
909:
910: grp_rel_rec grp_rel_cur%rowtype;
911:

Line 914: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,

910: grp_rel_rec grp_rel_cur%rowtype;
911:
912:
913:
914: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
918: IS

Line 915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

911:
912:
913:
914: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
918: IS
919: SELECT 'X'

Line 916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

912:
913:
914: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
918: IS
919: SELECT 'X'
920: FROM jtf_rs_grp_relations rel

Line 917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)

913:
914: CURSOR check_overlap_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
915: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
918: IS
919: SELECT 'X'
920: FROM jtf_rs_grp_relations rel
921: WHERE rel.group_relate_id <> l_group_relate_id

Line 920: FROM jtf_rs_grp_relations rel

916: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
917: l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE)
918: IS
919: SELECT 'X'
920: FROM jtf_rs_grp_relations rel
921: WHERE rel.group_relate_id <> l_group_relate_id
922: AND rel.group_id = l_group_id
923: AND NVL(rel.delete_flag,'N') <> 'Y'
924: AND rel.relation_type = 'PARENT_GROUP'

Line 937: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,

933: -- OR rel.end_date_active IS NULL)));
934:
935: check_overlap_rec check_overlap_cur%ROWTYPE;
936:
937: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
940: IS
941: SELECT 'X'

Line 938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

934:
935: check_overlap_rec check_overlap_cur%ROWTYPE;
936:
937: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
940: IS
941: SELECT 'X'
942: FROM jtf_rs_groups_b grp

Line 939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)

935: check_overlap_rec check_overlap_cur%ROWTYPE;
936:
937: CURSOR check_group_dt_cur(l_group_id JTF_RS_GRP_RELATIONS.GROUP_ID%TYPE ,
938: l_start_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
939: l_end_date_active JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE)
940: IS
941: SELECT 'X'
942: FROM jtf_rs_groups_b grp
943: WHERE grp.group_id = l_group_id

Line 1005: from jtf_rs_grp_relations rel

1001:
1002: CURSOR parent_count_cur(l_group_id number)
1003: IS
1004: SELECT count(*) par_count
1005: from jtf_rs_grp_relations rel
1006: where rel.relation_type = 'PARENT_GROUP'
1007: connect by rel.group_id = prior related_group_id
1008: and nvl(delete_flag, 'N') <> 'Y'
1009: and rel.related_group_id <> l_group_id

Line 1023: from jtf_rs_grp_relations rel

1019:
1020: CURSOR child_count_cur(l_group_id number)
1021: IS
1022: SELECT count(*) par_count
1023: from jtf_rs_grp_relations rel
1024: where rel.relation_type = 'PARENT_GROUP'
1025: connect by rel.related_group_id = prior group_id
1026: and nvl(delete_flag, 'N') <> 'Y'
1027: and rel.group_id <> l_group_id

Line 1386: jtf_rs_grp_relations_pkg.lock_row(

1382:
1383: --call lock row for updation
1384: BEGIN
1385:
1386: jtf_rs_grp_relations_pkg.lock_row(
1387: x_group_relate_id => l_group_relate_id,
1388: x_object_version_number => p_object_version_num
1389: );
1390:

Line 1436: jtf_rs_grp_relations_pkg.update_row(

1432:
1433:
1434:
1435:
1436: jtf_rs_grp_relations_pkg.update_row(
1437: X_GROUP_RELATE_ID => l_group_relate_id,
1438: X_GROUP_ID => l_group_id,
1439: X_RELATED_GROUP_ID => l_related_group_id,
1440: X_RELATION_TYPE => l_relation_type,

Line 1756: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

1752: PROCEDURE delete_resource_group_relate
1753: (P_API_VERSION IN NUMBER,
1754: P_INIT_MSG_LIST IN VARCHAR2,
1755: P_COMMIT IN VARCHAR2,
1756: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
1757: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
1758: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1759: X_MSG_COUNT OUT NOCOPY NUMBER,
1760: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1781: CURSOR grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE )

1777: l_login_id Number;
1778:
1779:
1780:
1781: CURSOR grp_rel_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE )
1782: IS
1783: SELECT group_id,
1784: related_group_id,
1785: start_date_active,

Line 1806: FROM jtf_rs_grp_relations

1802: attribute13,
1803: attribute14,
1804: attribute15,
1805: attribute_category
1806: FROM jtf_rs_grp_relations
1807: WHERE group_relate_id = l_group_relate_id;
1808:
1809: grp_rel_rec grp_rel_cur%rowtype;
1810:

Line 1814: from jtf_rs_grp_relations rel

1810:
1811: CURSOR parent_count_cur(l_group_id number)
1812: IS
1813: SELECT count(*) par_count
1814: from jtf_rs_grp_relations rel
1815: where rel.relation_type = 'PARENT_GROUP'
1816: connect by rel.group_id = prior related_group_id
1817: and nvl(delete_flag, 'N') <> 'Y'
1818: and rel.related_group_id <> l_group_id

Line 1832: from jtf_rs_grp_relations rel

1828:
1829: CURSOR child_count_cur(l_group_id number)
1830: IS
1831: SELECT count(*) child_count
1832: from jtf_rs_grp_relations rel
1833: where rel.relation_type = 'PARENT_GROUP'
1834: connect by rel.related_group_id = prior group_id
1835: and nvl(delete_flag, 'N') <> 'Y'
1836: and rel.group_id <> l_group_id

Line 1982: jtf_rs_grp_relations_pkg.lock_row(

1978:
1979: --call lock row for updation
1980: BEGIN
1981:
1982: jtf_rs_grp_relations_pkg.lock_row(
1983: x_group_relate_id => p_group_relate_id,
1984: x_object_version_number => p_object_version_num
1985: );
1986:

Line 2000: jtf_rs_grp_relations_pkg.update_row(

1996: END;
1997:
1998:
1999: --fetch table handler to update the delete flag to 'Y'
2000: jtf_rs_grp_relations_pkg.update_row(
2001: X_GROUP_RELATE_ID => p_group_relate_id,
2002: X_GROUP_ID => grp_rel_rec.group_id,
2003: X_RELATED_GROUP_ID => grp_rel_rec.related_group_id,
2004: X_RELATION_TYPE => grp_rel_rec.relation_type,