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 719: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

715: l_proc VARCHAR2(72) := g_package||'validate_scl';
716: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
717: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
718: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
719: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
720: l_scl_null_ind number(1) := 0;
721:
722: l_scl_segment1 varchar2(60) := p_segment1;
723: l_scl_segment2 varchar2(60) := p_segment2;

Line 3071: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3067: l_old_group_name pay_people_groups.group_name%TYPE;
3068: l_other_manager_warning boolean;
3069: l_effective_date date;
3070: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3071: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3072: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3073: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3074: --
3075: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 3072: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3068: l_other_manager_warning boolean;
3069: l_effective_date date;
3070: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3071: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3072: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3073: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3074: --
3075: l_business_group_id per_business_groups.business_group_id%TYPE;
3076: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 3073: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3069: l_effective_date date;
3070: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3071: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3072: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3073: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3074: --
3075: l_business_group_id per_business_groups.business_group_id%TYPE;
3076: l_legislation_code per_business_groups.legislation_code%TYPE;
3077: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

Line 3508: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3504: l_old_group_name pay_people_groups.group_name%TYPE;
3505: l_other_manager_warning boolean;
3506: l_effective_date date;
3507: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3508: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3509: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3510: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3511: l_hourly_salaried_warning boolean;
3512: l_proc varchar2(72);

Line 3509: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3505: l_other_manager_warning boolean;
3506: l_effective_date date;
3507: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3508: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3509: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3510: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3511: l_hourly_salaried_warning boolean;
3512: l_proc varchar2(72);
3513: --

Line 3510: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3506: l_effective_date date;
3507: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3508: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3509: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3510: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3511: l_hourly_salaried_warning boolean;
3512: l_proc varchar2(72);
3513: --
3514: begin

Line 3943: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3939: l_other_manager_warning boolean;
3940: l_hourly_salaried_warning boolean;
3941: l_effective_date date;
3942: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3943: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3944: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3945: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3946: --
3947: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 3944: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3940: l_hourly_salaried_warning boolean;
3941: l_effective_date date;
3942: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3943: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3944: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3945: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3946: --
3947: l_business_group_id per_business_groups.business_group_id%TYPE;
3948: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 3945: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

3941: l_effective_date date;
3942: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3943: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3944: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3945: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3946: --
3947: l_business_group_id per_business_groups.business_group_id%TYPE;
3948: l_legislation_code per_business_groups.legislation_code%TYPE;
3949: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

Line 4392: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4388: l_other_manager_warning boolean;
4389: l_hourly_salaried_warning boolean;
4390: l_effective_date date;
4391: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4392: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4393: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4394: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4395: --
4396: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 4393: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4389: l_hourly_salaried_warning boolean;
4390: l_effective_date date;
4391: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4392: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4393: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4394: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4395: --
4396: l_business_group_id per_business_groups.business_group_id%TYPE;
4397: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 4394: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

4390: l_effective_date date;
4391: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4392: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4393: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4394: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
4395: --
4396: l_business_group_id per_business_groups.business_group_id%TYPE;
4397: l_legislation_code per_business_groups.legislation_code%TYPE;
4398: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;

Line 5919: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

5915: l_business_group_id per_business_groups.business_group_id%TYPE;
5916: l_legislation_code per_business_groups.legislation_code%TYPE;
5917: l_pop_date_start DATE;
5918: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
5919: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5920: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5921: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5922: l_vendor_id NUMBER := p_vendor_id;
5923: l_vendor_site_id NUMBER := p_vendor_site_id;

Line 5920: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

5916: l_legislation_code per_business_groups.legislation_code%TYPE;
5917: l_pop_date_start DATE;
5918: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
5919: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5920: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5921: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5922: l_vendor_id NUMBER := p_vendor_id;
5923: l_vendor_site_id NUMBER := p_vendor_site_id;
5924: l_po_header_id NUMBER := p_po_header_id;

Line 5921: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

5917: l_pop_date_start DATE;
5918: --l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
5919: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5920: l_scl_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5921: l_grp_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
5922: l_vendor_id NUMBER := p_vendor_id;
5923: l_vendor_site_id NUMBER := p_vendor_site_id;
5924: l_po_header_id NUMBER := p_po_header_id;
5925: l_vendor_id_temp NUMBER;

Line 8965: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

8961: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8962: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
8963: l_effective_date date;
8964: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
8965: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
8966: l_organization_id per_all_assignments_f.organization_id%type;
8967: l_location_id per_all_assignments_f.location_id%type;
8968: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
8969: l_cagr_concatenated_segments varchar2(2000);

Line 9288: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

9284: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9285: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9286: l_effective_date date;
9287: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9288: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9289: l_organization_id per_all_assignments_f.organization_id%type;
9290: l_location_id per_all_assignments_f.location_id%type;
9291: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9292: := p_cagr_grade_def_id; -- bug 2359997

Line 9623: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

9619: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9620: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9621: l_effective_date date;
9622: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9623: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9624: l_organization_id per_all_assignments_f.organization_id%type;
9625: l_location_id per_all_assignments_f.location_id%type;
9626: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9627: := p_cagr_grade_def_id; -- bug 2359997

Line 9979: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

9975: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9976: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
9977: l_effective_date date;
9978: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9979: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9980: l_organization_id per_all_assignments_f.organization_id%type;
9981: l_location_id per_all_assignments_f.location_id%type;
9982: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9983: := p_cagr_grade_def_id; -- bug 2359997

Line 11287: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

11283: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11284: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
11285: l_hourly_salaried_warning BOOLEAN;
11286: l_session_id NUMBER;
11287: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
11288: l_payroll_id_updated BOOLEAN;
11289: --
11290: -- Internal working variables
11291: --

Line 12247: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

12243: l_payroll_id_updated boolean;
12244: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
12245: l_spp_delete_warning boolean := false; -- Bug 3545065
12246: l_tax_district_changed_warning boolean;
12247: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
12248: --
12249: l_api_updating boolean;
12250: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
12251: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 15021: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

15017: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
15018: := p_special_ceiling_step_id; -- bug 3485599
15019: l_spp_delete_warning boolean;
15020: l_tax_district_changed_warning boolean;
15021: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15022: --
15023: l_api_updating boolean;
15024: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15025: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 15234: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

15230: := p_people_group_id; -- bug 2359997
15231: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
15232: l_spp_delete_warning boolean;
15233: l_tax_district_changed_warning boolean;
15234: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
15235: l_gsp_post_process_warning varchar2(2000); -- bug2999562
15236: --
15237: l_api_updating boolean;
15238: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 16708: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

16704: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
16705: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
16706: l_effective_date date;
16707: l_date_probation_end date;
16708: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
16709: l_organization_id per_all_assignments_f.organization_id%type;
16710: l_location_id per_all_assignments_f.location_id%type;
16711: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
16712: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

Line 18372: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

18368: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
18369: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
18370: l_effective_date date;
18371: l_date_probation_end date;
18372: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
18373: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
18374: l_cagr_concatenated_segments varchar2(2000);
18375: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
18376: --

Line 19108: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

19104: l_date_probation_end date;
19105: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
19106: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
19107: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19108: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19109: l_session_id number;
19110: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
19111: l_cagr_concatenated_segments varchar2(2000);
19112: l_appl_date_end per_applications.date_end%TYPE;

Line 20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
20810: l_comment_id per_all_assignments_f.comment_id%TYPE;
20811: l_group_name pay_people_groups.group_name%TYPE;
20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
20813: l_application_id per_applications.application_id%TYPE;
20814: l_business_group_id per_business_groups.business_group_id%TYPE;
20815: l_legislation_code per_business_groups.legislation_code%TYPE;
20816: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;