[Home] [Help]
3395: g_user_id,
3396: g_sysdatetime,
3397: g_login_id,
3398: trunc(g_sess_date),
3399: hr_general.end_of_time);
3400: */
3401:
3402: /* Call dml to insert new timecard. */
3403: IF g_debug
3421: p_last_update_login => g_login_id,
3422: p_payroll_id => i_payroll_id,
3423: p_status => NULL,
3424: p_effective_start_date => TRUNC (g_sess_date),
3425: p_effective_end_date => hr_general.end_of_time,
3426: p_object_version_number => l_object_version_number
3427: );
3428: --
3429: o_timecard_id := l_timecard_id;
4837: i_rate_multiple,
4838: i_hourly_rate,
4839: i_amount,
4840: TRUNC(g_sess_date),
4841: hr_general.end_of_time);
4842: */
4843:
4844: /* Call dml to insert hours */
4845: hxt_dml.insert_hxt_sum_hours_worked
4873: p_last_update_login => i_last_update_login,
4874: p_actual_time_in => i_start_time,
4875: p_actual_time_out => i_end_time,
4876: p_effective_start_date => TRUNC (g_sess_date),
4877: p_effective_end_date => hr_general.end_of_time,
4878: p_project_id => i_project_id,
4879: p_prev_wage_code => i_wage_code,
4880: p_job_id => NULL,
4881: p_earn_pol_id => i_earn_pol_id,
5097: i_rate_multiple, -- SIR290 tsm.rate_multiple,
5098: i_hourly_rate, -- SIR290 tsm.hourly_rate,
5099: i_amount, -- SIR290 tsm.amount,
5100: trunc(g_sess_date),
5101: hr_general.end_of_time
5102: FROM HXT_SUM_HOURS_WORKED_F TSM
5103: WHERE ROWID = v_row_id;
5104: */
5105: SELECT tsm.ID, tsm.tim_id, tsm.seqno
5143: p_last_update_login => i_last_update_login,
5144: p_actual_time_in => i_start_time,
5145: p_actual_time_out => i_end_time,
5146: p_effective_start_date => TRUNC (g_sess_date),
5147: p_effective_end_date => hr_general.end_of_time,
5148: p_project_id => i_project_id,
5149: p_prev_wage_code => i_wage_code,
5150: p_job_id => NULL,
5151: p_earn_pol_id => i_earn_pol_id,
5448: i_last_update_login,
5449: i_start_date,
5450: NULL,
5451: TRUNC (g_sess_date),
5452: hr_general.end_of_time,
5453: i_project_id -- p_PROJECT_ID
5454: ,
5455: NULL -- p_job_id
5456: ,