APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on INV_EBI_CHANGE_ID_OBJ_TBL

Line 1434: p_change_lst IN inv_ebi_change_id_obj_tbl

1430: -- Function : This API to retrive change order for multiple change id
1431: --
1432: ************************************************************************************/
1433: PROCEDURE get_eco_list_attr(
1434: p_change_lst IN inv_ebi_change_id_obj_tbl
1435: ,p_name_val_list IN inv_ebi_name_value_list
1436: ,x_eco_lst_obj OUT NOCOPY inv_ebi_eco_out_obj_tbl
1437: ,x_return_status OUT NOCOPY VARCHAR2
1438: ,x_msg_count OUT NOCOPY NUMBER

Line 1451: l_mult_org_chg_id_temp inv_ebi_change_id_obj_tbl;

1447: l_name_val_list inv_ebi_name_value_list;
1448: l_eco_obj inv_ebi_eco_obj;
1449: l_eco_obj_tbl inv_ebi_eco_out_obj_tbl;
1450: l_eco_lst_obj inv_ebi_eco_out_obj;
1451: l_mult_org_chg_id_temp inv_ebi_change_id_obj_tbl;
1452: l_mult_org_chg_id_tbl inv_ebi_change_id_obj_tbl;
1453: l_eco_output_tbl_lst inv_ebi_change_id_obj_tbl;
1454:
1455: CURSOR c_get_multi_org_chg_id(p_chg_id NUMBER)

Line 1452: l_mult_org_chg_id_tbl inv_ebi_change_id_obj_tbl;

1448: l_eco_obj inv_ebi_eco_obj;
1449: l_eco_obj_tbl inv_ebi_eco_out_obj_tbl;
1450: l_eco_lst_obj inv_ebi_eco_out_obj;
1451: l_mult_org_chg_id_temp inv_ebi_change_id_obj_tbl;
1452: l_mult_org_chg_id_tbl inv_ebi_change_id_obj_tbl;
1453: l_eco_output_tbl_lst inv_ebi_change_id_obj_tbl;
1454:
1455: CURSOR c_get_multi_org_chg_id(p_chg_id NUMBER)
1456: IS

Line 1453: l_eco_output_tbl_lst inv_ebi_change_id_obj_tbl;

1449: l_eco_obj_tbl inv_ebi_eco_out_obj_tbl;
1450: l_eco_lst_obj inv_ebi_eco_out_obj;
1451: l_mult_org_chg_id_temp inv_ebi_change_id_obj_tbl;
1452: l_mult_org_chg_id_tbl inv_ebi_change_id_obj_tbl;
1453: l_eco_output_tbl_lst inv_ebi_change_id_obj_tbl;
1454:
1455: CURSOR c_get_multi_org_chg_id(p_chg_id NUMBER)
1456: IS
1457: SELECT inv_ebi_change_id_obj(geco.change_id,'N')

Line 1464: FROM THE (SELECT CAST(p_change_lst as inv_ebi_change_id_obj_tbl)

1460: where eec.change_id=p_chg_id
1461: and eec.change_notice=eec1.change_notice
1462: MINUS
1463: SELECT b.change_id
1464: FROM THE (SELECT CAST(p_change_lst as inv_ebi_change_id_obj_tbl)
1465: FROM dual) b ) geco;
1466:
1467: CURSOR c_get_final_eco_list IS
1468: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)

Line 1470: FROM THE (SELECT CAST( p_change_lst as inv_ebi_change_id_obj_tbl)

1466:
1467: CURSOR c_get_final_eco_list IS
1468: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
1469: FROM (SELECT b.change_id,b.last_update_status
1470: FROM THE (SELECT CAST( p_change_lst as inv_ebi_change_id_obj_tbl)
1471: FROM dual ) b
1472: UNION
1473: SELECT c.change_id,c.last_update_status
1474: FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)

Line 1474: FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)

1470: FROM THE (SELECT CAST( p_change_lst as inv_ebi_change_id_obj_tbl)
1471: FROM dual ) b
1472: UNION
1473: SELECT c.change_id,c.last_update_status
1474: FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)
1475: FROM dual ) c ) geco;
1476: BEGIN
1477: l_eco_obj_tbl := inv_ebi_eco_out_obj_tbl();
1478: l_name_val_list := p_name_val_list;

Line 1480: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();

1476: BEGIN
1477: l_eco_obj_tbl := inv_ebi_eco_out_obj_tbl();
1478: l_name_val_list := p_name_val_list;
1479: x_return_status := FND_API.G_RET_STS_SUCCESS;
1480: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();
1481: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();
1482:
1483: INV_EBI_ITEM_HELPER.set_server_time_zone;
1484:

Line 1481: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();

1477: l_eco_obj_tbl := inv_ebi_eco_out_obj_tbl();
1478: l_name_val_list := p_name_val_list;
1479: x_return_status := FND_API.G_RET_STS_SUCCESS;
1480: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();
1481: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();
1482:
1483: INV_EBI_ITEM_HELPER.set_server_time_zone;
1484:
1485: IF p_change_lst IS NOT NULL AND p_change_lst.COUNT > 0 THEN