DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_COST_OBJECTS_HIER_S

Line 4112: fem_cost_objects_hier_s.NEXTVAL,

4108: FROM fem_object_definition_b
4109: WHERE object_definition_id = p_src_hier_version_id ;
4110:
4111: SELECT fcoh.rowid,
4112: fem_cost_objects_hier_s.NEXTVAL,
4113: effective_start_date,
4114: parent_id,
4115: child_id,
4116: child_sequence_num,

Line 7704: SELECT fem_cost_objects_hier_s.NEXTVAL

7700: l_effective_end_date := TO_DATE('01/01/2500', 'MM/DD/YYYY');
7701:
7702: END IF;
7703:
7704: SELECT fem_cost_objects_hier_s.NEXTVAL
7705: INTO l_new_relationship_id
7706: FROM dual;
7707:
7708: INSERT INTO fem_cost_objects_hier

Line 8263: SELECT fem_cost_objects_hier_s.NEXTVAL

8259: FOR l_all_children_rec IN l_all_children_csr
8260: (c_hierarchy_id => p_hierarchy_id,
8261: c_parent_id => l_parent_id) LOOP
8262:
8263: SELECT fem_cost_objects_hier_s.NEXTVAL
8264: INTO l_new_relationship_id
8265: FROM dual;
8266:
8267: INSERT INTO fem_cost_objects_hier

Line 8304: SELECT fem_cost_objects_hier_s.NEXTVAL

8300: END LOOP;
8301:
8302: ELSE
8303:
8304: SELECT fem_cost_objects_hier_s.NEXTVAL
8305: INTO l_new_relationship_id
8306: FROM dual;
8307:
8308: INSERT INTO fem_cost_objects_hier