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

Line 1766: l_orig_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1762: l_return_status VARCHAR2(10);
1763: l_error_code NUMBER;
1764: l_msg_data VARCHAR2(9999);
1765: l_application_id fnd_application.application_id%TYPE;
1766: l_orig_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1767: l_new_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1768: l_orig_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1769: l_new_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1770: l_new_cc_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 1767: l_new_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1763: l_error_code NUMBER;
1764: l_msg_data VARCHAR2(9999);
1765: l_application_id fnd_application.application_id%TYPE;
1766: l_orig_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1767: l_new_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1768: l_orig_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1769: l_new_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1770: l_new_cc_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1771: l_item_rev_id mtl_item_revisions_b.revision_id%TYPE;

Line 1768: l_orig_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1764: l_msg_data VARCHAR2(9999);
1765: l_application_id fnd_application.application_id%TYPE;
1766: l_orig_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1767: l_new_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1768: l_orig_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1769: l_new_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1770: l_new_cc_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1771: l_item_rev_id mtl_item_revisions_b.revision_id%TYPE;
1772: l_item_rev_code mtl_item_revisions_b.revision%TYPE;

Line 1769: l_new_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1765: l_application_id fnd_application.application_id%TYPE;
1766: l_orig_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1767: l_new_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1768: l_orig_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1769: l_new_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1770: l_new_cc_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1771: l_item_rev_id mtl_item_revisions_b.revision_id%TYPE;
1772: l_item_rev_code mtl_item_revisions_b.revision%TYPE;
1773: l_commit VARCHAR2(20);

Line 1770: l_new_cc_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1766: l_orig_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1767: l_new_item_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1768: l_orig_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1769: l_new_item_rev_pk_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1770: l_new_cc_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1771: l_item_rev_id mtl_item_revisions_b.revision_id%TYPE;
1772: l_item_rev_code mtl_item_revisions_b.revision%TYPE;
1773: l_commit VARCHAR2(20);
1774:

Line 1989: l_orig_item_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1985: developer_debug (' Application Id ' || to_char(l_application_id));
1986: developer_debug (' New Item Id ' || to_char(x_inventory_item_id));
1987: developer_debug (' New Org Id ' || to_char(x_organization_id));
1988: -- call the user attributes code for item level
1989: l_orig_item_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1990: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id),
1991: EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
1992: l_new_item_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1993: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', x_inventory_item_id),

Line 1992: l_new_item_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1988: -- call the user attributes code for item level
1989: l_orig_item_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1990: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_id),
1991: EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_id));
1992: l_new_item_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1993: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', x_inventory_item_id),
1994: EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', x_organization_id));
1995:
1996: l_orig_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 1996: l_orig_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1992: l_new_item_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1993: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', x_inventory_item_id),
1994: EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', x_organization_id));
1995:
1996: l_orig_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1997: -- EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION', NULL),
1998: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
1999: l_new_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2000: -- EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION', NULL),

Line 1999: l_new_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1995:
1996: l_orig_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1997: -- EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION', NULL),
1998: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
1999: l_new_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2000: -- EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION', NULL),
2001: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
2002: l_new_cc_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2003: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', p_Item_Catalog_Group_Id));

Line 2002: l_new_cc_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1998: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
1999: l_new_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2000: -- EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION', NULL),
2001: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
2002: l_new_cc_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2003: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', p_Item_Catalog_Group_Id));
2004: developer_debug(' Before calling EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data ');
2005: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data (
2006: p_api_version => 1.0

Line 2043: l_orig_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

2039: developer_debug(' 40 ');
2040: IF c_get_orig_item_rev_details%FOUND THEN
2041: CLOSE c_get_orig_item_rev_details;
2042: developer_debug(' 50 ');
2043: l_orig_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2044: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', l_item_rev_id));
2045: developer_debug(' 55 -- orig revision ' || l_item_rev_code);
2046: -- fetch the item revision of the newly created item.
2047: developer_debug(' 60 ');

Line 2053: l_new_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

2049: ,cp_organization_id => x_organization_id);
2050: FETCH c_get_orig_item_rev_details INTO l_item_rev_code, l_item_rev_id;
2051: IF c_get_orig_item_rev_details%FOUND THEN
2052: developer_debug(' 70 ');
2053: l_new_item_rev_pk_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2054: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', l_item_rev_id));
2055: developer_debug(' 75 -- new revision ' || l_item_rev_code);
2056: ELSE
2057: l_new_item_rev_pk_value_pairs := NULL;

Line 2061: l_new_cc_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

2057: l_new_item_rev_pk_value_pairs := NULL;
2058: END IF;
2059: developer_debug(' 80 ');
2060: CLOSE c_get_orig_item_rev_details;
2061: l_new_cc_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2062: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', p_Item_Catalog_Group_Id));
2063: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data (
2064: p_api_version => 1.0
2065: ,p_application_id => l_application_id