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_POSITIONS_PVT dependencies on PSB_POSITION_ASSIGNMENTS_PVT

Line 1811: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

1807: /* No Overlaps, Input not for protecting assignment: direct insert */
1808: -- removed salary validation
1809: begin
1810:
1811: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
1812: (p_api_version => 1.0,
1813: p_return_status => l_return_status,
1814: p_msg_count => l_msg_count,
1815: p_msg_data => l_msg_data,

Line 1886: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row

1882: )
1883: ) then
1884: begin
1885:
1886: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row
1887: (p_api_version => 1.0,
1888: p_return_status => l_return_status,
1889: p_msg_count => l_msg_count,
1890: p_msg_data => l_msg_data,

Line 2021: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row

2017:
2018: --+ pass input pay_element_id and pay_element_option_id so that salary overlap will result
2019: --+ of update will have the new input salary values
2020:
2021: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row
2022: (p_api_version => 1.0,
2023: p_return_status => l_return_status,
2024: p_msg_count => l_msg_count,
2025: p_msg_data => l_msg_data,

Line 2052: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

2048: end;
2049: elsif ((g_assign(l_assign_index).worksheet_id is null) and (p_worksheet_id is not null) and
2050: (not FND_API.to_Boolean(l_ws_overlap))) then
2051: begin
2052: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
2053: (p_api_version => 1.0,
2054: p_return_status => l_return_status,
2055: p_msg_count => l_msg_count,
2056: p_msg_data => l_msg_data,

Line 2132: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row

2128: l_element_id := p_pay_element_id;
2129: END IF;
2130: /* end bug no 4213882 */
2131:
2132: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row
2133: (p_api_version => 1.0,
2134: p_return_status => l_return_status,
2135: p_msg_count => l_msg_count,
2136: p_msg_data => l_msg_data,

Line 2185: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row

2181: l_element_id := p_pay_element_id;
2182: END IF;
2183: /* end bug no 4213882 */
2184:
2185: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row
2186: (p_api_version => 1.0,
2187: p_return_status => l_return_status,
2188: p_msg_count => l_msg_count,
2189: p_msg_data => l_msg_data,

Line 2233: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

2229: (g_assign(l_assign_index).effective_start_date > p_effective_start_date) AND
2230: (p_effective_end_date is null)) THEN
2231: /* end bug 4153562 */
2232:
2233: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
2234: (p_api_version => 1.0,
2235: p_return_status => l_return_status,
2236: p_msg_count => l_msg_count,
2237: p_msg_data => l_msg_data,

Line 2287: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

2283:
2284: if FND_API.to_Boolean(l_updated_record) then
2285: begin
2286:
2287: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
2288: (p_api_version => 1.0,
2289: p_return_status => l_return_status,
2290: p_msg_count => l_msg_count,
2291: p_msg_data => l_msg_data,

Line 2329: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row

2325: begin
2326:
2327: --++ pass input pay_element_option_id so that if input is salary, the updated row will
2328: --++ reflect the input value
2329: PSB_POSITION_ASSIGNMENTS_PVT.Update_Row
2330: (p_api_version => 1.0,
2331: p_return_status => l_return_status,
2332: p_msg_count => l_msg_count,
2333: p_msg_data => l_msg_data,

Line 2461: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

2457:
2458: if not FND_API.to_Boolean(l_created_record) then
2459: begin
2460:
2461: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
2462: (p_api_version => 1.0,
2463: p_return_status => l_return_status,
2464: p_msg_count => l_msg_count,
2465: p_msg_data => l_msg_data,

Line 2598: PSB_POSITION_ASSIGNMENTS_PVT.Delete_Row

2594:
2595: IF (PSB_HR_POPULATE_DATA_PVT.g_extract_method = 'REFRESH') THEN
2596: IF ( g_assign(l_assign_index).effective_start_date > p_effective_start_date ) THEN
2597:
2598: PSB_POSITION_ASSIGNMENTS_PVT.Delete_Row
2599: (p_api_version => 1.0,
2600: p_return_status => l_return_status,
2601: p_msg_count => l_msg_count,
2602: p_msg_data => l_msg_data,

Line 2609: PSB_POSITION_ASSIGNMENTS_PVT.Delete_Row

2605: END IF;
2606: ELSE
2607: /* End bug 4153562 */
2608:
2609: PSB_POSITION_ASSIGNMENTS_PVT.Delete_Row
2610: (p_api_version => 1.0,
2611: p_return_status => l_return_status,
2612: p_msg_count => l_msg_count,
2613: p_msg_data => l_msg_data,

Line 2768: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

2764: -- should process all the overlaps records - deleting all existing overlaps
2765:
2766: begin
2767:
2768: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
2769: (p_api_version => 1.0,
2770: p_return_status => l_return_status,
2771: p_msg_count => l_msg_count,
2772: p_msg_data => l_msg_data,

Line 6137: PSB_POSITION_ASSIGNMENTS_PVT.delete_row

6133: AND (NVL(past.effective_end_date, p_effective_start_date) >= p_effective_start_date)))
6134: )
6135: LOOP
6136:
6137: PSB_POSITION_ASSIGNMENTS_PVT.delete_row
6138: (p_api_version => 1.0,
6139: p_return_status => l_return_status,
6140: p_msg_count => l_msg_count,
6141: p_msg_data => l_msg_data,

Line 6162: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

6158: -- the first insert_row call create the worksheet specific record
6159: -- the second insert_row call create the extract specific record
6160: IF l_de_exists THEN
6161:
6162: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
6163: (p_api_version => 1.0,
6164: p_return_status => l_return_status,
6165: p_msg_count => l_msg_count,
6166: p_msg_data => l_msg_data,

Line 6197: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

6193: END IF;
6194:
6195: ELSE
6196:
6197: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
6198: (p_api_version => 1.0,
6199: p_return_status => l_return_status,
6200: p_msg_count => l_msg_count,
6201: p_msg_data => l_msg_data,

Line 6292: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

6288: IF l_matching_assmt <> TRUE THEN
6289:
6290: -- Bug 4545909. added the following IF clause
6291: IF l_de_exists THEN
6292: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
6293: (p_api_version => 1.0,
6294: p_return_status => l_return_status,
6295: p_msg_count => l_msg_count,
6296: p_msg_data => l_msg_data,

Line 6322: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

6318: -- p_modify_flag => p_modify_flag,
6319: p_modify_flag => 'Y', -- bug 5002080
6320: p_mode => p_mode);
6321: ELSE
6322: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
6323: (p_api_version => 1.0,
6324: p_return_status => l_return_status,
6325: p_msg_count => l_msg_count,
6326: p_msg_data => l_msg_data,