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_WS_ELEMENT_LINES

Line 1477: l_new_element_line_id psb_ws_element_lines.element_line_id%TYPE ;

1473: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1474: l_new_worksheet_id psb_worksheets.worksheet_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 ;

Line 1667: -- The related rows in psb_ws_fte_lines and psb_ws_element_lines will

1663:
1664: --
1665: -- We need to find all the position_line_id for the worksheet and each of
1666: -- the position_line_id needs to be copied in psb_ws_position_lines table.
1667: -- The related rows in psb_ws_fte_lines and psb_ws_element_lines will
1668: -- also be copied and assigned new position_line_id as created in the
1669: -- psb_ws_position_lines table.
1670: --
1671:

Line 1864: END LOOP; -- To process fte_lines in psb_ws_element_lines.

1860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1862: END IF;
1863: --
1864: END LOOP; -- To process fte_lines in psb_ws_element_lines.
1865:
1866: --
1867: -- Copy each record in psb_ws_element_lines table for the current
1868: -- l_lines_pos_rec.position_line_id. The new l_new_position_line_id

Line 1867: -- Copy each record in psb_ws_element_lines table for the current

1863: --
1864: END LOOP; -- To process fte_lines in psb_ws_element_lines.
1865:
1866: --
1867: -- Copy each record in psb_ws_element_lines table for the current
1868: -- l_lines_pos_rec.position_line_id. The new l_new_position_line_id
1869: -- will replace the position_line_id column in new created records.
1870: --
1871: FOR l_element_rec IN

Line 1874: FROM psb_ws_element_lines

1870: --
1871: FOR l_element_rec IN
1872: (
1873: SELECT *
1874: FROM psb_ws_element_lines
1875: WHERE position_line_id = l_lines_pos_rec.position_line_id
1876: )
1877: LOOP
1878:

Line 1879: -- API to create new element lines in psb_ws_element_lines.

1875: WHERE position_line_id = l_lines_pos_rec.position_line_id
1876: )
1877: LOOP
1878:
1879: -- API to create new element lines in psb_ws_element_lines.
1880: PSB_WS_Pos_Pvt.Create_Element_Lines
1881: (
1882: p_api_version => 1.0 ,
1883: p_init_msg_list => FND_API.G_FALSE ,

Line 1910: END LOOP; -- To process element_lines in psb_ws_element_lines.

1906: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1908: END IF;
1909: --
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

Line 2074: l_new_element_line_id psb_ws_element_lines.element_line_id%TYPE ;

2070: l_target_position_id psb_ws_position_lines.position_id%TYPE;
2071: --
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: --

Line 2649: END LOOP; -- To process fte_lines in psb_ws_element_lines

2645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2647: END IF;
2648: --
2649: END LOOP; -- To process fte_lines in psb_ws_element_lines
2650:
2651:
2652: --
2653: -- Create new records in psb_ws_element_lines table for each occurance

Line 2653: -- Create new records in psb_ws_element_lines table for each occurance

2649: END LOOP; -- To process fte_lines in psb_ws_element_lines
2650:
2651:
2652: --
2653: -- Create new records in psb_ws_element_lines table for each occurance
2654: -- of l_lines_pos_rec.position_line_id. The new l_new_position_line_id
2655: -- will replace the position_line_id column in new created records.
2656: --
2657: FOR l_element_rec IN

Line 2660: FROM psb_ws_element_lines

2656: --
2657: FOR l_element_rec IN
2658: (
2659: SELECT *
2660: FROM psb_ws_element_lines
2661: WHERE position_line_id = l_lines_pos_rec.position_line_id
2662: )
2663: LOOP
2664:

Line 2665: -- API to create new element lines in psb_ws_element_lines.

2661: WHERE position_line_id = l_lines_pos_rec.position_line_id
2662: )
2663: LOOP
2664:
2665: -- API to create new element lines in psb_ws_element_lines.
2666: PSB_WS_Pos_Pvt.Create_Element_Lines
2667: (
2668: p_api_version => 1.0 ,
2669: p_init_msg_list => FND_API.G_FALSE ,

Line 2698: END LOOP; -- To process element_lines in psb_ws_element_lines.

2694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2696: END IF;
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

Line 3113: END LOOP; -- To process fte_lines in psb_ws_element_lines.

3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3110: END IF;
3111: --
3112:
3113: END LOOP; -- To process fte_lines in psb_ws_element_lines.
3114:
3115:
3116: --
3117: -- Wipe out records in psb_ws_element_lines related to the original line

Line 3117: -- Wipe out records in psb_ws_element_lines related to the original line

3113: END LOOP; -- To process fte_lines in psb_ws_element_lines.
3114:
3115:
3116: --
3117: -- Wipe out records in psb_ws_element_lines related to the original line
3118: -- l_target_position_line_id and create new records from the local
3119: -- l_lines_pos_rec.position_line_id . The l_target_position_line_id
3120: -- will replace the position_line_id column in new created records.
3121: --

Line 3123: DELETE psb_ws_element_lines

3119: -- l_lines_pos_rec.position_line_id . The l_target_position_line_id
3120: -- will replace the position_line_id column in new created records.
3121: --
3122:
3123: DELETE psb_ws_element_lines
3124: WHERE position_line_id = l_target_position_line_id ;
3125:
3126: FOR l_element_rec IN
3127: (

Line 3129: FROM psb_ws_element_lines

3125:
3126: FOR l_element_rec IN
3127: (
3128: SELECT *
3129: FROM psb_ws_element_lines
3130: WHERE position_line_id = l_lines_pos_rec.position_line_id
3131: )
3132: LOOP
3133:

Line 3134: -- API to create new element lines in psb_ws_element_lines.

3130: WHERE position_line_id = l_lines_pos_rec.position_line_id
3131: )
3132: LOOP
3133:
3134: -- API to create new element lines in psb_ws_element_lines.
3135: PSB_WS_Pos_Pvt.Create_Element_Lines
3136: (
3137: p_api_version => 1.0 ,
3138: p_init_msg_list => FND_API.G_FALSE ,

Line 3167: END LOOP; -- To process element_lines in psb_ws_element_lines.

3163: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3165: END IF;
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

Line 4980: -- Update all the lines in psb_ws_element_lines as no service package

4976: FROM psb_ws_lines_positions
4977: WHERE worksheet_id = p_worksheet_id ) ;
4978:
4979: --
4980: -- Update all the lines in psb_ws_element_lines as no service package
4981: -- selection exists.
4982: --
4983: UPDATE psb_ws_element_lines
4984: SET current_stage_seq = l_target_stage_seq

Line 4983: UPDATE psb_ws_element_lines

4979: --
4980: -- Update all the lines in psb_ws_element_lines as no service package
4981: -- selection exists.
4982: --
4983: UPDATE psb_ws_element_lines
4984: SET current_stage_seq = l_target_stage_seq
4985: WHERE l_target_stage_seq > current_stage_seq
4986: AND end_stage_seq is null
4987: AND position_line_id IN

Line 5037: -- Update psb_ws_element_lines as per the service package selection.

5033: AND operation_id = p_operation_id
5034: ) ;
5035:
5036: --
5037: -- Update psb_ws_element_lines as per the service package selection.
5038: --
5039: UPDATE psb_ws_element_lines
5040: SET current_stage_seq = l_target_stage_seq
5041: WHERE l_target_stage_seq > current_stage_seq

Line 5039: UPDATE psb_ws_element_lines

5035:
5036: --
5037: -- Update psb_ws_element_lines as per the service package selection.
5038: --
5039: UPDATE psb_ws_element_lines
5040: SET current_stage_seq = l_target_stage_seq
5041: WHERE l_target_stage_seq > current_stage_seq
5042: AND end_stage_seq is null
5043: AND position_line_id IN

Line 6393: -- Deleting records from psb_ws_element_lines.

6389: -- Deleting records from psb_ws_fte_lines.
6390: DELETE psb_ws_fte_lines
6391: WHERE position_line_id = l_position_line_id;
6392:
6393: -- Deleting records from psb_ws_element_lines.
6394: DELETE psb_ws_element_lines
6395: WHERE position_line_id = l_position_line_id;
6396:
6397: /*For Bug No : 2266309 Start*/

Line 6394: DELETE psb_ws_element_lines

6390: DELETE psb_ws_fte_lines
6391: WHERE position_line_id = l_position_line_id;
6392:
6393: -- Deleting records from psb_ws_element_lines.
6394: DELETE psb_ws_element_lines
6395: WHERE position_line_id = l_position_line_id;
6396:
6397: /*For Bug No : 2266309 Start*/
6398: l_record_ctr := l_record_ctr + 3;