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_ACCUM_UTILS dependencies on PA_ACCUM_UTILS

Line 1: PACKAGE body PA_ACCUM_UTILS AS

1: PACKAGE body PA_ACCUM_UTILS AS
2: /* $Header: PAACUTIB.pls 120.2 2010/10/01 15:11:33 kmaddi ship $ */
3:
4: -- Proj_level_record - This verifies for the existence of the Project level
5: -- record (Task id = 0 and Resource list member id = 0)

Line 33: x_err_stack||'->PA_ACCUM_UTILS.Proj_level_record';

29: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
30: Begin
31: V_Old_Stack := x_err_stack;
32: x_err_stack :=
33: x_err_stack||'->PA_ACCUM_UTILS.Proj_level_record';
34:
35: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
36: pa_debug.debug('Proj_level_record: ' || x_err_stack);
37: END IF;

Line 174: x_err_stack||'->PA_ACCUM_UTILS.Get_Impl_Option';

170: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
171: Begin
172: V_Old_Stack := x_err_stack;
173: x_err_stack :=
174: x_err_stack||'->PA_ACCUM_UTILS.Get_Impl_Option';
175:
176: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
177: pa_debug.debug('Get_Impl_Option: ' || x_err_stack);
178: END IF;

Line 212: x_err_stack||'->PA_ACCUM_UTILS.Get_Current_period_Info';

208: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
209: Begin
210: V_Old_Stack := x_err_stack;
211: x_err_stack :=
212: x_err_stack||'->PA_ACCUM_UTILS.Get_Current_period_Info';
213:
214: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
215: pa_debug.debug('Get_Current_period_Info: ' || x_err_stack);
216: END IF;

Line 317: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info';

313: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
314: BEGIN
315: V_Old_Stack := x_err_stack;
316: x_err_stack :=
317: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info';
318: x_accum_period_type_changed := FALSE;
319:
320: -- Select the details pertaining to the previous pa period.
321:

Line 474: x_err_stack||'->PA_ACCUM_UTILS.Get_period_year_Info';

470: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
471: BEGIN
472: V_Old_Stack := x_err_stack;
473: x_err_stack :=
474: x_err_stack||'->PA_ACCUM_UTILS.Get_period_year_Info';
475:
476: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
477: pa_debug.debug('Get_period_year_info: ' || x_err_stack);
478: END IF;

Line 547: x_err_stack||'->PA_ACCUM_UTILS.Check_Actuals_Details';

543:
544: Begin
545: V_Old_Stack := x_err_stack;
546: x_err_stack :=
547: x_err_stack||'->PA_ACCUM_UTILS.Check_Actuals_Details';
548: V_task_id := X_Task_id;
549: Open Get_Accum_Id_Cur;
550: Fetch Get_Accum_Id_Cur Into V_Accum_id;
551: -- If we get such a record in Headers, then we insert one record in

Line 696: x_err_stack||'->PA_ACCUM_UTILS.Check_Cmt_Details';

692:
693: Begin
694: V_Old_Stack := x_err_stack;
695: x_err_stack :=
696: x_err_stack||'->PA_ACCUM_UTILS.Check_Cmt_Details';
697: V_task_id := X_Task_id;
698:
699: Open Get_Accum_Id_Cur;
700: Fetch Get_Accum_Id_Cur Into V_Accum_id;

Line 828: x_err_stack||'->PA_ACCUM_UTILS.Check_Budget_Details';

824:
825: Begin
826: V_Old_Stack := x_err_stack;
827: x_err_stack :=
828: x_err_stack||'->PA_ACCUM_UTILS.Check_Budget_Details';
829: V_task_id := X_Task_id;
830: Open Get_Accum_Id_Cur;
831: Fetch Get_Accum_Id_Cur Into V_Accum_id;
832:

Line 989: x_err_stack := x_err_stack || '->PA_ACCUM_UTILS.Get_config_Option ';

985: Begin
986: x_err_code := 0;
987: x_Accum_flag := NULL;
988: v_old_stack := x_err_stack;
989: x_err_stack := x_err_stack || '->PA_ACCUM_UTILS.Get_config_Option ';
990: x_err_stage := ' Select Project_Type_class_code ';
991:
992: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
993: pa_debug.debug('Get_Config_Option: ' || x_err_stack);

Line 1069: x_err_stack||'->PA_ACCUM_UTILS.Get_existing_higher_tasks';

1065: V_Old_Stack Varchar2(630);
1066: Begin
1067: V_Old_Stack := x_err_stack;
1068: x_err_stack :=
1069: x_err_stack||'->PA_ACCUM_UTILS.Get_existing_higher_tasks';
1070: For Task_Rec IN Tasks_Cur LOOP
1071: v_noof_tasks := v_noof_tasks + 1;
1072: x_task_array(v_noof_tasks) := Task_Rec.Task_id;
1073: END LOOP;

Line 1100: x_err_stack||'->PA_ACCUM_UTILS.update_proj_accum_header';

1096: Begin
1097: V_Old_Stack := x_err_stack;
1098: x_err_code := 0;
1099: x_err_stack :=
1100: x_err_stack||'->PA_ACCUM_UTILS.update_proj_accum_header';
1101:
1102: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1103: pa_debug.debug('update_proj_accum_header: ' || x_err_stack);
1104: END IF;

Line 1141: x_err_stack||'->PA_ACCUM_UTILS.update_tasks_restructured_flag';

1137: Begin
1138: V_Old_Stack := x_err_stack;
1139: x_err_code := 0;
1140: x_err_stack :=
1141: x_err_stack||'->PA_ACCUM_UTILS.update_tasks_restructured_flag';
1142:
1143: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1144: pa_debug.debug('update_tasks_restructured_flag: ' || x_err_stack);
1145: END IF;

Line 1182: x_err_stack||'->PA_ACCUM_UTILS.check_tasks_restructured_flag';

1178: Begin
1179: V_Old_Stack := x_err_stack;
1180: x_err_code := 0;
1181: x_err_stack :=
1182: x_err_stack||'->PA_ACCUM_UTILS.check_tasks_restructured_flag';
1183:
1184: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1185: pa_debug.debug('check_tasks_restructured_flag: ' || x_err_stack);
1186: END IF;

Line 1451: pa_accum_utils.g_check_reporting_end_date := lcl_end_date;

1447: into lcl_end_date
1448: from PA_PERIODS_V pav, pa_implementations pai
1449: where period_name = x_period_name;
1450:
1451: pa_accum_utils.g_check_reporting_end_date := lcl_end_date;
1452:
1453: END set_check_reporting_end_date;
1454:
1455: FUNCTION get_check_reporting_end_date

Line 1463: IF pa_accum_utils.g_check_reporting_end_date is null

