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_ACCT1 dependencies on PSB_WORKSHEET

Line 470: IF PSB_WORKSHEET.g_ws_creation_flag

466: end if;
467:
468: /* Bug 3543845 start: Use caching when available */
469:
470: IF PSB_WORKSHEET.g_ws_creation_flag
471: THEN
472:
473: l_ps_acct_pos_set_id := PSB_WORKSHEET.g_ps_acct_pos_set_id;
474: l_nps_acct_pos_set_id := PSB_WORKSHEET.g_nps_acct_pos_set_id;

Line 473: l_ps_acct_pos_set_id := PSB_WORKSHEET.g_ps_acct_pos_set_id;

469:
470: IF PSB_WORKSHEET.g_ws_creation_flag
471: THEN
472:
473: l_ps_acct_pos_set_id := PSB_WORKSHEET.g_ps_acct_pos_set_id;
474: l_nps_acct_pos_set_id := PSB_WORKSHEET.g_nps_acct_pos_set_id;
475:
476: ELSE
477:

Line 474: l_nps_acct_pos_set_id := PSB_WORKSHEET.g_nps_acct_pos_set_id;

470: IF PSB_WORKSHEET.g_ws_creation_flag
471: THEN
472:
473: l_ps_acct_pos_set_id := PSB_WORKSHEET.g_ps_acct_pos_set_id;
474: l_nps_acct_pos_set_id := PSB_WORKSHEET.g_nps_acct_pos_set_id;
475:
476: ELSE
477:
478: SELECT root_budget_group_id,

Line 821: from PSB_WORKSHEETS_V

817: stage_set_id,
818: flex_mapping_set_id,
819: current_stage_seq,
820: local_copy_flag
821: from PSB_WORKSHEETS_V
822: where worksheet_id = p_worksheet_id;
823: */
824:
825: cursor c_sp is

Line 977: IF PSB_WORKSHEET.g_ws_creation_flag

973:
974: /* Bug 3458191 start */
975: -- Check the g_ws_creation_flag to determine whether to use the
976: -- cached worksheet values.
977: IF PSB_WORKSHEET.g_ws_creation_flag
978: AND
979: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id
980: THEN
981: -- Retrieve the worksheet values from cache to avoiding extra query

Line 979: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id

975: -- Check the g_ws_creation_flag to determine whether to use the
976: -- cached worksheet values.
977: IF PSB_WORKSHEET.g_ws_creation_flag
978: AND
979: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id
980: THEN
981: -- Retrieve the worksheet values from cache to avoiding extra query
982: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
983: l_local_copy_flag := PSB_WORKSHEET.g_local_copy_flag;

Line 982: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;

978: AND
979: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id
980: THEN
981: -- Retrieve the worksheet values from cache to avoiding extra query
982: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
983: l_local_copy_flag := PSB_WORKSHEET.g_local_copy_flag;
984: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
985: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;

Line 983: l_local_copy_flag := PSB_WORKSHEET.g_local_copy_flag;

979: PSB_WORKSHEET.g_worksheet_id = p_worksheet_id
980: THEN
981: -- Retrieve the worksheet values from cache to avoiding extra query
982: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
983: l_local_copy_flag := PSB_WORKSHEET.g_local_copy_flag;
984: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
985: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
987: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;

Line 984: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;

980: THEN
981: -- Retrieve the worksheet values from cache to avoiding extra query
982: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
983: l_local_copy_flag := PSB_WORKSHEET.g_local_copy_flag;
984: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
985: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
987: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
988: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;

Line 985: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;

981: -- Retrieve the worksheet values from cache to avoiding extra query
982: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
983: l_local_copy_flag := PSB_WORKSHEET.g_local_copy_flag;
984: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
985: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
987: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
988: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
989: l_stage_set_id := PSB_WORKSHEET.g_stage_set_id;

Line 986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;

