DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on INV_EBI_ECO_OUTPUT_OBJ

Line 14: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

10: PROCEDURE populate_item_attributes(
11: p_change_order_obj IN inv_ebi_change_order_obj
12: ,p_revised_item IN inv_ebi_revised_item_obj
13: ,x_item OUT NOCOPY inv_ebi_item_obj
14: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
15: ) IS
16: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
17: l_main_item_obj inv_ebi_item_main_obj;
18: l_output_status inv_ebi_output_status;

Line 21: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

17: l_main_item_obj inv_ebi_item_main_obj;
18: l_output_status inv_ebi_output_status;
19: BEGIN
20: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
21: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
22: IF(p_revised_item.item IS NOT NULL ) THEN
23: x_item := p_revised_item.item;
24: ELSE
25: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,

Line 129: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

125: ************************************************************************************/
126: PROCEDURE transfer_engg_item_mfg(
127: p_item IN inv_ebi_item_obj
128: ,p_alt_bom_designator IN VARCHAR2
129: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
130: ) IS
131: l_approval_status VARCHAR2(30);
132: l_item_number VARCHAR2(2000);
133: l_is_engineering_item VARCHAR2(3);

Line 143: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

139:
140: BEGIN
141: SAVEPOINT inv_ebi_engg_item_save_pnt;
142: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
143: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
144:
145: IF(p_item.main_obj_type.inventory_item_id IS NULL OR
146: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN
147:

Line 273: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

269: ************************************************************************************/
270: PROCEDURE validate_component_items(
271: p_organization_code IN VARCHAR2
272: ,p_component_item_tbl IN inv_ebi_rev_comp_tbl
273: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
274: ) IS
275: l_is_master_org VARCHAR2(3);
276: l_organization_id NUMBER;
277: l_component_item_name VARCHAR2(240);

Line 283: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

279: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
280: l_output_status inv_ebi_output_status;
281: BEGIN
282: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
283: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
284: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
285: l_pk_col_name_val_pairs.EXTEND(1);
286: l_pk_col_name_val_pairs(1).name := 'organization_code';
287: l_pk_col_name_val_pairs(1).value := p_organization_code;

Line 344: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

340: --
341: ************************************************************************************/
342: PROCEDURE validate_eco(
343: p_eco_obj IN inv_ebi_eco_obj
344: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
345: ) IS
346: l_output_status inv_ebi_output_status;
347: l_item_output inv_ebi_item_output_obj;
348: l_transaction_type VARCHAR2(20);

Line 352: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

348: l_transaction_type VARCHAR2(20);
349: l_organization_id NUMBER;
350: BEGIN
351: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
352: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
353: FND_MSG_PUB.initialize;
354: IF p_eco_obj.eco_revised_item_type IS NOT NULL THEN
355: FOR i IN 1..p_eco_obj.eco_revised_item_type.COUNT LOOP
356: IF p_eco_obj.eco_revised_item_type(i).item IS NOT NULL THEN

Line 493: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

489:
490: PROCEDURE process_change_order(
491: p_commit IN VARCHAR2 := FND_API.g_false
492: ,p_eco_obj IN inv_ebi_eco_obj
493: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
494: ) IS
495: l_change_id NUMBER;
496: l_change_notice VARCHAR2(10);
497: l_organization_id NUMBER;

Line 506: l_out inv_ebi_eco_output_obj;

502: l_pkdata ego_col_name_value_pair_array;
503: l_pkcode ego_col_name_value_pair_array;
504: l_eco_obj inv_ebi_eco_obj;
505: l_eco_obj_validate_eco inv_ebi_eco_obj;
506: l_out inv_ebi_eco_output_obj;
507: l_output_status inv_ebi_output_status;
508: l_item_output inv_ebi_item_output_obj;
509: l_item_output_tbl inv_ebi_item_output_tbl;
510: l_curr_status_code NUMBER;

Line 551: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

547: l_uda_output := inv_ebi_uda_output_obj(NULL,NULL);
548: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');
549: l_category_output := inv_ebi_category_output_obj(NULL);
550: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
551: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
552: l_item_output_tbl := inv_ebi_item_output_tbl();
553: l_item_obj_tbl := inv_ebi_item_attr_tbl();
554: l_update_item_tab := FND_TABLE_OF_NUMBER();
555:

Line 974: x_out := inv_ebi_eco_output_obj(l_change_notice,l_change_id,l_organization_id,l_organization_code,

970: ,p_revised_item_type_tbl => p_eco_obj.eco_revised_item_type
971: ,x_revised_item_type_tbl => l_revitem_output_tbl
972: );
973:
974: x_out := inv_ebi_eco_output_obj(l_change_notice,l_change_id,l_organization_id,l_organization_code,
975: l_item_output.output_status,l_revitem_output_tbl,l_uda_output);
976: INV_EBI_UTIL.debug_line('STEP: 200 END CALLING populate_revised_items_out');
977: IF FND_API.to_boolean(p_commit) THEN
978: COMMIT;

Line 1565: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl

1561:
1562: PROCEDURE process_change_order_list(
1563: p_commit IN VARCHAR2 := fnd_api.g_false
1564: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
1565: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
1566: ,x_return_status OUT NOCOPY VARCHAR2
1567: ,x_msg_count OUT NOCOPY NUMBER
1568: ,x_msg_data OUT NOCOPY VARCHAR2
1569: )

Line 1572: l_inv_ebi_eco_output_obj inv_ebi_eco_output_obj;

1568: ,x_msg_data OUT NOCOPY VARCHAR2
1569: )
1570: IS
1571: l_inv_ebi_eco_obj inv_ebi_eco_obj;
1572: l_inv_ebi_eco_output_obj inv_ebi_eco_output_obj;
1573: l_part_err_msg VARCHAR2(32000);
1574: l_eco_name VARCHAR2(10);
1575: l_org_code VARCHAR2(3);
1576: l_is_master_org VARCHAR2(1);

