APPS.GL_MANAGEMENT_SEGMENT_UPGRADE dependencies on GL_MGT_SEG_UPGRADE_H

Line 138: -- Check existing record in GL_MGT_SEG_UPGRADE_H

134: END IF;
135:
136: GL_MESSAGE.write_log('SHRD0209', 1, 'USERLOCK', lock_name);
137:
138: -- Check existing record in GL_MGT_SEG_UPGRADE_H
139: SELECT decode(min(chart_of_accounts_id), null, 'N', 'Y'),
140: min(mgt_seg_column_name),
141: min(assign_complete_flag)
142: INTO rerun_flag, l_mgt_seg_column_name, l_assign_complete_flag

Line 143: FROM GL_MGT_SEG_UPGRADE_H

139: SELECT decode(min(chart_of_accounts_id), null, 'N', 'Y'),
140: min(mgt_seg_column_name),
141: min(assign_complete_flag)
142: INTO rerun_flag, l_mgt_seg_column_name, l_assign_complete_flag
143: FROM GL_MGT_SEG_UPGRADE_H
144: WHERE chart_of_accounts_id = X_Chart_Of_Accounts_Id;
145:
146: -- If the upgrade is complate for the COA, or the management segment
147: -- selected is different, stop

Line 165: INSERT INTO GL_MGT_SEG_UPGRADE_H

161: RAISE get_sequence_error;
162: END;
163:
164: IF (rerun_flag = 'N') THEN
165: INSERT INTO GL_MGT_SEG_UPGRADE_H
166: (chart_of_accounts_id,
167: mgt_seg_column_name,
168: assign_complete_flag,
169: max_processed_batch_id,

Line 188: UPDATE GL_MGT_SEG_UPGRADE_H

184: sysdate,
185: l_user_id,
186: l_login_id);
187: ELSE
188: UPDATE GL_MGT_SEG_UPGRADE_H
189: SET max_batch_id = new_max_batch_id
190: WHERE chart_of_accounts_id = X_Chart_Of_Accounts_Id;
191: END IF;
192:

Line 274: -- Check the record in GL_MGT_SEG_UPGRADE_H

270:
271: l_user_id := FND_GLOBAL.user_id;
272: l_login_id := FND_GLOBAL.login_id;
273:
274: -- Check the record in GL_MGT_SEG_UPGRADE_H
275: SELECT min(assign_complete_flag),
276: min(mgt_seg_column_name),
277: nvl(min(max_processed_batch_id), 0),
278: min(max_batch_id)

Line 281: FROM GL_MGT_SEG_UPGRADE_H

277: nvl(min(max_processed_batch_id), 0),
278: min(max_batch_id)
279: INTO l_assign_complete_flag, l_mgt_seg_column_name,
280: l_max_proc_batch_id, l_max_batch_id
281: FROM GL_MGT_SEG_UPGRADE_H
282: WHERE chart_of_accounts_id = X_Chart_Of_Accounts_Id;
283:
284: IF (l_assign_complete_flag <> 'N') THEN
285: RAISE assign_complete_error;

Line 487: UPDATE GL_MGT_SEG_UPGRADE_H

483: 'SEGMENT30', cc.segment30);
484:
485: l_max_proc_batch_id := high_batch_id;
486:
487: UPDATE GL_MGT_SEG_UPGRADE_H
488: SET max_processed_batch_id = high_batch_id
489: WHERE chart_of_accounts_id = X_Chart_Of_Accounts_Id;
490:
491: COMMIT;

Line 545: -- Check the record in GL_MGT_SEG_UPGRADE_H

541:
542: l_user_id := FND_GLOBAL.user_id;
543: l_login_id := FND_GLOBAL.login_id;
544:
545: -- Check the record in GL_MGT_SEG_UPGRADE_H
546: SELECT min(mgt_seg_column_name),
547: min(assign_complete_flag),
548: min(max_processed_batch_id)
549: INTO l_mgt_seg_column_name, l_assign_complete_flag, l_max_proc_batch_id

Line 550: FROM GL_MGT_SEG_UPGRADE_H

546: SELECT min(mgt_seg_column_name),
547: min(assign_complete_flag),
548: min(max_processed_batch_id)
549: INTO l_mgt_seg_column_name, l_assign_complete_flag, l_max_proc_batch_id
550: FROM GL_MGT_SEG_UPGRADE_H
551: WHERE chart_of_accounts_id = X_Chart_Of_Accounts_id;
552:
553: IF (l_assign_complete_flag <> 'N') THEN
554: RAISE assign_complete_error;

Line 757: UPDATE GL_MGT_SEG_UPGRADE_H

753: mgt_seg_value_set_id = segment.value_set_id
754: WHERE chart_of_accounts_id = X_Chart_Of_Accounts_Id;
755:
756: -- Assignment completed
757: UPDATE GL_MGT_SEG_UPGRADE_H
758: SET assign_complete_flag = 'Y',
759: max_processed_batch_id = null,
760: max_batch_id = null
761: WHERE chart_of_accounts_id = X_Chart_Of_Accounts_Id;