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_WS_ACCOUNT_LINES

Line 690: -- Create Worksheet Account Distribution in PSB_WS_ACCOUNT_LINES. If

686: END Find_CCIDs;
687:
688: /* ----------------------------------------------------------------------- */
689:
690: -- Create Worksheet Account Distribution in PSB_WS_ACCOUNT_LINES. If
691: -- entry already exists, it updates existing entry (if p_check_spal_exists
692: -- is FND_API.G_FALSE); otherwise, it increments the existing entry (if
693: -- p_check_spal_exists is FND_API.G_TRUE)
694:

Line 858: from PSB_WS_ACCOUNT_LINES a

854: period45_amount, period46_amount, period47_amount, period48_amount,
855: period49_amount, period50_amount, period51_amount, period52_amount,
856: period53_amount, period54_amount, period55_amount, period56_amount,
857: period57_amount, period58_amount, period59_amount, period60_amount
858: from PSB_WS_ACCOUNT_LINES a
859: where currency_code = p_currency_code
860: and l_current_stage_seq between start_stage_seq and current_stage_seq
861: and balance_type = p_balance_type
862: and template_id = p_template_id

Line 891: from PSB_WS_ACCOUNT_LINES a

887: period45_amount, period46_amount, period47_amount, period48_amount,
888: period49_amount, period50_amount, period51_amount, period52_amount,
889: period53_amount, period54_amount, period55_amount, period56_amount,
890: period57_amount, period58_amount, period59_amount, period60_amount
891: from PSB_WS_ACCOUNT_LINES a
892: where currency_code = p_currency_code
893: and l_current_stage_seq between start_stage_seq and current_stage_seq
894: and balance_type = p_balance_type
895: and template_id is null

Line 920: from PSB_WS_ACCOUNT_LINES a

916: period45_amount, period46_amount, period47_amount, period48_amount,
917: period49_amount, period50_amount, period51_amount, period52_amount,
918: period53_amount, period54_amount, period55_amount, period56_amount,
919: period57_amount, period58_amount, period59_amount, period60_amount
920: from PSB_WS_ACCOUNT_LINES a
921: where currency_code = p_currency_code
922: and l_current_stage_seq between start_stage_seq and current_stage_seq
923: and balance_type = p_balance_type
924: and template_id is null

Line 1200: 'from PSB_WS_ACCOUNT_LINES a ' ||

1196: 'ytd_amount, ' ||
1197: /* Bug 3347507 start */
1198: 'start_stage_seq ' ||
1199: /* Bug 3347507 end */
1200: 'from PSB_WS_ACCOUNT_LINES a ' ||
1201: 'where ' || l_current_stage_seq || ' between start_stage_seq and current_stage_seq ';
1202:
1203: if p_template_id <> FND_API.G_MISS_NUM then
1204: sql_wal := sql_wal ||

Line 1581: update PSB_WS_ACCOUNT_LINES a