Line 1584: x_out := inv_ebi_eco_output_obj_tbl();

1580: FND_MSG_PUB.initialize;
1581: INV_EBI_UTIL.setup();
1582: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
1583: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1584: x_out := inv_ebi_eco_output_obj_tbl();
1585: IF (p_eco_obj_list IS NOT NULL AND p_eco_obj_list.count > 0) THEN
1586: x_out.extend(p_eco_obj_list.count);
1587: FOR i in 1..p_eco_obj_list.count
1588: LOOP

Line 1600: ,x_out => l_inv_ebi_eco_output_obj

1596: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1597:
1598: INV_EBI_CHANGE_ORDER_PUB.process_change_order( p_commit => p_commit
1599: ,p_eco_obj => l_inv_ebi_eco_obj
1600: ,x_out => l_inv_ebi_eco_output_obj
1601: );
1602: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Master ORG'||
1603: 'Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1604: 'ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);

Line 1605: x_out(i) := l_inv_ebi_eco_output_obj;

1601: );
1602: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Master ORG'||
1603: 'Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1604: 'ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1605: x_out(i) := l_inv_ebi_eco_output_obj;
1606: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
1607: RAISE FND_API.g_exc_unexpected_error;
1608: END IF;
1609: END IF;

Line 1625: ,x_out => l_inv_ebi_eco_output_obj

1621: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1622: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1623: INV_EBI_CHANGE_ORDER_PUB.process_change_order( p_commit => p_commit
1624: ,p_eco_obj => l_inv_ebi_eco_obj
1625: ,x_out => l_inv_ebi_eco_output_obj
1626: );
1627: INV_EBI_UTIL.debug_line('STEP: 50 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||
1628: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1629: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);

Line 1630: x_out(i) := l_inv_ebi_eco_output_obj;

1626: );
1627: INV_EBI_UTIL.debug_line('STEP: 50 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||
1628: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1629: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1630: x_out(i) := l_inv_ebi_eco_output_obj;
1631: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
1632: RAISE FND_API.g_exc_unexpected_error;
1633: END IF;
1634: END IF;