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.PER_CANCEL_HIRE_OR_APL_PKG dependencies on IRC_ASSIGNMENT_STATUSES

Line 1400: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;

1396: p_rowid ROWID;
1397: l_period_of_service_id NUMBER;
1398: l_assignment_id NUMBER;
1399: l_person_type_id NUMBER;
1400: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
1401: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
1402: l_asg_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1403: l_dummy varchar2(10);
1404:

Line 1401: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;

1397: l_period_of_service_id NUMBER;
1398: l_assignment_id NUMBER;
1399: l_person_type_id NUMBER;
1400: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
1401: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
1402: l_asg_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1403: l_dummy varchar2(10);
1404:
1405: cursor budget_values1 is

Line 1463: from irc_assignment_statuses iass

1459:
1460: -- Cusror for iRecruitment assignment status
1461: cursor irc_asg_status is
1462: select iass.assignment_status_id, iass.object_version_number
1463: from irc_assignment_statuses iass
1464: where iass.assignment_status_id =
1465: (select max(iass.assignment_status_id)
1466: from irc_assignment_statuses iass
1467: where iass.assignment_id = l_assignment_id

Line 1466: from irc_assignment_statuses iass

1462: select iass.assignment_status_id, iass.object_version_number
1463: from irc_assignment_statuses iass
1464: where iass.assignment_status_id =
1465: (select max(iass.assignment_status_id)
1466: from irc_assignment_statuses iass
1467: where iass.assignment_id = l_assignment_id
1468: and iass.assignment_status_type_id = l_asg_status_type_id);
1469:
1470: -- assignment cursor for entries update

Line 2089: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;

2085: l_assignment_id NUMBER;
2086: l_back2back BOOLEAN;
2087: l_person_type_id NUMBER;
2088: -- Start of fix 3564129
2089: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
2090: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
2091: l_asg_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2092: -- End of fix 3564129
2093: --

Line 2090: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;

2086: l_back2back BOOLEAN;
2087: l_person_type_id NUMBER;
2088: -- Start of fix 3564129
2089: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
2090: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
2091: l_asg_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2092: -- End of fix 3564129
2093: --
2094:

Line 2238: from irc_assignment_statuses iass

2234: -- Start of fix 3564129
2235: -- Cusror for iRecruitment assignment status
2236: cursor irc_asg_status is
2237: select iass.assignment_status_id, iass.object_version_number
2238: from irc_assignment_statuses iass
2239: where iass.assignment_status_id =
2240: (select max(iass.assignment_status_id)
2241: from irc_assignment_statuses iass
2242: where iass.assignment_id = l_assignment_id

Line 2241: from irc_assignment_statuses iass

2237: select iass.assignment_status_id, iass.object_version_number
2238: from irc_assignment_statuses iass
2239: where iass.assignment_status_id =
2240: (select max(iass.assignment_status_id)
2241: from irc_assignment_statuses iass
2242: where iass.assignment_id = l_assignment_id
2243: and iass.assignment_status_type_id = l_asg_status_type_id);
2244: -- End of fix 3564129
2245: --