DBA Data[Home] [Help]

APPS.INV_ITEM_REVISION_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 415: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)

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

Line 416: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID' ,p_organization_id));

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(

Line 418: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)

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

Line 419: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));

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

Line 421: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', p_revision_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
424: ,p_mode => p_transaction_type
425: ,p_item_id => p_inventory_item_id

Line 524: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_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));

Line 525: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_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(

Line 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));

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

Line 528: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));

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'