APPS.GL_JE_CATEGORIES_PKG dependencies on FND_DOC_SEQUENCE_CATEGORIES

Line 147: FROM fnd_doc_sequence_categories fcat

143: x_created_by NUMBER,
144: x_last_update_login NUMBER ) IS
145: CURSOR c_dup IS
146: SELECT 'Duplicate'
147: FROM fnd_doc_sequence_categories fcat
148: WHERE fcat.application_id = 101
149: AND fcat.code = x_je_category_name ;
150: dummy VARCHAR2(100);
151:

Line 157: INSERT INTO fnd_doc_sequence_categories (

153: OPEN c_dup;
154: FETCH c_dup INTO dummy;
155:
156: IF c_dup%NOTFOUND THEN
157: INSERT INTO fnd_doc_sequence_categories (
158: application_id, last_update_date, last_updated_by,
159: code, name, description,
160: table_name, created_by, creation_date,
161: last_update_login )

Line 190: FROM fnd_doc_sequence_categories fcat

186: x_description VARCHAR2,
187: x_last_updated_by NUMBER ) IS
188: CURSOR c_dup IS
189: SELECT 'Duplicate'
190: FROM fnd_doc_sequence_categories fcat
191: WHERE fcat.application_id = 101
192: AND fcat.code = x_je_category_name ;
193: dummy VARCHAR2(100);
194:

Line 200: UPDATE fnd_doc_sequence_categories fcat

196: OPEN c_dup;
197: FETCH c_dup INTO dummy;
198:
199: IF c_dup%FOUND THEN
200: UPDATE fnd_doc_sequence_categories fcat
201: SET fcat.description = x_description,
202: fcat.last_update_date = sysdate,
203: fcat.last_updated_by = x_last_updated_by,
204: fcat.name = x_user_je_category_name

Line 229: UPDATE fnd_doc_sequence_categories fcat

225: dummy VARCHAR2(100);
226:
227: BEGIN
228:
229: UPDATE fnd_doc_sequence_categories fcat
230: SET ( fcat.description,
231: fcat.last_update_date,
232: fcat.last_updated_by,
233: fcat.name ) =

Line 244: fnd_doc_sequence_categories fcat2

240: AND gcat.je_category_name = fcat.code )
241: WHERE fcat.application_id = 101
242: and fcat.code in ( select fcat2.code
243: from gl_je_categories_tl gcat2,
244: fnd_doc_sequence_categories fcat2
245: where gcat2.language = FND_GLOBAL.BASE_LANGUAGE
246: AND fcat2.application_id = 101
247: AND gcat2.je_category_name = fcat2.code
248: AND ( gcat2.user_je_category_name <> fcat2.name

Line 637: -- update FND_DOC_SEQUENCE_CATEGORIES if change is made in

633: X_Attribute5 => V_Attribute5,
634: X_context => V_Context,
635: X_Consolidation_Flag => null);
636:
637: -- update FND_DOC_SEQUENCE_CATEGORIES if change is made in
638: -- the base language
639: if ( userenv('LANG') = FND_GLOBAL.BASE_LANGUAGE ) then
640: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,
641: x_user_je_category_name,

Line 698: -- update FND_DOC_SEQUENCE_CATEGORIES if change is made in

694: source_lang = userenv('LANG')
695: WHERE userenv('LANG') in (LANGUAGE, SOURCE_LANG)
696: and je_category_name = X_je_category_name;
697:
698: -- update FND_DOC_SEQUENCE_CATEGORIES if change is made in
699: -- the base language
700: if ( userenv('LANG') = FND_GLOBAL.BASE_LANGUAGE ) then
701: GL_JE_CATEGORIES_PKG.update_fnd_cat( x_je_category_name,
702: x_user_je_category_name,