982: l_global_worksheet_id := PSB_WORKSHEET.g_global_worksheet_id;
983: l_local_copy_flag := PSB_WORKSHEET.g_local_copy_flag;
984: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
985: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
987: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
988: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
989: l_stage_set_id := PSB_WORKSHEET.g_stage_set_id;
990: l_current_stage_seq := PSB_WORKSHEET.g_current_stage_seq;

Line 987: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;

983: l_local_copy_flag := PSB_WORKSHEET.g_local_copy_flag;
984: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
985: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
987: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
988: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
989: l_stage_set_id := PSB_WORKSHEET.g_stage_set_id;
990: l_current_stage_seq := PSB_WORKSHEET.g_current_stage_seq;
991:

Line 988: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;

984: l_gl_cutoff_period := PSB_WORKSHEET.g_gl_cutoff_period;
985: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
987: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
988: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
989: l_stage_set_id := PSB_WORKSHEET.g_stage_set_id;
990: l_current_stage_seq := PSB_WORKSHEET.g_current_stage_seq;
991:
992: ELSE

Line 989: l_stage_set_id := PSB_WORKSHEET.g_stage_set_id;

985: l_allocrule_set_id := PSB_WORKSHEET.g_allocrule_set_id;
986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
987: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
988: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
989: l_stage_set_id := PSB_WORKSHEET.g_stage_set_id;
990: l_current_stage_seq := PSB_WORKSHEET.g_current_stage_seq;
991:
992: ELSE
993:

Line 990: l_current_stage_seq := PSB_WORKSHEET.g_current_stage_seq;

986: l_budget_calendar_id := PSB_WORKSHEET.g_budget_calendar_id;
987: l_rounding_factor := PSB_WORKSHEET.g_rounding_factor;
988: l_flex_mapping_set_id := PSB_WORKSHEET.g_flex_mapping_set_id;
989: l_stage_set_id := PSB_WORKSHEET.g_stage_set_id;
990: l_current_stage_seq := PSB_WORKSHEET.g_current_stage_seq;
991:
992: ELSE
993:
994: SELECT DECODE(global_worksheet_flag, 'Y', worksheet_id,

Line 1006: FROM psb_worksheets

1002: l_local_copy_flag,
1003: /* start bug 3871839 */
1004: l_current_stage_seq
1005: /* end bug 3871839 */
1006: FROM psb_worksheets
1007: WHERE worksheet_id = p_worksheet_id;
1008:
1009: SELECT gl_cutoff_period,
1010: allocrule_set_id allocrule_set_id,

Line 1026: FROM psb_worksheets

1022: l_stage_set_id,
1023: l_flex_mapping_set_id
1024: /* Bug No :3871839 Commented out l_current_stage_sequence */
1025: /*l_current_stage_seq*/
1026: FROM psb_worksheets
1027: WHERE worksheet_id = l_global_worksheet_id;
1028:
1029: END IF;
1030: /* Bug 3458191 end */

Line 2345: if PSB_WORKSHEET.g_ws_creation_flag OR

2341: begin
2342:
2343: -- Bug 3543845: During ws creation, distributed ws does not exist.
2344: -- if l_local_copy_flag = 'Y' then
2345: if PSB_WORKSHEET.g_ws_creation_flag OR
2346: l_local_copy_flag = 'Y'
2347: then
2348: begin
2349:

Line 2415: if PSB_WORKSHEET.g_ws_creation_flag OR

2411:
2412: -- Bug 3543845: During ws creation, distributed ws does not exist.
2413: -- Also flip the condition to make it readable.
2414: -- if nvl(l_local_copy_flag, 'N') <> 'Y' then
2415: if PSB_WORKSHEET.g_ws_creation_flag OR
2416: l_local_copy_flag = 'Y'
2417: then
2418: begin
2419:

Line 2618: from PSB_WORKSHEETS_V a, PSB_BUDGET_GROUPS b

2614: a.flex_mapping_set_id,
2615: a.gl_cutoff_period,
2616: nvl(b.root_budget_group_id, b.budget_group_id) root_budget_group_id,
2617: local_copy_flag
2618: from PSB_WORKSHEETS_V a, PSB_BUDGET_GROUPS b
2619: where a.worksheet_id = p_worksheet_id
2620: and b.budget_group_id = a.budget_group_id;
2621: --
2622: cursor c_CCID is

Line 2956: PSB_WORKSHEET.Delete_WAL

2952:
2953: if l_spal_exists then
2954: begin
2955:
2956: PSB_WORKSHEET.Delete_WAL
2957: (p_api_version => 1.0,
2958: p_return_status => l_return_status,
2959: p_account_line_id => l_spal_id);
2960:

Line 3948: IF PSB_WORKSHEET.g_ws_creation_flag OR l_local_copy_flag = 'Y'

3944:
3945: -- Bug 3543845: During ws creation, distributed ws does not exist.
3946: -- Also flip the condition to make it readable.
3947: -- if nvl(l_local_copy_flag, 'N') <> 'Y' then
3948: IF PSB_WORKSHEET.g_ws_creation_flag OR l_local_copy_flag = 'Y'
3949: THEN
3950: BEGIN
3951:
3952: INSERT INTO PSB_WS_LINES

Line 3974: END IF; -- End of : IF PSB_WORKSHEET.g_ws_creation_flag OR ...

3970: null,'Y', sysdate, l_userid, l_loginid, l_userid, sysdate);
3971: END LOOP;
3972: END;
3973:
3974: END IF; -- End of : IF PSB_WORKSHEET.g_ws_creation_flag OR ...
3975: END;
3976:
3977: END IF; -- End of : IF l_position_line_id IS NOT NULL
3978: END;

