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_HELPER dependencies on INV_EBI_CHANGE_ID_OBJ

Line 6027: ,p_eco_tbl IN inv_ebi_change_id_obj_tbl

6023: ************************************************************************************/
6024:
6025: PROCEDURE filter_ecos_based_on_org(
6026: p_org_codes IN VARCHAR2
6027: ,p_eco_tbl IN inv_ebi_change_id_obj_tbl
6028: ,x_eco_tbl OUT NOCOPY inv_ebi_change_id_obj_tbl
6029: ,x_return_status OUT NOCOPY VARCHAR2
6030: ,x_msg_count OUT NOCOPY NUMBER
6031: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 6028: ,x_eco_tbl OUT NOCOPY inv_ebi_change_id_obj_tbl

6024:
6025: PROCEDURE filter_ecos_based_on_org(
6026: p_org_codes IN VARCHAR2
6027: ,p_eco_tbl IN inv_ebi_change_id_obj_tbl
6028: ,x_eco_tbl OUT NOCOPY inv_ebi_change_id_obj_tbl
6029: ,x_return_status OUT NOCOPY VARCHAR2
6030: ,x_msg_count OUT NOCOPY NUMBER
6031: ,x_msg_data OUT NOCOPY VARCHAR2)
6032: IS

Line 6034: l_eco_output_tbl inv_ebi_change_id_obj_tbl;

6030: ,x_msg_count OUT NOCOPY NUMBER
6031: ,x_msg_data OUT NOCOPY VARCHAR2)
6032: IS
6033: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
6034: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
6035: l_counter NUMBER:=0;
6036: l_org_code VARCHAR2(10);
6037: BEGIN
6038: x_return_status := FND_API.g_ret_sts_success;

Line 6041: l_eco_output_tbl := inv_ebi_change_id_obj_tbl();

6037: BEGIN
6038: x_return_status := FND_API.g_ret_sts_success;
6039: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.filter_ecos_based_on_org');
6040: INV_EBI_UTIL.debug_line('STEP 20: ORG CODES'||p_org_codes);
6041: l_eco_output_tbl := inv_ebi_change_id_obj_tbl();
6042:
6043: IF p_org_codes IS NOT NULL THEN
6044: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);
6045: END IF;

Line 6090: ,x_eco_tbl OUT NOCOPY inv_ebi_change_id_obj_tbl

6086: *****************************************************************************************************/
6087: PROCEDURE parse_and_get_eco(
6088: p_eco_names IN VARCHAR2
6089: ,p_org_codes IN VARCHAR2
6090: ,x_eco_tbl OUT NOCOPY inv_ebi_change_id_obj_tbl
6091: ,x_return_status OUT NOCOPY VARCHAR2
6092: ,x_msg_count OUT NOCOPY NUMBER
6093: ,x_msg_data OUT NOCOPY VARCHAR2)
6094: IS

Line 6103: l_eco_obj inv_ebi_change_id_obj;

6099: l_count NUMBER:=0;
6100: l_counter NUMBER := 0;
6101: l_entity_exist NUMBER :=0;
6102: l_entity_count NUMBER :=0;
6103: l_eco_obj inv_ebi_change_id_obj;
6104: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
6105: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;
6106: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
6107: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;

Line 6104: l_eco_output_tbl inv_ebi_change_id_obj_tbl;

6100: l_counter NUMBER := 0;
6101: l_entity_exist NUMBER :=0;
6102: l_entity_count NUMBER :=0;
6103: l_eco_obj inv_ebi_change_id_obj;
6104: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
6105: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;
6106: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
6107: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;
6108: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;

Line 6119: l_eco_output_tbl :=inv_ebi_change_id_obj_tbl();

6115: x_return_status := FND_API.g_ret_sts_success;
6116: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco');
6117: INV_EBI_UTIL.debug_line('STEP 20: CHANGE ORDER NAMES '|| p_eco_names);
6118: INV_EBI_UTIL.debug_line('STEP 30: ORG CODE NAMES '|| p_org_codes);
6119: l_eco_output_tbl :=inv_ebi_change_id_obj_tbl();
6120:
6121: IF p_eco_names IS NOT NULL THEN
6122: l_eco_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_eco_names);
6123: END IF;

Line 6227: l_eco_obj := inv_ebi_change_id_obj( l_chg_id, 'Y');

6223: END;
6224:
6225: IF l_chg_id IS NOT NULL THEN
6226: l_counter := l_counter + 1;
6227: l_eco_obj := inv_ebi_change_id_obj( l_chg_id, 'Y');
6228: l_eco_output_tbl.EXTEND(1);
6229: l_eco_output_tbl(l_counter) := l_eco_obj;
6230: l_count := 1;
6231: END IF;

Line 6237: l_eco_obj := inv_ebi_change_id_obj( cur.change_id, 'Y');

6233: END LOOP;
6234: ELSE
6235: FOR cur IN c_get_all_orgs(l_valid_eco_tbl(i)) LOOP
6236: l_counter := l_counter + 1;
6237: l_eco_obj := inv_ebi_change_id_obj( cur.change_id, 'Y');
6238: l_eco_output_tbl.EXTEND(1);
6239: l_eco_output_tbl(l_counter) := l_eco_obj;
6240: l_count := 1;
6241: END LOOP;

Line 6289: ,x_eco OUT NOCOPY inv_ebi_change_id_obj_tbl

6285: PROCEDURE get_eco_list(
6286: p_name_value_list IN inv_ebi_name_value_tbl
6287: ,p_prog_id IN NUMBER
6288: ,p_appl_id IN NUMBER
6289: ,x_eco OUT NOCOPY inv_ebi_change_id_obj_tbl
6290: ,x_return_status OUT NOCOPY VARCHAR2
6291: ,x_msg_count OUT NOCOPY NUMBER
6292: ,x_msg_data OUT NOCOPY VARCHAR2
6293: )

Line 6295: l_eco inv_ebi_change_id_obj_tbl;

6291: ,x_msg_count OUT NOCOPY NUMBER
6292: ,x_msg_data OUT NOCOPY VARCHAR2
6293: )
6294: IS
6295: l_eco inv_ebi_change_id_obj_tbl;
6296: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
6297: l_eco_org_output_tbl inv_ebi_change_id_obj_tbl;
6298: l_eco_tbl inv_ebi_change_id_obj_tbl;
6299: l_eco_string VARCHAR2(32000);

Line 6296: l_eco_output_tbl inv_ebi_change_id_obj_tbl;

6292: ,x_msg_data OUT NOCOPY VARCHAR2
6293: )
6294: IS
6295: l_eco inv_ebi_change_id_obj_tbl;
6296: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
6297: l_eco_org_output_tbl inv_ebi_change_id_obj_tbl;
6298: l_eco_tbl inv_ebi_change_id_obj_tbl;
6299: l_eco_string VARCHAR2(32000);
6300: l_org_string VARCHAR2(2000);

Line 6297: l_eco_org_output_tbl inv_ebi_change_id_obj_tbl;

6293: )
6294: IS
6295: l_eco inv_ebi_change_id_obj_tbl;
6296: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
6297: l_eco_org_output_tbl inv_ebi_change_id_obj_tbl;
6298: l_eco_tbl inv_ebi_change_id_obj_tbl;
6299: l_eco_string VARCHAR2(32000);
6300: l_org_string VARCHAR2(2000);
6301: l_from_date_str VARCHAR2(30);

Line 6298: l_eco_tbl inv_ebi_change_id_obj_tbl;

6294: IS
6295: l_eco inv_ebi_change_id_obj_tbl;
6296: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
6297: l_eco_org_output_tbl inv_ebi_change_id_obj_tbl;
6298: l_eco_tbl inv_ebi_change_id_obj_tbl;
6299: l_eco_string VARCHAR2(32000);
6300: l_org_string VARCHAR2(2000);
6301: l_from_date_str VARCHAR2(30);
6302: l_to_date_str VARCHAR2(30);

Line 6311: SELECT inv_ebi_change_id_obj(eci.change_id, 'Y')

6307: l_msg_data VARCHAR2(2000);
6308: l_msg_count NUMBER;
6309:
6310: CURSOR c_get_eco_chgid IS
6311: SELECT inv_ebi_change_id_obj(eci.change_id, 'Y')
6312: FROM(
6313: SELECT eec.change_id
6314: FROM eng_engineering_changes eec
6315: WHERE eec.last_update_date <> eec.creation_date

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

6322: AND eri.last_update_date >= l_from_date
6323: AND eri.last_update_date <= l_to_date ) eci;
6324:
6325: CURSOR c_get_final_eco_list IS
6326: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
6327: FROM (SELECT b.change_id,b.last_update_status
6328: FROM THE (SELECT CAST( l_eco as inv_ebi_change_id_obj_tbl)
6329: FROM dual ) b
6330: INTERSECT

Line 6328: FROM THE (SELECT CAST( l_eco as inv_ebi_change_id_obj_tbl)

6324:
6325: CURSOR c_get_final_eco_list IS
6326: SELECT inv_ebi_change_id_obj(geco.change_id,geco.last_update_status)
6327: FROM (SELECT b.change_id,b.last_update_status
6328: FROM THE (SELECT CAST( l_eco as inv_ebi_change_id_obj_tbl)
6329: FROM dual ) b
6330: INTERSECT
6331: SELECT c.change_id,c.last_update_status
6332: FROM THE (SELECT CAST( l_eco_output_tbl as inv_ebi_change_id_obj_tbl)

Line 6332: FROM THE (SELECT CAST( l_eco_output_tbl as inv_ebi_change_id_obj_tbl)

6328: FROM THE (SELECT CAST( l_eco as inv_ebi_change_id_obj_tbl)
6329: FROM dual ) b
6330: INTERSECT
6331: SELECT c.change_id,c.last_update_status
6332: FROM THE (SELECT CAST( l_eco_output_tbl as inv_ebi_change_id_obj_tbl)
6333: FROM dual ) c ) geco;
6334: l_ind_val NUMBER :=1;
6335: BEGIN
6336: FND_MSG_PUB.initialize();

Line 6401: l_eco := inv_ebi_change_id_obj_tbl();

6397: END IF;
6398: END IF;
6399:
6400: x_eco := l_eco_output_tbl;
6401: l_eco := inv_ebi_change_id_obj_tbl();
6402:
6403: IF (l_from_date IS NOT NULL AND l_to_date IS NOT NULL) THEN
6404: IF (c_get_eco_chgid%ISOPEN) THEN
6405: CLOSE c_get_eco_chgid;