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_GLOBAL

Line 40: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)

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)
41: AND lookup_code NOT IN
42: ( Select lookup_code
43: FROM hr_lookups
44: Where lookup_type = 'ZA_EMP_EQ_OCCUPATIONAL_CAT'

Line 77: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);

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);
78:
79: hr_utility.set_location('l_count ' || l_count,1);
80: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3) ' || fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);
81:

Line 80: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3) ' || fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);

76: and lookup_code <> p_lookup_code
77: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);
78:
79: hr_utility.set_location('l_count ' || l_count,1);
80: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3) ' || fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);
81:
82: if l_count = 0 then
83: l_MEANING := P_Meaning;
84: else

Line 146: AND security_group_id = fnd_global.lookup_security_group(P_LOOKUP_TYPE,3);

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);
147:
148: hr_utility.set_location('inside LOOKUP_VAL_INSERT_ROW',1);
149: hr_utility.set_location('P_LOOKUP_TYPE' || P_LOOKUP_TYPE,1);
150: hr_utility.set_location('P_LOOKUP_CODE' || P_LOOKUP_CODE,1);

Line 168: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3)'|| fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);

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);
172: SELECT vsize(P_DESCRIPTION) INTO lenb_desc FROM dual;

Line 193: X_SECURITY_GROUP_ID => fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),

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,
195: X_LOOKUP_CODE => P_LOOKUP_CODE,
196: X_TAG => null,
197: X_ATTRIBUTE_CATEGORY => G_ATTRIBUTE_CATEGORY,

Line 434: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)

430: ( g_p_lpath_lookup_type
431: , g_p_course_lookup_type
432: , g_p_cert_lookup_type
433: )
434: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)
435: And substr(lookup_code,1,4) = p_year;
436: end if;
437:
438: /* Calling create looukp values for planed Learning paths */

Line 630: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)

626: , g_t_cert_lookup_type
627: , g_t_comp_lookup_type
628: , g_t_qual_lookup_type
629: )
630: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)
631: And substr(lookup_code,1,4) = p_year - 1;
632: end if;
633:
634: /* Calling create looukp values for trained Learning paths */

Line 886: And security_group_id = fnd_global.lookup_security_group(lookup_type,3);

882: , g_p_course_lookup_type
883: , g_p_cert_lookup_type
884: )
885: And ATTRIBUTE_CATEGORY is null
886: And security_group_id = fnd_global.lookup_security_group(lookup_type,3);
887:
888: end if;
889:
890: If p_plan_trng_ind = '10' OR p_plan_trng_ind = '30' then

Line 901: And security_group_id = fnd_global.lookup_security_group(lookup_type,3)

897: , g_t_cert_lookup_type
898: , g_t_comp_lookup_type
899: , g_t_qual_lookup_type
900: )
901: And security_group_id = fnd_global.lookup_security_group(lookup_type,3)
902: And ATTRIBUTE_CATEGORY is null;
903:
904: end if;
905:

Line 1137: And security_group_id = fnd_global.lookup_security_group(l_lookup_type,3)

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 ||
1139: ATTRIBUTE5 ||ATTRIBUTE6 ||ATTRIBUTE7 ||ATTRIBUTE8 ||
1140: ATTRIBUTE9 ||ATTRIBUTE10||ATTRIBUTE11||ATTRIBUTE12||
1141: ATTRIBUTE13||ATTRIBUTE14||ATTRIBUTE15) is not null;

Line 1160: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)

1156: g_t_lpath_lookup_type
1157: , g_t_course_lookup_type
1158: , g_t_cert_lookup_type
1159: )
1160: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)
1161: and substr(lookup_code,1,4) = p_year-1;
1162:
1163: hr_utility.SET_LOCATION('l_trnd_count ' || l_trnd_count,1);
1164:

Line 1173: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)

1169: g_p_lpath_lookup_type
1170: , g_p_course_lookup_type
1171: , g_p_cert_lookup_type
1172: )
1173: AND security_group_id = fnd_global.lookup_security_group(lookup_type,3)
1174: and substr(lookup_code,1,4) = p_year;
1175:
1176: hr_utility.SET_LOCATION('l_plan_count ' || l_plan_count,1);
1177:

Line 1668: And security_group_id = fnd_global.lookup_security_group(l_lookup_type,3)

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 ||
1670: ATTRIBUTE5 ||ATTRIBUTE6 ||ATTRIBUTE7 ||ATTRIBUTE8 ||
1671: ATTRIBUTE9 ||ATTRIBUTE10||ATTRIBUTE11||ATTRIBUTE12||
1672: ATTRIBUTE13||ATTRIBUTE14||ATTRIBUTE15) is not null;

Line 1688: And security_group_id = fnd_global.lookup_security_group(lookup_type,3)

1684: g_t_lpath_lookup_type
1685: , g_t_course_lookup_type
1686: , g_t_cert_lookup_type
1687: )
1688: And security_group_id = fnd_global.lookup_security_group(lookup_type,3)
1689: and substr(lookup_code,1,4) = to_char(p_year-1);
1690:
1691: hr_utility.set_location ('l_count ' || l_count ,2);
1692: