APPS.AR_DUNNING_LETTERS_CUSTOM_PKG dependencies on AR_DUNNING_LETTERS_CUSTOM_TL

Line 14: cursor C is select ROWID from AR_DUNNING_LETTERS_CUSTOM_TL

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from AR_DUNNING_LETTERS_CUSTOM_TL
15: where DUNNING_LETTER_ID = X_DUNNING_LETTER_ID
16: and PARAGRAPH_NUMBER = X_PARAGRAPH_NUMBER
17: and LANGUAGE = userenv('LANG')
18: ;

Line 20: insert into AR_DUNNING_LETTERS_CUSTOM_TL (

16: and PARAGRAPH_NUMBER = X_PARAGRAPH_NUMBER
17: and LANGUAGE = userenv('LANG')
18: ;
19: begin
20: insert into AR_DUNNING_LETTERS_CUSTOM_TL (
21: DUNNING_LETTER_ID,
22: PARAGRAPH_NUMBER,
23: PARAGRAPH_TEXT,
24: LAST_UPDATE_DATE,

Line 46: from AR_DUNNING_LETTERS_CUSTOM_TL T

42: from FND_LANGUAGES L
43: where L.INSTALLED_FLAG in ('I', 'B')
44: and not exists
45: (select NULL
46: from AR_DUNNING_LETTERS_CUSTOM_TL T
47: where T.DUNNING_LETTER_ID = X_DUNNING_LETTER_ID
48: and T.PARAGRAPH_NUMBER = X_PARAGRAPH_NUMBER
49: and T.LANGUAGE = L.LANGUAGE_CODE);
50:

Line 69: from AR_DUNNING_LETTERS_CUSTOM_TL

65: ) is
66: cursor c1 is select
67: PARAGRAPH_TEXT,
68: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
69: from AR_DUNNING_LETTERS_CUSTOM_TL
70: where DUNNING_LETTER_ID = X_DUNNING_LETTER_ID
71: and PARAGRAPH_NUMBER = X_PARAGRAPH_NUMBER
72: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
73: for update of DUNNING_LETTER_ID nowait;

Line 99: update AR_DUNNING_LETTERS_CUSTOM_TL set

95: X_LAST_UPDATED_BY in NUMBER,
96: X_LAST_UPDATE_LOGIN in NUMBER
97: ) is
98: begin
99: update AR_DUNNING_LETTERS_CUSTOM_TL set
100: PARAGRAPH_TEXT = X_PARAGRAPH_TEXT,
101: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
102: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
103: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 119: delete from AR_DUNNING_LETTERS_CUSTOM_TL

115: X_DUNNING_LETTER_ID in NUMBER,
116: X_PARAGRAPH_NUMBER in NUMBER
117: ) is
118: begin
119: delete from AR_DUNNING_LETTERS_CUSTOM_TL
120: where DUNNING_LETTER_ID = X_DUNNING_LETTER_ID
121: and PARAGRAPH_NUMBER = X_PARAGRAPH_NUMBER;
122:
123: if (sql%notfound) then

Line 132: update AR_DUNNING_LETTERS_CUSTOM_TL T set (

128:
129: procedure ADD_LANGUAGE
130: is
131: begin
132: update AR_DUNNING_LETTERS_CUSTOM_TL T set (
133: PARAGRAPH_TEXT
134: ) = (select
135: B.PARAGRAPH_TEXT
136: from AR_DUNNING_LETTERS_CUSTOM_TL B

Line 136: from AR_DUNNING_LETTERS_CUSTOM_TL B

132: update AR_DUNNING_LETTERS_CUSTOM_TL T set (
133: PARAGRAPH_TEXT
134: ) = (select
135: B.PARAGRAPH_TEXT
136: from AR_DUNNING_LETTERS_CUSTOM_TL B
137: where B.DUNNING_LETTER_ID = T.DUNNING_LETTER_ID
138: and B.PARAGRAPH_NUMBER = T.PARAGRAPH_NUMBER
139: and B.LANGUAGE = T.SOURCE_LANG)
140: where (

Line 148: from AR_DUNNING_LETTERS_CUSTOM_TL SUBB, AR_DUNNING_LETTERS_CUSTOM_TL SUBT

144: ) in (select
145: SUBT.DUNNING_LETTER_ID,
146: SUBT.PARAGRAPH_NUMBER,
147: SUBT.LANGUAGE
148: from AR_DUNNING_LETTERS_CUSTOM_TL SUBB, AR_DUNNING_LETTERS_CUSTOM_TL SUBT
149: where SUBB.DUNNING_LETTER_ID = SUBT.DUNNING_LETTER_ID
150: and SUBB.PARAGRAPH_NUMBER = SUBT.PARAGRAPH_NUMBER
151: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
152: and (SUBB.PARAGRAPH_TEXT <> SUBT.PARAGRAPH_TEXT

Line 157: insert into AR_DUNNING_LETTERS_CUSTOM_TL (

153: or (SUBB.PARAGRAPH_TEXT is null and SUBT.PARAGRAPH_TEXT is not null)
154: or (SUBB.PARAGRAPH_TEXT is not null and SUBT.PARAGRAPH_TEXT is null)
155: ));
156:
157: insert into AR_DUNNING_LETTERS_CUSTOM_TL (
158: DUNNING_LETTER_ID,
159: PARAGRAPH_NUMBER,
160: PARAGRAPH_TEXT,
161: LAST_UPDATE_DATE,

Line 179: from AR_DUNNING_LETTERS_CUSTOM_TL B, FND_LANGUAGES L

175: B.LAST_UPDATED_BY,
176: B.LAST_UPDATE_LOGIN,
177: L.LANGUAGE_CODE,
178: B.SOURCE_LANG
179: from AR_DUNNING_LETTERS_CUSTOM_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 AR_DUNNING_LETTERS_CUSTOM_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 AR_DUNNING_LETTERS_CUSTOM_TL T
185: where T.DUNNING_LETTER_ID = B.DUNNING_LETTER_ID
186: and T.PARAGRAPH_NUMBER = B.PARAGRAPH_NUMBER
187: and T.LANGUAGE = L.LANGUAGE_CODE);
188: end ADD_LANGUAGE;

Line 238: update AR_DUNNING_LETTERS_CUSTOM_TL

234: begin
235:
236: -- only update rows that have not been altered by user
237:
238: update AR_DUNNING_LETTERS_CUSTOM_TL
239: set paragraph_text = X_PARAGRAPH_TEXT,
240: source_lang = userenv('LANG'),
241: last_update_date = sysdate,
242: last_updated_by = fnd_load_util.owner_id(X_OWNER),