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_TXN_ACCUMS dependencies on PA_PROJ_ACCUM_MAIN

Line 203: ROWNUM <= pa_proj_accum_main.x_commit_size;

199: WHERE project_id = x_start_project_id AND
200: (line_type = 'R' OR line_type = 'I') AND
201: resource_accumulated_flag <> 'N' AND
202: TRUNC(pa_date) BETWEEN x_start_pa_date AND x_end_pa_date AND
203: ROWNUM <= pa_proj_accum_main.x_commit_size;
204: /*Code Changes for Bug No.2984871 start */
205: l_rowcount:=sql%rowcount;
206: /*Code Changes for Bug No.2984871 end */
207: COMMIT;

Line 215: IF (l_rowcount < pa_proj_accum_main.x_commit_size) THEN

211: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
212: pa_debug.debug('update_resource_flag: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
213: END IF;
214: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
215: IF (l_rowcount < pa_proj_accum_main.x_commit_size) THEN
216: EXIT;
217: END IF;
218: END LOOP;
219:

Line 227: ROWNUM <= pa_proj_accum_main.x_commit_size;

223: WHERE project_id = x_start_project_id AND
224: released_date IS NOT NULL AND
225: resource_accumulated_flag <> 'S' AND
226: TRUNC(pa_date) BETWEEN x_start_pa_date AND x_end_pa_date AND
227: ROWNUM <= pa_proj_accum_main.x_commit_size;
228: /*Code Changes for Bug No.2984871 start */
229: l_rowcount:=sql%rowcount;
230: /*Code Changes for Bug No.2984871 end */
231: COMMIT;

Line 239: IF (l_rowcount < pa_proj_accum_main.x_commit_size) THEN

235: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
236: pa_debug.debug('update_resource_flag: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
237: END IF;
238: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
239: IF (l_rowcount < pa_proj_accum_main.x_commit_size) THEN
240: EXIT;
241: END IF;
242: END LOOP;
243:

Line 766: AND ROWNUM <= pa_proj_accum_main.x_commit_size;

762: AND end_date <= x_end_pa_date
763: )
764: )
765: AND ptad.line_type = 'C'
766: AND ROWNUM <= pa_proj_accum_main.x_commit_size;
767: /*Code Changes for Bug No.2984871 start */
768: l_rowcount:=sql%rowcount;
769: /*Code Changes for Bug No.2984871 end */
770: COMMIT;

Line 777: IF l_rowcount < pa_proj_accum_main.x_commit_size THEN

773: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
774: pa_debug.debug('delete_act_txn_accum_details: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
775: END IF;
776: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
777: IF l_rowcount < pa_proj_accum_main.x_commit_size THEN
778: EXIT;
779: END IF;
780: END LOOP;
781:

Line 834: AND ROWNUM <= pa_proj_accum_main.x_commit_size;

830: AND end_date <= x_end_pa_date
831: )
832: )
833: AND ptad.line_type IN ('R','E')
834: AND ROWNUM <= pa_proj_accum_main.x_commit_size;
835: /*Code Changes for Bug No.2984871 start */
836: l_rowcount:=sql%rowcount;
837: /*Code Changes for Bug No.2984871 end */
838:

Line 846: IF (l_rowcount < pa_proj_accum_main.x_commit_size) THEN

842: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
843: pa_debug.debug('delete_rev_txn_accum_details: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
844: END IF;
845: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
846: IF (l_rowcount < pa_proj_accum_main.x_commit_size) THEN
847: EXIT;
848: END IF;
849: END LOOP;
850:

Line 906: AND ROWNUM <= pa_proj_accum_main.x_commit_size;

902: AND end_date <= x_end_pa_date
903: )
904: )
905: AND ptad.line_type = 'M'
906: AND ROWNUM <= pa_proj_accum_main.x_commit_size;
907: /*Code Changes for Bug No.2984871 start */
908: l_rowcount:=sql%rowcount;
909: /*Code Changes for Bug No.2984871 end */
910: COMMIT;

Line 917: IF l_rowcount < pa_proj_accum_main.x_commit_size THEN

913: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
914: pa_debug.debug('delete_cmt_txn_accum_details: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
915: END IF;
916: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
917: IF l_rowcount < pa_proj_accum_main.x_commit_size THEN
918: EXIT;
919: END IF;
920: END LOOP;
921:

Line 1268: AND ROWNUM <= pa_proj_accum_main.x_commit_size;

1264: WHERE period_name = pct.pa_period
1265: AND start_date >= x_start_pa_date
1266: AND end_date <= x_end_pa_date
1267: )
1268: AND ROWNUM <= pa_proj_accum_main.x_commit_size;
1269: /*Code Changes for Bug No.2984871 start */
1270: l_rowcount:=sql%rowcount;
1271: /*Code Changes for Bug No.2984871 end */
1272:

Line 1280: IF l_rowcount < pa_proj_accum_main.x_commit_size THEN

1276: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1277: pa_debug.debug('delete_cmt_txns: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
1278: END IF;
1279: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
1280: IF l_rowcount < pa_proj_accum_main.x_commit_size THEN
1281: EXIT;
1282: END IF;
1283: END LOOP;
1284:

Line 1340: /Commented for bug 4094814 IF ( PA_PROJ_ACCUM_MAIN.G_GMS_Enabled = 'Y' ) and added below if/

1336: -- Grants Management Integrated Commitment Processing ---------------------
1337: -- added 30-MAY-2003, jwhite
1338:
1339:
1340: /*Commented for bug 4094814 IF ( PA_PROJ_ACCUM_MAIN.G_GMS_Enabled = 'Y' ) and added below if*/
1341:
1342: IF ( pa_gms_api.is_sponsored_project(x_start_project_id) )
1343: THEN
1344:

Line 2514: END IF; -- ( PA_PROJ_ACCUM_MAIN.G_GMS_Enabled = 'Y'

2510: end;
2511:
2512: end if;
2513:
2514: END IF; -- ( PA_PROJ_ACCUM_MAIN.G_GMS_Enabled = 'Y'
2515:
2516: -- End: Grants Management Integrated Commitment Processing ---------------------
2517:
2518:

Line 3092: IF (commit_rows >= pa_proj_accum_main.x_commit_size) THEN

3088: resource_accumulated_flag = 'Y'
3089: WHERE
3090: ROWID = cdlrec.cdlrowid;
3091: */
3092: IF (commit_rows >= pa_proj_accum_main.x_commit_size) THEN
3093: COMMIT;
3094: commit_rows := 0;
3095: END IF;
3096: END LOOP;

Line 3137: IF (commit_rows < pa_proj_accum_main.x_commit_size) THEN

3133: /* End of Code changes for bug 13448783 */
3134:
3135: /* End of changes for bug# 1770772 */
3136:
3137: IF (commit_rows < pa_proj_accum_main.x_commit_size) THEN
3138: COMMIT;
3139: END IF;
3140:
3141: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 3803: IF commit_rows >= pa_proj_accum_main.x_commit_size THEN

3799: program_id = x_program_id
3800: WHERE
3801: ROWID = curr_rowid;
3802:
3803: IF commit_rows >= pa_proj_accum_main.x_commit_size THEN
3804: COMMIT;
3805: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3806: pa_debug.debug('accum_revenue: ' || 'Number of Records Commited = '|| TO_CHAR(commit_rows));
3807: END IF;