APPS.GMA_SY_PARA_CDS_PKG dependencies on SY_PARA_CDS_TL

Line 17: cursor C is select ROWID from SY_PARA_CDS_TL

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from SY_PARA_CDS_TL
18: where TABLE_NAME = X_TABLE_NAME
19: and LANG_CODE = X_LANG_CODE
20: and PARAGRAPH_CODE = X_PARAGRAPH_CODE
21: and SUB_PARACODE = X_SUB_PARACODE

Line 25: insert into SY_PARA_CDS_TL (

21: and SUB_PARACODE = X_SUB_PARACODE
22: and LANGUAGE = userenv('LANG')
23: ;
24: begin
25: insert into SY_PARA_CDS_TL (
26: TABLE_NAME,
27: LANG_CODE,
28: PARAGRAPH_CODE,
29: SUB_PARACODE,

Line 57: from SY_PARA_CDS_TL T

53: from FND_LANGUAGES L
54: where L.INSTALLED_FLAG in ('I', 'B')
55: and not exists
56: (select NULL
57: from SY_PARA_CDS_TL T
58: where T.TABLE_NAME = X_TABLE_NAME
59: and T.LANG_CODE = X_LANG_CODE
60: and T.PARAGRAPH_CODE = X_PARAGRAPH_CODE
61: and T.SUB_PARACODE = X_SUB_PARACODE

Line 86: from SY_PARA_CDS_TL

82: cursor c1 is select
83: NONPRINTABLE_IND,
84: PARA_DESC,
85: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
86: from SY_PARA_CDS_TL
87: where TABLE_NAME = X_TABLE_NAME
88: and LANG_CODE = X_LANG_CODE
89: and PARAGRAPH_CODE = X_PARAGRAPH_CODE
90: and SUB_PARACODE = X_SUB_PARACODE

Line 121: update SY_PARA_CDS_TL set

117: X_LAST_UPDATED_BY in NUMBER,
118: X_LAST_UPDATE_LOGIN in NUMBER
119: ) is
120: begin
121: update SY_PARA_CDS_TL set
122: NONPRINTABLE_IND = X_NONPRINTABLE_IND,
123: PARA_DESC = X_PARA_DESC,
124: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
125: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 146: delete from SY_PARA_CDS_TL

142: X_PARAGRAPH_CODE in VARCHAR2,
143: X_SUB_PARACODE in NUMBER
144: ) is
145: begin
146: delete from SY_PARA_CDS_TL
147: where TABLE_NAME = X_TABLE_NAME
148: and LANG_CODE = X_LANG_CODE
149: and PARAGRAPH_CODE = X_PARAGRAPH_CODE
150: and SUB_PARACODE = X_SUB_PARACODE;

Line 161: update SY_PARA_CDS_TL T set (

157:
158: procedure ADD_LANGUAGE
159: is
160: begin
161: update SY_PARA_CDS_TL T set (
162: PARA_DESC
163: ) = (select
164: B.PARA_DESC
165: from SY_PARA_CDS_TL B

Line 165: from SY_PARA_CDS_TL B

161: update SY_PARA_CDS_TL T set (
162: PARA_DESC
163: ) = (select
164: B.PARA_DESC
165: from SY_PARA_CDS_TL B
166: where B.TABLE_NAME = T.TABLE_NAME
167: and B.LANG_CODE = T.LANG_CODE
168: and B.PARAGRAPH_CODE = T.PARAGRAPH_CODE
169: and B.SUB_PARACODE = T.SUB_PARACODE

Line 183: from SY_PARA_CDS_TL SUBB, SY_PARA_CDS_TL SUBT

179: SUBT.LANG_CODE,
180: SUBT.PARAGRAPH_CODE,
181: SUBT.SUB_PARACODE,
182: SUBT.LANGUAGE
183: from SY_PARA_CDS_TL SUBB, SY_PARA_CDS_TL SUBT
184: where SUBB.TABLE_NAME = SUBT.TABLE_NAME
185: and SUBB.LANG_CODE = SUBT.LANG_CODE
186: and SUBB.PARAGRAPH_CODE = SUBT.PARAGRAPH_CODE
187: and SUBB.SUB_PARACODE = SUBT.SUB_PARACODE

Line 192: insert into SY_PARA_CDS_TL (

188: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
189: and (SUBB.PARA_DESC <> SUBT.PARA_DESC
190: ));
191:
192: insert into SY_PARA_CDS_TL (
193: TABLE_NAME,
194: LANG_CODE,
195: PARAGRAPH_CODE,
196: SUB_PARACODE,

Line 220: from SY_PARA_CDS_TL B, FND_LANGUAGES L

216: B.LAST_UPDATED_BY,
217: B.LAST_UPDATE_LOGIN,
218: L.LANGUAGE_CODE,
219: B.SOURCE_LANG
220: from SY_PARA_CDS_TL B, FND_LANGUAGES L
221: where L.INSTALLED_FLAG in ('I', 'B')
222: and B.LANGUAGE = userenv('LANG')
223: and not exists
224: (select NULL

Line 225: from SY_PARA_CDS_TL T

221: where L.INSTALLED_FLAG in ('I', 'B')
222: and B.LANGUAGE = userenv('LANG')
223: and not exists
224: (select NULL
225: from SY_PARA_CDS_TL T
226: where T.TABLE_NAME = B.TABLE_NAME
227: and T.LANG_CODE = B.LANG_CODE
228: and T.PARAGRAPH_CODE = B.PARAGRAPH_CODE
229: and T.SUB_PARACODE = B.SUB_PARACODE

Line 240: update SY_PARA_CDS_TL set

236: X_SUB_PARACODE in NUMBER,
237: X_PARA_DESC in VARCHAR2
238: ) IS
239: BEGIN
240: update SY_PARA_CDS_TL set
241: PARA_DESC = X_PARA_DESC,
242: SOURCE_LANG = userenv('LANG'),
243: LAST_UPDATE_DATE = sysdate,
244: LAST_UPDATED_BY = 0,