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_TIMELINE_PVT dependencies on PA_TIME_CHART_TEMP

Line 394: -- Purpose : Populates global temp table PA_TIME_CHART_TEMP with

390: END copy_open_asgn_timeline;
391:
392:
393: -- Procedure : populate_time_chart_table
394: -- Purpose : Populates global temp table PA_TIME_CHART_TEMP with
395: -- time chart records. The procedure is called from
396: -- front end to display timeline.
397: -- Input parameters
398: -- Parameters Required Description

Line 412: -- PA_TIME_CHART_TEMP before creating new records.

408: -- p_end_date Yes The end date of the time chart.
409: -- p_scale_type Yes The scale type of the time chart. Valid
410: -- values include: 'THREE_MONTH', 'MONTH'.
411: -- p_delete_flag No If 'Y', all records are deleted from
412: -- PA_TIME_CHART_TEMP before creating new records.
413: -- Otherwise, no records are deleted.
414: -- x_return_status Yes Return status code.
415: -- x_msg_count Yes Message count.
416: -- x_msg_data Yes Message data.

Line 489: INSERT INTO pa_time_chart_temp (

485: END IF;
486:
487: IF p_timeline_type = 'ResourceSchedules' THEN
488: IF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license = 'Y' THEN
489: INSERT INTO pa_time_chart_temp (
490: select
491: 'RESOURCE' time_chart_record_type,
492: resource_id row_label_id,
493: item_date start_date,

Line 559: INSERT INTO pa_time_chart_temp (

555: 'STAFFED_ASGMT_PROV'))
556: );
557:
558: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
559: INSERT INTO pa_time_chart_temp (
560: select
561: 'RESOURCE' time_chart_record_type,
562: fi.resource_id row_label_id,
563: fi.item_date start_date,

Line 598: INSERT INTO pa_time_chart_temp (

594: 'STAFFED_ASGMT_PROV'))
595: );
596:
597: ELSIF g_availability_cal_period = 'DAILY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
598: INSERT INTO pa_time_chart_temp (
599: select 'RESOURCE' time_chart_record_type,
600: resource_id row_label_id,
601: global_exp_period_end_date-6 start_date,
602: global_exp_period_end_date end_date,

Line 674: INSERT INTO pa_time_chart_temp (

670: col.render_priority
671: );
672:
673: ELSIF g_availability_cal_period = 'DAILY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
674: INSERT INTO pa_time_chart_temp (
675: select 'RESOURCE' time_chart_record_type,
676: fi.resource_id row_label_id,
677: fi.global_exp_period_end_date-6 start_date,
678: fi.global_exp_period_end_date end_date,

Line 717: INSERT INTO pa_time_chart_temp (

713: col.render_priority
714: );
715:
716: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license = 'Y' THEN
717: INSERT INTO pa_time_chart_temp (
718: select 'RESOURCE' time_chart_record_type,
719: fi.resource_id row_label_id,
720: fi.item_date start_date,
721: fi.item_date end_date,

Line 801: INSERT INTO pa_time_chart_temp (

797: 'STAFFED_ASGMT_PROV'))
798: );
799:
800: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
801: INSERT INTO pa_time_chart_temp (
802: select 'RESOURCE' time_chart_record_type,
803: fi.resource_id row_label_id,
804: fi.item_date start_date,
805: fi.item_date end_date,

Line 839: INSERT INTO pa_time_chart_temp (

835: 'STAFFED_ASGMT_PROV'))
836: );
837:
838: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
839: INSERT INTO pa_time_chart_temp (
840: select 'RESOURCE' time_chart_record_type,
841: fi.resource_id row_label_id,
842: fi.global_exp_period_end_date-6 start_date,
843: fi.global_exp_period_end_date end_date,

Line 934: INSERT INTO pa_time_chart_temp (

930: col.render_priority
931: );
932:
933: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
934: INSERT INTO pa_time_chart_temp (
935: select 'RESOURCE' time_chart_record_type,
936: fi.resource_id row_label_id,
937: fi.global_exp_period_end_date-6 start_date,
938: fi.global_exp_period_end_date end_date,

Line 980: INSERT INTO pa_time_chart_temp (

976:
977: -- Resource Details Timeline
978: ELSIF p_timeline_type = 'ResourceAssignments' THEN
979: IF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license = 'Y' THEN
980: INSERT INTO pa_time_chart_temp (
981: select
982: decode(fi.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED')time_chart_record_type,
983: decode(fi.availability_flag, 'Y', -99, 'N', -100) row_label_id,
984: fi.item_date start_date,

Line 1041: INSERT INTO pa_time_chart_temp (

1037: 'STAFFED_ASGMT_PROV'))
1038: );
1039:
1040: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1041: INSERT INTO pa_time_chart_temp (
1042: select
1043: 'ASSIGNMENT' time_chart_record_type,
1044: fi.assignment_id row_label_id,fi.item_date start_date,
1045: fi.item_date end_date,

Line 1079: INSERT INTO pa_time_chart_temp (

1075: 'STAFFED_ASGMT_PROV'))
1076: );
1077:
1078: ELSIF g_availability_cal_period = 'DAILY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
1079: INSERT INTO pa_time_chart_temp (
1080: select
1081: decode(fi.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1082: decode(fi.availability_flag, 'Y', -99, 'N', -100) row_label_id,
1083: fi.global_exp_period_end_date - 6 start_date,

Line 1150: INSERT INTO pa_time_chart_temp (

1146: col.render_priority
1147: );
1148:
1149: ELSIF g_availability_cal_period = 'DAILY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
1150: INSERT INTO pa_time_chart_temp (
1151: select
1152: 'ASSIGNMENT' time_chart_record_type,
1153: fi.assignment_id row_label_id,
1154: fi.global_exp_period_end_date-6 start_date,

Line 1194: INSERT INTO pa_time_chart_temp (

1190: );
1191:
1192: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license = 'Y' THEN
1193: pa_timeline_util.debug('Resource Details: weekly month');
1194: INSERT INTO pa_time_chart_temp (
1195: select
1196: decode(fi_week.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1197: decode(fi_week.availability_flag, 'Y', -99, 'N', -100) row_label_id,
1198: fi.item_date start_date,

Line 1274: INSERT INTO pa_time_chart_temp (

1270: );
1271:
1272: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1273: pa_timeline_util.debug('Resource Details: weekly month');
1274: INSERT INTO pa_time_chart_temp (
1275: select
1276: 'ASSIGNMENT' time_chart_record_type,
1277: fi.assignment_id row_label_id,
1278: fi.item_date start_date,

Line 1314: INSERT INTO pa_time_chart_temp (

1310: );
1311:
1312: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
1313: pa_timeline_util.debug('Resource Details: weekly | three_month');
1314: INSERT INTO pa_time_chart_temp (
1315: select
1316: decode(fi_week.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1317: decode(fi_week.availability_flag, 'Y', -99, 'N', -100) row_label_id,
1318: fi.global_exp_period_end_date-6 start_date,

Line 1403: INSERT INTO pa_time_chart_temp (

1399: );
1400:
1401: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
1402: pa_timeline_util.debug('Resource Details: weekly | three_month');
1403: INSERT INTO pa_time_chart_temp (
1404: select
1405: 'ASSIGNMENT' time_chart_record_type,
1406: fi.assignment_id row_label_id,
1407: fi.global_exp_period_end_date-6 start_date,

Line 1451: INSERT INTO pa_time_chart_temp (

1447:
1448: -- Resource Overcommitment Timeline
1449: ELSIF p_timeline_type = 'ResourceOvercommitmentCalc' THEN
1450: IF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license = 'Y' THEN
1451: INSERT INTO pa_time_chart_temp (
1452: select
1453: 'OVERCOMMITTED' time_chart_record_type,
1454: -100 row_label_id,
1455: fi.item_date start_date,

Line 1568: INSERT INTO pa_time_chart_temp (

1564: 'STAFFED_ASGMT_PROV'))
1565: );
1566:
1567: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1568: INSERT INTO pa_time_chart_temp (
1569: select
1570: 'ASSIGNMENT' time_chart_record_type,
1571: fi.assignment_id row_label_id,fi.item_date start_date,
1572: fi.item_date end_date,

Line 1606: INSERT INTO pa_time_chart_temp (

1602: 'STAFFED_ASGMT_PROV'))
1603: );
1604:
1605: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
1606: INSERT INTO pa_time_chart_temp (
1607: select
1608: 'OVERCOMMITTED' time_chart_record_type,
1609: -100 row_label_id,
1610: fi.global_exp_period_end_date - 6 start_date,

Line 1732: INSERT INTO pa_time_chart_temp (

1728: col.render_priority
1729: );
1730:
1731: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
1732: INSERT INTO pa_time_chart_temp (
1733: select
1734: 'ASSIGNMENT' time_chart_record_type,
1735: fi.assignment_id row_label_id,
1736: fi.global_exp_period_end_date-6 start_date,

Line 1775: INSERT INTO pa_time_chart_temp (

1771: col.render_priority
1772: );
1773:
1774: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'MONTH' and prm_license = 'Y' THEN
1775: INSERT INTO pa_time_chart_temp (
1776: select
1777: 'OVERCOMMITTED' time_chart_record_type,
1778: -100 row_label_id,
1779: fi.item_date start_date,

Line 1967: INSERT INTO pa_time_chart_temp (

1963: 'STAFFED_ASGMT_PROV'))
1964: );
1965:
1966: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1967: INSERT INTO pa_time_chart_temp (
1968: select
1969: 'ASSIGNMENT' time_chart_record_type,
1970: fi.assignment_id row_label_id,
1971: fi.item_date start_date,

Line 2006: INSERT INTO pa_time_chart_temp (

2002: 'STAFFED_ASGMT_PROV'))
2003: );
2004:
2005: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
2006: INSERT INTO pa_time_chart_temp (
2007: select
2008: 'OVERCOMMITTED' time_chart_record_type,
2009: -100 row_label_id,
2010: fi_week.global_exp_period_end_date-6 start_date,

Line 2138: INSERT INTO pa_time_chart_temp (

2134: col.file_name
2135: );
2136:
2137: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
2138: INSERT INTO pa_time_chart_temp (
2139: select
2140: 'ASSIGNMENT' time_chart_record_type,
2141: fi.assignment_id row_label_id,
2142: fi.global_exp_period_end_date-6 start_date,

Line 2186: INSERT INTO pa_time_chart_temp (

2182: -- Team List Timeline.
2183: ELSIF p_timeline_type = 'ProjectAssignments' THEN
2184:
2185: IF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license = 'Y' THEN
2186: INSERT INTO pa_time_chart_temp (
2187: select
2188: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2189: fi1.assignment_id row_label_id,
2190: fi1.item_date start_date,

Line 2305: INSERT INTO pa_time_chart_temp (

2301: and fi_overcom.overcommitment_quantity > 0
2302: );
2303:
2304: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
2305: INSERT INTO pa_time_chart_temp (
2306: select
2307: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2308: fi1.assignment_id row_label_id,
2309: fi1.item_date start_date,

Line 2387: INSERT INTO pa_time_chart_temp (

2383: End of commenting for bug 3280808 */
2384: );
2385:
2386: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
2387: INSERT INTO pa_time_chart_temp (
2388: select
2389: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2390: fi1.assignment_id row_label_id,
2391: fi1.global_exp_period_end_date-6 start_date,

Line 2519: INSERT INTO pa_time_chart_temp (

2515: col.render_priority
2516: );
2517:
2518: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
2519: INSERT INTO pa_time_chart_temp (
2520: select
2521: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2522: fi1.assignment_id row_label_id,
2523: fi1.global_exp_period_end_date-6 start_date,

Line 2619: INSERT INTO pa_time_chart_temp (

2615: -- PA_PROJECT_ASSIGNMENTS and Further filtering on DELETE FLAG ('N')
2616: -- As DELETE_FLAG having value 'Y' are records which are eligible
2617: -- purge and we need not scan them too.
2618: ------------------------------------------------------------------
2619: INSERT INTO pa_time_chart_temp (
2620: select
2621: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2622: fi1.assignment_id row_label_id,
2623: fi1.item_date start_date,

Line 2782: INSERT INTO pa_time_chart_temp (

2778: and fi_overcom.overcommitment_quantity > 0
2779: );
2780:
2781: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
2782: INSERT INTO pa_time_chart_temp (
2783: select
2784: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2785: fi1.assignment_id row_label_id,
2786: fi1.item_date start_date,

Line 2872: INSERT INTO pa_time_chart_temp (

2868: -- PA_PROJECT_ASSIGNMENTS and Further filtering on DELETE FLAG ('N')
2869: -- As DELETE_FLAG having value 'Y' are records which are eligible
2870: -- purge and we need not scan them too.
2871: ------------------------------------------------------------------
2872: INSERT INTO pa_time_chart_temp (
2873: select
2874: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2875: fi1.assignment_id row_label_id,
2876: fi1.global_exp_period_end_date-6 start_date,

Line 3048: INSERT INTO pa_time_chart_temp (

3044: col.render_priority
3045: );
3046:
3047: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
3048: INSERT INTO pa_time_chart_temp (
3049: select
3050: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
3051: fi1.assignment_id row_label_id,
3052: fi1.global_exp_period_end_date-6 start_date,