APPS.EGO_IMPORT_PVT dependencies on EGO_ATTRS_V

Line 794: --6468564:Perf issue replacing EGO_ATTRS_V

790: , p_master_org_id IN NUMBER DEFAULT NULL
791: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
792: )
793: IS
794: --6468564:Perf issue replacing EGO_ATTRS_V
795: CURSOR c_pdh_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS
796: SELECT sub.*
797: ,EXT.DATA_TYPE DATA_TYPE_CODE
798: FROM

Line 877: --6468564:Perf issue replacing EGO_ATTRS_V

873: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE
874: AND EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME
875: ORDER BY rnk, sub.last_update_date DESC, interface_table_unique_id DESC ;
876:
877: --6468564:Perf issue replacing EGO_ATTRS_V
878: CURSOR c_ss_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS
879: SELECT sub.*
880: ,EXT.DATA_TYPE DATA_TYPE_CODE
881: FROM

Line 976: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

972: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
973: l_mrow_ix PLS_INTEGER := 0;
974: l_is_pdh_batch BOOLEAN;
975:
976: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
977:
978: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;
979: l_pdh_batch_flag FLAG := p_is_pdh_batch;
980: l_rev_dl_id NUMBER;

Line 1224: --6468564:Perf issue replacing EGO_ATTRS_V

1220: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
1221: )
1222: IS
1223:
1224: --6468564:Perf issue replacing EGO_ATTRS_V
1225: CURSOR c_pdh_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS
1226: SELECT sub.*
1227: ,EXT.DATA_TYPE DATA_TYPE_CODE
1228: FROM

Line 1301: --6468564 : Perf issue replacing EGO_ATTRS_V

1297: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE
1298: AND EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME
1299: ORDER BY rnk, sub.last_update_date DESC, interface_table_unique_id DESC ;
1300:
1301: --6468564 : Perf issue replacing EGO_ATTRS_V
1302: CURSOR c_ss_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS
1303: SELECT sub.*
1304: ,EXT.DATA_TYPE DATA_TYPE_CODE
1305: FROM

Line 1395: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

1391: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
1392: l_mrow_ix PLS_INTEGER := 0;
1393: l_is_pdh_batch BOOLEAN;
1394:
1395: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
1396: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;
1397: l_pdh_batch_flag FLAG := p_is_pdh_batch;
1398:
1399: l_proc_log_prefix CONSTANT VARCHAR2(30) := ' merge_item_attrs - ';

Line 4323: , EGO_ATTRS_V attrs

4319: AND DL.DATA_LEVEL_ID = DL.DATA_LEVEL_ID
4320: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
4321: )
4322: ) sub
4323: , EGO_ATTRS_V attrs
4324: WHERE sub.CNT > 1
4325: AND attrs.APPLICATION_ID = 431
4326: AND attrs.ATTR_GROUP_NAME = sub.ATTR_GROUP_INT_NAME
4327: AND attrs.ATTR_NAME = sub.ATTR_INT_NAME

Line 4345: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

4341: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
4342: l_mrow_ix PLS_INTEGER := 0;
4343: l_new_row_idx PLS_INTEGER := 0;
4344:
4345: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4346:
4347: l_proc_log_prefix CONSTANT VARCHAR2(50) := 'Merge_Item_Attrs_For_Import - ';
4348: BEGIN
4349: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );

Line 4635: , EGO_ATTRS_V attrs

4631: WHERE A.DATA_LEVEL_ID = cp_rev_dl_id
4632: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
4633: )
4634: ) sub
4635: , EGO_ATTRS_V attrs
4636: WHERE sub.CNT > 1
4637: AND attrs.APPLICATION_ID = 431
4638: AND attrs.ATTR_GROUP_NAME = sub.ATTR_GROUP_INT_NAME
4639: AND attrs.ATTR_NAME = sub.ATTR_INT_NAME

Line 4658: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

4654: l_mrow_ix PLS_INTEGER := 0;
4655: l_new_row_idx PLS_INTEGER := 0;
4656: l_rev_dl_id NUMBER;
4657:
4658: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4659:
4660: l_proc_log_prefix CONSTANT VARCHAR2(50) := 'Merge_Rev_Attrs_For_Import - ';
4661: BEGIN
4662: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );