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_ECO_OBJ

Line 599: ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj

595: p_change_id IN NUMBER
596: ,p_last_update_status IN VARCHAR2
597: ,p_revised_item_sequence_id IN NUMBER
598: ,p_name_val_list IN inv_ebi_name_value_list
599: ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj
600: ,x_return_status OUT NOCOPY VARCHAR2
601: ,x_msg_count OUT NOCOPY NUMBER
602: ,x_msg_data OUT NOCOPY VARCHAR2
603: )

Line 605: l_eco_obj inv_ebi_eco_obj;

601: ,x_msg_count OUT NOCOPY NUMBER
602: ,x_msg_data OUT NOCOPY VARCHAR2
603: )
604: IS
605: l_eco_obj inv_ebi_eco_obj;
606: l_return_status VARCHAR2(1);
607: l_msg_count NUMBER;
608: l_msg_data VARCHAR2(1000);
609: l_eco_change_order_obj inv_ebi_change_order_obj;

Line 671: x_eco_obj := inv_ebi_eco_obj(l_eco_change_order_obj,NULL,l_revised_item_tbl,NULL);

667: l_revised_item_obj.status_name := l_eco_obj.eco_revised_item_type(i).status_name;
668: l_revised_item_obj.new_effective_date := l_eco_obj.eco_revised_item_type(i).new_effective_date;
669: l_revised_item_tbl(i) := l_revised_item_obj;
670: END LOOP;
671: x_eco_obj := inv_ebi_eco_obj(l_eco_change_order_obj,NULL,l_revised_item_tbl,NULL);
672: ELSE
673: x_eco_obj := l_eco_obj;
674: END IF;
675: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_PUB.get_eco STATUS: '|| x_return_status);

Line 1023: l_eco_obj inv_ebi_eco_obj;

1019: l_ovrflw_msg VARCHAR2(1):='N';
1020: l_count NUMBER := 0;
1021: l_part_msgtxt VARCHAR2(32000);
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;

Line 1184: ,p_eco_obj IN inv_ebi_eco_obj

1180: ************************************************************************************/
1181:
1182: PROCEDURE process_change_order_items(
1183: p_commit IN VARCHAR2 := FND_API.g_false
1184: ,p_eco_obj IN inv_ebi_eco_obj
1185: ,p_update_item_tbl IN inv_ebi_item_attr_tbl
1186: ,x_update_item_tbl OUT NOCOPY inv_ebi_item_attr_tbl
1187: ,x_out OUT NOCOPY inv_ebi_item_output_obj
1188: ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj

Line 1188: ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj

1184: ,p_eco_obj IN inv_ebi_eco_obj
1185: ,p_update_item_tbl IN inv_ebi_item_attr_tbl
1186: ,x_update_item_tbl OUT NOCOPY inv_ebi_item_attr_tbl
1187: ,x_out OUT NOCOPY inv_ebi_item_output_obj
1188: ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj
1189: ) IS
1190:
1191: l_item inv_ebi_item_obj;
1192: l_revised_item_tbl inv_ebi_revised_item_tbl;

Line 1193: l_eco_obj inv_ebi_eco_obj;

1189: ) IS
1190:
1191: l_item inv_ebi_item_obj;
1192: l_revised_item_tbl inv_ebi_revised_item_tbl;
1193: l_eco_obj inv_ebi_eco_obj;
1194: l_master_org NUMBER;
1195: l_inventory_item_id NUMBER;
1196: l_current_revision VARCHAR2(3);
1197: l_revision VARCHAR2(3);

Line 1587: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl

1583: -- Added this API for Bug 8397083
1584: ************************************************************************************/
1585: PROCEDURE process_bom(
1586: p_commit IN VARCHAR2 := FND_API.g_false
1587: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
1588: ,x_eco_obj_list OUT NOCOPY inv_ebi_eco_obj_tbl
1589: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1590: ) IS
1591:

Line 1588: ,x_eco_obj_list OUT NOCOPY inv_ebi_eco_obj_tbl

1584: ************************************************************************************/
1585: PROCEDURE process_bom(
1586: p_commit IN VARCHAR2 := FND_API.g_false
1587: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
1588: ,x_eco_obj_list OUT NOCOPY inv_ebi_eco_obj_tbl
1589: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1590: ) IS
1591:
1592: l_eco_obj inv_ebi_eco_obj;

