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 6179: RETURN FND_TABLE_OF_VARCHAR2_255

6175:
6176: FUNCTION parse_input_string(
6177: p_input_string IN VARCHAR2
6178: )
6179: RETURN FND_TABLE_OF_VARCHAR2_255
6180: IS
6181: l_input_string VARCHAR2(240);
6182: l_count NUMBER:=0;
6183: l_length NUMBER:=0;

Line 6184: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;

6180: IS
6181: l_input_string VARCHAR2(240);
6182: l_count NUMBER:=0;
6183: l_length NUMBER:=0;
6184: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;
6185: BEGIN
6186: l_input_string := p_input_string;
6187: l_parsed_tbl := FND_TABLE_OF_VARCHAR2_255();
6188: l_length := LENGTH(l_input_string);

Line 6187: l_parsed_tbl := FND_TABLE_OF_VARCHAR2_255();

6183: l_length NUMBER:=0;
6184: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;
6185: BEGIN
6186: l_input_string := p_input_string;
6187: l_parsed_tbl := FND_TABLE_OF_VARCHAR2_255();
6188: l_length := LENGTH(l_input_string);
6189:
6190: IF (SUBSTR(l_input_string,l_length-1) <> ';;') THEN
6191: l_input_string := l_input_string || ';;';

Line 6217: l_org_tbl FND_TABLE_OF_VARCHAR2_255;

6213: ,x_return_status OUT NOCOPY VARCHAR2
6214: ,x_msg_count OUT NOCOPY NUMBER
6215: ,x_msg_data OUT NOCOPY VARCHAR2)
6216: IS
6217: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
6218: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
6219: l_counter NUMBER:=0;
6220: BEGIN
6221: x_return_status := FND_API.g_ret_sts_success;

Line 6277: l_item_tbl FND_TABLE_OF_VARCHAR2_255;

6273: l_org_id NUMBER;
6274: l_item_id NUMBER;
6275: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
6276: l_item_obj inv_ebi_get_operational_attrs;
6277: l_item_tbl FND_TABLE_OF_VARCHAR2_255;
6278: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
6279: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;
6280: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
6281: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;

Line 6278: l_org_tbl FND_TABLE_OF_VARCHAR2_255;

6274: l_item_id NUMBER;
6275: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
6276: l_item_obj inv_ebi_get_operational_attrs;
6277: l_item_tbl FND_TABLE_OF_VARCHAR2_255;
6278: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
6279: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;
6280: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
6281: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
6282: CURSOR c_get_all_orgs(p_item_name VARCHAR2) IS

Line 6279: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;

6275: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
6276: l_item_obj inv_ebi_get_operational_attrs;
6277: l_item_tbl FND_TABLE_OF_VARCHAR2_255;
6278: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
6279: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;
6280: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
6281: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
6282: CURSOR c_get_all_orgs(p_item_name VARCHAR2) IS
6283: SELECT msik.inventory_item_id,msik.organization_id,mp.organization_code

Line 6280: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;

6276: l_item_obj inv_ebi_get_operational_attrs;
6277: l_item_tbl FND_TABLE_OF_VARCHAR2_255;
6278: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
6279: l_valid_item_tbl FND_TABLE_OF_VARCHAR2_255;
6280: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
6281: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
6282: CURSOR c_get_all_orgs(p_item_name VARCHAR2) IS
6283: SELECT msik.inventory_item_id,msik.organization_id,mp.organization_code
6284: FROM mtl_system_items_kfv msik,mtl_parameters mp

Line 6301: l_valid_item_tbl := FND_TABLE_OF_VARCHAR2_255();

6297: IF p_org_codes IS NOT NULL THEN
6298: l_org_tbl := parse_input_string(p_org_codes);
6299: END IF;
6300: IF l_item_tbl IS NOT NULL AND l_item_tbl.COUNT > 0 THEN
6301: l_valid_item_tbl := FND_TABLE_OF_VARCHAR2_255();
6302: l_entity_count :=0;
6303: FOR i in l_item_tbl.FIRST..l_item_tbl.LAST LOOP
6304: BEGIN
6305: FND_MSG_PUB.initialize();

Line 6334: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();

6330: END;
6331: END LOOP;
6332: END IF;
6333: IF l_org_tbl IS NOT NULL AND l_org_tbl.COUNT > 0 THEN
6334: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();
6335: l_entity_count :=0;
6336: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
6337: BEGIN
6338: FND_MSG_PUB.initialize();

Line 6455: RETURN FND_TABLE_OF_VARCHAR2_255

6451:
6452: FUNCTION parse_source_system_string(
6453: p_input_string IN VARCHAR2
6454: )
6455: RETURN FND_TABLE_OF_VARCHAR2_255
6456: IS
6457: l_cross_reference_type VARCHAR2(32000);
6458: l_count NUMBER:=0;
6459: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;

Line 6459: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;

6455: RETURN FND_TABLE_OF_VARCHAR2_255
6456: IS
6457: l_cross_reference_type VARCHAR2(32000);
6458: l_count NUMBER:=0;
6459: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;
6460: BEGIN
6461: l_cross_reference_type := TRIM(',' FROM p_input_string);
6462: l_parsed_tbl := FND_TABLE_OF_VARCHAR2_255();
6463: l_cross_reference_type := l_cross_reference_type || ',';

Line 6462: l_parsed_tbl := FND_TABLE_OF_VARCHAR2_255();

6458: l_count NUMBER:=0;
6459: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;
6460: BEGIN
6461: l_cross_reference_type := TRIM(',' FROM p_input_string);
6462: l_parsed_tbl := FND_TABLE_OF_VARCHAR2_255();
6463: l_cross_reference_type := l_cross_reference_type || ',';
6464: WHILE INSTR(l_cross_reference_type,',') > 0 LOOP
6465: l_parsed_tbl.EXTEND(1);
6466: l_count := l_count+1;

Line 6503: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;

6499: l_item_output_tbl inv_ebi_get_opr_attrs_tbl;
6500: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
6501: l_msg_data VARCHAR2(2000);
6502: l_msg_count NUMBER;
6503: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;
6504:
6505: CURSOR c_get_item_list_pim IS
6506: SELECT inv_ebi_get_operational_attrs(item_pim.inventory_item_id,item_pim.concatenated_segments,item_pim.organization_id,item_pim.organization_code,NULL,NULL)
6507: FROM

Line 6512: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

6508: (SELECT mcr.inventory_item_id, msik.concatenated_segments, msi.organization_id, mp.organization_code
6509: FROM mtl_cross_references_b mcr, mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6510: WHERE mcr.inventory_item_id = msi.inventory_item_id
6511: --AND mcr.organization_id = msi.organization_id --8897962 mcr has organization_id value as null
6512: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6513: AND hz.orig_system_id = mcr.source_system_id
6514: AND msi.organization_id = mp.organization_id
6515: AND msik.organization_id = msi.organization_id
6516: AND msik.inventory_item_id = msi.inventory_item_id

Line 6529: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

6525: AND msik.organization_id = mp.organization_id
6526: AND msik.organization_id = cic.organization_id
6527: AND msik.inventory_item_id = cic.inventory_item_id
6528: AND cic.last_update_date <> cic.creation_date
6529: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6530: AND hz.orig_system_id = mcr.source_system_id
6531: AND cic.last_update_date >= l_from_date
6532: AND cic.last_update_date <= l_to_date
6533: UNION

Line 6539: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

6535: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6536: WHERE mcr.inventory_item_id = cql.inventory_item_id
6537: --AND mcr.organization_id = cql.organization_id
6538: AND msik.organization_id = mp.organization_id
6539: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6540: AND hz.orig_system_id = mcr.source_system_id
6541: AND msik.organization_id = cql.organization_id
6542: AND msik.inventory_item_id = cql.inventory_item_id
6543: AND cql.last_update_date >= l_from_date

Line 6791: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;

6787: l_item_org_output_tbl inv_ebi_get_opr_attrs_tbl;
6788: l_item_tbl_flst inv_ebi_get_opr_attrs_tbl;
6789: l_msg_data VARCHAR2(2000);
6790: l_msg_count NUMBER;
6791: l_parsed_tbl FND_TABLE_OF_VARCHAR2_255;
6792:
6793: CURSOR c_get_bal_item_lst_pim IS --8897962
6794: SELECT inv_ebi_get_operational_attrs(gibp.inventory_item_id,gibp.concatenated_segments, gibp.organization_id,gibp.organization_code,NULL,NULL)
6795: FROM (

Line 6803: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

6799: --AND mcr.organization_id = moq.organization_id
6800: AND moq.organization_id = mp.organization_id
6801: AND msik.organization_id = moq.organization_id
6802: AND msik.inventory_item_id = moq.inventory_item_id
6803: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6804: AND hz.orig_system_id = mcr.source_system_id
6805: AND moq.last_update_date >= l_from_date
6806: AND moq.last_update_date <= l_to_date) gibp;
6807: