APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on INV_EBI_REVITEM_OUTPUT_OBJ_TBL

Line 404: ,x_revised_item_type_tbl OUT NOCOPY inv_ebi_revitem_output_obj_tbl

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;
408: l_revised_item_type_tbl inv_ebi_revitem_output_obj_tbl;

Line 408: l_revised_item_type_tbl inv_ebi_revitem_output_obj_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;
408: l_revised_item_type_tbl inv_ebi_revitem_output_obj_tbl;
409: l_ouid NUMBER;
410: l_operating_unit VARCHAR2(240);
411: BEGIN
412: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

Line 413: l_revised_item_type_tbl := inv_ebi_revitem_output_obj_tbl();

409: l_ouid NUMBER;
410: l_operating_unit VARCHAR2(240);
411: BEGIN
412: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
413: l_revised_item_type_tbl := inv_ebi_revitem_output_obj_tbl();
414: l_pk_col_name_val_pairs.EXTEND(1);
415: l_pk_col_name_val_pairs(1).name := 'organization_code';
416: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
417:

Line 521: l_revitem_output_tbl inv_ebi_revitem_output_obj_tbl;

517: l_assign_item_to_child_org VARCHAR2(1):= fnd_api.g_false;
518: l_update_item_tab FND_TABLE_OF_NUMBER;
519: l_update_item_index NUMBER := 0;
520: l_cnt_nmval NUMBER := 0;
521: l_revitem_output_tbl inv_ebi_revitem_output_obj_tbl;
522: l_master_org NUMBER;
523: l_inventory_item_id NUMBER;
524: l_current_revision VARCHAR2(3);
525: l_revision VARCHAR2(3);

Line 557: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();

553: l_item_obj_tbl := inv_ebi_item_attr_tbl();
554: l_update_item_tab := FND_TABLE_OF_NUMBER();
555:
556: l_eco_obj_validate_eco := p_eco_obj;
557: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();
558: IF(p_eco_obj.eco_revised_item_type IS NOT NULL AND p_eco_obj.eco_change_order_type IS NOT NULL) THEN
559: FOR i IN 1 .. l_eco_obj_validate_eco.eco_revised_item_type.COUNT
560: LOOP
561: --To populate item attributes from revised item values.