eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_VALIDITY_RULES_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 312: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;

308: l_recipe_theo_loss GMD_PROCESS_LOSS.process_loss%TYPE;
309: x_msg_cnt NUMBER;
310: x_msg_dat VARCHAR2(2000);
311:
312: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;
313: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;
314: l_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;
315: l_orgn_code gmd_recipe_validity_rules.orgn_code%TYPE;
316:

Line 313: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;

309: x_msg_cnt NUMBER;
310: x_msg_dat VARCHAR2(2000);
311:
312: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;
313: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;
314: l_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;
315: l_orgn_code gmd_recipe_validity_rules.orgn_code%TYPE;
316:
317: CURSOR get_other_vr_details(V_vr_id NUMBER) IS

Line 314: l_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;

310: x_msg_dat VARCHAR2(2000);
311:
312: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;
313: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;
314: l_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;
315: l_orgn_code gmd_recipe_validity_rules.orgn_code%TYPE;
316:
317: CURSOR get_other_vr_details(V_vr_id NUMBER) IS
318: SELECT std_qty, inventory_item_id, detail_uom, orgn_code

Line 315: l_orgn_code gmd_recipe_validity_rules.orgn_code%TYPE;

311:
312: l_std_qty gmd_recipe_validity_rules.std_qty%TYPE;
313: l_detail_uom gmd_recipe_validity_rules.detail_uom%TYPE;
314: l_item_id gmd_recipe_validity_rules.inventory_item_id%TYPE;
315: l_orgn_code gmd_recipe_validity_rules.orgn_code%TYPE;
316:
317: CURSOR get_other_vr_details(V_vr_id NUMBER) IS
318: SELECT std_qty, inventory_item_id, detail_uom, orgn_code
319: FROM gmd_recipe_validity_rules

Line 319: FROM gmd_recipe_validity_rules

315: l_orgn_code gmd_recipe_validity_rules.orgn_code%TYPE;
316:
317: CURSOR get_other_vr_details(V_vr_id NUMBER) IS
318: SELECT std_qty, inventory_item_id, detail_uom, orgn_code
319: FROM gmd_recipe_validity_rules
320: WHERE recipe_validity_rule_id = V_vr_id;
321:
322: l_api_name VARCHAR2(100) := 'calculate_process_loss' ;
323:

Line 396: FROM gmd_recipe_validity_rules

392: ) IS
393:
394: CURSOR Cur_check_dup_upd IS
395: SELECT recipe_validity_rule_id
396: FROM gmd_recipe_validity_rules
397: WHERE recipe_id = pRecipe_id
398: AND inventory_item_id = pitem_id -- NPD Conv.
399: AND ((orgn_code = pOrgn_code) OR
400: (orgn_code IS NULL AND pOrgn_code IS NULL))

Line 456: ( p_validity_rule_id IN gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE

452: /* Michael Tou 25-Oct-2011 Bug# 6713805 Added ITEM_UM in order to re-calculate */
453: /* inv_min_qty, inv_max_qty whenever UOM updates */
454: /* =============================================================== */
455: PROCEDURE update_validity_rules
456: ( p_validity_rule_id IN gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE
457: , p_update_table IN gmd_validity_rules_pvt.update_tbl_type
458: , x_message_count OUT NOCOPY NUMBER
459: , x_message_list OUT NOCOPY VARCHAR2
460: , x_return_status OUT NOCOPY VARCHAR2

Line 475: l_old_vr_rec gmd_recipe_validity_rules%ROWTYPE;

471: l_formula_id NUMBER;
472: l_recp_use NUMBER;
473:
474: /* Define record type that hold the routing data */
475: l_old_vr_rec gmd_recipe_validity_rules%ROWTYPE;
476: l_organization_id number := null; -- Bug 14690148 pal
477:
478: /* Define Exceptions */
479: VR_update_failure EXCEPTION;

Line 486: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS

482: setup_failure EXCEPTION;
483:
484: /* Define cursor section */
485: CURSOR get_old_vr_rec(vValidity_rule_id
486: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS
487: Select *
488: From gmd_recipe_validity_rules
489: Where recipe_validity_rule_id = vValidity_rule_id;
490:

Line 488: From gmd_recipe_validity_rules

484: /* Define cursor section */
485: CURSOR get_old_vr_rec(vValidity_rule_id
486: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS
487: Select *
488: From gmd_recipe_validity_rules
489: Where recipe_validity_rule_id = vValidity_rule_id;
490:
491: CURSOR Get_db_last_update_date(vValidity_rule_id
492: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS

Line 492: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS

488: From gmd_recipe_validity_rules
489: Where recipe_validity_rule_id = vValidity_rule_id;
490:
491: CURSOR Get_db_last_update_date(vValidity_rule_id
492: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS
493: Select last_update_date
494: From gmd_recipe_validity_rules
495: Where recipe_validity_rule_id = vValidity_rule_id;
496:

Line 494: From gmd_recipe_validity_rules

490:
491: CURSOR Get_db_last_update_date(vValidity_rule_id
492: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS
493: Select last_update_date
494: From gmd_recipe_validity_rules
495: Where recipe_validity_rule_id = vValidity_rule_id;
496:
497: CURSOR Get_Routing_Details(vValidity_rule_id
498: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS

Line 498: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS

494: From gmd_recipe_validity_rules
495: Where recipe_validity_rule_id = vValidity_rule_id;
496:
497: CURSOR Get_Routing_Details(vValidity_rule_id
498: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS
499: Select rt.Effective_Start_Date,
500: rt.Effective_End_Date
501: From gmd_routings_b rt, gmd_recipes_b rc,
502: gmd_recipe_validity_rules vr

Line 502: gmd_recipe_validity_rules vr

498: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS
499: Select rt.Effective_Start_Date,
500: rt.Effective_End_Date
501: From gmd_routings_b rt, gmd_recipes_b rc,
502: gmd_recipe_validity_rules vr
503: Where vr.recipe_id = rc.recipe_id AND
504: rc.routing_id = rt.routing_id AND
505: vr.recipe_validity_rule_id = vValidity_rule_id AND
506: rt.delete_mark = 0;

Line 532: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

528:
529: -- Cursor to fetch recipe use and formula id of the VR
530: CURSOR get_recp_dets IS
531: SELECT r.formula_id, v.recipe_use
532: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
533: WHERE v.recipe_validity_rule_id = p_validity_rule_id
534: AND v.recipe_id = r.recipe_id;
535:
536: BEGIN

Line 1051: UPDATE GMD_RECIPE_VALIDITY_RULES

1047: RAISE vr_update_failure;
1048: END IF;
1049:
1050: /* Number of times this routine is equal to number of rows in the p_update_table */
1051: UPDATE GMD_RECIPE_VALIDITY_RULES
1052: SET
1053: recipe_id = l_old_vr_rec.recipe_id
1054: , orgn_code = l_old_vr_rec.orgn_code
1055: -- NPD Conv.