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_ITEM_HELPER dependencies on FND_TABLE_OF_VARCHAR2_255

Line 4645: RETURN FND_TABLE_OF_VARCHAR2_255

4641:
4642: FUNCTION parse_input_string(
4643: p_input_string IN VARCHAR2
4644: )
4645: RETURN FND_TABLE_OF_VARCHAR2_255
4646: IS
4647: l_input_string VARCHAR2(240);
4648: l_count NUMBER:=0;
4649: l_length NUMBER:=0;

Line 4650: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;

4646: IS
4647: l_input_string VARCHAR2(240);
4648: l_count NUMBER:=0;
4649: l_length NUMBER:=0;
4650: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;
4651: BEGIN
4652: l_input_string := p_input_string;
4653: l_parsed_tbl := FND_TABLE_OF_VARCHAR2_255();
4654: l_length := LENGTH(l_input_string);

Line 4653: l_parsed_tbl := FND_TABLE_OF_VARCHAR2_255();

4649: l_length NUMBER:=0;
4650: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;
4651: BEGIN
4652: l_input_string := p_input_string;
4653: l_parsed_tbl := FND_TABLE_OF_VARCHAR2_255();
4654: l_length := LENGTH(l_input_string);
4655:
4656: IF (SUBSTR(l_input_string,l_length-1) <> ';;') THEN
4657: l_input_string := l_input_string || ';;';

Line 4683: l_org_tbl FND_TABLE_OF_VARCHAR2_255;

4679: ,x_return_status OUT NOCOPY VARCHAR2
4680: ,x_msg_count OUT NOCOPY NUMBER
4681: ,x_msg_data OUT NOCOPY VARCHAR2)
4682: IS
4683: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
4684: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4685: l_counter NUMBER:=0;
4686: BEGIN
4687: x_return_status := FND_API.g_ret_sts_success;

Line 4740: l_item_tbl FND_TABLE_OF_VARCHAR2_255;

4736: l_org_id NUMBER;
4737: l_item_id NUMBER;
4738: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4739: l_item_obj inv_ebi_get_operational_attrs;
4740: l_item_tbl FND_TABLE_OF_VARCHAR2_255;
4741: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
4742: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;
4743: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
4744: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;

Line 4741: l_org_tbl FND_TABLE_OF_VARCHAR2_255;

4737: l_item_id NUMBER;
4738: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4739: l_item_obj inv_ebi_get_operational_attrs;
4740: l_item_tbl FND_TABLE_OF_VARCHAR2_255;
4741: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
4742: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;
4743: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
4744: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
4745: CURSOR c_get_all_orgs(p_item_name VARCHAR2) IS

Line 4742: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;

4738: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
4739: l_item_obj inv_ebi_get_operational_attrs;
4740: l_item_tbl FND_TABLE_OF_VARCHAR2_255;
4741: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
4742: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;
4743: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
4744: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
4745: CURSOR c_get_all_orgs(p_item_name VARCHAR2) IS
4746: SELECT msik.inventory_item_id,msik.organization_id,mp.organization_code

Line 4743: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;

4739: l_item_obj inv_ebi_get_operational_attrs;
4740: l_item_tbl FND_TABLE_OF_VARCHAR2_255;
4741: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
4742: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;
4743: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
4744: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
4745: CURSOR c_get_all_orgs(p_item_name VARCHAR2) IS
4746: SELECT msik.inventory_item_id,msik.organization_id,mp.organization_code
4747: FROM mtl_system_items_kfv msik,mtl_parameters mp

Line 4762: l_valid_item_tbl := FND_TABLE_OF_VARCHAR2_255();

4758: IF p_org_codes IS NOT NULL THEN
4759: l_org_tbl := parse_input_string(p_org_codes);
4760: END IF;
4761: IF l_item_tbl IS NOT NULL AND l_item_tbl.COUNT > 0 THEN
4762: l_valid_item_tbl := FND_TABLE_OF_VARCHAR2_255();
4763: l_entity_count :=0;
4764: FOR i in l_item_tbl.FIRST..l_item_tbl.LAST LOOP
4765: BEGIN
4766: FND_MSG_PUB.initialize();

Line 4795: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();

4791: END;
4792: END LOOP;
4793: END IF;
4794: IF l_org_tbl IS NOT NULL AND l_org_tbl.COUNT > 0 THEN
4795: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();
4796: l_entity_count :=0;
4797: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
4798: BEGIN
4799: FND_MSG_PUB.initialize();