DBA Data[Home] [Help]

APPS.GME_SCALE_BATCH_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 189: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;

185: IS
186: /* Local variables */
187: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_BATCH';
188: l_row_count NUMBER;
189: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
190: l_scale_tab gmd_common_scale.scale_tab;
191: x_scale_tab gmd_common_scale.scale_tab;
192: l_batch_header gme_batch_header%ROWTYPE;
193: l_resch_batch_header_rec gme_batch_header%ROWTYPE;

Line 255: FROM gmd_recipe_validity_rules

251: -- Database cursors for various tables
252: CURSOR recipe_validity_rule_cursor (v_validity_rule_id IN NUMBER)
253: IS
254: SELECT *
255: FROM gmd_recipe_validity_rules
256: WHERE recipe_validity_rule_id = v_validity_rule_id;
257:
258: --Cursor to get status type of the validity_rule_status.
259: CURSOR cur_validity_status_type (v_validity_rule_status VARCHAR2)