eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on INV_EBI_CHANGE_ID_OBJ

Line 1009: p_change_lst IN inv_ebi_change_id_obj_tbl

1005: -- Function : This API to retrive change order for multiple change id
1006: --
1007: ************************************************************************************/
1008: PROCEDURE get_eco_list_attr(
1009: p_change_lst IN inv_ebi_change_id_obj_tbl
1010: ,p_name_val_list IN inv_ebi_name_value_list
1011: ,x_eco_lst_obj OUT NOCOPY inv_ebi_eco_out_obj_tbl
1012: ,x_return_status OUT NOCOPY VARCHAR2
1013: ,x_msg_count OUT NOCOPY NUMBER

Line 1026: l_mult_org_chg_id_temp inv_ebi_change_id_obj_tbl;

1022: l_name_val_list inv_ebi_name_value_list;
1023: l_eco_obj inv_ebi_eco_obj;
1024: l_eco_obj_tbl inv_ebi_eco_out_obj_tbl;
1025: l_eco_lst_obj inv_ebi_eco_out_obj;
1026: l_mult_org_chg_id_temp inv_ebi_change_id_obj_tbl;
1027: l_mult_org_chg_id_tbl inv_ebi_change_id_obj_tbl;
1028: l_eco_output_tbl_lst inv_ebi_change_id_obj_tbl;
1029: l_get_multiorg_change VARCHAR2(1) := NULL;-- added for bug 13874263
1030:

Line 1027: l_mult_org_chg_id_tbl inv_ebi_change_id_obj_tbl;

1023: l_eco_obj inv_ebi_eco_obj;
1024: l_eco_obj_tbl inv_ebi_eco_out_obj_tbl;
1025: l_eco_lst_obj inv_ebi_eco_out_obj;
1026: l_mult_org_chg_id_temp inv_ebi_change_id_obj_tbl;
1027: l_mult_org_chg_id_tbl inv_ebi_change_id_obj_tbl;
1028: l_eco_output_tbl_lst inv_ebi_change_id_obj_tbl;
1029: l_get_multiorg_change VARCHAR2(1) := NULL;-- added for bug 13874263
1030:
1031: CURSOR c_get_multi_org_chg_id(p_chg_id NUMBER)

Line 1028: l_eco_output_tbl_lst inv_ebi_change_id_obj_tbl;

1024: l_eco_obj_tbl inv_ebi_eco_out_obj_tbl;
1025: l_eco_lst_obj inv_ebi_eco_out_obj;
1026: l_mult_org_chg_id_temp inv_ebi_change_id_obj_tbl;
1027: l_mult_org_chg_id_tbl inv_ebi_change_id_obj_tbl;
1028: l_eco_output_tbl_lst inv_ebi_change_id_obj_tbl;
1029: l_get_multiorg_change VARCHAR2(1) := NULL;-- added for bug 13874263
1030:
1031: CURSOR c_get_multi_org_chg_id(p_chg_id NUMBER)
1032: IS

Line 1033: SELECT inv_ebi_change_id_obj(geco.change_id,'N')

1029: l_get_multiorg_change VARCHAR2(1) := NULL;-- added for bug 13874263
1030:
1031: CURSOR c_get_multi_org_chg_id(p_chg_id NUMBER)
1032: IS
1033: SELECT inv_ebi_change_id_obj(geco.change_id,'N')
1034: FROM (SELECT eec1.change_id
1035: FROM eng_engineering_changes eec,eng_engineering_changes eec1
1036: where eec.change_id=p_chg_id
1037: and eec.change_notice=eec1.change_notice

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

1036: where eec.change_id=p_chg_id
1037: and eec.change_notice=eec1.change_notice
1038: MINUS
1039: SELECT b.change_id
1040: FROM THE (SELECT CAST(p_change_lst as inv_ebi_change_id_obj_tbl)
1041: FROM dual) b ) geco;
1042:
1043: CURSOR c_get_final_eco_list IS
1044: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)

Line 1044: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)

1040: FROM THE (SELECT CAST(p_change_lst as inv_ebi_change_id_obj_tbl)
1041: FROM dual) b ) geco;
1042:
1043: CURSOR c_get_final_eco_list IS
1044: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
1045: FROM (SELECT b.change_id,b.last_update_status
1046: FROM THE (SELECT CAST( p_change_lst as inv_ebi_change_id_obj_tbl)
1047: FROM dual ) b
1048: UNION

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

1042:
1043: CURSOR c_get_final_eco_list IS
1044: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
1045: FROM (SELECT b.change_id,b.last_update_status
1046: FROM THE (SELECT CAST( p_change_lst as inv_ebi_change_id_obj_tbl)
1047: FROM dual ) b
1048: UNION
1049: SELECT c.change_id,c.last_update_status
1050: FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)

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

1046: FROM THE (SELECT CAST( p_change_lst as inv_ebi_change_id_obj_tbl)
1047: FROM dual ) b
1048: UNION
1049: SELECT c.change_id,c.last_update_status
1050: FROM THE (SELECT CAST( l_mult_org_chg_id_tbl as inv_ebi_change_id_obj_tbl)
1051: FROM dual ) c ) geco;
1052: BEGIN
1053: l_eco_obj_tbl := inv_ebi_eco_out_obj_tbl();
1054: l_name_val_list := p_name_val_list;

Line 1062: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();

1058: INV_EBI_UTIL.set_apps_context(l_name_val_list.name_value_table);
1059: END IF;
1060: */
1061: x_return_status := FND_API.G_RET_STS_SUCCESS;
1062: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();
1063: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();
1064:
1065: INV_EBI_ITEM_HELPER.set_server_time_zone;
1066:

Line 1063: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();

1059: END IF;
1060: */
1061: x_return_status := FND_API.G_RET_STS_SUCCESS;
1062: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();
1063: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();
1064:
1065: INV_EBI_ITEM_HELPER.set_server_time_zone;
1066:
1067: INV_EBI_UTIL.setup();

Line 1111: l_eco_output_tbl_lst := inv_ebi_change_id_obj_tbl();

1107: OPEN c_get_final_eco_list;
1108: FETCH c_get_final_eco_list BULK COLLECT INTO l_eco_output_tbl_lst;
1109: CLOSE c_get_final_eco_list;
1110: ELSE -- else block added for bug 13874263
1111: l_eco_output_tbl_lst := inv_ebi_change_id_obj_tbl();
1112: l_eco_output_tbl_lst := p_change_lst;
1113: END IF;
1114: INV_EBI_UTIL.debug_line( 'Size of Change id table ' || l_eco_output_tbl_lst.COUNT);
1115: