[Home] [Help]
132: 02-Oct-03 tjesumic 115.87 Upper/lower/initcap applied for string format mask
133: 29-Oct-03 tjesumic 115.88 total for detail records are considers only non hiden records
134: hiden recors are filterd
135: 30-dec-03 mmudigon 115.89 Bug 3232205. Modified cursors on
136: ben_person_actions to drive by
137: benefit_action_id
138: 19-Jan-03 tjesumic 115.91 New procedire load_extract added to import and export the
139: extract definition
140: 19-Jan-03 tjesumic 115.92 extract sedded or not decided by the extract not the parameter
6022: l_num_rows := l_num_rows + 1;
6023: --
6024: l_person_action_id.extend(1);
6025: --
6026: select ben_person_actions_s.nextval
6027: into l_person_action_id(l_num_rows)
6028: from sys.dual;
6029: --
6030: l_person_id.extend(1);
6033: If l_num_rows = l_chunk_size then
6034: --
6035: forall l_count in 1..l_num_rows
6036: --
6037: insert into ben_person_actions
6038: (person_action_id,
6039: person_id,
6040: ler_id,
6041: benefit_action_id,
6096: forall l_count in 1..l_num_rows
6097: --
6098: -- Bulk bind in person actions
6099: --
6100: insert into ben_person_actions
6101: (person_action_id,
6102: person_id,
6103: ler_id,
6104: benefit_action_id,
6150: --
6151: Else -- benefit_action_id is null
6152: select count(*)
6153: into l_person_cnt
6154: from ben_person_actions
6155: where benefit_action_id = p_benefit_action_id
6156: and ACTION_STATUS_CD='U';
6157: --vkodedal 30-Mar-2009 Bug#8335771 -Restart process not spawning threads
6158: select count(*)
6642: l_package varchar2(80);
6643:
6644: cursor per_cursor is
6645: select person_id
6646: from ben_person_actions act
6647: where act.person_action_id between p_start_person_action_id
6648: and p_end_person_action_id
6649: and act.benefit_action_id = p_benefit_action_id
6650: and action_status_cd <> 'P' ;