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_PRODUCTS_HIER

Line 20: TYPE g_member_id_tbl_type is TABLE of FEM_PRODUCTS_HIER.PARENT_ID%TYPE

16: -- Type definition for cursor
17: TYPE dhm_cur_type is REF CURSOR;
18:
19: -- Global PL/SQL types
20: TYPE g_member_id_tbl_type is TABLE of FEM_PRODUCTS_HIER.PARENT_ID%TYPE
21: index by BINARY_INTEGER;
22: TYPE g_depth_num_tbl_type is
23: TABLE of FEM_PRODUCTS_HIER.PARENT_DEPTH_NUM%TYPE
24: index by BINARY_INTEGER;

Line 23: TABLE of FEM_PRODUCTS_HIER.PARENT_DEPTH_NUM%TYPE

19: -- Global PL/SQL types
20: TYPE g_member_id_tbl_type is TABLE of FEM_PRODUCTS_HIER.PARENT_ID%TYPE
21: index by BINARY_INTEGER;
22: TYPE g_depth_num_tbl_type is
23: TABLE of FEM_PRODUCTS_HIER.PARENT_DEPTH_NUM%TYPE
24: index by BINARY_INTEGER;
25: TYPE g_value_set_id_tbl_type is
26: TABLE of FEM_PRODUCTS_HIER.PARENT_VALUE_SET_ID%TYPE
27: index by BINARY_INTEGER;

Line 26: TABLE of FEM_PRODUCTS_HIER.PARENT_VALUE_SET_ID%TYPE

22: TYPE g_depth_num_tbl_type is
23: TABLE of FEM_PRODUCTS_HIER.PARENT_DEPTH_NUM%TYPE
24: index by BINARY_INTEGER;
25: TYPE g_value_set_id_tbl_type is
26: TABLE of FEM_PRODUCTS_HIER.PARENT_VALUE_SET_ID%TYPE
27: index by BINARY_INTEGER;
28: TYPE g_single_depth_tbl_type is
29: TABLE of FEM_PRODUCTS_HIER.SINGLE_DEPTH_FLAG%TYPE
30: index by BINARY_INTEGER;

Line 29: TABLE of FEM_PRODUCTS_HIER.SINGLE_DEPTH_FLAG%TYPE

25: TYPE g_value_set_id_tbl_type is
26: TABLE of FEM_PRODUCTS_HIER.PARENT_VALUE_SET_ID%TYPE
27: index by BINARY_INTEGER;
28: TYPE g_single_depth_tbl_type is
29: TABLE of FEM_PRODUCTS_HIER.SINGLE_DEPTH_FLAG%TYPE
30: index by BINARY_INTEGER;
31: TYPE g_disp_ordnum_tbl_type is
32: TABLE of FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE
33: index by BINARY_INTEGER;

Line 32: TABLE of FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE

28: TYPE g_single_depth_tbl_type is
29: TABLE of FEM_PRODUCTS_HIER.SINGLE_DEPTH_FLAG%TYPE
30: index by BINARY_INTEGER;
31: TYPE g_disp_ordnum_tbl_type is
32: TABLE of FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE
33: index by BINARY_INTEGER;
34: TYPE g_weight_pct_tbl_type is
35: TABLE of FEM_PRODUCTS_HIER.WEIGHTING_PCT%TYPE
36: index by BINARY_INTEGER;

Line 35: TABLE of FEM_PRODUCTS_HIER.WEIGHTING_PCT%TYPE

31: TYPE g_disp_ordnum_tbl_type is
32: TABLE of FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE
33: index by BINARY_INTEGER;
34: TYPE g_weight_pct_tbl_type is
35: TABLE of FEM_PRODUCTS_HIER.WEIGHTING_PCT%TYPE
36: index by BINARY_INTEGER;
37:
38:
39: /*===========================================================================+

Line 2678: TYPE t_parent_depth_num is TABLE OF fem_products_hier.parent_depth_num%TYPE;

2674: p_src_hier_version_id IN NUMBER,
2675: p_dest_hier_version_id IN NUMBER)
2676: is
2677: TYPE t_rowid is TABLE OF VARCHAR2(50);
2678: TYPE t_parent_depth_num is TABLE OF fem_products_hier.parent_depth_num%TYPE;
2679: TYPE t_parent_id is TABLE OF fem_products_hier.parent_id%TYPE;
2680: TYPE t_parent_value_set_id is TABLE OF fem_products_hier.parent_value_set_id%TYPE;
2681: TYPE t_child_depth_num is TABLE OF fem_products_hier.child_depth_num%TYPE;
2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;

Line 2679: TYPE t_parent_id is TABLE OF fem_products_hier.parent_id%TYPE;

2675: p_dest_hier_version_id IN NUMBER)
2676: is
2677: TYPE t_rowid is TABLE OF VARCHAR2(50);
2678: TYPE t_parent_depth_num is TABLE OF fem_products_hier.parent_depth_num%TYPE;
2679: TYPE t_parent_id is TABLE OF fem_products_hier.parent_id%TYPE;
2680: TYPE t_parent_value_set_id is TABLE OF fem_products_hier.parent_value_set_id%TYPE;
2681: TYPE t_child_depth_num is TABLE OF fem_products_hier.child_depth_num%TYPE;
2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;
2683: TYPE t_child_value_set_id is TABLE OF fem_products_hier.child_value_set_id%TYPE;

Line 2680: TYPE t_parent_value_set_id is TABLE OF fem_products_hier.parent_value_set_id%TYPE;

2676: is
2677: TYPE t_rowid is TABLE OF VARCHAR2(50);
2678: TYPE t_parent_depth_num is TABLE OF fem_products_hier.parent_depth_num%TYPE;
2679: TYPE t_parent_id is TABLE OF fem_products_hier.parent_id%TYPE;
2680: TYPE t_parent_value_set_id is TABLE OF fem_products_hier.parent_value_set_id%TYPE;
2681: TYPE t_child_depth_num is TABLE OF fem_products_hier.child_depth_num%TYPE;
2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;
2683: TYPE t_child_value_set_id is TABLE OF fem_products_hier.child_value_set_id%TYPE;
2684: TYPE t_single_depth_flag is TABLE OF fem_products_hier.single_depth_flag%TYPE;

Line 2681: TYPE t_child_depth_num is TABLE OF fem_products_hier.child_depth_num%TYPE;

2677: TYPE t_rowid is TABLE OF VARCHAR2(50);
2678: TYPE t_parent_depth_num is TABLE OF fem_products_hier.parent_depth_num%TYPE;
2679: TYPE t_parent_id is TABLE OF fem_products_hier.parent_id%TYPE;
2680: TYPE t_parent_value_set_id is TABLE OF fem_products_hier.parent_value_set_id%TYPE;
2681: TYPE t_child_depth_num is TABLE OF fem_products_hier.child_depth_num%TYPE;
2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;
2683: TYPE t_child_value_set_id is TABLE OF fem_products_hier.child_value_set_id%TYPE;
2684: TYPE t_single_depth_flag is TABLE OF fem_products_hier.single_depth_flag%TYPE;
2685: TYPE t_display_order_num is TABLE OF fem_products_hier.display_order_num%TYPE;

Line 2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;

2678: TYPE t_parent_depth_num is TABLE OF fem_products_hier.parent_depth_num%TYPE;
2679: TYPE t_parent_id is TABLE OF fem_products_hier.parent_id%TYPE;
2680: TYPE t_parent_value_set_id is TABLE OF fem_products_hier.parent_value_set_id%TYPE;
2681: TYPE t_child_depth_num is TABLE OF fem_products_hier.child_depth_num%TYPE;
2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;
2683: TYPE t_child_value_set_id is TABLE OF fem_products_hier.child_value_set_id%TYPE;
2684: TYPE t_single_depth_flag is TABLE OF fem_products_hier.single_depth_flag%TYPE;
2685: TYPE t_display_order_num is TABLE OF fem_products_hier.display_order_num%TYPE;
2686: TYPE t_weighting_pct is TABLE OF fem_products_hier.weighting_pct%TYPE;

Line 2683: TYPE t_child_value_set_id is TABLE OF fem_products_hier.child_value_set_id%TYPE;

2679: TYPE t_parent_id is TABLE OF fem_products_hier.parent_id%TYPE;
2680: TYPE t_parent_value_set_id is TABLE OF fem_products_hier.parent_value_set_id%TYPE;
2681: TYPE t_child_depth_num is TABLE OF fem_products_hier.child_depth_num%TYPE;
2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;
2683: TYPE t_child_value_set_id is TABLE OF fem_products_hier.child_value_set_id%TYPE;
2684: TYPE t_single_depth_flag is TABLE OF fem_products_hier.single_depth_flag%TYPE;
2685: TYPE t_display_order_num is TABLE OF fem_products_hier.display_order_num%TYPE;
2686: TYPE t_weighting_pct is TABLE OF fem_products_hier.weighting_pct%TYPE;
2687:

Line 2684: TYPE t_single_depth_flag is TABLE OF fem_products_hier.single_depth_flag%TYPE;

2680: TYPE t_parent_value_set_id is TABLE OF fem_products_hier.parent_value_set_id%TYPE;
2681: TYPE t_child_depth_num is TABLE OF fem_products_hier.child_depth_num%TYPE;
2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;
2683: TYPE t_child_value_set_id is TABLE OF fem_products_hier.child_value_set_id%TYPE;
2684: TYPE t_single_depth_flag is TABLE OF fem_products_hier.single_depth_flag%TYPE;
2685: TYPE t_display_order_num is TABLE OF fem_products_hier.display_order_num%TYPE;
2686: TYPE t_weighting_pct is TABLE OF fem_products_hier.weighting_pct%TYPE;
2687:
2688: t_row_id t_rowid;

Line 2685: TYPE t_display_order_num is TABLE OF fem_products_hier.display_order_num%TYPE;

2681: TYPE t_child_depth_num is TABLE OF fem_products_hier.child_depth_num%TYPE;
2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;
2683: TYPE t_child_value_set_id is TABLE OF fem_products_hier.child_value_set_id%TYPE;
2684: TYPE t_single_depth_flag is TABLE OF fem_products_hier.single_depth_flag%TYPE;
2685: TYPE t_display_order_num is TABLE OF fem_products_hier.display_order_num%TYPE;
2686: TYPE t_weighting_pct is TABLE OF fem_products_hier.weighting_pct%TYPE;
2687:
2688: t_row_id t_rowid;
2689: t_prnt_depth_num t_parent_depth_num;

Line 2686: TYPE t_weighting_pct is TABLE OF fem_products_hier.weighting_pct%TYPE;

2682: TYPE t_child_id is TABLE OF fem_products_hier.child_id%TYPE;
2683: TYPE t_child_value_set_id is TABLE OF fem_products_hier.child_value_set_id%TYPE;
2684: TYPE t_single_depth_flag is TABLE OF fem_products_hier.single_depth_flag%TYPE;
2685: TYPE t_display_order_num is TABLE OF fem_products_hier.display_order_num%TYPE;
2686: TYPE t_weighting_pct is TABLE OF fem_products_hier.weighting_pct%TYPE;
2687:
2688: t_row_id t_rowid;
2689: t_prnt_depth_num t_parent_depth_num;
2690: t_prnt_id t_parent_id;

Line 2749: if p_hier_table_name = 'FEM_PRODUCTS_HIER' then

2745: -- dbms_output.put_line('copy_hier_data: start ...');
2746:
2747: SAVEPOINT Copy_Hier_Data_Pvt;
2748:
2749: if p_hier_table_name = 'FEM_PRODUCTS_HIER' then
2750:
2751: select rowid,
2752: parent_depth_num,
2753: parent_id,

Line 2772: from fem_products_hier

2768: t_chld_value_set_id,
2769: t_sngle_depth_flag,
2770: t_dspy_order_num,
2771: t_wt_pct
2772: from fem_products_hier
2773: where hierarchy_obj_def_id = p_src_hier_version_id;
2774:
2775: FORALL rec in t_row_id.FIRST..t_row_id.LAST
2776:

Line 2777: INSERT INTO fem_products_hier

2773: where hierarchy_obj_def_id = p_src_hier_version_id;
2774:
2775: FORALL rec in t_row_id.FIRST..t_row_id.LAST
2776:
2777: INSERT INTO fem_products_hier
2778: ( hierarchy_obj_def_id,
2779: parent_depth_num,
2780: parent_id ,
2781: parent_value_set_id,

Line 5330: FEM_PRODUCTS_HIER.CHILD_ID%TYPE index by BINARY_INTEGER;

5326:
5327:
5328:
5329: TYPE l_member_id_tbl_type is TABLE of
5330: FEM_PRODUCTS_HIER.CHILD_ID%TYPE index by BINARY_INTEGER;
5331:
5332: TYPE l_depth_num_tbl_type is TABLE of
5333: FEM_PRODUCTS_HIER.CHILD_DEPTH_NUM%TYPE index by BINARY_INTEGER;
5334:

Line 5333: FEM_PRODUCTS_HIER.CHILD_DEPTH_NUM%TYPE index by BINARY_INTEGER;

5329: TYPE l_member_id_tbl_type is TABLE of
5330: FEM_PRODUCTS_HIER.CHILD_ID%TYPE index by BINARY_INTEGER;
5331:
5332: TYPE l_depth_num_tbl_type is TABLE of
5333: FEM_PRODUCTS_HIER.CHILD_DEPTH_NUM%TYPE index by BINARY_INTEGER;
5334:
5335: TYPE l_value_set_id_tbl_type is TABLE of
5336: FEM_PRODUCTS_HIER.CHILD_VALUE_SET_ID%TYPE index by BINARY_INTEGER;
5337:

Line 5336: FEM_PRODUCTS_HIER.CHILD_VALUE_SET_ID%TYPE index by BINARY_INTEGER;

5332: TYPE l_depth_num_tbl_type is TABLE of
5333: FEM_PRODUCTS_HIER.CHILD_DEPTH_NUM%TYPE index by BINARY_INTEGER;
5334:
5335: TYPE l_value_set_id_tbl_type is TABLE of
5336: FEM_PRODUCTS_HIER.CHILD_VALUE_SET_ID%TYPE index by BINARY_INTEGER;
5337:
5338: TYPE l_dis_ord_num_tbl_type is TABLE of
5339: FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE index by BINARY_INTEGER;
5340:

Line 5339: FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE index by BINARY_INTEGER;

5335: TYPE l_value_set_id_tbl_type is TABLE of
5336: FEM_PRODUCTS_HIER.CHILD_VALUE_SET_ID%TYPE index by BINARY_INTEGER;
5337:
5338: TYPE l_dis_ord_num_tbl_type is TABLE of
5339: FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE index by BINARY_INTEGER;
5340:
5341: l_child_id_tbl l_member_id_tbl_type;
5342: l_child_value_set_id_tbl l_value_set_id_tbl_type;
5343: l_child_depth_num_tbl l_depth_num_tbl_type;

Line 5949: FEM_PRODUCTS_HIER.CHILD_ID%TYPE index by BINARY_INTEGER;

5945: l_dpth_csr l_dhm_csr_type;
5946: l_leaf_csr l_dhm_csr_type;
5947:
5948: TYPE l_member_id_tbl_type is TABLE of
5949: FEM_PRODUCTS_HIER.CHILD_ID%TYPE index by BINARY_INTEGER;
5950:
5951: TYPE l_depth_num_tbl_type is TABLE of
5952: FEM_PRODUCTS_HIER.CHILD_DEPTH_NUM%TYPE index by BINARY_INTEGER;
5953:

Line 5952: FEM_PRODUCTS_HIER.CHILD_DEPTH_NUM%TYPE index by BINARY_INTEGER;

5948: TYPE l_member_id_tbl_type is TABLE of
5949: FEM_PRODUCTS_HIER.CHILD_ID%TYPE index by BINARY_INTEGER;
5950:
5951: TYPE l_depth_num_tbl_type is TABLE of
5952: FEM_PRODUCTS_HIER.CHILD_DEPTH_NUM%TYPE index by BINARY_INTEGER;
5953:
5954: TYPE l_value_set_id_tbl_type is TABLE of
5955: FEM_PRODUCTS_HIER.CHILD_VALUE_SET_ID%TYPE index by BINARY_INTEGER;
5956:

Line 5955: FEM_PRODUCTS_HIER.CHILD_VALUE_SET_ID%TYPE index by BINARY_INTEGER;

5951: TYPE l_depth_num_tbl_type is TABLE of
5952: FEM_PRODUCTS_HIER.CHILD_DEPTH_NUM%TYPE index by BINARY_INTEGER;
5953:
5954: TYPE l_value_set_id_tbl_type is TABLE of
5955: FEM_PRODUCTS_HIER.CHILD_VALUE_SET_ID%TYPE index by BINARY_INTEGER;
5956:
5957: TYPE l_dis_ord_num_tbl_type is TABLE of
5958: FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE index by BINARY_INTEGER;
5959:

Line 5958: FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE index by BINARY_INTEGER;

5954: TYPE l_value_set_id_tbl_type is TABLE of
5955: FEM_PRODUCTS_HIER.CHILD_VALUE_SET_ID%TYPE index by BINARY_INTEGER;
5956:
5957: TYPE l_dis_ord_num_tbl_type is TABLE of
5958: FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE index by BINARY_INTEGER;
5959:
5960: TYPE l_weighting_pct_tbl_type is TABLE of
5961: FEM_PRODUCTS_HIER.WEIGHTING_PCT%TYPE index by BINARY_INTEGER;
5962:

Line 5961: FEM_PRODUCTS_HIER.WEIGHTING_PCT%TYPE index by BINARY_INTEGER;

5957: TYPE l_dis_ord_num_tbl_type is TABLE of
5958: FEM_PRODUCTS_HIER.DISPLAY_ORDER_NUM%TYPE index by BINARY_INTEGER;
5959:
5960: TYPE l_weighting_pct_tbl_type is TABLE of
5961: FEM_PRODUCTS_HIER.WEIGHTING_PCT%TYPE index by BINARY_INTEGER;
5962:
5963: l_parent_id_tbl l_member_id_tbl_type;
5964: l_parent_value_set_id_tbl l_value_set_id_tbl_type;
5965: l_parent_depth_num_tbl l_depth_num_tbl_type;