[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
5990: l_num_rows := l_num_rows + 1;
5991: --
5992: l_person_action_id.extend(1);
5993: --
5994: select ben_person_actions_s.nextval
5995: into l_person_action_id(l_num_rows)
5996: from sys.dual;
5997: --
5998: l_person_id.extend(1);
6001: If l_num_rows = l_chunk_size then
6002: --
6003: forall l_count in 1..l_num_rows
6004: --
6005: insert into ben_person_actions
6006: (person_action_id,
6007: person_id,
6008: ler_id,
6009: benefit_action_id,
6063: forall l_count in 1..l_num_rows
6064: --
6065: -- Bulk bind in person actions
6066: --
6067: insert into ben_person_actions
6068: (person_action_id,
6069: person_id,
6070: ler_id,
6071: benefit_action_id,
6117: --
6118: Else -- benefit_action_id is null
6119: select count(*)
6120: into l_person_cnt
6121: from ben_person_actions
6122: where benefit_action_id = p_benefit_action_id;
6123:
6124: ---
6125: l_benefit_action_id := p_benefit_action_id ;
6601: l_package varchar2(80);
6602:
6603: cursor per_cursor is
6604: select person_id
6605: from ben_person_actions act
6606: where act.person_action_id between p_start_person_action_id
6607: and p_end_person_action_id
6608: and act.benefit_action_id = p_benefit_action_id
6609: and action_status_cd <> 'P' ;