APPS.GME_COMMON_PVT dependencies on GME_PARAMETERS

Line 189: FROM gme_parameters

185: IS
186: CURSOR cur_get_gme_params (v_org_id NUMBER)
187: IS
188: SELECT *
189: FROM gme_parameters
190: WHERE organization_id = v_org_id;
191:
192: CURSOR cur_get_inv_params (v_org_id NUMBER, v_org_code VARCHAR2)
193: IS

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

379: RETURN FALSE;
380: WHEN gmd_params_not_defined THEN
381: RETURN FALSE;
382: WHEN gme_params_not_defined THEN
383: gme_common_pvt.log_message ('GME_DEFINE_GME_PARAMETERS');
384: RETURN FALSE;
385: WHEN OTHERS THEN
386: IF g_debug <= gme_debug.g_log_unexpected THEN
387: gme_debug.put_line ( 'When others exception in '

Line 525: FROM mtl_system_items_b i, gme_parameters g

521: ,NVL (i.process_supply_locator_id
522: ,g.supply_locator_id)
523: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
524: ,i.restrict_locators_code
525: FROM mtl_system_items_b i, gme_parameters g
526: WHERE i.organization_id = v_org_id
527: AND i.inventory_item_id = v_inventory_item_id
528: AND g.organization_id = v_org_id;
529:

Line 652: FROM mtl_system_items_b i, gme_parameters g

648: ,NVL (i.process_yield_locator_id
649: ,g.yield_locator_id)
650: ,i.restrict_subinventories_code, NVL(i.location_control_code,1)
651: ,i.restrict_locators_code
652: FROM mtl_system_items_b i, gme_parameters g
653: WHERE i.organization_id = v_org_id
654: AND i.inventory_item_id = v_inventory_item_id
655: AND g.organization_id = v_org_id;
656:

Line 1241: FROM gme_parameters

1237:
1238: IF (x_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_batch) THEN
1239: SELECT batch_doc_numbering, batch_no_last_assigned + 1
1240: INTO l_assignment_type, l_document_no
1241: FROM gme_parameters
1242: WHERE organization_id = x_batch_header_rec.organization_id
1243: FOR UPDATE OF batch_no_last_assigned NOWAIT;
1244: ELSE
1245: SELECT fpo_doc_numbering, fpo_no_last_assigned + 1

Line 1247: FROM gme_parameters

1243: FOR UPDATE OF batch_no_last_assigned NOWAIT;
1244: ELSE
1245: SELECT fpo_doc_numbering, fpo_no_last_assigned + 1
1246: INTO l_assignment_type, l_document_no
1247: FROM gme_parameters
1248: WHERE organization_id = x_batch_header_rec.organization_id
1249: FOR UPDATE OF batch_no_last_assigned NOWAIT;
1250: END IF;
1251:

Line 1258: UPDATE gme_parameters

1254: RAISE invalid_doc_no;
1255: END IF;
1256:
1257: IF (x_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_batch) THEN
1258: UPDATE gme_parameters
1259: SET batch_no_last_assigned = batch_no_last_assigned + 1
1260: WHERE organization_id = p_batch_header_rec.organization_id;
1261: ELSE
1262: UPDATE gme_parameters

Line 1262: UPDATE gme_parameters

1258: UPDATE gme_parameters
1259: SET batch_no_last_assigned = batch_no_last_assigned + 1
1260: WHERE organization_id = p_batch_header_rec.organization_id;
1261: ELSE
1262: UPDATE gme_parameters
1263: SET fpo_no_last_assigned = fpo_no_last_assigned + 1
1264: WHERE organization_id = p_batch_header_rec.organization_id;
1265: END IF;
1266: