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_POS1 dependencies on PSB_WS_FTE_LINES

Line 38: from PSB_WS_FTE_LINES a

34: period49_fte, period50_fte, period51_fte, period52_fte,
35: period53_fte, period54_fte, period55_fte, period56_fte,
36: period57_fte, period58_fte, period59_fte, period60_fte,
37: annual_fte
38: from PSB_WS_FTE_LINES a
39: where CurSeq between start_stage_seq and current_stage_seq
40: and stage_set_id = StSet
41: and service_package_id = SvcPkg
42: and budget_year_id = BudYr

Line 51: select psb_ws_fte_lines_s.nextval FteLineID

47: from PSB_BUDGET_GROUPS_V
48: where budget_group_id = BudGrp;
49:
50: cursor c_FTESeq is
51: select psb_ws_fte_lines_s.nextval FteLineID
52: from dual;
53:
54: cursor c_BaseSP (GlobalWS NUMBER) is
55: select service_package_id

Line 1877: update PSB_WS_FTE_LINES

1873:
1874: if FND_API.to_Boolean(l_spfl_exists) then
1875: begin
1876:
1877: update PSB_WS_FTE_LINES
1878: set period1_fte = l_period_fte(1), period2_fte = l_period_fte(2),
1879: period3_fte = l_period_fte(3), period4_fte = l_period_fte(4),
1880: period5_fte = l_period_fte(5), period6_fte = l_period_fte(6),
1881: period7_fte = l_period_fte(7), period8_fte = l_period_fte(8),

Line 1919: update PSB_WS_FTE_LINES

1915: end;
1916: else
1917: begin
1918:
1919: update PSB_WS_FTE_LINES
1920: set period1_fte = l_period_fte(1), period2_fte = l_period_fte(2),
1921: period3_fte = l_period_fte(3), period4_fte = l_period_fte(4),
1922: period5_fte = l_period_fte(5), period6_fte = l_period_fte(6),
1923: period7_fte = l_period_fte(7), period8_fte = l_period_fte(8),

Line 1983: insert into PSB_WS_FTE_LINES

1979: end if;
1980:
1981: end loop;
1982:
1983: insert into PSB_WS_FTE_LINES
1984: (fte_line_id,
1985: position_line_id,
1986: budget_year_id,
1987: service_package_id,

Line 2198: -- FTE/SP record (in PSB_WS_FTE_LINES)

2194: --
2195: -- (i) Change SP only : if (start_stage_seq <> current_stage_seq) for current
2196: -- record
2197: -- (a) create new stage for all entries for the same SP including :
2198: -- FTE/SP record (in PSB_WS_FTE_LINES)
2199: -- Element Cost records for all recurring elements (in PSB_WS_ELEMENT_LINES)
2200: -- Account Dist records for all recurring elements (in PSB_WS_ACCOUNT_LINES)
2201: -- (b) recalculate for all recurring elements
2202:

Line 2206: -- FTE/SP record (in PSB_WS_FTE_LINES)

2202:
2203: -- (ii) Change FTE only : if (start_stage_seq <> current_stage_seq) for current
2204: -- record
2205: -- (a) create new stage for all entries for the same SP including :
2206: -- FTE/SP record (in PSB_WS_FTE_LINES)
2207: -- Element Cost records for all recurring elements (in PSB_WS_ELEMENT_LINES)
2208: -- Account Dist records for all recurring elements (in PSB_WS_ACCOUNT_LINES)
2209: -- (b) recalculate for all recurring elements
2210:

Line 2214: -- FTE/SP record (in PSB_WS_FTE_LINES)

2210:
2211: -- (iii) Change FTE and SP : if (start_stage_seq <> current_stage_seq) for current
2212: -- record
2213: -- (a) create new stage for all entries for the same SP including :
2214: -- FTE/SP record (in PSB_WS_FTE_LINES)
2215: -- Element Cost records for all recurring elements (in PSB_WS_ELEMENT_LINES)
2216: -- Account Dist records for all recurring elements (in PSB_WS_ACCOUNT_LINES)
2217: -- (b) recalculate for all recurring elements
2218:

Line 2320: from PSB_WS_FTE_LINES

2316: period49_fte, period50_fte, period51_fte, period52_fte,
2317: period53_fte, period54_fte, period55_fte, period56_fte,
2318: period57_fte, period58_fte, period59_fte, period60_fte,
2319: annual_fte
2320: from PSB_WS_FTE_LINES
2321: where fte_line_id = p_fte_line_id;
2322:
2323: cursor c_PrevStage is
2324: select Max(sequence_number) sequence_number

Line 2492: sql_wfl := 'insert into PSB_WS_FTE_LINES ' ||

2488: for c_FTESeq_Rec in c_FTESeq loop
2489: l_fte_line_id := c_FTESeq_Rec.FTELineID;
2490: end loop;
2491:
2492: sql_wfl := 'insert into PSB_WS_FTE_LINES ' ||
2493: '(fte_line_id, ' ||
2494: 'position_line_id, ' ||
2495: 'budget_year_id, ' ||
2496: 'service_package_id, ' ||

Line 2545: 'from PSB_WS_FTE_LINES ' ||

2541: ':b_last_updated_by, ' ||
2542: ':b_last_update_login , ' ||
2543: ':b_created_by, ' ||
2544: ':b_creation_date ' ||
2545: 'from PSB_WS_FTE_LINES ' ||
2546: 'where fte_line_id = :b_fte_line_id';
2547:
2548: -- Replaced PSB_WS_ACCT1.dsql_execute with execute immediate for bug 3132485
2549: -- Bug#5030383

Line 2577: sql_wfl := 'update PSB_WS_FTE_LINES ' ||

2573: end if;
2574:
2575: l_new_annual_fte := 0;
2576:
2577: sql_wfl := 'update PSB_WS_FTE_LINES ' ||
2578: 'set service_package_id = decode( :p_service_package_id1 , :gmn1,'||
2579: 'service_package_id, :p_service_package_id2 ), ';
2580:
2581: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop

Line 3124: FROM psb_ws_fte_lines

3120: WHERE position_line_id = p_position_line_id;
3121:
3122: CURSOR c_fte IS
3123: SELECT annual_fte
3124: FROM psb_ws_fte_lines
3125: WHERE position_line_id = p_position_line_id
3126: AND budget_year_id= p_budget_year_id;
3127:
3128: CURSOR c_pos_group IS

Line 4110: from PSB_WS_FTE_LINES a

4106: l_return_status VARCHAR2(1);
4107:
4108: cursor c_FTE is
4109: select annual_fte
4110: from PSB_WS_FTE_LINES a
4111: where p_current_stage_seq between start_stage_seq and current_stage_seq
4112: and stage_set_id = p_stage_set_id
4113: and service_package_id = p_service_package_id
4114: and budget_year_id = p_budget_year_id