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.PA_HR_UPDATE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 142: FROM per_all_assignments_f

138: If P_person_id is NOT NULL AND P_date is NOT NULL AND P_job_id is NULL then
139:
140: SELECT Job_id
141: INTO v_job_id
142: FROM per_all_assignments_f
143: WHERE Person_id = P_person_id
144: AND P_date BETWEEN effective_start_date
145: AND effective_end_date
146: AND job_id is NOT NULL

Line 205: FROM per_all_assignments_f

201: If P_person_id is NOT NULL AND P_date is NOT NULL AND P_job_id is NULL then
202:
203: SELECT Job_id
204: INTO v_job_id
205: FROM per_all_assignments_f
206: WHERE Person_id = P_person_id
207: AND P_date BETWEEN effective_start_date
208: AND effective_end_date
209: AND job_id is NOT NULL

Line 262: FROM per_all_assignments_f paaf

258:
259: IF p_person_id is NOT NULL AND p_date is NOT NULL THEN
260: SELECT job_id
261: INTO l_job_id
262: FROM per_all_assignments_f paaf
263: WHERE paaf.person_id = p_person_id
264: AND trunc(p_date) BETWEEN trunc(paaf.effective_start_date) -- Bug 8269512 : introduced trunc() on dates
265: AND trunc(paaf.effective_end_date) -- Bug 8269512 : introduced trunc() on dates
266: AND paaf.job_id is NOT NULL

Line 1585: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;

1581: PRAGMA AUTONOMOUS_TRANSACTION;
1582:
1583: v_return_status VARCHAR2(2000);
1584: v_error_message_code VARCHAR2(2000);
1585: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
1586: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
1587: v_Person_id Per_all_assignments_f.person_id%type;
1588: v_Default_OU Hr_Organization_Information.Org_Information1%type;
1589: v_commit VARCHAR2(200) := FND_API.G_FALSE;

Line 1586: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;

1582:
1583: v_return_status VARCHAR2(2000);
1584: v_error_message_code VARCHAR2(2000);
1585: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
1586: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
1587: v_Person_id Per_all_assignments_f.person_id%type;
1588: v_Default_OU Hr_Organization_Information.Org_Information1%type;
1589: v_commit VARCHAR2(200) := FND_API.G_FALSE;
1590: -- set to false since the api is being called from trigger

Line 1587: v_Person_id Per_all_assignments_f.person_id%type;

1583: v_return_status VARCHAR2(2000);
1584: v_error_message_code VARCHAR2(2000);
1585: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
1586: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
1587: v_Person_id Per_all_assignments_f.person_id%type;
1588: v_Default_OU Hr_Organization_Information.Org_Information1%type;
1589: v_commit VARCHAR2(200) := FND_API.G_FALSE;
1590: -- set to false since the api is being called from trigger
1591: v_validate_only VARCHAR2(200) := FND_API.G_FALSE;

Line 2070: l_Person_id Per_all_assignments_f.person_id%type;

2066: l_validate_only VARCHAR2(200) := FND_API.G_FALSE;
2067: l_internal VARCHAR2(1) := 'Y';
2068: l_individual VARCHAR2(1) := 'Y'; -- to process single resource in loop
2069: l_resource_type VARCHAR2(15):= 'EMPLOYEE';
2070: l_Person_id Per_all_assignments_f.person_id%type;
2071: l_return_status VARCHAR2(2000);
2072: l_msg_data VARCHAR2(2000);
2073: l_msg_count NUMBER;
2074: l_dummy NUMBER;

Line 2180: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;

2176: ) IS
2177: PRAGMA AUTONOMOUS_TRANSACTION;
2178: v_return_status VARCHAR2(2000);
2179: v_error_message_code VARCHAR2(2000);
2180: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2181: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2182: v_Person_id Per_all_assignments_f.person_id%type;
2183: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2184: v_Default_OU Hr_Organization_Information.Org_Information1%type;

Line 2181: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;

2177: PRAGMA AUTONOMOUS_TRANSACTION;
2178: v_return_status VARCHAR2(2000);
2179: v_error_message_code VARCHAR2(2000);
2180: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2181: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2182: v_Person_id Per_all_assignments_f.person_id%type;
2183: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2184: v_Default_OU Hr_Organization_Information.Org_Information1%type;
2185: v_msg_data VARCHAR2(2000);

Line 2182: v_Person_id Per_all_assignments_f.person_id%type;

2178: v_return_status VARCHAR2(2000);
2179: v_error_message_code VARCHAR2(2000);
2180: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2181: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2182: v_Person_id Per_all_assignments_f.person_id%type;
2183: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2184: v_Default_OU Hr_Organization_Information.Org_Information1%type;
2185: v_msg_data VARCHAR2(2000);
2186: v_msg_count NUMBER;

Line 2204: FROM per_all_assignments_f assn

2200: ,assn.effective_start_date
2201: ,assn.effective_end_date
2202: , res.resource_id
2203: , hrinf.org_information1
2204: FROM per_all_assignments_f assn
2205: , hr_organization_information hrinf
2206: /* , per_person_types pertypes Commented for bug#2781713 */
2207: , per_assignment_status_types pastype
2208: , pa_resource_txn_attributes res