Line 4368: IF g_enddate_cy <> NVL(PSB_WORKSHEET.g_gl_cutoff_period,FND_API.G_MISS_DATE) THEN

4364:
4365: end loop;
4366:
4367: -- Added the following condition as part of bug fix 3469514
4368: IF g_enddate_cy <> NVL(PSB_WORKSHEET.g_gl_cutoff_period,FND_API.G_MISS_DATE) THEN
4369:
4370: for c_WAL_Rec in c_WAL_Est loop
4371:
4372: l_ytd_amount := l_ytd_amount + c_WAL_Rec.ytd_amount;

Line 4702: IF ( PSB_WORKSHEET.g_ws_first_time_creation_flag

4698: -- Bug 3543845: Check whether the worksheet creation process is executed for
4699: -- the first time. If it is the first time, then check the ytd_amount and
4700: -- create zero balance profile. Otherwise, call the create_account_Dist
4701: -- without any filtering.
4702: IF ( PSB_WORKSHEET.g_ws_first_time_creation_flag
4703: and
4704: ( l_ytd_amount <> 0
4705: OR
4706: PSB_WS_ACCT2.g_running_total <> 0 --bug 3704360. added this clause.

Line 4712: NOT PSB_WORKSHEET.g_ws_first_time_creation_flag

4708: ( l_ytd_amount = 0 and g_create_zero_bal = 'Y' )
4709: )
4710: )
4711: OR
4712: NOT PSB_WORKSHEET.g_ws_first_time_creation_flag
4713: THEN
4714: /* comment out by bug 3305778
4715: if ((l_ytd_amount <> 0) or
4716: ((l_ytd_amount = 0) and (l_create_zero_bal = 'Y'))) then */

Line 5391: PSB_WORKSHEETS b,

5387: /* Existing Cursor definition is commented and modified one is added as follows :
5388: cursor c_Type12 is
5389: select nvl(a.ytd_amount, 0) YTD_Amount
5390: from PSB_WS_ACCOUNT_LINES a,
5391: PSB_WORKSHEETS b,
5392: PSB_BUDGET_PERIODS c
5393: where a.code_combination_id = l_mapped_ccid
5394: and a.balance_type = p_balance_type
5395: and a.currency_code = p_currency_code

Line 5398: from PSB_WORKSHEETS b,

5394: and a.balance_type = p_balance_type
5395: and a.currency_code = p_currency_code
5396: and exists
5397: (select 1
5398: from PSB_WORKSHEETS b,
5399: PSB_BUDGET_PERIODS c
5400: where b.worksheet_id = p_worksheet_id
5401: and a.stage_set_id = b.stage_set_id
5402: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq

Line 5419: from PSB_WORKSHEETS b,

5415: -- commenting the cursor
5416: /*
5417: cursor c_Type12 is
5418: select sum(nvl(a.ytd_amount, 0)) YTD_Amount
5419: from PSB_WORKSHEETS b,
5420: PSB_WS_LINES d,
5421: PSB_WS_ACCOUNT_LINES a,
5422: PSB_BUDGET_PERIODS c
5423: where b.worksheet_id = p_worksheet_id

Line 5447: PSB_WORKSHEETS b,

5443: /* Existing Cursor definition is commented and modified one is added as follows :
5444: cursor c_Type12SP is
5445: select nvl(a.ytd_amount, 0) YTD_Amount
5446: from PSB_WS_ACCOUNT_LINES a,
5447: PSB_WORKSHEETS b,
5448: PSB_BUDGET_PERIODS c
5449: where a.code_combination_id = l_mapped_ccid
5450: and a.balance_type = p_balance_type
5451: and a.currency_code = p_currency_code

Line 5454: from PSB_WORKSHEETS b,

5450: and a.balance_type = p_balance_type
5451: and a.currency_code = p_currency_code
5452: and exists
5453: (select 1
5454: from PSB_WORKSHEETS b,
5455: PSB_BUDGET_PERIODS c
5456: where b.worksheet_id = p_worksheet_id
5457: and a.stage_set_id = b.stage_set_id
5458: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq

Line 5482: from PSB_WORKSHEETS b,

5478:
5479: /*
5480: cursor c_Type12SP is
5481: select sum(nvl(a.ytd_amount, 0)) YTD_Amount
5482: from PSB_WORKSHEETS b,
5483: PSB_WS_LINES d,
5484: PSB_WS_ACCOUNT_LINES a,
5485: PSB_BUDGET_PERIODS c
5486: where b.worksheet_id = p_worksheet_id

Line 5601: PSB_WORKSHEETS b

5597:
5598: cursor c_Sum is
5599: select sum(nvl(a.ytd_amount,0)) Sum_Acc
5600: from PSB_WS_ACCOUNT_LINES a,
5601: PSB_WORKSHEETS b
5602: where exists
5603: (select 1
5604: from PSB_WS_LINES
5605: where account_line_id = a.account_line_id

Line 5622: PSB_WORKSHEETS b

5618:
5619: cursor c_SumSP is
5620: select sum(nvl(a.ytd_amount,0)) Sum_Acc
5621: from PSB_WS_ACCOUNT_LINES a,
5622: PSB_WORKSHEETS b
5623: where exists
5624: (select 1
5625: from PSB_WS_SUBMIT_SERVICE_PACKAGES c
5626: where c.service_package_id = a.service_package_id

Line 5839: FROM psb_worksheets

5835: /* Bug 3608191 : Start */
5836: BEGIN
5837: SELECT global_worksheet_flag
5838: INTO l_global_ws_flag
5839: FROM psb_worksheets
5840: WHERE worksheet_id = p_worksheet_id;
5841: END;
5842:
5843: l_processed_flag := 'N';

Line 7048: FROM psb_worksheets

7044: end loop;
7045:
7046: /* start bug 4256345 */
7047: FOR l_stage_rec IN ( SELECT stage_set_id, current_stage_seq
7048: FROM psb_worksheets
7049: WHERE worksheet_id = p_worksheet_id)
7050: LOOP
7051: l_stage_set_id := l_stage_rec.stage_set_id;
7052: l_current_stage_seq := l_stage_rec.current_Stage_seq;