[Home] [Help]
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,