eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_COST_OBJECTS

Line 2506: FROM fem_cost_objects_hier

2502: IS
2503: SELECT parent_id,
2504: child_id,
2505: child_sequence_num
2506: FROM fem_cost_objects_hier
2507: WHERE hierarchy_obj_id = c_hierarchy_id
2508: AND c_dest_version_start_date
2509: BETWEEN effective_start_date AND effective_end_date
2510: MINUS

Line 2514: FROM fem_cost_objects_hier

2510: MINUS
2511: SELECT parent_id,
2512: child_id,
2513: child_sequence_num
2514: FROM fem_cost_objects_hier
2515: WHERE hierarchy_obj_id = c_hierarchy_id
2516: AND c_src_version_start_date
2517: BETWEEN effective_start_date AND effective_end_date;
2518:

Line 2535: FROM fem_cost_objects_hier fcoh,

2531: bom_reference,
2532: parent_qty,
2533: child_qty,
2534: yield_percentage
2535: FROM fem_cost_objects_hier fcoh,
2536: fem_cost_obj_hier_qty fcohq
2537: WHERE hierarchy_obj_id = c_hierarchy_id
2538: AND fcoh.relationship_id = fcohq.relationship_id
2539: AND c_src_version_start_date

Line 2549: FROM fem_cost_objects_hier fcoh,

2545: bom_reference,
2546: parent_qty,
2547: child_qty,
2548: yield_percentage
2549: FROM fem_cost_objects_hier fcoh,
2550: fem_cost_obj_hier_qty fcohq
2551: WHERE hierarchy_obj_id = c_hierarchy_id
2552: AND fcoh.relationship_id = fcohq.relationship_id
2553: AND c_dest_version_start_date

Line 2589: p_hier_table_name => 'FEM_COST_OBJECTS_HIER',

2585: p_version_id => p_dest_version_id,
2586: p_parent_id => l_dest_version_hier_data_rec.parent_id,
2587: p_child_id => l_dest_version_hier_data_rec.child_id,
2588: p_child_sequence_num => l_dest_version_hier_data_rec.child_sequence_num,
2589: p_hier_table_name => 'FEM_COST_OBJECTS_HIER',
2590: p_remove_all_children_flag => 'N');
2591:
2592: IF l_return_status = FND_API.G_RET_STS_ERROR
2593: THEN

Line 2621: p_hier_table_name => 'FEM_COST_OBJECTS_HIER');

2617: p_child_qty => l_src_version_hier_data_rec.child_qty,
2618: p_yield_pct => l_src_version_hier_data_rec.yield_percentage,
2619: p_bom_reference => l_src_version_hier_data_rec.bom_reference,
2620: p_display_order_num=>l_src_version_hier_data_rec.display_order_num,
2621: p_hier_table_name => 'FEM_COST_OBJECTS_HIER');
2622:
2623: IF l_return_status = FND_API.G_RET_STS_ERROR
2624: THEN
2625: RAISE FND_API.G_EXC_ERROR ;

Line 2701: TYPE t_co_relationship_id is TABLE OF fem_cost_objects_hier.relationship_id%TYPE;

2697: t_wt_pct t_weighting_pct;
2698:
2699: -- The following is for Cost Object Hierarchy Data.
2700: TYPE t_co_rowid is TABLE OF VARCHAR2(50);
2701: TYPE t_co_relationship_id is TABLE OF fem_cost_objects_hier.relationship_id%TYPE;
2702: TYPE t_co_effective_start_date is TABLE OF fem_cost_objects_hier.effective_start_date%TYPE;
2703: TYPE t_co_hierarchy_obj_id is TABLE OF fem_cost_objects_hier.hierarchy_obj_id%TYPE;
2704: TYPE t_co_parent_id is TABLE OF fem_cost_objects_hier.parent_id%TYPE;
2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;

Line 2702: TYPE t_co_effective_start_date is TABLE OF fem_cost_objects_hier.effective_start_date%TYPE;

2698:
2699: -- The following is for Cost Object Hierarchy Data.
2700: TYPE t_co_rowid is TABLE OF VARCHAR2(50);
2701: TYPE t_co_relationship_id is TABLE OF fem_cost_objects_hier.relationship_id%TYPE;
2702: TYPE t_co_effective_start_date is TABLE OF fem_cost_objects_hier.effective_start_date%TYPE;
2703: TYPE t_co_hierarchy_obj_id is TABLE OF fem_cost_objects_hier.hierarchy_obj_id%TYPE;
2704: TYPE t_co_parent_id is TABLE OF fem_cost_objects_hier.parent_id%TYPE;
2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;
2706: TYPE t_co_child_sequence_num is TABLE OF fem_cost_objects_hier.child_sequence_num%TYPE;

Line 2703: TYPE t_co_hierarchy_obj_id is TABLE OF fem_cost_objects_hier.hierarchy_obj_id%TYPE;

2699: -- The following is for Cost Object Hierarchy Data.
2700: TYPE t_co_rowid is TABLE OF VARCHAR2(50);
2701: TYPE t_co_relationship_id is TABLE OF fem_cost_objects_hier.relationship_id%TYPE;
2702: TYPE t_co_effective_start_date is TABLE OF fem_cost_objects_hier.effective_start_date%TYPE;
2703: TYPE t_co_hierarchy_obj_id is TABLE OF fem_cost_objects_hier.hierarchy_obj_id%TYPE;
2704: TYPE t_co_parent_id is TABLE OF fem_cost_objects_hier.parent_id%TYPE;
2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;
2706: TYPE t_co_child_sequence_num is TABLE OF fem_cost_objects_hier.child_sequence_num%TYPE;
2707: TYPE t_co_display_order_num is TABLE OF fem_cost_objects_hier.display_order_num%TYPE;

Line 2704: TYPE t_co_parent_id is TABLE OF fem_cost_objects_hier.parent_id%TYPE;

2700: TYPE t_co_rowid is TABLE OF VARCHAR2(50);
2701: TYPE t_co_relationship_id is TABLE OF fem_cost_objects_hier.relationship_id%TYPE;
2702: TYPE t_co_effective_start_date is TABLE OF fem_cost_objects_hier.effective_start_date%TYPE;
2703: TYPE t_co_hierarchy_obj_id is TABLE OF fem_cost_objects_hier.hierarchy_obj_id%TYPE;
2704: TYPE t_co_parent_id is TABLE OF fem_cost_objects_hier.parent_id%TYPE;
2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;
2706: TYPE t_co_child_sequence_num is TABLE OF fem_cost_objects_hier.child_sequence_num%TYPE;
2707: TYPE t_co_display_order_num is TABLE OF fem_cost_objects_hier.display_order_num%TYPE;
2708: TYPE t_co_effective_end_date is TABLE OF fem_cost_objects_hier.effective_end_date%TYPE;

Line 2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;

2701: TYPE t_co_relationship_id is TABLE OF fem_cost_objects_hier.relationship_id%TYPE;
2702: TYPE t_co_effective_start_date is TABLE OF fem_cost_objects_hier.effective_start_date%TYPE;
2703: TYPE t_co_hierarchy_obj_id is TABLE OF fem_cost_objects_hier.hierarchy_obj_id%TYPE;
2704: TYPE t_co_parent_id is TABLE OF fem_cost_objects_hier.parent_id%TYPE;
2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;
2706: TYPE t_co_child_sequence_num is TABLE OF fem_cost_objects_hier.child_sequence_num%TYPE;
2707: TYPE t_co_display_order_num is TABLE OF fem_cost_objects_hier.display_order_num%TYPE;
2708: TYPE t_co_effective_end_date is TABLE OF fem_cost_objects_hier.effective_end_date%TYPE;
2709: TYPE t_co_bom_reference is TABLE OF fem_cost_objects_hier.bom_reference%TYPE;

Line 2706: TYPE t_co_child_sequence_num is TABLE OF fem_cost_objects_hier.child_sequence_num%TYPE;

2702: TYPE t_co_effective_start_date is TABLE OF fem_cost_objects_hier.effective_start_date%TYPE;
2703: TYPE t_co_hierarchy_obj_id is TABLE OF fem_cost_objects_hier.hierarchy_obj_id%TYPE;
2704: TYPE t_co_parent_id is TABLE OF fem_cost_objects_hier.parent_id%TYPE;
2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;
2706: TYPE t_co_child_sequence_num is TABLE OF fem_cost_objects_hier.child_sequence_num%TYPE;
2707: TYPE t_co_display_order_num is TABLE OF fem_cost_objects_hier.display_order_num%TYPE;
2708: TYPE t_co_effective_end_date is TABLE OF fem_cost_objects_hier.effective_end_date%TYPE;
2709: TYPE t_co_bom_reference is TABLE OF fem_cost_objects_hier.bom_reference%TYPE;
2710:

Line 2707: TYPE t_co_display_order_num is TABLE OF fem_cost_objects_hier.display_order_num%TYPE;

2703: TYPE t_co_hierarchy_obj_id is TABLE OF fem_cost_objects_hier.hierarchy_obj_id%TYPE;
2704: TYPE t_co_parent_id is TABLE OF fem_cost_objects_hier.parent_id%TYPE;
2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;
2706: TYPE t_co_child_sequence_num is TABLE OF fem_cost_objects_hier.child_sequence_num%TYPE;
2707: TYPE t_co_display_order_num is TABLE OF fem_cost_objects_hier.display_order_num%TYPE;
2708: TYPE t_co_effective_end_date is TABLE OF fem_cost_objects_hier.effective_end_date%TYPE;
2709: TYPE t_co_bom_reference is TABLE OF fem_cost_objects_hier.bom_reference%TYPE;
2710:
2711: TYPE t_co_dataset_code is TABLE OF fem_cost_obj_hier_qty.dataset_code%TYPE;

Line 2708: TYPE t_co_effective_end_date is TABLE OF fem_cost_objects_hier.effective_end_date%TYPE;

2704: TYPE t_co_parent_id is TABLE OF fem_cost_objects_hier.parent_id%TYPE;
2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;
2706: TYPE t_co_child_sequence_num is TABLE OF fem_cost_objects_hier.child_sequence_num%TYPE;
2707: TYPE t_co_display_order_num is TABLE OF fem_cost_objects_hier.display_order_num%TYPE;
2708: TYPE t_co_effective_end_date is TABLE OF fem_cost_objects_hier.effective_end_date%TYPE;
2709: TYPE t_co_bom_reference is TABLE OF fem_cost_objects_hier.bom_reference%TYPE;
2710:
2711: TYPE t_co_dataset_code is TABLE OF fem_cost_obj_hier_qty.dataset_code%TYPE;
2712: TYPE t_co_cal_period_id is TABLE OF fem_cost_obj_hier_qty.cal_period_id%TYPE;

Line 2709: TYPE t_co_bom_reference is TABLE OF fem_cost_objects_hier.bom_reference%TYPE;

2705: TYPE t_co_child_id is TABLE OF fem_cost_objects_hier.child_id%TYPE;
2706: TYPE t_co_child_sequence_num is TABLE OF fem_cost_objects_hier.child_sequence_num%TYPE;
2707: TYPE t_co_display_order_num is TABLE OF fem_cost_objects_hier.display_order_num%TYPE;
2708: TYPE t_co_effective_end_date is TABLE OF fem_cost_objects_hier.effective_end_date%TYPE;
2709: TYPE t_co_bom_reference is TABLE OF fem_cost_objects_hier.bom_reference%TYPE;
2710:
2711: TYPE t_co_dataset_code is TABLE OF fem_cost_obj_hier_qty.dataset_code%TYPE;
2712: TYPE t_co_cal_period_id is TABLE OF fem_cost_obj_hier_qty.cal_period_id%TYPE;
2713: TYPE t_co_parent_qty is TABLE OF fem_cost_obj_hier_qty.parent_qty%TYPE;

Line 4104: elsif p_hier_table_name = 'FEM_COST_OBJECTS_HIER' then

4100: l_last_update_date,
4101: l_last_update_login,
4102: 1);
4103:
4104: elsif p_hier_table_name = 'FEM_COST_OBJECTS_HIER' then
4105:
4106: SELECT effective_start_date
4107: INTO l_version_start_date
4108: FROM fem_object_definition_b

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 4140: FROM fem_cost_objects_hier fcoh,

4136: t_co_cal_per_id,
4137: t_co_prnt_qty,
4138: t_co_chld_qty,
4139: t_co_yld_percentage
4140: FROM fem_cost_objects_hier fcoh,
4141: fem_cost_obj_hier_qty fcohq
4142: WHERE fcoh.relationship_id = fcohq.relationship_id
4143: AND hierarchy_obj_id = p_src_hier_obj_id
4144: AND l_version_start_date BETWEEN effective_start_date

Line 4149: INSERT INTO fem_cost_objects_hier

4145: AND effective_end_date;
4146:
4147: FORALL rec in t_co_row_id.FIRST..t_co_row_id.LAST
4148:
4149: INSERT INTO fem_cost_objects_hier
4150: (relationship_id,
4151: effective_start_date,
4152: hierarchy_obj_id,
4153: parent_id,

Line 5109: FROM fem_cost_objects_hier

5105: IS
5106: SELECT parent_id,
5107: child_id,
5108: child_sequence_num
5109: FROM fem_cost_objects_hier
5110: WHERE hierarchy_obj_id = c_hierarchy_id
5111: AND (SELECT effective_start_date
5112: FROM fem_object_definition_b
5113: WHERE object_definition_id = c_version_id) BETWEEN

Line 5151: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN

5147:
5148: DELETE FROM fem_hier_definitions
5149: WHERE hierarchy_obj_def_id = obj_def_rec.object_definition_id;
5150:
5151: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN
5152:
5153: DELETE FROM fem_cost_obj_hier_qty
5154: WHERE relationship_id IN (SELECT relationship_id
5155: FROM fem_cost_objects_hier

Line 5155: FROM fem_cost_objects_hier

5151: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN
5152:
5153: DELETE FROM fem_cost_obj_hier_qty
5154: WHERE relationship_id IN (SELECT relationship_id
5155: FROM fem_cost_objects_hier
5156: WHERE hierarchy_obj_id = p_hier_obj_id);
5157:
5158: DELETE FROM fem_cost_objects_hier
5159: WHERE hierarchy_obj_id = p_hier_obj_id;

Line 5158: DELETE FROM fem_cost_objects_hier

5154: WHERE relationship_id IN (SELECT relationship_id
5155: FROM fem_cost_objects_hier
5156: WHERE hierarchy_obj_id = p_hier_obj_id);
5157:
5158: DELETE FROM fem_cost_objects_hier
5159: WHERE hierarchy_obj_id = p_hier_obj_id;
5160:
5161: ELSE
5162:

Line 5193: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN

5189: ELSE
5190:
5191: -- If p_hier_version_id is not NULL then we want to delete the specific
5192: -- Hier. Version.
5193: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN
5194:
5195: FOR l_cost_obj_detail_rec IN
5196: l_cost_obj_detail_csr(c_hierarchy_id => p_hier_obj_id,
5197: c_version_id => p_hier_version_id)

Line 5209: p_hier_table_name => 'FEM_COST_OBJECTS_HIER',

5205: p_version_id => p_hier_version_id,
5206: p_parent_id => l_cost_obj_detail_rec.parent_id,
5207: p_child_id => l_cost_obj_detail_rec.child_id,
5208: p_child_sequence_num => l_cost_obj_detail_rec.child_sequence_num,
5209: p_hier_table_name => 'FEM_COST_OBJECTS_HIER',
5210: p_remove_all_children_flag => 'N');
5211:
5212: END LOOP;
5213:

Line 5221: END IF; -- p_hier_table_name = 'FEM_COST_OBJECTS_HIER'

5217: ' WHERE hierarchy_obj_def_id = '||p_hier_version_id;
5218:
5219: execute immediate l_sql_stmt;
5220:
5221: END IF; -- p_hier_table_name = 'FEM_COST_OBJECTS_HIER'
5222:
5223: DELETE FROM fem_hier_definitions
5224: WHERE hierarchy_obj_def_id = p_hier_version_id;
5225:

Line 7494: FROM fem_cost_objects_hier

7490: IS
7491: SELECT parent_id
7492: FROM (SELECT parent_id,
7493: child_id
7494: FROM fem_cost_objects_hier
7495: WHERE hierarchy_obj_id = c_hierarchy_id)
7496: START WITH child_id = c_child_id
7497: CONNECT BY PRIOR parent_id = child_id;
7498:

Line 7501: FROM fem_cost_objects_hier

7497: CONNECT BY PRIOR parent_id = child_id;
7498:
7499: /*
7500: SELECT parent_id
7501: FROM fem_cost_objects_hier
7502: WHERE hierarchy_obj_id = c_hierarchy_id
7503: START WITH child_id = c_child_id
7504: CONNECT BY PRIOR parent_id = child_id ;
7505: */

Line 7510: FROM fem_cost_objects

7506:
7507: CURSOR l_cost_object_csr(c_cost_object_id IN NUMBER)
7508: IS
7509: SELECT cost_object_display_code
7510: FROM fem_cost_objects
7511: WHERE cost_object_id = c_cost_object_id;
7512:
7513: BEGIN
7514:

Line 7658: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN

7654: END IF;
7655: ---- End: Bug#5895840
7656:
7657:
7658: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN
7659:
7660: OPEN l_is_first_version_csr(c_hierarchy_id => p_hierarchy_id);
7661: FETCH l_is_first_version_csr INTO l_is_first_version;
7662: CLOSE l_is_first_version_csr;

Line 7673: FROM fem_cost_objects_hier

7669: l_child_sequence_num := 1;
7670:
7671: FOR l_max_child_seq_num_rec IN
7672: ( SELECT NVL(MAX(child_sequence_num),0) child_sequence_num
7673: FROM fem_cost_objects_hier
7674: WHERE hierarchy_obj_id = p_hierarchy_id
7675: AND parent_id = p_parent_id
7676: AND child_id = p_child_id)
7677: LOOP

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 7708: INSERT INTO fem_cost_objects_hier

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
7709: (relationship_id,
7710: effective_start_date,
7711: hierarchy_obj_id,
7712: parent_id,

Line 7967: FROM fem_cost_objects_hier

7963: l_child_sequence_num NUMBER := 1;
7964: BEGIN
7965:
7966: FOR x_rec IN (SELECT child_sequence_num, parent_id, child_id
7967: FROM fem_cost_objects_hier
7968: WHERE hierarchy_obj_id = p_hierarchy_id
7969: AND parent_id = p_parent_id
7970: AND child_id = p_child_id
7971: AND p_curr_ver_start_date

Line 7977: UPDATE fem_cost_objects_hier

7973: ORDER BY child_sequence_num)
7974:
7975: LOOP
7976:
7977: UPDATE fem_cost_objects_hier
7978: SET child_sequence_num = l_child_sequence_num
7979: WHERE hierarchy_obj_id = p_hierarchy_id
7980: AND parent_id = x_rec.parent_id
7981: AND child_id = x_rec.child_id

Line 8062: FROM fem_cost_objects_hier

8058: CURSOR l_all_children_csr (c_hierarchy_id IN NUMBER,
8059: c_parent_id IN NUMBER)
8060: IS
8061: SELECT child_id, bom_reference, child_sequence_num, display_order_num
8062: FROM fem_cost_objects_hier
8063: WHERE hierarchy_obj_id = c_hierarchy_id
8064: AND parent_id = c_parent_id;
8065:
8066: BEGIN

Line 8083: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN

8079: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
8080: FND_MSG_PUB.initialize ;
8081: END IF;
8082:
8083: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN
8084:
8085: l_parent_id := p_parent_id;
8086: l_child_id := p_child_id;
8087: l_child_sequence_num := p_child_sequence_num;

Line 8145: UPDATE fem_cost_objects_hier

8141: IF l_later_version_exists = 'Y' THEN
8142:
8143: IF p_remove_all_children_flag = 'Y' THEN
8144:
8145: UPDATE fem_cost_objects_hier
8146: SET effective_start_date = l_curr_version_end_date + 1,
8147: last_update_date = g_current_date,
8148: last_updated_by = g_current_user_id,
8149: last_update_login = g_current_login_id,

Line 8158: UPDATE fem_cost_objects_hier

8154: BETWEEN effective_start_date AND effective_end_date;
8155:
8156: ELSE
8157:
8158: UPDATE fem_cost_objects_hier
8159: SET effective_start_date = l_curr_version_end_date + 1,
8160: last_update_date = g_current_date,
8161: last_updated_by = g_current_user_id,
8162: last_update_login = g_current_login_id,

Line 8177: DELETE FROM fem_cost_objects_hier

8173: ELSE -- l_later_version_exists = N
8174:
8175: IF p_remove_all_children_flag = 'Y' THEN
8176:
8177: DELETE FROM fem_cost_objects_hier
8178: WHERE hierarchy_obj_id = p_hierarchy_id
8179: AND parent_id = l_parent_id;
8180:
8181: DELETE FROM fem_cost_obj_hier_qty

Line 8183: FROM fem_cost_objects_hier

8179: AND parent_id = l_parent_id;
8180:
8181: DELETE FROM fem_cost_obj_hier_qty
8182: WHERE relationship_id = (SELECT relationship_id
8183: FROM fem_cost_objects_hier
8184: WHERE hierarchy_obj_id = p_hierarchy_id
8185: AND parent_id = l_parent_id);
8186:
8187: ELSE

Line 8189: DELETE FROM fem_cost_objects_hier

8185: AND parent_id = l_parent_id);
8186:
8187: ELSE
8188:
8189: DELETE FROM fem_cost_objects_hier
8190: WHERE hierarchy_obj_id = p_hierarchy_id
8191: AND parent_id = l_parent_id
8192: AND child_id = l_child_id
8193: AND child_sequence_num = l_child_sequence_num;

Line 8197: FROM fem_cost_objects_hier

8193: AND child_sequence_num = l_child_sequence_num;
8194:
8195: DELETE FROM fem_cost_obj_hier_qty
8196: WHERE relationship_id = (SELECT relationship_id
8197: FROM fem_cost_objects_hier
8198: WHERE hierarchy_obj_id = p_hierarchy_id
8199: AND parent_id = l_parent_id
8200: AND child_id = l_child_id
8201: AND child_sequence_num=l_child_sequence_num);

Line 8211: UPDATE fem_cost_objects_hier

8207: ELSE -- there is a prior version
8208:
8209: IF p_remove_all_children_flag = 'Y' THEN
8210:
8211: UPDATE fem_cost_objects_hier
8212: SET effective_end_date = (l_curr_version_start_date - 1),
8213: last_update_date = g_current_date,
8214: last_updated_by = g_current_user_id,
8215: last_update_login = g_current_login_id,

Line 8222: DELETE FROM fem_cost_objects_hier

8218: AND parent_id = l_parent_id;
8219:
8220: IF sql%NOTFOUND THEN
8221:
8222: DELETE FROM fem_cost_objects_hier
8223: WHERE hierarchy_obj_id = p_hierarchy_id
8224: AND parent_id = l_parent_id
8225: AND child_sequence_num = l_child_sequence_num;
8226:

Line 8232: UPDATE fem_cost_objects_hier

8228:
8229:
8230: ELSE
8231:
8232: UPDATE fem_cost_objects_hier
8233: SET effective_end_date = (l_curr_version_start_date - 1),
8234: last_update_date = g_current_date,
8235: last_updated_by = g_current_user_id,
8236: last_update_login = g_current_login_id,

Line 8245: DELETE FROM fem_cost_objects_hier

8241: AND child_sequence_num = l_child_sequence_num;
8242:
8243: IF sql%NOTFOUND THEN
8244:
8245: DELETE FROM fem_cost_objects_hier
8246: WHERE hierarchy_obj_id = p_hierarchy_id
8247: AND parent_id = l_parent_id
8248: AND child_id = l_child_id
8249: AND child_sequence_num = l_child_sequence_num;

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 8267: INSERT INTO fem_cost_objects_hier

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
8268: (relationship_id,
8269: effective_start_date,
8270: hierarchy_obj_id,
8271: parent_id,

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

Line 8308: INSERT INTO fem_cost_objects_hier

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
8309: (relationship_id,
8310: effective_start_date,
8311: hierarchy_obj_id,
8312: parent_id,

Line 8449: FROM fem_cost_objects_hier

8445: c_child_sequence_num IN NUMBER,
8446: c_version_start_date IN DATE)
8447: IS
8448: SELECT relationship_id
8449: FROM fem_cost_objects_hier
8450: WHERE hierarchy_obj_id = c_hierarchy_id
8451: AND parent_id = c_parent_id
8452: AND child_id = c_child_id
8453: AND child_sequence_num = c_child_sequence_num

Line 8474: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN

8470: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
8471: FND_MSG_PUB.initialize ;
8472: END IF;
8473:
8474: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN
8475:
8476: OPEN l_version_csr(c_version_id => p_version_id);
8477: FETCH l_version_csr INTO l_version_start_date;
8478: CLOSE l_version_csr;

Line 8501: UPDATE fem_cost_objects_hier

8497: END;
8498: -- Bug#5723800 : End
8499:
8500:
8501: UPDATE fem_cost_objects_hier
8502: SET bom_reference = p_bom_reference
8503: WHERE relationship_id = l_relationship_id;
8504:
8505: -- Bug#5723800 : Begin

Line 8745: FROM fem_cost_objects_hier

8741: IS
8742: SELECT relationship_id,
8743: display_order_num,
8744: bom_reference
8745: FROM fem_cost_objects_hier
8746: WHERE hierarchy_obj_id = c_hierarchy_id
8747: AND parent_id = c_parent_id
8748: AND child_id = c_child_id
8749: AND child_sequence_num = c_child_sequence_num;

Line 8779: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN

8775: FND_MSG_PUB.initialize ;
8776: END IF;
8777: --
8778:
8779: IF p_hier_table_name = 'FEM_COST_OBJECTS_HIER' THEN
8780:
8781: OPEN l_relation_details_csr(c_hierarchy_id => p_hierarchy_id,
8782: c_version_id => p_version_id,
8783: c_parent_id => p_src_parent_id,