APPS.GME_RESCHEDULE_BATCH_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 59: l_recipe_validity_rule_rec gmd_recipe_validity_rules%ROWTYPE;

55: l_prim_prod_qty NUMBER;
56: l_prim_prod_um VARCHAR2 (3);
57: l_no_prod_rule_found BOOLEAN;
58: l_prim_prod_found BOOLEAN;
59: l_recipe_validity_rule_rec gmd_recipe_validity_rules%ROWTYPE;
60: l_duration NUMBER;
61: l_cal_count NUMBER;
62: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
63: l_temp_qty NUMBER;

Line 77: FROM gmd_status gs, gmd_recipe_validity_rules grvr

73:
74: CURSOR cur_get_status_type (v_validity_rule_id NUMBER)
75: IS
76: SELECT status_type
77: FROM gmd_status gs, gmd_recipe_validity_rules grvr
78: WHERE grvr.recipe_validity_rule_id = v_validity_rule_id
79: AND status_code = grvr.validity_rule_status;
80:
81: l_status_type gmd_status.status_type%TYPE;

Line 86: FROM gmd_recipe_validity_rules

82:
83: CURSOR cur_get_valid_dates (v_validity_rule_id NUMBER)
84: IS
85: SELECT start_date, end_date
86: FROM gmd_recipe_validity_rules
87: WHERE recipe_validity_rule_id = v_validity_rule_id;
88:
89: l_valid_dates_rec cur_get_valid_dates%ROWTYPE;
90:

Line 127: FROM gmd_recipe_validity_rules

123: CURSOR recipe_validity_rule_cursor (
124: p_recipe_validity_rule_id gme_batch_header.recipe_validity_rule_id%TYPE)
125: IS
126: SELECT *
127: FROM gmd_recipe_validity_rules
128: WHERE recipe_validity_rule_id = NVL (p_recipe_validity_rule_id, -1);
129:
130: CURSOR primary_prod_from_batch_cursor(v_batch_id IN NUMBER)
131: IS