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_OBJ

Line 2024: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)

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:
2028: l_class_code_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 2025: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)

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:
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))

Line 2029: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', NVL(p_item_catalog_group_id, -1))

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
2033: INTO l_label

Line 2237: -- into the EGO_COL_NAME_VALUE_PAIR_OBJ is 150 chars); if the --

2233:
2234: -------------------------------------------------------------------
2235: -- We build a list of all parent catalog groups, as long as the --
2236: -- list is less than 151 characters long (the longest we can fit --
2237: -- into the EGO_COL_NAME_VALUE_PAIR_OBJ is 150 chars); if the --
2238: -- list is too long to fully copy, we can only hope that the --
2239: -- portion we copied will contain all the information we need. --
2240: -------------------------------------------------------------------
2241: FOR cat_rec IN parent_catalog_group_cursor

Line 2538: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))

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:
2542: -----------------------------------------------------------------

Line 2539: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))

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:
2542: -----------------------------------------------------------------
2543: -- Get the Item Catalog Group ID as well as a comma-delimited --

Line 2601: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))

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:
2605: ---------------------------------------------------------------

Line 2602: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)

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:
2605: ---------------------------------------------------------------
2606: -- Next, we build our privileges table for the current user; --

Line 2793: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))

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:
2797: ---------------------------------------------------------------

Line 2794: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))

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:
2797: ---------------------------------------------------------------
2798: -- Next, we build our privileges table for the current user; --

Line 4856: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(p_inventory_item_id))

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:
4860: ----------------------

Line 4857: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(p_organization_id))

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:
4860: ----------------------
4861: -- Get Class Codes --

Line 4874: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))

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:
4878: ----------------------

Line 4875: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1', l_related_class_codes_list)

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:
4878: ----------------------
4879: -- Get Data Levels --

Line 4883: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_LEVEL', null)

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:
4887: ---------------------------------

Line 4884: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_REVISION_LEVEL', TO_CHAR(p_revision_id))

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:
4887: ---------------------------------
4888: -- Setup attribute group type --

Line 5673: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(attr_default_rec.INVENTORY_ITEM_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
5677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));

Line 5674: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(attr_default_rec.ORGANIZATION_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
5677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));
5678:

Line 5677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(attr_default_rec.ITEM_CATALOG_GROUP_ID)));

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)));
5681:

Line 5680: (EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', to_char(attr_default_rec.REVISION_ID)));

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);
5684: IF l_additional_class_Code_list IS NULL THEN