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 367: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

363: START WITH item_catalog_group_id = cp_catalog_group_id;
364:
365: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;
366: l_parent_catalog VARCHAR2(150):= NULL;
367: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
368: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
369: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
370: l_msg_count NUMBER;
371: l_error_code NUMBER;

Line 368: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

364:
365: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;
366: l_parent_catalog VARCHAR2(150):= NULL;
367: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
368: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
369: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
370: l_msg_count NUMBER;
371: l_error_code NUMBER;
372: l_msg_data VARCHAR2(2000);

Line 369: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

365: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;
366: l_parent_catalog VARCHAR2(150):= NULL;
367: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
368: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
369: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
370: l_msg_count NUMBER;
371: l_error_code NUMBER;
372: l_msg_data VARCHAR2(2000);
373: l_return_status VARCHAR2(1);

Line 397: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 400: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 403: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 457: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

453: l_return_status VARCHAR2(100);
454: l_error_code NUMBER;
455: l_msg_count NUMBER ;
456: l_msg_data VARCHAR2(100);
457: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
458: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
459: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
460:
461: BEGIN

Line 458: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;

454: l_error_code NUMBER;
455: l_msg_count NUMBER ;
456: l_msg_data VARCHAR2(100);
457: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
458: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
459: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
460:
461: BEGIN
462: IF p_source_revision_id IS NULL THEN

Line 459: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;

455: l_msg_count NUMBER ;
456: l_msg_data VARCHAR2(100);
457: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
458: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
459: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
460:
461: BEGIN
462: IF p_source_revision_id IS NULL THEN
463: -- API User has not passed in any Source Revision Id.

Line 498: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

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'