APPS.HXC_TIMEKEEPER_PROCESS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 73

   SELECT   ppf.person_id person_id, ppf.full_name,
            NVL (ppf.employee_number, ppf.npw_number) employee_number,
            hr_person_type_usage_info.get_user_person_type (p_start_period, ppf.person_id) person_type
   FROM     hxc_tk_group_queries htgq,
            hxc_tk_groups htg,
            hxc_tk_group_query_criteria htgqc,
            per_all_people_f ppf,
            per_all_assignments_f paa,
            per_person_type_usages_f ptu,
            per_person_types ppt
   WHERE    ppf.person_id = paa.person_id
AND         ppt.person_type_id = ptu.person_type_id
AND         ppt.system_person_type IN ('EMP', 'EMP_APL', 'CWK','EX_EMP', 'EX_CWK')
AND         (   p_person_type IS NULL
             OR (    DECODE (ppt.system_person_type, 'EMP_APL', 'EMP', ppt.system_person_type) =
                                                                                           p_person_type
                 AND p_person_type IS NOT NULL
                )
            )
AND         ptu.person_id = ppf.person_id
AND         p_start_period <= ptu.effective_end_date
AND         p_end_period >= ptu.effective_start_date
AND         paa.primary_flag = 'Y'
AND         paa.assignment_type IN ('E', 'C')
AND         p_start_period <= paa.effective_end_date
AND         p_end_period >= paa.effective_start_date
AND         p_start_period <= ppf.effective_end_date
AND         p_end_period >= ppf.effective_start_date
AND         ppf.person_id = htgqc.criteria_id
AND         htgqc.tk_group_query_id = htgq.tk_group_query_id
AND         htgq.tk_group_id = htg.tk_group_id
AND         htg.business_group_id = ppf.business_group_id
AND         htg.tk_group_id = p_group_id
AND         ppf.person_id = NVL (p_resource_id, ppf.person_id)
AND         htgq.include_exclude = 'I'
AND         htgqc.criteria_type = 'PERSON'
AND         ppf.effective_end_date = (SELECT MAX (ppf2.effective_end_date)
                                      FROM   per_people_f ppf2, per_all_assignments_f paa2
                                      WHERE  ppf2.person_id = paa2.person_id
AND                                          paa2.primary_flag = 'Y'
AND                                          paa2.assignment_type IN ('E', 'C')
AND                                          p_start_period <= paa2.effective_end_date
AND                                          p_end_period >= paa2.effective_start_date
AND                                          p_start_period <= ppf2.effective_end_date
AND                                          p_end_period >= ppf2.effective_start_date
AND                                          ppf2.person_id = ppf.person_id)
   UNION
   SELECT   ppf.person_id person_id, ppf.full_name,
            NVL (ppf.employee_number, ppf.npw_number) employee_number,
            hr_person_type_usage_info.get_user_person_type (p_start_period, ppf.person_id) person_type
   FROM     hxc_tk_group_queries htgq,
            hxc_tk_groups htg,
            hxc_tk_group_query_criteria htgqc,
            per_all_people_f ppf,
            per_all_assignments_f paa,
            per_person_type_usages_f ptu,
            per_person_types ppt
   WHERE    ppf.person_id = paa.person_id
AND         ppt.person_type_id = ptu.person_type_id
AND         ppt.system_person_type IN ('EMP', 'EMP_APL', 'CWK','EX_EMP')
AND         ptu.person_id = ppf.person_id
AND         (   p_person_type IS NULL
             OR (    DECODE (ppt.system_person_type, 'EMP_APL', 'EMP', ppt.system_person_type) =
                                                                                           p_person_type
                 AND p_person_type IS NOT NULL
                )
            )
AND         p_start_period <= ptu.effective_end_date
AND         p_end_period >= ptu.effective_start_date
AND         paa.primary_flag = 'Y'
AND         paa.assignment_type IN ('E', 'C')
AND         p_start_period <= paa.effective_end_date
AND         p_end_period >= paa.effective_start_date
AND         p_start_period <= ppf.effective_end_date
AND         p_end_period >= ppf.effective_start_date
AND         ppf.person_id = p_resource_id
AND         ppf.person_id = htgqc.criteria_id
AND         htgqc.tk_group_query_id = htgq.tk_group_query_id
AND         htgq.tk_group_id = htg.tk_group_id
AND         htg.business_group_id = ppf.business_group_id
AND         htgq.include_exclude = 'I'
AND         htgqc.criteria_type = 'PERSON'
AND         ppf.effective_end_date = (SELECT MAX (ppf2.effective_end_date)
                                      FROM   per_people_f ppf2, per_all_assignments_f paa2
                                      WHERE  ppf2.person_id = paa2.person_id
AND                                          paa2.primary_flag = 'Y'
AND                                          paa2.assignment_type IN ('E', 'C')
AND                                          p_start_period <= paa2.effective_end_date
AND                                          p_end_period >= paa2.effective_start_date
AND                                          p_start_period <= ppf2.effective_end_date
AND                                          p_end_period >= ppf2.effective_start_date
AND                                          ppf2.person_id = ppf.person_id)
   ORDER BY 2;

Line: 178

   SELECT time_building_block_id, object_version_number, start_time, comment_text, created_by,
          creation_date, last_updated_by, last_update_date, last_update_login
   FROM   hxc_time_building_blocks
   WHERE  resource_id = p_resource_id
AND       SCOPE = 'TIMECARD'
AND       start_time = p_start_period
AND       stop_time = p_end_period
AND       date_to = hr_general.end_of_time;

Line: 190

   SELECT *
   FROM   hxc_tk_detail_temp
   WHERE  detailid = p_detailid;

Line: 200

   SELECT   detail.time_building_block_id detail_id, detail.object_version_number detail_ovn,
            detail.measure, DAY.start_time, detail.start_time time_in, detail.stop_time time_out,
            detail.comment_text
   FROM     hxc_time_building_blocks detail, hxc_time_building_blocks DAY
   WHERE    DAY.parent_building_block_id = timecard_id
AND         DAY.parent_building_block_ovn = timecard_ovn
AND         detail.date_to = hr_general.end_of_time
AND         detail.SCOPE = 'DETAIL'
AND         detail.parent_building_block_id = DAY.time_building_block_id
AND         detail.parent_building_block_ovn = DAY.object_version_number
AND         DAY.SCOPE = 'DAY'
AND         DAY.date_to = hr_general.end_of_time
   ORDER BY 4, 5, 1; --nitin

Line: 218

      SELECT approval_status
      FROM hxc_timecard_summary
      WHERE timecard_id = time_building_block_id
         AND timecard_ovn = time_building_block_ovn;

Line: 292

  l_last_update_date        DATE;

Line: 293

  l_last_updated_by         NUMBER (16);

Line: 294

  l_last_update_login       NUMBER (16);

Line: 415

    SELECT detail.time_building_block_id bb_id, detail.object_version_number bb_ovn
    FROM   hxc_time_building_blocks detail, hxc_time_building_blocks DAY
    WHERE  DAY.parent_building_block_id = p_bb_id
/*ADVICE(509): Cursor references an external variable (use a parameter) [209] */

AND        DAY.parent_building_block_ovn = p_bb_ovn
/*ADVICE(512): Cursor references an external variable (use a parameter) [209] */

AND        detail.date_to = hr_general.end_of_time
AND        detail.SCOPE = 'DETAIL'
AND        detail.parent_building_block_id = DAY.time_building_block_id
AND        detail.parent_building_block_ovn = DAY.object_version_number
AND        DAY.SCOPE = 'DAY'
AND        DAY.date_to = hr_general.end_of_time;

Line: 436

    SELECT 'Y'
    FROM   hxc_errors
    WHERE  time_building_block_id = bb_id
AND        time_building_block_ovn = bb_ovn
AND        (date_to = hr_general.end_of_time OR date_to IS NULL)
AND        message_level = DECODE (msg_type, 'ALL', message_level, NULL, message_level, msg_type)
AND        message_name = DECODE (msg_text, NULL, message_name, msg_text);

Line: 494

    SELECT detail.time_building_block_id bb_id, detail.object_version_number bb_ovn
    FROM   hxc_time_building_blocks detail, hxc_time_building_blocks DAY
    WHERE  DAY.parent_building_block_id = p_bb_id
/*ADVICE(588): Cursor references an external variable (use a parameter) [209] */

AND        DAY.parent_building_block_ovn = p_bb_ovn
/*ADVICE(591): Cursor references an external variable (use a parameter) [209] */

AND        detail.date_to = hr_general.end_of_time
AND        detail.SCOPE = 'DETAIL'
AND        detail.parent_building_block_id = DAY.time_building_block_id
AND        detail.parent_building_block_ovn = DAY.object_version_number
AND        DAY.SCOPE = 'DAY'
AND        DAY.date_to = hr_general.end_of_time;

Line: 516

    SELECT 'Y'
    FROM   hxc_time_attributes
    WHERE  time_attribute_id IN (SELECT time_attribute_id
                                 FROM   hxc_time_attribute_usages
                                 WHERE  time_building_block_id = bb_id
AND                                     time_building_block_ovn = bb_ovn)
AND        attribute_category = 'REASON'
AND        attribute1 = DECODE (attribute3, 'CHANGE', change_reason, 'LATE', late_reason)
AND        NVL (attribute7, '-99') = DECODE (audit_history, NULL, NVL (attribute7, '-99'), audit_history);

Line: 531

    SELECT 'Y'
    FROM   hxc_time_attributes
    WHERE  time_attribute_id IN (SELECT time_attribute_id
                                 FROM   hxc_time_attribute_usages
                                 WHERE  time_building_block_id = bb_id
AND                                     time_building_block_ovn = bb_ovn)
AND        attribute_category = 'REASON'
AND        attribute7 = DECODE (audit_history, NULL, attribute7, audit_history);

Line: 621

   g_resource_tc_table.DELETE;

Line: 622

   g_submit_table.DELETE;

Line: 667

  ELSE -- global checkbix select
   --get the timekeeper setup preference for details  button  to decide the category

   IF g_base_att IS NULL THEN
    g_base_att := hxc_preference_evaluation.resource_preferences (
                   p_resource_id => p_timekeeper_id,
                   p_pref_code => 'TK_TCARD_SETUP',
                   p_attribute_n => 4,
                   p_evaluation_date => SYSDATE
                  );

Line: 683

    g_tk_data_query_from_process.DELETE;

Line: 696

     g_detail_data.DELETE;

Line: 698

     DELETE FROM hxc_tk_detail_temp; --4191367

Line: 699

/*ADVICE(786): Use of DELETE or UPDATE without WHERE clause [313] */


     g_submit_table.DELETE;

Line: 703

     g_lock_table.DELETE;

Line: 704

     g_resource_tc_table.DELETE;

Line: 785

       emp_qry_tc_info.DELETE;

Line: 860

                                    l_last_updated_by,
                                    l_last_update_date,
                                    l_last_update_login;

Line: 968

          l_buffer_info.DELETE;

Line: 976

          l_attributes.DELETE;

Line: 977

          l_detail_info_table.DELETE;

Line: 980

	  l_timecard.DELETE;

Line: 1052

           t_base_table.DELETE;

Line: 1122

                      hr_utility.TRACE ('inserting='|| x.comment_text || ' for x.detail_id= ' || x.detail_id);

Line: 1135

               UPDATE hxc_tk_detail_temp
               SET    dff_catg = l_attributes (l_attribute_index).attribute_category,
                      dff_oldcatg = l_attributes (l_attribute_index).attribute_category,
                      dff_attr1 = l_attributes (l_attribute_index).attribute1,
                      dff_attr2 = l_attributes (l_attribute_index).attribute2,
                      dff_attr3 = l_attributes (l_attribute_index).attribute3,
                      dff_attr4 = l_attributes (l_attribute_index).attribute4,
                      dff_attr5 = l_attributes (l_attribute_index).attribute5,
                      dff_attr6 = l_attributes (l_attribute_index).attribute6,
                      dff_attr7 = l_attributes (l_attribute_index).attribute7,
                      dff_attr8 = l_attributes (l_attribute_index).attribute8,
                      dff_attr9 = l_attributes (l_attribute_index).attribute9,
                      dff_attr10 = l_attributes (l_attribute_index).attribute10,
                      dff_attr11 = l_attributes (l_attribute_index).attribute11,
                      dff_attr12 = l_attributes (l_attribute_index).attribute12,
                      dff_attr13 = l_attributes (l_attribute_index).attribute13,
                      dff_attr14 = l_attributes (l_attribute_index).attribute14,
                      dff_attr15 = l_attributes (l_attribute_index).attribute15,
                      dff_attr16 = l_attributes (l_attribute_index).attribute16,
                      dff_attr17 = l_attributes (l_attribute_index).attribute17,
                      dff_attr18 = l_attributes (l_attribute_index).attribute18,
                      dff_attr19 = l_attributes (l_attribute_index).attribute19,
                      dff_attr20 = l_attributes (l_attribute_index).attribute20,
                      dff_attr21 = l_attributes (l_attribute_index).attribute21,
                      dff_attr22 = l_attributes (l_attribute_index).attribute22,
                      dff_attr23 = l_attributes (l_attribute_index).attribute23,
                      dff_attr24 = l_attributes (l_attribute_index).attribute24,
                      dff_attr25 = l_attributes (l_attribute_index).attribute25,
                      dff_attr26 = l_attributes (l_attribute_index).attribute26,
                      dff_attr27 = l_attributes (l_attribute_index).attribute27,
                      dff_attr28 = l_attributes (l_attribute_index).attribute28,
                      dff_attr29 = l_attributes (l_attribute_index).attribute29,
                      dff_attr30 = l_attributes (l_attribute_index).attribute30,
                      dff_oldattr1 = l_attributes (l_attribute_index).attribute1,
                      dff_oldattr2 = l_attributes (l_attribute_index).attribute2,
                      dff_oldattr3 = l_attributes (l_attribute_index).attribute3,
                      dff_oldattr4 = l_attributes (l_attribute_index).attribute4,
                      dff_oldattr5 = l_attributes (l_attribute_index).attribute5,
                      dff_oldattr6 = l_attributes (l_attribute_index).attribute6,
                      dff_oldattr7 = l_attributes (l_attribute_index).attribute7,
                      dff_oldattr8 = l_attributes (l_attribute_index).attribute8,
                      dff_oldattr9 = l_attributes (l_attribute_index).attribute9,
                      dff_oldattr10 = l_attributes (l_attribute_index).attribute10,
                      dff_oldattr11 = l_attributes (l_attribute_index).attribute11,
                      dff_oldattr12 = l_attributes (l_attribute_index).attribute12,
                      dff_oldattr13 = l_attributes (l_attribute_index).attribute13,
                      dff_oldattr14 = l_attributes (l_attribute_index).attribute14,
                      dff_oldattr15 = l_attributes (l_attribute_index).attribute15,
                      dff_oldattr16 = l_attributes (l_attribute_index).attribute16,
                      dff_oldattr17 = l_attributes (l_attribute_index).attribute17,
                      dff_oldattr18 = l_attributes (l_attribute_index).attribute18,
                      dff_oldattr19 = l_attributes (l_attribute_index).attribute19,
                      dff_oldattr20 = l_attributes (l_attribute_index).attribute20,
                      dff_oldattr21 = l_attributes (l_attribute_index).attribute21,
                      dff_oldattr22 = l_attributes (l_attribute_index).attribute22,
                      dff_oldattr23 = l_attributes (l_attribute_index).attribute23,
                      dff_oldattr24 = l_attributes (l_attribute_index).attribute24,
                      dff_oldattr25 = l_attributes (l_attribute_index).attribute25,
                      dff_oldattr26 = l_attributes (l_attribute_index).attribute26,
                      dff_oldattr27 = l_attributes (l_attribute_index).attribute27,
                      dff_oldattr28 = l_attributes (l_attribute_index).attribute28,
                      dff_oldattr29 = l_attributes (l_attribute_index).attribute29,
                      dff_oldattr30 = l_attributes (l_attribute_index).attribute30
               WHERE  detailid = x.detail_id;

Line: 1200

               INSERT INTO hxc_tk_detail_temp
                           (detailid, timecard_id, resource_id, comment_text, dff_catg, dff_oldcatg,
                            dff_attr1, dff_attr2, dff_attr3, dff_attr4, dff_attr5, dff_attr6, dff_attr7,
                            dff_attr8, dff_attr9, dff_attr10, dff_attr11, dff_attr12, dff_attr13,
                            dff_attr14, dff_attr15, dff_attr16, dff_attr17, dff_attr18, dff_attr19,
                            dff_attr20, dff_attr21, dff_attr22, dff_attr23, dff_attr24, dff_attr25,
                            dff_attr26, dff_attr27, dff_attr28, dff_attr29, dff_attr30, dff_oldattr1,
                            dff_oldattr2, dff_oldattr3, dff_oldattr4, dff_oldattr5, dff_oldattr6,
                            dff_oldattr7, dff_oldattr8, dff_oldattr9, dff_oldattr10, dff_oldattr11,
                            dff_oldattr12, dff_oldattr13, dff_oldattr14, dff_oldattr15, dff_oldattr16,
                            dff_oldattr17, dff_oldattr18, dff_oldattr19, dff_oldattr20, dff_oldattr21,
                            dff_oldattr22, dff_oldattr23, dff_oldattr24, dff_oldattr25, dff_oldattr26,
                            dff_oldattr27, dff_oldattr28, dff_oldattr29, dff_oldattr30)
               VALUES      (x.detail_id, l_timecard_id, p_resource_id, x.comment_text,
                            l_attributes (l_attribute_index).attribute_category,
                            l_attributes (l_attribute_index).attribute_category,
                            l_attributes (l_attribute_index).attribute1,
                            l_attributes (l_attribute_index).attribute2,
                            l_attributes (l_attribute_index).attribute3,
                            l_attributes (l_attribute_index).attribute4,
                            l_attributes (l_attribute_index).attribute5,
                            l_attributes (l_attribute_index).attribute6,
                            l_attributes (l_attribute_index).attribute7,
                            l_attributes (l_attribute_index).attribute8,
                            l_attributes (l_attribute_index).attribute9,
                            l_attributes (l_attribute_index).attribute10,
                            l_attributes (l_attribute_index).attribute11,
                            l_attributes (l_attribute_index).attribute12,
                            l_attributes (l_attribute_index).attribute13,
                            l_attributes (l_attribute_index).attribute14,
                            l_attributes (l_attribute_index).attribute15,
                            l_attributes (l_attribute_index).attribute16,
                            l_attributes (l_attribute_index).attribute17,
                            l_attributes (l_attribute_index).attribute18,
                            l_attributes (l_attribute_index).attribute19,
                            l_attributes (l_attribute_index).attribute20,
                            l_attributes (l_attribute_index).attribute21,
                            l_attributes (l_attribute_index).attribute22,
                            l_attributes (l_attribute_index).attribute23,
                            l_attributes (l_attribute_index).attribute24,
                            l_attributes (l_attribute_index).attribute25,
                            l_attributes (l_attribute_index).attribute26,
                            l_attributes (l_attribute_index).attribute27,
                            l_attributes (l_attribute_index).attribute28,
                            l_attributes (l_attribute_index).attribute29,
                            l_attributes (l_attribute_index).attribute30,
                            l_attributes (l_attribute_index).attribute1,
                            l_attributes (l_attribute_index).attribute2,
                            l_attributes (l_attribute_index).attribute3,
                            l_attributes (l_attribute_index).attribute4,
                            l_attributes (l_attribute_index).attribute5,
                            l_attributes (l_attribute_index).attribute6,
                            l_attributes (l_attribute_index).attribute7,
                            l_attributes (l_attribute_index).attribute8,
                            l_attributes (l_attribute_index).attribute9,
                            l_attributes (l_attribute_index).attribute10,
                            l_attributes (l_attribute_index).attribute11,
                            l_attributes (l_attribute_index).attribute12,
                            l_attributes (l_attribute_index).attribute13,
                            l_attributes (l_attribute_index).attribute14,
                            l_attributes (l_attribute_index).attribute15,
                            l_attributes (l_attribute_index).attribute16,
                            l_attributes (l_attribute_index).attribute17,
                            l_attributes (l_attribute_index).attribute18,
                            l_attributes (l_attribute_index).attribute19,
                            l_attributes (l_attribute_index).attribute20,
                            l_attributes (l_attribute_index).attribute21,
                            l_attributes (l_attribute_index).attribute22,
                            l_attributes (l_attribute_index).attribute23,
                            l_attributes (l_attribute_index).attribute24,
                            l_attributes (l_attribute_index).attribute25,
                            l_attributes (l_attribute_index).attribute26,
                            l_attributes (l_attribute_index).attribute27,
                            l_attributes (l_attribute_index).attribute28,
                            l_attributes (l_attribute_index).attribute29,
                            l_attributes (l_attribute_index).attribute30);

Line: 1284

		       'inserting REASON='|| x.comment_text || ' for x.detail_id= ' || x.detail_id
		      );

Line: 1309

                UPDATE hxc_tk_detail_temp
                SET    late_change = 'LATE',
                       old_late_change = 'LATE',
                       change_comment = NULL,
                       old_change_comment = NULL,
                       change_reason = NULL,
                       old_change_reason = NULL, --dhar
                       late_comment = l_attributes (l_attribute_index).attribute2,
                       old_late_comment = l_attributes (l_attribute_index).attribute2,
                       late_reason = l_attributes (l_attribute_index).attribute1,
                       old_late_reason = l_attributes (l_attribute_index).attribute1,
                       audit_datetime = l_attributes (l_attribute_index).attribute6,
                       old_audit_datetime = l_attributes (l_attribute_index).attribute6,
                       audit_history = l_attributes (l_attribute_index).attribute7,
                       old_audit_history = l_attributes (l_attribute_index).attribute7
                WHERE  detailid = x.detail_id;

Line: 1330

                UPDATE hxc_tk_detail_temp
                SET    late_change = 'CHANGE',
                       old_late_change = 'CHANGE',
                       late_comment = NULL,
                       old_late_comment = NULL,
                       late_reason = NULL,
                       old_late_reason = NULL, --dhar
                       change_comment = l_attributes (l_attribute_index).attribute2,
                       old_change_comment = l_attributes (l_attribute_index).attribute2,
                       change_reason = l_attributes (l_attribute_index).attribute1,
                       old_change_reason = l_attributes (l_attribute_index).attribute1,
                       audit_datetime = l_attributes (l_attribute_index).attribute6,
                       old_audit_datetime = l_attributes (l_attribute_index).attribute6,
                       audit_history = l_attributes (l_attribute_index).attribute7,
                       old_audit_history = l_attributes (l_attribute_index).attribute7
                WHERE  detailid = x.detail_id;

Line: 1349

                UPDATE hxc_tk_detail_temp
                SET    late_change = NULL,
                       old_late_change = NULL,
                       late_comment = NULL,
                       old_late_comment = NULL,
                       late_reason = NULL,
                       old_late_reason = NULL, --dhar
                       change_comment = l_attributes (l_attribute_index).attribute2,
                       old_change_comment = l_attributes (l_attribute_index).attribute2,
                       change_reason = l_attributes (l_attribute_index).attribute1,
                       old_change_reason = l_attributes (l_attribute_index).attribute1,
                       audit_datetime = l_attributes (l_attribute_index).attribute6,
                       old_audit_datetime = l_attributes (l_attribute_index).attribute6,
                       audit_history = l_attributes (l_attribute_index).attribute7,
                       old_audit_history = l_attributes (l_attribute_index).attribute7
                WHERE  detailid = x.detail_id;

Line: 1373

              ELSE -- no detailid --so insert
               IF (l_attributes (l_attribute_index).attribute3 = 'LATE') THEN
                if g_debug then
                        hr_utility.TRACE ('late reason');

Line: 1381

                INSERT INTO hxc_tk_detail_temp
                            (detailid, timecard_id, resource_id, comment_text, late_change, old_late_change,
                             late_reason,
                             late_comment, old_late_reason, old_late_comment, audit_datetime,
                             old_audit_datetime,
                             audit_history, old_audit_history)
                VALUES      (x.detail_id, l_timecard_id, p_resource_id, x.comment_text,
                             'LATE',
                             'LATE',
                             l_attributes (l_attribute_index).attribute1,
                             l_attributes (l_attribute_index).attribute2,
                             l_attributes (l_attribute_index).attribute1,
                             l_attributes (l_attribute_index).attribute2,
                             l_attributes (l_attribute_index).attribute6,
                             l_attributes (l_attribute_index).attribute6,
                             l_attributes (l_attribute_index).attribute7,
                             l_attributes (l_attribute_index).attribute7);

Line: 1401

                INSERT INTO hxc_tk_detail_temp
                            (detailid, timecard_id, resource_id, comment_text, late_change,old_late_change,
                             change_reason,
                             change_comment, old_change_reason, old_change_comment, audit_datetime,
                             old_audit_datetime,
                             audit_history, old_audit_history)
                VALUES      (x.detail_id, l_timecard_id, p_resource_id, x.comment_text,
                             'CHANGE','CHANGE',
                             l_attributes (l_attribute_index).attribute1,
                             l_attributes (l_attribute_index).attribute2,
                             l_attributes (l_attribute_index).attribute1,
                             l_attributes (l_attribute_index).attribute2,
                             l_attributes (l_attribute_index).attribute6,
                             l_attributes (l_attribute_index).attribute6,
                             l_attributes (l_attribute_index).attribute7,
                             l_attributes (l_attribute_index).attribute7);

Line: 1420

                INSERT INTO hxc_tk_detail_temp
                            (detailid, timecard_id, resource_id, comment_text, late_change,old_late_change,
                             change_reason,
                             change_comment, old_change_reason, old_change_comment, audit_datetime,
                             old_audit_datetime,
                             audit_history, old_audit_history)
                VALUES      (x.detail_id, l_timecard_id, p_resource_id, x.comment_text,
                             NULL,NULL,
                             l_attributes (l_attribute_index).attribute1,
                             l_attributes (l_attribute_index).attribute2,
                             l_attributes (l_attribute_index).attribute1,
                             l_attributes (l_attribute_index).attribute2,
                             l_attributes (l_attribute_index).attribute6,
                             l_attributes (l_attribute_index).attribute6,
                             l_attributes (l_attribute_index).attribute7,
                             l_attributes (l_attribute_index).attribute7);

Line: 1542

             l_detail_info_table.DELETE (t_base_table (t_base_index).base_id);

Line: 1972

              g_submit_table.DELETE (resource_info.person_id);

Line: 1978

             p_timekeeper_data (l_table_counter).last_update_date := l_last_update_date;

Line: 1979

             p_timekeeper_data (l_table_counter).last_updated_by := l_last_updated_by;

Line: 1980

             p_timekeeper_data (l_table_counter).last_update_login := l_last_update_login;

Line: 2060

               UPDATE hxc_tk_detail_temp
               SET    comment_text = l_detail_comment_text
               WHERE  detailid = l_detail_id AND timecard_id = l_timecard_id;

Line: 2064

               INSERT INTO hxc_tk_detail_temp
                           (detailid, timecard_id, comment_text)
               VALUES      (l_detail_id, l_timecard_id, l_detail_comment_text);

Line: 2324

            g_submit_table.DELETE (resource_info.person_id);

Line: 2341

           p_timekeeper_data (l_table_counter).last_update_date := l_last_update_date;

Line: 2342

           p_timekeeper_data (l_table_counter).last_updated_by := l_last_updated_by;

Line: 2343

           p_timekeeper_data (l_table_counter).last_update_login := l_last_update_login;

Line: 2403

              g_submit_table.DELETE (resource_info.person_id);

Line: 2416

             p_timekeeper_data (l_table_counter).last_update_date := l_last_update_date;

Line: 2417

             p_timekeeper_data (l_table_counter).last_updated_by := l_last_updated_by;

Line: 2418

             p_timekeeper_data (l_table_counter).last_update_login := l_last_update_login;

Line: 2458

               UPDATE hxc_tk_detail_temp
               SET    comment_text = l_detail_comment_text
               WHERE  detailid = l_detail_id AND timecard_id = l_timecard_id;

Line: 2462

               INSERT INTO hxc_tk_detail_temp
                           (detailid, timecard_id, comment_text)
               VALUES      (l_detail_id, l_timecard_id, l_detail_comment_text);

Line: 3018

              g_submit_table.DELETE (resource_info.person_id);

Line: 3185

             g_submit_table.DELETE (resource_info.person_id);

Line: 3209

     g_resource_tc_table.DELETE;

Line: 3304

    g_submit_table.DELETE (p_resource_id);

Line: 3330

   g_lock_table.DELETE (p_resource_id);

Line: 3372

  (p_insert_data IN OUT NOCOPY t_time_info)
 RETURN BOOLEAN IS

BEGIN
g_debug :=hr_utility.debug_enabled;

Line: 3379

	 hr_utility.trace('p_insert_data.timecard_end_period '||p_insert_data.timecard_end_period );

Line: 3380

	 hr_utility.trace('p_insert_data.resource_id     '||p_insert_data.resource_id     );

Line: 3381

	 hr_utility.trace('p_insert_data.employee_number '||p_insert_data.employee_number );

Line: 3382

	 hr_utility.trace('p_insert_data.employee_full_name     '||p_insert_data.employee_full_name     );

Line: 3383

	 hr_utility.trace('p_insert_data.timecard_id     '||p_insert_data.timecard_id     );

Line: 3384

	 hr_utility.trace('p_insert_data.timecard_ovn    '||p_insert_data.timecard_ovn    );

Line: 3385

	 hr_utility.trace('p_insert_data.check_box '||p_insert_data.check_box );

Line: 3386

	 hr_utility.trace('p_insert_data.error_status    '||p_insert_data.error_status    );

Line: 3387

	 hr_utility.trace('p_insert_data.timecard_status '||p_insert_data.timecard_status );

Line: 3388

	 hr_utility.trace('p_insert_data.timecard_status_code   '||p_insert_data.timecard_status_code   );

Line: 3389

	 hr_utility.trace('p_insert_data.attr_value_1    '||p_insert_data.attr_value_1    );

Line: 3390

	 hr_utility.trace('p_insert_data.attr_value_2    '||p_insert_data.attr_value_2    );

Line: 3391

	 hr_utility.trace('p_insert_data.attr_value_3    '||p_insert_data.attr_value_3    );

Line: 3392

	 hr_utility.trace('p_insert_data.attr_value_4    '||p_insert_data.attr_value_4    );

Line: 3393

	 hr_utility.trace('p_insert_data.attr_value_5    '||p_insert_data.attr_value_5    );

Line: 3394

	 hr_utility.trace('p_insert_data.attr_value_6    '||p_insert_data.attr_value_6    );

Line: 3395

	 hr_utility.trace('p_insert_data.attr_value_7    '||p_insert_data.attr_value_7    );

Line: 3396

	 hr_utility.trace('p_insert_data.attr_value_8    '||p_insert_data.attr_value_8    );

Line: 3397

	 hr_utility.trace('p_insert_data.attr_value_9    '||p_insert_data.attr_value_9    );

Line: 3398

	 hr_utility.trace('p_insert_data.attr_value_10   '||p_insert_data.attr_value_10   );

Line: 3399

	 hr_utility.trace('p_insert_data.attr_value_11   '||p_insert_data.attr_value_11   );

Line: 3400

	 hr_utility.trace('p_insert_data.attr_value_12   '||p_insert_data.attr_value_12   );

Line: 3401

	 hr_utility.trace('p_insert_data.attr_value_13   '||p_insert_data.attr_value_13   );

Line: 3402

	 hr_utility.trace('p_insert_data.attr_value_14   '||p_insert_data.attr_value_14   );

Line: 3403

	 hr_utility.trace('p_insert_data.attr_value_15   '||p_insert_data.attr_value_15   );

Line: 3404

	 hr_utility.trace('p_insert_data.attr_value_16   '||p_insert_data.attr_value_16   );

Line: 3405

	 hr_utility.trace('p_insert_data.attr_value_17   '||p_insert_data.attr_value_17   );

Line: 3406

	 hr_utility.trace('p_insert_data.attr_value_18   '||p_insert_data.attr_value_18   );

Line: 3407

	 hr_utility.trace('p_insert_data.attr_value_19   '||p_insert_data.attr_value_19   );

Line: 3408

	 hr_utility.trace('p_insert_data.attr_value_20   '||p_insert_data.attr_value_20   );

Line: 3409

	 hr_utility.trace('p_insert_data.attr_id_1 '||p_insert_data.attr_id_1 );

Line: 3410

	 hr_utility.trace('p_insert_data.attr_id_2 '||p_insert_data.attr_id_2 );

Line: 3411

	 hr_utility.trace('p_insert_data.attr_id_3 '||p_insert_data.attr_id_3 );

Line: 3412

	 hr_utility.trace('p_insert_data.attr_id_4 '||p_insert_data.attr_id_4 );

Line: 3413

	 hr_utility.trace('p_insert_data.attr_id_5 '||p_insert_data.attr_id_5 );

Line: 3414

	 hr_utility.trace('p_insert_data.attr_id_6 '||p_insert_data.attr_id_6 );

Line: 3415

	 hr_utility.trace('p_insert_data.attr_id_7 '||p_insert_data.attr_id_7 );

Line: 3416

	 hr_utility.trace('p_insert_data.attr_id_8 '||p_insert_data.attr_id_8 );

Line: 3417

	 hr_utility.trace('p_insert_data.attr_id_9 '||p_insert_data.attr_id_9 );

Line: 3418

	 hr_utility.trace('p_insert_data.attr_id_10      '||p_insert_data.attr_id_10      );

Line: 3419

	 hr_utility.trace('p_insert_data.attr_id_11      '||p_insert_data.attr_id_11      );

Line: 3420

	 hr_utility.trace('p_insert_data.attr_id_12      '||p_insert_data.attr_id_12      );

Line: 3421

	 hr_utility.trace('p_insert_data.attr_id_13      '||p_insert_data.attr_id_13      );

Line: 3422

	 hr_utility.trace('p_insert_data.attr_id_14      '||p_insert_data.attr_id_14      );

Line: 3423

	 hr_utility.trace('p_insert_data.attr_id_15      '||p_insert_data.attr_id_15      );

Line: 3424

	 hr_utility.trace('p_insert_data.attr_id_16      '||p_insert_data.attr_id_16      );

Line: 3425

	 hr_utility.trace('p_insert_data.attr_id_17      '||p_insert_data.attr_id_17      );

Line: 3426

	 hr_utility.trace('p_insert_data.attr_id_18      '||p_insert_data.attr_id_18      );

Line: 3427

	 hr_utility.trace('p_insert_data.attr_id_19      '||p_insert_data.attr_id_19      );

Line: 3428

	 hr_utility.trace('p_insert_data.attr_id_20      '||p_insert_data.attr_id_20      );

Line: 3429

	 hr_utility.trace('p_insert_data.attr_oldid_1    '||p_insert_data.attr_oldid_1    );

Line: 3430

	 hr_utility.trace('p_insert_data.attr_oldid_2    '||p_insert_data.attr_oldid_2    );

Line: 3431

	 hr_utility.trace('p_insert_data.attr_oldid_3    '||p_insert_data.attr_oldid_3    );

Line: 3432

	 hr_utility.trace('p_insert_data.attr_oldid_4    '||p_insert_data.attr_oldid_4    );

Line: 3433

	 hr_utility.trace('p_insert_data.attr_oldid_5    '||p_insert_data.attr_oldid_5    );

Line: 3434

	 hr_utility.trace('p_insert_data.attr_oldid_6    '||p_insert_data.attr_oldid_6    );

Line: 3435

	 hr_utility.trace('p_insert_data.attr_oldid_7    '||p_insert_data.attr_oldid_7    );

Line: 3436

	 hr_utility.trace('p_insert_data.attr_oldid_8    '||p_insert_data.attr_oldid_8    );

Line: 3437

	 hr_utility.trace('p_insert_data.attr_oldid_9    '||p_insert_data.attr_oldid_9    );

Line: 3438

	 hr_utility.trace('p_insert_data.attr_oldid_10   '||p_insert_data.attr_oldid_10   );

Line: 3439

	 hr_utility.trace('p_insert_data.attr_oldid_11   '||p_insert_data.attr_oldid_11   );

Line: 3440

	 hr_utility.trace('p_insert_data.attr_oldid_12   '||p_insert_data.attr_oldid_12   );

Line: 3441

	 hr_utility.trace('p_insert_data.attr_oldid_13   '||p_insert_data.attr_oldid_13   );

Line: 3442

	 hr_utility.trace('p_insert_data.attr_oldid_14   '||p_insert_data.attr_oldid_14   );

Line: 3443

	 hr_utility.trace('p_insert_data.attr_oldid_15   '||p_insert_data.attr_oldid_15   );

Line: 3444

	 hr_utility.trace('p_insert_data.attr_oldid_16   '||p_insert_data.attr_oldid_16   );

Line: 3445

	 hr_utility.trace('p_insert_data.attr_oldid_17   '||p_insert_data.attr_oldid_17   );

Line: 3446

	 hr_utility.trace('p_insert_data.attr_oldid_18   '||p_insert_data.attr_oldid_18   );

Line: 3447

	 hr_utility.trace('p_insert_data.attr_oldid_19   '||p_insert_data.attr_oldid_19   );

Line: 3448

	 hr_utility.trace('p_insert_data.attr_oldid_20   '||p_insert_data.attr_oldid_20   );

Line: 3449

	 hr_utility.trace('p_insert_data.timekeeper_action      '||p_insert_data.timekeeper_action      );

Line: 3450

	 hr_utility.trace('p_insert_data.detail_id_1     '||p_insert_data.detail_id_1     );

Line: 3451

	 hr_utility.trace('p_insert_data.detail_id_2     '||p_insert_data.detail_id_2     );

Line: 3452

	 hr_utility.trace('p_insert_data.detail_id_3     '||p_insert_data.detail_id_3     );

Line: 3453

	 hr_utility.trace('p_insert_data.detail_id_4     '||p_insert_data.detail_id_4     );

Line: 3454

	 hr_utility.trace('p_insert_data.detail_id_5     '||p_insert_data.detail_id_5     );

Line: 3455

	 hr_utility.trace('p_insert_data.detail_id_6     '||p_insert_data.detail_id_6     );

Line: 3456

	 hr_utility.trace('p_insert_data.detail_id_7     '||p_insert_data.detail_id_7     );

Line: 3457

	 hr_utility.trace('p_insert_data.detail_id_8     '||p_insert_data.detail_id_8     );

Line: 3458

	 hr_utility.trace('p_insert_data.detail_id_9     '||p_insert_data.detail_id_9     );

Line: 3459

	 hr_utility.trace('p_insert_data.detail_id_10    '||p_insert_data.detail_id_10    );

Line: 3460

	 hr_utility.trace('p_insert_data.detail_id_11    '||p_insert_data.detail_id_11    );

Line: 3461

	 hr_utility.trace('p_insert_data.detail_id_12    '||p_insert_data.detail_id_12    );

Line: 3462

	 hr_utility.trace('p_insert_data.detail_id_13    '||p_insert_data.detail_id_13    );

Line: 3463

	 hr_utility.trace('p_insert_data.detail_id_14    '||p_insert_data.detail_id_14    );

Line: 3464

	 hr_utility.trace('p_insert_data.detail_id_15    '||p_insert_data.detail_id_15    );

Line: 3465

	 hr_utility.trace('p_insert_data.detail_id_16    '||p_insert_data.detail_id_16    );

Line: 3466

	 hr_utility.trace('p_insert_data.detail_id_17    '||p_insert_data.detail_id_17    );

Line: 3467

	 hr_utility.trace('p_insert_data.detail_id_18    '||p_insert_data.detail_id_18    );

Line: 3468

	 hr_utility.trace('p_insert_data.detail_id_19    '||p_insert_data.detail_id_19    );

Line: 3469

	 hr_utility.trace('p_insert_data.detail_id_20    '||p_insert_data.detail_id_20    );

Line: 3470

	 hr_utility.trace('p_insert_data.detail_id_21    '||p_insert_data.detail_id_21    );

Line: 3471

	 hr_utility.trace('p_insert_data.detail_id_22    '||p_insert_data.detail_id_22    );

Line: 3472

	 hr_utility.trace('p_insert_data.detail_id_23    '||p_insert_data.detail_id_23    );

Line: 3473

	 hr_utility.trace('p_insert_data.detail_id_24    '||p_insert_data.detail_id_24    );

Line: 3474

	 hr_utility.trace('p_insert_data.detail_id_25    '||p_insert_data.detail_id_25    );

Line: 3475

	 hr_utility.trace('p_insert_data.detail_id_26    '||p_insert_data.detail_id_26    );

Line: 3476

	 hr_utility.trace('p_insert_data.detail_id_27    '||p_insert_data.detail_id_27    );

Line: 3477

	 hr_utility.trace('p_insert_data.detail_id_28    '||p_insert_data.detail_id_28    );

Line: 3478

	 hr_utility.trace('p_insert_data.detail_id_29    '||p_insert_data.detail_id_29    );

Line: 3479

	 hr_utility.trace('p_insert_data.detail_id_30    '||p_insert_data.detail_id_30    );

Line: 3480

	 hr_utility.trace('p_insert_data.detail_id_31    '||p_insert_data.detail_id_31    );

Line: 3481

	 hr_utility.trace('p_insert_data.detail_ovn_1    '||p_insert_data.detail_ovn_1    );

Line: 3482

	 hr_utility.trace('p_insert_data.detail_ovn_2    '||p_insert_data.detail_ovn_2    );

Line: 3483

	 hr_utility.trace('p_insert_data.detail_ovn_3    '||p_insert_data.detail_ovn_3    );

Line: 3484

	 hr_utility.trace('p_insert_data.detail_ovn_4    '||p_insert_data.detail_ovn_4    );

Line: 3485

	 hr_utility.trace('p_insert_data.detail_ovn_5    '||p_insert_data.detail_ovn_5    );

Line: 3486

	 hr_utility.trace('p_insert_data.detail_ovn_6    '||p_insert_data.detail_ovn_6    );

Line: 3487

	 hr_utility.trace('p_insert_data.detail_ovn_7    '||p_insert_data.detail_ovn_7    );

Line: 3488

	 hr_utility.trace('p_insert_data.detail_ovn_8    '||p_insert_data.detail_ovn_8    );

Line: 3489

	 hr_utility.trace('p_insert_data.detail_ovn_9    '||p_insert_data.detail_ovn_9    );

Line: 3490

	 hr_utility.trace('p_insert_data.detail_ovn_10   '||p_insert_data.detail_ovn_10   );

Line: 3491

	 hr_utility.trace('p_insert_data.detail_ovn_11   '||p_insert_data.detail_ovn_11   );

Line: 3492

	 hr_utility.trace('p_insert_data.detail_ovn_12   '||p_insert_data.detail_ovn_12   );

Line: 3493

	 hr_utility.trace('p_insert_data.detail_ovn_13   '||p_insert_data.detail_ovn_13   );

Line: 3494

	 hr_utility.trace('p_insert_data.detail_ovn_14   '||p_insert_data.detail_ovn_14   );

Line: 3495

	 hr_utility.trace('p_insert_data.detail_ovn_15   '||p_insert_data.detail_ovn_15   );

Line: 3496

	 hr_utility.trace('p_insert_data.detail_ovn_16   '||p_insert_data.detail_ovn_16   );

Line: 3497

	 hr_utility.trace('p_insert_data.detail_ovn_17   '||p_insert_data.detail_ovn_17   );

Line: 3498

	 hr_utility.trace('p_insert_data.detail_ovn_18   '||p_insert_data.detail_ovn_18   );

Line: 3499

	 hr_utility.trace('p_insert_data.detail_ovn_19   '||p_insert_data.detail_ovn_19   );

