[Home] [Help]
2982: END get_item_category;
2983:
2984:
2985: FUNCTION table_of_number_contains (
2986: p_table IN FND_TABLE_OF_NUMBER
2987: , p_value IN NUMBER
2988: ) RETURN BOOLEAN
2989: IS
2990: BEGIN
3114: l_category_output inv_ebi_category_output_obj;
3115: l_output_status inv_ebi_output_status;
3116: l_category_id NUMBER;
3117: l_old_item_category NUMBER;
3118: l_no_multi_assign_cat_set_tbl FND_TABLE_OF_NUMBER;
3119: BEGIN
3120: SAVEPOINT inv_ebi_cat_id_save_pnt;
3121: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
3122: INV_EBI_UTIL.debug_line('STEP 20: ITEM ID: '|| p_inventory_item_id || 'ORG ID: '|| p_organization_id);
3123: l_category_output := inv_ebi_category_output_obj(NULL);
3124: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3125: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL,NULL);
3126: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.process_item_cat_assignment');
3127: l_no_multi_assign_cat_set_tbl :=FND_TABLE_OF_NUMBER();
3128: FOR i IN 1..p_category_id_tbl.COUNT LOOP
3129: l_category_id := p_category_id_tbl(i).cat_id;
3130:
3131: IF is_category_set_multi_assign(p_category_id_tbl(i).cat_set_id) THEN
4541: PROCEDURE get_uda_attributes(
4542: p_classification_id IN NUMBER,
4543: p_attr_group_type IN VARCHAR2,
4544: p_application_id IN NUMBER,
4545: p_attr_grp_id_tbl IN FND_TABLE_OF_NUMBER,
4546: p_data_level IN VARCHAR2,
4547: p_revision_id IN NUMBER,
4548: p_object_name IN VARCHAR2,
4549: p_pk_data IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
4813: l_count NUMBER :=0;
4814: l_item_uda_count NUMBER :=0;
4815: l_attr_group_count NUMBER :=0;
4816: l_application_id NUMBER;
4817: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
4818: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
4819: l_uda_output_obj inv_ebi_eco_output_obj;
4820: l_output_status inv_ebi_output_status;
4821: