eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ASSIGNMENT_API dependencies on FND_ID_FLEX_SEGMENTS

Line 1280: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

1276: l_proc VARCHAR2(72) := g_package||'validate_scl';
1277: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
1278: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1279: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1280: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1281: l_scl_null_ind number(1) := 0;
1282:
1283: l_scl_segment1 varchar2(60) := p_segment1;
1284: l_scl_segment2 varchar2(60) := p_segment2;

Line 3638: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3634: l_old_group_name pay_people_groups.group_name%TYPE;
3635: l_other_manager_warning boolean;
3636: l_effective_date date;
3637: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3638: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3639: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3640: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3641: --
3642: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 3639: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3635: l_other_manager_warning boolean;
3636: l_effective_date date;
3637: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3638: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3639: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3640: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3641: --
3642: l_business_group_id per_business_groups.business_group_id%TYPE;
3643: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 3640: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3636: l_effective_date date;
3637: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3638: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3639: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3640: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3641: --
3642: l_business_group_id per_business_groups.business_group_id%TYPE;
3643: l_legislation_code per_business_groups.legislation_code%TYPE;
3644: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

Line 4075: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4071: l_old_group_name pay_people_groups.group_name%TYPE;
4072: l_other_manager_warning boolean;
4073: l_effective_date date;
4074: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4075: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4076: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4077: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4078: l_hourly_salaried_warning boolean;
4079: l_proc varchar2(72);

Line 4076: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4072: l_other_manager_warning boolean;
4073: l_effective_date date;
4074: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4075: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4076: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4077: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4078: l_hourly_salaried_warning boolean;
4079: l_proc varchar2(72);
4080: --

Line 4077: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4073: l_effective_date date;
4074: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4075: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4076: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4077: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4078: l_hourly_salaried_warning boolean;
4079: l_proc varchar2(72);
4080: --
4081: begin

Line 4510: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4506: l_other_manager_warning boolean;
4507: l_hourly_salaried_warning boolean;
4508: l_effective_date date;
4509: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4510: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4511: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4512: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4513: --
4514: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 4511: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4507: l_hourly_salaried_warning boolean;
4508: l_effective_date date;
4509: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4510: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4511: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4512: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4513: --
4514: l_business_group_id per_business_groups.business_group_id%TYPE;
4515: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 4512: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4508: l_effective_date date;
4509: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4510: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4511: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4512: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4513: --
4514: l_business_group_id per_business_groups.business_group_id%TYPE;
4515: l_legislation_code per_business_groups.legislation_code%TYPE;
4516: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

Line 4959: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4955: l_other_manager_warning boolean;
4956: l_hourly_salaried_warning boolean;
4957: l_effective_date date;
4958: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4959: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4960: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4961: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4962: --
4963: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 4960: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4956: l_hourly_salaried_warning boolean;
4957: l_effective_date date;
4958: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4959: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4960: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4961: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4962: --
4963: l_business_group_id per_business_groups.business_group_id%TYPE;
4964: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 4961: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4957: l_effective_date date;
4958: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4959: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4960: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4961: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4962: --
4963: l_business_group_id per_business_groups.business_group_id%TYPE;
4964: l_legislation_code per_business_groups.legislation_code%TYPE;
4965: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

Line 6486: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

6482: l_business_group_id per_business_groups.business_group_id%TYPE;
6483: l_legislation_code per_business_groups.legislation_code%TYPE;
6484: l_pop_date_start DATE;
6485: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
6486: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6487: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6488: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6489: l_vendor_id NUMBER := p_vendor_id;
6490: l_vendor_site_id NUMBER := p_vendor_site_id;

Line 6487: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

6483: l_legislation_code per_business_groups.legislation_code%TYPE;
6484: l_pop_date_start DATE;
6485: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
6486: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6487: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6488: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6489: l_vendor_id NUMBER := p_vendor_id;
6490: l_vendor_site_id NUMBER := p_vendor_site_id;
6491: l_po_header_id NUMBER := p_po_header_id;

Line 6488: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

6484: l_pop_date_start DATE;
6485: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
6486: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6487: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6488: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
6489: l_vendor_id NUMBER := p_vendor_id;
6490: l_vendor_site_id NUMBER := p_vendor_site_id;
6491: l_po_header_id NUMBER := p_po_header_id;
6492: l_vendor_id_temp NUMBER;

Line 9532: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

9528: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9529: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9530: l_effective_date date;
9531: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9532: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9533: l_organization_id per_all_assignments_f.organization_id%type;
9534: l_location_id per_all_assignments_f.location_id%type;
9535: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
9536: l_cagr_concatenated_segments varchar2(2000);

Line 9855: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

9851: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9852: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9853: l_effective_date date;
9854: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9855: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9856: l_organization_id per_all_assignments_f.organization_id%type;
9857: l_location_id per_all_assignments_f.location_id%type;
9858: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9859: := p_cagr_grade_def_id; -- bug 2359997

Line 10190: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

10186: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10187: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10188: l_effective_date date;
10189: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
10190: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
10191: l_organization_id per_all_assignments_f.organization_id%type;
10192: l_location_id per_all_assignments_f.location_id%type;
10193: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10194: := p_cagr_grade_def_id; -- bug 2359997

Line 10546: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

10542: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10543: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
10544: l_effective_date date;
10545: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
10546: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
10547: l_organization_id per_all_assignments_f.organization_id%type;
10548: l_location_id per_all_assignments_f.location_id%type;
10549: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10550: := p_cagr_grade_def_id; -- bug 2359997

Line 11888: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

11884: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11885: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11886: l_hourly_salaried_warning BOOLEAN;
11887: l_session_id NUMBER;
11888: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
11889: l_payroll_id_updated BOOLEAN;
11890: --
11891: -- Internal working variables
11892: --

Line 12848: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

12844: l_payroll_id_updated boolean;
12845: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
12846: l_spp_delete_warning boolean := false; -- Bug 3545065
12847: l_tax_district_changed_warning boolean;
12848: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
12849: --
12850: l_api_updating boolean;
12851: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12852: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 15622: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

15618: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
15619: := p_special_ceiling_step_id; -- bug 3485599
15620: l_spp_delete_warning boolean;
15621: l_tax_district_changed_warning boolean;
15622: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15623: --
15624: l_api_updating boolean;
15625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15626: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 15836: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

15832: := p_people_group_id; -- bug 2359997
15833: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
15834: l_spp_delete_warning boolean;
15835: l_tax_district_changed_warning boolean;
15836: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15837: l_gsp_post_process_warning varchar2(2000); -- bug2999562
15838: --
15839: l_api_updating boolean;
15840: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 17554: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

17550: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
17551: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
17552: l_effective_date date;
17553: l_date_probation_end date;
17554: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
17555: l_organization_id per_all_assignments_f.organization_id%type;
17556: l_location_id per_all_assignments_f.location_id%type;
17557: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
17558: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

Line 19235: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

19231: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
19232: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
19233: l_effective_date date;
19234: l_date_probation_end date;
19235: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19236: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19237: l_cagr_concatenated_segments varchar2(2000);
19238: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
19239: --

Line 19971: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

19967: l_date_probation_end date;
19968: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
19969: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
19970: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19971: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19972: l_session_id number;
19973: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
19974: l_cagr_concatenated_segments varchar2(2000);
19975: l_appl_date_end per_applications.date_end%TYPE;

Line 21675: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21672: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
21673: l_comment_id per_all_assignments_f.comment_id%TYPE;
21674: l_group_name pay_people_groups.group_name%TYPE;
21675: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
21676: l_application_id per_applications.application_id%TYPE;
21677: l_business_group_id per_business_groups.business_group_id%TYPE;
21678: l_legislation_code per_business_groups.legislation_code%TYPE;
21679: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;