Line: 3500

	 hr_utility.trace('p_insert_data.detail_ovn_20   '||p_insert_data.detail_ovn_20   );

Line: 3501

	 hr_utility.trace('p_insert_data.detail_ovn_21   '||p_insert_data.detail_ovn_21   );

Line: 3502

	 hr_utility.trace('p_insert_data.detail_ovn_22   '||p_insert_data.detail_ovn_22   );

Line: 3503

	 hr_utility.trace('p_insert_data.detail_ovn_23   '||p_insert_data.detail_ovn_23   );

Line: 3504

	 hr_utility.trace('p_insert_data.detail_ovn_24   '||p_insert_data.detail_ovn_24   );

Line: 3505

	 hr_utility.trace('p_insert_data.detail_ovn_25   '||p_insert_data.detail_ovn_25   );

Line: 3506

	 hr_utility.trace('p_insert_data.detail_ovn_26   '||p_insert_data.detail_ovn_26   );

Line: 3507

	 hr_utility.trace('p_insert_data.detail_ovn_27   '||p_insert_data.detail_ovn_27   );

Line: 3508

	 hr_utility.trace('p_insert_data.detail_ovn_28   '||p_insert_data.detail_ovn_28   );

Line: 3509

	 hr_utility.trace('p_insert_data.detail_ovn_29   '||p_insert_data.detail_ovn_29   );

Line: 3510

	 hr_utility.trace('p_insert_data.detail_ovn_30   '||p_insert_data.detail_ovn_30   );

Line: 3511

	 hr_utility.trace('p_insert_data.detail_ovn_31   '||p_insert_data.detail_ovn_31   );

Line: 3512

	 hr_utility.trace('p_insert_data.day_1    '||p_insert_data.day_1    );

Line: 3513

	 hr_utility.trace('p_insert_data.day_2    '||p_insert_data.day_2    );

Line: 3514

	 hr_utility.trace('p_insert_data.day_3    '||p_insert_data.day_3    );

Line: 3515

	 hr_utility.trace('p_insert_data.day_4    '||p_insert_data.day_4    );

Line: 3516

	 hr_utility.trace('p_insert_data.day_5    '||p_insert_data.day_5    );

Line: 3517

	 hr_utility.trace('p_insert_data.day_6    '||p_insert_data.day_6    );

Line: 3518

	 hr_utility.trace('p_insert_data.day_7    '||p_insert_data.day_7    );

Line: 3519

	 hr_utility.trace('p_insert_data.day_8    '||p_insert_data.day_8    );

Line: 3520

	 hr_utility.trace('p_insert_data.day_9    '||p_insert_data.day_9    );

Line: 3521

	 hr_utility.trace('p_insert_data.day_10   '||p_insert_data.day_10   );

Line: 3522

	 hr_utility.trace('p_insert_data.day_11   '||p_insert_data.day_11   );

Line: 3523

	 hr_utility.trace('p_insert_data.day_12   '||p_insert_data.day_12   );

Line: 3524

	   hr_utility.trace('p_insert_data.day_13   '||p_insert_data.day_13   );

Line: 3525

	   hr_utility.trace('p_insert_data.day_14   '||p_insert_data.day_14   );

Line: 3526

	   hr_utility.trace('p_insert_data.day_15   '||p_insert_data.day_15   );

Line: 3527

	   hr_utility.trace('p_insert_data.day_16   '||p_insert_data.day_16   );

Line: 3528

	   hr_utility.trace('p_insert_data.day_17   '||p_insert_data.day_17   );

Line: 3529

	   hr_utility.trace('p_insert_data.day_18   '||p_insert_data.day_18   );

Line: 3530

	   hr_utility.trace('p_insert_data.day_19   '||p_insert_data.day_19   );

Line: 3531

	   hr_utility.trace('p_insert_data.day_20   '||p_insert_data.day_20   );

Line: 3532

	   hr_utility.trace('p_insert_data.day_21   '||p_insert_data.day_21   );

Line: 3533

	   hr_utility.trace('p_insert_data.day_22   '||p_insert_data.day_22   );

Line: 3534

	   hr_utility.trace('p_insert_data.day_23   '||p_insert_data.day_23   );

Line: 3535

	   hr_utility.trace('p_insert_data.day_24   '||p_insert_data.day_24   );

Line: 3536

	   hr_utility.trace('p_insert_data.day_25   '||p_insert_data.day_25   );

Line: 3537

	   hr_utility.trace('p_insert_data.day_26   '||p_insert_data.day_26   );

Line: 3538

	   hr_utility.trace('p_insert_data.day_27   '||p_insert_data.day_27   );

Line: 3539

	   hr_utility.trace('p_insert_data.day_28   '||p_insert_data.day_28   );

Line: 3540

	   hr_utility.trace('p_insert_data.day_29   '||p_insert_data.day_29   );

Line: 3541

	   hr_utility.trace('p_insert_data.day_30   '||p_insert_data.day_30   );

Line: 3542

	   hr_utility.trace('p_insert_data.day_31   '||p_insert_data.day_31   );

Line: 3543

	   hr_utility.trace('p_insert_data.time_in_1 '||p_insert_data.time_in_1 );

Line: 3544

	   hr_utility.trace('p_insert_data.time_out_1      '||p_insert_data.time_out_1      );

Line: 3545

	   hr_utility.trace('p_insert_data.time_in_2 '||p_insert_data.time_in_2 );

Line: 3546

	   hr_utility.trace('p_insert_data.time_out_2      '||p_insert_data.time_out_2      );

Line: 3547

	   hr_utility.trace('p_insert_data.time_in_3 '||p_insert_data.time_in_3 );

Line: 3548

	   hr_utility.trace('p_insert_data.time_out_3      '||p_insert_data.time_out_3      );

Line: 3549

	   hr_utility.trace('p_insert_data.time_in_4 '||p_insert_data.time_in_4 );

Line: 3550

	   hr_utility.trace('p_insert_data.time_out_4      '||p_insert_data.time_out_4      );

Line: 3551

	   hr_utility.trace('p_insert_data.time_in_5 '||p_insert_data.time_in_5 );

Line: 3552

	   hr_utility.trace('p_insert_data.time_out_5      '||p_insert_data.time_out_5      );

Line: 3553

	   hr_utility.trace('p_insert_data.time_in_6 '||p_insert_data.time_in_6 );

Line: 3554

	   hr_utility.trace('p_insert_data.time_out_6      '||p_insert_data.time_out_6      );

Line: 3555

	   hr_utility.trace('p_insert_data.time_in_7 '||p_insert_data.time_in_7 );

Line: 3556

	   hr_utility.trace('p_insert_data.time_out_7      '||p_insert_data.time_out_7      );

Line: 3557

	   hr_utility.trace('p_insert_data.time_in_8 '||p_insert_data.time_in_8 );

Line: 3558

	   hr_utility.trace('p_insert_data.time_out_8      '||p_insert_data.time_out_8      );

Line: 3559

	   hr_utility.trace('p_insert_data.time_in_9 '||p_insert_data.time_in_9 );

Line: 3560

	   hr_utility.trace('p_insert_data.time_out_9      '||p_insert_data.time_out_9      );

Line: 3561

	   hr_utility.trace('p_insert_data.time_in_10      '||p_insert_data.time_in_10      );

Line: 3562

	   hr_utility.trace('p_insert_data.time_out_10     '||p_insert_data.time_out_10     );

Line: 3563

	   hr_utility.trace('p_insert_data.time_in_11      '||p_insert_data.time_in_11      );

Line: 3564

	   hr_utility.trace('p_insert_data.time_out_11     '||p_insert_data.time_out_11     );

Line: 3565

	   hr_utility.trace('p_insert_data.time_in_12      '||p_insert_data.time_in_12      );

Line: 3566

	   hr_utility.trace('p_insert_data.time_out_12     '||p_insert_data.time_out_12     );

Line: 3567

	   hr_utility.trace('p_insert_data.time_in_13      '||p_insert_data.time_in_13      );

Line: 3568

	   hr_utility.trace('p_insert_data.time_out_13     '||p_insert_data.time_out_13     );

Line: 3569

	   hr_utility.trace('p_insert_data.time_in_14      '||p_insert_data.time_in_14      );

Line: 3570

	   hr_utility.trace('p_insert_data.time_out_14     '||p_insert_data.time_out_14     );

Line: 3571

	   hr_utility.trace('p_insert_data.time_in_15      '||p_insert_data.time_in_15      );

Line: 3572

	   hr_utility.trace('p_insert_data.time_out_15     '||p_insert_data.time_out_15     );

Line: 3573

	   hr_utility.trace('p_insert_data.time_in_16      '||p_insert_data.time_in_16      );

Line: 3574

	   hr_utility.trace('p_insert_data.time_out_16     '||p_insert_data.time_out_16     );

Line: 3575

	   hr_utility.trace('p_insert_data.time_in_17      '||p_insert_data.time_in_17      );

Line: 3576

	   hr_utility.trace('p_insert_data.time_out_17     '||p_insert_data.time_out_17     );

Line: 3577

	   hr_utility.trace('p_insert_data.time_in_18      '||p_insert_data.time_in_18      );

Line: 3578

	   hr_utility.trace('p_insert_data.time_out_18     '||p_insert_data.time_out_18     );

Line: 3579

	   hr_utility.trace('p_insert_data.time_in_19      '||p_insert_data.time_in_19      );

Line: 3580

	   hr_utility.trace('p_insert_data.time_out_19     '||p_insert_data.time_out_19     );

Line: 3581

	   hr_utility.trace('p_insert_data.time_in_20      '||p_insert_data.time_in_20      );

Line: 3582

	   hr_utility.trace('p_insert_data.time_out_20     '||p_insert_data.time_out_20     );

Line: 3583

	   hr_utility.trace('p_insert_data.time_in_21      '||p_insert_data.time_in_21      );

Line: 3584

	   hr_utility.trace('p_insert_data.time_out_21     '||p_insert_data.time_out_21     );

Line: 3585

	   hr_utility.trace('p_insert_data.time_in_22      '||p_insert_data.time_in_22      );

Line: 3586

	   hr_utility.trace('p_insert_data.time_out_22     '||p_insert_data.time_out_22     );

Line: 3587

	   hr_utility.trace('p_insert_data.time_in_23      '||p_insert_data.time_in_23      );

Line: 3588

	   hr_utility.trace('p_insert_data.time_out_23     '||p_insert_data.time_out_23     );

Line: 3589

	   hr_utility.trace('p_insert_data.time_in_24      '||p_insert_data.time_in_24      );

Line: 3590

	   hr_utility.trace('p_insert_data.time_out_24     '||p_insert_data.time_out_24     );

Line: 3591

	   hr_utility.trace('p_insert_data.time_in_25      '||p_insert_data.time_in_25      );

Line: 3592

	   hr_utility.trace('p_insert_data.time_out_25     '||p_insert_data.time_out_25     );

Line: 3593

	   hr_utility.trace('p_insert_data.time_in_26      '||p_insert_data.time_in_26      );

