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

Line 28: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

24: l_return_status VARCHAR2(100);
25: l_error_code NUMBER;
26: l_msg_count NUMBER ;
27: l_msg_data VARCHAR2(100);
28: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
29: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
30: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
31:
32: BEGIN

Line 29: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;

25: l_error_code NUMBER;
26: l_msg_count NUMBER ;
27: l_msg_data VARCHAR2(100);
28: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
29: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
30: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
31:
32: BEGIN
33: OPEN c_get_effective_revision(cp_inventory_item_id => p_inventory_item_id

Line 30: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;

26: l_msg_count NUMBER ;
27: l_msg_data VARCHAR2(100);
28: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
29: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
30: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
31:
32: BEGIN
33: OPEN c_get_effective_revision(cp_inventory_item_id => p_inventory_item_id
34: ,cp_organization_id => p_organization_id

Line 40: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(

36: FETCH c_get_effective_revision INTO l_source_revision_id;
37: CLOSE c_get_effective_revision;
38:
39: IF l_source_revision_id IS NOT NULL THEN
40: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(
41: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
42: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
43:
44: 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 44: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));

40: l_pk_item_pairs :=EGO_COL_NAME_VALUE_PAIR_ARRAY(
41: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
42: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
43:
44: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
45: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));
46: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
47: p_api_version => 1.0
48: ,p_application_id => 431

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

41: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id)
42: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
43:
44: l_pk_item_rev_pairs_src := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , l_source_revision_id));
45: l_pk_item_rev_pairs_dst := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , p_revision_id));
46: EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data(
47: p_api_version => 1.0
48: ,p_application_id => 431
49: ,p_object_name => 'EGO_ITEM'