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_POSITION_ASSIGNMENTS

Line 651: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW

647: ELSE
648:
649: hr_utility.set_location(' ::: > before ASSinsert ' ,336);
650:
651: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW
652: (
653: p_api_version => 1,
654: p_init_msg_list => NULL,
655: p_commit => NULL,

Line 1411: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW

1407:
1408: IF l_attribute_value_id is not null or
1409: l_attribute_value is not null THEN
1410:
1411: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW
1412: (
1413: p_api_version => 1,
1414: p_init_msg_list => NULL,
1415: p_commit => NULL,

Line 2678: Delete psb_position_assignments

2674:
2675: IF (p_transaction_status <> 'APPLIED') then
2676:
2677: hr_utility.set_location('>> DELETING records to recreate .... ' ,1777);
2678: Delete psb_position_assignments
2679: where position_id = l_psb_position_id;
2680:
2681: Populate_Salary_Assignments
2682: ( p_return_status => l_return_status,

Line 2768: delete from psb_position_assignments

2764: p_budget_revision_pos_line_id => c_br_positions_rec.budget_revision_pos_line_id);
2765:
2766: end loop;
2767:
2768: delete from psb_position_assignments
2769: where position_id = l_psb_position_id;
2770:
2771: if sql%notfound then
2772: null;

Line 3971: Delete psb_position_assignments

3967:
3968: RAISE FND_API.G_EXC_ERROR;
3969: END IF;
3970:
3971: Delete psb_position_assignments
3972: where position_id = l_psb_position_id;
3973:
3974: Populate_Salary_Assignments
3975: ( p_return_status => l_return_status,

Line 4515: psb_position_assignments d

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
4519: AND b.hr_employee_id = be.hr_employee_id

Line 5685: FROM psb_position_assignments pas, -- bug #4886277: Used the table

5681: -- to l_elem_assign_csr
5682: Cursor l_elem_assign_csr(vc_position_id IN NUMBER)
5683: IS
5684: SELECT pas.position_assignment_id
5685: FROM psb_position_assignments pas, -- bug #4886277: Used the table
5686: -- instead of View.
5687: psb_pay_elements pe
5688: WHERE pas.pay_element_id = pe.pay_element_id (+)
5689: AND pas.assignment_type = 'ELEMENT'

Line 6672: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW

6668: /* if (((l_extract_method = 'CREATE') or (l_dummy = 0)) AND l_update_flag <> 'Y' )
6669: or ((l_elem_assign_dummy = 0) and (l_pay_element_id is not null))
6670: then */
6671: --
6672: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW
6673: (
6674: p_api_version => 1,
6675: p_init_msg_lISt => NULL,
6676: p_commit => NULL,

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 7284: Delete Psb_Position_Assignments

7280: -- refreshing.
7281: Begin
7282:
7283: -- Delete 'ELEMENT' assignments.
7284: Delete Psb_Position_Assignments
7285: WHERE position_id = employee_rec.position_id
7286: AND data_extract_id = p_data_extract_id
7287: AND assignment_type = 'ELEMENT';
7288:

Line 7290: Delete Psb_Position_Assignments

7286: AND data_extract_id = p_data_extract_id
7287: AND assignment_type = 'ELEMENT';
7288:
7289: -- Delete 'ATTRIBUTE' assignments.
7290: Delete Psb_Position_Assignments
7291: WHERE position_id = employee_rec.position_id
7292: AND data_extract_id = p_data_extract_id
7293: AND assignment_type = 'ATTRIBUTE';
7294:

Line 7474: FROM psb_position_assignments

7470: -- (position_id = hr_employee_id + hr_position_id)
7471: FOR l_pos_assignment_rec in
7472: (
7473: Select employee_id, position_assignment_id
7474: FROM psb_position_assignments
7475: WHERE data_extract_id = p_data_extract_id
7476: AND assignment_type = 'EMPLOYEE'
7477: AND position_id = employee_rec.position_id
7478: )

Line 7556: PSB_POSITION_ASSIGNMENTS_PVT.UPDATE_ROW

7552: else
7553: l_proposed_salary := prev_proposed_salary;
7554: END IF;
7555:
7556: PSB_POSITION_ASSIGNMENTS_PVT.UPDATE_ROW
7557: (
7558: p_api_version => 1,
7559: p_init_msg_lISt => NULL,
7560: p_commit => NULL,

Line 7643: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW

7639: p_data_extract_id
7640: );
7641:
7642: -- Create an 'EMPLOYEE' assignment FOR the related position_id.
7643: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW
7644: (
7645: p_api_version => 1,
7646: p_init_msg_lISt => NULL,
7647: p_commit => NULL,

Line 7694: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW

7690: else
7691: l_proposed_salary := prev_proposed_salary;
7692: END IF;
7693:
7694: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW
7695: (
7696: p_api_version => 1,
7697: p_init_msg_lISt => NULL,
7698: p_commit => NULL,

Line 7749: PSB_POSITION_ASSIGNMENTS_PVT.Delete_Row

7745:
7746: FOR terminated_rec IN C_Terminated_Employees
7747: LOOP
7748:
7749: PSB_POSITION_ASSIGNMENTS_PVT.Delete_Row
7750: ( p_api_version => 1.0,
7751: p_return_status => l_return_status,
7752: p_msg_count => l_msg_count,
7753: p_msg_data => l_msg_data,

Line 9124: p_process => 'PSB Position Assignments',

9120: p_return_status => l_return_status,
9121: p_msg_count => l_msg_count,
9122: p_msg_data => l_msg_data,
9123: p_data_extract_id => p_data_extract_id,
9124: p_process => 'PSB Position Assignments',
9125: p_status => l_status,
9126: p_restart_id => l_restart_hr_position_id
9127: );
9128:

Line 9172: psb_position_assignments ppa,

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
9176: AND ppa.assignment_type = 'EMPLOYEE'

Line 9227: p_process => 'PSB Position Assignments',

9223: p_msg_count => l_msg_count,
9224: p_msg_data => l_msg_data,
9225: p_data_extract_id => p_data_extract_id,
9226: p_extract_method => p_extract_method,
9227: p_process => 'PSB Position Assignments',
9228: p_restart_id => C_Assignment_Rec.hr_position_id
9229: );
9230:
9231:

Line 9361: FROM psb_position_assignments

9357: -- Find all the assignments as per the current position_id.
9358: FOR C_ref_assign_rec in
9359: (
9360: Select position_assignment_id
9361: FROM psb_position_assignments
9362: WHERE data_extract_id = p_data_extract_id
9363: AND position_id = lr_position_id
9364: AND attribute_id = lr_attribute_id
9365: AND assignment_type = 'ATTRIBUTE'

Line 9409: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW

9405:
9406: END IF; -- END creating 'ATTRIBUTE' type assignment in 'REFRESH' mode.
9407: IF (l_extract_method = 'CREATE' OR lr_max_dummy = 0 ) THEN
9408: --
9409: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW
9410: (
9411: p_api_version => 1,
9412: p_init_msg_lISt => NULL,
9413: p_commit => NULL,

Line 9458: p_process => 'PSB Position Assignments',

9454: p_msg_count => l_msg_count,
9455: p_msg_data => l_msg_data,
9456: p_data_extract_id => p_data_extract_id,
9457: p_extract_method => p_extract_method,
9458: p_process => 'PSB Position Assignments',
9459: p_restart_id => lp_hr_position_id
9460: );
9461:
9462: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 9473: p_process => 'PSB Position Assignments'

9469: p_msg_count => l_msg_count,
9470: p_msg_data => l_msg_data,
9471: p_data_extract_id => p_data_extract_id,
9472: p_extract_method => p_extract_method,
9473: p_process => 'PSB Position Assignments'
9474: );
9475:
9476: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9477: RAISE FND_API.G_EXC_ERROR;