1459: BEGIN
1460:
1461: -- Check the global variable for a reporting period. If none is set,
1462: -- return the current reporting period
1463: IF pa_accum_utils.g_check_reporting_end_date is null
1464: THEN
1465: /* Bug 2634995 begins */
1466: --Replaced the pa_periods_v with the view definition
1467: -- select decode( pai.accumulation_period_type, 'PA', pav.pa_end_date,

Line 1488: return pa_accum_utils.g_check_reporting_end_date;

1484: /* Bug 2634995 ends */
1485:
1486: return lcl_end_date;
1487: ELSE
1488: return pa_accum_utils.g_check_reporting_end_date;
1489: END IF;
1490:
1491: return pa_accum_utils.g_check_reporting_end_date;
1492: END get_check_reporting_end_date;

Line 1491: return pa_accum_utils.g_check_reporting_end_date;

1487: ELSE
1488: return pa_accum_utils.g_check_reporting_end_date;
1489: END IF;
1490:
1491: return pa_accum_utils.g_check_reporting_end_date;
1492: END get_check_reporting_end_date;
1493:
1494:
1495: Procedure Set_current_period_Info IS

Line 1499: pa_debug.debug('pa_accum_utils.set_current_period_info');

1495: Procedure Set_current_period_Info IS
1496: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
1497: Begin
1498: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1499: pa_debug.debug('pa_accum_utils.set_current_period_info');
1500: END IF;
1501:
1502: SELECT
1503: period_name,

Line 1534: IF pa_accum_utils.g_current_pa_period is null

1530: -- Return the value in global variable g_current_pa_period,if it is set.
1531: -- If g_current_pa_period is not set,fetch the current pa period from
1532: -- the database
1533:
1534: IF pa_accum_utils.g_current_pa_period is null
1535: THEN
1536: SELECT
1537: period_name
1538: INTO

Line 1544: l_current_pa_period := pa_accum_utils.g_current_pa_period;

1540: FROM pa_periods
1541: WHERE
1542: current_pa_period_flag = 'Y';
1543: ELSE
1544: l_current_pa_period := pa_accum_utils.g_current_pa_period;
1545: END IF;
1546:
1547: return l_current_pa_period;
1548:

Line 1565: IF pa_accum_utils.g_current_gl_period is null

1561: -- Return the value in global variable g_current_gl_period,if it is set.
1562: -- If g_current_gl_period is not set,fetch the current gl period from
1563: -- the database
1564:
1565: IF pa_accum_utils.g_current_gl_period is null
1566: THEN
1567: SELECT
1568: gl_period_name
1569: INTO

Line 1575: l_current_gl_period := pa_accum_utils.g_current_gl_period;

1571: FROM pa_periods
1572: WHERE
1573: current_pa_period_flag = 'Y';
1574: ELSE
1575: l_current_gl_period := pa_accum_utils.g_current_gl_period;
1576: END IF;
1577:
1578: return l_current_gl_period;
1579:

Line 1688: If pa_accum_utils.G_grouping_id Is Not Null Then

1684: Is
1685: Group_id Number := NULL;
1686:
1687: Begin
1688: If pa_accum_utils.G_grouping_id Is Not Null Then
1689: Group_id := pa_accum_utils.G_grouping_id;
1690: End If;
1691:
1692: Return Group_id;

Line 1689: Group_id := pa_accum_utils.G_grouping_id;

1685: Group_id Number := NULL;
1686:
1687: Begin
1688: If pa_accum_utils.G_grouping_id Is Not Null Then
1689: Group_id := pa_accum_utils.G_grouping_id;
1690: End If;
1691:
1692: Return Group_id;
1693:

Line 1709: If pa_accum_utils.G_context Is Not Null Then

1705: Is
1706: Summ_context Varchar2(25) := NULL;
1707:
1708: Begin
1709: If pa_accum_utils.G_context Is Not Null Then
1710: Summ_context := pa_accum_utils.G_context;
1711: End If;
1712:
1713: Return Summ_context;

Line 1710: Summ_context := pa_accum_utils.G_context;

1706: Summ_context Varchar2(25) := NULL;
1707:
1708: Begin
1709: If pa_accum_utils.G_context Is Not Null Then
1710: Summ_context := pa_accum_utils.G_context;
1711: End If;
1712:
1713: Return Summ_context;
1714:

Line 1732: If pa_accum_utils.G_start_proj Is Not Null Then

1728: Proj_num Varchar2(25) := NULL;
1729: Begin
1730:
1731: If x_From_Or_To = 'F' Then -- From which project
1732: If pa_accum_utils.G_start_proj Is Not Null Then
1733: Proj_num := pa_accum_utils.G_start_proj;
1734: End If;
1735: Else -- Till which project
1736: If pa_accum_utils.G_end_proj Is Not Null Then

Line 1733: Proj_num := pa_accum_utils.G_start_proj;

1729: Begin
1730:
1731: If x_From_Or_To = 'F' Then -- From which project
1732: If pa_accum_utils.G_start_proj Is Not Null Then
1733: Proj_num := pa_accum_utils.G_start_proj;
1734: End If;
1735: Else -- Till which project
1736: If pa_accum_utils.G_end_proj Is Not Null Then
1737: Proj_num := pa_accum_utils.G_end_proj;

Line 1736: If pa_accum_utils.G_end_proj Is Not Null Then

1732: If pa_accum_utils.G_start_proj Is Not Null Then
1733: Proj_num := pa_accum_utils.G_start_proj;
1734: End If;
1735: Else -- Till which project
1736: If pa_accum_utils.G_end_proj Is Not Null Then
1737: Proj_num := pa_accum_utils.G_end_proj;
1738: End If;
1739: End If;
1740:

Line 1737: Proj_num := pa_accum_utils.G_end_proj;

1733: Proj_num := pa_accum_utils.G_start_proj;
1734: End If;
1735: Else -- Till which project
1736: If pa_accum_utils.G_end_proj Is Not Null Then
1737: Proj_num := pa_accum_utils.G_end_proj;
1738: End If;
1739: End If;
1740:
1741: Return Proj_num;

Line 1779: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info1';

1775: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1776: BEGIN
1777: V_Old_Stack := x_err_stack;
1778: x_err_stack :=
1779: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info1';
1780:
1781: -- Select the details pertaining to the previous pa period.
1782:
1783: IF P_DEBUG_MODE = 'Y' THEN

Line 1881: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info2';

1877: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1878: BEGIN
1879: V_Old_Stack := x_err_stack;
1880: x_err_stack :=
1881: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info2';
1882: x_accum_period_type_changed := FALSE;
1883:
1884: IF P_DEBUG_MODE = 'Y' THEN
1885: pa_debug.debug('Get_pa_period_Info2: ' || x_err_stack);

Line 1959: END pa_accum_utils;

1955: -- /*--------------------------------------------------------*/
1956: -- End of code added for performance issue 3653978
1957: -- /*--------------------------------------------------------*/
1958:
1959: END pa_accum_utils;