Line: 3594

	   hr_utility.trace('p_insert_data.time_out_26     '||p_insert_data.time_out_26     );

Line: 3595

	   hr_utility.trace('p_insert_data.time_in_27      '||p_insert_data.time_in_27      );

Line: 3596

	   hr_utility.trace('p_insert_data.time_out_27     '||p_insert_data.time_out_27     );

Line: 3597

	   hr_utility.trace('p_insert_data.time_in_28      '||p_insert_data.time_in_28      );

Line: 3598

	   hr_utility.trace('p_insert_data.time_out_28     '||p_insert_data.time_out_28     );

Line: 3599

	   hr_utility.trace('p_insert_data.time_in_29      '||p_insert_data.time_in_29      );

Line: 3600

	   hr_utility.trace('p_insert_data.time_out_29     '||p_insert_data.time_out_29     );

Line: 3601

	   hr_utility.trace('p_insert_data.time_in_30      '||p_insert_data.time_in_30      );

Line: 3602

	   hr_utility.trace('p_insert_data.time_out_30     '||p_insert_data.time_out_30     );

Line: 3603

	   hr_utility.trace('p_insert_data.time_in_31      '||p_insert_data.time_in_31      );

Line: 3604

	   hr_utility.trace('p_insert_data.time_out_31     '||p_insert_data.time_out_31     );

Line: 3605

	 hr_utility.trace('p_insert_data.comment_text    '||p_insert_data.comment_text    );

Line: 3606

	   hr_utility.trace('p_insert_data.last_update_date '||p_insert_data.last_update_date );

Line: 3607

	 hr_utility.trace('p_insert_data.last_updated_by '||p_insert_data.last_updated_by );

Line: 3608

	 hr_utility.trace('p_insert_data.last_update_login      '||p_insert_data.last_update_login      );

Line: 3609

	 hr_utility.trace('p_insert_data.created_by      '||p_insert_data.created_by      );

Line: 3610

	   hr_utility.trace('p_insert_data.creation_date   '||p_insert_data.creation_date   );

Line: 3611

	 hr_utility.trace('p_insert_data.row_lock_id     '||p_insert_data.row_lock_id     );

Line: 3612

	 hr_utility.trace('p_insert_data.tc_lock_success '||p_insert_data.tc_lock_success );

Line: 3613

	 hr_utility.trace('p_insert_data.person_type     '||p_insert_data.person_type     );

Line: 3614

	 hr_utility.trace('p_insert_data.timecard_message '||p_insert_data.timecard_message );

Line: 3615

	 hr_utility.trace('p_insert_data.timecard_message_code  '||p_insert_data.timecard_message_code  );

Line: 3616

	 hr_utility.trace('p_insert_data.audit_enabled '||p_insert_data.audit_enabled );

Line: 3620

  IF    p_insert_data.timecard_start_period is not null OR
 p_insert_data.timecard_end_period is not null OR
-- p_insert_data.resource_id     IS NOT NULL OR
-- p_insert_data.employee_number IS NOT NULL OR
-- p_insert_data.employee_full_name     IS NOT NULL OR
 p_insert_data.timecard_id     IS NOT NULL OR
 p_insert_data.timecard_ovn    IS NOT NULL OR
 --p_insert_data.check_box IS NOT NULL OR
 p_insert_data.error_status    IS NOT NULL OR
 p_insert_data.timecard_status IS NOT NULL OR
 p_insert_data.timecard_status_code   IS NOT NULL OR
 p_insert_data.attr_value_1    IS NOT NULL OR
 p_insert_data.attr_value_2    IS NOT NULL OR
 p_insert_data.attr_value_3    IS NOT NULL OR
 p_insert_data.attr_value_4    IS NOT NULL OR
 p_insert_data.attr_value_5    IS NOT NULL OR
 p_insert_data.attr_value_6    IS NOT NULL OR
 p_insert_data.attr_value_7    IS NOT NULL OR
 p_insert_data.attr_value_8    IS NOT NULL OR
 p_insert_data.attr_value_9    IS NOT NULL OR
 p_insert_data.attr_value_10   IS NOT NULL OR
 p_insert_data.attr_value_11   IS NOT NULL OR
 p_insert_data.attr_value_12   IS NOT NULL OR
 p_insert_data.attr_value_13   IS NOT NULL OR
 p_insert_data.attr_value_14   IS NOT NULL OR
 p_insert_data.attr_value_15   IS NOT NULL OR
 p_insert_data.attr_value_16   IS NOT NULL OR
 p_insert_data.attr_value_17   IS NOT NULL OR
 p_insert_data.attr_value_18   IS NOT NULL OR
 p_insert_data.attr_value_19   IS NOT NULL OR
 p_insert_data.attr_value_20   IS NOT NULL OR
 p_insert_data.attr_id_1 IS NOT NULL OR
 p_insert_data.attr_id_2 IS NOT NULL OR
 p_insert_data.attr_id_3 IS NOT NULL OR
 p_insert_data.attr_id_4 IS NOT NULL OR
 p_insert_data.attr_id_5 IS NOT NULL OR
 p_insert_data.attr_id_6 IS NOT NULL OR
 p_insert_data.attr_id_7 IS NOT NULL OR
 p_insert_data.attr_id_8 IS NOT NULL OR
 p_insert_data.attr_id_9 IS NOT NULL OR
 p_insert_data.attr_id_10      IS NOT NULL OR
 p_insert_data.attr_id_11      IS NOT NULL OR
 p_insert_data.attr_id_12      IS NOT NULL OR
 p_insert_data.attr_id_13      IS NOT NULL OR
 p_insert_data.attr_id_14      IS NOT NULL OR
 p_insert_data.attr_id_15      IS NOT NULL OR
 p_insert_data.attr_id_16      IS NOT NULL OR
 p_insert_data.attr_id_17      IS NOT NULL OR
 p_insert_data.attr_id_18      IS NOT NULL OR
 p_insert_data.attr_id_19      IS NOT NULL OR
 p_insert_data.attr_id_20      IS NOT NULL OR
 p_insert_data.attr_oldid_1    IS NOT NULL OR
 p_insert_data.attr_oldid_2    IS NOT NULL OR
 p_insert_data.attr_oldid_3    IS NOT NULL OR
 p_insert_data.attr_oldid_4    IS NOT NULL OR
 p_insert_data.attr_oldid_5    IS NOT NULL OR
 p_insert_data.attr_oldid_6    IS NOT NULL OR
 p_insert_data.attr_oldid_7    IS NOT NULL OR
 p_insert_data.attr_oldid_8    IS NOT NULL OR
 p_insert_data.attr_oldid_9    IS NOT NULL OR
 p_insert_data.attr_oldid_10   IS NOT NULL OR
 p_insert_data.attr_oldid_11   IS NOT NULL OR
 p_insert_data.attr_oldid_12   IS NOT NULL OR
 p_insert_data.attr_oldid_13   IS NOT NULL OR
 p_insert_data.attr_oldid_14   IS NOT NULL OR
 p_insert_data.attr_oldid_15   IS NOT NULL OR
 p_insert_data.attr_oldid_16   IS NOT NULL OR
 p_insert_data.attr_oldid_17   IS NOT NULL OR
 p_insert_data.attr_oldid_18   IS NOT NULL OR
 p_insert_data.attr_oldid_19   IS NOT NULL OR
 p_insert_data.attr_oldid_20   IS NOT NULL OR
 p_insert_data.timekeeper_action      IS NOT NULL OR
   p_insert_data.detail_id_1     IS NOT NULL OR
   p_insert_data.detail_id_2     IS NOT NULL OR
   p_insert_data.detail_id_3     IS NOT NULL OR
   p_insert_data.detail_id_4     IS NOT NULL OR
   p_insert_data.detail_id_5     IS NOT NULL OR
   p_insert_data.detail_id_6     IS NOT NULL OR
   p_insert_data.detail_id_7     IS NOT NULL OR
   p_insert_data.detail_id_8     IS NOT NULL OR
   p_insert_data.detail_id_9     IS NOT NULL OR
   p_insert_data.detail_id_10    IS NOT NULL OR
   p_insert_data.detail_id_11    IS NOT NULL OR
   p_insert_data.detail_id_12    IS NOT NULL OR
   p_insert_data.detail_id_13    IS NOT NULL OR
   p_insert_data.detail_id_14    IS NOT NULL OR
   p_insert_data.detail_id_15    IS NOT NULL OR
   p_insert_data.detail_id_16    IS NOT NULL OR
   p_insert_data.detail_id_17    IS NOT NULL OR
   p_insert_data.detail_id_18    IS NOT NULL OR
   p_insert_data.detail_id_19    IS NOT NULL OR
   p_insert_data.detail_id_20    IS NOT NULL OR
   p_insert_data.detail_id_21    IS NOT NULL OR
   p_insert_data.detail_id_22    IS NOT NULL OR
   p_insert_data.detail_id_23    IS NOT NULL OR
   p_insert_data.detail_id_24    IS NOT NULL OR
   p_insert_data.detail_id_25    IS NOT NULL OR
   p_insert_data.detail_id_26    IS NOT NULL OR
   p_insert_data.detail_id_27    IS NOT NULL OR
   p_insert_data.detail_id_28    IS NOT NULL OR
   p_insert_data.detail_id_29    IS NOT NULL OR
   p_insert_data.detail_id_30    IS NOT NULL OR
   p_insert_data.detail_id_31    IS NOT NULL OR
   p_insert_data.detail_ovn_1    IS NOT NULL OR
   p_insert_data.detail_ovn_2    IS NOT NULL OR
   p_insert_data.detail_ovn_3    IS NOT NULL OR
   p_insert_data.detail_ovn_4    IS NOT NULL OR
   p_insert_data.detail_ovn_5    IS NOT NULL OR
   p_insert_data.detail_ovn_6    IS NOT NULL OR
   p_insert_data.detail_ovn_7    IS NOT NULL OR
   p_insert_data.detail_ovn_8    IS NOT NULL OR
   p_insert_data.detail_ovn_9    IS NOT NULL OR
   p_insert_data.detail_ovn_10   IS NOT NULL OR
   p_insert_data.detail_ovn_11   IS NOT NULL OR
   p_insert_data.detail_ovn_12   IS NOT NULL OR
   p_insert_data.detail_ovn_13   IS NOT NULL OR
   p_insert_data.detail_ovn_14   IS NOT NULL OR
   p_insert_data.detail_ovn_15   IS NOT NULL OR
   p_insert_data.detail_ovn_16   IS NOT NULL OR
   p_insert_data.detail_ovn_17   IS NOT NULL OR
   p_insert_data.detail_ovn_18   IS NOT NULL OR
   p_insert_data.detail_ovn_19   IS NOT NULL OR
   p_insert_data.detail_ovn_20   IS NOT NULL OR
   p_insert_data.detail_ovn_21   IS NOT NULL OR
   p_insert_data.detail_ovn_22   IS NOT NULL OR
   p_insert_data.detail_ovn_23   IS NOT NULL OR
   p_insert_data.detail_ovn_24   IS NOT NULL OR
   p_insert_data.detail_ovn_25   IS NOT NULL OR
   p_insert_data.detail_ovn_26   IS NOT NULL OR
   p_insert_data.detail_ovn_27   IS NOT NULL OR
   p_insert_data.detail_ovn_28   IS NOT NULL OR
   p_insert_data.detail_ovn_29   IS NOT NULL OR
   p_insert_data.detail_ovn_30   IS NOT NULL OR
   p_insert_data.detail_ovn_31   IS NOT NULL OR
   p_insert_data.day_1    IS NOT NULL OR
   p_insert_data.day_2    IS NOT NULL OR
   p_insert_data.day_3    IS NOT NULL OR
   p_insert_data.day_4    IS NOT NULL OR
   p_insert_data.day_5    IS NOT NULL OR
   p_insert_data.day_6    IS NOT NULL OR
   p_insert_data.day_7    IS NOT NULL OR
   p_insert_data.day_8    IS NOT NULL OR
   p_insert_data.day_9    IS NOT NULL OR
   p_insert_data.day_10   IS NOT NULL OR
   p_insert_data.day_11   IS NOT NULL OR
   p_insert_data.day_12   IS NOT NULL OR
   p_insert_data.day_13   IS NOT NULL OR
   p_insert_data.day_14   IS NOT NULL OR
   p_insert_data.day_15   IS NOT NULL OR
   p_insert_data.day_16   IS NOT NULL OR
   p_insert_data.day_17   IS NOT NULL OR
   p_insert_data.day_18   IS NOT NULL OR
   p_insert_data.day_19   IS NOT NULL OR
   p_insert_data.day_20   IS NOT NULL OR
   p_insert_data.day_21   IS NOT NULL OR
   p_insert_data.day_22   IS NOT NULL OR
   p_insert_data.day_23   IS NOT NULL OR
   p_insert_data.day_24   IS NOT NULL OR
   p_insert_data.day_25   IS NOT NULL OR
   p_insert_data.day_26   IS NOT NULL OR
   p_insert_data.day_27   IS NOT NULL OR
   p_insert_data.day_28   IS NOT NULL OR
   p_insert_data.day_29   IS NOT NULL OR
   p_insert_data.day_30   IS NOT NULL OR
   p_insert_data.day_31   IS NOT NULL OR
   p_insert_data.time_in_1 IS NOT NULL OR
   p_insert_data.time_out_1      IS NOT NULL OR
   p_insert_data.time_in_2 IS NOT NULL OR
   p_insert_data.time_out_2      IS NOT NULL OR
   p_insert_data.time_in_3 IS NOT NULL OR
   p_insert_data.time_out_3      IS NOT NULL OR
   p_insert_data.time_in_4 IS NOT NULL OR
   p_insert_data.time_out_4      IS NOT NULL OR
   p_insert_data.time_in_5 IS NOT NULL OR
   p_insert_data.time_out_5      IS NOT NULL OR
   p_insert_data.time_in_6 IS NOT NULL OR
   p_insert_data.time_out_6      IS NOT NULL OR
   p_insert_data.time_in_7 IS NOT NULL OR
   p_insert_data.time_out_7      IS NOT NULL OR
   p_insert_data.time_in_8 IS NOT NULL OR
   p_insert_data.time_out_8      IS NOT NULL OR
   p_insert_data.time_in_9 IS NOT NULL OR
   p_insert_data.time_out_9      IS NOT NULL OR
   p_insert_data.time_in_10      IS NOT NULL OR
   p_insert_data.time_out_10     IS NOT NULL OR
   p_insert_data.time_in_11      IS NOT NULL OR
   p_insert_data.time_out_11     IS NOT NULL OR
   p_insert_data.time_in_12      IS NOT NULL OR
   p_insert_data.time_out_12     IS NOT NULL OR
   p_insert_data.time_in_13      IS NOT NULL OR
   p_insert_data.time_out_13     IS NOT NULL OR
   p_insert_data.time_in_14      IS NOT NULL OR
   p_insert_data.time_out_14     IS NOT NULL OR
   p_insert_data.time_in_15      IS NOT NULL OR
   p_insert_data.time_out_15     IS NOT NULL OR
   p_insert_data.time_in_16      IS NOT NULL OR
   p_insert_data.time_out_16     IS NOT NULL OR
   p_insert_data.time_in_17      IS NOT NULL OR
   p_insert_data.time_out_17     IS NOT NULL OR
   p_insert_data.time_in_18      IS NOT NULL OR
   p_insert_data.time_out_18     IS NOT NULL OR
   p_insert_data.time_in_19      IS NOT NULL OR
   p_insert_data.time_out_19     IS NOT NULL OR
   p_insert_data.time_in_20      IS NOT NULL OR
   p_insert_data.time_out_20     IS NOT NULL OR
   p_insert_data.time_in_21      IS NOT NULL OR
   p_insert_data.time_out_21     IS NOT NULL OR
   p_insert_data.time_in_22      IS NOT NULL OR
   p_insert_data.time_out_22     IS NOT NULL OR
   p_insert_data.time_in_23      IS NOT NULL OR
   p_insert_data.time_out_23     IS NOT NULL OR
   p_insert_data.time_in_24      IS NOT NULL OR
   p_insert_data.time_out_24     IS NOT NULL OR
   p_insert_data.time_in_25      IS NOT NULL OR
   p_insert_data.time_out_25     IS NOT NULL OR
   p_insert_data.time_in_26      IS NOT NULL OR
   p_insert_data.time_out_26     IS NOT NULL OR
   p_insert_data.time_in_27      IS NOT NULL OR
   p_insert_data.time_out_27     IS NOT NULL OR
   p_insert_data.time_in_28      IS NOT NULL OR
   p_insert_data.time_out_28     IS NOT NULL OR
   p_insert_data.time_in_29      IS NOT NULL OR
   p_insert_data.time_out_29     IS NOT NULL OR
   p_insert_data.time_in_30      IS NOT NULL OR
   p_insert_data.time_out_30     IS NOT NULL OR
   p_insert_data.time_in_31      IS NOT NULL OR
   p_insert_data.time_out_31     IS NOT NULL OR
 p_insert_data.comment_text    IS NOT NULL OR
   p_insert_data.last_update_date IS NOT NULL OR
 p_insert_data.last_updated_by IS NOT NULL OR
 p_insert_data.last_update_login      IS NOT NULL OR
 p_insert_data.created_by      IS NOT NULL OR
   p_insert_data.creation_date   IS NOT NULL OR
 --p_insert_data.row_lock_id     IS NOT NULL OR
 p_insert_data.tc_lock_success IS NOT NULL OR
