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_COL_NAME_VALUE_PAIR_ARRAY

Line 2016: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

2012: ) IS
2013:
2014: l_api_name CONSTANT VARCHAR2(30) := 'Seed_Item_Long_Desc_Attr_Group';
2015:
2016: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
2017: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
2018: l_label VARCHAR2(80);
2019: l_attr_value_info_table EGO_USER_ATTR_DATA_TABLE;
2020:

Line 2017: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

2013:
2014: l_api_name CONSTANT VARCHAR2(30) := 'Seed_Item_Long_Desc_Attr_Group';
2015:
2016: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
2017: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
2018: l_label VARCHAR2(80);
2019: l_attr_value_info_table EGO_USER_ATTR_DATA_TABLE;
2020:
2021: BEGIN

Line 2023: l_pk_column_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(

2019: l_attr_value_info_table EGO_USER_ATTR_DATA_TABLE;
2020:
2021: BEGIN
2022:
2023: l_pk_column_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2024: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
2025: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
2026: );
2027:

Line 2028: l_class_code_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(

2024: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
2025: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
2026: );
2027:
2028: l_class_code_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2029: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', NVL(p_item_catalog_group_id, -1))
2030: );
2031:
2032: SELECT DISPLAY_NAME

Line 2518: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

2514: ) IS
2515:
2516: l_api_name CONSTANT VARCHAR2(30) := 'Process_User_Attrs_For_Item';
2517:
2518: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
2519: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
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;

Line 2519: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

2515:
2516: l_api_name CONSTANT VARCHAR2(30) := 'Process_User_Attrs_For_Item';
2517:
2518: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
2519: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
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;

Line 2537: EGO_COL_NAME_VALUE_PAIR_ARRAY(

2533: -----------------------
2534: -- Get PKs organized --
2535: -----------------------
2536: l_pk_column_values :=
2537: EGO_COL_NAME_VALUE_PAIR_ARRAY(
2538: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))
2539: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))
2540: );
2541:

Line 2600: EGO_COL_NAME_VALUE_PAIR_ARRAY(

2596: ,l_related_class_codes_list
2597: );
2598:
2599: l_class_code_values :=
2600: EGO_COL_NAME_VALUE_PAIR_ARRAY(
2601: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))
2602: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)
2603: );
2604:

Line 2783: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

2779: ) IS
2780:
2781: l_api_name CONSTANT VARCHAR2(30) := 'Get_User_Attrs_For_Item';
2782:
2783: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
2784: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
2785:
2786: BEGIN
2787:

Line 2792: EGO_COL_NAME_VALUE_PAIR_ARRAY(

2788: -----------------------
2789: -- Get PKs organized --
2790: -----------------------
2791: l_pk_column_values :=
2792: EGO_COL_NAME_VALUE_PAIR_ARRAY(
2793: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))
2794: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))
2795: );
2796:

Line 4834: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

4830: ,x_msg_count OUT NOCOPY NUMBER
4831: ,x_msg_data OUT NOCOPY VARCHAR2
4832: ) IS
4833: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Required_Attrs';
4834: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4835: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4836: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4837: l_attr_group_type_table EGO_VARCHAR_TBL_TYPE;
4838: l_item_catalog_group_id NUMBER;

Line 4835: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

4831: ,x_msg_data OUT NOCOPY VARCHAR2
4832: ) IS
4833: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Required_Attrs';
4834: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4835: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4836: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4837: l_attr_group_type_table EGO_VARCHAR_TBL_TYPE;
4838: l_item_catalog_group_id NUMBER;
4839: l_related_class_codes_list VARCHAR2(150);

Line 4836: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

4832: ) IS
4833: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Required_Attrs';
4834: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4835: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4836: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4837: l_attr_group_type_table EGO_VARCHAR_TBL_TYPE;
4838: l_item_catalog_group_id NUMBER;
4839: l_related_class_codes_list VARCHAR2(150);
4840: l_token_table ERROR_HANDLER.Token_Tbl_Type;

Line 4855: EGO_COL_NAME_VALUE_PAIR_ARRAY(

4851: -----------------------
4852: -- Get PKs organized --
4853: -----------------------
4854: l_pk_column_values :=
4855: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4856: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))
4857: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))
4858: );
4859:

Line 4873: EGO_COL_NAME_VALUE_PAIR_ARRAY(

4869: ,x_related_class_codes_list => l_related_class_codes_list
4870: );
4871:
4872: l_class_code_values :=
4873: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4874: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))
4875: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)
4876: );
4877:

Line 4882: EGO_COL_NAME_VALUE_PAIR_ARRAY(

4878: ----------------------
4879: -- Get Data Levels --
4880: ----------------------
4881: l_data_level_values :=
4882: EGO_COL_NAME_VALUE_PAIR_ARRAY(
4883: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_LEVEL', null)
4884: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_REVISION_LEVEL', TO_CHAR(p_revision_id))
4885: );
4886:

Line 5628: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

5624: l_msg_count NUMBER;
5625: l_msg_data VARCHAR2(2000);
5626: l_failed_row_id_list VARCHAR2(2000);
5627:
5628: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5629: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5630: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
5631: l_inventory_item_id NUMBER;
5632: l_organization_id NUMBER;

Line 5629: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

5625: l_msg_data VARCHAR2(2000);
5626: l_failed_row_id_list VARCHAR2(2000);
5627:
5628: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5629: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5630: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
5631: l_inventory_item_id NUMBER;
5632: l_organization_id NUMBER;
5633: l_revision_id NUMBER;

Line 5630: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

5626: l_failed_row_id_list VARCHAR2(2000);
5627:
5628: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5629: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
5630: l_data_level_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
5631: l_inventory_item_id NUMBER;
5632: l_organization_id NUMBER;
5633: l_revision_id NUMBER;
5634: l_object_name VARCHAR2(10);

Line 5672: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

5668: l_application_id := attr_default_rec.APPLICATION_ID;
5669: l_catalog_group_id := attr_default_rec.ITEM_CATALOG_GROUP_ID;
5670: l_attribute_group_type := attr_default_rec.ATTRIBUTE_GROUP_TYPE;
5671: l_commit := p_commit;
5672: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
5673: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(attr_default_rec.INVENTORY_ITEM_ID))
5674: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(attr_default_rec.ORGANIZATION_ID)));
5675:
5676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 5676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

5672: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
5673: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(attr_default_rec.INVENTORY_ITEM_ID))
5674: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(attr_default_rec.ORGANIZATION_ID)));
5675:
5676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
5677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));
5678:
5679: l_data_level_values := EGO_COL_NAME_VALUE_PAIR_ARRAY
5680: (EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', to_char(attr_default_rec.REVISION_ID)));

Line 5679: l_data_level_values := EGO_COL_NAME_VALUE_PAIR_ARRAY

5675:
5676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
5677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));
5678:
5679: l_data_level_values := EGO_COL_NAME_VALUE_PAIR_ARRAY
5680: (EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', to_char(attr_default_rec.REVISION_ID)));
5681:
5682: Get_Related_Class_Codes ( p_classification_code => l_catalog_group_id,
5683: x_related_class_codes_list => l_additional_class_Code_list);