[Home] [Help]
4493: -- This API is used to validate the Item Request Inputs
4494: --
4495: ************************************************************************************/
4496: PROCEDURE validate_get_item_request(
4497: p_get_opr_attrs_rec IN inv_ebi_get_operational_attrs,
4498: x_status OUT NOCOPY VARCHAR2,
4499: x_msg_count OUT NOCOPY NUMBER,
4500: x_msg_data OUT NOCOPY VARCHAR2
4501: )
6272: l_entity_count NUMBER :=0;
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;
6389: l_pk_col_name_val_pairs.TRIM(2);
6390:
6391: IF l_item_id IS NOT NULL THEN
6392: l_counter := l_counter + 1;
6393: l_item_obj := inv_ebi_get_operational_attrs( l_item_id, l_valid_item_tbl(i) , l_org_id, l_valid_org_tbl(j),NULL,NULL);
6394: l_item_output_tbl.EXTEND(1);
6395: l_item_output_tbl(l_counter) := l_item_obj;
6396: l_count := 1;
6397: END IF;
6399: END LOOP;
6400: ELSE
6401: FOR cur IN c_get_all_orgs(l_valid_item_tbl(i)) LOOP
6402: l_counter := l_counter + 1;
6403: l_item_obj := inv_ebi_get_operational_attrs( cur.inventory_item_id, l_valid_item_tbl(i) , cur.organization_id, cur.organization_code,NULL,NULL);
6404: l_item_output_tbl.EXTEND(1);
6405: l_item_output_tbl(l_counter) := l_item_obj;
6406: l_count := 1;
6407: END LOOP;
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
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
6543: AND cql.last_update_date >= l_from_date
6544: AND cql.last_update_date <= l_to_date) item_pim;
6545:
6546: CURSOR c_get_item_list IS
6547: SELECT inv_ebi_get_operational_attrs(item_npim.inventory_item_id,item_npim.concatenated_segments,item_npim.organization_id,item_npim.organization_code,NULL,NULL)
6548: FROM
6549: (SELECT msi.inventory_item_id, msik.concatenated_segments, msi.organization_id, mp.organization_code
6550: FROM mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik
6551: WHERE msi.organization_id = mp.organization_id
6573: AND cql.last_update_date <= l_to_date
6574: ) item_npim;
6575:
6576: CURSOR c_get_item_flist IS
6577: SELECT inv_ebi_get_operational_attrs(item_flst.item_id,item_flst.item_name,item_flst.organization_id,item_flst.organization_code,NULL,NULL)
6578: FROM (
6579: SELECT a.item_id,a.item_name, a.organization_id,a.organization_code
6580: FROM THE (SELECT CAST( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
6581: FROM dual ) a
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 (
6796: SELECT DISTINCT mcr.inventory_item_id,msik.concatenated_segments,moq.organization_id,mp.organization_code
6797: FROM mtl_onhand_quantities_detail moq,mtl_cross_references_b mcr, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6798: WHERE mcr.inventory_item_id = moq.inventory_item_id
6805: AND moq.last_update_date >= l_from_date
6806: AND moq.last_update_date <= l_to_date) gibp;
6807:
6808: CURSOR c_get_bal_item_lst IS
6809: SELECT inv_ebi_get_operational_attrs(gib.inventory_item_id,gib.concatenated_segments, gib.organization_id,gib.organization_code,NULL,NULL)
6810: FROM (SELECT DISTINCT moq.inventory_item_id,msik.concatenated_segments,moq.organization_id,mp.organization_code
6811: FROM mtl_onhand_quantities_detail moq, mtl_parameters mp, mtl_system_items_kfv msik
6812: WHERE moq.organization_id = mp.organization_id
6813: AND msik.organization_id = moq.organization_id
6815: AND moq.last_update_date >= l_from_date
6816: AND moq.last_update_date <= l_to_date) gib;
6817:
6818: CURSOR c_get_bal_item_flst IS
6819: SELECT inv_ebi_get_operational_attrs(gibf.item_id,gibf.item_name, gibf.organization_id,gibf.organization_code,NULL,NULL)
6820: FROM (
6821: SELECT a.item_id,a.item_name, a.organization_id,a.organization_code
6822: FROM THE (SELECT cast( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
6823: FROM dual ) a