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

Line 19: FROM pa_projects proj

15: BEGIN
16:
17: SELECT 'X'
18: INTO x_return
19: FROM pa_projects proj
20: WHERE proj.project_type = p_project_type
21: AND proj.segment1 = p_proj_num;
22:
23: IF x_return IS NULL THEN

Line 55: FROM pa_projects;

51:
52: SELECT min(segment1), max(segment1)
53: INTO p_proj_num_from_out,
54: p_proj_num_to_out
55: FROM pa_projects;
56:
57: END IF;
58:
59: IF (p_proj_num_from IS NOT NULL) THEN

Line 77: p_proj_num_from_temp pa_projects.segment1%TYPE;

73: p_proj_num_from_out OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
74: p_proj_num_to_out OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
75: p_proj_type IN VARCHAR2 ) IS
76:
77: p_proj_num_from_temp pa_projects.segment1%TYPE;
78:
79: BEGIN
80:
81: IF (p_proj_num_from IS NULL) OR

Line 87: FROM pa_projects

83:
84: SELECT MIN(segment1), MAX(segment1)
85: INTO p_proj_num_from_out,
86: p_proj_num_to_out
87: FROM pa_projects
88: WHERE project_type = NVL(p_proj_type, project_type)
89: AND NVL(cbs_enable_flag,'N') <> 'Y'; --bug#16461684
90:
91: END IF;

Line 113: FROM pa_projects

109: p_proj_num_from_out := p_proj_num_from;
110: ELSE
111: SELECT MIN(segment1)
112: INTO p_proj_num_from_temp
113: FROM pa_projects
114: WHERE project_type = p_proj_type
115: AND segment1 BETWEEN p_proj_num_from AND p_proj_num_to_out
116: AND NVL(cbs_enable_flag,'N') <> 'Y'; --bug#16461684
117: END IF;

Line 128: FROM pa_projects

124: p_proj_num_to_out := p_proj_num_to;
125: ELSE
126: SELECT MAX(segment1)
127: INTO p_proj_num_to_out
128: FROM pa_projects
129: WHERE project_type = p_proj_type
130: AND segment1 BETWEEN p_proj_num_from_out AND p_proj_num_to
131: AND NVL(cbs_enable_flag,'N') <> 'Y'; --bug#16461684
132: END IF;

Line 143: FROM pa_projects

139: p_proj_num_from_out := p_proj_num_from;
140: ELSE
141: SELECT MIN(segment1)
142: INTO p_proj_num_from_out
143: FROM pa_projects
144: WHERE project_type = p_proj_type
145: AND NVL(cbs_enable_flag,'N') <> 'Y'; --bug#16461684
146: END IF;
147:

Line 154: FROM pa_projects

150: p_proj_num_to_out := p_proj_num_to;
151: ELSE
152: SELECT MAX(segment1)
153: INTO p_proj_num_to_out
154: FROM pa_projects
155: WHERE project_type = p_proj_type
156: AND NVL(cbs_enable_flag,'N') <> 'Y'; --bug#16461684
157: END IF;
158:

Line 825: /* pa_projects_for_accum table */

821: x_PrjSumStart DATE := NULL; /* Start time for Project Summary */
822: x_PrjSumEnd DATE := NULL; /* End time for Project Summary */
823:
824: x_InsertStart DATE := NULL; /* Start time for Insert onto */
825: /* pa_projects_for_accum table */
826: x_InsertEnd DATE := NULL; /* End time for Insert onto */
827: /* pa_projects_for_accum table */
828:
829: l_accum_period_type_changed BOOLEAN;

Line 827: /* pa_projects_for_accum table */

823:
824: x_InsertStart DATE := NULL; /* Start time for Insert onto */
825: /* pa_projects_for_accum table */
826: x_InsertEnd DATE := NULL; /* End time for Insert onto */
827: /* pa_projects_for_accum table */
828:
829: l_accum_period_type_changed BOOLEAN;
830: l_project_num_from VARCHAR2(25);
831: l_project_num_to VARCHAR2(25);

Line 864: FROM pa_projects_for_accum pfa

860: -- TM is when unaccumulated commitments exist in pa_txn_accum
861:
862: CURSOR all_projs IS
863: SELECT DISTINCT pfa.project_id, pfa.segment1
864: FROM pa_projects_for_accum pfa
865: WHERE pfa.request_id = x_request_id
866: AND pfa.segment1
867: BETWEEN l_project_num_from AND l_project_num_to
868: AND pfa.action_flag IN ('CS', 'RV', 'RL', 'CM', 'BD', 'PR', 'TX', 'TM')

Line 871: FROM pa_projects_for_accum pf

867: BETWEEN l_project_num_from AND l_project_num_to
868: AND pfa.action_flag IN ('CS', 'RV', 'RL', 'CM', 'BD', 'PR', 'TX', 'TM')
869: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(pfa.project_id) = 'N' --bug#16461684
870: AND NOT EXISTS (SELECT pf.project_id
871: FROM pa_projects_for_accum pf
872: WHERE pf.request_id = pfa.request_id
873: AND pf.segment1 = pfa.segment1 -- Bug3653978. replaced pfa.project_id with pfa.segment1
874: AND pf.action_flag IN
875: ('PT', 'CL', 'BK', 'TR'));

Line 878: FROM pa_projects pa

874: AND pf.action_flag IN
875: ('PT', 'CL', 'BK', 'TR'));
876: /* Commenting out for performance bug 3653978.
877: AND EXISTS (SELECT pa.project_id -- for bug 2543021
878: FROM pa_projects pa
879: WHERE pa.project_id = pfa.project_id
880: AND pa.project_type = NVL(x_project_type,project_type));
881: */
882: /*Added for bug 5635857*/

Line 885: FROM pa_projects_for_accum pfa

881: */
882: /*Added for bug 5635857*/
883: CURSOR all_cm_projs IS
884: SELECT DISTINCT pfa.project_id
885: FROM pa_projects_for_accum pfa
886: WHERE pfa.request_id = x_request_id
887: AND pfa.segment1
888: BETWEEN l_project_num_from AND l_project_num_to
889: AND pfa.action_flag = 'CM'

Line 892: FROM pa_projects_for_accum pf

888: BETWEEN l_project_num_from AND l_project_num_to
889: AND pfa.action_flag = 'CM'
890: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(pfa.project_id) = 'N' --bug#16461684
891: AND NOT EXISTS (SELECT pf.project_id
892: FROM pa_projects_for_accum pf
893: WHERE pf.request_id = pfa.request_id
894: AND pf.segment1 = pfa.segment1 -- Bug3783746. replaced pf.project_id with pfa.segment1
895: AND pf.action_flag IN
896: ('PT', 'CL', 'BK', 'TR'));

Line 900: FROM pa_projects_for_accum pfa

896: ('PT', 'CL', 'BK', 'TR'));
897:
898: CURSOR action_found IS
899: SELECT pfa.action_flag
900: FROM pa_projects_for_accum pfa
901: WHERE pfa.segment1 = l_segment1
902: AND pfa.request_id = x_request_id ;
903:
904: CURSOR not_valid_proj IS

Line 906: FROM pa_projects_for_accum pfa

902: AND pfa.request_id = x_request_id ;
903:
904: CURSOR not_valid_proj IS
905: SELECT pfa.project_id, pfa.segment1, pfa.action_flag
906: FROM pa_projects_for_accum pfa
907: WHERE pfa.request_id = x_request_id
908: AND pfa.action_flag IN ('PT', 'CL', 'BK', 'TR')
909: ORDER BY pfa.segment1, pfa.action_flag ;
910:

Line 928: FROM pa_projects_for_accum_v proj

924: /* Added for bug 1751445 Cause Performance */
925: /*Commented for perf bug #3672175 and redefined below */
926: /* CURSOR all_valid_proj IS
927: SELECT DISTINCT proj.project_id, proj.segment1
928: FROM pa_projects_for_accum_v proj
929: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
930: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
931: AND NOT EXISTS (SELECT 1
932: FROM pa_projects_for_accum proj_invalid

Line 932: FROM pa_projects_for_accum proj_invalid

928: FROM pa_projects_for_accum_v proj
929: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
930: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
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+0 = x_request_id);*/
936: CURSOR all_valid_proj IS

Line 940: FROM pa_projects proj

936: CURSOR all_valid_proj IS
937: SELECT
938: proj.project_id ,
939: proj.segment1 ,proj.project_type
940: FROM pa_projects proj
941: WHERE proj.segment1 BETWEEN pa_accum_utils.Get_project_info('F')
942: AND pa_accum_utils.Get_project_info('T')
943: AND pa_accum_utils.Get_context_info = 'REGULAR'
944: AND NVL(proj.template_flag,'N') <> 'Y'

Line 949: FROM pa_projects_for_accum proj_invalid

945: AND NVL(proj.cbs_enable_flag,'N') <> 'Y' --bug#16461684
946: AND proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
947: AND proj.project_type = NVL(x_project_type, project_type)
948: AND NOT EXISTS (SELECT 1
949: FROM pa_projects_for_accum proj_invalid
950: WHERE proj_invalid.project_id = proj.project_id
951: AND proj_invalid.action_flag IN ('PT','CL','BK','TR')
952: AND proj_invalid.request_id = x_request_id)
953: UNION

Line 955: FROM pa_projects proj

951: AND proj_invalid.action_flag IN ('PT','CL','BK','TR')
952: AND proj_invalid.request_id = x_request_id)
953: UNION
954: SELECT proj.project_id , proj.segment1 ,proj.project_type
955: FROM pa_projects proj
956: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
957: AND EXISTS ( select 1 from pa_alloc_txn_details alloc
958: where alloc.project_id = proj.project_id
959: AND alloc.run_id = pa_accum_utils.Get_grouping_id)

Line 964: FROM pa_projects_for_accum proj_invalid

960: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'
961: AND proj.project_type = NVL(x_project_type, project_type)
962: AND NVL(proj.cbs_enable_flag,'N') <> 'Y' --bug#16461684
963: AND NOT EXISTS (SELECT 1
964: FROM pa_projects_for_accum proj_invalid
965: WHERE proj_invalid.project_id = proj.project_id
966: AND proj_invalid.action_flag IN ('PT','CL','BK','TR')
967: AND proj_invalid.request_id = x_request_id); /*Code redefined for bug#3672175 ends here*/
968: filter_proj not_valid_proj%ROWTYPE ;

Line 1058: -- inserts records onto pa_projects_for_accum

1054: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1055: Pa_Accum_Utils.G_context := x_summ_context;
1056: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1057:
1058: -- inserts records onto pa_projects_for_accum
1059:
1060: BEGIN
1061:
1062: DELETE FROM pa_projects_for_accum pfa

Line 1062: DELETE FROM pa_projects_for_accum pfa

1058: -- inserts records onto pa_projects_for_accum
1059:
1060: BEGIN
1061:
1062: DELETE FROM pa_projects_for_accum pfa
1063: WHERE pfa.request_id = x_request_id
1064: AND pfa.segment1
1065: BETWEEN l_project_num_from AND l_project_num_to ;
1066:

Line 1069: INSERT INTO pa_projects_for_accum

1065: BETWEEN l_project_num_from AND l_project_num_to ;
1066:
1067: /* Bug1751445 Replaced union with union all. Also commented out call to pa_check_commitments */
1068:
1069: INSERT INTO pa_projects_for_accum
1070: (project_id, request_id, action_flag, segment1, exception_flag)
1071: SELECT proj.project_id, x_request_id request_id,
1072: 'CS' action_flag, proj.segment1, 'N'
1073: FROM pa_projects_for_accum_v proj

Line 1073: FROM pa_projects_for_accum_v proj

1069: INSERT INTO pa_projects_for_accum
1070: (project_id, request_id, action_flag, segment1, exception_flag)
1071: SELECT proj.project_id, x_request_id request_id,
1072: 'CS' action_flag, proj.segment1, 'N'
1073: FROM pa_projects_for_accum_v proj
1074: WHERE proj.segment1
1075: BETWEEN l_project_num_from AND l_project_num_to
1076: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1077: AND x_actual_cost_flag = 'Y'

Line 1089: FROM pa_projects_for_accum_v proj

1085: AND cdl.resource_accumulated_flag='N')
1086: UNION ALL
1087: SELECT proj.project_id, x_request_id request_id,
1088: 'RV' action_flag, proj.segment1, 'N'
1089: FROM pa_projects_for_accum_v proj
1090: WHERE proj.segment1
1091: BETWEEN l_project_num_from AND l_project_num_to
1092: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1093: AND x_revenue_flag = 'Y'

Line 1105: FROM pa_projects_for_accum_v proj

1101: AND dr.released_date IS NOT NULL)
1102: UNION ALL
1103: SELECT proj.project_id, x_request_id request_id,
1104: 'RL' action_flag, proj.segment1, 'N'
1105: FROM pa_projects_for_accum_v proj
1106: WHERE proj.segment1
1107: BETWEEN l_project_num_from AND l_project_num_to
1108: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1109: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1118: FROM pa_projects_for_accum_v proj

1114: 'N') = 'N')
1115: /* UNION ALL
1116: SELECT proj.project_id, x_request_id request_id,
1117: 'CM' action_flag, proj.segment1, 'N'
1118: FROM pa_projects_for_accum_v proj
1119: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1120: AND x_commitments_flag = 'Y'
1121: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1122: UNION ALL

Line 1125: FROM pa_projects_for_accum_v proj

1121: AND PA_CHECK_COMMITMENTS.commitments_changed(proj.project_id) = 'Y' */
1122: UNION ALL
1123: SELECT proj.project_id, x_request_id request_id,
1124: 'BD' action_flag, proj.segment1, 'N'
1125: FROM pa_projects_for_accum_v proj
1126: WHERE proj.segment1
1127: BETWEEN l_project_num_from AND l_project_num_to
1128: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1129: AND x_budgets_flag = 'Y'

Line 1139: FROM pa_projects_for_accum_v proj

1135: AND bud.resource_accumulated_flag = 'N')
1136: UNION ALL
1137: SELECT proj.project_id, x_request_id request_id,
1138: 'TR' action_flag, proj.segment1, 'Y'
1139: FROM pa_projects_for_accum_v proj
1140: WHERE proj.segment1
1141: BETWEEN l_project_num_from AND l_project_num_to
1142: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1143: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1151: FROM pa_projects_for_accum_v proj

1147: AND NVL(pah.tasks_restructured_flag, 'N') = 'Y')
1148: UNION ALL
1149: SELECT proj.project_id, x_request_id request_id,
1150: 'PR' action_flag, proj.segment1, 'N'
1151: FROM pa_projects_for_accum_v proj
1152: WHERE proj.segment1
1153: BETWEEN l_project_num_from AND l_project_num_to
1154: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1155: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1162: FROM pa_projects_for_accum_v proj

1158: proj.closed_date, l_current_start_date) = 'Y'
1159: UNION ALL
1160: SELECT proj.project_id, x_request_id request_id,
1161: 'BK' action_flag, proj.segment1, 'Y'
1162: FROM pa_projects_for_accum_v proj
1163: WHERE proj.segment1
1164: BETWEEN l_project_num_from AND l_project_num_to
1165: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1166: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1173: FROM pa_projects_for_accum_v proj

1169: proj.closed_date, l_current_start_date) = 'Y'
1170: UNION ALL
1171: SELECT proj.project_id, x_request_id request_id,
1172: 'CL' action_flag, proj.segment1, 'N'
1173: FROM pa_projects_for_accum_v proj
1174: WHERE proj.segment1
1175: BETWEEN l_project_num_from AND l_project_num_to
1176: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1177: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1184: FROM pa_projects_for_accum_v proj

1180: proj.closed_date, l_current_start_date) = 'Y'
1181: UNION ALL
1182: SELECT proj.project_id, x_request_id request_id,
1183: 'PT' action_flag, proj.segment1, 'Y'
1184: FROM pa_projects_for_accum_v proj
1185: WHERE proj.segment1
1186: BETWEEN l_project_num_from AND l_project_num_to
1187: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1188: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684

Line 1195: FROM pa_projects_for_accum_v proj

1191: proj.closed_date, l_current_start_date) = 'Y'
1192: UNION ALL
1193: SELECT proj.project_id, x_request_id request_id, 'TX' action_flag,
1194: proj.segment1, 'N'
1195: FROM pa_projects_for_accum_v proj
1196: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1197: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1198: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1199: AND (x_actual_cost_flag = 'Y' OR x_revenue_flag = 'Y')

Line 1214: FROM pa_projects_for_accum_v proj

1210: AND x_revenue_flag = 'Y')
1211: UNION ALL
1212: SELECT proj.project_id, x_request_id request_id, 'TM' action_flag,
1213: proj.segment1, 'N'
1214: FROM pa_projects_for_accum_v proj
1215: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
1216: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1217: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1218: AND x_commitments_flag = 'Y'

Line 1234: INSERT INTO pa_projects_for_accum

1230: IF x_commitments_flag = 'Y' THEN
1231:
1232: FOR recs IN all_valid_proj LOOP
1233:
1234: INSERT INTO pa_projects_for_accum
1235: (project_id, request_id, action_flag, segment1, exception_flag)
1236: SELECT recs.project_id, x_request_id, 'CM', recs.segment1, 'N'
1237: FROM dual
1238: WHERE Pa_Check_Commitments.commitments_changed(recs.project_id) = 'Y';

Line 1256: -- end of insert pa_projects_for_accum

1252: WHEN OTHERS THEN
1253: x_err_code := SQLCODE;
1254: RAISE;
1255: END ;
1256: -- end of insert pa_projects_for_accum
1257:
1258: x_date_through := x_end_date_through;
1259: IF x_end_date_through >= x_current_pa_end_date OR x_end_date_through IS NULL THEN
1260: x_date_through := x_end_pa_date;

Line 1342: DELETE FROM pa_projects_for_accum

1338: WHEN NO_DATA_FOUND THEN
1339: NULL ;
1340: WHEN OTHERS THEN
1341: x_err_code := SQLCODE;
1342: DELETE FROM pa_projects_for_accum
1343: WHERE request_id = x_request_id ;
1344: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1345: Pa_Debug.debug('proj_accum: ' || 'Exception Generated By Oracle Error: ' ||
1346: errbuf,Pa_Debug.DEBUG_LEVEL_EXCEPTION );

Line 2065: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id

2061:
2062: END LOOP ;
2063:
2064: IF x_delete_temp_table = 'Y' THEN
2065: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id
2066: AND exception_flag = 'N';
2067: ELSE
2068: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id;
2069: END IF;

Line 2068: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id;

2064: IF x_delete_temp_table = 'Y' THEN
2065: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id
2066: AND exception_flag = 'N';
2067: ELSE
2068: DELETE FROM pa_projects_for_accum WHERE request_id = x_request_id;
2069: END IF;
2070:
2071: COMMIT WORK ;
2072:

Line 2081: DELETE FROM pa_projects_for_accum

2077: x_err_code := SQLCODE;
2078: retcode := x_err_code;
2079: errbuf := SUBSTR(SQLERRM(SQLCODE),1,512);
2080: ROLLBACK WORK;
2081: DELETE FROM pa_projects_for_accum
2082: WHERE request_id = x_request_id ;
2083: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2084: Pa_Debug.debug('proj_accum: ' || 'Exception Generated By Oracle Error: ' ||
2085: errbuf ,Pa_Debug.DEBUG_LEVEL_EXCEPTION);

Line 2153: pa_projects ppr

2149: ppr.project_id,
2150: ppr.segment1,
2151: ppr.closed_date
2152: FROM
2153: pa_projects ppr
2154: WHERE
2155: NVL(ppr.template_flag,'N') <> 'Y'
2156: AND NVL(ppr.cbs_enable_flag,'N') <> 'Y' --bug#16461684
2157: AND (

Line 2842: pa_projects ppr

2838: ppr.project_id,
2839: ppr.segment1,
2840: ppr.closed_date
2841: FROM
2842: pa_projects ppr
2843: WHERE
2844: NVL(ppr.template_flag,'N') <> 'Y'
2845: AND ppr.segment1 BETWEEN l_project_num_from AND l_project_num_to
2846: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code)= 'N';

Line 3196: pa_projects ppr

3192: ppr.project_id,
3193: ppr.segment1,
3194: ppr.closed_date
3195: FROM
3196: pa_projects ppr
3197: WHERE
3198: NVL(ppr.template_flag,'N') <> 'Y'
3199: AND ppr.segment1 BETWEEN l_project_num_from AND l_project_num_to
3200: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code)= 'N';

Line 3926: FROM pa_projects_for_accum pfa

3922: -- bug 6408874. Introduced BULK Processing
3923: INSERT INTO pa_proj_summ_tmp (project_id) -- BUG 10107257 Using global temp table instead of Bulk collect
3924: (SELECT DISTINCT pfa.project_id project_id
3925: -- bulk collect into TmpProjectTab
3926: FROM pa_projects_for_accum pfa
3927: WHERE pfa.request_id = x_request_id
3928: AND (
3929: ((pfa.segment1 BETWEEN p_project_num_from AND p_project_num_to) and l_client_extn_mode='N') OR
3930: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=pfa.project_id))

Line 3934: FROM pa_projects_for_accum pf

3930: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=pfa.project_id))
3931: ) --14090312
3932: AND pfa.action_flag = 'CM'
3933: AND NOT EXISTS (SELECT pf.project_id
3934: FROM pa_projects_for_accum pf
3935: WHERE pf.request_id = pfa.request_id
3936: AND pf.segment1 = pfa.segment1
3937: AND pf.action_flag IN ('PT', 'CL', 'BK', 'TR')));
3938: -- Added below for Bug# 7175975

Line 3943: FROM pa_projects ppr

3939: ELSIF (p_refresh_flag = 'Y') THEN
3940: INSERT INTO pa_proj_summ_tmp (project_id) -- BUG 10107257 Using global temp table instead of Bulk collect
3941: (SELECT ppr.project_id
3942: -- BULK COLLECT INTO TmpProjectTab
3943: FROM pa_projects ppr
3944: WHERE NVL(ppr.template_flag,'N') <> 'Y'
3945: AND (
3946: ((ppr.segment1 BETWEEN p_project_num_from AND p_project_num_to) and l_client_extn_mode='N') OR
3947: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=ppr.project_id))