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 PER_ASSIGNMENT_STATUS_TYPES

Line 223: from per_assignment_status_types b

219: from per_all_assignments_f a
220: where assignment_id = p_assignment_id
221: and exists
222: (select null
223: from per_assignment_status_types b
224: where b.per_system_status in ('TERM_APL','ACTIVE_ASSIGN')
225: and a.assignment_status_type_id = b.assignment_status_type_id) ;
226:
227: -- ER FPT

Line 704: from per_assignment_status_types b

700: from per_all_assignments_f a
701: where assignment_id = p_assignment_id
702: and exists
703: (select null
704: from per_assignment_status_types b
705: where b.per_system_status in ('TERM_APL','ACTIVE_ASSIGN')
706: and a.assignment_status_type_id = b.assignment_status_type_id) ;
707:
708: cursor c3(p_date_end date) is

Line 2161: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

2157: l_actual_termination_date
2158: per_periods_of_service.actual_termination_date%TYPE;
2159: l_legislation_code per_business_groups.legislation_code%TYPE;
2160: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
2161: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2162: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
2163: l_proc varchar2(72)
2164: := g_package || 'actual_termination_cwk_asg';
2165: --

Line 2184: , per_assignment_status_types ast

2180: --
2181: cursor csr_invalid_term_assign is
2182: select null
2183: from per_all_assignments_f asg
2184: , per_assignment_status_types ast
2185: where asg.assignment_id = p_assignment_id
2186: and asg.effective_end_date >= l_actual_termination_date
2187: and ast.assignment_status_type_id = asg.assignment_status_type_id
2188: and ast.per_system_status = 'TERM_CWK_ASG';

Line 2582: from per_assignment_status_types ast

2578: select min(asg.effective_start_date) - 1
2579: from per_all_assignments_f asg
2580: where asg.assignment_id = p_assignment_id
2581: and exists ( select null
2582: from per_assignment_status_types ast
2583: where ast.assignment_status_type_id
2584: = asg.assignment_status_type_id
2585: and ast.per_system_status = 'TERM_CWK_ASG');
2586:

Line 2593: from per_assignment_status_types ast

2589: select max(asg.effective_end_date)
2590: from per_all_assignments_f asg
2591: where asg.assignment_id = p_assignment_id
2592: and exists ( select null
2593: from per_assignment_status_types ast
2594: where ast.assignment_status_type_id
2595: = asg.assignment_status_type_id
2596: and ast.per_system_status = 'TERM_CWK_ASG');
2597:

Line 3077: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

3073: l_actual_termination_date
3074: per_periods_of_service.actual_termination_date%TYPE;
3075: l_legislation_code per_business_groups.legislation_code%TYPE;
3076: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
3077: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3078: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
3079: l_proc varchar2(72)
3080: := g_package || 'actual_termination_emp_asg';
3081: --

Line 3100: , per_assignment_status_types ast

3096: --
3097: cursor csr_invalid_term_assign is
3098: select null
3099: from per_all_assignments_f asg
3100: , per_assignment_status_types ast
3101: where asg.assignment_id = p_assignment_id
3102: and asg.effective_end_date >= l_actual_termination_date
3103: and ast.assignment_status_type_id = asg.assignment_status_type_id
3104: and ast.per_system_status = 'TERM_ASSIGN';

Line 8946: from per_assignment_status_types ast

8942: select min(asg.effective_start_date) - 1
8943: from per_all_assignments_f asg
8944: where asg.assignment_id = p_assignment_id
8945: and exists ( select null
8946: from per_assignment_status_types ast
8947: where ast.assignment_status_type_id
8948: = asg.assignment_status_type_id
8949: and ast.per_system_status = 'TERM_ASSIGN');
8950:

Line 8957: from per_assignment_status_types ast

8953: select max(asg.effective_end_date)
8954: from per_all_assignments_f asg
8955: where asg.assignment_id = p_assignment_id
8956: and exists ( select null
8957: from per_assignment_status_types ast
8958: where ast.assignment_status_type_id
8959: = asg.assignment_status_type_id
8960: and ast.per_system_status = 'TERM_ASSIGN');
8961:

Line 10213: l_old_asg_status per_assignment_status_types.per_system_status%type;

10209: l_proc varchar2(72) := g_package||'update_emp_asg';
10210: l_session_id number;
10211: l_unused_start_date date;
10212: l_unused_end_date date;
10213: l_old_asg_status per_assignment_status_types.per_system_status%type;
10214: l_new_asg_status per_assignment_status_types.per_system_status%type;
10215:
10216: begin
10217: --

Line 10214: l_new_asg_status per_assignment_status_types.per_system_status%type;

10210: l_session_id number;
10211: l_unused_start_date date;
10212: l_unused_end_date date;
10213: l_old_asg_status per_assignment_status_types.per_system_status%type;
10214: l_new_asg_status per_assignment_status_types.per_system_status%type;
10215:
10216: begin
10217: --
10218: l_object_version_number := p_object_version_number;

Line 10569: l_old_asg_status per_assignment_status_types.per_system_status%type;

10565: l_proc varchar2(72) := g_package||'update_emp_asg';
10566: l_session_id number;
10567: l_unused_start_date date;
10568: l_unused_end_date date;
10569: l_old_asg_status per_assignment_status_types.per_system_status%type;
10570: l_new_asg_status per_assignment_status_types.per_system_status%type;
10571: --
10572: -- bug 2359997 new variables to indicate whether key flex id parameters
10573: -- enter the program with a value.

Line 10570: l_new_asg_status per_assignment_status_types.per_system_status%type;

10566: l_session_id number;
10567: l_unused_start_date date;
10568: l_unused_end_date date;
10569: l_old_asg_status per_assignment_status_types.per_system_status%type;
10570: l_new_asg_status per_assignment_status_types.per_system_status%type;
10571: --
10572: -- bug 2359997 new variables to indicate whether key flex id parameters
10573: -- enter the program with a value.
10574: --

Line 10639: from per_assignment_status_types ast,

10635: --
10636: l_projected_assignment_end date;--fix for bug 6595592.
10637: cursor csr_old_asg_status is
10638: select ast.per_system_status
10639: from per_assignment_status_types ast,
10640: per_all_assignments_f asg
10641: where ast.assignment_status_type_id = asg.assignment_status_type_id
10642: and asg.assignment_id = p_assignment_id
10643: and l_effective_date between asg.effective_start_date

Line 10648: from per_assignment_status_types ast

10644: and asg.effective_end_date;
10645: --
10646: cursor csr_new_asg_status is
10647: select ast.per_system_status
10648: from per_assignment_status_types ast
10649: where ast.assignment_status_type_id = p_assignment_status_type_id;
10650: --
10651: cursor csr_get_assignment_type is
10652: select asg.assignment_type

Line 11900: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;

11896: l_organization_id per_all_assignments_f.organization_id%TYPE;
11897: l_business_group_id per_business_groups.business_group_id%TYPE;
11898: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11899: l_location_id per_all_assignments_f.location_id%TYPE;
11900: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11901: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11902: l_cagr_grade_def_id NUMBER;
11903: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
11904: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 11901: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;

11897: l_business_group_id per_business_groups.business_group_id%TYPE;
11898: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
11899: l_location_id per_all_assignments_f.location_id%TYPE;
11900: l_old_asg_status per_assignment_status_types.per_system_status%TYPE;
11901: l_new_asg_status per_assignment_status_types.per_system_status%TYPE;
11902: l_cagr_grade_def_id NUMBER;
11903: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
11904: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
11905: l_po_header_id NUMBER := p_po_header_id;

Line 11921: from per_assignment_status_types ast,

11917: lv_object_version_number number := p_object_version_number ;
11918: --
11919: cursor csr_old_asg_status is
11920: select ast.per_system_status
11921: from per_assignment_status_types ast,
11922: per_all_assignments_f asg
11923: where ast.assignment_status_type_id = asg.assignment_status_type_id
11924: and asg.assignment_id = p_assignment_id
11925: and l_effective_date between asg.effective_start_date and asg.effective_end_date;

Line 11929: from per_assignment_status_types ast

11925: and l_effective_date between asg.effective_start_date and asg.effective_end_date;
11926: --
11927: cursor csr_new_asg_status is
11928: select ast.per_system_status
11929: from per_assignment_status_types ast
11930: where ast.assignment_status_type_id = p_assignment_status_type_id;
11931: --
11932: cursor csr_get_assignment_type is
11933: select asg.assignment_type

Line 17577: l_old_asg_status per_assignment_status_types.per_system_status%type;

17573: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
17574: l_proc varchar2(72) := g_package||'update_apl_asg';
17575: l_api_updating boolean;
17576: l_session_id number;
17577: l_old_asg_status per_assignment_status_types.per_system_status%type;
17578: l_new_asg_status per_assignment_status_types.per_system_status%type;
17579: --
17580: -- bug 2230915 new variables to indicate whether key flex id parameters
17581: -- enter the program with a value.

Line 17578: l_new_asg_status per_assignment_status_types.per_system_status%type;

17574: l_proc varchar2(72) := g_package||'update_apl_asg';
17575: l_api_updating boolean;
17576: l_session_id number;
17577: l_old_asg_status per_assignment_status_types.per_system_status%type;
17578: l_new_asg_status per_assignment_status_types.per_system_status%type;
17579: --
17580: -- bug 2230915 new variables to indicate whether key flex id parameters
17581: -- enter the program with a value.
17582: --

Line 17680: from per_assignment_status_types ast,

17676:
17677: --
17678: cursor csr_old_asg_status is
17679: select ast.per_system_status
17680: from per_assignment_status_types ast,
17681: per_all_assignments_f asg
17682: where ast.assignment_status_type_id = asg.assignment_status_type_id
17683: and asg.assignment_id = p_assignment_id
17684: and l_effective_date between asg.effective_start_date and asg.effective_end_date;

Line 17688: from per_assignment_status_types ast

17684: and l_effective_date between asg.effective_start_date and asg.effective_end_date;
17685: --
17686: cursor csr_new_asg_status is
17687: select ast.per_system_status
17688: from per_assignment_status_types ast
17689: where ast.assignment_status_type_id = p_assignment_status_type_id;
17690: --
17691: --
17692: cursor csr_grp_idsel is

Line 22149: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE

22145: ,p_effective_date IN DATE
22146: ,p_datetrack_update_mode IN VARCHAR2
22147: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22148: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22149: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
22150: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
22151: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22152: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22153: )

Line 22164: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'ACTIVE_APL';

22160: l_effective_date DATE;
22161: --
22162: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
22163: --
22164: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'ACTIVE_APL';
22165: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
22166: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
22167: --
22168: lv_object_version_number number := p_object_version_number ;

Line 23952: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE

23948: ,p_effective_date IN DATE
23949: ,p_datetrack_update_mode IN VARCHAR2
23950: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23951: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23952: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
23953: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
23954: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23955: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
23956: )

Line 23967: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW1';

23963: l_effective_date DATE;
23964: --
23965: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
23966: --
23967: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW1';
23968: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
23969: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
23970: --
23971: lv_object_version_number number := p_object_version_number ;

Line 24116: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE

24112: ,p_effective_date IN DATE
24113: ,p_datetrack_update_mode IN VARCHAR2
24114: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
24115: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
24116: ,p_assignment_status_type_id IN per_assignment_status_types.assignment_status_type_id%TYPE
24117: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
24118: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
24119: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
24120: )

Line 24131: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW2';

24127: l_effective_date DATE;
24128: --
24129: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
24130: --
24131: l_expected_system_status per_assignment_status_types.per_system_status%TYPE := 'INTERVIEW2';
24132: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
24133: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
24134: --
24135: lv_object_version_number number := p_object_version_number ;