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.PER_ZA_WSP_LOOKUP dependencies on FND_LOOKUP_VALUES

Line 36: Update fnd_lookup_values

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)

Line 53: LOOKUP_VAL_INSERT_ROW creats row in the fnd_lookup_values

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:

Line 73: fnd_lookup_values

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

Line 103: Description : LOOKUP_VAL_INSERT_ROW creats row in the fnd_lookup_values

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

Line 142: FND_LOOKUP_values

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

Line 167: hr_utility.set_location('calling FND_LOOKUP_VALUES_PKG.INSERT_ROW',1);

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

Line 190: FND_LOOKUP_VALUES_PKG.INSERT_ROW(

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,

Line 428: Delete from fnd_lookup_values

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

Line 622: Delete from fnd_lookup_values

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

Line 877: Update fnd_lookup_values

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

Line 891: Update fnd_lookup_values

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

Line 1134: from fnd_lookup_values

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

Line 1153: from fnd_lookup_values

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

Line 1166: from fnd_lookup_values

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

Line 1665: from fnd_lookup_values

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

Line 1681: from fnd_lookup_values

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