DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on INV_EBI_REVITEM_OUTPUT_OBJ_TBL

Line 506: ,x_revised_item_type_tbl OUT NOCOPY inv_ebi_revitem_output_obj_tbl

502: ************************************************************************************/
503: PROCEDURE populate_revised_items_out
504: (p_change_order IN inv_ebi_change_order_obj
505: ,p_revised_item_type_tbl IN inv_ebi_revised_item_tbl
506: ,x_revised_item_type_tbl OUT NOCOPY inv_ebi_revitem_output_obj_tbl
507: )IS
508: l_organization_id NUMBER;
509: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
510: l_revised_item_type_tbl inv_ebi_revitem_output_obj_tbl;

Line 510: l_revised_item_type_tbl inv_ebi_revitem_output_obj_tbl;

506: ,x_revised_item_type_tbl OUT NOCOPY inv_ebi_revitem_output_obj_tbl
507: )IS
508: l_organization_id NUMBER;
509: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
510: l_revised_item_type_tbl inv_ebi_revitem_output_obj_tbl;
511: l_ouid NUMBER;
512: l_operating_unit VARCHAR2(240);
513: BEGIN
514: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.populate_revised_items_out');

Line 517: l_revised_item_type_tbl := inv_ebi_revitem_output_obj_tbl();

513: BEGIN
514: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.populate_revised_items_out');
515: INV_EBI_UTIL.debug_line('STEP 20: ECO: '|| p_change_order.eco_name || ' ORG CODE: '|| p_change_order.organization_code);
516: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
517: l_revised_item_type_tbl := inv_ebi_revitem_output_obj_tbl();
518: l_pk_col_name_val_pairs.EXTEND(1);
519: l_pk_col_name_val_pairs(1).name := 'organization_code';
520: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
521:

Line 1934: l_revitem_output_tbl inv_ebi_revitem_output_obj_tbl;

1930: l_curr_status_code NUMBER;
1931: l_status_code NUMBER;
1932: l_is_wf_Set BOOLEAN;
1933: l_is_plmwf_Set BOOLEAN;
1934: l_revitem_output_tbl inv_ebi_revitem_output_obj_tbl;
1935: l_revision VARCHAR2(3);
1936: l_change_type_code NUMBER;
1937: l_status_name VARCHAR2(30);
1938: l_out inv_ebi_eco_output_obj;

Line 1958: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();

1954: l_uda_output := inv_ebi_uda_output_obj(NULL,NULL);
1955: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1956: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1957:
1958: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();
1959:
1960: bom_globals.set_bo_identifier(bom_globals.g_eco_bo);
1961:
1962: INV_EBI_UTIL.debug_line('STEP 30: START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');

Line 2228: l_revitem_output_tbl inv_ebi_revitem_output_obj_tbl;

2224: l_eco_obj_tbl inv_ebi_eco_obj_tbl;
2225: l_upd_eco_name_tbl FND_TABLE_OF_VARCHAR2_30;
2226: l_upd_eco_idx_tbl FND_TABLE_OF_NUMBER;
2227: l_index NUMBER ;
2228: l_revitem_output_tbl inv_ebi_revitem_output_obj_tbl;
2229: l_output_status inv_ebi_output_status;
2230: l_count NUMBER;
2231: l_upd_item_cnt NUMBER := 0;
2232: l_upd_child_item_cnt NUMBER := 0;

Line 2265: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();

2261: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
2262:
2263: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2264: x_out := inv_ebi_eco_output_obj_tbl();
2265: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();
2266: l_eco_obj_tbl := inv_ebi_eco_obj_tbl();
2267: l_eco_obj_tbl := p_eco_obj_list;
2268:
2269: IF (l_eco_obj_tbl IS NOT NULL AND l_eco_obj_tbl.count > 0) THEN