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 454: ( p_validity_rule_id IN gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE

450: /* Changed the call from fnd_date.CHARDATE_TO_DATE to */
451: /* fnd_date.CANONICAL_TO_DATE
452: /* =============================================================== */
453: PROCEDURE update_validity_rules
454: ( p_validity_rule_id IN gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE
455: , p_update_table IN gmd_validity_rules_pvt.update_tbl_type
456: , x_message_count OUT NOCOPY NUMBER
457: , x_message_list OUT NOCOPY VARCHAR2
458: , x_return_status OUT NOCOPY VARCHAR2

Line 473: l_old_vr_rec gmd_recipe_validity_rules%ROWTYPE;

469: l_formula_id NUMBER;
470: l_recp_use NUMBER;
471:
472: /* Define record type that hold the routing data */
473: l_old_vr_rec gmd_recipe_validity_rules%ROWTYPE;
474:
475: /* Define Exceptions */
476: VR_update_failure EXCEPTION;
477: last_update_date_failure EXCEPTION;

Line 483: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS

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

Line 485: From gmd_recipe_validity_rules

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

Line 489: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS

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

Line 491: From gmd_recipe_validity_rules

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

Line 495: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS

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

Line 499: gmd_recipe_validity_rules vr

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

Line 529: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

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

Line 1038: UPDATE GMD_RECIPE_VALIDITY_RULES

1034: RAISE vr_update_failure;
1035: END IF;
1036:
1037: /* Number of times this routine is equal to number of rows in the p_update_table */
1038: UPDATE GMD_RECIPE_VALIDITY_RULES
1039: SET
1040: recipe_id = l_old_vr_rec.recipe_id
1041: , orgn_code = l_old_vr_rec.orgn_code
1042: -- NPD Conv.