APPS.GL_MANAGEMENT_SEGMENT_UPGRADE dependencies on GL_JE_BATCHES

Line 111: -- Check je_batch_id in gl_je_batches table in order or not.

107:
108: l_user_id := FND_GLOBAL.user_id;
109: l_login_id := FND_GLOBAL.login_id;
110:
111: -- Check je_batch_id in gl_je_batches table in order or not.
112: IF (FND_INSTALLATION.get_app_info('SQLGL', status, industry, schema)) THEN
113:
114: SELECT order_flag
115: INTO seq_in_order

Line 118: AND sequence_name = 'GL_JE_BATCHES_S';

114: SELECT order_flag
115: INTO seq_in_order
116: FROM dba_sequences
117: WHERE sequence_owner = schema
118: AND sequence_name = 'GL_JE_BATCHES_S';
119:
120: IF (seq_in_order = 'N') THEN
121: RAISE sequence_order_error;
122: END IF;

Line 156: SELECT GL_JE_BATCHES_S.nextval

152: END IF;
153:
154: -- Get a new max_batch_id and insert/update the history record
155: BEGIN
156: SELECT GL_JE_BATCHES_S.nextval
157: INTO new_max_batch_id
158: FROM dual;
159: EXCEPTION
160: WHEN others THEN

Line 220: 'SEQUENCE', 'GL_JE_BATCHES_S');

216: X_Retcode := '2';
217: WHEN get_sequence_error THEN
218: lock_op_succeeded := release_lock(X_Chart_Of_Accounts_Id);
219: GL_MESSAGE.write_log('SHRD0050', 2, 'ROUTINE', fn_name,
220: 'SEQUENCE', 'GL_JE_BATCHES_S');
221: GL_MESSAGE.func_fail(api_name || '.' || fn_name);
222: X_Retcode := '2';
223: WHEN user_lock_error THEN
224: GL_MESSAGE.write_log('MGTS0005', 1, 'USERLOCK', lock_name);

Line 294: GL_JE_BATCHES B

290: INSERT INTO GL_MGT_SEG_UPGRADE_GT
291: (je_batch_id)
292: SELECT msu.je_batch_id
293: FROM GL_MGT_SEG_UPGRADE MSU,
294: GL_JE_BATCHES B
295: WHERE msu.chart_of_accounts_id = X_Chart_Of_Accounts_Id
296: AND b.je_batch_id = msu.je_batch_id
297: AND b.status || '' = 'P';
298:

Line 397: FROM GL_JE_BATCHES B

393: (chart_of_accounts_id, je_batch_id, creation_date,
394: created_by, last_update_date, last_updated_by, last_update_login)
395: SELECT b.chart_of_accounts_id, b.je_batch_id,
396: sysdate, l_user_id, sysdate, l_user_id, l_login_id
397: FROM GL_JE_BATCHES B
398: WHERE b.je_batch_id BETWEEN low_batch_id AND high_batch_id
399: AND b.status <> 'P'
400: AND b.chart_of_accounts_id = X_Chart_Of_Accounts_Id;
401:

Line 437: FROM GL_JE_BATCHES B,

433: 'SEGMENT28', cc.segment28,
434: 'SEGMENT29', cc.segment29,
435: 'SEGMENT30', cc.segment30),
436: sysdate, l_user_id, sysdate, l_user_id, l_login_id
437: FROM GL_JE_BATCHES B,
438: GL_JE_HEADERS H,
439: GL_JE_LINES L,
440: GL_CODE_COMBINATIONS CC
441: WHERE b.je_batch_id BETWEEN low_batch_id AND high_batch_id

Line 685: FROM GL_JE_BATCHES B,

681: 'SEGMENT28', cc.segment28,
682: 'SEGMENT29', cc.segment29,
683: 'SEGMENT30', cc.segment30),
684: sysdate, l_user_id, sysdate, l_user_id, l_login_id
685: FROM GL_JE_BATCHES B,
686: GL_JE_HEADERS H,
687: GL_JE_LINES L,
688: GL_CODE_COMBINATIONS CC
689: WHERE b.je_batch_id > l_max_proc_batch_id