[Home] [Help]
399: -- This API is used to populate Revised item details after eco creation.
400: ************************************************************************************/
401: PROCEDURE populate_revised_items_out
402: (p_change_order IN inv_ebi_change_order_obj
403: ,p_revised_item_type_tbl IN inv_ebi_revised_item_tbl
404: ,x_revised_item_type_tbl OUT NOCOPY inv_ebi_revitem_output_obj_tbl
405: )IS
406: l_organization_id NUMBER;
407: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
1035: l_return_status VARCHAR2(1);
1036: l_msg_count NUMBER;
1037: l_msg_data VARCHAR2(1000);
1038: l_eco_change_order_obj inv_ebi_change_order_obj;
1039: l_revised_item_tbl inv_ebi_revised_item_tbl;
1040: l_revised_item_obj inv_ebi_revised_item_obj;
1041: l_only_status_info VARCHAR2(1):= fnd_api.g_false;
1042: BEGIN
1043: x_return_status := FND_API.G_RET_STS_SUCCESS;
1049: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
1050: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
1051: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
1052: );
1053: l_revised_item_tbl := inv_ebi_revised_item_tbl();
1054: l_revised_item_obj := inv_ebi_revised_item_obj(
1055: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
1056: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
1057: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
1174: END LOOP;
1175: END IF;
1176:
1177: ----------------------------------------------------------------------------
1178: -- To Convert Date Fields in eco_revised_item_type(INV_EBI_REVISED_ITEM_TBL)
1179: ----------------------------------------------------------------------------
1180: IF(p_eco_lst_obj(i).eco_attr.eco_revised_item_type IS NOT NULL AND p_eco_lst_obj(i).eco_attr.eco_revised_item_type.COUNT>0) THEN
1181: FOR j IN p_eco_lst_obj(i).eco_attr.eco_revised_item_type.FIRST..p_eco_lst_obj(i).eco_attr.eco_revised_item_type.LAST LOOP
1182: x_eco_lst_obj(i).eco_attr.eco_revised_item_type(j).start_effective_date_str :=