DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on FND_PROFILE

Line 173: -- Also, added FND_PROFILE.value call to Initialization

169: --
170: -- 31-JUL-03 jwhite For patchset 'L' Reburdening Enhancement, added this
171: -- IN-parm to the accum_cdls procedure:
172: -- x_cdl_line_type VARCHAR2
173: -- Also, added FND_PROFILE.value call to Initialization
174: -- procedure for conditional processing:
175: -- Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening
176: --
177: -- 01-JUL-04 sacgupta Added call to new procedure get_pa_period_info1

Line 185: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

181:
182: PROCEDURE initialize
183:
184: IS
185: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
186:
187: BEGIN
188:
189: x_old_stack := x_err_stack;

Line 204: IF Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET') IS NOT NULL THEN

200: Pa_Debug.debug(x_err_stack);
201: END IF;
202:
203: --- Getting the commit size--------------
204: IF Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET') IS NOT NULL THEN
205: Pa_Proj_Accum_Main.x_commit_size := Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET');
206: ELSE
207: Pa_Proj_Accum_Main.x_commit_size := 500;
208: END IF;

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

201: END IF;
202:
203: --- Getting the commit size--------------
204: IF Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET') IS NOT NULL THEN
205: Pa_Proj_Accum_Main.x_commit_size := Fnd_Profile.value('PA_NUM_EXP_ITEMS_PER_SET');
206: ELSE
207: Pa_Proj_Accum_Main.x_commit_size := 500;
208: END IF;
209:

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

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

Line 333: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

329:
330: PROCEDURE initialize_project (x_project_id IN NUMBER,
331: x_accum_period_type_changed OUT NOCOPY BOOLEAN) --File.Sql.39 bug 4440895
332: IS
333: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
334: l_accum_period_type_changed BOOLEAN;
335:
336:
337: BEGIN

Line 498: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

494: x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
495: x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
496: x_err_code IN OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
497: IS
498: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
499:
500: BEGIN
501:
502: x_old_stack := x_err_stack;

Line 768: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

764: )
765: IS
766:
767: /* Added Debug Profile Option variable initialization for bug#2674619 */
768: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
769:
770:
771:
772: x_log_summ_mode VARCHAR2(1) := 'N';

Line 954: x_log_summ_mode := Fnd_Profile.value('PA_LOG_SUMM_MODE');

950: x_err_code := 0;
951:
952: x_summ_process := 'UP';
953: x_err_stage := 'Project Accumulation Process';
954: x_log_summ_mode := Fnd_Profile.value('PA_LOG_SUMM_MODE');
955:
956: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
957: Pa_Debug.debug('proj_accum: ' || x_err_stack);
958: END IF;

Line 2066: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

2062: IS
2063:
2064: /* Added Debug Profile Option variable initialization for bug#2674619 */
2065:
2066: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2067:
2068:
2069:
2070: l_accum_period_type_changed BOOLEAN;

Line 2139: x_log_summ_mode := Fnd_Profile.value('PA_LOG_SUMM_MODE');

2135: x_err_code := 0;
2136:
2137: x_summ_process := 'RF';
2138: x_err_stage := 'Project refresh Process';
2139: x_log_summ_mode := Fnd_Profile.value('PA_LOG_SUMM_MODE');
2140:
2141: IF (x_end_date_through IS NULL OR x_end_date_through >= x_current_pa_end_date) THEN
2142: x_date_through := x_end_pa_date;
2143: ELSE

Line 2761: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

2757: x_project_num_to IN VARCHAR2,
2758: x_resource_list_id IN NUMBER
2759: )
2760: IS
2761: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
2762: l_accum_period_type_changed BOOLEAN;
2763: l_sum_exception_code pa_project_accum_headers.sum_exception_code%TYPE := NULL;
2764: l_current_start_date DATE := NULL;
2765: l_current_end_date DATE := NULL;

Line 3119: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

3115: x_end_pa_period IN VARCHAR2,
3116: x_system_linkage_function IN VARCHAR2
3117: )
3118: IS
3119: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
3120: l_accum_period_type_changed BOOLEAN;
3121: -- Declare cursor for Projects
3122:
3123: l_project_num_from VARCHAR2(25);

Line 3502: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

3498:
3499: PROCEDURE lock_proj_level_header_record
3500: (x_project_id IN NUMBER)
3501: IS
3502: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
3503: dummy_project_id NUMBER;
3504: BEGIN
3505: x_old_stack := x_err_stack;
3506: x_err_stack :=