[Home] [Help]
179: IS
180: /* Local variables */
181: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_BATCH';
182: l_row_count NUMBER;
183: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
184: l_scale_tab gmd_common_scale.scale_tab;
185: x_scale_tab gmd_common_scale.scale_tab;
186: l_batch_header gme_batch_header%ROWTYPE;
187: l_resch_batch_header_rec gme_batch_header%ROWTYPE;
245: -- Database cursors for various tables
246: CURSOR recipe_validity_rule_cursor (v_validity_rule_id IN NUMBER)
247: IS
248: SELECT *
249: FROM gmd_recipe_validity_rules
250: WHERE recipe_validity_rule_id = v_validity_rule_id;
251:
252: --Cursor to get status type of the validity_rule_status.
253: CURSOR cur_validity_status_type (v_validity_rule_status VARCHAR2)