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 FND_TABLE_OF_VARCHAR2_255

Line 6033: l_org_tbl FND_TABLE_OF_VARCHAR2_255;

6029: ,x_return_status OUT NOCOPY VARCHAR2
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

Line 6105: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;

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;
6109: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;

Line 6106: l_org_tbl FND_TABLE_OF_VARCHAR2_255;

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;
6109: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
6110: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS

Line 6107: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;

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;
6109: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
6110: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS
6111: SELECT change_id

Line 6108: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;

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;
6109: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
6110: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS
6111: SELECT change_id
6112: FROM eng_engineering_changes

Line 6130: l_valid_eco_tbl := FND_TABLE_OF_VARCHAR2_255();

6126: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);
6127: END IF;
6128:
6129: IF l_eco_tbl IS NOT NULL AND l_eco_tbl.COUNT > 0 THEN
6130: l_valid_eco_tbl := FND_TABLE_OF_VARCHAR2_255();
6131: l_entity_count :=0;
6132: FOR i in l_eco_tbl.FIRST..l_eco_tbl.LAST LOOP
6133: BEGIN
6134: FND_MSG_PUB.initialize();

Line 6164: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();

6160: END LOOP;
6161: END IF;
6162:
6163: IF l_org_tbl IS NOT NULL AND l_org_tbl.COUNT > 0 THEN
6164: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();
6165: l_entity_count :=0;
6166: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
6167: BEGIN
6168: FND_MSG_PUB.initialize();