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

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
263: WHERE person_id = p_person_id
264: AND p_date BETWEEN effective_start_date
265: AND effective_end_date
266: AND job_id is NOT NULL

Line 1578: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;

1574: PRAGMA AUTONOMOUS_TRANSACTION;
1575:
1576: v_return_status VARCHAR2(2000);
1577: v_error_message_code VARCHAR2(2000);
1578: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
1579: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
1580: v_Person_id Per_all_assignments_f.person_id%type;
1581: v_Default_OU Hr_Organization_Information.Org_Information1%type;
1582: v_commit VARCHAR2(200) := FND_API.G_FALSE;

Line 1579: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;

1575:
1576: v_return_status VARCHAR2(2000);
1577: v_error_message_code VARCHAR2(2000);
1578: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
1579: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
1580: v_Person_id Per_all_assignments_f.person_id%type;
1581: v_Default_OU Hr_Organization_Information.Org_Information1%type;
1582: v_commit VARCHAR2(200) := FND_API.G_FALSE;
1583: -- set to false since the api is being called from trigger

Line 1580: v_Person_id Per_all_assignments_f.person_id%type;

1576: v_return_status VARCHAR2(2000);
1577: v_error_message_code VARCHAR2(2000);
1578: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
1579: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
1580: v_Person_id Per_all_assignments_f.person_id%type;
1581: v_Default_OU Hr_Organization_Information.Org_Information1%type;
1582: v_commit VARCHAR2(200) := FND_API.G_FALSE;
1583: -- set to false since the api is being called from trigger
1584: v_validate_only VARCHAR2(200) := FND_API.G_FALSE;

Line 2063: l_Person_id Per_all_assignments_f.person_id%type;

2059: l_validate_only VARCHAR2(200) := FND_API.G_FALSE;
2060: l_internal VARCHAR2(1) := 'Y';
2061: l_individual VARCHAR2(1) := 'Y'; -- to process single resource in loop
2062: l_resource_type VARCHAR2(15):= 'EMPLOYEE';
2063: l_Person_id Per_all_assignments_f.person_id%type;
2064: l_return_status VARCHAR2(2000);
2065: l_msg_data VARCHAR2(2000);
2066: l_msg_count NUMBER;
2067: l_dummy NUMBER;

Line 2173: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;

2169: ) IS
2170: PRAGMA AUTONOMOUS_TRANSACTION;
2171: v_return_status VARCHAR2(2000);
2172: v_error_message_code VARCHAR2(2000);
2173: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2174: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2175: v_Person_id Per_all_assignments_f.person_id%type;
2176: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2177: v_Default_OU Hr_Organization_Information.Org_Information1%type;

Line 2174: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;

2170: PRAGMA AUTONOMOUS_TRANSACTION;
2171: v_return_status VARCHAR2(2000);
2172: v_error_message_code VARCHAR2(2000);
2173: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2174: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2175: v_Person_id Per_all_assignments_f.person_id%type;
2176: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2177: v_Default_OU Hr_Organization_Information.Org_Information1%type;
2178: v_msg_data VARCHAR2(2000);

Line 2175: v_Person_id Per_all_assignments_f.person_id%type;

2171: v_return_status VARCHAR2(2000);
2172: v_error_message_code VARCHAR2(2000);
2173: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2174: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2175: v_Person_id Per_all_assignments_f.person_id%type;
2176: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2177: v_Default_OU Hr_Organization_Information.Org_Information1%type;
2178: v_msg_data VARCHAR2(2000);
2179: v_msg_count NUMBER;

Line 2197: FROM per_all_assignments_f assn

2193: ,assn.effective_start_date
2194: ,assn.effective_end_date
2195: , res.resource_id
2196: , hrinf.org_information1
2197: FROM per_all_assignments_f assn
2198: , hr_organization_information hrinf
2199: /* , per_person_types pertypes Commented for bug#2781713 */
2200: , per_assignment_status_types pastype
2201: , pa_resource_txn_attributes res

Line 2248: FROM per_all_assignments_f assn

2244: ,assn.effective_start_date
2245: ,assn.effective_end_date
2246: , res.resource_id
2247: -- , hrinf.org_information1
2248: FROM per_all_assignments_f assn
2249: , hr_organization_information hrinf
2250: /* , per_person_types pertypes Commented for bug#2781713 */
2251: , per_assignment_status_types pastype
2252: , pa_resource_txn_attributes res

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