1577: /* Bug 3347507 end */
1578: begin
1579:
1580:
1581: update PSB_WS_ACCOUNT_LINES a
1582: set budget_group_id = p_budget_group_id,
1583: current_stage_seq = l_current_stage_seq,
1584: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
1585: annual_fte = decode(nvl(p_annual_fte, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, annual_fte, nvl(p_annual_fte, FND_API.G_MISS_NUM)),

Line 1684: update PSB_WS_ACCOUNT_LINES

1680:
1681: if l_flexmap_increment then
1682: begin
1683:
1684: update PSB_WS_ACCOUNT_LINES
1685: set budget_group_id = p_budget_group_id,
1686: current_stage_seq = l_current_stage_seq,
1687: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
1688: annual_fte = decode(nvl(p_annual_fte, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, annual_fte, p_annual_fte + nvl(l_current_fte, 0)),

Line 1761: update PSB_WS_ACCOUNT_LINES

1757: end;
1758: else
1759: begin
1760:
1761: update PSB_WS_ACCOUNT_LINES
1762: set budget_group_id = p_budget_group_id,
1763: current_stage_seq = l_current_stage_seq,
1764: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
1765: annual_fte = decode(nvl(p_annual_fte, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, annual_fte, p_annual_fte),

Line 1865: update PSB_WS_ACCOUNT_LINES

1861:
1862: if l_flexmap_increment then
1863: begin
1864:
1865: update PSB_WS_ACCOUNT_LINES
1866: set budget_group_id = p_budget_group_id,
1867: current_stage_seq = l_current_stage_seq,
1868: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
1869: annual_fte = decode(nvl(p_annual_fte, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, annual_fte, p_annual_fte + nvl(l_current_fte, 0)),

Line 1942: update PSB_WS_ACCOUNT_LINES

1938: end;
1939: else
1940: begin
1941:
1942: update PSB_WS_ACCOUNT_LINES
1943: set budget_group_id = p_budget_group_id,
1944: current_stage_seq = l_current_stage_seq,
1945: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
1946: annual_fte = decode(nvl(p_annual_fte, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, annual_fte, p_annual_fte),

Line 2049: update PSB_WS_ACCOUNT_LINES

2045:
2046: if l_flexmap_increment then
2047: begin
2048:
2049: update PSB_WS_ACCOUNT_LINES
2050: set budget_group_id = p_budget_group_id,
2051: current_stage_seq = l_current_stage_seq,
2052: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
2053: annual_fte = decode(nvl(p_annual_fte, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, annual_fte, p_annual_fte + nvl(l_current_fte, 0)),

Line 2126: update PSB_WS_ACCOUNT_LINES

2122: end;
2123: else
2124: begin
2125:
2126: update PSB_WS_ACCOUNT_LINES
2127: set budget_group_id = p_budget_group_id,
2128: current_stage_seq = l_current_stage_seq,
2129: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
2130: annual_fte = decode(nvl(p_annual_fte, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, annual_fte, p_annual_fte),

Line 2275: insert into PSB_WS_ACCOUNT_LINES

2271: end if;
2272:
2273: end loop;
2274:
2275: insert into PSB_WS_ACCOUNT_LINES
2276: (account_line_id, code_combination_id, position_line_id, service_package_id, budget_group_id,
2277: element_set_id, salary_account_line, stage_set_id, start_stage_seq, current_stage_seq,
2278: end_stage_seq, copy_of_account_line_id, last_update_date, last_updated_by,
2279: last_update_login, created_by, creation_date, template_id, budget_year_id, annual_fte,

Line 2292: values (psb_ws_account_lines_s.nextval,

2288: period43_amount, period44_amount, period45_amount, period46_amount, period47_amount, period48_amount,
2289: period49_amount, period50_amount, period51_amount, period52_amount, period53_amount, period54_amount,
2290: period55_amount, period56_amount, period57_amount, period58_amount, period59_amount, period60_amount,
2291: ytd_amount, request_id, functional_transaction)
2292: values (psb_ws_account_lines_s.nextval,
2293: l_ccid,
2294: decode(p_position_line_id, FND_API.G_MISS_NUM, null, p_position_line_id),
2295: l_service_package_id,
2296: p_budget_group_id,

Line 2654: select PSB_WS_ACCOUNT_LINES_S.NEXTVAL seq

2650: and a.account_position_set_id = c.account_position_set_id
2651: and c.code_combination_id = l_ccid;
2652: --
2653: cursor c_seq is
2654: select PSB_WS_ACCOUNT_LINES_S.NEXTVAL seq
2655: from dual;
2656:
2657: -- Bug No 2354918 Start
2658: cursor c_WAL is

Line 2675: from PSB_WS_ACCOUNT_LINES

2671: period49_amount, period50_amount, period51_amount, period52_amount,
2672: period53_amount, period54_amount, period55_amount, period56_amount,
2673: period57_amount, period58_amount, period59_amount, period60_amount,
2674: budget_year_id
2675: from PSB_WS_ACCOUNT_LINES
2676: where account_line_id = p_account_line_id
2677: and position_line_id is null;
2678: --
2679: BEGIN

Line 2726: 'from PSB_WS_ACCOUNT_LINES ' ||

2722: 'period49_amount, period50_amount, period51_amount, period52_amount, ' ||
2723: 'period53_amount, period54_amount, period55_amount, period56_amount, ' ||
2724: 'period57_amount, period58_amount, period59_amount, period60_amount, ' ||
2725: 'ytd_amount ' ||
2726: 'from PSB_WS_ACCOUNT_LINES ' ||
2727: 'where account_line_id = :AccLineID';
2728:
2729: execute immediate sql_wsacc into
2730: l_ccid, l_budget_group_id, l_template_id, l_position_line_id, l_element_set_id, l_budget_year_id,

Line 2753: 'from PSB_WS_ACCOUNT_LINES a ' ||

2749: begin
2750:
2751: sql_wal := 'select account_line_id, ' ||
2752: 'ytd_amount ' ||
2753: 'from PSB_WS_ACCOUNT_LINES a ' ||
2754: 'where currency_code = ''' || l_currency_code || ''' ' ||
2755: 'and ' || l_current_stage_seq || ' between start_stage_seq and current_stage_seq ' ||
2756: 'and balance_type = ''' || l_balance_type || ''' ';
2757:

Line 2896: insert into PSB_WS_ACCOUNT_LINES

2892: for c_seq_rec in c_seq loop
2893: l_acclineid := c_seq_rec.seq;
2894: end loop;
2895:
2896: insert into PSB_WS_ACCOUNT_LINES
2897: (account_line_id, code_combination_id, position_line_id, service_package_id, budget_group_id,
2898: element_set_id, salary_account_line, stage_set_id, start_stage_seq, current_stage_seq,
2899: end_stage_seq, copy_of_account_line_id, last_update_date, last_updated_by,
2900: last_update_login, created_by, creation_date, template_id, budget_year_id, annual_fte,

Line 2932: from PSB_WS_ACCOUNT_LINES

2928: period43_amount, period44_amount, period45_amount, period46_amount, period47_amount, period48_amount,
2929: period49_amount, period50_amount, period51_amount, period52_amount, period53_amount, period54_amount,
2930: period55_amount, period56_amount, period57_amount, period58_amount, period59_amount, period60_amount,
2931: ytd_amount, functional_transaction
2932: from PSB_WS_ACCOUNT_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:

Line 3487: -- Update PSB_WS_ACCOUNT_LINES with input parameter values passed in.

3483:
3484: end;
3485: end if;
3486:
3487: -- Update PSB_WS_ACCOUNT_LINES with input parameter values passed in.
3488: -- Bug#3132485: Replaced references to G_MISS_NUM by bind ones.
3489:
3490: -- Bug#5030613
3491: -- Replaced l_new_budget_group_id by b_budget_group_id bind variable.

Line 3493: 'update PSB_WS_ACCOUNT_LINES ' ||

3489:
3490: -- Bug#5030613
3491: -- Replaced l_new_budget_group_id by b_budget_group_id bind variable.
3492: sql_wsacc :=
3493: 'update PSB_WS_ACCOUNT_LINES ' ||
3494: 'set service_package_id = decode(:p_service_package_id1, :gmn1, service_package_id, :p_service_package_id2), ' ||
3495: 'budget_group_id = :b_budget_group_id, ' ||
3496: 'copy_of_account_line_id = decode(:p_copy_of_account_line_id1, :gmn2 , copy_of_account_line_id, :p_copy_of_account_line_id2), annual_fte = decode(' ||
3497: 'nvl(:p_annual_fte1, :gmn3), :gmn4, annual_fte, nvl(:p_annual_fte2, :gmn5) ), ' ;

Line 3937: UPDATE psb_ws_account_lines SET budget_group_changed = 'Y'

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'
3938: WHERE account_line_id = p_account_line_id;
3939: /* End bug #4167811 */
3940: END;
3941:

Line 4016: -- are stored as separate entries in PSB_WS_ACCOUNT_LINES

4012: /* ----------------------------------------------------------------------- */
4013:
4014: -- Copy Actual Balances for Current Year as Estimate Balances up to the
4015: -- GL Cutoff Period. This is needed because Actual and Estimate Balances
4016: -- are stored as separate entries in PSB_WS_ACCOUNT_LINES
4017:
4018: PROCEDURE Copy_CY_Estimates
4019: ( p_return_status OUT NOCOPY VARCHAR2,
4020: p_worksheet_id IN NUMBER,

Line 4062: from PSB_WS_ACCOUNT_LINES a

4058: period45_amount, period46_amount, period47_amount, period48_amount,
4059: period49_amount, period50_amount, period51_amount, period52_amount,
4060: period53_amount, period54_amount, period55_amount, period56_amount,
4061: period57_amount, period58_amount, period59_amount, period60_amount
4062: from PSB_WS_ACCOUNT_LINES a
4063: where template_id is null
4064: and position_line_id is null
4065: and currency_code = p_currency_code
4066: and p_start_stage_seq between start_stage_seq and current_stage_seq

Line 4096: from PSB_WS_ACCOUNT_LINES a

4092: period45_amount, period46_amount, period47_amount, period48_amount,
4093: period49_amount, period50_amount, period51_amount, period52_amount,
4094: period53_amount, period54_amount, period55_amount, period56_amount,
4095: period57_amount, period58_amount, period59_amount, period60_amount
4096: from PSB_WS_ACCOUNT_LINES a
4097: where template_id is null
4098: and position_line_id is null
4099: and currency_code = p_currency_code
4100: and p_start_stage_seq between start_stage_seq and current_stage_seq

Line 4680: -- CCIDs with zero YTD Amounts should be created in PSB_WS_ACCOUNT_LINES

4676: end loop;
4677: END IF;
4678:
4679: -- Create Zero Balances Profile Option : this specifies whether non-Position
4680: -- CCIDs with zero YTD Amounts should be created in PSB_WS_ACCOUNT_LINES
4681:
4682: --commented the following statements for bug 3305778
4683: /* Bug 3543845: Reactivate the following statements, use g_create_zero_bal
4684: and add a new condition to improve performance

Line 4802: update PSB_WS_ACCOUNT_LINES

4798: then
4799: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4800: end if;
4801:
4802: update PSB_WS_ACCOUNT_LINES
4803: set ytd_amount = nvl(period1_amount, 0) + nvl(period2_amount, 0) + nvl(period3_amount, 0) +
4804: nvl(period4_amount, 0) + nvl(period5_amount, 0) + nvl(period6_amount, 0) +
4805: nvl(period7_amount, 0) + nvl(period8_amount, 0) + nvl(period9_amount, 0) +
4806: nvl(period10_amount, 0) + nvl(period11_amount, 0) + nvl(period12_amount, 0) +

Line 5390: from PSB_WS_ACCOUNT_LINES a,

5386: /* For Bug No. 2214715 : Start */
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

Line 5421: PSB_WS_ACCOUNT_LINES a,

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
5425: and d.account_line_id = a.account_line_id

Line 5446: from PSB_WS_ACCOUNT_LINES a,

5442: /* For Bug No. 2214715 : Start */
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

Line 5484: PSB_WS_ACCOUNT_LINES a,

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
5488: and d.account_line_id = a.account_line_id

Line 5526: PSB_WS_ACCOUNT_LINES A

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
5530: AND A.CURRENCY_CODE = p_currency_code

Line 5557: PSB_WS_ACCOUNT_LINES A

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
5561: AND A.CURRENCY_CODE = p_currency_code

Line 5600: from PSB_WS_ACCOUNT_LINES a,

5596: -- This is applicable when the Detailed Flag is Set and is for all Service Packages
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

Line 5621: from PSB_WS_ACCOUNT_LINES a,

5617: -- that have been selected for submission in Worksheet Operations
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

Line 5704: psb_ws_account_lines f,

5700: cursor c_Account_types is
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

Line 7253: from PSB_WS_ACCOUNT_LINES

7249: l_concat_segments VARCHAR2(2000);
7250:
7251: cursor c_note_id is
7252: select note_id
7253: from PSB_WS_ACCOUNT_LINES
7254: where account_line_id = p_account_line_id;
7255: --
7256: BEGIN
7257: --

Line 7277: update PSB_WS_ACCOUNT_LINES

7273: (note_id, note, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
7274: values (psb_ws_account_line_notes_s.nextval, p_note, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
7275: returning note_id into l_note_id;
7276:
7277: update PSB_WS_ACCOUNT_LINES
7278: set note_id = l_note_id
7279: where account_line_id = p_account_line_id;
7280:
7281: end;