411: NULL;
412: END;
413:
414: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
415: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)
416: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID' ,p_organization_id));
417: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
418: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
419: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));
412: END;
413:
414: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
415: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)
416: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID' ,p_organization_id));
417: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
418: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
419: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));
420: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
414: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
415: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)
416: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID' ,p_organization_id));
417: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
418: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
419: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));
420: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
421: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', p_revision_id));
422: EGO_ITEM_PUB.Apply_Templ_User_Attrs_To_Item
415: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)
416: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID' ,p_organization_id));
417: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
418: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
419: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));
420: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
421: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', p_revision_id));
422: EGO_ITEM_PUB.Apply_Templ_User_Attrs_To_Item
423: (p_api_version => 1.0
417: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
418: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
419: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));
420: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
421: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', p_revision_id));
422: EGO_ITEM_PUB.Apply_Templ_User_Attrs_To_Item
423: (p_api_version => 1.0
424: ,p_mode => p_transaction_type
425: ,p_item_id => p_inventory_item_id
520: END IF; --p_source_revision_id IS NULL
521:
522: IF l_source_revision_id IS NOT NULL THEN
523: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(
524: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
525: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
526:
527: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
528: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));
521:
522: IF l_source_revision_id IS NOT NULL THEN
523: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(
524: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
525: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
526:
527: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
528: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));
529: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
523: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(
524: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
525: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
526:
527: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
528: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));
529: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
530: p_api_version => 1.0
531: ,p_application_id => 431
524: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
525: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
526:
527: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
528: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));
529: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
530: p_api_version => 1.0
531: ,p_application_id => 431
532: ,p_object_name => 'EGO_ITEM'