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_OPS_PVT dependencies on PSB_POSITION_ASSIGNMENTS

Line 1479: psb_position_assignments.position_assignment_id%TYPE ;

1475: l_new_position_line_id psb_ws_lines_positions.position_line_id%TYPE ;
1476: l_new_fte_line_id psb_ws_fte_lines.fte_line_id%TYPE ;
1477: l_new_element_line_id psb_ws_element_lines.element_line_id%TYPE ;
1478: l_new_position_assignment_id
1479: psb_position_assignments.position_assignment_id%TYPE ;
1480: l_rowid VARCHAR2(2000);
1481: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
1482: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
1483: l_segment_values_tbl FND_FLEX_EXT.SegmentArray ;

Line 1914: -- ( Note that psb_position_assignments will have values specific to

1910: END LOOP; -- To process element_lines in psb_ws_element_lines.
1911:
1912: --
1913: -- Copy position assignment information related to the worksheet.
1914: -- ( Note that psb_position_assignments will have values specific to
1915: -- the global worksheet for the official ones.)
1916: --
1917: FOR l_asgn_rec IN
1918: (

Line 1921: psb_position_assignments asgn

1917: FOR l_asgn_rec IN
1918: (
1919: SELECT asgn.*
1920: FROM psb_ws_position_lines pos ,
1921: psb_position_assignments asgn
1922: WHERE pos.position_line_id = l_lines_pos_rec.position_line_id
1923: AND asgn.worksheet_id = l_ws_row_type.global_worksheet_id
1924: AND asgn.position_id = pos.position_id
1925: )

Line 1973: END LOOP; -- To process assignments in psb_position_assignments for

1969: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1971: END IF;
1972: --
1973: END LOOP; -- To process assignments in psb_position_assignments for
1974: -- current position line l_lines_pos_rec.position_line_id.
1975:
1976: END LOOP; -- To process position_lines in psb_ws_position_lines.
1977:

Line 2076: psb_position_assignments.position_assignment_id%TYPE ;

2072: l_new_position_line_id psb_ws_lines_positions.position_line_id%TYPE;
2073: l_new_fte_line_id psb_ws_fte_lines.fte_line_id%TYPE ;
2074: l_new_element_line_id psb_ws_element_lines.element_line_id%TYPE ;
2075: l_new_position_assignment_id
2076: psb_position_assignments.position_assignment_id%TYPE ;
2077: l_rowid VARCHAR2(2000);
2078: --
2079: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2080: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 2701: -- Create new records in psb_position_assignments for each occurance

2697: --
2698: END LOOP; -- To process element_lines in psb_ws_element_lines.
2699:
2700: --
2701: -- Create new records in psb_position_assignments for each occurance
2702: -- of l_lines_pos_rec.position_id. The global_worksheet_id
2703: -- will replace the worksheet_id column in new created records.
2704: --
2705: FOR l_asgn_rec IN

Line 2708: FROM psb_position_assignments

2704: --
2705: FOR l_asgn_rec IN
2706: (
2707: SELECT *
2708: FROM psb_position_assignments
2709: WHERE position_id = l_lines_pos_rec.position_id
2710: AND worksheet_id = p_source_worksheet_id
2711: )
2712: LOOP

Line 3170: -- Wipe out records in psb_position_assignments related to the original

3166: --
3167: END LOOP; -- To process element_lines in psb_ws_element_lines.
3168:
3169: --
3170: -- Wipe out records in psb_position_assignments related to the original
3171: -- l_target_position_id and create new records from the
3172: -- local l_lines_pos_rec.position_id. The global_worksheet_id will
3173: -- replace the worksheet_id column in new created records.
3174: --

Line 3175: DELETE psb_position_assignments

3171: -- l_target_position_id and create new records from the
3172: -- local l_lines_pos_rec.position_id. The global_worksheet_id will
3173: -- replace the worksheet_id column in new created records.
3174: --
3175: DELETE psb_position_assignments
3176: WHERE position_id = l_target_position_id
3177: AND worksheet_id = l_global_worksheet_id ;
3178:
3179: --

Line 3180: -- Create new records in psb_position_assignments for each occurance

3176: WHERE position_id = l_target_position_id
3177: AND worksheet_id = l_global_worksheet_id ;
3178:
3179: --
3180: -- Create new records in psb_position_assignments for each occurance
3181: -- of l_lines_pos_rec.position_id. The global_worksheet_id
3182: -- will replace the worksheet_id column in new created records.
3183: --
3184: FOR l_asgn_rec IN

Line 3187: FROM psb_position_assignments

3183: --
3184: FOR l_asgn_rec IN
3185: (
3186: SELECT *
3187: FROM psb_position_assignments
3188: WHERE position_id = l_lines_pos_rec.position_id
3189: AND worksheet_id = p_source_worksheet_id
3190: )
3191: LOOP

Line 6468: -- Delete from psb_position_assignments.

6464: -- Delete from psb_ws_user_profiles.
6465: DELETE psb_ws_user_profiles
6466: WHERE worksheet_id = p_worksheet_id ;
6467:
6468: -- Delete from psb_position_assignments.
6469: DELETE psb_position_assignments
6470: WHERE worksheet_id = p_worksheet_id ;
6471:
6472: -- Delete from psb_pay_element_rates.

Line 6469: DELETE psb_position_assignments

6465: DELETE psb_ws_user_profiles
6466: WHERE worksheet_id = p_worksheet_id ;
6467:
6468: -- Delete from psb_position_assignments.
6469: DELETE psb_position_assignments
6470: WHERE worksheet_id = p_worksheet_id ;
6471:
6472: -- Delete from psb_pay_element_rates.
6473: DELETE psb_pay_element_rates