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.1 2005/08/19 16:15:02 mwasowic noship $ */
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 1447: pa_accum_utils.g_check_reporting_end_date := lcl_end_date;

1443: into lcl_end_date
1444: from PA_PERIODS_V pav, pa_implementations pai
1445: where period_name = x_period_name;
1446:
1447: pa_accum_utils.g_check_reporting_end_date := lcl_end_date;
1448:
1449: END set_check_reporting_end_date;
1450:
1451: FUNCTION get_check_reporting_end_date

Line 1459: IF pa_accum_utils.g_check_reporting_end_date is null

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

Line 1484: return pa_accum_utils.g_check_reporting_end_date;

1480: /* Bug 2634995 ends */
1481:
1482: return lcl_end_date;
1483: ELSE
1484: return pa_accum_utils.g_check_reporting_end_date;
1485: END IF;
1486:
1487: return pa_accum_utils.g_check_reporting_end_date;
1488: END get_check_reporting_end_date;

Line 1487: return pa_accum_utils.g_check_reporting_end_date;

1483: ELSE
1484: return pa_accum_utils.g_check_reporting_end_date;
1485: END IF;
1486:
1487: return pa_accum_utils.g_check_reporting_end_date;
1488: END get_check_reporting_end_date;
1489:
1490:
1491: Procedure Set_current_period_Info IS

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

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

Line 1530: IF pa_accum_utils.g_current_pa_period is null

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

Line 1540: l_current_pa_period := pa_accum_utils.g_current_pa_period;

1536: FROM pa_periods
1537: WHERE
1538: current_pa_period_flag = 'Y';
1539: ELSE
1540: l_current_pa_period := pa_accum_utils.g_current_pa_period;
1541: END IF;
1542:
1543: return l_current_pa_period;
1544:

Line 1561: IF pa_accum_utils.g_current_gl_period is null

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

Line 1571: l_current_gl_period := pa_accum_utils.g_current_gl_period;

1567: FROM pa_periods
1568: WHERE
1569: current_pa_period_flag = 'Y';
1570: ELSE
1571: l_current_gl_period := pa_accum_utils.g_current_gl_period;
1572: END IF;
1573:
1574: return l_current_gl_period;
1575:

Line 1684: If pa_accum_utils.G_grouping_id Is Not Null Then

1680: Is
1681: Group_id Number := NULL;
1682:
1683: Begin
1684: If pa_accum_utils.G_grouping_id Is Not Null Then
1685: Group_id := pa_accum_utils.G_grouping_id;
1686: End If;
1687:
1688: Return Group_id;

Line 1685: Group_id := pa_accum_utils.G_grouping_id;

1681: Group_id Number := NULL;
1682:
1683: Begin
1684: If pa_accum_utils.G_grouping_id Is Not Null Then
1685: Group_id := pa_accum_utils.G_grouping_id;
1686: End If;
1687:
1688: Return Group_id;
1689:

Line 1705: If pa_accum_utils.G_context Is Not Null Then

1701: Is
1702: Summ_context Varchar2(25) := NULL;
1703:
1704: Begin
1705: If pa_accum_utils.G_context Is Not Null Then
1706: Summ_context := pa_accum_utils.G_context;
1707: End If;
1708:
1709: Return Summ_context;

Line 1706: Summ_context := pa_accum_utils.G_context;

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

Line 1728: If pa_accum_utils.G_start_proj Is Not Null Then

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

Line 1729: Proj_num := pa_accum_utils.G_start_proj;

1725: Begin
1726:
1727: If x_From_Or_To = 'F' Then -- From which project
1728: If pa_accum_utils.G_start_proj Is Not Null Then
1729: Proj_num := pa_accum_utils.G_start_proj;
1730: End If;
1731: Else -- Till which project
1732: If pa_accum_utils.G_end_proj Is Not Null Then
1733: Proj_num := pa_accum_utils.G_end_proj;

Line 1732: If pa_accum_utils.G_end_proj Is Not Null Then

1728: If pa_accum_utils.G_start_proj Is Not Null Then
1729: Proj_num := pa_accum_utils.G_start_proj;
1730: End If;
1731: Else -- Till which project
1732: If pa_accum_utils.G_end_proj Is Not Null Then
1733: Proj_num := pa_accum_utils.G_end_proj;
1734: End If;
1735: End If;
1736:

Line 1733: Proj_num := pa_accum_utils.G_end_proj;

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

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

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

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

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

Line 1955: END pa_accum_utils;

1951: -- /*--------------------------------------------------------*/
1952: -- End of code added for performance issue 3653978
1953: -- /*--------------------------------------------------------*/
1954:
1955: END pa_accum_utils;