DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on INV_EBI_ECO_OBJ

Line 343: p_eco_obj IN inv_ebi_eco_obj

339: -- This API is used to
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;

Line 492: ,p_eco_obj IN inv_ebi_eco_obj

488: ************************************************************************************/
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);

Line 504: l_eco_obj inv_ebi_eco_obj;

500: l_item inv_ebi_item_obj;
501: l_category_output inv_ebi_category_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;

Line 505: l_eco_obj_validate_eco inv_ebi_eco_obj;

501: l_category_output inv_ebi_category_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;

Line 1028: ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj

1024: p_change_id IN NUMBER
1025: ,p_last_update_status IN VARCHAR2
1026: ,p_revised_item_sequence_id IN NUMBER
1027: ,p_name_val_list IN inv_ebi_name_value_list
1028: ,x_eco_obj OUT NOCOPY inv_ebi_eco_obj
1029: ,x_return_status OUT NOCOPY VARCHAR2
1030: ,x_msg_count OUT NOCOPY NUMBER
1031: ,x_msg_data OUT NOCOPY VARCHAR2
1032: )

Line 1034: l_eco_obj inv_ebi_eco_obj;

1030: ,x_msg_count OUT NOCOPY NUMBER
1031: ,x_msg_data OUT NOCOPY VARCHAR2
1032: )
1033: IS
1034: l_eco_obj inv_ebi_eco_obj;
1035: l_return_status VARCHAR2(1);
1036: l_msg_count NUMBER;
1037: l_msg_data VARCHAR2(1000);
1038: l_eco_change_order_obj inv_ebi_change_order_obj;

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

1093: l_revised_item_obj.status_name := l_eco_obj.eco_revised_item_type(i).status_name;
1094: l_revised_item_obj.new_effective_date := l_eco_obj.eco_revised_item_type(i).new_effective_date;
1095: l_revised_item_tbl(i) := l_revised_item_obj;
1096: END LOOP;
1097: x_eco_obj := inv_ebi_eco_obj(l_eco_change_order_obj,NULL,l_revised_item_tbl,NULL);
1098: ELSE
1099: x_eco_obj := l_eco_obj;
1100: END IF;
1101: EXCEPTION

Line 1448: l_eco_obj inv_ebi_eco_obj;

1444: l_ovrflw_msg VARCHAR2(1):='N';
1445: l_count NUMBER := 0;
1446: l_part_msgtxt VARCHAR2(32000);
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;

Line 1564: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl

1560: ************************************************************************************/
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

Line 1571: l_inv_ebi_eco_obj inv_ebi_eco_obj;

1567: ,x_msg_count OUT NOCOPY NUMBER
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);

Line 1589: l_inv_ebi_eco_obj := p_eco_obj_list(i);

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
1589: l_inv_ebi_eco_obj := p_eco_obj_list(i);
1590: l_eco_name := p_eco_obj_list(i).eco_change_order_type.eco_name;
1591: l_org_code := p_eco_obj_list(i).eco_change_order_type.organization_code;
1592: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
1593: IF( l_is_master_org = fnd_api.g_true ) THEN

Line 1599: ,p_eco_obj => l_inv_ebi_eco_obj

1595: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
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||

Line 1615: l_inv_ebi_eco_obj := p_eco_obj_list(i);

1611: END IF;
1612: IF (p_eco_obj_list IS NOT NULL AND p_eco_obj_list.count > 0) THEN
1613: FOR i in 1..p_eco_obj_list.count
1614: LOOP
1615: l_inv_ebi_eco_obj := p_eco_obj_list(i);
1616: l_eco_name := p_eco_obj_list(i).eco_change_order_type.eco_name;
1617: l_org_code := p_eco_obj_list(i).eco_change_order_type.organization_code;
1618: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
1619: IF( l_is_master_org = fnd_api.g_false ) THEN

Line 1624: ,p_eco_obj => l_inv_ebi_eco_obj

1620: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||
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||