APPS.GME_INSERT_STEP_PVT dependencies on CR_RSRC_MST

Line 449: l_max_cap cr_rsrc_mst.max_capacity%TYPE;

445: ,x_resource OUT NOCOPY gme_batch_step_resources.resources%TYPE
446: ,x_return_status OUT NOCOPY VARCHAR2
447: ,p_step_qty_uom IN VARCHAR2 DEFAULT NULL) --Bug#5231180
448: IS
449: l_max_cap cr_rsrc_mst.max_capacity%TYPE;
450: l_std_cap cr_rsrc_mst.max_capacity%TYPE;
451: l_std_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
452: l_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
453: l_min_of_max_cap_uom cr_rsrc_mst.capacity_uom%TYPE;

Line 450: l_std_cap cr_rsrc_mst.max_capacity%TYPE;

446: ,x_return_status OUT NOCOPY VARCHAR2
447: ,p_step_qty_uom IN VARCHAR2 DEFAULT NULL) --Bug#5231180
448: IS
449: l_max_cap cr_rsrc_mst.max_capacity%TYPE;
450: l_std_cap cr_rsrc_mst.max_capacity%TYPE;
451: l_std_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
452: l_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
453: l_min_of_max_cap_uom cr_rsrc_mst.capacity_uom%TYPE;
454: l_cap_uom cr_rsrc_mst.capacity_uom%TYPE;

Line 451: l_std_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;

447: ,p_step_qty_uom IN VARCHAR2 DEFAULT NULL) --Bug#5231180
448: IS
449: l_max_cap cr_rsrc_mst.max_capacity%TYPE;
450: l_std_cap cr_rsrc_mst.max_capacity%TYPE;
451: l_std_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
452: l_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
453: l_min_of_max_cap_uom cr_rsrc_mst.capacity_uom%TYPE;
454: l_cap_uom cr_rsrc_mst.capacity_uom%TYPE;
455:

Line 452: l_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;

448: IS
449: l_max_cap cr_rsrc_mst.max_capacity%TYPE;
450: l_std_cap cr_rsrc_mst.max_capacity%TYPE;
451: l_std_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
452: l_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
453: l_min_of_max_cap_uom cr_rsrc_mst.capacity_uom%TYPE;
454: l_cap_uom cr_rsrc_mst.capacity_uom%TYPE;
455:
456: --Bug#5231180 changed to mtl_units_of_measure

Line 453: l_min_of_max_cap_uom cr_rsrc_mst.capacity_uom%TYPE;

449: l_max_cap cr_rsrc_mst.max_capacity%TYPE;
450: l_std_cap cr_rsrc_mst.max_capacity%TYPE;
451: l_std_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
452: l_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
453: l_min_of_max_cap_uom cr_rsrc_mst.capacity_uom%TYPE;
454: l_cap_uom cr_rsrc_mst.capacity_uom%TYPE;
455:
456: --Bug#5231180 changed to mtl_units_of_measure
457: l_min_of_max_um_type mtl_units_of_measure.uom_class%TYPE; --sy_uoms_mst.um_type%TYPE;

Line 454: l_cap_uom cr_rsrc_mst.capacity_uom%TYPE;

450: l_std_cap cr_rsrc_mst.max_capacity%TYPE;
451: l_std_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
452: l_min_of_max_cap cr_rsrc_mst.max_capacity%TYPE;
453: l_min_of_max_cap_uom cr_rsrc_mst.capacity_uom%TYPE;
454: l_cap_uom cr_rsrc_mst.capacity_uom%TYPE;
455:
456: --Bug#5231180 changed to mtl_units_of_measure
457: l_min_of_max_um_type mtl_units_of_measure.uom_class%TYPE; --sy_uoms_mst.um_type%TYPE;
458: l_std_factor NUMBER;

Line 465: CURSOR cur_get_rsrc (p_rsrc cr_rsrc_mst.resources%TYPE)

461: l_first BOOLEAN;
462: l_assign BOOLEAN;
463: l_api_name CONSTANT VARCHAR2 (30) := 'CALC_MAX_CAPACITY';
464:
465: CURSOR cur_get_rsrc (p_rsrc cr_rsrc_mst.resources%TYPE)
466: IS
467: SELECT max_capacity, capacity_um --Bug#5231180 changed to capacity um
468: FROM cr_rsrc_mst
469: WHERE resources = p_rsrc

Line 468: FROM cr_rsrc_mst

464:
465: CURSOR cur_get_rsrc (p_rsrc cr_rsrc_mst.resources%TYPE)
466: IS
467: SELECT max_capacity, capacity_um --Bug#5231180 changed to capacity um
468: FROM cr_rsrc_mst
469: WHERE resources = p_rsrc
470: AND delete_mark = 0
471: AND capacity_constraint = 1;
472: