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_OBJ_HIER_QTY

Line 2536: fem_cost_obj_hier_qty fcohq

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
2540: BETWEEN effective_start_date AND effective_end_date

Line 2550: fem_cost_obj_hier_qty fcohq

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
2554: BETWEEN effective_start_date AND effective_end_date;

Line 2711: TYPE t_co_dataset_code is TABLE OF fem_cost_obj_hier_qty.dataset_code%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;
2714: TYPE t_co_child_qty is TABLE OF fem_cost_obj_hier_qty.child_qty%TYPE;
2715: TYPE t_co_yield_percentage is TABLE OF fem_cost_obj_hier_qty.yield_percentage%TYPE;

Line 2712: TYPE t_co_cal_period_id is TABLE OF fem_cost_obj_hier_qty.cal_period_id%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;
2714: TYPE t_co_child_qty is TABLE OF fem_cost_obj_hier_qty.child_qty%TYPE;
2715: TYPE t_co_yield_percentage is TABLE OF fem_cost_obj_hier_qty.yield_percentage%TYPE;
2716:

Line 2713: TYPE t_co_parent_qty is TABLE OF fem_cost_obj_hier_qty.parent_qty%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;
2714: TYPE t_co_child_qty is TABLE OF fem_cost_obj_hier_qty.child_qty%TYPE;
2715: TYPE t_co_yield_percentage is TABLE OF fem_cost_obj_hier_qty.yield_percentage%TYPE;
2716:
2717: t_co_row_id t_co_rowid;

Line 2714: TYPE t_co_child_qty is TABLE OF fem_cost_obj_hier_qty.child_qty%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;
2714: TYPE t_co_child_qty is TABLE OF fem_cost_obj_hier_qty.child_qty%TYPE;
2715: TYPE t_co_yield_percentage is TABLE OF fem_cost_obj_hier_qty.yield_percentage%TYPE;
2716:
2717: t_co_row_id t_co_rowid;
2718: t_co_rel_id t_co_relationship_id;

Line 2715: TYPE t_co_yield_percentage is TABLE OF fem_cost_obj_hier_qty.yield_percentage%TYPE;

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;
2714: TYPE t_co_child_qty is TABLE OF fem_cost_obj_hier_qty.child_qty%TYPE;
2715: TYPE t_co_yield_percentage is TABLE OF fem_cost_obj_hier_qty.yield_percentage%TYPE;
2716:
2717: t_co_row_id t_co_rowid;
2718: t_co_rel_id t_co_relationship_id;
2719: t_co_eff_start_date t_co_effective_start_date;

Line 4141: fem_cost_obj_hier_qty fcohq

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
4145: AND effective_end_date;

Line 4184: INSERT INTO fem_cost_obj_hier_qty

4180: 1);
4181:
4182: FORALL rec in t_co_row_id.FIRST..t_co_row_id.LAST
4183:
4184: INSERT INTO fem_cost_obj_hier_qty
4185: (relationship_id,
4186: dataset_code,
4187: cal_period_id,
4188: child_qty,

Line 5153: DELETE FROM fem_cost_obj_hier_qty

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
5156: WHERE hierarchy_obj_id = p_hier_obj_id);
5157:

Line 7741: INSERT INTO fem_cost_obj_hier_qty

7737: g_current_date,
7738: g_current_login_id,
7739: 1);
7740:
7741: INSERT INTO fem_cost_obj_hier_qty
7742: (relationship_id,
7743: dataset_code,
7744: cal_period_id,
7745: child_qty,

Line 8181: DELETE FROM fem_cost_obj_hier_qty

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
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);

Line 8195: DELETE FROM fem_cost_obj_hier_qty

8191: AND parent_id = l_parent_id
8192: AND child_id = l_child_id
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

Line 8491: SELECT 'N' into l_insert_flag from fem_cost_obj_hier_qty

8487: CLOSE l_relation_Csr;
8488:
8489: -- Bug#5723800 : Begin
8490: BEGIN
8491: SELECT 'N' into l_insert_flag from fem_cost_obj_hier_qty
8492: WHERE relationship_id = l_relationship_id and
8493: dataset_code = l_dataset_code and
8494: cal_period_id = l_cal_period_id;
8495: EXCEPTION

Line 8507: INSERT into fem_cost_obj_hier_qty

8503: WHERE relationship_id = l_relationship_id;
8504:
8505: -- Bug#5723800 : Begin
8506: IF l_insert_flag <> 'N' then
8507: INSERT into fem_cost_obj_hier_qty
8508: (relationship_id,
8509: dataset_code,
8510: cal_period_id,
8511: child_qty,

Line 8535: UPDATE fem_cost_obj_hier_qty

8531: l_last_update_login,
8532: 1);
8533: ELSE
8534: -- Bug#5723800 : End
8535: UPDATE fem_cost_obj_hier_qty
8536: SET parent_qty = p_parent_qty,
8537: child_qty = p_child_qty,
8538: yield_percentage = p_yield_pct
8539: WHERE relationship_id = l_relationship_id

Line 8758: FROM fem_cost_obj_hier_qty

8754: cal_period_id,
8755: child_qty,
8756: parent_qty,
8757: yield_percentage
8758: FROM fem_cost_obj_hier_qty
8759: WHERE relationship_id = c_relationship_id;
8760:
8761: BEGIN
8762: