DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on FND_TABLE_OF_VARCHAR2_30

Line 1597: l_common_org_tbl FND_TABLE_OF_VARCHAR2_30;

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;
1597: l_common_org_tbl FND_TABLE_OF_VARCHAR2_30;
1598: l_replicate_bom_org_tbl FND_TABLE_OF_VARCHAR2_30;
1599: l_common_eco_tbl FND_TABLE_OF_VARCHAR2_30;
1600: l_replicate_bom_eco_tbl FND_TABLE_OF_VARCHAR2_30;
1601: l_replicate_bom_cnt NUMBER := 0;

Line 1598: l_replicate_bom_org_tbl FND_TABLE_OF_VARCHAR2_30;

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;
1597: l_common_org_tbl FND_TABLE_OF_VARCHAR2_30;
1598: l_replicate_bom_org_tbl FND_TABLE_OF_VARCHAR2_30;
1599: l_common_eco_tbl FND_TABLE_OF_VARCHAR2_30;
1600: l_replicate_bom_eco_tbl FND_TABLE_OF_VARCHAR2_30;
1601: l_replicate_bom_cnt NUMBER := 0;
1602: l_common_bom_found VARCHAR2(1);

Line 1599: l_common_eco_tbl FND_TABLE_OF_VARCHAR2_30;

1595: l_replicate_bom_tbl inv_ebi_revised_item_tbl;
1596: l_common_assy_item_cnt NUMBER := 0;
1597: l_common_org_tbl FND_TABLE_OF_VARCHAR2_30;
1598: l_replicate_bom_org_tbl FND_TABLE_OF_VARCHAR2_30;
1599: l_common_eco_tbl FND_TABLE_OF_VARCHAR2_30;
1600: l_replicate_bom_eco_tbl FND_TABLE_OF_VARCHAR2_30;
1601: l_replicate_bom_cnt NUMBER := 0;
1602: l_common_bom_found VARCHAR2(1);
1603: l_replicate_bom_found VARCHAR2(1);

Line 1600: l_replicate_bom_eco_tbl FND_TABLE_OF_VARCHAR2_30;

1596: l_common_assy_item_cnt NUMBER := 0;
1597: l_common_org_tbl FND_TABLE_OF_VARCHAR2_30;
1598: l_replicate_bom_org_tbl FND_TABLE_OF_VARCHAR2_30;
1599: l_common_eco_tbl FND_TABLE_OF_VARCHAR2_30;
1600: l_replicate_bom_eco_tbl FND_TABLE_OF_VARCHAR2_30;
1601: l_replicate_bom_cnt NUMBER := 0;
1602: l_common_bom_found VARCHAR2(1);
1603: l_replicate_bom_found VARCHAR2(1);
1604: l_output_status inv_ebi_output_status;

Line 1622: l_common_org_tbl := FND_TABLE_OF_VARCHAR2_30();

1618: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1619:
1620: l_common_assy_item_tbl := inv_ebi_revised_item_tbl();
1621: l_replicate_bom_tbl := inv_ebi_revised_item_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();

Line 1623: l_replicate_bom_org_tbl := FND_TABLE_OF_VARCHAR2_30();

1619:
1620: l_common_assy_item_tbl := inv_ebi_revised_item_tbl();
1621: l_replicate_bom_tbl := inv_ebi_revised_item_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');

Line 1624: l_common_eco_tbl := FND_TABLE_OF_VARCHAR2_30();

1620: l_common_assy_item_tbl := inv_ebi_revised_item_tbl();
1621: l_replicate_bom_tbl := inv_ebi_revised_item_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

Line 1625: l_replicate_bom_eco_tbl := FND_TABLE_OF_VARCHAR2_30();

1621: l_replicate_bom_tbl := inv_ebi_revised_item_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);

Line 2225: l_upd_eco_name_tbl FND_TABLE_OF_VARCHAR2_30;

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;
2229: l_output_status inv_ebi_output_status;

Line 2273: l_upd_eco_name_tbl := FND_TABLE_OF_VARCHAR2_30();

2269: IF (l_eco_obj_tbl IS NOT NULL AND l_eco_obj_tbl.count > 0) THEN
2270:
2271: x_out.extend(l_eco_obj_tbl.count);
2272:
2273: l_upd_eco_name_tbl := FND_TABLE_OF_VARCHAR2_30();
2274: l_upd_item_tbl := inv_ebi_item_attr_tbl();
2275: l_updated_item_tbl := inv_ebi_item_attr_tbl(); -- Bug 8830143
2276: l_upd_eco_idx_tbl := FND_TABLE_OF_NUMBER();
2277: