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 393: -- Purpose : Populates global temp table PA_TIME_CHART_TEMP with

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

Line 411: -- PA_TIME_CHART_TEMP before creating new records.

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

Line 488: INSERT INTO pa_time_chart_temp (

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

Line 555: INSERT INTO pa_time_chart_temp (

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

Line 593: INSERT INTO pa_time_chart_temp (

589: 'STAFFED_ASGMT_PROV'))
590: );
591:
592: ELSIF g_availability_cal_period = 'DAILY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
593: INSERT INTO pa_time_chart_temp (
594: select 'RESOURCE' time_chart_record_type,
595: resource_id row_label_id,
596: global_exp_period_end_date-6 start_date,
597: global_exp_period_end_date end_date,

Line 666: INSERT INTO pa_time_chart_temp (

662: col.render_priority
663: );
664:
665: ELSIF g_availability_cal_period = 'DAILY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
666: INSERT INTO pa_time_chart_temp (
667: select 'RESOURCE' time_chart_record_type,
668: fi.resource_id row_label_id,
669: fi.global_exp_period_end_date-6 start_date,
670: fi.global_exp_period_end_date end_date,

Line 708: INSERT INTO pa_time_chart_temp (

704: col.render_priority
705: );
706:
707: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license = 'Y' THEN
708: INSERT INTO pa_time_chart_temp (
709: select 'RESOURCE' time_chart_record_type,
710: fi.resource_id row_label_id,
711: fi.item_date start_date,
712: fi.item_date end_date,

Line 790: INSERT INTO pa_time_chart_temp (

786: 'STAFFED_ASGMT_PROV'))
787: );
788:
789: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
790: INSERT INTO pa_time_chart_temp (
791: select 'RESOURCE' time_chart_record_type,
792: fi.resource_id row_label_id,
793: fi.item_date start_date,
794: fi.item_date end_date,

Line 827: INSERT INTO pa_time_chart_temp (

823: 'STAFFED_ASGMT_PROV'))
824: );
825:
826: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
827: INSERT INTO pa_time_chart_temp (
828: select 'RESOURCE' time_chart_record_type,
829: fi.resource_id row_label_id,
830: fi.global_exp_period_end_date-6 start_date,
831: fi.global_exp_period_end_date end_date,

Line 919: INSERT INTO pa_time_chart_temp (

915: col.render_priority
916: );
917:
918: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
919: INSERT INTO pa_time_chart_temp (
920: select 'RESOURCE' time_chart_record_type,
921: fi.resource_id row_label_id,
922: fi.global_exp_period_end_date-6 start_date,
923: fi.global_exp_period_end_date end_date,

Line 964: INSERT INTO pa_time_chart_temp (

960:
961: -- Resource Details Timeline
962: ELSIF p_timeline_type = 'ResourceAssignments' THEN
963: IF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license = 'Y' THEN
964: INSERT INTO pa_time_chart_temp (
965: select
966: decode(fi.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED')time_chart_record_type,
967: decode(fi.availability_flag, 'Y', -99, 'N', -100) row_label_id,
968: fi.item_date start_date,

Line 1022: INSERT INTO pa_time_chart_temp (

1018: 'STAFFED_ASGMT_PROV'))
1019: );
1020:
1021: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1022: INSERT INTO pa_time_chart_temp (
1023: select
1024: 'ASSIGNMENT' time_chart_record_type,
1025: fi.assignment_id row_label_id,fi.item_date start_date,
1026: fi.item_date end_date,

Line 1059: INSERT INTO pa_time_chart_temp (

1055: 'STAFFED_ASGMT_PROV'))
1056: );
1057:
1058: ELSIF g_availability_cal_period = 'DAILY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
1059: INSERT INTO pa_time_chart_temp (
1060: select
1061: decode(fi.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1062: decode(fi.availability_flag, 'Y', -99, 'N', -100) row_label_id,
1063: fi.global_exp_period_end_date - 6 start_date,

Line 1127: INSERT INTO pa_time_chart_temp (

1123: col.render_priority
1124: );
1125:
1126: ELSIF g_availability_cal_period = 'DAILY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
1127: INSERT INTO pa_time_chart_temp (
1128: select
1129: 'ASSIGNMENT' time_chart_record_type,
1130: fi.assignment_id row_label_id,
1131: fi.global_exp_period_end_date-6 start_date,

Line 1170: INSERT INTO pa_time_chart_temp (

1166: );
1167:
1168: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license = 'Y' THEN
1169: pa_timeline_util.debug('Resource Details: weekly month');
1170: INSERT INTO pa_time_chart_temp (
1171: select
1172: decode(fi_week.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1173: decode(fi_week.availability_flag, 'Y', -99, 'N', -100) row_label_id,
1174: fi.item_date start_date,

Line 1247: INSERT INTO pa_time_chart_temp (

1243: );
1244:
1245: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1246: pa_timeline_util.debug('Resource Details: weekly month');
1247: INSERT INTO pa_time_chart_temp (
1248: select
1249: 'ASSIGNMENT' time_chart_record_type,
1250: fi.assignment_id row_label_id,
1251: fi.item_date start_date,

Line 1286: INSERT INTO pa_time_chart_temp (

1282: );
1283:
1284: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
1285: pa_timeline_util.debug('Resource Details: weekly | three_month');
1286: INSERT INTO pa_time_chart_temp (
1287: select
1288: decode(fi_week.availability_flag, 'Y', 'AVAILABLE', 'N', 'OVERCOMMITTED') time_chart_record_type,
1289: decode(fi_week.availability_flag, 'Y', -99, 'N', -100) row_label_id,
1290: fi.global_exp_period_end_date-6 start_date,

Line 1372: INSERT INTO pa_time_chart_temp (

1368: );
1369:
1370: ELSIF g_availability_cal_period = 'WEEKLY' AND p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
1371: pa_timeline_util.debug('Resource Details: weekly | three_month');
1372: INSERT INTO pa_time_chart_temp (
1373: select
1374: 'ASSIGNMENT' time_chart_record_type,
1375: fi.assignment_id row_label_id,
1376: fi.global_exp_period_end_date-6 start_date,

Line 1419: INSERT INTO pa_time_chart_temp (

1415:
1416: -- Resource Overcommitment Timeline
1417: ELSIF p_timeline_type = 'ResourceOvercommitmentCalc' THEN
1418: IF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license = 'Y' THEN
1419: INSERT INTO pa_time_chart_temp (
1420: select
1421: 'OVERCOMMITTED' time_chart_record_type,
1422: -100 row_label_id,
1423: fi.item_date start_date,

Line 1534: INSERT INTO pa_time_chart_temp (

1530: 'STAFFED_ASGMT_PROV'))
1531: );
1532:
1533: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1534: INSERT INTO pa_time_chart_temp (
1535: select
1536: 'ASSIGNMENT' time_chart_record_type,
1537: fi.assignment_id row_label_id,fi.item_date start_date,
1538: fi.item_date end_date,

Line 1571: INSERT INTO pa_time_chart_temp (

1567: 'STAFFED_ASGMT_PROV'))
1568: );
1569:
1570: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
1571: INSERT INTO pa_time_chart_temp (
1572: select
1573: 'OVERCOMMITTED' time_chart_record_type,
1574: -100 row_label_id,
1575: fi.global_exp_period_end_date - 6 start_date,

Line 1695: INSERT INTO pa_time_chart_temp (

1691: col.render_priority
1692: );
1693:
1694: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
1695: INSERT INTO pa_time_chart_temp (
1696: select
1697: 'ASSIGNMENT' time_chart_record_type,
1698: fi.assignment_id row_label_id,
1699: fi.global_exp_period_end_date-6 start_date,

Line 1737: INSERT INTO pa_time_chart_temp (

1733: col.render_priority
1734: );
1735:
1736: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'MONTH' and prm_license = 'Y' THEN
1737: INSERT INTO pa_time_chart_temp (
1738: select
1739: 'OVERCOMMITTED' time_chart_record_type,
1740: -100 row_label_id,
1741: fi.item_date start_date,

Line 1927: INSERT INTO pa_time_chart_temp (

1923: 'STAFFED_ASGMT_PROV'))
1924: );
1925:
1926: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
1927: INSERT INTO pa_time_chart_temp (
1928: select
1929: 'ASSIGNMENT' time_chart_record_type,
1930: fi.assignment_id row_label_id,
1931: fi.item_date start_date,

Line 1965: INSERT INTO pa_time_chart_temp (

1961: 'STAFFED_ASGMT_PROV'))
1962: );
1963:
1964: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
1965: INSERT INTO pa_time_chart_temp (
1966: select
1967: 'OVERCOMMITTED' time_chart_record_type,
1968: -100 row_label_id,
1969: fi_week.global_exp_period_end_date-6 start_date,

Line 2096: INSERT INTO pa_time_chart_temp (

2092: col.file_name
2093: );
2094:
2095: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
2096: INSERT INTO pa_time_chart_temp (
2097: select
2098: 'ASSIGNMENT' time_chart_record_type,
2099: fi.assignment_id row_label_id,
2100: fi.global_exp_period_end_date-6 start_date,

Line 2143: INSERT INTO pa_time_chart_temp (

2139: -- Team List Timeline.
2140: ELSIF p_timeline_type = 'ProjectAssignments' THEN
2141:
2142: IF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license = 'Y' THEN
2143: INSERT INTO pa_time_chart_temp (
2144: select
2145: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2146: fi1.assignment_id row_label_id,
2147: fi1.item_date start_date,

Line 2260: INSERT INTO pa_time_chart_temp (

2256: and fi_overcom.overcommitment_quantity > 0
2257: );
2258:
2259: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
2260: INSERT INTO pa_time_chart_temp (
2261: select
2262: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2263: fi1.assignment_id row_label_id,
2264: fi1.item_date start_date,

Line 2341: INSERT INTO pa_time_chart_temp (

2337: End of commenting for bug 3280808 */
2338: );
2339:
2340: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'THREE_MONTH' and prm_license = 'Y' THEN
2341: INSERT INTO pa_time_chart_temp (
2342: select
2343: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2344: fi1.assignment_id row_label_id,
2345: fi1.global_exp_period_end_date-6 start_date,

Line 2471: INSERT INTO pa_time_chart_temp (

2467: col.render_priority
2468: );
2469:
2470: ELSIF g_availability_cal_period = 'DAILY' and p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
2471: INSERT INTO pa_time_chart_temp (
2472: select
2473: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2474: fi1.assignment_id row_label_id,
2475: fi1.global_exp_period_end_date-6 start_date,

Line 2570: INSERT INTO pa_time_chart_temp (

2566: -- PA_PROJECT_ASSIGNMENTS and Further filtering on DELETE FLAG ('N')
2567: -- As DELETE_FLAG having value 'Y' are records which are eligible
2568: -- purge and we need not scan them too.
2569: ------------------------------------------------------------------
2570: INSERT INTO pa_time_chart_temp (
2571: select
2572: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2573: fi1.assignment_id row_label_id,
2574: fi1.item_date start_date,

Line 2731: INSERT INTO pa_time_chart_temp (

2727: and fi_overcom.overcommitment_quantity > 0
2728: );
2729:
2730: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'MONTH' and prm_license <> 'Y' THEN
2731: INSERT INTO pa_time_chart_temp (
2732: select
2733: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2734: fi1.assignment_id row_label_id,
2735: fi1.item_date start_date,

Line 2820: INSERT INTO pa_time_chart_temp (

2816: -- PA_PROJECT_ASSIGNMENTS and Further filtering on DELETE FLAG ('N')
2817: -- As DELETE_FLAG having value 'Y' are records which are eligible
2818: -- purge and we need not scan them too.
2819: ------------------------------------------------------------------
2820: INSERT INTO pa_time_chart_temp (
2821: select
2822: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2823: fi1.assignment_id row_label_id,
2824: fi1.global_exp_period_end_date-6 start_date,

Line 2994: INSERT INTO pa_time_chart_temp (

2990: col.render_priority
2991: );
2992:
2993: ELSIF g_availability_cal_period = 'WEEKLY' and p_scale_type = 'THREE_MONTH' and prm_license <> 'Y' THEN
2994: INSERT INTO pa_time_chart_temp (
2995: select
2996: decode(fi1.forecast_item_type, 'A', 'ASSIGNMENT', 'R', 'REQUIREMENT') time_chart_record_type,
2997: fi1.assignment_id row_label_id,
2998: fi1.global_exp_period_end_date-6 start_date,