1178: */
1179: PROCEDURE CREATE_REQUIREMENTS
1180: (
1181: p_api_version_number IN NUMBER := 1.0
1182: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1183: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1184: , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1185: , x_requirement_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1186: , x_return_status OUT NOCOPY VARCHAR2
1179: PROCEDURE CREATE_REQUIREMENTS
1180: (
1181: p_api_version_number IN NUMBER := 1.0
1182: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1183: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1184: , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1185: , x_requirement_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1186: , x_return_status OUT NOCOPY VARCHAR2
1187: , x_msg_count OUT NOCOPY NUMBER
1230: */
1231: PROCEDURE UPDATE_REQUIREMENTS
1232: (
1233: p_api_version_number IN NUMBER := 1.0
1234: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1235: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1236: , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1237: , x_return_status OUT NOCOPY VARCHAR2
1238: , x_msg_count OUT NOCOPY NUMBER
1231: PROCEDURE UPDATE_REQUIREMENTS
1232: (
1233: p_api_version_number IN NUMBER := 1.0
1234: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1235: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1236: , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1237: , x_return_status OUT NOCOPY VARCHAR2
1238: , x_msg_count OUT NOCOPY NUMBER
1239: , x_msg_data OUT NOCOPY VARCHAR2
1281: */
1282: PROCEDURE DELETE_REQUIREMENTS
1283: (
1284: p_api_version_number IN NUMBER := 1.0
1285: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1286: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1287: , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1288: , x_return_status OUT NOCOPY VARCHAR2
1289: , x_msg_count OUT NOCOPY NUMBER
1282: PROCEDURE DELETE_REQUIREMENTS
1283: (
1284: p_api_version_number IN NUMBER := 1.0
1285: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1286: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1287: , p_requirement_in_tbl IN REQUIREMENT_IN_TBL_TYPE
1288: , x_return_status OUT NOCOPY VARCHAR2
1289: , x_msg_count OUT NOCOPY NUMBER
1290: , x_msg_data OUT NOCOPY VARCHAR2
1337: */
1338: PROCEDURE STAFF_REQUIREMENTS
1339: (
1340: p_api_version_number IN NUMBER := 1.0
1341: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1342: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1343: , p_staff_requirement_tbl IN STAFF_REQUIREMENT_TBL_TYPE
1344: , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1345: , x_return_status OUT NOCOPY VARCHAR2
1338: PROCEDURE STAFF_REQUIREMENTS
1339: (
1340: p_api_version_number IN NUMBER := 1.0
1341: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1342: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1343: , p_staff_requirement_tbl IN STAFF_REQUIREMENT_TBL_TYPE
1344: , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1345: , x_return_status OUT NOCOPY VARCHAR2
1346: , x_msg_count OUT NOCOPY NUMBER
1394: */
1395: PROCEDURE COPY_TEAM_ROLES
1396: (
1397: p_api_version_number IN NUMBER := 1.0
1398: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1399: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1400: , p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1401: , x_req_asgn_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1402: , x_return_status OUT NOCOPY VARCHAR2
1395: PROCEDURE COPY_TEAM_ROLES
1396: (
1397: p_api_version_number IN NUMBER := 1.0
1398: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1399: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1400: , p_req_asgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1401: , x_req_asgn_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1402: , x_return_status OUT NOCOPY VARCHAR2
1403: , x_msg_count OUT NOCOPY NUMBER
1451: */
1452: PROCEDURE CREATE_ASSIGNMENTS
1453: (
1454: p_api_version_number IN NUMBER := 1.0
1455: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1456: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1457: , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1458: , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1459: , x_return_status OUT NOCOPY VARCHAR2
1452: PROCEDURE CREATE_ASSIGNMENTS
1453: (
1454: p_api_version_number IN NUMBER := 1.0
1455: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1456: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1457: , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1458: , x_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1459: , x_return_status OUT NOCOPY VARCHAR2
1460: , x_msg_count OUT NOCOPY NUMBER
1503: */
1504: PROCEDURE UPDATE_ASSIGNMENTS
1505: (
1506: p_api_version_number IN NUMBER := 1.0
1507: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1508: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1509: , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1510: , x_return_status OUT NOCOPY VARCHAR2
1511: , x_msg_count OUT NOCOPY NUMBER
1504: PROCEDURE UPDATE_ASSIGNMENTS
1505: (
1506: p_api_version_number IN NUMBER := 1.0
1507: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1508: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1509: , p_assignment_in_tbl IN ASSIGNMENT_IN_TBL_TYPE
1510: , x_return_status OUT NOCOPY VARCHAR2
1511: , x_msg_count OUT NOCOPY NUMBER
1512: , x_msg_data OUT NOCOPY VARCHAR2
1604: */
1605: PROCEDURE SUBMIT_ASSIGNMENTS
1606: (
1607: p_api_version_number IN NUMBER := 1.0
1608: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1609: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1610: , p_submit_assignment_in_tbl IN SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1611: , x_return_status OUT NOCOPY VARCHAR2
1612: , x_msg_count OUT NOCOPY NUMBER
1605: PROCEDURE SUBMIT_ASSIGNMENTS
1606: (
1607: p_api_version_number IN NUMBER := 1.0
1608: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1609: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1610: , p_submit_assignment_in_tbl IN SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1611: , x_return_status OUT NOCOPY VARCHAR2
1612: , x_msg_count OUT NOCOPY NUMBER
1613: , x_msg_data OUT NOCOPY VARCHAR2
1820: * @rep:compatibility S
1821: */
1822: PROCEDURE CREATE_CANDIDATES
1823: (
1824: p_commit IN VARCHAR2 := FND_API.G_FALSE
1825: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1826: , p_api_version_number IN NUMBER := 1.0
1827: , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1828: , x_candidate_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1821: */
1822: PROCEDURE CREATE_CANDIDATES
1823: (
1824: p_commit IN VARCHAR2 := FND_API.G_FALSE
1825: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1826: , p_api_version_number IN NUMBER := 1.0
1827: , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1828: , x_candidate_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1829: , x_return_status OUT NOCOPY VARCHAR2
1872: * @rep:compatibility S
1873: */
1874: PROCEDURE UPDATE_CANDIDATES
1875: (
1876: p_commit IN VARCHAR2 := FND_API.G_FALSE
1877: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1878: , p_api_version_number IN NUMBER := 1.0
1879: , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1880: , x_return_status OUT NOCOPY VARCHAR2
1873: */
1874: PROCEDURE UPDATE_CANDIDATES
1875: (
1876: p_commit IN VARCHAR2 := FND_API.G_FALSE
1877: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1878: , p_api_version_number IN NUMBER := 1.0
1879: , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1880: , x_return_status OUT NOCOPY VARCHAR2
1881: , x_msg_count OUT NOCOPY NUMBER
1923: * @rep:compatibility S
1924: */
1925: PROCEDURE DELETE_CANDIDATES
1926: (
1927: p_commit IN VARCHAR2 := FND_API.G_FALSE
1928: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1929: , p_api_version_number IN NUMBER := 1.0
1930: , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1931: , x_return_status OUT NOCOPY VARCHAR2
1924: */
1925: PROCEDURE DELETE_CANDIDATES
1926: (
1927: p_commit IN VARCHAR2 := FND_API.G_FALSE
1928: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1929: , p_api_version_number IN NUMBER := 1.0
1930: , p_candidate_in_tbl IN CANDIDATE_IN_TBL_TYPE
1931: , x_return_status OUT NOCOPY VARCHAR2
1932: , x_msg_count OUT NOCOPY NUMBER
1980: * @rep:compatibility S
1981: */
1982: PROCEDURE CREATE_CANDIDATE_LOG
1983: (
1984: p_commit IN VARCHAR2 := FND_API.G_FALSE
1985: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1986: , p_api_version_number IN NUMBER := 1.0
1987: , p_candidate_log_tbl IN CANDIDATE_LOG_TBL_TYPE
1988: , x_candidate_review_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1981: */
1982: PROCEDURE CREATE_CANDIDATE_LOG
1983: (
1984: p_commit IN VARCHAR2 := FND_API.G_FALSE
1985: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1986: , p_api_version_number IN NUMBER := 1.0
1987: , p_candidate_log_tbl IN CANDIDATE_LOG_TBL_TYPE
1988: , x_candidate_review_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1989: , x_return_status OUT NOCOPY VARCHAR2