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.

[Home] [Help]

APPS.PSB_WS_ACCT1 dependencies on PSB_WS_LINES

Line 866: from PSB_WS_LINES b

862: and template_id = p_template_id
863: and position_line_id is null
864: and exists
865: (select 1
866: from PSB_WS_LINES b
867: where b.account_line_id = a.account_line_id
868: and b.worksheet_id = decode(nvl(l_local_copy_flag, 'N'), 'Y', p_worksheet_id, l_global_worksheet_id))
869: and stage_set_id = l_stage_set_id
870: and service_package_id = l_service_package_id

Line 928: from PSB_WS_LINES b

924: and template_id is null
925: and position_line_id is null
926: and exists
927: (select 1
928: from PSB_WS_LINES b
929: where b.account_line_id = a.account_line_id
930: and b.worksheet_id = decode(nvl(l_local_copy_flag, 'N'), 'Y', p_worksheet_id, l_global_worksheet_id))
931: and stage_set_id = l_stage_set_id
932: and service_package_id = l_service_package_id

Line 1244: 'from PSB_WS_LINES b ' ||

1240:
1241: sql_wal := sql_wal ||
1242: 'and exists ' ||
1243: '(select 1 ' ||
1244: 'from PSB_WS_LINES b ' ||
1245: 'where b.account_line_id = a.account_line_id ' ||
1246: 'and b.worksheet_id = ' || p_worksheet_id || ') ';
1247:
1248: end;

Line 2324: -- Create an entry in PSB_WS_LINES for all worksheets to which the CCID or Position belongs

2320: l_period_amounts(56), l_period_amounts(57), l_period_amounts(58), l_period_amounts(59), l_period_amounts(60),
2321: l_rounded_ytd_amount, l_requestid, p_functional_transaction)
2322: returning account_line_id into l_acclineid;
2323:
2324: -- Create an entry in PSB_WS_LINES for all worksheets to which the CCID or Position belongs
2325:
2326: if p_position_line_id <> FND_API.G_MISS_NUM then
2327: begin
2328:

Line 2329: insert into PSB_WS_LINES

2325:
2326: if p_position_line_id <> FND_API.G_MISS_NUM then
2327: begin
2328:
2329: insert into PSB_WS_LINES
2330: (worksheet_id, account_line_id, freeze_flag,
2331: view_line_flag, last_update_date, last_updated_by,
2332: last_update_login, created_by, creation_date)
2333: select worksheet_id, l_acclineid, freeze_flag,

Line 2336: from PSB_WS_LINES_POSITIONS

2332: last_update_login, created_by, creation_date)
2333: select worksheet_id, l_acclineid, freeze_flag,
2334: view_line_flag, sysdate, l_userid,
2335: l_loginid, l_userid, sysdate
2336: from PSB_WS_LINES_POSITIONS
2337: where position_line_id = p_position_line_id;
2338:
2339: end;
2340: else

Line 2350: insert into PSB_WS_LINES

2346: l_local_copy_flag = 'Y'
2347: then
2348: begin
2349:
2350: insert into PSB_WS_LINES
2351: (worksheet_id, account_line_id, freeze_flag,
2352: view_line_flag, last_update_date, last_updated_by,
2353: last_update_login, created_by, creation_date)
2354: values (p_worksheet_id, l_acclineid, null,

Line 2363: insert into PSB_WS_LINES

2359: begin
2360: for c_Distribute_WS_Rec in c_Distribute_WS (l_global_worksheet_id, p_budget_group_id,
2361: g_startdate_pp,
2362: g_enddate_cy) loop
2363: insert into PSB_WS_LINES
2364: (worksheet_id, account_line_id, freeze_flag,
2365: view_line_flag, last_update_date, last_updated_by,
2366: last_update_login, created_by, creation_date)
2367: values (c_Distribute_WS_Rec.worksheet_id, l_acclineid, null,

Line 2390: delete from psb_ws_lines

2386:
2387: if l_budget_group_changed then
2388: begin
2389:
2390: delete from psb_ws_lines
2391: where account_line_id = l_account_line_id;
2392:
2393: -- Create an entry in PSB_WS_LINES for all worksheets to which the CCID or Position belongs
2394:

Line 2393: -- Create an entry in PSB_WS_LINES for all worksheets to which the CCID or Position belongs

2389:
2390: delete from psb_ws_lines
2391: where account_line_id = l_account_line_id;
2392:
2393: -- Create an entry in PSB_WS_LINES for all worksheets to which the CCID or Position belongs
2394:
2395: if p_position_line_id <> FND_API.G_MISS_NUM then
2396: begin
2397:

Line 2398: insert into PSB_WS_LINES

2394:
2395: if p_position_line_id <> FND_API.G_MISS_NUM then
2396: begin
2397:
2398: insert into PSB_WS_LINES
2399: (worksheet_id, account_line_id, freeze_flag,
2400: view_line_flag, last_update_date, last_updated_by,
2401: last_update_login, created_by, creation_date)
2402: select worksheet_id, l_account_line_id, freeze_flag,

Line 2405: from PSB_WS_LINES_POSITIONS

2401: last_update_login, created_by, creation_date)
2402: select worksheet_id, l_account_line_id, freeze_flag,
2403: view_line_flag, sysdate, l_userid,
2404: l_loginid, l_userid, sysdate
2405: from PSB_WS_LINES_POSITIONS
2406: where position_line_id = p_position_line_id;
2407:
2408: end;
2409: else

Line 2420: insert into PSB_WS_LINES

2416: l_local_copy_flag = 'Y'
2417: then
2418: begin
2419:
2420: insert into PSB_WS_LINES
2421: (worksheet_id, account_line_id, freeze_flag,
2422: view_line_flag, last_update_date, last_updated_by,
2423: last_update_login, created_by, creation_date)
2424: values (p_worksheet_id, l_account_line_id, null,

Line 2435: insert into PSB_WS_LINES

2431:
2432: for c_Distribute_WS_Rec in c_Distribute_WS (l_global_worksheet_id, p_budget_group_id,
2433: g_startdate_pp,
2434: g_enddate_cy) loop
2435: insert into PSB_WS_LINES
2436: (worksheet_id, account_line_id, freeze_flag,
2437: view_line_flag, last_update_date, last_updated_by,
2438: last_update_login, created_by, creation_date)
2439: values (c_Distribute_WS_Rec.worksheet_id, l_account_line_id, null,

Line 2790: 'from PSB_WS_LINES b ' ||

2786:
2787: sql_wal := sql_wal ||
2788: 'and exists ' ||
2789: '(select 1 ' ||
2790: 'from PSB_WS_LINES b ' ||
2791: 'where b.account_line_id = a.account_line_id ' ||
2792: 'and b.worksheet_id = ' || p_worksheet_id || ') ';
2793:
2794: end;

Line 2937: insert into PSB_WS_LINES

2933: where account_line_id = p_account_line_id;
2934:
2935: -- Create an entry for all the worksheets assigned to the current account line
2936:
2937: insert into PSB_WS_LINES
2938: (worksheet_id, account_line_id, freeze_flag,
2939: view_line_flag, last_update_date, last_updated_by,
2940: last_update_login, created_by, creation_date)
2941: select worksheet_id, l_acclineid, freeze_flag,

Line 2944: from PSB_WS_LINES

2940: last_update_login, created_by, creation_date)
2941: select worksheet_id, l_acclineid, freeze_flag,
2942: view_line_flag, sysdate, l_userid,
2943: l_loginid, l_userid, sysdate
2944: from PSB_WS_LINES
2945: where account_line_id = p_account_line_id;
2946:
2947: end;
2948: end if;

Line 3919: DELETE FROM psb_ws_lines

3915: -- Update was successful; if budget group was changed reassign worksheets
3916: IF l_budget_group_changed
3917: THEN
3918: BEGIN
3919: DELETE FROM psb_ws_lines
3920: WHERE account_line_id = p_account_line_id;
3921:
3922: -- Create an entry in PSB_WS_LINES for all worksheets to which the CCID or Position belongs
3923:

Line 3922: -- Create an entry in PSB_WS_LINES for all worksheets to which the CCID or Position belongs

3918: BEGIN
3919: DELETE FROM psb_ws_lines
3920: WHERE account_line_id = p_account_line_id;
3921:
3922: -- Create an entry in PSB_WS_LINES for all worksheets to which the CCID or Position belongs
3923:
3924: IF l_position_line_id IS NOT NULL
3925: THEN
3926: BEGIN

Line 3927: INSERT INTO PSB_WS_LINES

3923:
3924: IF l_position_line_id IS NOT NULL
3925: THEN
3926: BEGIN
3927: INSERT INTO PSB_WS_LINES
3928: (worksheet_id, account_line_id, freeze_flag, view_line_flag,
3929: last_update_date, last_updated_by, last_update_login, created_by,
3930: creation_date)
3931: SELECT worksheet_id, p_account_line_id, freeze_flag, view_line_flag,

Line 3933: FROM PSB_WS_LINES_POSITIONS

3929: last_update_date, last_updated_by, last_update_login, created_by,
3930: creation_date)
3931: SELECT worksheet_id, p_account_line_id, freeze_flag, view_line_flag,
3932: sysdate, l_userid,l_loginid, l_userid, sysdate
3933: FROM PSB_WS_LINES_POSITIONS
3934: WHERE position_line_id = l_position_line_id;
3935:
3936: /* Start bug #4167811 */
3937: UPDATE psb_ws_account_lines SET budget_group_changed = 'Y'

Line 3952: INSERT INTO PSB_WS_LINES

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
3953: (worksheet_id, account_line_id, freeze_flag, view_line_flag,
3954: last_update_date, last_updated_by, last_update_login,
3955: created_by, creation_date)
3956: VALUES (p_worksheet_id, p_account_line_id, null, 'Y', sysdate,

Line 3965: INSERT INTO PSB_WS_LINES

3961: BEGIN
3962: FOR c_Distribute_WS_Rec IN c_Distribute_WS(l_global_worksheet_id,
3963: p_budget_group_id, g_startdate_pp, g_enddate_cy)
3964: LOOP
3965: INSERT INTO PSB_WS_LINES
3966: (worksheet_id, account_line_id, freeze_flag, view_line_flag,
3967: last_update_date, last_updated_by, last_update_login,
3968: created_by, creation_date)
3969: VALUES (c_Distribute_WS_Rec.worksheet_id, p_account_line_id,

Line 4070: from PSB_WS_LINES b

4066: and p_start_stage_seq between start_stage_seq and current_stage_seq
4067: and balance_type = 'A'
4068: and exists
4069: (select 1
4070: from PSB_WS_LINES b
4071: where b.account_line_id = a.account_line_id
4072: and b.worksheet_id = p_worksheet_id)
4073: and stage_set_id = p_stage_set_id
4074: and service_package_id = p_service_package_id

Line 4104: from PSB_WS_LINES b

4100: and p_start_stage_seq between start_stage_seq and current_stage_seq
4101: and balance_type = 'E'
4102: and exists
4103: (select 1
4104: from PSB_WS_LINES b
4105: where b.account_line_id = a.account_line_id
4106: and b.worksheet_id = p_worksheet_id)
4107: and stage_set_id = p_stage_set_id
4108: and service_package_id = p_service_package_id

Line 5409: from PSB_WS_LINES

5405: and c.budget_period_type = 'Y'
5406: and c.budget_year_type_id = p_budget_year_type_id)
5407: and exists
5408: (select 1
5409: from PSB_WS_LINES
5410: where account_line_id = a.account_line_id
5411: and worksheet_id = p_worksheet_id);
5412: */
5413:

Line 5420: PSB_WS_LINES d,

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
5424: and d.worksheet_id = b.worksheet_id

Line 5465: from PSB_WS_LINES

5461: and c.budget_period_type = 'Y'
5462: and c.budget_year_type_id = p_budget_year_type_id)
5463: and exists
5464: (select 1
5465: from PSB_WS_LINES
5466: where account_line_id = a.account_line_id
5467: and worksheet_id = p_worksheet_id)
5468: and exists
5469: (select 1

Line 5483: PSB_WS_LINES d,

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
5487: and d.worksheet_id = b.worksheet_id

Line 5525: FROM PSB_WS_LINES WSL,

5521: end loop;
5522: */
5523:
5524: FOR l_ytd_rec IN (SELECT NVL(A.YTD_AMOUNT, 0) YTD_AMOUNT
5525: FROM PSB_WS_LINES WSL,
5526: PSB_WS_ACCOUNT_LINES A
5527: WHERE A.CODE_COMBINATION_ID = l_mapped_ccid
5528: AND A.BUDGET_YEAR_ID = p_budget_period_id
5529: AND A.BALANCE_TYPE = p_balance_type

Line 5556: FROM PSB_WS_LINES WSL,

5552: end loop;
5553: */
5554:
5555: FOR l_ytd_rec IN (SELECT NVL(A.YTD_AMOUNT, 0) YTD_AMOUNT
5556: FROM PSB_WS_LINES WSL,
5557: PSB_WS_ACCOUNT_LINES A
5558: WHERE A.CODE_COMBINATION_ID = l_mapped_ccid
5559: AND A.BUDGET_YEAR_ID = p_budget_period_id
5560: AND A.BALANCE_TYPE = p_balance_type

Line 5604: from PSB_WS_LINES

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
5606: and worksheet_id = p_worksheet_id)
5607: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5608: and a.balance_type = 'E'

Line 5630: from PSB_WS_LINES

5626: where c.service_package_id = a.service_package_id
5627: and c.worksheet_id = p_worksheet_id)
5628: and exists
5629: (select 1
5630: from PSB_WS_LINES
5631: where account_line_id = a.account_line_id
5632: and worksheet_id = p_worksheet_id)
5633: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq
5634: and a.balance_type = 'E'

Line 5705: psb_ws_lines g

5701: select distinct f.account_type
5702: from psb_budget_accounts d,
5703: psb_set_relations_v e,
5704: psb_ws_account_lines f,
5705: psb_ws_lines g
5706: where d.account_position_set_id = e.account_position_set_id
5707: and e.account_or_position_type = 'A'
5708: and e.constraint_id = p_constraint_id
5709: and d.code_combination_id = f.code_combination_id