APPS.FPA_OBJECTS_PKG dependencies on FPA_OBJECTS_TL

Line 15: cursor C is select ROWID from FPA_OBJECTS_TL

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from FPA_OBJECTS_TL
16: where ID = X_ID
17: and OBJECT = X_OBJECT
18: and LANGUAGE = userenv('LANG')
19: ;

Line 21: insert into FPA_OBJECTS_TL (

17: and OBJECT = X_OBJECT
18: and LANGUAGE = userenv('LANG')
19: ;
20: begin
21: insert into FPA_OBJECTS_TL (
22: OBJECT,
23: ID,
24: NAME,
25: DESCRIPTION,

Line 49: from FPA_OBJECTS_TL T

45: from FND_LANGUAGES L
46: where L.INSTALLED_FLAG in ('I', 'B')
47: and not exists
48: (select NULL
49: from FPA_OBJECTS_TL T
50: where T.ID = X_ID
51: and T.OBJECT = X_OBJECT
52: and T.LANGUAGE = L.LANGUAGE_CODE);
53:

Line 74: from FPA_OBJECTS_TL

70: cursor c1 is select
71: NAME,
72: DESCRIPTION,
73: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
74: from FPA_OBJECTS_TL
75: where ID = X_ID
76: and OBJECT = X_OBJECT
77: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
78: for update of ID nowait;

Line 107: update FPA_OBJECTS_TL set

103: X_LAST_UPDATED_BY in NUMBER,
104: X_LAST_UPDATE_LOGIN in NUMBER
105: ) is
106: begin
107: update FPA_OBJECTS_TL set
108: NAME = X_NAME,
109: DESCRIPTION = X_DESCRIPTION,
110: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
111: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 128: delete from FPA_OBJECTS_TL

124: X_ID in NUMBER,
125: X_OBJECT in VARCHAR2
126: ) is
127: begin
128: delete from FPA_OBJECTS_TL
129: where ID = X_ID
130: and OBJECT = X_OBJECT;
131:
132: if (sql%notfound) then

Line 141: update FPA_OBJECTS_TL T set (

137:
138: procedure ADD_LANGUAGE
139: is
140: begin
141: update FPA_OBJECTS_TL T set (
142: NAME,
143: DESCRIPTION
144: ) = (select
145: B.NAME,

Line 147: from FPA_OBJECTS_TL B

143: DESCRIPTION
144: ) = (select
145: B.NAME,
146: B.DESCRIPTION
147: from FPA_OBJECTS_TL B
148: where B.ID = T.ID
149: and B.OBJECT = T.OBJECT
150: and B.LANGUAGE = T.SOURCE_LANG)
151: where (

Line 159: from FPA_OBJECTS_TL SUBB, FPA_OBJECTS_TL SUBT

155: ) in (select
156: SUBT.ID,
157: SUBT.OBJECT,
158: SUBT.LANGUAGE
159: from FPA_OBJECTS_TL SUBB, FPA_OBJECTS_TL SUBT
160: where SUBB.ID = SUBT.ID
161: and SUBB.OBJECT = SUBT.OBJECT
162: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
163: and (SUBB.NAME <> SUBT.NAME

Line 171: insert into FPA_OBJECTS_TL (

167: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
168: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
169: ));
170:
171: insert into FPA_OBJECTS_TL (
172: OBJECT,
173: ID,
174: NAME,
175: DESCRIPTION,

Line 195: from FPA_OBJECTS_TL B, FND_LANGUAGES L

191: B.LAST_UPDATE_DATE,
192: B.LAST_UPDATE_LOGIN,
193: L.LANGUAGE_CODE,
194: B.SOURCE_LANG
195: from FPA_OBJECTS_TL B, FND_LANGUAGES L
196: where L.INSTALLED_FLAG in ('I', 'B')
197: and B.LANGUAGE = userenv('LANG')
198: and not exists
199: (select NULL

Line 200: from FPA_OBJECTS_TL T

196: where L.INSTALLED_FLAG in ('I', 'B')
197: and B.LANGUAGE = userenv('LANG')
198: and not exists
199: (select NULL
200: from FPA_OBJECTS_TL T
201: where T.ID = B.ID
202: and T.OBJECT = B.OBJECT
203: and T.LANGUAGE = L.LANGUAGE_CODE);
204: end ADD_LANGUAGE;

Line 215: update fpa_objects_tl set

211: P_OWNER in VARCHAR2
212: ) is
213: begin
214:
215: update fpa_objects_tl set
216: NAME = P_NAME,
217: LAST_UPDATE_DATE = sysdate,
218: LAST_UPDATED_BY = decode(P_OWNER, 'SEED', 1, 0),
219: LAST_UPDATE_LOGIN = 0,