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_RESOURCE_PVT dependencies on PA_RESOURCES_DENORM

Line 66: from pa_resources_denorm res

62: WHERE a1.record_type = 'C'
63: and a1.resource_id = p_resource_id
64: and a1.percent >= l_avl_profile
65: and sysdate < (select min(resource_effective_start_date)
66: from pa_resources_denorm res
67: where a1.resource_id = res.resource_id);
68:
69:
70: BEGIN

Line 213: -- to the table 'PA_RESOURCES_DENORM' after some appropriate

209: -------------------------------------------------------------------------------+
210: --
211: -- PROCEDURE : Insert_resource_denorm
212: -- DESCRIPTION : This Procedure inserts the record 'p_resource_denorm_rec'
213: -- to the table 'PA_RESOURCES_DENORM' after some appropriate
214: -- validations.
215: --
216: --------------------------------------------------------------------------------+
217: PROCEDURE Insert_resource_denorm

Line 224: l_resource_id pa_resources_denorm.resource_id%TYPE := NULL;

220: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
221: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
222: IS
223: l_resource_denorm_rec PA_RESOURCE_PVT.Resource_denorm_Rec_type;
224: l_resource_id pa_resources_denorm.resource_id%TYPE := NULL;
225: l_return_status VARCHAR2(1);
226: l_err_msg_code fnd_new_messages.message_name%TYPE;
227: l_msg_index_out NUMBER;
228: l_rows_exists VARCHAR2(1);

Line 269: FROM pa_resources_denorm

265: SELECT 'Y'
266: INTO l_rows_exists
267: FROM dual
268: WHERE EXISTS (SELECT 'Y'
269: FROM pa_resources_denorm
270: WHERE l_resource_denorm_rec.person_id = person_id
271: AND l_resource_denorm_rec.job_id = job_id);
272:
273: IF l_rows_exists = 'Y' THEN

Line 301: INSERT into pa_resources_denorm

297: --and sysdate between effective_start_date and effective_end_date;
298: --
299: -- insert the record to the table 'PA_RESOURCE_DENORM'
300: --
301: INSERT into pa_resources_denorm
302: (
303: PERSON_ID,
304: RESOURCE_ID,
305: RESOURCE_NAME,

Line 451: -- 'PA_RESOURCES_DENORM' after some appropriate validations.

447: -----------------------------------------------------------------------------------+
448: --
449: -- PROCEDURE : Update_resource_denorm
450: -- DESCRIPTION: This Function updates record(s) in the table
451: -- 'PA_RESOURCES_DENORM' after some appropriate validations.
452: --
453: -----------------------------------------------------------------------------------+
454: PROCEDURE Update_resource_denorm (
455: p_resource_denorm_old_rec IN Resource_denorm_Rec_type,

Line 498: -- the primary key in the table 'PA_RESOURCES_DENORM', resource_effective

494: -------------------------------------------------------------------------
495: -- If resource_effective_start_date has been passed, update an individual
496: -- record after some appropriate validations.
497: -- Since the combination of person_id and resource_effective_start_date is
498: -- the primary key in the table 'PA_RESOURCES_DENORM', resource_effective
499: -- _start_date should not be null for individual record update.
500: -------------------------------------------------------------------------
501: IF l_resource_denorm_new_rec.resource_effective_start_date <> FND_API.G_MISS_DATE AND
502: l_resource_denorm_new_rec.resource_effective_start_date is not null THEN

Line 607: -- DESCRIPTION: This procedure updates single record in the table 'PA_RESOURCES_DENORM'.

603:
604: ---------------------------------------------------------------------------------------
605: --
606: -- PROCEDURE : update_single_res_denorm_rec
607: -- DESCRIPTION: This procedure updates single record in the table 'PA_RESOURCES_DENORM'.
608: --
609: ---------------------------------------------------------------------------------------
610: PROCEDURE update_single_res_denorm_rec(
611: p_resource_denorm_rec IN resource_denorm_rec_type,

Line 633: UPDATE pa_resources_denorm

629: RETURN;
630: END IF;
631:
632:
633: UPDATE pa_resources_denorm
634: SET
635: resource_type = DECODE(p_resource_denorm_rec.resource_type, FND_API.G_MISS_CHAR,
636: resource_type,p_resource_denorm_rec.resource_type),
637: resource_organization_id = DECODE(p_resource_denorm_rec.resource_organization_ID,

Line 693: -- person in the table 'PA_RESOURCES_DENORM'. This procedure usually

689: ------------------------------------------------------------------------------------
690: --
691: -- PROCEDURE : update_person_res_denorm_recs
692: -- DESCRIPTION: This procedure updates multiple records which are related to a
693: -- person in the table 'PA_RESOURCES_DENORM'. This procedure usually
694: -- is used to update resource_name.
695: --
696: ------------------------------------------------------------------------------------
697: PROCEDURE update_person_res_denorm_recs

Line 725: UPDATE pa_resources_denorm

721: p_new_resource_denorm_rec => p_resource_denorm_rec,
722: x_return_status => l_return_status);
723:
724:
725: UPDATE pa_resources_denorm
726: SET
727: resource_name = DECODE(p_resource_denorm_rec.resource_name, FND_API.G_MISS_CHAR,
728: resource_name,p_resource_denorm_rec.resource_name),
729: resource_country_code = DECODE(p_resource_denorm_rec.resource_country_code, FND_API.G_MISS_CHAR,

Line 769: l_old_resource_name pa_resources_denorm.resource_name%TYPE;

765: PROCEDURE syncronize_manager_name
766: (p_new_resource_denorm_rec IN resource_denorm_rec_type,
767: x_return_status OUT NOCOPY VARCHAR) --File.Sql.39 bug 4440895
768: IS
769: l_old_resource_name pa_resources_denorm.resource_name%TYPE;
770: l_new_resource_name pa_resources_denorm.resource_name%TYPE := p_new_resource_denorm_rec.resource_name;
771: l_name_changed VARCHAR2(1):='N'; -- 5336386
772: BEGIN
773: -- Initialize the return status to success

Line 770: l_new_resource_name pa_resources_denorm.resource_name%TYPE := p_new_resource_denorm_rec.resource_name;

766: (p_new_resource_denorm_rec IN resource_denorm_rec_type,
767: x_return_status OUT NOCOPY VARCHAR) --File.Sql.39 bug 4440895
768: IS
769: l_old_resource_name pa_resources_denorm.resource_name%TYPE;
770: l_new_resource_name pa_resources_denorm.resource_name%TYPE := p_new_resource_denorm_rec.resource_name;
771: l_name_changed VARCHAR2(1):='N'; -- 5336386
772: BEGIN
773: -- Initialize the return status to success
774: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 784: --FROM pa_resources_denorm

780:
781: -- 5336386 : Commented below select and added new
782: --SELECT DISTINCT resource_name
783: --INTO l_old_resource_name
784: --FROM pa_resources_denorm
785: --WHERE person_id=p_new_resource_denorm_rec.person_id;
786:
787: SELECT 'Y' INTO l_name_changed
788: FROM dual

Line 791: FROM pa_resources_denorm

787: SELECT 'Y' INTO l_name_changed
788: FROM dual
789: WHERE exists
790: (SELECT 'Y'
791: FROM pa_resources_denorm
792: WHERE person_id = p_new_resource_denorm_rec.person_id
793: AND resource_name <> l_new_resource_name) ;
794:
795:

Line 802: UPDATE pa_resources_denorm

798:
799: -- if the resource_name has been updated, we need to syncronize manager_name if he
800: -- is manager of someone.
801:
802: UPDATE pa_resources_denorm
803: SET manager_name = l_new_resource_name
804: WHERE manager_id = p_new_resource_denorm_rec.person_id;
805: --AND resource_effective_end_date > sysdate;
806: END IF;

Line 825: -- job in the table 'PA_RESOURCES_DENORM'.

821:
822: ------------------------------------------------------------------------------------
823: -- PROCEDURE : update_job_res_denorm_recs
824: -- DESCRIPTION: This procedure update multiple records which are related to a
825: -- job in the table 'PA_RESOURCES_DENORM'.
826: ------------------------------------------------------------------------------------
827: PROCEDURE update_job_res_denorm_recs
828: (p_resource_denorm_rec IN resource_denorm_rec_type,
829: p_start_rowid IN rowid default NULL,

Line 839: UPDATE pa_resources_denorm

835: -- Initialize the return status to success
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837:
838: -- fixed the bug 1559045 here
839: UPDATE pa_resources_denorm
840: SET
841: resource_job_level = DECODE(p_resource_denorm_rec.resource_job_level, FND_API.G_MISS_NUM,
842: resource_job_level,p_resource_denorm_rec.resource_job_level),
843: employee_flag = DECODE(p_resource_denorm_rec.employee_flag, FND_API.G_MISS_CHAR,

Line 874: -- DESCRIPTION: This procedure deletes a record in the table 'PA_RESOURCES_DENORM'.

870:
871: ------------------------------------------------------------------------------------
872: --
873: -- PROCEDURE : delete_resource_denorm
874: -- DESCRIPTION: This procedure deletes a record in the table 'PA_RESOURCES_DENORM'.
875: --
876: ------------------------------------------------------------------------------------
877: PROCEDURE delete_resource_denorm
878: ( p_person_id IN pa_resources_denorm.person_id%type,

Line 878: ( p_person_id IN pa_resources_denorm.person_id%type,

874: -- DESCRIPTION: This procedure deletes a record in the table 'PA_RESOURCES_DENORM'.
875: --
876: ------------------------------------------------------------------------------------
877: PROCEDURE delete_resource_denorm
878: ( p_person_id IN pa_resources_denorm.person_id%type,
879: p_res_effective_start_date IN pa_resources_denorm.resource_effective_start_date%type,
880: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
881: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
882: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895

Line 879: p_res_effective_start_date IN pa_resources_denorm.resource_effective_start_date%type,

875: --
876: ------------------------------------------------------------------------------------
877: PROCEDURE delete_resource_denorm
878: ( p_person_id IN pa_resources_denorm.person_id%type,
879: p_res_effective_start_date IN pa_resources_denorm.resource_effective_start_date%type,
880: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
881: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
882: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
883: IS

Line 884: -- l_manager_id pa_resources_denorm.manager_id%TYPE;

880: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
881: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
882: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
883: IS
884: -- l_manager_id pa_resources_denorm.manager_id%TYPE;
885: -- l_msg_index_out NUMBER;
886: -- l_return_status VARCHAR2(1);
887: -- l_err_msg_code fnd_new_messages.message_name%TYPE;
888:

Line 894: DELETE FROM PA_RESOURCES_DENORM

890: -- Initialize the return status to success
891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892:
893:
894: DELETE FROM PA_RESOURCES_DENORM
895: WHERE person_id = p_person_id
896: AND resource_effective_start_date = p_res_effective_start_date
897: AND resource_effective_end_date > trunc(sysdate);
898:

Line 925: l_billable_flag pa_resources_denorm.billable_flag%TYPE;

921: ,x_schedulable_flag OUT NOCOPY VARCHAR2
922: ) IS
923:
924: l_job_info_type VARCHAR2(20) := 'Job Category';
925: l_billable_flag pa_resources_denorm.billable_flag%TYPE;
926: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;
927: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;
928:
929:

Line 926: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;

922: ) IS
923:
924: l_job_info_type VARCHAR2(20) := 'Job Category';
925: l_billable_flag pa_resources_denorm.billable_flag%TYPE;
926: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;
927: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;
928:
929:
930: BEGIN

Line 927: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;

923:
924: l_job_info_type VARCHAR2(20) := 'Job Category';
925: l_billable_flag pa_resources_denorm.billable_flag%TYPE;
926: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;
927: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;
928:
929:
930: BEGIN
931:

Line 1008: l_resource_country_code pa_resources_denorm.resource_country_code%TYPE;

1004: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1005: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1006: ) IS
1007:
1008: l_resource_country_code pa_resources_denorm.resource_country_code%TYPE;
1009: l_resource_country pa_resources_denorm.resource_country%TYPE;
1010: l_resource_region pa_resources_denorm.resource_region%TYPE;
1011: l_resource_city pa_resources_denorm.resource_city%TYPE;
1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;

Line 1009: l_resource_country pa_resources_denorm.resource_country%TYPE;

1005: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1006: ) IS
1007:
1008: l_resource_country_code pa_resources_denorm.resource_country_code%TYPE;
1009: l_resource_country pa_resources_denorm.resource_country%TYPE;
1010: l_resource_region pa_resources_denorm.resource_region%TYPE;
1011: l_resource_city pa_resources_denorm.resource_city%TYPE;
1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;
1013: l_employee_flag pa_resources_denorm.employee_flag%TYPE;

Line 1010: l_resource_region pa_resources_denorm.resource_region%TYPE;

1006: ) IS
1007:
1008: l_resource_country_code pa_resources_denorm.resource_country_code%TYPE;
1009: l_resource_country pa_resources_denorm.resource_country%TYPE;
1010: l_resource_region pa_resources_denorm.resource_region%TYPE;
1011: l_resource_city pa_resources_denorm.resource_city%TYPE;
1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;
1013: l_employee_flag pa_resources_denorm.employee_flag%TYPE;
1014: l_billable_flag pa_resources_denorm.billable_flag%TYPE;

Line 1011: l_resource_city pa_resources_denorm.resource_city%TYPE;

1007:
1008: l_resource_country_code pa_resources_denorm.resource_country_code%TYPE;
1009: l_resource_country pa_resources_denorm.resource_country%TYPE;
1010: l_resource_region pa_resources_denorm.resource_region%TYPE;
1011: l_resource_city pa_resources_denorm.resource_city%TYPE;
1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;
1013: l_employee_flag pa_resources_denorm.employee_flag%TYPE;
1014: l_billable_flag pa_resources_denorm.billable_flag%TYPE;
1015: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;

Line 1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;

1008: l_resource_country_code pa_resources_denorm.resource_country_code%TYPE;
1009: l_resource_country pa_resources_denorm.resource_country%TYPE;
1010: l_resource_region pa_resources_denorm.resource_region%TYPE;
1011: l_resource_city pa_resources_denorm.resource_city%TYPE;
1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;
1013: l_employee_flag pa_resources_denorm.employee_flag%TYPE;
1014: l_billable_flag pa_resources_denorm.billable_flag%TYPE;
1015: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;
1016: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;

Line 1013: l_employee_flag pa_resources_denorm.employee_flag%TYPE;

1009: l_resource_country pa_resources_denorm.resource_country%TYPE;
1010: l_resource_region pa_resources_denorm.resource_region%TYPE;
1011: l_resource_city pa_resources_denorm.resource_city%TYPE;
1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;
1013: l_employee_flag pa_resources_denorm.employee_flag%TYPE;
1014: l_billable_flag pa_resources_denorm.billable_flag%TYPE;
1015: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;
1016: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;
1017: l_return_status VARCHAR2(1);

Line 1014: l_billable_flag pa_resources_denorm.billable_flag%TYPE;

1010: l_resource_region pa_resources_denorm.resource_region%TYPE;
1011: l_resource_city pa_resources_denorm.resource_city%TYPE;
1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;
1013: l_employee_flag pa_resources_denorm.employee_flag%TYPE;
1014: l_billable_flag pa_resources_denorm.billable_flag%TYPE;
1015: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;
1016: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;
1017: l_return_status VARCHAR2(1);
1018: l_error_msg_code VARCHAR2(2000);

Line 1015: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;

1011: l_resource_city pa_resources_denorm.resource_city%TYPE;
1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;
1013: l_employee_flag pa_resources_denorm.employee_flag%TYPE;
1014: l_billable_flag pa_resources_denorm.billable_flag%TYPE;
1015: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;
1016: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;
1017: l_return_status VARCHAR2(1);
1018: l_error_msg_code VARCHAR2(2000);
1019: l_msg_count NUMBER;

Line 1016: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;

1012: l_resource_job_level pa_resources_denorm.resource_job_level%TYPE;
1013: l_employee_flag pa_resources_denorm.employee_flag%TYPE;
1014: l_billable_flag pa_resources_denorm.billable_flag%TYPE;
1015: l_utilization_flag pa_resources_denorm.utilization_flag%TYPE;
1016: l_schedulable_flag pa_resources_denorm.schedulable_flag%TYPE;
1017: l_return_status VARCHAR2(1);
1018: l_error_msg_code VARCHAR2(2000);
1019: l_msg_count NUMBER;
1020: l_first_time VARCHAR2(1) := 'Y';

Line 1022: l_rec_start_date pa_resources_denorm.resource_effective_start_date%TYPE;

1018: l_error_msg_code VARCHAR2(2000);
1019: l_msg_count NUMBER;
1020: l_first_time VARCHAR2(1) := 'Y';
1021: l_null_location VARCHAR2(1) := 'N';
1022: l_rec_start_date pa_resources_denorm.resource_effective_start_date%TYPE;
1023: l_rec_end_date pa_resources_denorm.resource_effective_end_date%TYPE;
1024:
1025:
1026: CURSOR denormalized_locations (l_person_id IN NUMBER, l_asgn_start_date IN DATE, l_asgn_end_date IN DATE ) IS

Line 1023: l_rec_end_date pa_resources_denorm.resource_effective_end_date%TYPE;

1019: l_msg_count NUMBER;
1020: l_first_time VARCHAR2(1) := 'Y';
1021: l_null_location VARCHAR2(1) := 'N';
1022: l_rec_start_date pa_resources_denorm.resource_effective_start_date%TYPE;
1023: l_rec_end_date pa_resources_denorm.resource_effective_end_date%TYPE;
1024:
1025:
1026: CURSOR denormalized_locations (l_person_id IN NUMBER, l_asgn_start_date IN DATE, l_asgn_end_date IN DATE ) IS
1027: SELECT date_from,

Line 1047: -- The delete logic deletes all overlapping records in pa_resources_denorm

1043: -- Initialize the return status to success
1044: x_return_status := FND_API.G_RET_STS_SUCCESS;
1045:
1046:
1047: -- The delete logic deletes all overlapping records in pa_resources_denorm
1048: -- for the incoming assignment record
1049: -- This logic also works with location denormalization changes.
1050: DELETE FROM pa_resources_denorm
1051: WHERE person_id = p_resource_source_id

Line 1050: DELETE FROM pa_resources_denorm

1046:
1047: -- The delete logic deletes all overlapping records in pa_resources_denorm
1048: -- for the incoming assignment record
1049: -- This logic also works with location denormalization changes.
1050: DELETE FROM pa_resources_denorm
1051: WHERE person_id = p_resource_source_id
1052: AND resource_effective_start_date <= p_assignment_end_date
1053: AND resource_effective_end_date >= p_assignment_start_date
1054: ;

Line 1125: -- and creates 1 record in pa_resources_denorm for every different location

1121: END IF;
1122:
1123: -- Location denormalization changes involve the following
1124: -- Code loops through all the different location records of a HR assignment
1125: -- and creates 1 record in pa_resources_denorm for every different location
1126: -- of a HR assignment
1127: OPEN denormalized_locations(p_resource_source_id, p_assignment_start_date, p_assignment_end_date);
1128:
1129: LOOP

Line 1156: INSERT INTO PA_RESOURCES_DENORM ( person_id

1152: IF l_null_location = 'Y' THEN
1153:
1154: l_rec_start_date := p_assignment_start_date;
1155:
1156: INSERT INTO PA_RESOURCES_DENORM ( person_id
1157: , resource_id
1158: , resource_name
1159: , resource_type
1160: , resource_org_id

Line 1265: proceeding on inserting into pa_resources_denorm. This will show the

1261: x_return_status => l_return_status,
1262: x_error_message_code => l_error_msg_code);
1263:
1264: /* Bug 5689674: Added the below exception handling to throw an error without
1265: proceeding on inserting into pa_resources_denorm. This will show the
1266: error as an exception in the report output. */
1267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1268: IF l_error_msg_code IS NOT NULL THEN
1269: pa_utils.add_message

Line 1277: INSERT INTO PA_RESOURCES_DENORM ( person_id

1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275: /* End of changes for Bug 5689674 */
1276:
1277: INSERT INTO PA_RESOURCES_DENORM ( person_id
1278: , resource_id
1279: , resource_name
1280: , resource_type
1281: , resource_org_id

Line 1417: -- g_manager_resource_id - manager's resource_id from pa_resources_denorm

1413: -- FUNCTION : Get_Manager_Id
1414: -- DESCRIPTION: This function gets the manager_id for a given project. It returns
1415: -- null if there is no manager. Also sets the following global variables
1416: -- g_manager_name - manager name
1417: -- g_manager_resource_id - manager's resource_id from pa_resources_denorm
1418: -- This API is used specifically in views pa_project_open_assns_v
1419: -- and pa_project_open_assns_staff_v
1420: --
1421: ------------------------------------------------------------------------------------

Line 1442: from pa_resources_denorm

1438: -- end -- 18-AUG-2008 cklee Fixed bug: 6708404
1439:
1440: select resource_name
1441: into g_manager_name
1442: from pa_resources_denorm
1443: where person_id = l_party_id
1444: and trunc(sysdate) between resource_effective_start_date and resource_effective_end_date;
1445:
1446: select resource_id

Line 1448: from pa_resources_denorm

1444: and trunc(sysdate) between resource_effective_start_date and resource_effective_end_date;
1445:
1446: select resource_id
1447: into g_manager_resource_id
1448: from pa_resources_denorm
1449: where person_id = l_party_id
1450: and trunc(sysdate) between resource_effective_start_date and resource_effective_end_date;
1451:
1452: g_project_id := p_project_id; /* Bug#2604495 Setting the Global variable's value */

Line 2751: from pa_resources_denorm

2747: --earlier than min. resource start date
2748: --------------------------------------------------
2749: select min(RESOURCE_EFFECTIVE_START_DATE)
2750: into l_earliest_start_date
2751: from pa_resources_denorm
2752: where RESOURCE_ID = p_resource_id;
2753:
2754: update pa_res_availability
2755: set start_date = l_earliest_start_date

Line 2853: from pa_resources_denorm

2849: BEGIN
2850:
2851: select min(resource_effective_start_date)
2852: into l_start_date
2853: from pa_resources_denorm
2854: where resource_id = p_resource_id;
2855:
2856: /*bug 3229929 modified min(resource_effective_end_date) to max(resource_effective_end_date) */
2857: select max(resource_effective_end_date)

Line 2859: from pa_resources_denorm

2855:
2856: /*bug 3229929 modified min(resource_effective_end_date) to max(resource_effective_end_date) */
2857: select max(resource_effective_end_date)
2858: into l_end_date
2859: from pa_resources_denorm
2860: where resource_id = p_resource_id;
2861:
2862: EXCEPTION
2863: WHEN NO_DATA_FOUND THEN

Line 2937: from pa_resources_denorm

2933: CURSOR resources IS
2934: select resource_id,
2935: min(resource_effective_start_date) start_date,
2936: max(resource_effective_end_date) end_date
2937: from pa_resources_denorm
2938: group by resource_id;
2939:
2940: CURSOR redundant_resources IS -- Added for bug 7316435
2941: select resource_id

Line 2943: where resource_id not in (Select resource_id from pa_resources_denorm)

2939:
2940: CURSOR redundant_resources IS -- Added for bug 7316435
2941: select resource_id
2942: from pa_res_availability
2943: where resource_id not in (Select resource_id from pa_resources_denorm)
2944: and resource_id <> -1;
2945:
2946: l_res_count Number; --Added for bug 4928773
2947: