749: decode(p_supercede_mode, null, g_psp_template_id, -999),
750: l_request_id,
751: l_bg_currency_code,
752: sysdate,
753: fnd_global.user_id ,
754: fnd_global.user_id,
755: fnd_global.user_id,
756: sysdate,
757: l_profile_bg_id,
750: l_request_id,
751: l_bg_currency_code,
752: sysdate,
753: fnd_global.user_id ,
754: fnd_global.user_id,
755: fnd_global.user_id,
756: sysdate,
757: l_profile_bg_id,
758: l_profile_sob_id) returning effort_report_id bulk collect into person_rec.array_effort_report_id;
751: l_bg_currency_code,
752: sysdate,
753: fnd_global.user_id ,
754: fnd_global.user_id,
755: fnd_global.user_id,
756: sysdate,
757: l_profile_bg_id,
758: l_profile_sob_id) returning effort_report_id bulk collect into person_rec.array_effort_report_id;
759:
871: 0,
872: det_schedule_start_date(i),
873: det_schedule_end_date(i),
874: sysdate,
875: fnd_global.user_id,
876: fnd_global.user_id,
877: fnd_global.user_id,
878: sysdate
879: ) returning to_number(det_person_id(i)), effort_report_detail_id bulk collect into effort_det_lines_rec.person_id, effort_det_lines_rec.effort_report_detail_id;
872: det_schedule_start_date(i),
873: det_schedule_end_date(i),
874: sysdate,
875: fnd_global.user_id,
876: fnd_global.user_id,
877: fnd_global.user_id,
878: sysdate
879: ) returning to_number(det_person_id(i)), effort_report_detail_id bulk collect into effort_det_lines_rec.person_id, effort_det_lines_rec.effort_report_detail_id;
880:
873: det_schedule_end_date(i),
874: sysdate,
875: fnd_global.user_id,
876: fnd_global.user_id,
877: fnd_global.user_id,
878: sysdate
879: ) returning to_number(det_person_id(i)), effort_report_detail_id bulk collect into effort_det_lines_rec.person_id, effort_det_lines_rec.effort_report_detail_id;
880:
881: