APPS.FTP_PAYMENT_PATTERN_PKG dependencies on FTP_PAYMENT_PATTERN_TL

Line 42: insert into FTP_PAYMENT_PATTERN_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into FTP_PAYMENT_PATTERN_TL (
43: OBJECT_VERSION_NUMBER,
44: DESCRIPTION,
45: CREATION_DATE,
46: CREATED_BY,

Line 70: from FTP_PAYMENT_PATTERN_TL T

66: from FND_LANGUAGES L
67: where L.INSTALLED_FLAG in ('I', 'B')
68: and not exists
69: (select NULL
70: from FTP_PAYMENT_PATTERN_TL T
71: where T.PAYMENT_ID = X_PAYMENT_ID
72: and T.LANGUAGE = L.LANGUAGE_CODE);
73:
74: open c;

Line 103: from FTP_PAYMENT_PATTERN_TL

99:
100: cursor c1 is select
101: DESCRIPTION,
102: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
103: from FTP_PAYMENT_PATTERN_TL
104: where PAYMENT_ID = X_PAYMENT_ID
105: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
106: for update of PAYMENT_ID nowait;
107: begin

Line 166: update FTP_PAYMENT_PATTERN_TL set

162: if (sql%notfound) then
163: raise no_data_found;
164: end if;
165:
166: update FTP_PAYMENT_PATTERN_TL set
167: DESCRIPTION = X_DESCRIPTION,
168: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
169: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
170: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 184: delete from FTP_PAYMENT_PATTERN_TL

180: procedure DELETE_ROW (
181: X_PAYMENT_ID in NUMBER
182: ) is
183: begin
184: delete from FTP_PAYMENT_PATTERN_TL
185: where PAYMENT_ID = X_PAYMENT_ID;
186:
187: if (sql%notfound) then
188: raise no_data_found;

Line 202: delete from FTP_PAYMENT_PATTERN_TL T

198:
199: procedure ADD_LANGUAGE
200: is
201: begin
202: delete from FTP_PAYMENT_PATTERN_TL T
203: where not exists
204: (select NULL
205: from FTP_PAYMENT_PATTERN_B B
206: where B.PAYMENT_ID = T.PAYMENT_ID

Line 209: update FTP_PAYMENT_PATTERN_TL T set (

205: from FTP_PAYMENT_PATTERN_B B
206: where B.PAYMENT_ID = T.PAYMENT_ID
207: );
208:
209: update FTP_PAYMENT_PATTERN_TL T set (
210: DESCRIPTION
211: ) = (select
212: B.DESCRIPTION
213: from FTP_PAYMENT_PATTERN_TL B

Line 213: from FTP_PAYMENT_PATTERN_TL B

209: update FTP_PAYMENT_PATTERN_TL T set (
210: DESCRIPTION
211: ) = (select
212: B.DESCRIPTION
213: from FTP_PAYMENT_PATTERN_TL B
214: where B.PAYMENT_ID = T.PAYMENT_ID
215: and B.LANGUAGE = T.SOURCE_LANG)
216: where (
217: T.PAYMENT_ID,

Line 222: from FTP_PAYMENT_PATTERN_TL SUBB, FTP_PAYMENT_PATTERN_TL SUBT

218: T.LANGUAGE
219: ) in (select
220: SUBT.PAYMENT_ID,
221: SUBT.LANGUAGE
222: from FTP_PAYMENT_PATTERN_TL SUBB, FTP_PAYMENT_PATTERN_TL SUBT
223: where SUBB.PAYMENT_ID = SUBT.PAYMENT_ID
224: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
225: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
226: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 230: insert into FTP_PAYMENT_PATTERN_TL (

226: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
227: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
228: ));
229:
230: insert into FTP_PAYMENT_PATTERN_TL (
231: OBJECT_VERSION_NUMBER,
232: DESCRIPTION,
233: CREATION_DATE,
234: CREATED_BY,

Line 254: from FTP_PAYMENT_PATTERN_TL B, FND_LANGUAGES L

250: B.PAYMENT_ID,
251: B.AMRT_TYPE_CODE,
252: L.LANGUAGE_CODE,
253: B.SOURCE_LANG
254: from FTP_PAYMENT_PATTERN_TL B, FND_LANGUAGES L
255: where L.INSTALLED_FLAG in ('I', 'B')
256: and B.LANGUAGE = userenv('LANG')
257: and not exists
258: (select NULL

Line 259: from FTP_PAYMENT_PATTERN_TL T

255: where L.INSTALLED_FLAG in ('I', 'B')
256: and B.LANGUAGE = userenv('LANG')
257: and not exists
258: (select NULL
259: from FTP_PAYMENT_PATTERN_TL T
260: where T.PAYMENT_ID = B.PAYMENT_ID
261: and T.LANGUAGE = L.LANGUAGE_CODE);
262: end ADD_LANGUAGE;
263: