[Home] [Help]
644: -- API Name: Remove_Rows_After_Policy_Check
645: --
646: -- Description:
647: -- Updates the error table and deletes the corresponding rows from the
648: -- EGO_USER_ATTR_ROW_TABLE if a change order is required or update is not allowed
649: -- for a given attribute
650: -- ------------------------------------------------------------------------------------
651: FUNCTION Remove_Rows_After_Policy_Check (
652: p_inventory_item_id IN NUMBER
650: -- ------------------------------------------------------------------------------------
651: FUNCTION Remove_Rows_After_Policy_Check (
652: p_inventory_item_id IN NUMBER
653: ,p_organization_id IN NUMBER
654: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
655: ,p_entity_id IN NUMBER DEFAULT NULL
656: ,p_entity_index IN NUMBER DEFAULT NULL
657: ,p_entity_code IN VARCHAR2 DEFAULT NULL
658: ,x_return_status OUT NOCOPY VARCHAR2
655: ,p_entity_id IN NUMBER DEFAULT NULL
656: ,p_entity_index IN NUMBER DEFAULT NULL
657: ,p_entity_code IN VARCHAR2 DEFAULT NULL
658: ,x_return_status OUT NOCOPY VARCHAR2
659: ) RETURN EGO_USER_ATTR_ROW_TABLE IS
660:
661: l_object_id NUMBER;
662: l_is_required VARCHAR2(1);
663: l_token_table ERROR_HANDLER.Token_Tbl_Type;
665: l_rev_id VARCHAR2(150);
666: l_delete_sql VARCHAR2(200);
667: l_attr_data_table_index NUMBER;
668:
669: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
670: l_current_data_element EGO_USER_ATTR_ROW_OBJ;
671:
672: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;
673: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;
677: l_item_number MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
678: l_row_identifier NUMBER;
679: i NUMBER :=0;
680: BEGIN
681: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
682: l_attr_data_table_index := p_attributes_row_table.FIRST;
683: SELECT OBJECT_ID into l_object_id FROM fnd_objects WHERE obj_name ='EGO_ITEM';
684:
685: LOOP
1119: l_cat_assign_rec_table_aft CATEGORY_ASSIGN_TAB;
1120: l_wf_org_code VARCHAR2(3);
1121:
1122: -- Bug 9852661
1123: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE := EGO_USER_ATTR_ROW_TABLE();
1124: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE() ;
1125: l_attr_row_count NUMBER;
1126: l_attr_data_count NUMBER;
1127: -- Bug 9852661
1568: l_item_rec_in.STYLE_ITEM_FLAG := G_Item_Rec.STYLE_ITEM_FLAG;
1569: l_item_rec_in.STYLE_ITEM_ID := G_Item_Rec.STYLE_ITEM_ID;
1570:
1571: -- Bug 9852661
1572: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1573: l_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
1574:
1575: l_attr_row_count := 1;
1576: IF (G_Item_Rec.attributes_row_table IS NOT NULL) THEN
1665: , x_Item_rec => l_Item_rec_out
1666: , x_return_status => l_return_status
1667: , x_Error_tbl => l_Error_tbl
1668: -- Bug 9092888, Bug 9852661 - Changes
1669: , p_attributes_row_table => l_attributes_row_table -- IN EGO_USER_ATTR_ROW_TABLE DEFAULT NULL
1670: , p_attributes_data_table => l_attributes_data_table -- IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
1671: -- Bug 9092888, Bug 9852661 - Changes
1672: );
1673:
2716: PROCEDURE Process_User_Attrs_For_Item (
2717: p_api_version IN NUMBER
2718: ,p_inventory_item_id IN NUMBER
2719: ,p_organization_id IN NUMBER
2720: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
2721: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
2722: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
2723: ,p_entity_id IN NUMBER DEFAULT NULL
2724: ,p_entity_index IN NUMBER DEFAULT NULL
2746: l_item_catalog_group_id NUMBER;
2747: l_related_class_codes_list VARCHAR2(150);
2748: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
2749: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2750: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2751: l_return_status VARCHAR2(2);
2752:
2753: BEGIN
2754: l_attributes_row_table:=EGO_USER_ATTR_ROW_TABLE();
2750: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2751: l_return_status VARCHAR2(2);
2752:
2753: BEGIN
2754: l_attributes_row_table:=EGO_USER_ATTR_ROW_TABLE();
2755: -------------------------------------------------------------------------
2756: -- First we build tables of Primary Key and Classification Code values --
2757: -------------------------------------------------------------------------
2758:
2995: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2996: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2997: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2998: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2999: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
3000: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
3001: ,x_return_status OUT NOCOPY VARCHAR2
3002: ,x_errorcode OUT NOCOPY NUMBER
3003: ,x_msg_count OUT NOCOPY NUMBER
3009: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
3010: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
3011:
3012: BEGIN
3013: x_attributes_row_table := EGO_USER_ATTR_ROW_TABLE(NULL);--Bug 14140340
3014: -----------------------
3015: -- Get PKs organized --
3016: -----------------------
3017: l_pk_column_values :=