APPS.GML_REQIMPORT_GRP dependencies on PO_GML_DB_COMMON

Line 192: v_process_dest_org := po_gml_db_common.check_process_org(cr_rec.destination_organization_id);

188: CLOSE Cr_opm_item_attr;
189: END;
190:
191: --check whether destination organization is process.
192: v_process_dest_org := po_gml_db_common.check_process_org(cr_rec.destination_organization_id);
193:
194: -- Error out if discrete items ordered in process organizations.
195: IF NOT v_opm_item and v_process_dest_org = 'Y' THEN
196: l_rec.interface_type := 'REQIMPORT';

Line 229: v_process_source_org := po_gml_db_common.check_process_org(cr_rec.source_organization_id);

225: --validate source and destination organization to be both either process or discrete
226: --validate source and destination organization are process and not same
227: IF cr_rec.source_type_code = 'INVENTORY' THEN
228:
229: v_process_source_org := po_gml_db_common.check_process_org(cr_rec.source_organization_id);
230:
231: IF (v_process_dest_org = 'N' AND v_process_source_org = 'Y' )
232: OR (v_process_dest_org = 'Y' AND v_process_source_org = 'N' )
233: THEN

Line 306: l_secondary_unit_of_measure := po_gml_db_common.get_apps_uom_code(v_item_um2);

302: --get secondary_unit_of_measure from secondary_uom_code
303: IF cr_rec.secondary_uom_code IS NOT NULL and cr_rec.secondary_unit_of_measure is NULL
304: AND v_dualum_ind > 0
305: THEN
306: l_secondary_unit_of_measure := po_gml_db_common.get_apps_uom_code(v_item_um2);
307:
308: BEGIN
309: SELECT mum.unit_of_measure
310: INTO l_passed_secondary_uom

Line 362: l_secondary_unit_of_measure := po_gml_db_common.get_apps_uom_code(v_item_um2);

358: ELSIF cr_rec.secondary_uom_code IS NULL and cr_rec.secondary_unit_of_measure is NULL
359: AND v_dualum_ind > 0
360: THEN
361:
362: l_secondary_unit_of_measure := po_gml_db_common.get_apps_uom_code(v_item_um2);
363:
364: UPDATE po_requisitions_interface pri
365: SET pri.secondary_unit_of_measure = l_secondary_unit_of_measure
366: WHERE rowid = cr_rec.rowid;

Line 371: l_secondary_unit_of_measure := po_gml_db_common.get_apps_uom_code(v_item_um2);

367:
368: --If unit of measure is provided then validate it.
369: ELSIF cr_rec.secondary_unit_of_measure is NOT NULL
370: THEN
371: l_secondary_unit_of_measure := po_gml_db_common.get_apps_uom_code(v_item_um2);
372:
373: --validate secondary_unit_of_measure
374: --error if its not valid or its different than Items secondary unit of measure
375: IF cr_rec.secondary_unit_of_measure <> l_secondary_unit_of_measure THEN

Line 411: po_gml_db_common.VALIDATE_QUANTITY(

407: --If secondary quantity is not provided and compute it and update interface table.
408: --only if the unit of measure is correctly validated 0 use falg v_uom_error
409: IF cr_rec.secondary_quantity IS NULL AND v_dualum_ind > 0 AND NOT v_uom_error THEN
410:
411: po_gml_db_common.VALIDATE_QUANTITY(
412: v_opm_item_id,
413: v_dualum_ind,
414: cr_rec.quantity,
415: v_item_um,

Line 495: po_gml_db_common.VALIDATE_QUANTITY(

491:
492: --if dual um 1 then update the secondary quantity since its fixed conversion.
493: ELSIF v_dualum_ind = 1 THEN
494:
495: po_gml_db_common.VALIDATE_QUANTITY(
496: v_opm_item_id,
497: v_dualum_ind,
498: cr_rec.quantity,
499: v_item_um,