172: l_statem := l_statem||' p_bus_grp => :l_bus_grp, ';
173: l_statem := l_statem||' p_payroll_id => :l_payroll_id, ';
174: l_statem := l_statem||' p_asg_action => :l_asg_action); end; ';
175: --
176: sql_cursor := dbms_sql.open_cursor;
177: --
178: dbms_sql.parse(sql_cursor, l_statem, dbms_sql.v7);
179: --
180: --
174: l_statem := l_statem||' p_asg_action => :l_asg_action); end; ';
175: --
176: sql_cursor := dbms_sql.open_cursor;
177: --
178: dbms_sql.parse(sql_cursor, l_statem, dbms_sql.v7);
179: --
180: --
181: dbms_sql.bind_variable(sql_cursor, 'l_eff_date', p_effective_date);
182: dbms_sql.bind_variable(sql_cursor, 'l_start_date', p_start_date);
177: --
178: dbms_sql.parse(sql_cursor, l_statem, dbms_sql.v7);
179: --
180: --
181: dbms_sql.bind_variable(sql_cursor, 'l_eff_date', p_effective_date);
182: dbms_sql.bind_variable(sql_cursor, 'l_start_date', p_start_date);
183: dbms_sql.bind_variable(sql_cursor, 'l_bus_grp', p_bus_grp);
184: dbms_sql.bind_variable(sql_cursor, 'l_payroll_id', p_payroll_id);
185: dbms_sql.bind_variable(sql_cursor, 'l_asg_action', p_asg_action);
178: dbms_sql.parse(sql_cursor, l_statem, dbms_sql.v7);
179: --
180: --
181: dbms_sql.bind_variable(sql_cursor, 'l_eff_date', p_effective_date);
182: dbms_sql.bind_variable(sql_cursor, 'l_start_date', p_start_date);
183: dbms_sql.bind_variable(sql_cursor, 'l_bus_grp', p_bus_grp);
184: dbms_sql.bind_variable(sql_cursor, 'l_payroll_id', p_payroll_id);
185: dbms_sql.bind_variable(sql_cursor, 'l_asg_action', p_asg_action);
186: --
179: --
180: --
181: dbms_sql.bind_variable(sql_cursor, 'l_eff_date', p_effective_date);
182: dbms_sql.bind_variable(sql_cursor, 'l_start_date', p_start_date);
183: dbms_sql.bind_variable(sql_cursor, 'l_bus_grp', p_bus_grp);
184: dbms_sql.bind_variable(sql_cursor, 'l_payroll_id', p_payroll_id);
185: dbms_sql.bind_variable(sql_cursor, 'l_asg_action', p_asg_action);
186: --
187: l_rows := dbms_sql.execute(sql_cursor);
180: --
181: dbms_sql.bind_variable(sql_cursor, 'l_eff_date', p_effective_date);
182: dbms_sql.bind_variable(sql_cursor, 'l_start_date', p_start_date);
183: dbms_sql.bind_variable(sql_cursor, 'l_bus_grp', p_bus_grp);
184: dbms_sql.bind_variable(sql_cursor, 'l_payroll_id', p_payroll_id);
185: dbms_sql.bind_variable(sql_cursor, 'l_asg_action', p_asg_action);
186: --
187: l_rows := dbms_sql.execute(sql_cursor);
188: --
181: dbms_sql.bind_variable(sql_cursor, 'l_eff_date', p_effective_date);
182: dbms_sql.bind_variable(sql_cursor, 'l_start_date', p_start_date);
183: dbms_sql.bind_variable(sql_cursor, 'l_bus_grp', p_bus_grp);
184: dbms_sql.bind_variable(sql_cursor, 'l_payroll_id', p_payroll_id);
185: dbms_sql.bind_variable(sql_cursor, 'l_asg_action', p_asg_action);
186: --
187: l_rows := dbms_sql.execute(sql_cursor);
188: --
189: if (l_rows = 1) then
183: dbms_sql.bind_variable(sql_cursor, 'l_bus_grp', p_bus_grp);
184: dbms_sql.bind_variable(sql_cursor, 'l_payroll_id', p_payroll_id);
185: dbms_sql.bind_variable(sql_cursor, 'l_asg_action', p_asg_action);
186: --
187: l_rows := dbms_sql.execute(sql_cursor);
188: --
189: if (l_rows = 1) then
190: dbms_sql.variable_value(sql_cursor, 'l_start_date',
191: l_return_date);
186: --
187: l_rows := dbms_sql.execute(sql_cursor);
188: --
189: if (l_rows = 1) then
190: dbms_sql.variable_value(sql_cursor, 'l_start_date',
191: l_return_date);
192: dbms_sql.close_cursor(sql_cursor);
193: --
194: else
188: --
189: if (l_rows = 1) then
190: dbms_sql.variable_value(sql_cursor, 'l_start_date',
191: l_return_date);
192: dbms_sql.close_cursor(sql_cursor);
193: --
194: else
195: l_return_date := to_date('0001/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS');
196: dbms_sql.close_cursor(sql_cursor);
192: dbms_sql.close_cursor(sql_cursor);
193: --
194: else
195: l_return_date := to_date('0001/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS');
196: dbms_sql.close_cursor(sql_cursor);
197: end if;
198: /* Bug 13537723, code changes end */
199: end if;
200: --