97: l_qty NUMBER;
98: l_schedule_date DATE;
99: i NUMBER;
100: l_now DATE := SYSDATE;
101: l_user_id NUMBER := fnd_global.user_id;
102: l_login_id NUMBER := fnd_global.login_id;
103: l_conc_request_id NUMBER := fnd_global.conc_request_id;
104: l_prog_appl_id NUMBER := fnd_global.prog_appl_id;
105: l_conc_program_id NUMBER := fnd_global.conc_program_id;
98: l_schedule_date DATE;
99: i NUMBER;
100: l_now DATE := SYSDATE;
101: l_user_id NUMBER := fnd_global.user_id;
102: l_login_id NUMBER := fnd_global.login_id;
103: l_conc_request_id NUMBER := fnd_global.conc_request_id;
104: l_prog_appl_id NUMBER := fnd_global.prog_appl_id;
105: l_conc_program_id NUMBER := fnd_global.conc_program_id;
106:
99: i NUMBER;
100: l_now DATE := SYSDATE;
101: l_user_id NUMBER := fnd_global.user_id;
102: l_login_id NUMBER := fnd_global.login_id;
103: l_conc_request_id NUMBER := fnd_global.conc_request_id;
104: l_prog_appl_id NUMBER := fnd_global.prog_appl_id;
105: l_conc_program_id NUMBER := fnd_global.conc_program_id;
106:
107: CURSOR qty_c (p_transaction_id NUMBER) IS
100: l_now DATE := SYSDATE;
101: l_user_id NUMBER := fnd_global.user_id;
102: l_login_id NUMBER := fnd_global.login_id;
103: l_conc_request_id NUMBER := fnd_global.conc_request_id;
104: l_prog_appl_id NUMBER := fnd_global.prog_appl_id;
105: l_conc_program_id NUMBER := fnd_global.conc_program_id;
106:
107: CURSOR qty_c (p_transaction_id NUMBER) IS
108: SELECT schedule_quantity, original_schedule_quantity, schedule_date
101: l_user_id NUMBER := fnd_global.user_id;
102: l_login_id NUMBER := fnd_global.login_id;
103: l_conc_request_id NUMBER := fnd_global.conc_request_id;
104: l_prog_appl_id NUMBER := fnd_global.prog_appl_id;
105: l_conc_program_id NUMBER := fnd_global.conc_program_id;
106:
107: CURSOR qty_c (p_transaction_id NUMBER) IS
108: SELECT schedule_quantity, original_schedule_quantity, schedule_date
109: FROM Mrp_Schedule_Dates