DBA Data[Home] [Help]

APPS.EGO_UI_ITEM_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 1990: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', p_inventory_item_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),
1994: EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', x_organization_id));

Line 1991: EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', p_organization_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),
1994: EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', x_organization_id));
1995:

Line 1993: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', x_inventory_item_id),

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(
1997: -- EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION', NULL),

Line 1994: EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', x_organization_id));

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(
1997: -- EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION', NULL),
1998: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));

Line 1997: -- EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION', NULL),

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

Line 1998: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));

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),
2001: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
2002: l_new_cc_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 2000: -- EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION', NULL),

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));
2004: developer_debug(' Before calling EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data ');

Line 2001: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));

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));
2004: developer_debug(' Before calling EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data ');
2005: EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data (

Line 2003: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', p_Item_Catalog_Group_Id));

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
2007: ,p_application_id => l_application_id

Line 2044: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', l_item_rev_id));

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 ');
2048: OPEN c_get_orig_item_rev_details (cp_inventory_item_id => x_inventory_item_id

Line 2054: EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', l_item_rev_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;
2058: END IF;

Line 2062: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', p_Item_Catalog_Group_Id));

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
2066: ,p_object_id => l_object_id