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_PROJ_ACCUM_MAIN

Line 1: PACKAGE BODY Pa_Proj_Accum_Main AS

1: PACKAGE BODY Pa_Proj_Accum_Main AS
2: /* $Header: PARESMNB.pls 120.15.12020000.8 2013/03/28 17:27:52 bpottipa ship $ */
3:
4: x_run_id NUMBER;
5: x_status NUMBER;

Line 180: -- Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening

176: -- IN-parm to the accum_cdls procedure:
177: -- x_cdl_line_type VARCHAR2
178: -- Also, added FND_PROFILE.value call to Initialization
179: -- procedure for conditional processing:
180: -- Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening
181: --
182: -- 01-JUL-04 sacgupta Added call to new procedure get_pa_period_info1
183: -- This procedure initilaize global variables whose
184: -- values are same for all the projects

Line 195: x_err_stack := x_err_stack ||'->pa_proj_accum_main.initialize';

191:
192: BEGIN
193:
194: x_old_stack := x_err_stack;
195: x_err_stack := x_err_stack ||'->pa_proj_accum_main.initialize';
196: x_err_code := 0;
197: x_err_stage := 'Summary Accumulation Initialization Procedure';
198:
199: -- This procedure initialize the variables for all projects

Line 210: Pa_Proj_Accum_Main.x_commit_size := Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET');

206: END IF;
207:
208: --- Getting the commit size--------------
209: IF Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET') IS NOT NULL THEN
210: Pa_Proj_Accum_Main.x_commit_size := Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET');
211: ELSE
212: Pa_Proj_Accum_Main.x_commit_size := 500;
213: END IF;
214:

Line 212: Pa_Proj_Accum_Main.x_commit_size := 500;

208: --- Getting the commit size--------------
209: IF Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET') IS NOT NULL THEN
210: Pa_Proj_Accum_Main.x_commit_size := Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET');
211: ELSE
212: Pa_Proj_Accum_Main.x_commit_size := 500;
213: END IF;
214:
215: Pa_Accum_Utils.get_impl_option
216: (x_impl_option,

Line 309: --Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := NVL(FND_PROFILE.value('PA_ENHANCED_BURDENING'), 'N');

305: -- This profile is used to conditionally execute the accum_clds procedure
306: -- for incremental burden rows.
307:
308:
309: --Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := NVL(FND_PROFILE.value('PA_ENHANCED_BURDENING'), 'N');
310: Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := pa_utils2.IsEnhancedBurdeningEnabled; /*4278940 */
311:
312: IF ( P_DEBUG_MODE = 'Y' )
313: THEN

Line 310: Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := pa_utils2.IsEnhancedBurdeningEnabled; /4278940 /

306: -- for incremental burden rows.
307:
308:
309: --Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := NVL(FND_PROFILE.value('PA_ENHANCED_BURDENING'), 'N');
310: Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := pa_utils2.IsEnhancedBurdeningEnabled; /*4278940 */
311:
312: IF ( P_DEBUG_MODE = 'Y' )
313: THEN
314: Pa_Debug.debug('proj_accum, Initialize: G_PA_Enhanced_Burdening - '|| Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening );

Line 314: Pa_Debug.debug('proj_accum, Initialize: G_PA_Enhanced_Burdening - '|| Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening );

310: Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := pa_utils2.IsEnhancedBurdeningEnabled; /*4278940 */
311:
312: IF ( P_DEBUG_MODE = 'Y' )
313: THEN
314: Pa_Debug.debug('proj_accum, Initialize: G_PA_Enhanced_Burdening - '|| Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening );
315: END IF;
316:
317:
318: -- --------------------------------------------------------------------------

Line 345: x_err_stack := x_err_stack ||'->pa_proj_accum_main.initialize_project';

341:
342: BEGIN
343:
344: x_old_stack := x_err_stack;
345: x_err_stack := x_err_stack ||'->pa_proj_accum_main.initialize_project';
346: x_err_code := 0;
347: x_err_stage :=
348: 'Summary Accumulation Initialization Procedure for Project_id= ' || x_project_id;
349:

Line 459: If PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 is null or

455: -- If the project had been previously accumulated, then get the details
456: -- pertaining to the previously accumulated period
457:
458: If x_prev_accum_period is not Null Then
459: If PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 is null or
460: PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 <> x_prev_accum_period Then
461:
462: PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 := x_prev_accum_period;
463:

Line 460: PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 <> x_prev_accum_period Then

456: -- pertaining to the previously accumulated period
457:
458: If x_prev_accum_period is not Null Then
459: If PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 is null or
460: PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 <> x_prev_accum_period Then
461:
462: PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 := x_prev_accum_period;
463:
464: -- Initialize the global variables before use for each project

Line 462: PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 := x_prev_accum_period;

458: If x_prev_accum_period is not Null Then
459: If PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 is null or
460: PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 <> x_prev_accum_period Then
461:
462: PA_PROJ_ACCUM_MAIN.x_prev_accum_period1 := x_prev_accum_period;
463:
464: -- Initialize the global variables before use for each project
465: x_prev_accum_year := 0;
466:

Line 508: x_err_stack := x_err_stack ||'->pa_proj_accum_main.check_reporting_period';

504:
505: BEGIN
506:
507: x_old_stack := x_err_stack;
508: x_err_stack := x_err_stack ||'->pa_proj_accum_main.check_reporting_period';
509: x_err_code := 0;
510: x_err_stage := 'Checking If Reporting Period Moved Backwards in Time';
511:
512: -- This procedure checks if the reporting period was moved

Line 729: AND ( Pa_Proj_Accum_Main.x_period_yr_start_date IS NOT NULL)

725: IF x_action_flag = 'CL' THEN
726: -- Check for Closed Projects (CL)
727:
728: /*IF (x_closed_date IS NOT NULL)
729: AND ( Pa_Proj_Accum_Main.x_period_yr_start_date IS NOT NULL)
730: AND ( TRUNC(x_closed_date) <
731: TRUNC(Pa_Proj_Accum_Main.x_period_yr_start_date)) THEN
732: x_ret_flag := 'Y' ;*/--commented this for bug 12865070
733: --added below for 12865070

Line 731: TRUNC(Pa_Proj_Accum_Main.x_period_yr_start_date)) THEN

727:
728: /*IF (x_closed_date IS NOT NULL)
729: AND ( Pa_Proj_Accum_Main.x_period_yr_start_date IS NOT NULL)
730: AND ( TRUNC(x_closed_date) <
731: TRUNC(Pa_Proj_Accum_Main.x_period_yr_start_date)) THEN
732: x_ret_flag := 'Y' ;*/--commented this for bug 12865070
733: --added below for 12865070
734: IF (l_prev_projects ='Y')
735: then

Line 738: AND ( Pa_Proj_Accum_Main.x_period_yr_start_date IS NOT NULL)

734: IF (l_prev_projects ='Y')
735: then
736:
737: IF (x_closed_date IS NOT NULL)
738: AND ( Pa_Proj_Accum_Main.x_period_yr_start_date IS NOT NULL)
739: AND ( add_months (x_closed_date,12)) <
740: (TRUNC(Pa_Proj_Accum_Main.x_period_yr_start_date)) THEN
741:
742: x_ret_flag := 'Y' ;

Line 740: (TRUNC(Pa_Proj_Accum_Main.x_period_yr_start_date)) THEN

736:
737: IF (x_closed_date IS NOT NULL)
738: AND ( Pa_Proj_Accum_Main.x_period_yr_start_date IS NOT NULL)
739: AND ( add_months (x_closed_date,12)) <
740: (TRUNC(Pa_Proj_Accum_Main.x_period_yr_start_date)) THEN
741:
742: x_ret_flag := 'Y' ;
743:
744: END IF ;

Line 747: AND ( Pa_Proj_Accum_Main.x_period_yr_start_date IS NOT NULL)

743:
744: END IF ;
745: else
746: IF (x_closed_date IS NOT NULL)
747: AND ( Pa_Proj_Accum_Main.x_period_yr_start_date IS NOT NULL)
748: AND ( TRUNC(x_closed_date) <
749: TRUNC(Pa_Proj_Accum_Main.x_period_yr_start_date)) THEN
750: x_ret_flag := 'Y' ;
751:

Line 749: TRUNC(Pa_Proj_Accum_Main.x_period_yr_start_date)) THEN

745: else
746: IF (x_closed_date IS NOT NULL)
747: AND ( Pa_Proj_Accum_Main.x_period_yr_start_date IS NOT NULL)
748: AND ( TRUNC(x_closed_date) <
749: TRUNC(Pa_Proj_Accum_Main.x_period_yr_start_date)) THEN
750: x_ret_flag := 'Y' ;
751:
752: END IF ;
753:

Line 981: x_err_stack := x_err_stack ||'->pa_proj_accum_main.Proj_Accum';

977:
978: BEGIN
979:
980: x_old_stack := x_err_stack;
981: x_err_stack := x_err_stack ||'->pa_proj_accum_main.Proj_Accum';
982: x_err_code := 0;
983:
984: x_summ_process := 'UP';
985: x_err_stage := 'Project Accumulation Process';

Line 1041: Pa_Proj_Accum_Main.initialize;

1037: -- all the parameters are validated now
1038:
1039: -- Call the Initialization procedure
1040:
1041: Pa_Proj_Accum_Main.initialize;
1042:
1043: IF x_impl_option = 'PA' THEN
1044: l_current_start_date := x_current_pa_start_date ;
1045: l_current_end_date := x_current_pa_end_date ;

Line 1083: ( cdl.line_type = 'I' and Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening = 'Y')

1079: AND EXISTS (SELECT 'x'
1080: FROM pa_cost_distribution_lines_all cdl
1081: WHERE cdl.project_id = proj.project_id
1082: AND (cdl.line_type = 'R' OR
1083: ( cdl.line_type = 'I' and Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening = 'Y')
1084: ) /*4278940 */
1085: AND cdl.resource_accumulated_flag='N')
1086: UNION ALL
1087: SELECT proj.project_id, x_request_id request_id,

Line 1156: AND Pa_Proj_Accum_Main.check_period_flags

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
1156: AND Pa_Proj_Accum_Main.check_period_flags
1157: (proj.project_id, x_impl_option, l_current_end_date, 'PR',
1158: proj.closed_date, l_current_start_date) = 'Y'
1159: UNION ALL
1160: SELECT proj.project_id, x_request_id request_id,

Line 1167: AND Pa_Proj_Accum_Main.check_period_flags

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
1167: AND Pa_Proj_Accum_Main.check_period_flags
1168: (proj.project_id, x_impl_option, l_current_end_date, 'BK',
1169: proj.closed_date, l_current_start_date) = 'Y'
1170: UNION ALL
1171: SELECT proj.project_id, x_request_id request_id,

Line 1178: AND Pa_Proj_Accum_Main.check_period_flags

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
1178: AND Pa_Proj_Accum_Main.check_period_flags
1179: (proj.project_id, x_impl_option, l_current_end_date, 'CL',
1180: proj.closed_date, l_current_start_date) = 'Y'
1181: UNION ALL
1182: SELECT proj.project_id, x_request_id request_id,

Line 1189: AND Pa_Proj_Accum_Main.check_period_flags

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
1189: AND Pa_Proj_Accum_Main.check_period_flags
1190: (proj.project_id, x_impl_option, l_current_end_date, 'PT',
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,

Line 1269: Pa_Proj_Accum_Main.lock_proj_level_header_record

1265: BEGIN
1266:
1267: FOR filter_proj IN not_valid_proj LOOP
1268:
1269: Pa_Proj_Accum_Main.lock_proj_level_header_record
1270: (filter_proj.project_id);
1271:
1272: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1273: Pa_Debug.debug('proj_accum: ' || '**** PLEASE REFRESH THE PROJECT '

Line 1424: IF Pa_Proj_Accum_Main.action_exists

1420: Pa_Debug.debug('proj_accum: ' || 'Refreshing new resource lists assigned '||
1421: 'to the project, If any');
1422: END IF;
1423:
1424: IF Pa_Proj_Accum_Main.action_exists
1425: (x_action_flag => 'RL',
1426: x_actions_in => x_actions_in,
1427: x_actions_cnt => x_actions_cnt) = 'Y' THEN
1428:

Line 1511: (Pa_Proj_Accum_Main.action_exists

1507: x_err_stage,
1508: x_err_code) ;
1509:
1510: IF (x_actual_cost_flag = 'Y' AND
1511: (Pa_Proj_Accum_Main.action_exists
1512: (x_action_flag => 'CS',
1513: x_actions_in => x_actions_in,
1514: x_actions_cnt => x_actions_cnt) = 'Y')) THEN
1515:

Line 1533: IF (Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening = 'Y')

1529: x_err_stage,
1530: x_err_code) ;
1531:
1532: -- 05-AUG-2003, jwhite: For patchset 'L' Reburdening Enhancement
1533: IF (Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening = 'Y')
1534: THEN
1535:
1536: IF ( P_DEBUG_MODE = 'Y' )
1537: THEN

Line 1562: (Pa_Proj_Accum_Main.action_exists

1558:
1559: END IF ;
1560:
1561: IF (x_revenue_flag = 'Y' AND
1562: (Pa_Proj_Accum_Main.action_exists
1563: (x_action_flag => 'RV',
1564: x_actions_in => x_actions_in,
1565: x_actions_cnt => x_actions_cnt) = 'Y')) THEN
1566:

Line 1585: (Pa_Proj_Accum_Main.action_exists

1581:
1582: END IF ;
1583:
1584: IF (x_commitments_flag = 'Y' AND
1585: (Pa_Proj_Accum_Main.action_exists
1586: (x_action_flag => 'CM',
1587: x_actions_in => x_actions_in,
1588: x_actions_cnt => x_actions_cnt) = 'Y')) THEN
1589:

Line 1647: IF Pa_Proj_Accum_Main.action_exists

1643: END IF;
1644:
1645: END IF;
1646:
1647: IF Pa_Proj_Accum_Main.action_exists
1648: (x_action_flag => 'PR',
1649: x_actions_in => x_actions_in,
1650: x_actions_cnt => x_actions_cnt) = 'Y' THEN
1651:

Line 1693: -- (pa_proj_accum_main.action_exists

1689: -- no new commitments to be processed
1690:
1691: -- IF (x_commitments_flag <> 'Y')
1692: -- OR (x_commitments_flag = 'Y' AND
1693: -- (pa_proj_accum_main.action_exists
1694: -- (x_action_flag => 'CM',
1695: -- x_actions_in => x_actions_in,
1696: -- x_actions_cnt => x_actions_cnt) <> 'Y' AND
1697: -- pa_proj_accum_main.action_exists

Line 1697: -- pa_proj_accum_main.action_exists

1693: -- (pa_proj_accum_main.action_exists
1694: -- (x_action_flag => 'CM',
1695: -- x_actions_in => x_actions_in,
1696: -- x_actions_cnt => x_actions_cnt) <> 'Y' AND
1697: -- pa_proj_accum_main.action_exists
1698: -- (x_action_flag => 'TM',
1699: -- x_actions_in => x_actions_in,
1700: -- x_actions_cnt => x_actions_cnt) <> 'Y')) THEN
1701:

Line 1735: IF Pa_Proj_Accum_Main.action_exists

1731: tmp_bud_type_code := NULL ;
1732:
1733: END IF ;
1734:
1735: IF Pa_Proj_Accum_Main.action_exists
1736: (x_action_flag => 'PR',
1737: x_actions_in => x_actions_in,
1738: x_actions_cnt => x_actions_cnt) = 'Y'
1739: OR (x_budgets_flag = 'Y' AND

Line 1740: Pa_Proj_Accum_Main.action_exists

1736: (x_action_flag => 'PR',
1737: x_actions_in => x_actions_in,
1738: x_actions_cnt => x_actions_cnt) = 'Y'
1739: OR (x_budgets_flag = 'Y' AND
1740: Pa_Proj_Accum_Main.action_exists
1741: (x_action_flag => 'BD',
1742: x_actions_in => x_actions_in,
1743: x_actions_cnt => x_actions_cnt) = 'Y') THEN
1744:

Line 1798: IF Pa_Proj_Accum_Main.action_exists

1794: x_err_stack,
1795: x_err_stage,
1796: x_err_code);
1797:
1798: IF Pa_Proj_Accum_Main.action_exists
1799: (x_action_flag => 'CS',
1800: x_actions_in => x_actions_in,
1801: x_actions_cnt => x_actions_cnt) = 'Y'
1802: OR Pa_Proj_Accum_Main.action_exists

Line 1802: OR Pa_Proj_Accum_Main.action_exists

1798: IF Pa_Proj_Accum_Main.action_exists
1799: (x_action_flag => 'CS',
1800: x_actions_in => x_actions_in,
1801: x_actions_cnt => x_actions_cnt) = 'Y'
1802: OR Pa_Proj_Accum_Main.action_exists
1803: (x_action_flag => 'RV',
1804: x_actions_in => x_actions_in,
1805: x_actions_cnt => x_actions_cnt) = 'Y'
1806: OR Pa_Proj_Accum_Main.action_exists

Line 1806: OR Pa_Proj_Accum_Main.action_exists

1802: OR Pa_Proj_Accum_Main.action_exists
1803: (x_action_flag => 'RV',
1804: x_actions_in => x_actions_in,
1805: x_actions_cnt => x_actions_cnt) = 'Y'
1806: OR Pa_Proj_Accum_Main.action_exists
1807: (x_action_flag => 'CM',
1808: x_actions_in => x_actions_in,
1809: x_actions_cnt => x_actions_cnt) = 'Y'
1810: OR Pa_Proj_Accum_Main.action_exists

Line 1810: OR Pa_Proj_Accum_Main.action_exists

1806: OR Pa_Proj_Accum_Main.action_exists
1807: (x_action_flag => 'CM',
1808: x_actions_in => x_actions_in,
1809: x_actions_cnt => x_actions_cnt) = 'Y'
1810: OR Pa_Proj_Accum_Main.action_exists
1811: (x_action_flag => 'TM',
1812: x_actions_in => x_actions_in,
1813: x_actions_cnt => x_actions_cnt) = 'Y'
1814: OR Pa_Proj_Accum_Main.action_exists

Line 1814: OR Pa_Proj_Accum_Main.action_exists

1810: OR Pa_Proj_Accum_Main.action_exists
1811: (x_action_flag => 'TM',
1812: x_actions_in => x_actions_in,
1813: x_actions_cnt => x_actions_cnt) = 'Y'
1814: OR Pa_Proj_Accum_Main.action_exists
1815: (x_action_flag => 'TX',
1816: x_actions_in => x_actions_in,
1817: x_actions_cnt => x_actions_cnt) = 'Y' THEN
1818:

Line 1832: -- IF (pa_proj_accum_main.action_exists

1828: IF x_log_summ_mode = 'Y' THEN
1829: x_MapTxnEnd := SYSDATE; --End time for Map Txns
1830: END IF;
1831:
1832: -- IF (pa_proj_accum_main.action_exists
1833: -- (x_action_flag => 'CM',
1834: -- x_actions_in => x_actions_in,
1835: -- x_actions_cnt => x_actions_cnt) = 'Y'
1836: -- AND x_commitments_flag = 'Y')

Line 1837: -- OR pa_proj_accum_main.action_exists

1833: -- (x_action_flag => 'CM',
1834: -- x_actions_in => x_actions_in,
1835: -- x_actions_cnt => x_actions_cnt) = 'Y'
1836: -- AND x_commitments_flag = 'Y')
1837: -- OR pa_proj_accum_main.action_exists
1838: -- (x_action_flag => 'PR',
1839: -- x_actions_in => x_actions_in,
1840: -- x_actions_cnt => x_actions_cnt) = 'Y'
1841: -- OR (pa_proj_accum_main.action_exists

Line 1841: -- OR (pa_proj_accum_main.action_exists

1837: -- OR pa_proj_accum_main.action_exists
1838: -- (x_action_flag => 'PR',
1839: -- x_actions_in => x_actions_in,
1840: -- x_actions_cnt => x_actions_cnt) = 'Y'
1841: -- OR (pa_proj_accum_main.action_exists
1842: -- (x_action_flag => 'TM',
1843: -- x_actions_in => x_actions_in,
1844: -- x_actions_cnt => x_actions_cnt) = 'Y'
1845: -- AND x_commitments_flag = 'Y')

Line 1874: IF (Pa_Proj_Accum_Main.action_exists

1870: -- END IF;
1871: --
1872: -- END IF ;
1873:
1874: IF (Pa_Proj_Accum_Main.action_exists
1875: (x_action_flag => 'CS',
1876: x_actions_in => x_actions_in,
1877: x_actions_cnt => x_actions_cnt) = 'Y'
1878: AND x_actual_cost_flag = 'Y')

Line 1879: OR (Pa_Proj_Accum_Main.action_exists

1875: (x_action_flag => 'CS',
1876: x_actions_in => x_actions_in,
1877: x_actions_cnt => x_actions_cnt) = 'Y'
1878: AND x_actual_cost_flag = 'Y')
1879: OR (Pa_Proj_Accum_Main.action_exists
1880: (x_action_flag => 'RV',
1881: x_actions_in => x_actions_in,
1882: x_actions_cnt => x_actions_cnt) = 'Y'
1883: AND x_revenue_flag = 'Y')

Line 1884: OR Pa_Proj_Accum_Main.action_exists

1880: (x_action_flag => 'RV',
1881: x_actions_in => x_actions_in,
1882: x_actions_cnt => x_actions_cnt) = 'Y'
1883: AND x_revenue_flag = 'Y')
1884: OR Pa_Proj_Accum_Main.action_exists
1885: (x_action_flag => 'TX',
1886: x_actions_in => x_actions_in,
1887: x_actions_cnt => x_actions_cnt) = 'Y'
1888: OR (Pa_Proj_Accum_Main.action_exists

Line 1888: OR (Pa_Proj_Accum_Main.action_exists

1884: OR Pa_Proj_Accum_Main.action_exists
1885: (x_action_flag => 'TX',
1886: x_actions_in => x_actions_in,
1887: x_actions_cnt => x_actions_cnt) = 'Y'
1888: OR (Pa_Proj_Accum_Main.action_exists
1889: (x_action_flag => 'CM',
1890: x_actions_in => x_actions_in,
1891: x_actions_cnt => x_actions_cnt) = 'Y'
1892: AND x_commitments_flag = 'Y')

Line 1893: OR (Pa_Proj_Accum_Main.action_exists

1889: (x_action_flag => 'CM',
1890: x_actions_in => x_actions_in,
1891: x_actions_cnt => x_actions_cnt) = 'Y'
1892: AND x_commitments_flag = 'Y')
1893: OR (Pa_Proj_Accum_Main.action_exists
1894: (x_action_flag => 'TM',
1895: x_actions_in => x_actions_in,
1896: x_actions_cnt => x_actions_cnt) = 'Y'
1897: AND x_commitments_flag = 'Y') THEN

Line 2183: x_err_stack := x_err_stack ||'->pa_proj_accum_main.proj_refresh';

2179:
2180: BEGIN
2181:
2182: x_old_stack := x_err_stack;
2183: x_err_stack := x_err_stack ||'->pa_proj_accum_main.proj_refresh';
2184: x_err_code := 0;
2185:
2186: x_summ_process := 'RF';
2187: x_err_stage := 'Project refresh Process';

Line 2242: Pa_Proj_Accum_Main.initialize;

2238: retcode :=0;
2239:
2240: -- Call the Initialization procedure
2241:
2242: Pa_Proj_Accum_Main.initialize;
2243: -- Added below for Bug# 7175975
2244: populate_cmt_tmp_table(p_project_num_from => l_project_num_from,
2245: p_project_num_to => l_project_num_to, -- Bug 9354283
2246: p_system_linkage_function => NULL,

Line 2266: Pa_Proj_Accum_Main.initialize_project(projrec.project_id,

2262:
2263: -- Initialize the Global variable in the loop for each project
2264: -- No need to check if the accumulation period type has been changed
2265: -- because the project is being refreshed
2266: Pa_Proj_Accum_Main.initialize_project(projrec.project_id,
2267: l_accum_period_type_changed);
2268:
2269: -- Try to Lock the project level record
2270: IF Pa_Debug.acquire_user_lock('PA_SUMM:'||TO_CHAR(projrec.project_id)) <> 0 THEN

Line 2389: IF (Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening = 'Y')

2385: x_err_stage,
2386: x_err_code);
2387:
2388: -- 05-AUG-2003, jwhite: For patchset 'L' Reburdening Enhancement
2389: IF (Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening = 'Y')
2390: THEN
2391:
2392: IF ( P_DEBUG_MODE = 'Y' )
2393: THEN

Line 2857: x_err_stack := x_err_stack || '->pa_proj_accum_main.ref_rl_accum';

2853: x_err_code := 0;
2854: x_old_stack := x_err_stack;
2855:
2856: x_summ_process := 'RL';
2857: x_err_stack := x_err_stack || '->pa_proj_accum_main.ref_rl_accum';
2858: x_err_stage := 'Refresh Resource List accumulation Process';
2859:
2860: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2861: Pa_Debug.debug('ref_rl_accum: ' || x_err_stack);

Line 2876: Pa_Proj_Accum_Main.initialize;

2872: retcode :=0;
2873:
2874: -- Call the Initialization procedure
2875:
2876: Pa_Proj_Accum_Main.initialize;
2877:
2878: FOR projrec IN selprjs LOOP
2879:
2880: BEGIN

Line 2905: Pa_Proj_Accum_Main.initialize_project(projrec.project_id,

2901: || TO_CHAR(projrec.project_id));
2902: END IF;
2903:
2904: -- Initialize the Global variable in the loop for each project
2905: Pa_Proj_Accum_Main.initialize_project(projrec.project_id,
2906: l_accum_period_type_changed);
2907: IF x_impl_option = 'PA' THEN
2908: l_current_start_date := x_current_pa_start_date;
2909: l_current_end_date := x_current_pa_end_date;

Line 2919: IF (Pa_Proj_Accum_Main.check_period_flags(projrec.project_id,x_impl_option,l_current_end_date,

2915: --
2916: -- Check to see if the accumulation period type has changed. If so, the
2917: -- project must be refreshed. Bug #572031
2918: --
2919: IF (Pa_Proj_Accum_Main.check_period_flags(projrec.project_id,x_impl_option,l_current_end_date,
2920: 'PT',projrec.closed_date,l_current_start_date)='Y') THEN
2921: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2922: Pa_Debug.debug('ref_rl_accum: ' || '*********************************************************************************',Pa_Debug.DEBUG_LEVEL_EXCEPTION);
2923: Pa_Debug.debug('ref_rl_accum: ' || '*****THE ACCUMULATION PERIOD TYPE HAS CHANGED SINCE THE LAST TIME PROJECT ' || projrec.segment1 || ' WAS ACCUMULATED '|| '******',

Line 3214: x_err_stack := x_err_stack || '->pa_proj_accum_main.build_txn_accum';

3210: x_err_stage := 'Build Transaction accumulation Process';
3211:
3212: x_summ_process := 'RT';
3213: x_old_stack := x_err_stack;
3214: x_err_stack := x_err_stack || '->pa_proj_accum_main.build_txn_accum';
3215:
3216: x_mode := 'F';
3217:
3218: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 3243: Pa_Proj_Accum_Main.initialize;

3239: -- all the parameters are validated now
3240:
3241: -- Call the Initialization procedure
3242:
3243: Pa_Proj_Accum_Main.initialize;
3244:
3245: -- Get the start pa_date and end pa_date for processing
3246:
3247: IF ( x_start_pa_period IS NOT NULL ) THEN

Line 3303: Pa_Proj_Accum_Main.initialize_project(projrec.project_id, l_accum_period_type_changed);

3299:
3300: -- Initialize the Global variable in the loop for each project
3301: -- No need to check if the accumulation period type has changed because
3302: -- the project is being refreshed
3303: Pa_Proj_Accum_Main.initialize_project(projrec.project_id, l_accum_period_type_changed);
3304:
3305: -- Get the accum configuration
3306:
3307: Pa_Txn_Accums.get_accum_configurations

Line 3391: IF (Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening = 'Y')

3387: x_err_code);
3388:
3389:
3390: -- 05-AUG-2003, jwhite: For patchset 'L' Reburdening Enhancement
3391: IF (Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening = 'Y')
3392: THEN
3393:
3394:
3395: IF ( P_DEBUG_MODE = 'Y' )

Line 3570: x_err_stack ||'->pa_proj_accum_main.lock_proj_level_header_record';

3566: dummy_project_id NUMBER;
3567: BEGIN
3568: x_old_stack := x_err_stack;
3569: x_err_stack :=
3570: x_err_stack ||'->pa_proj_accum_main.lock_proj_level_header_record';
3571: x_err_code := 0;
3572: x_err_stage :=
3573: 'locking the project level header record for project_id= '||x_project_id;
3574:

Line 3627: RETURN Pa_Proj_Accum_Main.x_current_end_date;

3623: FUNCTION Get_curr_end_date
3624: RETURN DATE
3625: IS
3626: BEGIN
3627: RETURN Pa_Proj_Accum_Main.x_current_end_date;
3628: EXCEPTION
3629: WHEN OTHERS THEN
3630: RAISE;
3631: END Get_curr_end_date;

Line 4309: END Pa_Proj_Accum_Main;

4305: END populate_cmt_tmp_table;
4306:
4307: /* Procedure added for bug#6408874 */
4308:
4309: END Pa_Proj_Accum_Main;