2377: -- per_job_extra_billability, which is an autonomous transaction
2378: -- This will not affect the workflow process when doing any commit or rollback
2379: PROCEDURE call_forcast_api
2380: (P_table_name IN VARCHAR2
2381: ,P_person_id IN PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE default NULL
2382: ,P_Job_id IN per_jobs.job_id%type default NULL
2383: ,P_billable_flag IN VARCHAR2 default NULL
2384: ,P_organization_id IN Hr_organization_information.organization_id%type default NULL
2385: ,p_start_date IN date default NULL

Line 2394: v_person_id PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE;

2390: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2391: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2392: ) IS
2393:
2394: v_person_id PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE;
2395: v_start_date Date;
2396: v_end_date Date;
2397:
2398: --- This cursor picks all the persons who are Employees category and

Line 2406: FROM per_all_assignments_f assn

2402: SELECT distinct
2403: assn.person_id
2404: ,assn.effective_start_date
2405: ,assn.effective_end_date
2406: FROM per_all_assignments_f assn
2407: , hr_organization_information hrinf
2408: /* , per_person_types pertypes Commented for Bug#2781713 */
2409: , per_assignment_status_types pastype
2410: , per_all_people_f pep

Line 2444: FROM per_all_assignments_f assn

2440: SELECT distinct
2441: assn.person_id
2442: ,assn.effective_start_date
2443: ,assn.effective_end_date
2444: FROM per_all_assignments_f assn
2445: , hr_organization_information hrinf
2446: /* , per_person_types pertypes Commented for Bug#2781713 */
2447: , per_assignment_status_types pastype
2448: , per_all_people_f pep

Line 3162: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

3158: cases, the resource is considered no longer active in PJR.
3159: */
3160: PROCEDURE Update_EndDate(
3161: p_person_id IN per_all_people_f.person_id%TYPE,
3162: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3163: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3164: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3165: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3166: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3163: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

3159: */
3160: PROCEDURE Update_EndDate(
3161: p_person_id IN per_all_people_f.person_id%TYPE,
3162: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3163: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3164: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3165: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3166: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3167: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3164: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

3160: PROCEDURE Update_EndDate(
3161: p_person_id IN per_all_people_f.person_id%TYPE,
3162: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3163: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3164: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3165: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3166: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3167: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3168: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 3165: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

3161: p_person_id IN per_all_people_f.person_id%TYPE,
3162: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3163: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3164: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3165: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3166: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3167: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3168: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3169:

Line 3331: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,

3327: /* 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.
3328: */
3329: PROCEDURE Update_Org(
3330: p_person_id IN per_all_people_f.person_id%TYPE,
3331: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3332: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3333: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3334: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3335: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

Line 3332: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,

3328: */
3329: PROCEDURE Update_Org(
3330: p_person_id IN per_all_people_f.person_id%TYPE,
3331: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3332: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3333: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3334: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3335: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3336: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 3333: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

3329: PROCEDURE Update_Org(
3330: p_person_id IN per_all_people_f.person_id%TYPE,
3331: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3332: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3333: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3334: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3335: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3336: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3337: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3334: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

3330: p_person_id IN per_all_people_f.person_id%TYPE,
3331: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3332: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3333: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3334: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3335: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3336: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3337: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3338: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3335: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

3331: p_old_org_id IN per_all_assignments_f.organization_id%TYPE,
3332: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3333: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3334: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3335: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3336: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3337: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3338: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3339: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 3336: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

3332: p_new_org_id IN per_all_assignments_f.organization_id%TYPE,
3333: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3334: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3335: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3336: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3337: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3338: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3339: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3340:

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

3576:
3577: /* Function Belongs_ExpOrg checks if the given organization belongs to
3578: an expenditure/event organization
3579: */
3580: FUNCTION Belongs_ExpOrg(p_org_id IN per_all_assignments_f.organization_id%TYPE)
3581: RETURN VARCHAR2 IS
3582: -- This function returns 'Y' if a given org is a Exp organization ,
3583: -- otherwise , it returns 'N'
3584:

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

3617: END Belongs_ExpOrg;
3618:
3619: /* Function Get_DefaultOU returns the default OU for the given organization.
3620: */
3621: FUNCTION Get_DefaultOU(p_org_id IN per_all_assignments_f.organization_id%TYPE)
3622: RETURN NUMBER IS
3623: l_default_ou number;
3624: BEGIN
3625: select to_number(org_information1)

Line 3648: p_old_job IN per_all_assignments_f.job_id%TYPE,

3644: table and regenerate forecast items for the resource respectively.
3645: */
3646: PROCEDURE Update_Job(
3647: p_person_id IN per_all_people_f.person_id%TYPE,
3648: p_old_job IN per_all_assignments_f.job_id%TYPE,
3649: p_new_job IN per_all_assignments_f.job_id%TYPE,
3650: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3651: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3652: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3649: p_new_job IN per_all_assignments_f.job_id%TYPE,

3645: */
3646: PROCEDURE Update_Job(
3647: p_person_id IN per_all_people_f.person_id%TYPE,
3648: p_old_job IN per_all_assignments_f.job_id%TYPE,
3649: p_new_job IN per_all_assignments_f.job_id%TYPE,
3650: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3651: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3652: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3653: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3650: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,

3646: PROCEDURE Update_Job(
3647: p_person_id IN per_all_people_f.person_id%TYPE,
3648: p_old_job IN per_all_assignments_f.job_id%TYPE,
3649: p_new_job IN per_all_assignments_f.job_id%TYPE,
3650: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3651: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3652: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3653: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3654: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 3651: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

3647: p_person_id IN per_all_people_f.person_id%TYPE,
3648: p_old_job IN per_all_assignments_f.job_id%TYPE,
3649: p_new_job IN per_all_assignments_f.job_id%TYPE,
3650: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3651: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3652: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3653: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3654: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3655:

Line 3858: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,

3854: the resource's supervisor in the denorm table.
3855: */
3856: PROCEDURE Update_Supervisor(
3857: p_person_id IN per_all_people_f.person_id%TYPE,
3858: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3859: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3860: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3861: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3862: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3859: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,

3855: */
3856: PROCEDURE Update_Supervisor(
3857: p_person_id IN per_all_people_f.person_id%TYPE,
3858: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3859: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3860: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3861: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3862: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3863: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3860: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,

3856: PROCEDURE Update_Supervisor(
3857: p_person_id IN per_all_people_f.person_id%TYPE,
3858: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3859: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3860: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3861: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3862: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3863: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3864: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 3861: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

3857: p_person_id IN per_all_people_f.person_id%TYPE,
3858: p_old_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3859: p_new_supervisor IN per_all_assignments_f.supervisor_id%TYPE,
3860: p_new_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3861: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3862: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3863: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3864: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3865:

Line 3946: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

3942: the forecast items for this resource.
3943: */
3944: PROCEDURE Update_PrimaryFlag(
3945: p_person_id IN per_all_people_f.person_id%TYPE,
3946: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3947: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3948: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3949: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3950: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3947: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,

3943: */
3944: PROCEDURE Update_PrimaryFlag(
3945: p_person_id IN per_all_people_f.person_id%TYPE,
3946: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3947: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3948: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3949: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3950: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3951: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3948: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,

3944: PROCEDURE Update_PrimaryFlag(
3945: p_person_id IN per_all_people_f.person_id%TYPE,
3946: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3947: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3948: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3949: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3950: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3951: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3952: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 3949: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,

3945: p_person_id IN per_all_people_f.person_id%TYPE,
3946: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
3947: p_new_start_date IN per_all_assignments_f.effective_end_date%TYPE,
3948: p_old_end_date IN per_all_assignments_f.effective_start_date%TYPE,
3949: p_new_end_date IN per_all_assignments_f.effective_end_date%TYPE,
3950: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3951: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3952: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3953:

Line 4226: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,

4222: -- Added for bug 3957522
4223: -- Procedure to delete records in pa_resources_denorm
4224: PROCEDURE Delete_PA_Resource_Denorm(
4225: p_person_id IN per_all_people_f.person_id%TYPE,
4226: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4227: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4228: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4229: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4230: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 4227: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,

4223: -- Procedure to delete records in pa_resources_denorm
4224: PROCEDURE Delete_PA_Resource_Denorm(
4225: p_person_id IN per_all_people_f.person_id%TYPE,
4226: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,
4227: p_old_end_date IN per_all_assignments_f.effective_end_date%TYPE,
4228: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4229: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4230: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
4231: