DBA Data[Home] [Help]

APPS.BOM_COMPUTE_FUNCTIONS dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 882: l_pk_column_value EGO_COL_NAME_VALUE_PAIR_OBJ;

878: ,x_error_message OUT NOCOPY VARCHAR2
879: )
880: IS
881: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
882: l_pk_column_value EGO_COL_NAME_VALUE_PAIR_OBJ;
883: l_error_message VARCHAR2(2000);
884: l_item_catalog_group_id NUMBER;
885: l_extension_ids EGO_NUMBER_TBL_TYPE;
886: l_cur_attr_diff_tbl EGO_USER_ATTR_DIFF_TABLE;

Line 943: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_header_item_id)

939:
940: END IF;
941:
942: l_pk_column_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(
943: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_header_item_id)
944: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
945: );
946:
947: --

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

940: END IF;
941:
942: l_pk_column_values := EGO_COL_NAME_VALUE_PAIR_ARRAY(
943: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_header_item_id)
944: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
945: );
946:
947: --
948: -- When there is a change to the packaging hierarchy

Line 1014: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));

1010: END LOOP;
1011:
1012: Bom_Rollup_Pub.g_class_code_name_value_pairs :=
1013: EGO_COL_NAME_VALUE_PAIR_ARRAY
1014: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
1015:
1016: END IF;
1017: --Call the update api only if Bom_Rollup_Pub.g_attr_diffs is not null.
1018: --bug: 4037735.

Line 1270: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_item_id)

1266:
1267: BEGIN
1268:
1269: l_pk_columns := EGO_COL_NAME_VALUE_PAIR_ARRAY
1270: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_item_id)
1271: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
1272: );
1273:
1274: FOR c1 IN get_classification_code

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

1267: BEGIN
1268:
1269: l_pk_columns := EGO_COL_NAME_VALUE_PAIR_ARRAY
1270: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_item_id)
1271: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id)
1272: );
1273:
1274: FOR c1 IN get_classification_code
1275: LOOP

Line 1280: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));

1276: l_item_catalog_group_id := c1.item_catalog_group_id;
1277: END LOOP;
1278:
1279: l_class_code := EGO_COL_NAME_VALUE_PAIR_ARRAY
1280: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
1281:
1282: l_data_level := EGO_COL_NAME_VALUE_PAIR_ARRAY
1283: (EGO_COL_NAME_VALUE_PAIR_OBJ('DATA_LEVEL', 'EGO_ITEM'));
1284:

Line 1283: (EGO_COL_NAME_VALUE_PAIR_OBJ('DATA_LEVEL', 'EGO_ITEM'));

1279: l_class_code := EGO_COL_NAME_VALUE_PAIR_ARRAY
1280: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(l_item_catalog_group_id)));
1281:
1282: l_data_level := EGO_COL_NAME_VALUE_PAIR_ARRAY
1283: (EGO_COL_NAME_VALUE_PAIR_OBJ('DATA_LEVEL', 'EGO_ITEM'));
1284:
1285: EGO_USER_ATTRS_DATA_PVT.Perform_DML_On_Row(
1286: p_api_version => 1.0
1287: , p_object_name => 'EGO_ITEM'