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.EGO_ITEM_PVT dependencies on EGO_USER_ATTR_ROW_TABLE

Line 644: -- EGO_USER_ATTR_ROW_TABLE if a change order is required or update is not allowed

640: -- API Name: Remove_Rows_After_Policy_Check
641: --
642: -- Description:
643: -- Updates the error table and deletes the corresponding rows from the
644: -- EGO_USER_ATTR_ROW_TABLE if a change order is required or update is not allowed
645: -- for a given attribute
646: -- ------------------------------------------------------------------------------------
647: FUNCTION Remove_Rows_After_Policy_Check (
648: p_inventory_item_id IN NUMBER

Line 650: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE

646: -- ------------------------------------------------------------------------------------
647: FUNCTION Remove_Rows_After_Policy_Check (
648: p_inventory_item_id IN NUMBER
649: ,p_organization_id IN NUMBER
650: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
651: ,p_entity_id IN NUMBER DEFAULT NULL
652: ,p_entity_index IN NUMBER DEFAULT NULL
653: ,p_entity_code IN VARCHAR2 DEFAULT NULL
654: ,x_return_status OUT NOCOPY VARCHAR2

Line 655: ) RETURN EGO_USER_ATTR_ROW_TABLE IS

651: ,p_entity_id IN NUMBER DEFAULT NULL
652: ,p_entity_index IN NUMBER DEFAULT NULL
653: ,p_entity_code IN VARCHAR2 DEFAULT NULL
654: ,x_return_status OUT NOCOPY VARCHAR2
655: ) RETURN EGO_USER_ATTR_ROW_TABLE IS
656:
657: l_object_id NUMBER;
658: l_is_required VARCHAR2(1);
659: l_token_table ERROR_HANDLER.Token_Tbl_Type;

Line 665: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

661: l_rev_id VARCHAR2(150);
662: l_delete_sql VARCHAR2(200);
663: l_attr_data_table_index NUMBER;
664:
665: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
666: l_current_data_element EGO_USER_ATTR_ROW_OBJ;
667:
668: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;
669: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;

Line 677: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();

673: l_item_number MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
674: l_row_identifier NUMBER;
675: i NUMBER :=0;
676: BEGIN
677: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
678: l_attr_data_table_index := p_attributes_row_table.FIRST;
679: SELECT OBJECT_ID into l_object_id FROM fnd_objects WHERE obj_name ='EGO_ITEM';
680:
681: LOOP

Line 2494: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE

2490: PROCEDURE Process_User_Attrs_For_Item (
2491: p_api_version IN NUMBER
2492: ,p_inventory_item_id IN NUMBER
2493: ,p_organization_id IN NUMBER
2494: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
2495: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
2496: ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
2497: ,p_entity_id IN NUMBER DEFAULT NULL
2498: ,p_entity_index IN NUMBER DEFAULT NULL

Line 2524: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;

2520: l_item_catalog_group_id NUMBER;
2521: l_related_class_codes_list VARCHAR2(150);
2522: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
2523: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2524: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2525: l_return_status VARCHAR2(2);
2526:
2527: BEGIN
2528: l_attributes_row_table:=EGO_USER_ATTR_ROW_TABLE();

Line 2528: l_attributes_row_table:=EGO_USER_ATTR_ROW_TABLE();

2524: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2525: l_return_status VARCHAR2(2);
2526:
2527: BEGIN
2528: l_attributes_row_table:=EGO_USER_ATTR_ROW_TABLE();
2529: -------------------------------------------------------------------------
2530: -- First we build tables of Primary Key and Classification Code values --
2531: -------------------------------------------------------------------------
2532:

Line 2773: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

2769: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2770: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2771: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2772: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2773: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2774: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2775: ,x_return_status OUT NOCOPY VARCHAR2
2776: ,x_errorcode OUT NOCOPY NUMBER
2777: ,x_msg_count OUT NOCOPY NUMBER