APPS.PRP_TOKEN_VALUES_PKG dependencies on PRP_TOKEN_VALUES_TL

Line 15: cursor C is select ROWID from PRP_TOKEN_VALUES_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 PRP_TOKEN_VALUES_TL
16: where TOKEN_VALUE_ID = X_TOKEN_VALUE_ID
17: and LANGUAGE = userenv('LANG')
18: ;
19: begin

Line 20: insert into PRP_TOKEN_VALUES_TL (

16: where TOKEN_VALUE_ID = X_TOKEN_VALUE_ID
17: and LANGUAGE = userenv('LANG')
18: ;
19: begin
20: insert into PRP_TOKEN_VALUES_TL (
21: TOKEN_VALUE_ID,
22: OBJECT_VERSION_NUMBER,
23: TOKEN_ID,
24: TOKEN_VALUE,

Line 48: from PRP_TOKEN_VALUES_TL T

44: from FND_LANGUAGES L
45: where L.INSTALLED_FLAG in ('I', 'B')
46: and not exists
47: (select NULL
48: from PRP_TOKEN_VALUES_TL T
49: where T.TOKEN_VALUE_ID = X_TOKEN_VALUE_ID
50: and T.LANGUAGE = L.LANGUAGE_CODE);
51:
52: open c;

Line 73: from PRP_TOKEN_VALUES_TL

69: OBJECT_VERSION_NUMBER,
70: TOKEN_ID,
71: TOKEN_VALUE,
72: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
73: from PRP_TOKEN_VALUES_TL
74: where TOKEN_VALUE_ID = X_TOKEN_VALUE_ID
75: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
76: for update of TOKEN_VALUE_ID nowait;
77: begin

Line 104: update PRP_TOKEN_VALUES_TL set

100: X_LAST_UPDATED_BY in NUMBER,
101: X_LAST_UPDATE_LOGIN in NUMBER
102: ) is
103: begin
104: update PRP_TOKEN_VALUES_TL set
105: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
106: TOKEN_ID = X_TOKEN_ID,
107: TOKEN_VALUE = X_TOKEN_VALUE,
108: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 124: delete from PRP_TOKEN_VALUES_TL

120: procedure DELETE_ROW (
121: X_TOKEN_VALUE_ID in NUMBER
122: ) is
123: begin
124: delete from PRP_TOKEN_VALUES_TL
125: where TOKEN_VALUE_ID = X_TOKEN_VALUE_ID;
126:
127: if (sql%notfound) then
128: raise no_data_found;

Line 136: update PRP_TOKEN_VALUES_TL T set (

132:
133: procedure ADD_LANGUAGE
134: is
135: begin
136: update PRP_TOKEN_VALUES_TL T set (
137: TOKEN_VALUE
138: ) = (select
139: B.TOKEN_VALUE
140: from PRP_TOKEN_VALUES_TL B

Line 140: from PRP_TOKEN_VALUES_TL B

136: update PRP_TOKEN_VALUES_TL T set (
137: TOKEN_VALUE
138: ) = (select
139: B.TOKEN_VALUE
140: from PRP_TOKEN_VALUES_TL B
141: where B.TOKEN_VALUE_ID = T.TOKEN_VALUE_ID
142: and B.LANGUAGE = T.SOURCE_LANG)
143: where (
144: T.TOKEN_VALUE_ID,

Line 149: from PRP_TOKEN_VALUES_TL SUBB, PRP_TOKEN_VALUES_TL SUBT

145: T.LANGUAGE
146: ) in (select
147: SUBT.TOKEN_VALUE_ID,
148: SUBT.LANGUAGE
149: from PRP_TOKEN_VALUES_TL SUBB, PRP_TOKEN_VALUES_TL SUBT
150: where SUBB.TOKEN_VALUE_ID = SUBT.TOKEN_VALUE_ID
151: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
152: and (SUBB.TOKEN_VALUE <> SUBT.TOKEN_VALUE
153: ));

Line 155: insert into PRP_TOKEN_VALUES_TL (

151: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
152: and (SUBB.TOKEN_VALUE <> SUBT.TOKEN_VALUE
153: ));
154:
155: insert into PRP_TOKEN_VALUES_TL (
156: TOKEN_VALUE_ID,
157: OBJECT_VERSION_NUMBER,
158: TOKEN_ID,
159: TOKEN_VALUE,

Line 179: from PRP_TOKEN_VALUES_TL B, FND_LANGUAGES L

175: B.LAST_UPDATE_DATE,
176: B.LAST_UPDATE_LOGIN,
177: L.LANGUAGE_CODE,
178: B.SOURCE_LANG
179: from PRP_TOKEN_VALUES_TL B, FND_LANGUAGES L
180: where L.INSTALLED_FLAG in ('I', 'B')
181: and B.LANGUAGE = userenv('LANG')
182: and not exists
183: (select NULL

Line 184: from PRP_TOKEN_VALUES_TL T

180: where L.INSTALLED_FLAG in ('I', 'B')
181: and B.LANGUAGE = userenv('LANG')
182: and not exists
183: (select NULL
184: from PRP_TOKEN_VALUES_TL T
185: where T.TOKEN_VALUE_ID = B.TOKEN_VALUE_ID
186: and T.LANGUAGE = L.LANGUAGE_CODE);
187: end ADD_LANGUAGE;
188: