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_PROJ_ACCUM_MAIN dependencies on PA_PROJECTS_FOR_ACCUM

Line 797: /* pa_projects_for_accum table */

793: x_PrjSumStart DATE := NULL; /* Start time for Project Summary */
794: x_PrjSumEnd DATE := NULL; /* End time for Project Summary */
795:
796: x_InsertStart DATE := NULL; /* Start time for Insert onto */
797: /* pa_projects_for_accum table */
798: x_InsertEnd DATE := NULL; /* End time for Insert onto */
799: /* pa_projects_for_accum table */
800:
801: l_accum_period_type_changed BOOLEAN;

Line 799: /* pa_projects_for_accum table */

795:
796: x_InsertStart DATE := NULL; /* Start time for Insert onto */
797: /* pa_projects_for_accum table */
798: x_InsertEnd DATE := NULL; /* End time for Insert onto */
799: /* pa_projects_for_accum table */
800:
801: l_accum_period_type_changed BOOLEAN;
802: l_project_num_from VARCHAR2(25);
803: l_project_num_to VARCHAR2(25);

Line 836: FROM pa_projects_for_accum pfa

832: -- TM is when unaccumulated commitments exist in pa_txn_accum
833:
834: CURSOR all_projs IS
835: SELECT DISTINCT pfa.project_id, pfa.segment1
836: FROM pa_projects_for_accum pfa
837: WHERE pfa.request_id = x_request_id
838: AND pfa.segment1
839: BETWEEN l_project_num_from AND l_project_num_to
840: AND pfa.action_flag IN ('CS', 'RV', 'RL', 'CM', 'BD', 'PR', 'TX', 'TM')

Line 842: FROM pa_projects_for_accum pf

838: AND pfa.segment1
839: BETWEEN l_project_num_from AND l_project_num_to
840: AND pfa.action_flag IN ('CS', 'RV', 'RL', 'CM', 'BD', 'PR', 'TX', 'TM')
841: AND NOT EXISTS (SELECT pf.project_id
842: FROM pa_projects_for_accum pf
843: WHERE pf.request_id = pfa.request_id
844: AND pf.segment1 = pfa.segment1 -- Bug3653978. replaced pfa.project_id with pfa.segment1
845: AND pf.action_flag IN
846: ('PT', 'CL', 'BK', 'TR'));

Line 856: FROM pa_projects_for_accum pfa

852: */
853: /*Added for bug 5635857*/
854: CURSOR all_cm_projs IS
855: SELECT DISTINCT pfa.project_id
856: FROM pa_projects_for_accum pfa
857: WHERE pfa.request_id = x_request_id
858: AND pfa.segment1
859: BETWEEN l_project_num_from AND l_project_num_to
860: AND pfa.action_flag = 'CM'

Line 862: FROM pa_projects_for_accum pf

858: AND pfa.segment1
859: BETWEEN l_project_num_from AND l_project_num_to
860: AND pfa.action_flag = 'CM'
861: AND NOT EXISTS (SELECT pf.project_id
862: FROM pa_projects_for_accum pf
863: WHERE pf.request_id = pfa.request_id
864: AND pf.segment1 = pfa.segment1 -- Bug3783746. replaced pf.project_id with pfa.segment1
865: AND pf.action_flag IN
866: ('PT', 'CL', 'BK', 'TR'));

Line 870: FROM pa_projects_for_accum pfa

866: ('PT', 'CL', 'BK', 'TR'));
867:
868: CURSOR action_found IS
869: SELECT pfa.action_flag
870: FROM pa_projects_for_accum pfa
871: WHERE pfa.segment1 = l_segment1
872: AND pfa.request_id = x_request_id ;
873:
874: CURSOR not_valid_proj IS

Line 876: FROM pa_projects_for_accum pfa

872: AND pfa.request_id = x_request_id ;
873:
874: CURSOR not_valid_proj IS
875: SELECT pfa.project_id, pfa.segment1, pfa.action_flag
876: FROM pa_projects_for_accum pfa
877: WHERE pfa.request_id = x_request_id
878: AND pfa.action_flag IN ('PT', 'CL', 'BK', 'TR')
879: ORDER BY pfa.segment1, pfa.action_flag ;
880:

Line 898: FROM pa_projects_for_accum_v proj

894: /* Added for bug 1751445 Cause Performance */
895: /*Commented for perf bug #3672175 and redefined below */
896: /* CURSOR all_valid_proj IS
897: SELECT DISTINCT proj.project_id, proj.segment1
898: FROM pa_projects_for_accum_v proj
899: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
900: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
901: AND NOT EXISTS (SELECT 1
902: FROM pa_projects_for_accum proj_invalid

Line 902: FROM pa_projects_for_accum proj_invalid

898: FROM pa_projects_for_accum_v proj
899: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
900: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
901: AND NOT EXISTS (SELECT 1
902: FROM pa_projects_for_accum proj_invalid
903: WHERE proj_invalid.project_id = proj.project_id
904: AND proj_invalid.action_flag IN ('PT','CL','BK','TR')
905: AND proj_invalid.request_id+0 = x_request_id);*/
906: CURSOR all_valid_proj IS

Line 918: FROM pa_projects_for_accum proj_invalid

914: AND NVL(proj.template_flag,'N') <> 'Y'
915: AND proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
916: AND proj.project_type = NVL(x_project_type, project_type)
917: AND NOT EXISTS (SELECT 1
918: FROM pa_projects_for_accum proj_invalid
919: WHERE proj_invalid.project_id = proj.project_id
920: AND proj_invalid.action_flag IN ('PT','CL','BK','TR')
921: AND proj_invalid.request_id = x_request_id)
922: UNION

Line 932: FROM pa_projects_for_accum proj_invalid

928: AND alloc.run_id = pa_accum_utils.Get_grouping_id)
929: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'
930: AND proj.project_type = NVL(x_project_type, project_type)
931: AND NOT EXISTS (SELECT 1
932: FROM pa_projects_for_accum proj_invalid
933: WHERE proj_invalid.project_id = proj.project_id
934: AND proj_invalid.action_flag IN ('PT','CL','BK','TR')
935: AND proj_invalid.request_id = x_request_id); /*Code redefined for bug#3672175 ends here*/
936: filter_proj not_valid_proj%ROWTYPE ;

Line 1026: -- inserts records onto pa_projects_for_accum

1022: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1023: Pa_Accum_Utils.G_context := x_summ_context;
1024: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1025:
1026: -- inserts records onto pa_projects_for_accum
1027:
1028: BEGIN
1029:
1030: DELETE FROM pa_projects_for_accum pfa

Line 1030: DELETE FROM pa_projects_for_accum pfa

1026: -- inserts records onto pa_projects_for_accum
1027:
1028: BEGIN
1029:
1030: DELETE FROM pa_projects_for_accum pfa
1031: WHERE pfa.request_id = x_request_id
1032: AND pfa.segment1
1033: BETWEEN l_project_num_from AND l_project_num_to ;
1034:

Line 1037: INSERT INTO pa_projects_for_accum

1033: BETWEEN l_project_num_from AND l_project_num_to ;
1034:
1035: /* Bug1751445 Replaced union with union all. Also commented out call to pa_check_commitments */
1036:
1037: INSERT INTO pa_projects_for_accum
1038: (project_id, request_id, action_flag, segment1, exception_flag)
1039: SELECT proj.project_id, x_request_id request_id,
1040: 'CS' action_flag, proj.segment1, 'N'
1041: FROM pa_projects_for_accum_v proj

Line 1041: FROM pa_projects_for_accum_v proj

1037: INSERT INTO pa_projects_for_accum
1038: (project_id, request_id, action_flag, segment1, exception_flag)
1039: SELECT proj.project_id, x_request_id request_id,
1040: 'CS' action_flag, proj.segment1, 'N'
1041: FROM pa_projects_for_accum_v proj
1042: WHERE proj.segment1
1043: BETWEEN l_project_num_from AND l_project_num_to
1044: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1045: AND x_actual_cost_flag = 'Y'

Line 1056: FROM pa_projects_for_accum_v proj

1052: AND cdl.resource_accumulated_flag='N')
1053: UNION ALL
1054: SELECT proj.project_id, x_request_id request_id,
1055: 'RV' action_flag, proj.segment1, 'N'
1056: FROM pa_projects_for_accum_v proj
1057: WHERE proj.segment1
1058: BETWEEN l_project_num_from AND l_project_num_to
1059: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1060: AND x_revenue_flag = 'Y'

Line 1071: FROM pa_projects_for_accum_v proj

1067: AND dr.released_date IS NOT NULL)
1068: UNION ALL
1069: SELECT proj.project_id, x_request_id request_id,
1070: 'RL' action_flag, proj.segment1, 'N'
1071: FROM pa_projects_for_accum_v proj
1072: WHERE proj.segment1
1073: BETWEEN l_project_num_from AND l_project_num_to
1074: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1075: AND EXISTS (SELECT 'x'

Line 1083: FROM pa_projects_for_accum_v proj

1079: 'N') = 'N')
1080: /* UNION ALL
1081: SELECT proj.project_id, x_request_id request_id,
1082: 'CM' action_flag, proj.segment1, 'N'
1083: FROM pa_projects_for_accum_v proj
1084: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1085: AND x_commitments_flag = 'Y'
1086: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1087: UNION ALL

Line 1090: FROM pa_projects_for_accum_v proj

1086: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1087: UNION ALL
1088: SELECT proj.project_id, x_request_id request_id,
1089: 'BD' action_flag, proj.segment1, 'N'
1090: FROM pa_projects_for_accum_v proj
1091: WHERE proj.segment1
1092: BETWEEN l_project_num_from AND l_project_num_to
1093: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1094: AND x_budgets_flag = 'Y'

Line 1103: FROM pa_projects_for_accum_v proj

1099: AND bud.resource_accumulated_flag = 'N')
1100: UNION ALL
1101: SELECT proj.project_id, x_request_id request_id,
1102: 'TR' action_flag, proj.segment1, 'Y'
1103: FROM pa_projects_for_accum_v proj
1104: WHERE proj.segment1
1105: BETWEEN l_project_num_from AND l_project_num_to
1106: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1107: AND EXISTS (SELECT 'x'

Line 1114: FROM pa_projects_for_accum_v proj

1110: AND NVL(pah.tasks_restructured_flag, 'N') = 'Y')
1111: UNION ALL
1112: SELECT proj.project_id, x_request_id request_id,
1113: 'PR' action_flag, proj.segment1, 'N'
1114: FROM pa_projects_for_accum_v proj
1115: WHERE proj.segment1
1116: BETWEEN l_project_num_from AND l_project_num_to
1117: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1118: AND Pa_Proj_Accum_Main.check_period_flags

Line 1124: FROM pa_projects_for_accum_v proj

1120: proj.closed_date, l_current_start_date) = 'Y'
1121: UNION ALL
1122: SELECT proj.project_id, x_request_id request_id,
1123: 'BK' action_flag, proj.segment1, 'Y'
1124: FROM pa_projects_for_accum_v proj
1125: WHERE proj.segment1
1126: BETWEEN l_project_num_from AND l_project_num_to
1127: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1128: AND Pa_Proj_Accum_Main.check_period_flags

Line 1134: FROM pa_projects_for_accum_v proj

1130: proj.closed_date, l_current_start_date) = 'Y'
1131: UNION ALL
1132: SELECT proj.project_id, x_request_id request_id,
1133: 'CL' action_flag, proj.segment1, 'N'
1134: FROM pa_projects_for_accum_v proj
1135: WHERE proj.segment1
1136: BETWEEN l_project_num_from AND l_project_num_to
1137: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1138: AND Pa_Proj_Accum_Main.check_period_flags

Line 1144: FROM pa_projects_for_accum_v proj

1140: proj.closed_date, l_current_start_date) = 'Y'
1141: UNION ALL
1142: SELECT proj.project_id, x_request_id request_id,
1143: 'PT' action_flag, proj.segment1, 'Y'
1144: FROM pa_projects_for_accum_v proj
1145: WHERE proj.segment1
1146: BETWEEN l_project_num_from AND l_project_num_to
1147: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1148: AND Pa_Proj_Accum_Main.check_period_flags

Line 1154: FROM pa_projects_for_accum_v proj

1150: proj.closed_date, l_current_start_date) = 'Y'
1151: UNION ALL
1152: SELECT proj.project_id, x_request_id request_id, 'TX' action_flag,
1153: proj.segment1, 'N'
1154: FROM pa_projects_for_accum_v proj
1155: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1156: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1157: AND (x_actual_cost_flag = 'Y' OR x_revenue_flag = 'Y')
1158: AND EXISTS (SELECT 'x'

Line 1172: FROM pa_projects_for_accum_v proj

1168: AND x_revenue_flag = 'Y')
1169: UNION ALL
1170: SELECT proj.project_id, x_request_id request_id, 'TM' action_flag,
1171: proj.segment1, 'N'
1172: FROM pa_projects_for_accum_v proj
1173: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1174: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1175: AND x_commitments_flag = 'Y'
1176: AND EXISTS (SELECT 'x'

Line 1191: INSERT INTO pa_projects_for_accum

1187: IF x_commitments_flag = 'Y' THEN
1188:
1189: FOR recs IN all_valid_proj LOOP
1190:
1191: INSERT INTO pa_projects_for_accum
1192: (project_id, request_id, action_flag, segment1, exception_flag)
1193: SELECT recs.project_id, x_request_id, 'CM', recs.segment1, 'N'
1194: FROM dual
1195: WHERE Pa_Check_Commitments.commitments_changed(recs.project_id) = 'Y';

Line 1213: -- end of insert pa_projects_for_accum

1209: WHEN OTHERS THEN
1210: x_err_code := SQLCODE;
1211: RAISE;
1212: END ;
1213: -- end of insert pa_projects_for_accum
1214:
1215: x_date_through := x_end_date_through;
1216: IF x_end_date_through >= x_current_pa_end_date OR x_end_date_through IS NULL THEN
1217: x_date_through := x_end_pa_date;

Line 1299: DELETE FROM pa_projects_for_accum

1295: WHEN NO_DATA_FOUND THEN
1296: NULL ;
1297: WHEN OTHERS THEN
1298: x_err_code := SQLCODE;
1299: DELETE FROM pa_projects_for_accum
1300: WHERE request_id = x_request_id ;
1301: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1302: Pa_Debug.debug('proj_accum: ' || 'Exception Generated By Oracle Error: ' ||
1303: errbuf,Pa_Debug.DEBUG_LEVEL_EXCEPTION );

Line 2022: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id

2018:
2019: END LOOP ;
2020:
2021: IF x_delete_temp_table = 'Y' THEN
2022: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id
2023: AND exception_flag = 'N';
2024: ELSE
2025: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id;
2026: END IF;

Line 2025: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id;

2021: IF x_delete_temp_table = 'Y' THEN
2022: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id
2023: AND exception_flag = 'N';
2024: ELSE
2025: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id;
2026: END IF;
2027:
2028: COMMIT WORK ;
2029:

Line 2038: DELETE FROM pa_projects_for_accum

2034: x_err_code := SQLCODE;
2035: retcode := x_err_code;
2036: errbuf := SUBSTR(SQLERRM(SQLCODE),1,512);
2037: ROLLBACK WORK;
2038: DELETE FROM pa_projects_for_accum
2039: WHERE request_id = x_request_id ;
2040: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2041: Pa_Debug.debug('proj_accum: ' || 'Exception Generated By Oracle Error: ' ||
2042: errbuf ,Pa_Debug.DEBUG_LEVEL_EXCEPTION);

Line 3851: FROM pa_projects_for_accum pfa

3847: IF (p_refresh_flag = 'N') THEN --Condition via bug 7175975
3848: -- bug 6408874. Introduced BULK Processing
3849: SELECT DISTINCT pfa.project_id project_id
3850: bulk collect into TmpProjectTab
3851: FROM pa_projects_for_accum pfa
3852: WHERE pfa.request_id = x_request_id
3853: AND pfa.segment1 BETWEEN p_project_num_from AND p_project_num_to
3854: AND pfa.action_flag = 'CM'
3855: AND NOT EXISTS (SELECT pf.project_id

Line 3856: FROM pa_projects_for_accum pf

3852: WHERE pfa.request_id = x_request_id
3853: AND pfa.segment1 BETWEEN p_project_num_from AND p_project_num_to
3854: AND pfa.action_flag = 'CM'
3855: AND NOT EXISTS (SELECT pf.project_id
3856: FROM pa_projects_for_accum pf
3857: WHERE pf.request_id = pfa.request_id
3858: AND pf.segment1 = pfa.segment1
3859: AND pf.action_flag IN ('PT', 'CL', 'BK', 'TR'));
3860: -- Added below for Bug# 7175975