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.CN_IMP_HIERARCHY_PVT dependencies on CN_HIERARCHY_IMP_V

Line 13: -- This procedure will set error in cn_imp_lines(cn_hierarchy_imp_v)

9: -- ========================================================
10: -- --------------------------------------------------------+
11: -- seterr_imp_hierarchy
12: --
13: -- This procedure will set error in cn_imp_lines(cn_hierarchy_imp_v)
14: -- with passed in status and error code
15: -- --------------------------------------------------------+
16: PROCEDURE seterr_imp_hierarchy
17: (p_hier_record IN imp_hier_rec_type,

Line 26: UPDATE cn_hierarchy_imp_v

22: x_processed_row IN OUT NOCOPY NUMBER) IS
23: PRAGMA AUTONOMOUS_TRANSACTION;
24: BEGIN
25:
26: UPDATE cn_hierarchy_imp_v
27: SET status_code = p_status_code, error_code = p_error_code,
28: error_msg = p_error_msg
29: WHERE
30: (start_date =

Line 133: FROM cn_hierarchy_imp_v

129: Upper(primary_key) PRIMARY_KEY,
130: Upper(hierarchy_value) HIERARCHY_VALUE
131: INTO p_hier_record.base_table_name,p_hier_record.primary_key,
132: p_hier_record.hierarchy_value
133: FROM cn_hierarchy_imp_v
134: WHERE imp_header_id = p_imp_header_id
135: AND status_code = l_stage_status
136: AND hierarchy_type = p_hier_record.hierarchy_type
137: ;

Line 587: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE,

583: l_sql_stmt VARCHAR2(8000);
584:
585: -- Cursor to get hierarchy nodes
586: CURSOR c_hierarchy_node_csr
587: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE,
588: l_base_tbl cn_hierarchy_imp_v.base_table_name%TYPE,
589: l_hier_name cn_hierarchy_imp_v.hierarchy_name%TYPE,
590: l_start_date cn_hierarchy_imp_v.start_date%TYPE,
591: l_end_date cn_hierarchy_imp_v.end_date%TYPE)

Line 588: l_base_tbl cn_hierarchy_imp_v.base_table_name%TYPE,

584:
585: -- Cursor to get hierarchy nodes
586: CURSOR c_hierarchy_node_csr
587: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE,
588: l_base_tbl cn_hierarchy_imp_v.base_table_name%TYPE,
589: l_hier_name cn_hierarchy_imp_v.hierarchy_name%TYPE,
590: l_start_date cn_hierarchy_imp_v.start_date%TYPE,
591: l_end_date cn_hierarchy_imp_v.end_date%TYPE)
592: IS

Line 589: l_hier_name cn_hierarchy_imp_v.hierarchy_name%TYPE,

585: -- Cursor to get hierarchy nodes
586: CURSOR c_hierarchy_node_csr
587: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE,
588: l_base_tbl cn_hierarchy_imp_v.base_table_name%TYPE,
589: l_hier_name cn_hierarchy_imp_v.hierarchy_name%TYPE,
590: l_start_date cn_hierarchy_imp_v.start_date%TYPE,
591: l_end_date cn_hierarchy_imp_v.end_date%TYPE)
592: IS
593: SELECT

Line 590: l_start_date cn_hierarchy_imp_v.start_date%TYPE,

586: CURSOR c_hierarchy_node_csr
587: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE,
588: l_base_tbl cn_hierarchy_imp_v.base_table_name%TYPE,
589: l_hier_name cn_hierarchy_imp_v.hierarchy_name%TYPE,
590: l_start_date cn_hierarchy_imp_v.start_date%TYPE,
591: l_end_date cn_hierarchy_imp_v.end_date%TYPE)
592: IS
593: SELECT
594: imp_line_id,

Line 591: l_end_date cn_hierarchy_imp_v.end_date%TYPE)

587: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE,
588: l_base_tbl cn_hierarchy_imp_v.base_table_name%TYPE,
589: l_hier_name cn_hierarchy_imp_v.hierarchy_name%TYPE,
590: l_start_date cn_hierarchy_imp_v.start_date%TYPE,
591: l_end_date cn_hierarchy_imp_v.end_date%TYPE)
592: IS
593: SELECT
594: imp_line_id,
595: imp_header_id,

Line 602: FROM CN_HIERARCHY_IMP_V

598: record_num,
599: trim(parent_node_name) PARENT_NODE_NAME,
600: trim(default_node_flag) DEFAULT_NODE_FLAG,
601: trim(node_name) NODE_NAME
602: FROM CN_HIERARCHY_IMP_V
603: WHERE imp_header_id = p_imp_header_id
604: AND status_code = l_stage_status
605: AND hierarchy_type = l_hier_type
606: AND BASE_TABLE_NAME = l_base_tbl

Line 878: SELECT imp_line_id,record_num FROM cn_hierarchy_imp_v

874: l_def_base_name cn_hierarchy_nodes.name%TYPE;
875:
876: -- cursor to get all record missed required field
877: CURSOR c_miss_required_csr IS
878: SELECT imp_line_id,record_num FROM cn_hierarchy_imp_v
879: WHERE imp_header_id = p_imp_header_id
880: AND status_code = l_stage_status
881: AND (hierarchy_type IS NULL OR BASE_TABLE_NAME IS NULL OR
882: primary_key IS NULL OR hierarchy_value IS NULL OR

Line 889: SELECT imp_line_id,record_num FROM cn_hierarchy_imp_v

885: ;
886:
887: -- cursor to get all record with wrong default_node_flag
888: CURSOR c_err_dflt_node_csr IS
889: SELECT imp_line_id,record_num FROM cn_hierarchy_imp_v
890: WHERE imp_header_id = p_imp_header_id
891: AND status_code = l_stage_status
892: AND default_node_flag <> 'Y'
893: AND default_node_flag <> 'N'

Line 900: FROM CN_HIERARCHY_IMP_V

896: -- Cursor to get distinct base_table_name from stage table
897: CURSOR c_base_table_csr IS
898: SELECT DISTINCT
899: Upper(base_table_name) BASE_TABLE_NAME
900: FROM CN_HIERARCHY_IMP_V
901: WHERE imp_header_id = p_imp_header_id
902: AND status_code = l_stage_status
903: ;
904:

Line 909: FROM CN_HIERARCHY_IMP_V

905: -- Cursor to get distinct HIERARCHY_TYPE from stage table
906: CURSOR c_hierarchy_type_csr IS
907: SELECT DISTINCT
908: trim(hierarchy_type) HIERARCHY_TYPE
909: FROM CN_HIERARCHY_IMP_V
910: WHERE imp_header_id = p_imp_header_id
911: AND status_code = l_stage_status
912: ;
913:

Line 918: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE) IS

914: l_hierarchy_type_csr c_hierarchy_type_csr%ROWTYPE;
915:
916: -- Cursor to get distinct head_hierarchy for one hierarchy_type
917: CURSOR c_head_hierarchy_csr
918: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE) IS
919: SELECT DISTINCT
920: trim(hierarchy_name) HIERARCHY_NAME,
921: trim(start_date) START_DATE,
922: trim(end_date) end_date

Line 923: FROM CN_HIERARCHY_IMP_V

919: SELECT DISTINCT
920: trim(hierarchy_name) HIERARCHY_NAME,
921: trim(start_date) START_DATE,
922: trim(end_date) end_date
923: FROM CN_HIERARCHY_IMP_V
924: WHERE imp_header_id = p_imp_header_id
925: AND status_code = l_stage_status
926: AND hierarchy_type = l_hier_type
927: ;

Line 931: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE,

927: ;
928:
929: -- Cursor to get distinct dim_hierarchy for one hierarchy_type,head_hier
930: CURSOR c_dim_hierarchy_csr
931: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE,
932: l_head_hier cn_hierarchy_imp_v.hierarchy_name%TYPE ) IS
933: SELECT DISTINCT
934: trim(start_date) START_DATE,
935: trim(end_date) end_date

Line 932: l_head_hier cn_hierarchy_imp_v.hierarchy_name%TYPE ) IS

928:
929: -- Cursor to get distinct dim_hierarchy for one hierarchy_type,head_hier
930: CURSOR c_dim_hierarchy_csr
931: (l_hier_type cn_hierarchy_imp_v.hierarchy_type%TYPE,
932: l_head_hier cn_hierarchy_imp_v.hierarchy_name%TYPE ) IS
933: SELECT DISTINCT
934: trim(start_date) START_DATE,
935: trim(end_date) end_date
936: FROM CN_HIERARCHY_IMP_V

Line 936: FROM CN_HIERARCHY_IMP_V

932: l_head_hier cn_hierarchy_imp_v.hierarchy_name%TYPE ) IS
933: SELECT DISTINCT
934: trim(start_date) START_DATE,
935: trim(end_date) end_date
936: FROM CN_HIERARCHY_IMP_V
937: WHERE imp_header_id = p_imp_header_id
938: AND status_code = l_stage_status
939: AND hierarchy_type = l_hier_type
940: AND hierarchy_name = l_head_hier

Line 945: l_parent_node_name cn_hierarchy_imp_v.parent_node_name%TYPE;

941: ;
942:
943: l_dummy NUMBER;
944: l_tmp VARCHAR2(30);
945: l_parent_node_name cn_hierarchy_imp_v.parent_node_name%TYPE;
946:
947: BEGIN
948:
949: -- Initialize API return status to success

Line 1050: FROM CN_HIERARCHY_IMP_V

1046: BEGIN
1047: l_hier_record.base_table_name := l_base_table_csr.base_table_name;
1048: SELECT DISTINCT trim(hierarchy_type) hierarchy_type
1049: INTO l_tmp
1050: FROM CN_HIERARCHY_IMP_V
1051: WHERE imp_header_id = p_imp_header_id
1052: AND status_code = l_stage_status
1053: AND BASE_TABLE_NAME = l_base_table_csr.BASE_TABLE_NAME
1054: ;

Line 1171: FROM cn_hierarchy_imp_v

1167: l_parent_node_name := 'temp';
1168: -- Get default base node name from CSV file
1169: SELECT trim(node_name),trim(parent_node_name)
1170: INTO l_def_base_name,l_parent_node_name
1171: FROM cn_hierarchy_imp_v
1172: WHERE imp_header_id = p_imp_header_id
1173: AND status_code = l_stage_status
1174: AND hierarchy_type = l_hier_record.hierarchy_type
1175: AND hierarchy_name = l_hier_record.hierarchy_name