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_HR_POPULATE_DATA_PVT dependencies on PSB_POSITIONS

Line 1995: SELECT psb_positions_s.nextval INTO l_position_id

1991: l_availability_status := C_avail_status_rec.system_type_cd;
1992: End loop;
1993:
1994: -- Create new position in PSB
1995: SELECT psb_positions_s.nextval INTO l_position_id
1996: FROM dual;
1997:
1998: PSB_POSITIONS_PVT.INSERT_ROW
1999: (

Line 1998: PSB_POSITIONS_PVT.INSERT_ROW

1994: -- Create new position in PSB
1995: SELECT psb_positions_s.nextval INTO l_position_id
1996: FROM dual;
1997:
1998: PSB_POSITIONS_PVT.INSERT_ROW
1999: (
2000: p_api_version => 1.0,
2001: p_init_msg_list => NULL,
2002: p_commit => NULL,

Line 2190: from psb_positions

2186: Select 'Position Transaction Exists in PSB'
2187: from dual
2188: where exists
2189: (Select 1
2190: from psb_positions
2191: where transaction_id = p_position_transaction_id);
2192:
2193: Cursor C_pos_trx is
2194: Select *

Line 2195: from psb_positions

2191: where transaction_id = p_position_transaction_id);
2192:
2193: Cursor C_pos_trx is
2194: Select *
2195: from psb_positions
2196: where transaction_id = p_position_transaction_id;
2197:
2198: Cursor C_availability_status is
2199: /*For Bug No : 1527423 Start*/

Line 2291: For C_pos_trx_rec in C_pos_trx -- psb_positions

2287: /*For Bug No : 2738939 End*/
2288:
2289: hr_utility.set_location('>> applid 8401 ' ,1777);
2290:
2291: For C_pos_trx_rec in C_pos_trx -- psb_positions
2292: Loop
2293: l_psb_position_id := C_pos_trx_rec.position_id;
2294: -- de by org
2295: l_organization_id := C_pos_trx_rec.organization_id;

Line 2616: PSB_POSITIONS_PVT.UPDATE_ROW

2612: hr_utility.set_location('>> l_ccid '|| l_ccid,777);
2613:
2614: --++ end restructure
2615:
2616: PSB_POSITIONS_PVT.UPDATE_ROW
2617: (
2618: p_api_version => 1.0,
2619: p_init_msg_lISt => FND_API.G_FALSE,
2620: p_commit => FND_API.G_FALSE,

Line 2775: PSB_POSITIONS_PVT.DELETE_ROW

2771: if sql%notfound then
2772: null;
2773: end if;
2774:
2775: PSB_POSITIONS_PVT.DELETE_ROW
2776: (
2777: p_api_version => 1.0,
2778: p_init_msg_liSt => FND_API.G_FALSE,
2779: p_commit => FND_API.G_FALSE,

Line 3264: select psb_positions_s.nextval INTO l_position_id

3260: /*For Bug No 1527423 End */
3261: End loop;
3262:
3263: -- Create new position in PSB
3264: select psb_positions_s.nextval INTO l_position_id
3265: from dual;
3266:
3267: hr_utility.set_location('l_position_id '||l_position_id ,9833);
3268: hr_utility.set_location('l_data_extract_id '||l_data_extract_id, 9833);

Line 3281: PSB_POSITIONS_PVT.INSERT_ROW

3277: hr_utility.set_location('_availability_status '||
3278: l_availability_status ,9833);
3279: hr_utility.set_location('l_concat_pos_name '||l_concat_pos_name ,9833);
3280:
3281: PSB_POSITIONS_PVT.INSERT_ROW
3282: (
3283: p_api_version => 1.0,
3284: p_init_msg_lISt => NULL,
3285: p_commit => NULL,

Line 3352: hr_utility.set_location(' end add psb positions'||l_position_id,1333);

3348: p_msg_data => l_msg_data,
3349: p_position_id => l_position_id
3350: ) ;
3351:
3352: hr_utility.set_location(' end add psb positions'||l_position_id,1333);
3353:
3354: -- Populate Salary Assignments
3355: hr_utility.set_location(' Before Salary Assignment'||l_position_id,333);
3356:

Line 3486: from psb_positions

3482: /*For Bug No : 2602027 End*/
3483:
3484: Cursor C_pos_trx is
3485: Select *
3486: from psb_positions
3487: where hr_position_id = p_position_id
3488: and data_extract_id = l_data_extract_id;
3489:
3490: Cursor C_availability_status is

Line 3912: PSB_POSITIONS_PVT.UPDATE_ROW

3908:
3909: hr_utility.set_location(' before update position', 1887);
3910: -- ++++++
3911:
3912: PSB_POSITIONS_PVT.UPDATE_ROW
3913: (
3914: p_api_version => 1.0,
3915: p_init_msg_lISt => FND_API.G_FALSE,
3916: p_commit => FND_API.G_FALSE,

Line 4175: UPDATE psb_positions

4171:
4172: END LOOP;
4173:
4174: IF NVL(l_root_budget_group, 'N') = 'Y' THEN
4175: UPDATE psb_positions
4176: SET budget_group_id = l_org_budget_group_id
4177: WHERE position_id = p_position_id;
4178: ELSE
4179: UPDATE psb_positions

Line 4179: UPDATE psb_positions

4175: UPDATE psb_positions
4176: SET budget_group_id = l_org_budget_group_id
4177: WHERE position_id = p_position_id;
4178: ELSE
4179: UPDATE psb_positions
4180: SET budget_group_id = l_budget_group_id
4181: WHERE position_id = p_position_id;
4182: END IF;
4183: -- end bug 3253644

Line 4236: FROM PSB_POSITIONS PP,

4232: PP.organization_id,
4233: PP.hr_employee_id,
4234: PP.effective_start_DATE,
4235: PP.effective_END_DATE
4236: FROM PSB_POSITIONS PP,
4237: PSB_POSITIONS_I PPI
4238: WHERE PP.data_extract_id = p_data_extract_id
4239: AND PP.data_extract_id = PPI.data_extract_id
4240: AND PP.position_id > p_restart_position_id

Line 4237: PSB_POSITIONS_I PPI

4233: PP.hr_employee_id,
4234: PP.effective_start_DATE,
4235: PP.effective_END_DATE
4236: FROM PSB_POSITIONS PP,
4237: PSB_POSITIONS_I PPI
4238: WHERE PP.data_extract_id = p_data_extract_id
4239: AND PP.data_extract_id = PPI.data_extract_id
4240: AND PP.position_id > p_restart_position_id
4241: AND PP.hr_position_id = PPI.hr_position_id

Line 4514: psb_positions c,

4510: a.effective_start_date
4511: FROM psb_cost_distributions_i a,
4512: psb_employees_i b,
4513: psb_employees be,
4514: psb_positions c,
4515: psb_position_assignments d
4516: WHERE a.assignment_id = b.assignment_id
4517: AND a.data_extract_id = p_data_extract_id
4518: AND b.hr_position_id = c.hr_position_id

Line 5700: SELECT * FROM psb_positions_i

5696:
5697: /* Bug 3417868 Start */
5698:
5699: CURSOR l_position_source IS
5700: SELECT * FROM psb_positions_i
5701: WHERE data_extract_id = p_data_extract_id
5702: AND hr_position_id > l_restart_hr_position_id
5703: ORDER BY hr_position_id,
5704: hr_employee_id;

Line 5766: --psb positions in refresh mode.

5762: TYPE l_position_i_tbl_type IS TABLE OF l_position_i_rec_type
5763: INDEX BY BINARY_INTEGER;
5764:
5765: --bug#4166493, rec type modified to add additional columns necessary to update
5766: --psb positions in refresh mode.
5767:
5768: TYPE l_position_rec_type IS RECORD
5769: ( hr_position_id NUMBER,
5770: hr_employee_id NUMBER,

Line 5853: p_process => 'PSB Positions',

5849: p_return_status => l_return_status,
5850: p_msg_count => l_msg_count,
5851: p_msg_data => l_msg_data,
5852: p_data_extract_id => p_data_extract_id,
5853: p_process => 'PSB Positions',
5854: p_status => l_status,
5855: p_restart_id => l_restart_hr_position_id
5856: ) ;
5857: --

Line 5883: --Bug#4166493, picking up additonal data, necessary for updating psb_positions.

5879:
5880: --populating target pl/sql table
5881: FOR position_target_rec in
5882: (
5883: --Bug#4166493, picking up additonal data, necessary for updating psb_positions.
5884: Select hr_position_id,
5885: hr_employee_id,
5886: position_id,
5887: organization_id,

Line 5894: FROM psb_positions

5890: position_definition_id,
5891: transaction_id,
5892: transaction_status,
5893: name
5894: FROM psb_positions
5895: WHERE data_extract_id = p_data_extract_id
5896: AND hr_position_id = l_last_hr_position_id
5897: ORDER BY hr_position_id,
5898: hr_employee_id

Line 6018: PSB_POSITIONS_PVT.UPDATE_ROW

6014: IF l_position_cache(j).update_insert_flag IS NULL THEN
6015:
6016: -- Only thing we update here is the employee_id to NULL,
6017: --rest of the data remains same.
6018: PSB_POSITIONS_PVT.UPDATE_ROW
6019: (
6020: p_api_version => 1.0,
6021: p_init_msg_lISt => FND_API.G_FALSE,
6022: p_commit => FND_API.G_FALSE,

Line 6164: p_process => 'PSB Positions',

6160: p_msg_count => l_msg_count,
6161: p_msg_data => l_msg_data,
6162: p_data_extract_id => p_data_extract_id,
6163: p_extract_method => p_extract_method,
6164: p_process => 'PSB Positions',
6165: p_restart_id => prev_hr_position_id
6166: ) ;
6167: --
6168: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 6377: FROM psb_positions

6373:
6374: FOR C_Refresh_Rec in
6375: (
6376: SELECT position_id,organization_id
6377: FROM psb_positions
6378: WHERE hr_position_id = position_rec.hr_position_id
6379: AND ( NVL(hr_employee_id,-1)=NVL(position_rec.hr_employee_id,-1)
6380: OR
6381: ( hr_employee_id IS NULL

Line 6385: FROM psb_positions

6381: ( hr_employee_id IS NULL
6382: AND
6383: NOT EXISTS
6384: ( SELECT 1
6385: FROM psb_positions
6386: WHERE hr_position_id = position_rec.hr_position_id
6387: AND hr_employee_id = position_rec.hr_employee_id
6388: AND data_extract_id = p_data_extract_id
6389: )

Line 6397: FROM psb_positions

6393: ( hr_employee_id IS NOT NULL
6394: AND
6395: NOT EXISTS
6396: ( SELECT 1
6397: FROM psb_positions
6398: WHERE hr_position_id = position_rec.hr_position_id
6399: AND hr_employee_id IS NULL
6400: AND data_extract_id = p_data_extract_id
6401: )

Line 6418: PSB_POSITIONS_PVT.UPDATE_ROW

6414: /* Bug 3417868 End */
6415:
6416:
6417: -- bug 4551061 added the in parameter p_availability_status
6418: PSB_POSITIONS_PVT.UPDATE_ROW
6419: (
6420: p_api_version => 1.0,
6421: p_init_msg_lISt => FND_API.G_FALSE,
6422: p_commit => FND_API.G_FALSE,

Line 6543: PSB_POSITIONS_PVT.ModIFy_Assignment(

6539: /* start bug no 4213882 */
6540: if l_assignment_rec_no < 2 then
6541: /* end bug no 4213882 */
6542:
6543: PSB_POSITIONS_PVT.ModIFy_Assignment(
6544: p_api_version => 1.0,
6545: p_return_status => l_return_status,
6546: p_msg_count => l_msg_count,
6547: p_msg_data => l_msg_data,

Line 6604: SELECT psb_positions_s.nextval INTO l_position_id

6600: --
6601: /* Bug 3417868 Start */
6602: ELSIF l_position_i_cache(i).update_insert_flag = 'I' THEN
6603: /* Bug 3417868 End */
6604: SELECT psb_positions_s.nextval INTO l_position_id
6605: FROM dual;
6606:
6607: -- bug 4551061 added the in parameter p_availability_status
6608: PSB_POSITIONS_PVT.INSERT_ROW

Line 6608: PSB_POSITIONS_PVT.INSERT_ROW

6604: SELECT psb_positions_s.nextval INTO l_position_id
6605: FROM dual;
6606:
6607: -- bug 4551061 added the in parameter p_availability_status
6608: PSB_POSITIONS_PVT.INSERT_ROW
6609: (
6610: p_api_version => 1.0,
6611: p_init_msg_lISt => NULL,
6612: p_commit => NULL,

Line 6803: END LOOP; -- END processing all the positions FROM psb_positions_i table.

6799: END IF;
6800:
6801: l_last_hr_position_id:= l_pos_record.hr_position_id;
6802:
6803: END LOOP; -- END processing all the positions FROM psb_positions_i table.
6804: CLOSE l_position_source;
6805: /* Bug 3417868 End */
6806:
6807: /* For Bug No: 3066598 Start */

Line 6817: p_process => 'PSB Positions',

6813: p_msg_count => l_msg_count,
6814: p_msg_data => l_msg_data,
6815: p_data_extract_id => p_data_extract_id,
6816: p_extract_method => p_extract_method,
6817: p_process => 'PSB Positions',
6818: p_restart_id => prev_hr_position_id
6819: );
6820: --
6821: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 6837: p_process => 'PSB Positions'

6833: p_msg_count => l_msg_count,
6834: p_msg_data => l_msg_data,
6835: p_data_extract_id => p_data_extract_id,
6836: p_extract_method => p_extract_method,
6837: p_process => 'PSB Positions'
6838: );
6839: --
6840: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6841: RAISE FND_API.G_EXC_ERROR;

Line 6936: -- because psb_positions IS populated with proper hr_employee_id prior to

6932: l_api_name CONSTANT VARCHAR2(30) := 'Populate_Employee';
6933: l_api_version CONSTANT NUMBER := 1.0;
6934:
6935: -- Outer join IS NOT needed FOR ( pe.hr_employee_id = pp.hr_employee_id)
6936: -- because psb_positions IS populated with proper hr_employee_id prior to
6937: -- running thIS process.
6938: /*For Bug No : 2594575 Start*/
6939: --Stop extracting secured data of employee
6940: --Removed the columns in psb_employees table

Line 6961: psb_positions pp

6957: element_value,proposed_salary,
6958: employee_number,
6959: pp.set_of_books_id
6960: FROM psb_employees_i pe,
6961: psb_positions pp
6962: WHERE pe.data_extract_id = p_data_extract_id
6963: AND pe.data_extract_id = pp.data_extract_id
6964: AND pe.hr_position_id = pp.hr_position_id
6965: AND pe.hr_employee_id = pp.hr_employee_id

Line 6974: FROM psb_position_assignments ppa,psb_positions pp,psb_employees pe,

6970: /*Cursor Added for Bug#4135280 */
6971: /*Modified the cursor for Bug#4166493, to take care of date tracked HR data*/
6972: CURSOR C_Terminated_Employees IS
6973: SELECT distinct position_assignment_id,pp.position_id,pe.hr_employee_id
6974: FROM psb_position_assignments ppa,psb_positions pp,psb_employees pe,
6975: per_all_assignments_f paf
6976: WHERE ppa.position_id=pp.position_id
6977: AND ppa.data_extract_id=p_data_extract_id
6978: AND pp.hr_position_id > l_restart_hr_position_id

Line 6993: FROM psb_position_assignments ppa,psb_positions pp,psb_employees pe,

6989: AND pp.hr_employee_id IS NULL
6990: AND ppa.assignment_type='EMPLOYEE';
6991:
6992: /* SELECT distinct position_assignment_id,pp.position_id,pe.hr_employee_id
6993: FROM psb_position_assignments ppa,psb_positions pp,psb_employees pe,
6994: per_all_assignments_f paf
6995: WHERE ppa.position_id=pp.position_id
6996: AND ppa.data_extract_id=p_data_extract_id
6997: AND pp.hr_position_id > l_restart_hr_position_id

Line 7483: PSB_POSITIONS_PVT.ModIFy_Assignment

7479: LOOP
7480:
7481: l_employee_dummy := 1;
7482:
7483: PSB_POSITIONS_PVT.ModIFy_Assignment
7484: (
7485: p_api_version => 1.0,
7486: p_return_status => l_return_status,
7487: p_msg_count => l_msg_count,

Line 9171: FROM psb_positions pp,

9167: pea.attribute_name,
9168: pea.attribute_value,
9169: pea.effective_start_DATE,
9170: pea.effective_END_DATE
9171: FROM psb_positions pp,
9172: psb_position_assignments ppa,
9173: psb_employee_assignments_i pea
9174: WHERE pp.data_extract_id = p_data_extract_id
9175: AND pp.position_id = ppa.position_id

Line 9193: psb_positions pp

9189: pea.attribute_value,
9190: pea.effective_start_DATE,
9191: pea.effective_END_DATE
9192: FROM psb_employee_assignments_i pea,
9193: psb_positions pp
9194: WHERE pea.data_extract_id = p_data_extract_id
9195: AND pea.hr_position_id = pp.hr_position_id
9196: AND pea.hr_employee_id IS NULL
9197: AND pp.hr_employee_id IS NULL

Line 9296: -- As hr_employee_id IS NULL, retrieve position_id FROM psb_positions.

9292: END IF; -- END IF ( l_value_table_flag = 'Y')
9293: -- Find the position_id to be upDATEd FOR.
9294: IF (C_Assignment_rec.hr_employee_id IS NULL) THEN
9295:
9296: -- As hr_employee_id IS NULL, retrieve position_id FROM psb_positions.
9297: FOR C_max_pos_rec in
9298: (
9299: Select position_id
9300: FROM psb_positions

Line 9300: FROM psb_positions

9296: -- As hr_employee_id IS NULL, retrieve position_id FROM psb_positions.
9297: FOR C_max_pos_rec in
9298: (
9299: Select position_id
9300: FROM psb_positions
9301: WHERE data_extract_id = p_data_extract_id
9302: AND hr_position_id = C_Assignment_rec.hr_position_id
9303: AND hr_employee_id is null
9304: )

Line 9317: FROM psb_positions

9313:
9314: FOR C_max_rec in
9315: (
9316: Select position_id
9317: FROM psb_positions
9318: WHERE data_extract_id = p_data_extract_id
9319: AND hr_position_id = C_Assignment_rec.hr_position_id
9320: AND hr_employee_id = C_Assignment_rec.hr_employee_id
9321: )

Line 9370: PSB_POSITIONS_PVT.ModIFy_Assignment

9366: )
9367: LOOP
9368: lr_max_dummy := 1;
9369:
9370: PSB_POSITIONS_PVT.ModIFy_Assignment
9371: (
9372: p_api_version => 1.0,
9373: p_return_status => l_return_status,
9374: p_msg_count => l_msg_count,

Line 9624: PSB_POSITIONS_PVT.Create_Default_Assignments

9620:
9621: IF (l_status = 'I') THEN
9622:
9623:
9624: PSB_POSITIONS_PVT.Create_Default_Assignments
9625: ( p_api_version => 1.0,
9626: p_commit => FND_API.G_FALSE,
9627: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9628: p_init_msg_lISt => FND_API.G_FALSE,