-- p_insert_data.person_type     IS NOT NULL OR
 p_insert_data.timecard_message IS NOT NULL OR
 p_insert_data.timecard_message_code  IS NOT NULL
 --p_insert_data.audit_enabled   IS NOT NULL
THEN
if g_debug then
        hr_utility.trace(' found data');

Line: 3882

 PROCEDURE timekeeper_insert (
  p_insert_data IN OUT NOCOPY t_timekeeper_table
 ) IS

 l_index	NUMBER;

Line: 3890

  l_index := p_insert_data.FIRST;

Line: 3893

   EXIT WHEN (NOT p_insert_data.EXISTS (l_index));

Line: 3894

    IF not_empty_row(p_insert_data(l_index))
    THEN
     populate_global_table (p_table_data => p_insert_data(l_index), p_action => 'INSERT');

Line: 3898

    l_index := p_insert_data.NEXT (l_index);

Line: 3901

 END timekeeper_insert;

Line: 3910

 PROCEDURE timekeeper_update (
  p_update_data IN OUT NOCOPY t_timekeeper_table
 ) IS

 l_index	NUMBER;

Line: 3918

  l_index := p_update_data.FIRST;

Line: 3921

   EXIT WHEN (NOT p_update_data.EXISTS (l_index));

Line: 3922

     IF not_empty_row(p_update_data(l_index))
     THEN
      populate_global_table (p_table_data => p_update_data(l_index), p_action => 'UPDATE');

Line: 3926

     l_index := p_update_data.NEXT (l_index);

Line: 3929

 END timekeeper_update;

Line: 3936

 PROCEDURE timekeeper_delete (
  p_delete_data IN OUT NOCOPY t_timekeeper_table
 ) IS

 l_index	NUMBER;

Line: 3944

  l_index := p_delete_data.FIRST;

Line: 3947

   EXIT WHEN (NOT p_delete_data.EXISTS (l_index));

Line: 3948

    IF not_empty_row(p_delete_data(l_index))
    THEN
     populate_global_table (p_table_data => p_delete_data(l_index), p_action => 'DELETE');

Line: 3952

    l_index := p_delete_data.NEXT (l_index);

Line: 3955

 END timekeeper_delete;

Line: 4028

  g_detail_data.DELETE;

Line: 4035

   PROCEDURE timekeeper_data_delete IS
  BEGIN
    g_timekeeper_data.delete;

Line: 4093

   SELECT time_building_block_id, object_version_number, comment_text
   FROM   hxc_time_building_blocks
   WHERE  SCOPE = 'TIMECARD'
AND       date_to = hr_general.end_of_time
AND       resource_id = p_resource_id
AND       start_time = p_start_period
AND       stop_time = p_end_period;

Line: 4108

   SELECT '1'
   FROM   hxc_time_building_blocks detail, hxc_time_building_blocks DAY
   WHERE  DAY.SCOPE = 'DAY'
AND       DAY.resource_id = p_resource_id
AND       DAY.parent_building_block_id = p_timecard_id
AND       DAY.parent_building_block_ovn = p_timecard_ovn
AND       DAY.time_building_block_id = detail.parent_building_block_id
AND       DAY.object_version_number = detail.parent_building_block_ovn
AND       detail.SCOPE = 'DETAIL'
AND       detail.resource_id = p_resource_id;

Line: 4124

	  SELECT final_process_date, date_start
	  FROM per_periods_of_service
	  WHERE person_id = p_resource_id
	  union all
	  select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
  	from per_periods_of_placement
  	where person_id = p_resource_id
	  ORDER BY date_start DESC;

Line: 4138

        SELECT 'Y'
        from hxc_time_building_blocks
        where resource_id=p_resource_id
        and scope='TIMECARD'
        and trunc(start_time)=trunc(p_start_date)
        and trunc(stop_time)=trunc(p_end_date)
        and (trunc(date_to) = hr_general.end_of_time or APPROVAL_STATUS='ERROR');

Line: 4204

  l_delete                    BOOLEAN;

Line: 4271

  g_mid_data.DELETE;

Line: 4301

  att_seg_tab.DELETE;

Line: 4367

     l_timecard.DELETE;

Line: 4368

     l_attributes.DELETE;

Line: 4432

       p_insert_detail => g_timekeeper_data (l_result),
       p_timecard => l_timecard,
       p_attributes => l_attributes,
       p_day_id_info_table => l_day_id_info_table,
       p_approval_style_id => l_approval_style_id,
       p_attribute_index_info => l_attribute_index_info,
       p_timecard_index_info => l_timecard_index_info,
       p_timecard_id => l_timecard_id,
       p_mid_save => l_mid_save,
       p_comment_made_null => l_comment_made_null,
       p_row_lock_id => l_row_locked_id,
       p_tk_audit_enabled => p_tk_audit_enabled
      );

Line: 4454

     l_delete := TRUE;

Line: 4461

        l_delete := FALSE;

Line: 4471

        l_delete := FALSE;

Line: 4490

     IF (l_delete) THEN
      l_messages.DELETE;

Line: 4494

       l_timecard.DELETE;

Line: 4495

       l_attributes.DELETE;

Line: 4498

       hxc_timekeeper.delete_timecard (p_timecard_id => l_timecard_id, p_messages => l_messages);

Line: 4503

      l_messages.DELETE;

Line: 4547

  g_timekeeper_data.DELETE;

Line: 4562

  l_new_tk_data_from_process.DELETE;

Line: 4574

   l_timekeeper_table.DELETE;

Line: 4690

       l_new_tk_data_from_process.DELETE (l_new_tk_data_index);

Line: 4705

     g_submit_table.DELETE (l_resource_id);

Line: 4782

  p_insert OUT NOCOPY BOOLEAN,
  p_submit_emp OUT NOCOPY hxc_timekeeper_process.tk_submit_tab,
  p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
 ) IS
  CURSOR crs_max_submit IS
   SELECT MAX (submission_id)
   FROM   hxc_tk_timekeeper_submits;

Line: 4813

  SELECT hxc_tk_timekeeper_submits_s.NEXTVAL
  INTO   l_next_val
  FROM   DUAL;

Line: 4823

  p_insert := FALSE;

Line: 4832

   p_insert := TRUE;

Line: 4873

  g_submit_table.DELETE;

Line: 4895

   SELECT DISTINCT (resource_id) resource_id
   FROM            hxc_tk_timekeeper_submits
   WHERE           submission_id = p_submit_id;

Line: 4904

SELECT DISTINCT NVL (ppf.employee_number, ppf.npw_number) employee_number,
                     ppf.full_name,
                     ppf.effective_end_date
FROM    per_people_f ppf
WHERE   ppf.person_id = p_resource_id
AND     p_from_period < ppf.effective_end_date
AND     p_to_period > ppf.effective_start_date
AND EXISTS ( select 'x'
             from   per_all_assignments_f paa
             WHERE  ppf.person_id = paa.person_id
             AND    paa.primary_flag = 'Y'
             AND    paa.assignment_type IN ('E', 'C')
             AND    p_from_period < paa.effective_end_date
             AND    p_to_period   > paa.effective_start_date )
ORDER BY        ppf.effective_end_date DESC;

Line: 4925

	  SELECT final_process_date, date_start
	  FROM per_periods_of_service
	  WHERE person_id = p_resource_id
	  union all
	  select (final_process_date + NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0)) final_process_date, date_start
	  from per_periods_of_placement
 	  where person_id = p_resource_id
	  ORDER BY date_start DESC;

Line: 4939

        SELECT 'Y'
        from hxc_time_building_blocks
        where resource_id=p_resource_id
        and scope='TIMECARD'
        and trunc(start_time)=trunc(p_start_date)
        and trunc(stop_time)=trunc(p_end_date)
        and (trunc(date_to) = hr_general.end_of_time or APPROVAL_STATUS='ERROR');

Line: 5122

     l_attributes.DELETE;

Line: 5123

     l_timecard.DELETE;

Line: 5128

     l_day_id_info_table.delete;

Line: 5129

     l_timecard_index_info.delete;

Line: 5130

     l_attribute_index_info.delete;

Line: 5190

      l_timecard.DELETE;

Line: 5191

      l_attributes.DELETE;

Line: 5348

   SELECT time_building_block_id, object_version_number, date_to, date_from, approval_style_id,
          approval_status, comment_text,application_set_id
   FROM   hxc_time_building_blocks
   WHERE  resource_id = p_resource_id
AND       SCOPE = 'TIMECARD'
AND       date_to = hr_general.end_of_time
AND       start_time = p_start_period
AND       stop_time = p_end_period;

Line: 5370

   SELECT time_building_block_id, object_version_number, date_to, date_from,application_set_id
   FROM   hxc_time_building_blocks
   WHERE  resource_id = p_resource_id
AND       parent_building_block_id = p_parent_building_block_id
AND       parent_building_block_ovn = p_parent_ovn
AND       date_to = hr_general.end_of_time
AND       SCOPE = 'DAY'
AND       start_time = p_start_period
AND       stop_time = p_end_period;

Line: 5387

   SELECT time_building_block_id detail_id, object_version_number detail_ovn, measure, date_to,
          date_from, start_time, stop_time, comment_text,application_set_id
   FROM   hxc_time_building_blocks
   WHERE  resource_id = p_resource_id
AND       parent_building_block_id = p_parent_building_block_id
AND       parent_building_block_ovn = p_parent_ovn
AND       date_to = hr_general.end_of_time
AND       SCOPE = 'DETAIL';

Line: 5743

  p_insert_detail IN hxc_timekeeper_process.t_time_info,
  p_timecard IN OUT NOCOPY hxc_block_table_type,
  p_attributes IN OUT NOCOPY hxc_attribute_table_type,
  p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,
  p_approval_style_id IN NUMBER,
  p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
  p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
  p_timecard_id IN NUMBER,
  p_mid_save IN OUT NOCOPY VARCHAR2,
  p_comment_made_null IN OUT NOCOPY BOOLEAN,
  p_row_lock_id OUT NOCOPY ROWID,
  p_tk_audit_enabled    IN 		VARCHAR2
 ) IS
  l_index_day                  NUMBER
/*ADVICE(5036): NUMBER has no precision [315] */
                                                                                      := 0;

Line: 5823

   SELECT *
   FROM   hxc_tk_detail_temp
   WHERE  detailid = p_detailid;

Line: 5838

   SELECT comment_text
   FROM   hxc_time_building_blocks
   WHERE  resource_id = p_resource_id
AND       SCOPE = 'TIMECARD'
AND       date_to = hr_general.end_of_time
AND       start_time = p_start_period
AND       stop_time = p_end_period;

Line: 5952

   SELECT bld_blk_info_type_id
   INTO   bldtyp_id
   FROM   hxc_bld_blk_info_types
   WHERE  bld_blk_info_type = 'Dummy Paexpitdff Context';

Line: 5969

    SELECT bld_blk_info_type_id
    INTO   reason_bldtyp_id
    FROM   hxc_bld_blk_info_types
    WHERE  bld_blk_info_type = 'REASON';

Line: 5980

  IF    NVL (p_insert_detail.timecard_start_period, p_start_period) = p_start_period
     OR NVL (p_insert_detail.timecard_end_period, p_end_period) = p_end_period THEN
   p_mid_save := 'Y';

Line: 5983

   p_row_lock_id := CHARTOROWID (p_insert_detail.row_lock_id);

Line: 5985

   IF  p_insert_detail.timekeeper_action = 'INSERT' AND p_insert_detail.comment_text IS NULL THEN
    IF p_timecard_index_info.EXISTS (p_timecard_id) THEN
     l_block_index := p_timecard_index_info (p_timecard_id).time_block_row_index;

Line: 6002

     p_timecard (l_block_index).comment_text := p_insert_detail.comment_text;

Line: 6004

     IF p_insert_detail.comment_text IS NULL THEN
      p_comment_made_null := TRUE;

Line: 6015

   l_action := p_insert_detail.timekeeper_action;

Line: 6017

   IF l_action = 'INSERT' THEN
    p_mid_save := 'N';

Line: 6028

      p_insert_detail => p_insert_detail,
      p_base_dff => hxc_timekeeper_process.g_base_att,
      p_att_tab => p_att_tab
     );

Line: 6038

   IF l_action = 'UPDATE' THEN -- create the tbb_id table reference
    -- for each time_building_block_id let create a reference attribute_id table
    hxc_alias_utility.get_tbb_id_reference_table (
     p_attributes => p_attributes,
     p_tbb_id_reference_table => l_tbb_id_reference_table
    );

Line: 6156

     p_insert_detail => p_insert_detail,
     p_measure => l_measure,
     p_detail_id => l_detail_id,
     p_detail_ovn => l_detail_ovn,
     p_detail_time_in => l_detail_time_in,
     p_detail_time_out => l_detail_time_out
    );

Line: 6164

    IF  p_mid_save = 'N' AND p_insert_detail.timekeeper_action = 'INSERT' THEN
     IF l_measure IS NOT NULL OR l_detail_time_in IS NOT NULL OR l_detail_time_out IS NOT NULL THEN
      p_mid_save := 'Y';

Line: 6508

     DELETE FROM hxc_tk_detail_temp
     WHERE       detailid = l_detail_id;

Line: 6532

    ELSIF l_action = 'INSERT' THEN

     -- the easy one just attach the new information on the  timecard/attributes structure.
     -- add the detail only if the measure has been filled.
     IF (l_measure IS NOT NULL OR l_detail_time_in IS NOT NULL OR l_detail_time_out IS NOT NULL) THEN
      -- add the detail information.
      g_negative_index := g_negative_index - 1;

Line: 6573

        p_insert_data_details => p_insert_detail,
        p_old_value => l_old_attribute_value,
        p_new_value => l_new_attribute_value
       );

Line: 6710

    ELSIF l_action = 'UPDATE' THEN


     IF      (l_measure IS NOT NULL OR l_detail_time_in IS NOT NULL OR l_detail_time_out IS NOT NULL)
         AND l_detail_id IS NOT NULL
         AND l_detail_id > 0 THEN
      -- we are on an existing block
      -- update the detail information with the new measure



      IF l_detail_time_in > l_detail_time_out THEN
       l_detail_time_out := l_detail_time_out + 1;

Line: 6731

        p_insert_data_details => p_insert_detail,
        p_old_value => l_old_attribute_value,
        p_new_value => l_new_attribute_value
       );

Line: 7010

        p_insert_data_details => p_insert_detail,
        p_old_value => l_old_attribute_value,
        p_new_value => l_new_attribute_value
       );

Line: 7226

      END IF; ---DELETE REASON

Line: 7231

    ELSIF l_action = 'DELETE' THEN
     IF  l_detail_id IS NOT NULL AND l_detail_id > 0 THEN
      -- terminate the block
      hxc_timekeeper_utilities.add_block (
       p_timecard => p_timecard,
       p_timecard_id => l_detail_id,
       p_ovn => l_detail_ovn,
       p_parent_id => p_day_id_info_table (l_index_day).day_id,
       p_parent_ovn => p_day_id_info_table (l_index_day).day_ovn,
       p_approval_style_id => p_approval_style_id,
       p_measure => l_measure,
       p_scope => 'DETAIL',
       p_date_to => SYSDATE,
       p_date_from => NULL,
       p_start_period => l_detail_time_in,
       p_end_period => l_detail_time_out,
       p_resource_id => p_resource_id,
       p_changed => 'Y',
       p_comment_text => l_detail_comment_text,
       p_submit_flg => g_submit,
       p_application_set_id => l_application_set_id,
       p_timecard_index_info => p_timecard_index_info
      );

Line: 7318

      END IF; ---DELETE REASON