DBA Data[Home] [Help]

APPS.INV_ITEM_REVISION_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 398: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)

394: NULL;
395: END;
396:
397: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
398: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)
399: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID' ,p_organization_id));
400: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
401: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
402: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));

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

395: END;
396:
397: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
398: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)
399: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID' ,p_organization_id));
400: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
401: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
402: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));
403: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 401: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)

397: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
398: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)
399: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID' ,p_organization_id));
400: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
401: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
402: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));
403: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
404: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', p_revision_id));
405: EGO_ITEM_PUB.Apply_Templ_User_Attrs_To_Item

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

398: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',p_inventory_item_id)
399: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID' ,p_organization_id));
400: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
401: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
402: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));
403: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
404: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', p_revision_id));
405: EGO_ITEM_PUB.Apply_Templ_User_Attrs_To_Item
406: (p_api_version => 1.0

Line 404: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', p_revision_id));

400: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
401: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID' ,l_catalog_group_id)
402: ,EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST_1',l_parent_catalog));
403: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
404: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', p_revision_id));
405: EGO_ITEM_PUB.Apply_Templ_User_Attrs_To_Item
406: (p_api_version => 1.0
407: ,p_mode => p_transaction_type
408: ,p_item_id => p_inventory_item_id

Line 499: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)

495: END IF; --p_source_revision_id IS NULL
496:
497: IF l_source_revision_id IS NOT NULL THEN
498: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(
499: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
500: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
501:
502: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
503: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));

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

496:
497: IF l_source_revision_id IS NOT NULL THEN
498: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(
499: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
500: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
501:
502: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
503: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));
504: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(

Line 502: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));

498: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(
499: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
500: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
501:
502: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
503: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));
504: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
505: p_api_version => 1.0
506: ,p_application_id => 431

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

499: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
500: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
501:
502: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
503: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));
504: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
505: p_api_version => 1.0
506: ,p_application_id => 431
507: ,p_object_name => 'EGO_ITEM'