APPS.EGO_GTIN_PVT dependencies on EGO_EXT_FWK_PUB

Line 2508: IF (i.data_type_code = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR

2504: ' AND organization_id = :2';
2505:
2506: write_debug_log(l_api_name||': found data type code '||i.data_type_code);
2507:
2508: IF (i.data_type_code = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2509: i.data_type_code = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE)
2510: THEN
2511:
2512: EXECUTE IMMEDIATE l_old_query

Line 2509: i.data_type_code = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE)

2505:
2506: write_debug_log(l_api_name||': found data type code '||i.data_type_code);
2507:
2508: IF (i.data_type_code = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2509: i.data_type_code = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE)
2510: THEN
2511:
2512: EXECUTE IMMEDIATE l_old_query
2513: INTO l_attr_old_value_str

Line 2516: ELSIF (i.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)

2512: EXECUTE IMMEDIATE l_old_query
2513: INTO l_attr_old_value_str
2514: USING p_inventory_item_id, p_organization_id;
2515:
2516: ELSIF (i.data_type_code = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE)
2517: THEN
2518:
2519: EXECUTE IMMEDIATE l_old_query
2520: INTO l_attr_old_value_num

Line 2523: ELSIF (i.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

2519: EXECUTE IMMEDIATE l_old_query
2520: INTO l_attr_old_value_num
2521: USING p_inventory_item_id, p_organization_id;
2522:
2523: ELSIF (i.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2524: i.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
2525: THEN
2526:
2527: EXECUTE IMMEDIATE l_old_query

Line 2524: i.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)

2520: INTO l_attr_old_value_num
2521: USING p_inventory_item_id, p_organization_id;
2522:
2523: ELSIF (i.data_type_code = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2524: i.data_type_code = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
2525: THEN
2526:
2527: EXECUTE IMMEDIATE l_old_query
2528: INTO l_attr_old_value_date

Line 3190: l_object_id := EGO_EXT_FWK_PUB.Get_Object_Id_From_Name (p_object_name => G_ITEM_OBJECT_NAME) ;

3186: AND oa.attr_group_id = eag.attr_group_id
3187: AND eag.attr_group_type IN ('EGO_ITEM_GTIN_ATTRS', 'EGO_ITEM_GTIN_MULTI_ATTRS'));
3188:
3189: l_CatalogGroupIds(l_CatalogGroupIds.count +1) := -1;
3190: l_object_id := EGO_EXT_FWK_PUB.Get_Object_Id_From_Name (p_object_name => G_ITEM_OBJECT_NAME) ;
3191:
3192: --dbms_output.put_line('after selecting all catalogs');
3193: -- Since same attribute group names are used for all catalog groups fetch it before
3194: -- looping through catalog groups.