[Home] [Help]
458: p_request_id,
459: p_program_application_id,
460: p_program_id,
461: l_update_date
462: FROM DUAL
463: /* Duplicate check. Required because of organization list Includes */
464: WHERE NOT EXISTS
465: (SELECT NULL
466: FROM per_organization_list pol
662: p_request_id,
663: p_program_application_id,
664: p_program_id,
665: l_update_date
666: FROM sys.dual
667: WHERE EXISTS
668: (SELECT NULL
669: FROM hr_all_positions_f pp,
670: per_organization_list ol
3160:
3161: l_proc varchar2(100) := g_package||'action_creation';
3162:
3163: /*
3164: ** Cursor to select the individual person ID's for each person in the range
3165: ** between stperson and endperson.
3166: **
3167: ** Use the emp/apl/cwk number columns to filter out contact only people
3168: ** unless they become a Emp/Apl/Cwl in the future.
3309: for perrec in c_actions(pactid, stperson, endperson) loop
3310:
3311: select pay_assignment_actions_s.nextval
3312: into l_lockingactid
3313: from dual;
3314:
3315: if l_temp_person_id is null then
3316: /*
3317: ** This is the first iteration so set the temp variable
3350: for asgrec in c_actions_prev(pactid, stperson, endperson) loop
3351:
3352: select pay_assignment_actions_s.nextval
3353: into l_lockingactid
3354: from dual;
3355:
3356: if l_temp_person_id is null then
3357: /*
3358: ** This is the first iteration so set the temp variable
3423: -- |----------------------------< archive_data >------------------------------|
3424: -- ----------------------------------------------------------------------------
3425: --
3426: -- Purpose : This process is called for each assignment action and performs the
3427: -- processing required for each individual person. We have access
3428: -- to an assignment ID but need to determine security for a person
3429: -- so convert the assignment ID into a person ID and then kickoff
3430: -- the processing for that person.
3431: --
3590: x_custom_restriction_flag => rtrim(r_sec.custom_restriction_flag),
3591: x_restriction_text => rtrim(r_sec.restriction_text),
3592: x_exclude_business_groups_flag => rtrim(r_sec.exclude_business_groups_flag),
3593: x_org_security_mode => rtrim(r_sec.org_security_mode),
3594: x_restrict_on_individual_asg => rtrim(r_sec.restrict_on_individual_asg),
3595: x_top_organization_method => rtrim(r_sec.top_organization_method),
3596: x_top_position_method => rtrim(r_sec.top_position_method)
3597: );
3598: --
3631: x_custom_restriction_flag => r_sec.custom_restriction_flag,
3632: x_restriction_text => r_sec.restriction_text,
3633: x_exclude_business_groups_flag => r_sec.exclude_business_groups_flag,
3634: x_org_security_mode => r_sec.org_security_mode,
3635: x_restrict_on_individual_asg => r_sec.restrict_on_individual_asg,
3636: x_top_organization_method => r_sec.top_organization_method,
3637: x_top_position_method => r_sec.top_position_method,
3638: x_request_id => l_req_id,
3639: x_program_application_id => l_appl_id,