Line 2255: FROM per_all_assignments_f assn

2251: ,assn.effective_start_date
2252: ,assn.effective_end_date
2253: , res.resource_id
2254: -- , hrinf.org_information1
2255: FROM per_all_assignments_f assn
2256: , hr_organization_information hrinf
2257: /* , per_person_types pertypes Commented for bug#2781713 */
2258: , per_assignment_status_types pastype
2259: , pa_resource_txn_attributes res

Line 2388: ,P_person_id IN PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE default NULL

2384: -- per_job_extra_billability, which is an autonomous transaction
2385: -- This will not affect the workflow process when doing any commit or rollback
2386: PROCEDURE call_forcast_api
2387: (P_table_name IN VARCHAR2
2388: ,P_person_id IN PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE default NULL
2389: ,P_Job_id IN per_jobs.job_id%type default NULL
2390: ,P_billable_flag IN VARCHAR2 default NULL
2391: ,P_organization_id IN Hr_organization_information.organization_id%type default NULL
2392: ,p_start_date IN date default NULL

Line 2401: v_person_id PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE;

2397: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2398: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2399: ) IS
2400:
2401: v_person_id PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE;
2402: v_start_date Date;
2403: v_end_date Date;
2404:
2405: --- This cursor picks all the persons who are Employees category and

Line 2413: FROM per_all_assignments_f assn

2409: SELECT distinct
2410: assn.person_id
2411: ,assn.effective_start_date
2412: ,assn.effective_end_date
2413: FROM per_all_assignments_f assn
2414: , hr_organization_information hrinf
2415: /* , per_person_types pertypes Commented for Bug#2781713 */
2416: , per_assignment_status_types pastype
2417: , per_all_people_f pep

Line 2451: FROM per_all_assignments_f assn

2447: SELECT distinct
2448: assn.person_id
2449: ,assn.effective_start_date
2450: ,assn.effective_end_date
2451: FROM per_all_assignments_f assn
2452: , hr_organization_information hrinf
2453: /* , per_person_types pertypes Commented for Bug#2781713 */
2454: , per_assignment_status_types pastype
2455: , per_all_people_f pep

Line 3188: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

3184: cases, the resource is considered no longer active in PJR.
3185: */
3186: PROCEDURE Update_EndDate(
3187: p_person_id IN per_all_people_f.person_id%TYPE,
3188: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3189: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3190: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3191: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3192: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3189: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

3185: */
3186: PROCEDURE Update_EndDate(
3187: p_person_id IN per_all_people_f.person_id%TYPE,
3188: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3189: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3190: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3191: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3192: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3193: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3190: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

3186: PROCEDURE Update_EndDate(
3187: p_person_id IN per_all_people_f.person_id%TYPE,
3188: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3189: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3190: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3191: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3192: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3193: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3194: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 3191: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

3187: p_person_id IN per_all_people_f.person_id%TYPE,
3188: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3189: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3190: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3191: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3192: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3193: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3194: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3195:

Line 3232: l_resource_effective_end_date per_all_assignments_f.effective_end_date%TYPE ;

3228: l_end_date DATE;
3229: --Bug 9838014 End
3230:
3231: -- Bug 8791391
3232: l_resource_effective_end_date per_all_assignments_f.effective_end_date%TYPE ;
3233: l_withdraw_nom_flag VARCHAR2(1) :='Y';
3234:
3235: -- Bug 9704139
3236: l_candidate_terminated VARCHAR2(3) := 'N';

Line 3370: FROM per_all_assignments_f paaf,

3366:
3367: /*
3368: SELECT MAX(paaf.effective_end_date)
3369: INTO l_resource_effective_end_date
3370: FROM per_all_assignments_f paaf,
3371: per_assignment_status_types past
3372: WHERE paaf.person_id=p_person_id
3373: AND paaf.primary_flag = 'Y'
3374: AND paaf.assignment_type in ('E','C')

Line 3451: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,

3447: /* Procedure Update_Org calls Update_Resource_Denorm and Create_Forecast_Item to update the organization and org_id for the resources in pa_resources_denorm table and regenerate forecast items for the resource respectively.
3448: */
3449: PROCEDURE Update_Org(
3450: p_person_id IN per_all_people_f.person_id%TYPE,
3451: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3452: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3453: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3454: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3455: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

Line 3452: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,

3448: */
3449: PROCEDURE Update_Org(
3450: p_person_id IN per_all_people_f.person_id%TYPE,
3451: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3452: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3453: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3454: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3455: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3456: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 3453: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

3449: PROCEDURE Update_Org(
3450: p_person_id IN per_all_people_f.person_id%TYPE,
3451: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3452: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3453: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3454: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3455: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3456: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3457: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3454: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

3450: p_person_id IN per_all_people_f.person_id%TYPE,
3451: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3452: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3453: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3454: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3455: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3456: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3457: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3458: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3455: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

3451: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3452: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3453: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3454: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3455: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3456: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3457: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3458: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3459: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 3456: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

3452: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3453: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3454: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3455: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3456: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3457: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3458: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3459: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3460:

Line 3701: FUNCTION Belongs_ExpOrg(p_org_id IN per_all_assignments_f.organization_id%TYPE)

3697:
3698: /* Function Belongs_ExpOrg checks if the given organization belongs to
3699: an expenditure/event organization
3700: */
3701: FUNCTION Belongs_ExpOrg(p_org_id IN per_all_assignments_f.organization_id%TYPE)
3702: RETURN VARCHAR2 IS
3703: -- This function returns 'Y' if a given org is a Exp organization ,
3704: -- otherwise , it returns 'N'
3705:

Line 3742: FUNCTION Get_DefaultOU(p_org_id IN per_all_assignments_f.organization_id%TYPE)

3738: END Belongs_ExpOrg;
3739:
3740: /* Function Get_DefaultOU returns the default OU for the given organization.
3741: */
3742: FUNCTION Get_DefaultOU(p_org_id IN per_all_assignments_f.organization_id%TYPE)
3743: RETURN NUMBER IS
3744: l_default_ou number;
3745: BEGIN
3746: select to_number(org_information1)

Line 3769: p_old_job IN per_all_assignments_f.job_id%TYPE,

3765: table and regenerate forecast items for the resource respectively.
3766: */
3767: PROCEDURE Update_Job(
3768: p_person_id IN per_all_people_f.person_id%TYPE,
3769: p_old_job IN per_all_assignments_f.job_id%TYPE,
3770: p_new_job IN per_all_assignments_f.job_id%TYPE,
3771: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3772: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3773: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3770: p_new_job IN per_all_assignments_f.job_id%TYPE,

3766: */
3767: PROCEDURE Update_Job(
3768: p_person_id IN per_all_people_f.person_id%TYPE,
3769: p_old_job IN per_all_assignments_f.job_id%TYPE,
3770: p_new_job IN per_all_assignments_f.job_id%TYPE,
3771: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3772: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3773: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3774: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3771: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,

3767: PROCEDURE Update_Job(
3768: p_person_id IN per_all_people_f.person_id%TYPE,
3769: p_old_job IN per_all_assignments_f.job_id%TYPE,
3770: p_new_job IN per_all_assignments_f.job_id%TYPE,
3771: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3772: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3773: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3774: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3775: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 3772: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

3768: p_person_id IN per_all_people_f.person_id%TYPE,
3769: p_old_job IN per_all_assignments_f.job_id%TYPE,
3770: p_new_job IN per_all_assignments_f.job_id%TYPE,
3771: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3772: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3773: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3774: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3775: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3776:

Line 3994: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,

3990: the resource's supervisor in the denorm table.
3991: */
3992: PROCEDURE Update_Supervisor(
3993: p_person_id IN per_all_people_f.person_id%TYPE,
3994: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3995: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3996: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3997: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3998: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3995: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,

3991: */
3992: PROCEDURE Update_Supervisor(
3993: p_person_id IN per_all_people_f.person_id%TYPE,
3994: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3995: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3996: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3997: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3998: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3999: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3996: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,

3992: PROCEDURE Update_Supervisor(
3993: p_person_id IN per_all_people_f.person_id%TYPE,
3994: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3995: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3996: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3997: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3998: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3999: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4000: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 3997: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

3993: p_person_id IN per_all_people_f.person_id%TYPE,
3994: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3995: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3996: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3997: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3998: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3999: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4000: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
4001:

Line 4082: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

4078: the forecast items for this resource.
4079: */
4080: PROCEDURE Update_PrimaryFlag(
4081: p_person_id IN per_all_people_f.person_id%TYPE,
4082: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4083: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
4084: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
4085: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4086: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 4083: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

4079: */
4080: PROCEDURE Update_PrimaryFlag(
4081: p_person_id IN per_all_people_f.person_id%TYPE,
4082: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4083: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
4084: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
4085: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4086: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4087: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 4084: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

4080: PROCEDURE Update_PrimaryFlag(
4081: p_person_id IN per_all_people_f.person_id%TYPE,
4082: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4083: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
4084: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
4085: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4086: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4087: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4088: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 4085: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

4081: p_person_id IN per_all_people_f.person_id%TYPE,
4082: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4083: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
4084: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
4085: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4086: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4087: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4088: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
4089:

Line 4365: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

4361: -- Added for bug 3957522
4362: -- Procedure to delete records in pa_resources_denorm
4363: PROCEDURE Delete_PA_Resource_Denorm(
4364: p_person_id IN per_all_people_f.person_id%TYPE,
4365: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4366: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4367: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4368: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4369: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 4366: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,

4362: -- Procedure to delete records in pa_resources_denorm
4363: PROCEDURE Delete_PA_Resource_Denorm(
4364: p_person_id IN per_all_people_f.person_id%TYPE,
4365: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4366: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4367: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4368: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4369: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
4370: