241: where lookup_type like 'AME_APPROVER_CATEGORY' and lookup_code = p_category;
242:
243:
244: l_default_approvers_list ame_approver_record2_table_ss := ame_approver_record2_table_ss();
245: l_default_approver ame_approver_record2_ss;
246: l_default_insertions_list ame_insertion_record2_table_ss := ame_insertion_record2_table_ss();
247: l_default_insertion ame_insertion_record2_ss;
248: ln_approver_index NUMBER;
249: c_all_approvers ame_util.approversTable2;
357: FETCH c_apr_category INTO ln_apr_category;
358: CLOSE c_apr_category;
359:
360:
361: -- create the out ame_approver_record2_ss
362: l_default_approver := ame_approver_record2_ss(
363: tempIndex, -- approver line no
364: c_all_approvers(tempIndex).name, -- name
365: c_all_approvers(tempIndex).orig_system,
358: CLOSE c_apr_category;
359:
360:
361: -- create the out ame_approver_record2_ss
362: l_default_approver := ame_approver_record2_ss(
363: tempIndex, -- approver line no
364: c_all_approvers(tempIndex).name, -- name
365: c_all_approvers(tempIndex).orig_system,
366: c_all_approvers(tempIndex).orig_system_id,