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 5084: l_org_tbl FND_TABLE_OF_VARCHAR2_255;

5080: ,x_return_status OUT NOCOPY VARCHAR2
5081: ,x_msg_count OUT NOCOPY NUMBER
5082: ,x_msg_data OUT NOCOPY VARCHAR2)
5083: IS
5084: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
5085: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
5086: l_counter NUMBER:=0;
5087: l_org_code VARCHAR2(10);
5088: BEGIN

Line 5147: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;

5143: l_entity_exist NUMBER :=0;
5144: l_entity_count NUMBER :=0;
5145: l_eco_obj inv_ebi_change_id_obj;
5146: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
5147: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5148: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
5149: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5150: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
5151: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;

Line 5148: l_org_tbl FND_TABLE_OF_VARCHAR2_255;

5144: l_entity_count NUMBER :=0;
5145: l_eco_obj inv_ebi_change_id_obj;
5146: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
5147: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5148: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
5149: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5150: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
5151: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
5152: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS

Line 5149: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;

5145: l_eco_obj inv_ebi_change_id_obj;
5146: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
5147: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5148: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
5149: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5150: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
5151: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
5152: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS
5153: SELECT change_id

Line 5150: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;

5146: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
5147: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5148: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
5149: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5150: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
5151: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
5152: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS
5153: SELECT change_id
5154: FROM eng_engineering_changes

Line 5169: l_valid_eco_tbl := FND_TABLE_OF_VARCHAR2_255();

5165: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);
5166: END IF;
5167:
5168: IF l_eco_tbl IS NOT NULL AND l_eco_tbl.COUNT > 0 THEN
5169: l_valid_eco_tbl := FND_TABLE_OF_VARCHAR2_255();
5170: l_entity_count :=0;
5171: FOR i in l_eco_tbl.FIRST..l_eco_tbl.LAST LOOP
5172: BEGIN
5173: FND_MSG_PUB.initialize();

Line 5203: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();

5199: END LOOP;
5200: END IF;
5201:
5202: IF l_org_tbl IS NOT NULL AND l_org_tbl.COUNT > 0 THEN
5203: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();
5204: l_entity_count :=0;
5205: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
5206: BEGIN
5207: FND_MSG_PUB.initialize();