APPS.GME_COMMON_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 976: FROM gme_batch_header b, gmd_recipe_validity_rules a

972: CURSOR cur_get_info (v_batch_id NUMBER)
973: IS
974: SELECT b.recipe_validity_rule_id, a.recipe_id, b.organization_id
975: ,b.routing_id, b.formula_id
976: FROM gme_batch_header b, gmd_recipe_validity_rules a
977: WHERE b.batch_id = v_batch_id
978: AND b.recipe_validity_rule_id = a.recipe_validity_rule_id;
979:
980: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)

Line 983: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

979:
980: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)
981: IS
982: SELECT r.recipe_id, r.routing_id, r.formula_id
983: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
984: WHERE v.recipe_validity_rule_id = v_validity_rule_id
985: AND v.recipe_id = r.recipe_id;
986:
987: /*Bug#5618961 cursor modified to select routing class uom instead of

Line 1028: FROM gmd_recipe_validity_rules

1024: --Bug#5618961 cursor modified to select std qty, uom and inventory item id
1025: CURSOR validity_process_loss_cursor (v_recipe_validity_rule_id NUMBER)
1026: IS
1027: SELECT planned_process_loss, std_qty, detail_uom, inventory_item_id
1028: FROM gmd_recipe_validity_rules
1029: WHERE recipe_validity_rule_id = NVL (v_recipe_validity_rule_id, -1);
1030: BEGIN
1031: IF g_debug <= gme_debug.g_log_procedure THEN
1032: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 2224: FROM gmd_recipe_validity_rules

2220: IS
2221: CURSOR get_validity_rule (v_validity_rule_id NUMBER)
2222: IS
2223: SELECT *
2224: FROM gmd_recipe_validity_rules
2225: WHERE recipe_validity_rule_id = v_validity_rule_id;
2226:
2227: CURSOR cur_item_no (v_org_id NUMBER, v_inventory_item_id NUMBER)
2228: IS

Line 2234: l_validity_rec gmd_recipe_validity_rules%ROWTYPE;

2230: FROM mtl_system_items_kfv
2231: WHERE organization_id = v_org_id
2232: AND inventory_item_id = v_inventory_item_id;
2233:
2234: l_validity_rec gmd_recipe_validity_rules%ROWTYPE;
2235: --Sunitha ch. bug 5581523 removed the default value of the l_qty variable
2236: --l_qty NUMBER := 0;
2237: l_qty NUMBER;
2238: l_item_id NUMBER := NULL;

Line 4070: FROM gmd_recipe_validity_rules

4066: /* Cusror definitions */
4067: CURSOR get_validity_rule (v_validity_rule_id NUMBER)
4068: IS
4069: SELECT *
4070: FROM gmd_recipe_validity_rules
4071: WHERE recipe_validity_rule_id = v_validity_rule_id;
4072:
4073: -- Check if the validity rule status is either 'OBSOLETE' or 'ON HOLD'.
4074: CURSOR cur_get_status_type (v_validity_rule_id NUMBER)

Line 4077: FROM gmd_status gs, gmd_recipe_validity_rules grvr

4073: -- Check if the validity rule status is either 'OBSOLETE' or 'ON HOLD'.
4074: CURSOR cur_get_status_type (v_validity_rule_id NUMBER)
4075: IS
4076: SELECT status_type
4077: FROM gmd_status gs, gmd_recipe_validity_rules grvr
4078: WHERE grvr.recipe_validity_rule_id = v_validity_rule_id
4079: AND status_code = grvr.validity_rule_status;
4080:
4081: /* Local variables */

Line 4082: l_validity_rec gmd_recipe_validity_rules%ROWTYPE;

4078: WHERE grvr.recipe_validity_rule_id = v_validity_rule_id
4079: AND status_code = grvr.validity_rule_status;
4080:
4081: /* Local variables */
4082: l_validity_rec gmd_recipe_validity_rules%ROWTYPE;
4083: l_start_date DATE;
4084: l_cmplt_date DATE;
4085: l_status_type gmd_recipe_validity_rules.validity_rule_status%TYPE;
4086: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_VALIDITY_RULE';

Line 4085: l_status_type gmd_recipe_validity_rules.validity_rule_status%TYPE;

4081: /* Local variables */
4082: l_validity_rec gmd_recipe_validity_rules%ROWTYPE;
4083: l_start_date DATE;
4084: l_cmplt_date DATE;
4085: l_status_type gmd_recipe_validity_rules.validity_rule_status%TYPE;
4086: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_VALIDITY_RULE';
4087: /* EXCEPTION Definitions */
4088: invalid_validity_rule EXCEPTION;
4089: BEGIN