Line 1592: l_eco_obj inv_ebi_eco_obj;

1588: ,x_eco_obj_list OUT NOCOPY inv_ebi_eco_obj_tbl
1589: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1590: ) IS
1591:
1592: l_eco_obj inv_ebi_eco_obj;
1593: l_replicate_bom_item_obj inv_ebi_revised_item_obj;
1594: l_common_assy_item_tbl inv_ebi_revised_item_tbl;
1595: l_replicate_bom_tbl inv_ebi_revised_item_tbl;
1596: l_common_assy_item_cnt NUMBER := 0;

Line 1626: x_eco_obj_list := inv_ebi_eco_obj_tbl();

1622: l_common_org_tbl := FND_TABLE_OF_VARCHAR2_30();
1623: l_replicate_bom_org_tbl := FND_TABLE_OF_VARCHAR2_30();
1624: l_common_eco_tbl := FND_TABLE_OF_VARCHAR2_30();
1625: l_replicate_bom_eco_tbl := FND_TABLE_OF_VARCHAR2_30();
1626: x_eco_obj_list := inv_ebi_eco_obj_tbl();
1627: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_bom');
1628: IF(p_eco_obj_list IS NOT NULL AND p_eco_obj_list.COUNT > 0) THEN
1629: x_eco_obj_list.EXTEND(p_eco_obj_list.COUNT);
1630:

Line 1921: ,p_eco_obj IN inv_ebi_eco_obj

1917: ************************************************************************************/
1918:
1919: PROCEDURE process_change_order(
1920: p_commit IN VARCHAR2 := FND_API.g_false
1921: ,p_eco_obj IN inv_ebi_eco_obj
1922: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1923: ) IS
1924:
1925: l_change_id NUMBER;

Line 2205: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl

2201: ************************************************************************************/
2202:
2203: PROCEDURE process_change_order_list_core(
2204: p_commit IN VARCHAR2 := fnd_api.g_false
2205: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
2206: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
2207: ,x_return_status OUT NOCOPY VARCHAR2
2208: ,x_msg_count OUT NOCOPY NUMBER
2209: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2212: l_inv_ebi_eco_obj inv_ebi_eco_obj;

2208: ,x_msg_count OUT NOCOPY NUMBER
2209: ,x_msg_data OUT NOCOPY VARCHAR2
2210: )
2211: IS
2212: l_inv_ebi_eco_obj inv_ebi_eco_obj;
2213: l_eco_obj inv_ebi_eco_obj;
2214: l_inv_ebi_eco_output_obj inv_ebi_eco_output_obj;
2215: l_part_err_msg VARCHAR2(32000);
2216: l_eco_name VARCHAR2(10);

Line 2213: l_eco_obj inv_ebi_eco_obj;

2209: ,x_msg_data OUT NOCOPY VARCHAR2
2210: )
2211: IS
2212: l_inv_ebi_eco_obj inv_ebi_eco_obj;
2213: l_eco_obj inv_ebi_eco_obj;
2214: l_inv_ebi_eco_output_obj inv_ebi_eco_output_obj;
2215: l_part_err_msg VARCHAR2(32000);
2216: l_eco_name VARCHAR2(10);
2217: l_org_code VARCHAR2(3);

Line 2223: l_eco_obj_list inv_ebi_eco_obj_tbl;

2219: l_updated_item_tbl inv_ebi_item_attr_tbl;
2220: l_upd_item_tbl inv_ebi_item_attr_tbl;
2221: l_assign_item_to_child_org VARCHAR2(1):= fnd_api.g_false;
2222: l_item_output_obj inv_ebi_item_output_obj;
2223: l_eco_obj_list inv_ebi_eco_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 ;

Line 2224: l_eco_obj_tbl inv_ebi_eco_obj_tbl;

2220: l_upd_item_tbl inv_ebi_item_attr_tbl;
2221: l_assign_item_to_child_org VARCHAR2(1):= fnd_api.g_false;
2222: l_item_output_obj inv_ebi_item_output_obj;
2223: l_eco_obj_list inv_ebi_eco_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;

Line 2266: l_eco_obj_tbl := inv_ebi_eco_obj_tbl();

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
2270:

Line 2281: l_inv_ebi_eco_obj := l_eco_obj_tbl(i);

2277:
2278:
2279: FOR i in 1..l_eco_obj_tbl.count
2280: LOOP
2281: l_inv_ebi_eco_obj := l_eco_obj_tbl(i);
2282: l_eco_name := l_eco_obj_tbl(i).eco_change_order_type.eco_name;
2283: l_org_code := l_eco_obj_tbl(i).eco_change_order_type.organization_code;
2284:
2285: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);

Line 2297: ,p_eco_obj => l_inv_ebi_eco_obj

2293:
2294: --To Create Items in Master Org
2295: INV_EBI_CHANGE_ORDER_PUB.process_change_order_items(
2296: p_commit => p_commit
2297: ,p_eco_obj => l_inv_ebi_eco_obj
2298: ,p_update_item_tbl => l_upd_item_tbl
2299: ,x_update_item_tbl => l_updated_item_tbl
2300: ,x_out => l_item_output_obj
2301: ,x_eco_obj => l_eco_obj

Line 2336: l_inv_ebi_eco_obj := l_eco_obj_tbl(i);

2332:
2333: FOR i in 1..l_eco_obj_tbl.count
2334: LOOP
2335:
2336: l_inv_ebi_eco_obj := l_eco_obj_tbl(i);
2337: l_eco_name := l_eco_obj_tbl(i).eco_change_order_type.eco_name;
2338: l_org_code := l_eco_obj_tbl(i).eco_change_order_type.organization_code;
2339: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
2340:

Line 2353: ,p_eco_obj => l_inv_ebi_eco_obj

2349: l_upd_item_tbl := l_updated_item_tbl;
2350:
2351: INV_EBI_CHANGE_ORDER_PUB.process_change_order_items(
2352: p_commit => p_commit
2353: ,p_eco_obj => l_inv_ebi_eco_obj
2354: ,p_update_item_tbl => l_upd_item_tbl
2355: ,x_update_item_tbl => l_updated_item_tbl
2356: ,x_out => l_item_output_obj
2357: ,x_eco_obj => l_eco_obj

Line 2393: IF l_inv_ebi_eco_obj.name_value_tbl IS NOT NULL THEN

2389:
2390: END IF;
2391: END LOOP;
2392:
2393: IF l_inv_ebi_eco_obj.name_value_tbl IS NOT NULL THEN
2394: FOR i in l_inv_ebi_eco_obj.name_value_tbl.FIRST..l_inv_ebi_eco_obj.name_value_tbl.LAST LOOP
2395: IF (UPPER(l_inv_ebi_eco_obj.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN
2396: l_assign_item_to_child_org := l_inv_ebi_eco_obj.name_value_tbl(i).param_value;
2397: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(

Line 2394: FOR i in l_inv_ebi_eco_obj.name_value_tbl.FIRST..l_inv_ebi_eco_obj.name_value_tbl.LAST LOOP

2390: END IF;
2391: END LOOP;
2392:
2393: IF l_inv_ebi_eco_obj.name_value_tbl IS NOT NULL THEN
2394: FOR i in l_inv_ebi_eco_obj.name_value_tbl.FIRST..l_inv_ebi_eco_obj.name_value_tbl.LAST LOOP
2395: IF (UPPER(l_inv_ebi_eco_obj.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN
2396: l_assign_item_to_child_org := l_inv_ebi_eco_obj.name_value_tbl(i).param_value;
2397: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(
2398: p_assign_item => l_assign_item_to_child_org

Line 2395: IF (UPPER(l_inv_ebi_eco_obj.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN

2391: END LOOP;
2392:
2393: IF l_inv_ebi_eco_obj.name_value_tbl IS NOT NULL THEN
2394: FOR i in l_inv_ebi_eco_obj.name_value_tbl.FIRST..l_inv_ebi_eco_obj.name_value_tbl.LAST LOOP
2395: IF (UPPER(l_inv_ebi_eco_obj.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN
2396: l_assign_item_to_child_org := l_inv_ebi_eco_obj.name_value_tbl(i).param_value;
2397: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(
2398: p_assign_item => l_assign_item_to_child_org
2399: );

Line 2396: l_assign_item_to_child_org := l_inv_ebi_eco_obj.name_value_tbl(i).param_value;

2392:
2393: IF l_inv_ebi_eco_obj.name_value_tbl IS NOT NULL THEN
2394: FOR i in l_inv_ebi_eco_obj.name_value_tbl.FIRST..l_inv_ebi_eco_obj.name_value_tbl.LAST LOOP
2395: IF (UPPER(l_inv_ebi_eco_obj.name_value_tbl(i).param_name) = INV_EBI_CHANGE_ORDER_HELPER.G_ASSIGN_ITEM_TO_CHILD_ORG) THEN
2396: l_assign_item_to_child_org := l_inv_ebi_eco_obj.name_value_tbl(i).param_value;
2397: INV_EBI_CHANGE_ORDER_HELPER.set_assign_item(
2398: p_assign_item => l_assign_item_to_child_org
2399: );
2400: END IF;

Line 2466: l_inv_ebi_eco_obj := l_eco_obj_list(i);

2462: END IF;
2463:
2464: FOR i in 1..l_eco_obj_list.COUNT
2465: LOOP
2466: l_inv_ebi_eco_obj := l_eco_obj_list(i);
2467: l_eco_name := l_eco_obj_list(i).eco_change_order_type.eco_name;
2468: l_org_code := l_eco_obj_list(i).eco_change_order_type.organization_code;
2469: INV_EBI_UTIL.debug_line('STEP 100: BEFORE CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order');
2470:

Line 2473: ,p_eco_obj => l_inv_ebi_eco_obj

2469: INV_EBI_UTIL.debug_line('STEP 100: BEFORE CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order');
2470:
2471: process_change_order(
2472: p_commit => p_commit
2473: ,p_eco_obj => l_inv_ebi_eco_obj
2474: ,x_out => l_inv_ebi_eco_output_obj
2475: );
2476: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order STATUS '|| l_inv_ebi_eco_output_obj.output_status.return_status);
2477: x_out(i) := l_inv_ebi_eco_output_obj;

Line 2572: l_inv_ebi_eco_obj := l_eco_obj_list(i);

2568: INV_EBI_UTIL.debug_line('STEP 170: START CALLING populate_revised_items_out');
2569:
2570: FOR i in 1..l_eco_obj_list.COUNT LOOP
2571:
2572: l_inv_ebi_eco_obj := l_eco_obj_list(i);
2573: populate_revised_items_out(
2574: p_change_order => l_inv_ebi_eco_obj.eco_change_order_type
2575: ,p_revised_item_type_tbl => l_inv_ebi_eco_obj.eco_revised_item_type
2576: ,x_revised_item_type_tbl => l_revitem_output_tbl

Line 2574: p_change_order => l_inv_ebi_eco_obj.eco_change_order_type

2570: FOR i in 1..l_eco_obj_list.COUNT LOOP
2571:
2572: l_inv_ebi_eco_obj := l_eco_obj_list(i);
2573: populate_revised_items_out(
2574: p_change_order => l_inv_ebi_eco_obj.eco_change_order_type
2575: ,p_revised_item_type_tbl => l_inv_ebi_eco_obj.eco_revised_item_type
2576: ,x_revised_item_type_tbl => l_revitem_output_tbl
2577: );
2578: x_out(i).item_output_tbl := l_revitem_output_tbl;

Line 2575: ,p_revised_item_type_tbl => l_inv_ebi_eco_obj.eco_revised_item_type

2571:
2572: l_inv_ebi_eco_obj := l_eco_obj_list(i);
2573: populate_revised_items_out(
2574: p_change_order => l_inv_ebi_eco_obj.eco_change_order_type
2575: ,p_revised_item_type_tbl => l_inv_ebi_eco_obj.eco_revised_item_type
2576: ,x_revised_item_type_tbl => l_revitem_output_tbl
2577: );
2578: x_out(i).item_output_tbl := l_revitem_output_tbl;
2579: END LOOP;

Line 2634: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl

2630: ************************************************************************************/
2631:
2632: PROCEDURE process_change_order_list(
2633: p_commit IN VARCHAR2 := fnd_api.g_false
2634: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
2635: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
2636: ,x_return_status OUT NOCOPY VARCHAR2
2637: ,x_msg_count OUT NOCOPY NUMBER
2638: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2685: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl

2681: --
2682: ************************************************************************************/
2683: PROCEDURE validate_change_order_list(
2684: p_commit IN VARCHAR2 := fnd_api.g_false
2685: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
2686: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
2687: ,x_return_status OUT NOCOPY VARCHAR2
2688: ,x_msg_count OUT NOCOPY NUMBER
2689: ,x_msg_data OUT NOCOPY VARCHAR2