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.PSB_WS_ACCT2 dependencies on PSB_WORKSHEET

Line 726: IF ( PSB_WORKSHEET.g_ws_first_time_creation_flag AND

722: -- Bug 3543845: Reactivate the following line
723:
724: -- Bug 4250468 added the variable g_ws_first_time_creation_flag
725: -- in the IF condition
726: IF ( PSB_WORKSHEET.g_ws_first_time_creation_flag AND
727: ((l_ytd_amount <> 0)
728: OR
729: ( l_ytd_amount = 0 and g_create_zero_bal = 'Y' )
730: )

Line 732: OR NOT PSB_WORKSHEET.g_ws_first_time_creation_flag THEN

728: OR
729: ( l_ytd_amount = 0 and g_create_zero_bal = 'Y' )
730: )
731: )
732: OR NOT PSB_WORKSHEET.g_ws_first_time_creation_flag THEN
733:
734: begin
735:
736: if g_balance_type(l_type_index) = 'E' then

Line 2355: IF (PSB_WORKSHEET.g_ws_first_time_creation_flag AND

2351: END IF;
2352:
2353: -- Bug 4250468 added the variable g_ws_first_time_creation_flag
2354: -- in the IF condition
2355: IF (PSB_WORKSHEET.g_ws_first_time_creation_flag AND
2356: ( l_ytd_estimate_amount <> 0
2357: OR
2358: (l_ytd_estimate_amount = 0 and g_create_zero_bal = 'Y')
2359: )

Line 2361: OR NOT PSB_WORKSHEET.g_ws_first_time_creation_flag THEN

2357: OR
2358: (l_ytd_estimate_amount = 0 and g_create_zero_bal = 'Y')
2359: )
2360: )
2361: OR NOT PSB_WORKSHEET.g_ws_first_time_creation_flag THEN
2362:
2363:
2364: --pd('2: Call Create_Account_Dist=> ccid=' || TO_CHAR(p_ccid) ||
2365: -- ', p_budget_year_id=' || TO_CHAR(p_budget_year_id) ||

Line 2549: FROM psb_worksheets_v

2545: budget_calendar_id ,
2546: include_gl_commit_balance ,
2547: include_gl_oblig_balance ,
2548: include_gl_other_balance
2549: FROM psb_worksheets_v
2550: WHERE worksheet_id = p_worksheet_id
2551: )
2552: LOOP
2553: l_budget_by_position := l_ws_rec.budget_by_position;

Line 2617: psb_worksheets_v b

2613: FOR l_sp_rec IN
2614: (
2615: SELECT a.service_package_id
2616: FROM psb_service_packages a,
2617: psb_worksheets_v b
2618: WHERE a.base_service_package = 'Y'
2619: AND ( a.global_worksheet_id = b.worksheet_id
2620: OR
2621: a.global_worksheet_id = b.global_worksheet_id

Line 3208: from PSB_WORKSHEETS b,

3204: and a.end_stage_seq is null
3205: and a.template_id is null
3206: and exists
3207: (select 1
3208: from PSB_WORKSHEETS b,
3209: PSB_BUDGET_PERIODS c
3210: where b.worksheet_id = p_worksheet_id
3211: and a.stage_set_id = b.stage_set_id
3212: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq

Line 3227: from PSB_WORKSHEETS b,

3223:
3224: -- commented as a part of bug fix 4256345
3225: /* cursor c_Type12 is
3226: select sum(nvl(a.ytd_amount, 0)) YTD_Amount
3227: from PSB_WORKSHEETS b,
3228: PSB_WS_LINES d,
3229: PSB_WS_ACCOUNT_LINES a,
3230: PSB_BUDGET_PERIODS c
3231: where b.worksheet_id = p_worksheet_id

Line 4078: from PSB_WORKSHEETS_V a,

4074: /* bug no 4256345 */
4075: a.stage_set_id,
4076: a.current_stage_seq
4077: /* bug no 4256345 */
4078: from PSB_WORKSHEETS_V a,
4079: PSB_BUDGET_GROUPS_V b
4080: where a.worksheet_id = p_worksheet_id
4081: and b.budget_group_id = a.budget_group_id;
4082:

Line 4423: from PSB_WORKSHEETS_V

4419: rounding_factor,
4420: gl_cutoff_period,
4421: num_years_to_allocate,
4422: budget_by_position
4423: from PSB_WORKSHEETS_V
4424: where worksheet_id = p_worksheet_id;
4425: */
4426:
4427: cursor c_SOB is

Line 4531: IF PSB_WORKSHEET.g_ws_creation_flag

4527: end loop;
4528: */
4529: -- Check the g_ws_creation_flag to determine whether to use the
4530: -- cached worksheet values.
4531: IF PSB_WORKSHEET.g_ws_creation_flag
4532: AND
4533: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id
4534: THEN
4535: -- Retrieve the worksheet values from cache to avoiding extra query

Line 4533: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id

4529: -- Check the g_ws_creation_flag to determine whether to use the
4530: -- cached worksheet values.
4531: IF PSB_WORKSHEET.g_ws_creation_flag
4532: AND
4533: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id
4534: THEN
4535: -- Retrieve the worksheet values from cache to avoiding extra query
4536: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
4537: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;

Line 4536: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;

4532: AND
4533: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id
4534: THEN
4535: -- Retrieve the worksheet values from cache to avoiding extra query
4536: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
4537: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
4538: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
4539: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;

Line 4537: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;

4533: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id
4534: THEN
4535: -- Retrieve the worksheet values from cache to avoiding extra query
4536: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
4537: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
4538: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
4539: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
4541: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;

Line 4538: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;

4534: THEN
4535: -- Retrieve the worksheet values from cache to avoiding extra query
4536: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
4537: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
4538: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
4539: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
4541: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
4542: l_parameter_set_id := PSB_WORKSHEET.g_parameter_set_id;

Line 4539: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;

4535: -- Retrieve the worksheet values from cache to avoiding extra query
4536: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
4537: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
4538: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
4539: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
4541: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
4542: l_parameter_set_id := PSB_WORKSHEET.g_parameter_set_id;
4543: l_num_years_to_allocate := PSB_WORKSHEET.g_num_years_to_allocate;

Line 4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;

4536: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
4537: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
4538: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
4539: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
4541: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
4542: l_parameter_set_id := PSB_WORKSHEET.g_parameter_set_id;
4543: l_num_years_to_allocate := PSB_WORKSHEET.g_num_years_to_allocate;
4544: l_budget_by_position := PSB_WORKSHEET.g_budget_by_position;

Line 4541: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;

4537: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
4538: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
4539: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
4541: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
4542: l_parameter_set_id := PSB_WORKSHEET.g_parameter_set_id;
4543: l_num_years_to_allocate := PSB_WORKSHEET.g_num_years_to_allocate;
4544: l_budget_by_position := PSB_WORKSHEET.g_budget_by_position;
4545:

Line 4542: l_parameter_set_id := PSB_WORKSHEET.g_parameter_set_id;

4538: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
4539: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
4541: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
4542: l_parameter_set_id := PSB_WORKSHEET.g_parameter_set_id;
4543: l_num_years_to_allocate := PSB_WORKSHEET.g_num_years_to_allocate;
4544: l_budget_by_position := PSB_WORKSHEET.g_budget_by_position;
4545:
4546: ELSE

Line 4543: l_num_years_to_allocate := PSB_WORKSHEET.g_num_years_to_allocate;

4539: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
4541: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
4542: l_parameter_set_id := PSB_WORKSHEET.g_parameter_set_id;
4543: l_num_years_to_allocate := PSB_WORKSHEET.g_num_years_to_allocate;
4544: l_budget_by_position := PSB_WORKSHEET.g_budget_by_position;
4545:
4546: ELSE
4547:

Line 4544: l_budget_by_position := PSB_WORKSHEET.g_budget_by_position;

4540: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
4541: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
4542: l_parameter_set_id := PSB_WORKSHEET.g_parameter_set_id;
4543: l_num_years_to_allocate := PSB_WORKSHEET.g_num_years_to_allocate;
4544: l_budget_by_position := PSB_WORKSHEET.g_budget_by_position;
4545:
4546: ELSE
4547:
4548: SELECT DECODE(global_worksheet_flag, 'Y', worksheet_id,

Line 4552: FROM psb_worksheets

4548: SELECT DECODE(global_worksheet_flag, 'Y', worksheet_id,
4549: global_worksheet_id) global_worksheet_id
4550: INTO
4551: l_global_worksheet_id
4552: FROM psb_worksheets
4553: WHERE worksheet_id = p_worksheet_id;
4554:
4555: SELECT gl_cutoff_period,
4556: allocrule_set_id allocrule_set_id,

Line 4572: FROM psb_worksheets

4568: l_flex_mapping_set_id,
4569: l_parameter_set_id,
4570: l_num_years_to_allocate,
4571: l_budget_by_position
4572: FROM psb_worksheets
4573: WHERE worksheet_id = l_global_worksheet_id;
4574:
4575: END IF;
4576: /* Bug 3543845 End */

Line 4896: IF ( PSB_WORKSHEET.g_ws_first_time_creation_flag

4892: -- Bug 3543845: Check whether the worksheet creation process is
4893: -- executed for the first time. If it is the first time, then check the
4894: -- running total and create zero balance profile. Otherwise, call the
4895: -- create_account_Dist without any filtering.
4896: IF ( PSB_WORKSHEET.g_ws_first_time_creation_flag
4897: and
4898: ( g_running_total <> 0
4899: or
4900: (g_running_total = 0 and g_create_zero_bal = 'Y')

Line 4904: NOT PSB_WORKSHEET.g_ws_first_time_creation_flag

4900: (g_running_total = 0 and g_create_zero_bal = 'Y')
4901: )
4902: )
4903: OR
4904: NOT PSB_WORKSHEET.g_ws_first_time_creation_flag
4905: THEN
4906: BEGIN
4907:
4908:

Line 5108: IF ( PSB_WORKSHEET.g_ws_first_time_creation_flag

5104: -- Bug 3543845: Check whether the worksheet creation process is
5105: -- executed for the first time. If it is the first time, then check the
5106: -- running total and create zero balance profile. Otherwise, call the
5107: -- create_account_Dist without any filtering.
5108: IF ( PSB_WORKSHEET.g_ws_first_time_creation_flag
5109: and
5110: ( g_running_total <> 0
5111: or
5112: (g_running_total = 0 and g_create_zero_bal = 'Y')

Line 5116: NOT PSB_WORKSHEET.g_ws_first_time_creation_flag

5112: (g_running_total = 0 and g_create_zero_bal = 'Y')
5113: )
5114: )
5115: OR
5116: NOT PSB_WORKSHEET.g_ws_first_time_creation_flag
5117: THEN
5118: BEGIN
5119:
5120: -- Create Account Distribution for the CCID

Line 5280: if ( PSB_WORKSHEET.g_ws_first_time_creation_flag

5276: -- Bug 3543845: Check whether the worksheet creation process is
5277: -- executed for the first time. If it is the first time, then check the
5278: -- running total and create zero balance profile. Otherwise, call the
5279: -- create_account_Dist without any filtering.
5280: if ( PSB_WORKSHEET.g_ws_first_time_creation_flag
5281: and
5282: ( g_running_total <> 0
5283: or
5284: (g_running_total = 0 and g_create_zero_bal = 'Y')

Line 5288: NOT PSB_WORKSHEET.g_ws_first_time_creation_flag

5284: (g_running_total = 0 and g_create_zero_bal = 'Y')
5285: )
5286: )
5287: OR
5288: NOT PSB_WORKSHEET.g_ws_first_time_creation_flag
5289: then
5290: begin
5291:
5292: --pd('3: Call Create_Account_Dist=> ccid=' || TO_CHAR(p_ccid) ||

Line 8062: from PSB_WORKSHEETS

8058: stage_set_id,
8059: current_stage_seq,
8060: budget_calendar_id,
8061: rounding_factor
8062: from PSB_WORKSHEETS
8063: where worksheet_id = p_worksheet_id;
8064:
8065: cursor c_BG is
8066: select nvl(set_of_books_id, root_set_of_books_id) set_of_books_id,

Line 8086: PSB_WORKSHEET.Delete_Summary_Lines

8082:
8083: -- Delete all Summary Account Lines from PSB_WS_ACCOUNT_LINES to obviate any changes
8084: -- to the Summary Account - Detailed Account mappings in GL
8085:
8086: PSB_WORKSHEET.Delete_Summary_Lines
8087: (p_api_version => 1.0,
8088: p_return_status => l_return_status,
8089: p_worksheet_id => p_worksheet_id);
8090: