APPS.JTF_LOC_TYPES_PKG dependencies on JTF_LOC_TYPES_TL

Line 39: insert into JTF_LOC_TYPES_TL (

35: X_LAST_UPDATED_BY,
36: X_LAST_UPDATE_LOGIN
37: );
38:
39: insert into JTF_LOC_TYPES_TL (
40: LOCATION_TYPE_ID,
41: LAST_UPDATE_DATE,
42: LAST_UPDATED_BY,
43: CREATION_DATE,

Line 65: from JTF_LOC_TYPES_TL T

61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from JTF_LOC_TYPES_TL T
66: where T.LOCATION_TYPE_ID = X_LOCATION_TYPE_ID
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68:
69: open c;

Line 102: update JTF_LOC_TYPES_TL set

98: if (sql%notfound) then
99: raise no_data_found;
100: end if;
101:
102: update JTF_LOC_TYPES_TL set
103: LOCATION_TYPE_NAME = X_LOCATION_TYPE_NAME,
104: LOCATION_TYPE_DESCRIPTION = X_LOCATION_TYPE_DESCRIPTION,
105: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
106: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 121: delete from JTF_LOC_TYPES_TL T

117:
118: procedure ADD_LANGUAGE
119: is
120: begin
121: delete from JTF_LOC_TYPES_TL T
122: where not exists
123: (select NULL
124: from JTF_LOC_TYPES_B B
125: where B.LOCATION_TYPE_ID = T.LOCATION_TYPE_ID

Line 128: update JTF_LOC_TYPES_TL T set (

124: from JTF_LOC_TYPES_B B
125: where B.LOCATION_TYPE_ID = T.LOCATION_TYPE_ID
126: );
127:
128: update JTF_LOC_TYPES_TL T set (
129: LOCATION_TYPE_NAME,
130: LOCATION_TYPE_DESCRIPTION
131: ) = (select
132: B.LOCATION_TYPE_NAME,

Line 134: from JTF_LOC_TYPES_TL B

130: LOCATION_TYPE_DESCRIPTION
131: ) = (select
132: B.LOCATION_TYPE_NAME,
133: B.LOCATION_TYPE_DESCRIPTION
134: from JTF_LOC_TYPES_TL B
135: where B.LOCATION_TYPE_ID = T.LOCATION_TYPE_ID
136: and B.LANGUAGE = T.SOURCE_LANG)
137: where (
138: T.LOCATION_TYPE_ID,

Line 143: from JTF_LOC_TYPES_TL SUBB, JTF_LOC_TYPES_TL SUBT

139: T.LANGUAGE
140: ) in (select
141: SUBT.LOCATION_TYPE_ID,
142: SUBT.LANGUAGE
143: from JTF_LOC_TYPES_TL SUBB, JTF_LOC_TYPES_TL SUBT
144: where SUBB.LOCATION_TYPE_ID = SUBT.LOCATION_TYPE_ID
145: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
146: and (SUBB.LOCATION_TYPE_NAME <> SUBT.LOCATION_TYPE_NAME
147: or SUBB.LOCATION_TYPE_DESCRIPTION <> SUBT.LOCATION_TYPE_DESCRIPTION

Line 152: insert into JTF_LOC_TYPES_TL (

148: or (SUBB.LOCATION_TYPE_DESCRIPTION is null and SUBT.LOCATION_TYPE_DESCRIPTION is not null)
149: or (SUBB.LOCATION_TYPE_DESCRIPTION is not null and SUBT.LOCATION_TYPE_DESCRIPTION is null)
150: ));
151:
152: insert into JTF_LOC_TYPES_TL (
153: LOCATION_TYPE_ID,
154: LAST_UPDATE_DATE,
155: LAST_UPDATED_BY,
156: CREATION_DATE,

Line 174: from JTF_LOC_TYPES_TL B, FND_LANGUAGES L

170: B.LOCATION_TYPE_NAME,
171: B.LOCATION_TYPE_DESCRIPTION,
172: L.LANGUAGE_CODE,
173: B.SOURCE_LANG
174: from JTF_LOC_TYPES_TL B, FND_LANGUAGES L
175: where L.INSTALLED_FLAG in ('I', 'B')
176: and B.LANGUAGE = userenv('LANG')
177: and not exists
178: (select NULL

Line 179: from JTF_LOC_TYPES_TL T

175: where L.INSTALLED_FLAG in ('I', 'B')
176: and B.LANGUAGE = userenv('LANG')
177: and not exists
178: (select NULL
179: from JTF_LOC_TYPES_TL T
180: where T.LOCATION_TYPE_ID = B.LOCATION_TYPE_ID
181: and T.LANGUAGE = L.LANGUAGE_CODE);
182: end ADD_LANGUAGE;
183:

Line 191: update JTF_LOC_TYPES_TL set

187: , X_LOCATION_TYPE_DESCRIPTION IN VARCHAR2
188: , X_OWNER IN VARCHAR2
189: ) is
190: begin
191: update JTF_LOC_TYPES_TL set
192: location_type_name = nvl(x_location_type_name, location_type_name),
193: location_type_description = nvl(X_LOCATION_TYPE_DESCRIPTION, location_type_description),
194: source_lang = userenv('LANG'),
195: last_update_date = sysdate,