528: lock_op_succeeded BOOLEAN;
529:
530: struct_code VARCHAR2(30);
531: seg_name VARCHAR2(30);
532: flexfield FND_FLEX_KEY_API.flexfield_type;
533: structure FND_FLEX_KEY_API.structure_type;
534: segment FND_FLEX_KEY_API.segment_type;
535:
536: request_id NUMBER;
529:
530: struct_code VARCHAR2(30);
531: seg_name VARCHAR2(30);
532: flexfield FND_FLEX_KEY_API.flexfield_type;
533: structure FND_FLEX_KEY_API.structure_type;
534: segment FND_FLEX_KEY_API.segment_type;
535:
536: request_id NUMBER;
537:
530: struct_code VARCHAR2(30);
531: seg_name VARCHAR2(30);
532: flexfield FND_FLEX_KEY_API.flexfield_type;
533: structure FND_FLEX_KEY_API.structure_type;
534: segment FND_FLEX_KEY_API.segment_type;
535:
536: request_id NUMBER;
537:
538: max_processed_error EXCEPTION;
739: AND sg.id_flex_num = X_Chart_Of_Accounts_Id
740: AND sg.application_column_name = l_mgt_seg_column_name;
741:
742: -- Setup FND info and assign the management segment qualifier
743: FND_FLEX_KEY_API.set_session_mode('customer_data');
744: flexfield := FND_FLEX_KEY_API.find_flexfield('SQLGL', 'GL#');
745: structure := FND_FLEX_KEY_API.find_structure(flexfield, struct_code);
746: segment := FND_FLEX_KEY_API.find_segment(flexfield, structure, seg_name);
747: FND_FLEX_KEY_API.assign_qualifier(flexfield, structure, segment,
740: AND sg.application_column_name = l_mgt_seg_column_name;
741:
742: -- Setup FND info and assign the management segment qualifier
743: FND_FLEX_KEY_API.set_session_mode('customer_data');
744: flexfield := FND_FLEX_KEY_API.find_flexfield('SQLGL', 'GL#');
745: structure := FND_FLEX_KEY_API.find_structure(flexfield, struct_code);
746: segment := FND_FLEX_KEY_API.find_segment(flexfield, structure, seg_name);
747: FND_FLEX_KEY_API.assign_qualifier(flexfield, structure, segment,
748: 'GL_MANAGEMENT', 'Y');
741:
742: -- Setup FND info and assign the management segment qualifier
743: FND_FLEX_KEY_API.set_session_mode('customer_data');
744: flexfield := FND_FLEX_KEY_API.find_flexfield('SQLGL', 'GL#');
745: structure := FND_FLEX_KEY_API.find_structure(flexfield, struct_code);
746: segment := FND_FLEX_KEY_API.find_segment(flexfield, structure, seg_name);
747: FND_FLEX_KEY_API.assign_qualifier(flexfield, structure, segment,
748: 'GL_MANAGEMENT', 'Y');
749:
742: -- Setup FND info and assign the management segment qualifier
743: FND_FLEX_KEY_API.set_session_mode('customer_data');
744: flexfield := FND_FLEX_KEY_API.find_flexfield('SQLGL', 'GL#');
745: structure := FND_FLEX_KEY_API.find_structure(flexfield, struct_code);
746: segment := FND_FLEX_KEY_API.find_segment(flexfield, structure, seg_name);
747: FND_FLEX_KEY_API.assign_qualifier(flexfield, structure, segment,
748: 'GL_MANAGEMENT', 'Y');
749:
750: -- Update GL_LEDGERS
743: FND_FLEX_KEY_API.set_session_mode('customer_data');
744: flexfield := FND_FLEX_KEY_API.find_flexfield('SQLGL', 'GL#');
745: structure := FND_FLEX_KEY_API.find_structure(flexfield, struct_code);
746: segment := FND_FLEX_KEY_API.find_segment(flexfield, structure, seg_name);
747: FND_FLEX_KEY_API.assign_qualifier(flexfield, structure, segment,
748: 'GL_MANAGEMENT', 'Y');
749:
750: -- Update GL_LEDGERS
751: UPDATE GL_LEDGERS