APPS.GME_COMMON_PVT dependencies on GME_PARAMETERS

Line 275: FROM gme_parameters

271: IS
272: CURSOR cur_get_gme_params (v_org_id NUMBER)
273: IS
274: SELECT *
275: FROM gme_parameters
276: WHERE organization_id = v_org_id;
277:
278: CURSOR cur_get_inv_params (v_org_id NUMBER, v_org_code VARCHAR2)
279: IS

Line 473: gme_common_pvt.log_message ('GME_DEFINE_GME_PARAMETERS');

469: RETURN FALSE;
470: WHEN gmd_params_not_defined THEN
471: RETURN FALSE;
472: WHEN gme_params_not_defined THEN
473: gme_common_pvt.log_message ('GME_DEFINE_GME_PARAMETERS');
474: RETURN FALSE;
475: WHEN OTHERS THEN
476: IF g_debug <= gme_debug.g_log_unexpected THEN
477: gme_debug.put_line ( 'When others exception in '

Line 615: FROM mtl_system_items_b i, gme_parameters g

611: ,NVL (i.process_supply_locator_id
612: ,g.supply_locator_id)
613: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
614: ,i.restrict_locators_code
615: FROM mtl_system_items_b i, gme_parameters g
616: WHERE i.organization_id = v_org_id
617: AND i.inventory_item_id = v_inventory_item_id
618: AND g.organization_id = v_org_id;
619:

Line 742: FROM mtl_system_items_b i, gme_parameters g

738: ,NVL (i.process_yield_locator_id
739: ,g.yield_locator_id)
740: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
741: ,i.restrict_locators_code
742: FROM mtl_system_items_b i, gme_parameters g
743: WHERE i.organization_id = v_org_id
744: AND i.inventory_item_id = v_inventory_item_id
745: AND g.organization_id = v_org_id;
746:

Line 1331: FROM gme_parameters

1327:
1328: IF (x_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_batch) THEN
1329: SELECT batch_doc_numbering, batch_no_last_assigned + 1
1330: INTO l_assignment_type, l_document_no
1331: FROM gme_parameters
1332: WHERE organization_id = x_batch_header_rec.organization_id
1333: FOR UPDATE OF batch_no_last_assigned NOWAIT;
1334: ELSE
1335: SELECT fpo_doc_numbering, fpo_no_last_assigned + 1

Line 1337: FROM gme_parameters

1333: FOR UPDATE OF batch_no_last_assigned NOWAIT;
1334: ELSE
1335: SELECT fpo_doc_numbering, fpo_no_last_assigned + 1
1336: INTO l_assignment_type, l_document_no
1337: FROM gme_parameters
1338: WHERE organization_id = x_batch_header_rec.organization_id
1339: FOR UPDATE OF batch_no_last_assigned NOWAIT;
1340: END IF;
1341:

Line 1348: UPDATE gme_parameters

1344: RAISE invalid_doc_no;
1345: END IF;
1346:
1347: IF (x_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_batch) THEN
1348: UPDATE gme_parameters
1349: SET batch_no_last_assigned = batch_no_last_assigned + 1
1350: WHERE organization_id = p_batch_header_rec.organization_id;
1351: ELSE
1352: UPDATE gme_parameters

Line 1352: UPDATE gme_parameters

1348: UPDATE gme_parameters
1349: SET batch_no_last_assigned = batch_no_last_assigned + 1
1350: WHERE organization_id = p_batch_header_rec.organization_id;
1351: ELSE
1352: UPDATE gme_parameters
1353: SET fpo_no_last_assigned = fpo_no_last_assigned + 1
1354: WHERE organization_id = p_batch_header_rec.organization_id;
1355: END IF;
1356: