32: *****************************************************************************/
33: PROCEDURE set_wsp_cat_attr_cat is
34:
35: Begin
36: Update fnd_lookup_values
37: Set ATTRIBUTE_CATEGORY = G_WSP_CAT_ATTRIBUTE_CATEGORY
38: Where lookup_type = G_WSP_CAT_LOOKUP_TYPE
39: And ATTRIBUTE_CATEGORY IS null
40: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)
49:
50: /****************************************************************************
51: Name : validate_lookup_meaning
52: Description : called from LOOKUP_VAL_INSERT_ROW
53: LOOKUP_VAL_INSERT_ROW creats row in the fnd_lookup_values
54: If the meaning column is duplicate it prefix
55: year and duplicate no to meaning
56: *****************************************************************************/
57:
69: hr_utility.set_location('P_MEANING ' || P_MEANING,1);
70: select count(*)
71: into l_count
72: from
73: fnd_lookup_values
74: Where lookup_type = P_LOOKUP_TYPE
75: and MEANING = P_MEANING
76: and lookup_code <> p_lookup_code
77: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);
99:
100:
101: /****************************************************************************
102: Name : LOOKUP_VAL_INSERT_ROW
103: Description : LOOKUP_VAL_INSERT_ROW creats row in the fnd_lookup_values
104: lookup_code will have the YEAR appneded with id
105: *****************************************************************************/
106:
107: procedure LOOKUP_VAL_INSERT_ROW
138: begin
139: Select count(*)
140: INTO l_count
141: From
142: FND_LOOKUP_values
143: where
144: lookup_type = P_LOOKUP_TYPE
145: and lookup_code = P_LOOKUP_CODE
146: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);
163: , P_LOOKUP_CODE => P_LOOKUP_CODE
164: );
165: hr_utility.set_location('l_meaning' || l_meaning,1);
166:
167: hr_utility.set_location('calling FND_LOOKUP_VALUES_PKG.INSERT_ROW',1);
168: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3)'|| fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);
169:
170: /*Changes for Bug 6898734 */
171: len_desc:=length(P_DESCRIPTION);
186: hr_utility.set_location('After loop',1);
187:
188: /* End changes for Bug 6898734 */
189:
190: FND_LOOKUP_VALUES_PKG.INSERT_ROW(
191: X_ROWID => l_row_id,
192: X_LOOKUP_TYPE => P_LOOKUP_TYPE,
193: X_SECURITY_GROUP_ID => fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),
194: X_VIEW_APPLICATION_ID => 3,
424: If p_plan_trng_ind = '10' OR p_plan_trng_ind = '20' then
425:
426: /* Deleting the existing lookup_values from plan type for this year*/
427: If p_del_mode = 'Y' then
428: Delete from fnd_lookup_values
429: Where lookup_type in
430: ( g_p_lpath_lookup_type
431: , g_p_course_lookup_type
432: , g_p_cert_lookup_type
618: end if;
619:
620: If p_plan_trng_ind = '10' OR p_plan_trng_ind = '30' then
621: If p_del_mode = 'Y' then
622: Delete from fnd_lookup_values
623: Where lookup_type in
624: ( g_t_lpath_lookup_type
625: , g_t_course_lookup_type
626: , g_t_cert_lookup_type
873: p_plan_trng_ind in varchar2)
874: is
875: Begin
876: If p_plan_trng_ind = '10' OR p_plan_trng_ind = '20' then
877: Update fnd_lookup_values
878: Set ATTRIBUTE_CATEGORY = G_ATTRIBUTE_CATEGORY
879: Where lookup_type in
880: (
881: g_p_lpath_lookup_type
887:
888: end if;
889:
890: If p_plan_trng_ind = '10' OR p_plan_trng_ind = '30' then
891: Update fnd_lookup_values
892: Set ATTRIBUTE_CATEGORY = G_ATTRIBUTE_CATEGORY
893: Where lookup_type in
894: (
895: g_t_lpath_lookup_type
1130: , ATTRIBUTE12
1131: , ATTRIBUTE13
1132: , ATTRIBUTE14
1133: , ATTRIBUTE15
1134: from fnd_lookup_values
1135: Where lookup_type = l_lookup_type
1136: and substr(lookup_code,1,4) = to_char(l_from_year)
1137: And security_group_id = fnd_global.lookup_security_group(l_lookup_type,3)
1138: and (ATTRIBUTE1 ||ATTRIBUTE2 ||ATTRIBUTE3 ||ATTRIBUTE4 ||
1149: hr_utility.SET_LOCATION('p_plan_trng_ind ' || p_plan_trng_ind,1);
1150:
1151:
1152: select count(*) into l_trnd_count
1153: from fnd_lookup_values
1154: Where lookup_type in
1155: (
1156: g_t_lpath_lookup_type
1157: , g_t_course_lookup_type
1162:
1163: hr_utility.SET_LOCATION('l_trnd_count ' || l_trnd_count,1);
1164:
1165: select count(*) into l_plan_count
1166: from fnd_lookup_values
1167: Where lookup_type in
1168: (
1169: g_p_lpath_lookup_type
1170: , g_p_course_lookup_type
1661: , ATTRIBUTE12
1662: , ATTRIBUTE13
1663: , ATTRIBUTE14
1664: , ATTRIBUTE15
1665: from fnd_lookup_values
1666: Where lookup_type = l_lookup_type
1667: and substr(lookup_code,1,4) = to_char(P_from_year)
1668: And security_group_id = fnd_global.lookup_security_group(l_lookup_type,3)
1669: and (ATTRIBUTE1 ||ATTRIBUTE2 ||ATTRIBUTE3 ||ATTRIBUTE4 ||
1677: hr_utility.set_location ('P_from_year ' || P_from_year ,1);
1678:
1679:
1680: select count(*) into l_count
1681: from fnd_lookup_values
1682: Where lookup_type in
1683: (
1684: g_t_lpath_lookup_type
1685: , g_t_course_lookup_type