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.INV_ITEM_REVISION_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 384: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

380: START WITH item_catalog_group_id = cp_catalog_group_id;
381:
382: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;
383: l_parent_catalog VARCHAR2(150):= NULL;
384: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
385: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
386: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
387: l_msg_count NUMBER;
388: l_error_code NUMBER;

Line 385: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

381:
382: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;
383: l_parent_catalog VARCHAR2(150):= NULL;
384: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
385: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
386: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
387: l_msg_count NUMBER;
388: l_error_code NUMBER;
389: l_msg_data VARCHAR2(2000);

Line 386: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

382: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;
383: l_parent_catalog VARCHAR2(150):= NULL;
384: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
385: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
386: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
387: l_msg_count NUMBER;
388: l_error_code NUMBER;
389: l_msg_data VARCHAR2(2000);
390: l_return_status VARCHAR2(1);

Line 414: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

410: WHEN OTHERS THEN
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)

Line 417: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

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(
421: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', p_revision_id));

Line 420: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

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
424: ,p_mode => p_transaction_type

Line 474: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

470: l_return_status VARCHAR2(100);
471: l_error_code NUMBER;
472: l_msg_count NUMBER ;
473: l_msg_data VARCHAR2(100);
474: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
475: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
476: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
477: l_item_rev_dl_id NUMBER ;
478:

Line 475: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;

471: l_error_code NUMBER;
472: l_msg_count NUMBER ;
473: l_msg_data VARCHAR2(100);
474: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
475: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
476: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
477: l_item_rev_dl_id NUMBER ;
478:
479: BEGIN

Line 476: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;

472: l_msg_count NUMBER ;
473: l_msg_data VARCHAR2(100);
474: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
475: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
476: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
477: l_item_rev_dl_id NUMBER ;
478:
479: BEGIN
480: --bug 9582139

Line 523: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

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'