[Home] [Help]
1268: * Description: This procedure enables you to create project requirements.
1269: *
1270: * Parameters:
1271: * Parameter Name Null? Description
1272: * P_COMMIT NULL API standard (default = F)
1273: * P_INIT_MSG_LIST NULL API standard (default = T)
1274: * P_API_VERSION_NUMBER NOT NULL API standard
1275: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1276: * see the REQUIREMENT_IN_TBL_TYPE
1269: *
1270: * Parameters:
1271: * Parameter Name Null? Description
1272: * P_COMMIT NULL API standard (default = F)
1273: * P_INIT_MSG_LIST NULL API standard (default = T)
1274: * P_API_VERSION_NUMBER NOT NULL API standard
1275: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1276: * see the REQUIREMENT_IN_TBL_TYPE
1277: * datatype table.
1270: * Parameters:
1271: * Parameter Name Null? Description
1272: * P_COMMIT NULL API standard (default = F)
1273: * P_INIT_MSG_LIST NULL API standard (default = T)
1274: * P_API_VERSION_NUMBER NOT NULL API standard
1275: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1276: * see the REQUIREMENT_IN_TBL_TYPE
1277: * datatype table.
1278: * X_REQUIREMENT_ID_TBL N/A Table of requirement IDs created by
1288: * error exists
1289: */
1290: /*#
1291: * This is a public API to create one or more requirements for one or more projects
1292: * @param p_api_version_number API standard version number
1293: * @rep:paraminfo {@rep:required}
1294: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1295: * @param p_commit API standard (default = F): indicates if transaction will be committed
1296: * @param p_requirement_in_tbl Table of requirement records
1290: /*#
1291: * This is a public API to create one or more requirements for one or more projects
1292: * @param p_api_version_number API standard version number
1293: * @rep:paraminfo {@rep:required}
1294: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1295: * @param p_commit API standard (default = F): indicates if transaction will be committed
1296: * @param p_requirement_in_tbl Table of requirement records
1297: * @rep:paraminfo {@rep:required}
1298: * @param x_requirement_id_tbl Table of requirement IDs created by the API
1291: * This is a public API to create one or more requirements for one or more projects
1292: * @param p_api_version_number API standard version number
1293: * @rep:paraminfo {@rep:required}
1294: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1295: * @param p_commit API standard (default = F): indicates if transaction will be committed
1296: * @param p_requirement_in_tbl Table of requirement records
1297: * @rep:paraminfo {@rep:required}
1298: * @param x_requirement_id_tbl Table of requirement IDs created by the API
1299: * @rep:paraminfo {@rep:required}
1296: * @param p_requirement_in_tbl Table of requirement records
1297: * @rep:paraminfo {@rep:required}
1298: * @param x_requirement_id_tbl Table of requirement IDs created by the API
1299: * @rep:paraminfo {@rep:required}
1300: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1301: * @rep:paraminfo {@rep:required}
1302: * @param x_msg_count API standard: number of error messages
1303: * @rep:paraminfo {@rep:required}
1304: * @param x_msg_data API standard: error message
1298: * @param x_requirement_id_tbl Table of requirement IDs created by the API
1299: * @rep:paraminfo {@rep:required}
1300: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1301: * @rep:paraminfo {@rep:required}
1302: * @param x_msg_count API standard: number of error messages
1303: * @rep:paraminfo {@rep:required}
1304: * @param x_msg_data API standard: error message
1305: * @rep:paraminfo {@rep:required}
1306: * @rep:scope public
1300: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1301: * @rep:paraminfo {@rep:required}
1302: * @param x_msg_count API standard: number of error messages
1303: * @rep:paraminfo {@rep:required}
1304: * @param x_msg_data API standard: error message
1305: * @rep:paraminfo {@rep:required}
1306: * @rep:scope public
1307: * @rep:lifecycle active
1308: * @rep:displayname Create Requirements
1325: * Description: This procedure enables you to update project requirements.
1326: *
1327: * Parameters:
1328: * Parameter Name Null? Description
1329: * P_COMMIT NULL API standard (default = F)
1330: * P_INIT_MSG_LIST NULL API standard (default = T)
1331: * P_API_VERSION_NUMBER NOT NULL API standard
1332: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1333: * see the REQUIREMENT_IN_TBL_TYPE
1326: *
1327: * Parameters:
1328: * Parameter Name Null? Description
1329: * P_COMMIT NULL API standard (default = F)
1330: * P_INIT_MSG_LIST NULL API standard (default = T)
1331: * P_API_VERSION_NUMBER NOT NULL API standard
1332: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1333: * see the REQUIREMENT_IN_TBL_TYPE
1334: * datatype table.
1327: * Parameters:
1328: * Parameter Name Null? Description
1329: * P_COMMIT NULL API standard (default = F)
1330: * P_INIT_MSG_LIST NULL API standard (default = T)
1331: * P_API_VERSION_NUMBER NOT NULL API standard
1332: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1333: * see the REQUIREMENT_IN_TBL_TYPE
1334: * datatype table.
1335: * X_RETURN_STATUS N/A The return status of the API. Valid
1342: * error exists
1343: */
1344: /*#
1345: * This is a public API to update one or more requirements for one or more projects
1346: * @param p_api_version_number API standard version number
1347: * @rep:paraminfo {@rep:required}
1348: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1349: * @param p_commit API standard (default = F): indicates if transaction will be committed
1350: * @param p_requirement_in_tbl Table of requirement records
1344: /*#
1345: * This is a public API to update one or more requirements for one or more projects
1346: * @param p_api_version_number API standard version number
1347: * @rep:paraminfo {@rep:required}
1348: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1349: * @param p_commit API standard (default = F): indicates if transaction will be committed
1350: * @param p_requirement_in_tbl Table of requirement records
1351: * @rep:paraminfo {@rep:required}
1352: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1345: * This is a public API to update one or more requirements for one or more projects
1346: * @param p_api_version_number API standard version number
1347: * @rep:paraminfo {@rep:required}
1348: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1349: * @param p_commit API standard (default = F): indicates if transaction will be committed
1350: * @param p_requirement_in_tbl Table of requirement records
1351: * @rep:paraminfo {@rep:required}
1352: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1353: * @rep:paraminfo {@rep:required}
1348: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1349: * @param p_commit API standard (default = F): indicates if transaction will be committed
1350: * @param p_requirement_in_tbl Table of requirement records
1351: * @rep:paraminfo {@rep:required}
1352: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1353: * @rep:paraminfo {@rep:required}
1354: * @param x_msg_count API standard: number of error messages
1355: * @rep:paraminfo {@rep:required}
1356: * @param x_msg_data API standard: error message
1350: * @param p_requirement_in_tbl Table of requirement records
1351: * @rep:paraminfo {@rep:required}
1352: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1353: * @rep:paraminfo {@rep:required}
1354: * @param x_msg_count API standard: number of error messages
1355: * @rep:paraminfo {@rep:required}
1356: * @param x_msg_data API standard: error message
1357: * @rep:paraminfo {@rep:required}
1358: * @rep:scope public
1352: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1353: * @rep:paraminfo {@rep:required}
1354: * @param x_msg_count API standard: number of error messages
1355: * @rep:paraminfo {@rep:required}
1356: * @param x_msg_data API standard: error message
1357: * @rep:paraminfo {@rep:required}
1358: * @rep:scope public
1359: * @rep:lifecycle active
1360: * @rep:displayname Update Requirements
1376: * Description: This procedure enables you to delete project requirements.
1377: *
1378: * Parameters:
1379: * Parameter Name Null? Description
1380: * P_COMMIT NULL API standard (default = F)
1381: * P_INIT_MSG_LIST NULL API standard (default = T)
1382: * P_API_VERSION_NUMBER NOT NULL API standard
1383: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1384: * see the REQUIREMENT_IN_TBL_TYPE
1377: *
1378: * Parameters:
1379: * Parameter Name Null? Description
1380: * P_COMMIT NULL API standard (default = F)
1381: * P_INIT_MSG_LIST NULL API standard (default = T)
1382: * P_API_VERSION_NUMBER NOT NULL API standard
1383: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1384: * see the REQUIREMENT_IN_TBL_TYPE
1385: * datatype table.
1378: * Parameters:
1379: * Parameter Name Null? Description
1380: * P_COMMIT NULL API standard (default = F)
1381: * P_INIT_MSG_LIST NULL API standard (default = T)
1382: * P_API_VERSION_NUMBER NOT NULL API standard
1383: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1384: * see the REQUIREMENT_IN_TBL_TYPE
1385: * datatype table.
1386: * X_RETURN_STATUS N/A The return status of the API. Valid
1393: * error exists
1394: */
1395: /*#
1396: * This is a public API to delete one or more requirements for one or more projects
1397: * @param p_api_version_number API standard version number
1398: * @rep:paraminfo {@rep:required}
1399: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1400: * @param p_commit API standard (default = F): indicates if transaction will be committed
1401: * @param p_requirement_in_tbl Table of requirement records
1395: /*#
1396: * This is a public API to delete one or more requirements for one or more projects
1397: * @param p_api_version_number API standard version number
1398: * @rep:paraminfo {@rep:required}
1399: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1400: * @param p_commit API standard (default = F): indicates if transaction will be committed
1401: * @param p_requirement_in_tbl Table of requirement records
1402: * @rep:paraminfo {@rep:required}
1403: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1396: * This is a public API to delete one or more requirements for one or more projects
1397: * @param p_api_version_number API standard version number
1398: * @rep:paraminfo {@rep:required}
1399: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1400: * @param p_commit API standard (default = F): indicates if transaction will be committed
1401: * @param p_requirement_in_tbl Table of requirement records
1402: * @rep:paraminfo {@rep:required}
1403: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1404: * @rep:paraminfo {@rep:required}
1399: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1400: * @param p_commit API standard (default = F): indicates if transaction will be committed
1401: * @param p_requirement_in_tbl Table of requirement records
1402: * @rep:paraminfo {@rep:required}
1403: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1404: * @rep:paraminfo {@rep:required}
1405: * @param x_msg_count API standard: number of error messages
1406: * @rep:paraminfo {@rep:required}
1407: * @param x_msg_data API standard: error message
1401: * @param p_requirement_in_tbl Table of requirement records
1402: * @rep:paraminfo {@rep:required}
1403: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1404: * @rep:paraminfo {@rep:required}
1405: * @param x_msg_count API standard: number of error messages
1406: * @rep:paraminfo {@rep:required}
1407: * @param x_msg_data API standard: error message
1408: * @rep:paraminfo {@rep:required}
1409: * @rep:scope public
1403: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1404: * @rep:paraminfo {@rep:required}
1405: * @param x_msg_count API standard: number of error messages
1406: * @rep:paraminfo {@rep:required}
1407: * @param x_msg_data API standard: error message
1408: * @rep:paraminfo {@rep:required}
1409: * @rep:scope public
1410: * @rep:lifecycle active
1411: * @rep:displayname Delete Requirements
1427: * Description: This procedure enables you to staff requirements.
1428: *
1429: * Parameters:
1430: * Parameter Name Null? Description
1431: * P_COMMIT NULL API standard (default = F)
1432: * P_INIT_MSG_LIST NULL API standard (default = T)
1433: * P_API_VERSION_NUMBER NOT NULL API standard
1434: * P_STAFF_REQUIREMENT_TBL NOT NULL Table of staffing information for each
1435: * requirement. Please see the
1428: *
1429: * Parameters:
1430: * Parameter Name Null? Description
1431: * P_COMMIT NULL API standard (default = F)
1432: * P_INIT_MSG_LIST NULL API standard (default = T)
1433: * P_API_VERSION_NUMBER NOT NULL API standard
1434: * P_STAFF_REQUIREMENT_TBL NOT NULL Table of staffing information for each
1435: * requirement. Please see the
1436: * Staff_requirement_tbl_TYPE datatype
1429: * Parameters:
1430: * Parameter Name Null? Description
1431: * P_COMMIT NULL API standard (default = F)
1432: * P_INIT_MSG_LIST NULL API standard (default = T)
1433: * P_API_VERSION_NUMBER NOT NULL API standard
1434: * P_STAFF_REQUIREMENT_TBL NOT NULL Table of staffing information for each
1435: * requirement. Please see the
1436: * Staff_requirement_tbl_TYPE datatype
1437: * table.
1447: * error exists
1448: */
1449: /*#
1450: * This is a public API to staff one or more requirements for one or more projects
1451: * @param p_api_version_number API standard version number
1452: * @rep:paraminfo {@rep:required}
1453: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1454: * @param p_commit API standard (default = F): indicates if transaction will be committed
1455: * @param p_staff_requirement_tbl Table of staffing information for each requirement
1449: /*#
1450: * This is a public API to staff one or more requirements for one or more projects
1451: * @param p_api_version_number API standard version number
1452: * @rep:paraminfo {@rep:required}
1453: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1454: * @param p_commit API standard (default = F): indicates if transaction will be committed
1455: * @param p_staff_requirement_tbl Table of staffing information for each requirement
1456: * @rep:paraminfo {@rep:required}
1457: * @param x_assignment_id_tbl Table of staffed assignment IDs.
1450: * This is a public API to staff one or more requirements for one or more projects
1451: * @param p_api_version_number API standard version number
1452: * @rep:paraminfo {@rep:required}
1453: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1454: * @param p_commit API standard (default = F): indicates if transaction will be committed
1455: * @param p_staff_requirement_tbl Table of staffing information for each requirement
1456: * @rep:paraminfo {@rep:required}
1457: * @param x_assignment_id_tbl Table of staffed assignment IDs.
1458: * @rep:paraminfo {@rep:required}
1455: * @param p_staff_requirement_tbl Table of staffing information for each requirement
1456: * @rep:paraminfo {@rep:required}
1457: * @param x_assignment_id_tbl Table of staffed assignment IDs.
1458: * @rep:paraminfo {@rep:required}
1459: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1460: * @rep:paraminfo {@rep:required}
1461: * @param x_msg_count API standard: number of error messages
1462: * @rep:paraminfo {@rep:required}
1463: * @param x_msg_data API standard: error message
1457: * @param x_assignment_id_tbl Table of staffed assignment IDs.
1458: * @rep:paraminfo {@rep:required}
1459: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1460: * @rep:paraminfo {@rep:required}
1461: * @param x_msg_count API standard: number of error messages
1462: * @rep:paraminfo {@rep:required}
1463: * @param x_msg_data API standard: error message
1464: * @rep:paraminfo {@rep:required}
1465: * @rep:scope public
1459: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1460: * @rep:paraminfo {@rep:required}
1461: * @param x_msg_count API standard: number of error messages
1462: * @rep:paraminfo {@rep:required}
1463: * @param x_msg_data API standard: error message
1464: * @rep:paraminfo {@rep:required}
1465: * @rep:scope public
1466: * @rep:lifecycle active
1467: * @rep:displayname Staff Requirements
1485: * project assignments or requirements.
1486: *
1487: * Parameters:
1488: * Parameter Name Null? Description
1489: * P_COMMIT NULL API standard (default = F)
1490: * P_INIT_MSG_LIST NULL API standard (default = T)
1491: * P_API_VERSION_NUMBER NOT NULL API standard
1492: * P_REQ_ASGN_ID_TBL NOT NULL Table of requirement or assignment IDs.
1493: * Reference: pa_project_assignments.assignment_id
1486: *
1487: * Parameters:
1488: * Parameter Name Null? Description
1489: * P_COMMIT NULL API standard (default = F)
1490: * P_INIT_MSG_LIST NULL API standard (default = T)
1491: * P_API_VERSION_NUMBER NOT NULL API standard
1492: * P_REQ_ASGN_ID_TBL NOT NULL Table of requirement or assignment IDs.
1493: * Reference: pa_project_assignments.assignment_id
1494: * X_REQ_ASGN_ID_TBL N/A Table of requirement or assignment IDs
1487: * Parameters:
1488: * Parameter Name Null? Description
1489: * P_COMMIT NULL API standard (default = F)
1490: * P_INIT_MSG_LIST NULL API standard (default = T)
1491: * P_API_VERSION_NUMBER NOT NULL API standard
1492: * P_REQ_ASGN_ID_TBL NOT NULL Table of requirement or assignment IDs.
1493: * Reference: pa_project_assignments.assignment_id
1494: * X_REQ_ASGN_ID_TBL N/A Table of requirement or assignment IDs
1495: * created by the API.
1504: * error exists
1505: */
1506: /*#
1507: * This is a public API to copy one or more team roles
1508: * @param p_api_version_number API standard version number
1509: * @rep:paraminfo {@rep:required}
1510: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1511: * @param p_commit API standard (default = F): indicates if transaction will be committed
1512: * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1506: /*#
1507: * This is a public API to copy one or more team roles
1508: * @param p_api_version_number API standard version number
1509: * @rep:paraminfo {@rep:required}
1510: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1511: * @param p_commit API standard (default = F): indicates if transaction will be committed
1512: * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1513: * @rep:paraminfo {@rep:required}
1514: * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1507: * This is a public API to copy one or more team roles
1508: * @param p_api_version_number API standard version number
1509: * @rep:paraminfo {@rep:required}
1510: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1511: * @param p_commit API standard (default = F): indicates if transaction will be committed
1512: * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1513: * @rep:paraminfo {@rep:required}
1514: * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1515: * @rep:paraminfo {@rep:required}
1512: * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1513: * @rep:paraminfo {@rep:required}
1514: * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1515: * @rep:paraminfo {@rep:required}
1516: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1517: * @rep:paraminfo {@rep:required}
1518: * @param x_msg_count API standard: number of error messages
1519: * @rep:paraminfo {@rep:required}
1520: * @param x_msg_data API standard: error message
1514: * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1515: * @rep:paraminfo {@rep:required}
1516: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1517: * @rep:paraminfo {@rep:required}
1518: * @param x_msg_count API standard: number of error messages
1519: * @rep:paraminfo {@rep:required}
1520: * @param x_msg_data API standard: error message
1521: * @rep:paraminfo {@rep:required}
1522: * @rep:scope public
1516: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1517: * @rep:paraminfo {@rep:required}
1518: * @param x_msg_count API standard: number of error messages
1519: * @rep:paraminfo {@rep:required}
1520: * @param x_msg_data API standard: error message
1521: * @rep:paraminfo {@rep:required}
1522: * @rep:scope public
1523: * @rep:lifecycle active
1524: * @rep:displayname Copy Team Roles
1541: * Description: This procedure enables you to create project assignments.
1542: *
1543: * Parameters:
1544: * Parameter Name Null? Description
1545: * P_COMMIT NULL API standard (default = F)
1546: * P_INIT_MSG_LIST NULL API standard (default = T)
1547: * P_API_VERSION_NUMBER NOT NULL API standard
1548: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1549: * see the ASSIGNMENT_IN_TBL_TYPE
1542: *
1543: * Parameters:
1544: * Parameter Name Null? Description
1545: * P_COMMIT NULL API standard (default = F)
1546: * P_INIT_MSG_LIST NULL API standard (default = T)
1547: * P_API_VERSION_NUMBER NOT NULL API standard
1548: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1549: * see the ASSIGNMENT_IN_TBL_TYPE
1550: * datatype table.
1543: * Parameters:
1544: * Parameter Name Null? Description
1545: * P_COMMIT NULL API standard (default = F)
1546: * P_INIT_MSG_LIST NULL API standard (default = T)
1547: * P_API_VERSION_NUMBER NOT NULL API standard
1548: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1549: * see the ASSIGNMENT_IN_TBL_TYPE
1550: * datatype table.
1551: * X_ASSIGNMENT_ID_TBL N/A Table to store assignment IDs created
1561: * error exists
1562: */
1563: /*#
1564: * This is a public API to create one or more assignments for one or more projects
1565: * @param p_api_version_number API standard version number
1566: * @rep:paraminfo {@rep:required}
1567: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1568: * @param p_commit API standard (default = F): indicates if transaction will be committed
1569: * @param p_assignment_in_tbl Table of assignment records
1563: /*#
1564: * This is a public API to create one or more assignments for one or more projects
1565: * @param p_api_version_number API standard version number
1566: * @rep:paraminfo {@rep:required}
1567: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1568: * @param p_commit API standard (default = F): indicates if transaction will be committed
1569: * @param p_assignment_in_tbl Table of assignment records
1570: * @rep:paraminfo {@rep:required}
1571: * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1564: * This is a public API to create one or more assignments for one or more projects
1565: * @param p_api_version_number API standard version number
1566: * @rep:paraminfo {@rep:required}
1567: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1568: * @param p_commit API standard (default = F): indicates if transaction will be committed
1569: * @param p_assignment_in_tbl Table of assignment records
1570: * @rep:paraminfo {@rep:required}
1571: * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1572: * @rep:paraminfo {@rep:required}
1569: * @param p_assignment_in_tbl Table of assignment records
1570: * @rep:paraminfo {@rep:required}
1571: * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1572: * @rep:paraminfo {@rep:required}
1573: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1574: * @rep:paraminfo {@rep:required}
1575: * @param x_msg_count API standard: number of error messages
1576: * @rep:paraminfo {@rep:required}
1577: * @param x_msg_data API standard: error message
1571: * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1572: * @rep:paraminfo {@rep:required}
1573: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1574: * @rep:paraminfo {@rep:required}
1575: * @param x_msg_count API standard: number of error messages
1576: * @rep:paraminfo {@rep:required}
1577: * @param x_msg_data API standard: error message
1578: * @rep:paraminfo {@rep:required}
1579: * @rep:scope public
1573: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1574: * @rep:paraminfo {@rep:required}
1575: * @param x_msg_count API standard: number of error messages
1576: * @rep:paraminfo {@rep:required}
1577: * @param x_msg_data API standard: error message
1578: * @rep:paraminfo {@rep:required}
1579: * @rep:scope public
1580: * @rep:lifecycle active
1581: * @rep:displayname Create Assignments
1598: * Description: This procedure enables you to update project assignments.
1599: *
1600: * Parameters:
1601: * Parameter Name Null? Description
1602: * P_COMMIT NULL API standard (default = F)
1603: * P_INIT_MSG_LIST NULL API standard (default = T)
1604: * P_API_VERSION_NUMBER NOT NULL API standard
1605: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1606: * see the ASSIGNMENT_IN_TBL_TYPE
1599: *
1600: * Parameters:
1601: * Parameter Name Null? Description
1602: * P_COMMIT NULL API standard (default = F)
1603: * P_INIT_MSG_LIST NULL API standard (default = T)
1604: * P_API_VERSION_NUMBER NOT NULL API standard
1605: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1606: * see the ASSIGNMENT_IN_TBL_TYPE
1607: * datatype table.
1600: * Parameters:
1601: * Parameter Name Null? Description
1602: * P_COMMIT NULL API standard (default = F)
1603: * P_INIT_MSG_LIST NULL API standard (default = T)
1604: * P_API_VERSION_NUMBER NOT NULL API standard
1605: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1606: * see the ASSIGNMENT_IN_TBL_TYPE
1607: * datatype table.
1608: * X_RETURN_STATUS N/A The return status of the API. Valid
1615: * error exists
1616: */
1617: /*#
1618: * This is a public API to update one or more assignments for one or more projects.
1619: * @param p_api_version_number API standard version number
1620: * @rep:paraminfo {@rep:required}
1621: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1622: * @param p_commit API standard (default = F): indicates if transaction will be committed
1623: * @param p_assignment_in_tbl Table of assignment records
1617: /*#
1618: * This is a public API to update one or more assignments for one or more projects.
1619: * @param p_api_version_number API standard version number
1620: * @rep:paraminfo {@rep:required}
1621: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1622: * @param p_commit API standard (default = F): indicates if transaction will be committed
1623: * @param p_assignment_in_tbl Table of assignment records
1624: * @rep:paraminfo {@rep:required}
1625: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1618: * This is a public API to update one or more assignments for one or more projects.
1619: * @param p_api_version_number API standard version number
1620: * @rep:paraminfo {@rep:required}
1621: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1622: * @param p_commit API standard (default = F): indicates if transaction will be committed
1623: * @param p_assignment_in_tbl Table of assignment records
1624: * @rep:paraminfo {@rep:required}
1625: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1626: * @rep:paraminfo {@rep:required}
1621: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1622: * @param p_commit API standard (default = F): indicates if transaction will be committed
1623: * @param p_assignment_in_tbl Table of assignment records
1624: * @rep:paraminfo {@rep:required}
1625: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1626: * @rep:paraminfo {@rep:required}
1627: * @param x_msg_count API standard: number of error messages
1628: * @rep:paraminfo {@rep:required}
1629: * @param x_msg_data API standard: error message
1623: * @param p_assignment_in_tbl Table of assignment records
1624: * @rep:paraminfo {@rep:required}
1625: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1626: * @rep:paraminfo {@rep:required}
1627: * @param x_msg_count API standard: number of error messages
1628: * @rep:paraminfo {@rep:required}
1629: * @param x_msg_data API standard: error message
1630: * @rep:paraminfo {@rep:required}
1631: * @rep:scope public
1625: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1626: * @rep:paraminfo {@rep:required}
1627: * @param x_msg_count API standard: number of error messages
1628: * @rep:paraminfo {@rep:required}
1629: * @param x_msg_data API standard: error message
1630: * @rep:paraminfo {@rep:required}
1631: * @rep:scope public
1632: * @rep:lifecycle active
1633: * @rep:displayname Update Assignments
1649: * Description: This procedure enables you to delete project assignments.
1650: *
1651: * Parameters:
1652: * Parameter Name Null? Description
1653: * P_COMMIT NULL API standard (default = F)
1654: * P_INIT_MSG_LIST NULL API standard (default = T)
1655: * P_API_VERSION_NUMBER NOT NULL API standard
1656: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1657: * see the ASSIGNMENT_IN_TBL_TYPE
1650: *
1651: * Parameters:
1652: * Parameter Name Null? Description
1653: * P_COMMIT NULL API standard (default = F)
1654: * P_INIT_MSG_LIST NULL API standard (default = T)
1655: * P_API_VERSION_NUMBER NOT NULL API standard
1656: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1657: * see the ASSIGNMENT_IN_TBL_TYPE
1658: * datatype table.
1651: * Parameters:
1652: * Parameter Name Null? Description
1653: * P_COMMIT NULL API standard (default = F)
1654: * P_INIT_MSG_LIST NULL API standard (default = T)
1655: * P_API_VERSION_NUMBER NOT NULL API standard
1656: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1657: * see the ASSIGNMENT_IN_TBL_TYPE
1658: * datatype table.
1659: * X_RETURN_STATUS N/A The return status of the API. Valid
1666: * error exists
1667: */
1668: /*#
1669: * This is a public API to Delete one or more assignments for one or more projects.
1670: * @param p_api_version_number API standard version number
1671: * @rep:paraminfo {@rep:required}
1672: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1673: * @param p_commit API standard (default = F): indicates if transaction will be committed
1674: * @param p_assignment_in_tbl Table of assignment records
1668: /*#
1669: * This is a public API to Delete one or more assignments for one or more projects.
1670: * @param p_api_version_number API standard version number
1671: * @rep:paraminfo {@rep:required}
1672: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1673: * @param p_commit API standard (default = F): indicates if transaction will be committed
1674: * @param p_assignment_in_tbl Table of assignment records
1675: * @rep:paraminfo {@rep:required}
1676: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1669: * This is a public API to Delete one or more assignments for one or more projects.
1670: * @param p_api_version_number API standard version number
1671: * @rep:paraminfo {@rep:required}
1672: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1673: * @param p_commit API standard (default = F): indicates if transaction will be committed
1674: * @param p_assignment_in_tbl Table of assignment records
1675: * @rep:paraminfo {@rep:required}
1676: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1677: * @rep:paraminfo {@rep:required}
1672: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1673: * @param p_commit API standard (default = F): indicates if transaction will be committed
1674: * @param p_assignment_in_tbl Table of assignment records
1675: * @rep:paraminfo {@rep:required}
1676: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1677: * @rep:paraminfo {@rep:required}
1678: * @param x_msg_count API standard: number of error messages
1679: * @rep:paraminfo {@rep:required}
1680: * @param x_msg_data API standard: error message
1674: * @param p_assignment_in_tbl Table of assignment records
1675: * @rep:paraminfo {@rep:required}
1676: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1677: * @rep:paraminfo {@rep:required}
1678: * @param x_msg_count API standard: number of error messages
1679: * @rep:paraminfo {@rep:required}
1680: * @param x_msg_data API standard: error message
1681: * @rep:paraminfo {@rep:required}
1682: * @rep:scope public
1676: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1677: * @rep:paraminfo {@rep:required}
1678: * @param x_msg_count API standard: number of error messages
1679: * @rep:paraminfo {@rep:required}
1680: * @param x_msg_data API standard: error message
1681: * @rep:paraminfo {@rep:required}
1682: * @rep:scope public
1683: * @rep:lifecycle active
1684: * @rep:displayname Delete Assignments
1699: * assignments.
1700: *
1701: * Parameters:
1702: * Parameter Name Null? Description
1703: * P_COMMIT NULL API standard (default = F)
1704: * P_INIT_MSG_LIST NULL API standard (default = T)
1705: * P_API_VERSION_NUMBER NOT NULL API standard
1706: * P_SUBMIT_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1707: * see the SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1700: *
1701: * Parameters:
1702: * Parameter Name Null? Description
1703: * P_COMMIT NULL API standard (default = F)
1704: * P_INIT_MSG_LIST NULL API standard (default = T)
1705: * P_API_VERSION_NUMBER NOT NULL API standard
1706: * P_SUBMIT_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1707: * see the SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1708: * datatype table.
1701: * Parameters:
1702: * Parameter Name Null? Description
1703: * P_COMMIT NULL API standard (default = F)
1704: * P_INIT_MSG_LIST NULL API standard (default = T)
1705: * P_API_VERSION_NUMBER NOT NULL API standard
1706: * P_SUBMIT_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1707: * see the SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1708: * datatype table.
1709: * X_RETURN_STATUS N/A The return status of the API. Valid
1716: * error exists
1717: */
1718: /*#
1719: * This is a public API to submit/approve one or more assignments for one or more projects.
1720: * @param p_api_version_number API standard version number
1721: * @rep:paraminfo {@rep:required}
1722: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1723: * @param p_commit API standard (default = F): indicates if transaction will be committed
1724: * @param p_submit_assignment_in_tbl Table of assignment records
1718: /*#
1719: * This is a public API to submit/approve one or more assignments for one or more projects.
1720: * @param p_api_version_number API standard version number
1721: * @rep:paraminfo {@rep:required}
1722: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1723: * @param p_commit API standard (default = F): indicates if transaction will be committed
1724: * @param p_submit_assignment_in_tbl Table of assignment records
1725: * @rep:paraminfo {@rep:required}
1726: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1719: * This is a public API to submit/approve one or more assignments for one or more projects.
1720: * @param p_api_version_number API standard version number
1721: * @rep:paraminfo {@rep:required}
1722: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1723: * @param p_commit API standard (default = F): indicates if transaction will be committed
1724: * @param p_submit_assignment_in_tbl Table of assignment records
1725: * @rep:paraminfo {@rep:required}
1726: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1727: * @rep:paraminfo {@rep:required}
1722: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1723: * @param p_commit API standard (default = F): indicates if transaction will be committed
1724: * @param p_submit_assignment_in_tbl Table of assignment records
1725: * @rep:paraminfo {@rep:required}
1726: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1727: * @rep:paraminfo {@rep:required}
1728: * @param x_msg_count API standard: number of error messages
1729: * @rep:paraminfo {@rep:required}
1730: * @param x_msg_data API standard: error message
1724: * @param p_submit_assignment_in_tbl Table of assignment records
1725: * @rep:paraminfo {@rep:required}
1726: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1727: * @rep:paraminfo {@rep:required}
1728: * @param x_msg_count API standard: number of error messages
1729: * @rep:paraminfo {@rep:required}
1730: * @param x_msg_data API standard: error message
1731: * @rep:paraminfo {@rep:required}
1732: * @rep:scope public
1726: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1727: * @rep:paraminfo {@rep:required}
1728: * @param x_msg_count API standard: number of error messages
1729: * @rep:paraminfo {@rep:required}
1730: * @param x_msg_data API standard: error message
1731: * @rep:paraminfo {@rep:required}
1732: * @rep:scope public
1733: * @rep:lifecycle active
1734: * @rep:displayname Submit Assignments
1750: * Description: This procedure enables you to create competences for
1751: * project requirements.
1752: * Parameters:
1753: * Parameter Name Null? Description
1754: * P_COMMIT NULL API standard (default = F)
1755: * P_INIT_MSG_LIST NULL API standard (default = T)
1756: * P_API_VERSION_NUMBER NOT NULL API standard
1757: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1758: * see the COMPETENCE_IN_TBL_TYPE
1751: * project requirements.
1752: * Parameters:
1753: * Parameter Name Null? Description
1754: * P_COMMIT NULL API standard (default = F)
1755: * P_INIT_MSG_LIST NULL API standard (default = T)
1756: * P_API_VERSION_NUMBER NOT NULL API standard
1757: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1758: * see the COMPETENCE_IN_TBL_TYPE
1759: * datatype table.
1752: * Parameters:
1753: * Parameter Name Null? Description
1754: * P_COMMIT NULL API standard (default = F)
1755: * P_INIT_MSG_LIST NULL API standard (default = T)
1756: * P_API_VERSION_NUMBER NOT NULL API standard
1757: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1758: * see the COMPETENCE_IN_TBL_TYPE
1759: * datatype table.
1760: * X_COMPETENCE_ELEMENT_ID_TBL N/A Table to store the competence element
1770: * error exists
1771: */
1772: /*#
1773: * This is a public API to create one or more competences for one or more project requirements.
1774: * @param p_api_version_number API standard version number
1775: * @rep:paraminfo {@rep:required}
1776: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1777: * @param p_commit API standard (default = F): indicates if transaction will be committed
1778: * @param p_competence_in_tbl Table of competence records
1772: /*#
1773: * This is a public API to create one or more competences for one or more project requirements.
1774: * @param p_api_version_number API standard version number
1775: * @rep:paraminfo {@rep:required}
1776: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1777: * @param p_commit API standard (default = F): indicates if transaction will be committed
1778: * @param p_competence_in_tbl Table of competence records
1779: * @rep:paraminfo {@rep:required}
1780: * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1773: * This is a public API to create one or more competences for one or more project requirements.
1774: * @param p_api_version_number API standard version number
1775: * @rep:paraminfo {@rep:required}
1776: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1777: * @param p_commit API standard (default = F): indicates if transaction will be committed
1778: * @param p_competence_in_tbl Table of competence records
1779: * @rep:paraminfo {@rep:required}
1780: * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1781: * @rep:paraminfo {@rep:required}
1778: * @param p_competence_in_tbl Table of competence records
1779: * @rep:paraminfo {@rep:required}
1780: * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1781: * @rep:paraminfo {@rep:required}
1782: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1783: * @rep:paraminfo {@rep:required}
1784: * @param x_msg_count API standard: number of error messages
1785: * @rep:paraminfo {@rep:required}
1786: * @param x_msg_data API standard: error message
1780: * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1781: * @rep:paraminfo {@rep:required}
1782: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1783: * @rep:paraminfo {@rep:required}
1784: * @param x_msg_count API standard: number of error messages
1785: * @rep:paraminfo {@rep:required}
1786: * @param x_msg_data API standard: error message
1787: * @rep:paraminfo {@rep:required}
1788: * @rep:scope public
1782: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1783: * @rep:paraminfo {@rep:required}
1784: * @param x_msg_count API standard: number of error messages
1785: * @rep:paraminfo {@rep:required}
1786: * @param x_msg_data API standard: error message
1787: * @rep:paraminfo {@rep:required}
1788: * @rep:scope public
1789: * @rep:lifecycle active
1790: * @rep:displayname Create Requirement Competence
1807: * Description: This procedure enables you to update competences for
1808: * project requirements.
1809: * Parameters:
1810: * Parameter Name Null? Description
1811: * P_COMMIT NULL API standard (default = F)
1812: * P_INIT_MSG_LIST NULL API standard (default = T)
1813: * P_API_VERSION_NUMBER NOT NULL API standard
1814: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1815: * see the COMPETENCE_IN_TBL_TYPE
1808: * project requirements.
1809: * Parameters:
1810: * Parameter Name Null? Description
1811: * P_COMMIT NULL API standard (default = F)
1812: * P_INIT_MSG_LIST NULL API standard (default = T)
1813: * P_API_VERSION_NUMBER NOT NULL API standard
1814: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1815: * see the COMPETENCE_IN_TBL_TYPE
1816: * datatype table.
1809: * Parameters:
1810: * Parameter Name Null? Description
1811: * P_COMMIT NULL API standard (default = F)
1812: * P_INIT_MSG_LIST NULL API standard (default = T)
1813: * P_API_VERSION_NUMBER NOT NULL API standard
1814: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1815: * see the COMPETENCE_IN_TBL_TYPE
1816: * datatype table.
1817: * X_RETURN_STATUS N/A The return status of the API. Valid
1824: * error exists
1825: */
1826: /*#
1827: * This is a public API to update one or more competences for one or more project requirements
1828: * @param p_api_version_number API standard version number
1829: * @rep:paraminfo {@rep:required}
1830: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1831: * @param p_commit API standard (default = F): indicates if transaction will be committed
1832: * @param p_competence_in_tbl Table of competence records
1826: /*#
1827: * This is a public API to update one or more competences for one or more project requirements
1828: * @param p_api_version_number API standard version number
1829: * @rep:paraminfo {@rep:required}
1830: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1831: * @param p_commit API standard (default = F): indicates if transaction will be committed
1832: * @param p_competence_in_tbl Table of competence records
1833: * @rep:paraminfo {@rep:required}
1834: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1827: * This is a public API to update one or more competences for one or more project requirements
1828: * @param p_api_version_number API standard version number
1829: * @rep:paraminfo {@rep:required}
1830: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1831: * @param p_commit API standard (default = F): indicates if transaction will be committed
1832: * @param p_competence_in_tbl Table of competence records
1833: * @rep:paraminfo {@rep:required}
1834: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1835: * @rep:paraminfo {@rep:required}
1830: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1831: * @param p_commit API standard (default = F): indicates if transaction will be committed
1832: * @param p_competence_in_tbl Table of competence records
1833: * @rep:paraminfo {@rep:required}
1834: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1835: * @rep:paraminfo {@rep:required}
1836: * @param x_msg_count API standard: number of error messages
1837: * @rep:paraminfo {@rep:required}
1838: * @param x_msg_data API standard: error message
1832: * @param p_competence_in_tbl Table of competence records
1833: * @rep:paraminfo {@rep:required}
1834: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1835: * @rep:paraminfo {@rep:required}
1836: * @param x_msg_count API standard: number of error messages
1837: * @rep:paraminfo {@rep:required}
1838: * @param x_msg_data API standard: error message
1839: * @rep:paraminfo {@rep:required}
1840: * @rep:scope public
1834: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1835: * @rep:paraminfo {@rep:required}
1836: * @param x_msg_count API standard: number of error messages
1837: * @rep:paraminfo {@rep:required}
1838: * @param x_msg_data API standard: error message
1839: * @rep:paraminfo {@rep:required}
1840: * @rep:scope public
1841: * @rep:lifecycle active
1842: * @rep:displayname Update Requirement Competence
1859: * Description: This procedure enables you to delete competences for
1860: * project requirements.
1861: * Parameters:
1862: * Parameter Name Null? Description
1863: * P_COMMIT NULL API standard (default = F)
1864: * P_INIT_MSG_LIST NULL API standard (default = T)
1865: * P_API_VERSION_NUMBER NOT NULL API standard
1866: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1867: * see the COMPETENCE_IN_TBL_TYPE
1860: * project requirements.
1861: * Parameters:
1862: * Parameter Name Null? Description
1863: * P_COMMIT NULL API standard (default = F)
1864: * P_INIT_MSG_LIST NULL API standard (default = T)
1865: * P_API_VERSION_NUMBER NOT NULL API standard
1866: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1867: * see the COMPETENCE_IN_TBL_TYPE
1868: * datatype table.
1861: * Parameters:
1862: * Parameter Name Null? Description
1863: * P_COMMIT NULL API standard (default = F)
1864: * P_INIT_MSG_LIST NULL API standard (default = T)
1865: * P_API_VERSION_NUMBER NOT NULL API standard
1866: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1867: * see the COMPETENCE_IN_TBL_TYPE
1868: * datatype table.
1869: * X_RETURN_STATUS N/A The return status of the API. Valid
1876: * error exists
1877: */
1878: /*#
1879: * This is a public API to delete one or more competences for one or more project requirements.
1880: * @param p_api_version_number API standard version number
1881: * @rep:paraminfo {@rep:required}
1882: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1883: * @param p_commit API standard (default = F): indicates if transaction will be committed
1884: * @param p_competence_in_tbl Table of competence records
1878: /*#
1879: * This is a public API to delete one or more competences for one or more project requirements.
1880: * @param p_api_version_number API standard version number
1881: * @rep:paraminfo {@rep:required}
1882: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1883: * @param p_commit API standard (default = F): indicates if transaction will be committed
1884: * @param p_competence_in_tbl Table of competence records
1885: * @rep:paraminfo {@rep:required}
1886: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1879: * This is a public API to delete one or more competences for one or more project requirements.
1880: * @param p_api_version_number API standard version number
1881: * @rep:paraminfo {@rep:required}
1882: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1883: * @param p_commit API standard (default = F): indicates if transaction will be committed
1884: * @param p_competence_in_tbl Table of competence records
1885: * @rep:paraminfo {@rep:required}
1886: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1887: * @rep:paraminfo {@rep:required}
1882: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1883: * @param p_commit API standard (default = F): indicates if transaction will be committed
1884: * @param p_competence_in_tbl Table of competence records
1885: * @rep:paraminfo {@rep:required}
1886: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1887: * @rep:paraminfo {@rep:required}
1888: * @param x_msg_count API standard: number of error messages
1889: * @rep:paraminfo {@rep:required}
1890: * @param x_msg_data API standard: error message
1884: * @param p_competence_in_tbl Table of competence records
1885: * @rep:paraminfo {@rep:required}
1886: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1887: * @rep:paraminfo {@rep:required}
1888: * @param x_msg_count API standard: number of error messages
1889: * @rep:paraminfo {@rep:required}
1890: * @param x_msg_data API standard: error message
1891: * @rep:paraminfo {@rep:required}
1892: * @rep:scope public
1886: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1887: * @rep:paraminfo {@rep:required}
1888: * @param x_msg_count API standard: number of error messages
1889: * @rep:paraminfo {@rep:required}
1890: * @param x_msg_data API standard: error message
1891: * @rep:paraminfo {@rep:required}
1892: * @rep:scope public
1893: * @rep:lifecycle active
1894: * @rep:displayname Delete Requirement Competence
1912: * Description: This procedure enables you to nominate candidates for
1913: * project requirements.
1914: * Parameters:
1915: * Parameter Name Null? Description
1916: * P_COMMIT NULL API standard (default = F)
1917: * P_INIT_MSG_LIST NULL API standard (default = T)
1918: * P_API_VERSION_NUMBER NOT NULL API standard
1919: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1920: * the CANDIDATE_IN_TBL_TYPE datatype table.
1913: * project requirements.
1914: * Parameters:
1915: * Parameter Name Null? Description
1916: * P_COMMIT NULL API standard (default = F)
1917: * P_INIT_MSG_LIST NULL API standard (default = T)
1918: * P_API_VERSION_NUMBER NOT NULL API standard
1919: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1920: * the CANDIDATE_IN_TBL_TYPE datatype table.
1921: * X_CANDIDATE_ID_TBL N/A Table to store the candidate IDs
1914: * Parameters:
1915: * Parameter Name Null? Description
1916: * P_COMMIT NULL API standard (default = F)
1917: * P_INIT_MSG_LIST NULL API standard (default = T)
1918: * P_API_VERSION_NUMBER NOT NULL API standard
1919: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1920: * the CANDIDATE_IN_TBL_TYPE datatype table.
1921: * X_CANDIDATE_ID_TBL N/A Table to store the candidate IDs
1922: * created by the API.
1931: * error exists
1932: */
1933: /*#
1934: * This is a public API to create/nominate one or more candidates for project requirements
1935: * @param p_api_version_number API standard version number
1936: * @rep:paraminfo {@rep:required}
1937: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1938: * @param p_commit API standard (default = F): indicates if transaction will be committed
1939: * @param p_candidate_in_tbl Table of candidate records
1933: /*#
1934: * This is a public API to create/nominate one or more candidates for project requirements
1935: * @param p_api_version_number API standard version number
1936: * @rep:paraminfo {@rep:required}
1937: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1938: * @param p_commit API standard (default = F): indicates if transaction will be committed
1939: * @param p_candidate_in_tbl Table of candidate records
1940: * @rep:paraminfo {@rep:required}
1941: * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1934: * This is a public API to create/nominate one or more candidates for project requirements
1935: * @param p_api_version_number API standard version number
1936: * @rep:paraminfo {@rep:required}
1937: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1938: * @param p_commit API standard (default = F): indicates if transaction will be committed
1939: * @param p_candidate_in_tbl Table of candidate records
1940: * @rep:paraminfo {@rep:required}
1941: * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1942: * @rep:paraminfo {@rep:required}
1939: * @param p_candidate_in_tbl Table of candidate records
1940: * @rep:paraminfo {@rep:required}
1941: * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1942: * @rep:paraminfo {@rep:required}
1943: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1944: * @rep:paraminfo {@rep:required}
1945: * @param x_msg_count API standard: number of error messages
1946: * @rep:paraminfo {@rep:required}
1947: * @param x_msg_data API standard: error message
1941: * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1942: * @rep:paraminfo {@rep:required}
1943: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1944: * @rep:paraminfo {@rep:required}
1945: * @param x_msg_count API standard: number of error messages
1946: * @rep:paraminfo {@rep:required}
1947: * @param x_msg_data API standard: error message
1948: * @rep:paraminfo {@rep:required}
1949: * @rep:scope public
1943: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1944: * @rep:paraminfo {@rep:required}
1945: * @param x_msg_count API standard: number of error messages
1946: * @rep:paraminfo {@rep:required}
1947: * @param x_msg_data API standard: error message
1948: * @rep:paraminfo {@rep:required}
1949: * @rep:scope public
1950: * @rep:lifecycle active
1951: * @rep:displayname Create Candidates
1969: * Description: This procedure enables you to update the candidates for
1970: * project requirements.
1971: * Parameters:
1972: * Parameter Name Null? Description
1973: * P_COMMIT NULL API standard (default = F)
1974: * P_INIT_MSG_LIST NULL API standard (default = T)
1975: * P_API_VERSION_NUMBER NOT NULL API standard
1976: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1977: * the CANDIDATE_IN_TBL_TYPE datatype table.
1970: * project requirements.
1971: * Parameters:
1972: * Parameter Name Null? Description
1973: * P_COMMIT NULL API standard (default = F)
1974: * P_INIT_MSG_LIST NULL API standard (default = T)
1975: * P_API_VERSION_NUMBER NOT NULL API standard
1976: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1977: * the CANDIDATE_IN_TBL_TYPE datatype table.
1978: * X_RETURN_STATUS N/A The return status of the API. Valid
1971: * Parameters:
1972: * Parameter Name Null? Description
1973: * P_COMMIT NULL API standard (default = F)
1974: * P_INIT_MSG_LIST NULL API standard (default = T)
1975: * P_API_VERSION_NUMBER NOT NULL API standard
1976: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1977: * the CANDIDATE_IN_TBL_TYPE datatype table.
1978: * X_RETURN_STATUS N/A The return status of the API. Valid
1979: * values are: S (success)
1985: * error exists
1986: */
1987: /*#
1988: * This is a public API to update one or more candidates for project requirements
1989: * @param p_api_version_number API standard version number
1990: * @rep:paraminfo {@rep:required}
1991: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1992: * @param p_commit API standard (default = F): indicates if transaction will be committed
1993: * @param p_candidate_in_tbl Table of candidate records
1987: /*#
1988: * This is a public API to update one or more candidates for project requirements
1989: * @param p_api_version_number API standard version number
1990: * @rep:paraminfo {@rep:required}
1991: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1992: * @param p_commit API standard (default = F): indicates if transaction will be committed
1993: * @param p_candidate_in_tbl Table of candidate records
1994: * @rep:paraminfo {@rep:required}
1995: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1988: * This is a public API to update one or more candidates for project requirements
1989: * @param p_api_version_number API standard version number
1990: * @rep:paraminfo {@rep:required}
1991: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1992: * @param p_commit API standard (default = F): indicates if transaction will be committed
1993: * @param p_candidate_in_tbl Table of candidate records
1994: * @rep:paraminfo {@rep:required}
1995: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1996: * @rep:paraminfo {@rep:required}
1991: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1992: * @param p_commit API standard (default = F): indicates if transaction will be committed
1993: * @param p_candidate_in_tbl Table of candidate records
1994: * @rep:paraminfo {@rep:required}
1995: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1996: * @rep:paraminfo {@rep:required}
1997: * @param x_msg_count API standard: number of error messages
1998: * @rep:paraminfo {@rep:required}
1999: * @param x_msg_data API standard: error message
1993: * @param p_candidate_in_tbl Table of candidate records
1994: * @rep:paraminfo {@rep:required}
1995: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1996: * @rep:paraminfo {@rep:required}
1997: * @param x_msg_count API standard: number of error messages
1998: * @rep:paraminfo {@rep:required}
1999: * @param x_msg_data API standard: error message
2000: * @rep:paraminfo {@rep:required}
2001: * @rep:scope public
1995: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1996: * @rep:paraminfo {@rep:required}
1997: * @param x_msg_count API standard: number of error messages
1998: * @rep:paraminfo {@rep:required}
1999: * @param x_msg_data API standard: error message
2000: * @rep:paraminfo {@rep:required}
2001: * @rep:scope public
2002: * @rep:lifecycle active
2003: * @rep:displayname Update Candidates
2020: * Description: This procedure enables you to delete candidates from
2021: * project requirements.
2022: * Parameters:
2023: * Parameter Name Null? Description
2024: * P_COMMIT NULL API standard (default = F)
2025: * P_INIT_MSG_LIST NULL API standard (default = T)
2026: * P_API_VERSION_NUMBER NOT NULL API standard
2027: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
2028: * the CANDIDATE_IN_TBL_TYPE datatype table.
2021: * project requirements.
2022: * Parameters:
2023: * Parameter Name Null? Description
2024: * P_COMMIT NULL API standard (default = F)
2025: * P_INIT_MSG_LIST NULL API standard (default = T)
2026: * P_API_VERSION_NUMBER NOT NULL API standard
2027: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
2028: * the CANDIDATE_IN_TBL_TYPE datatype table.
2029: * X_RETURN_STATUS N/A The return status of the API. Valid
2022: * Parameters:
2023: * Parameter Name Null? Description
2024: * P_COMMIT NULL API standard (default = F)
2025: * P_INIT_MSG_LIST NULL API standard (default = T)
2026: * P_API_VERSION_NUMBER NOT NULL API standard
2027: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
2028: * the CANDIDATE_IN_TBL_TYPE datatype table.
2029: * X_RETURN_STATUS N/A The return status of the API. Valid
2030: * values are: S (success)
2036: * error exists
2037: */
2038: /*#
2039: * This is a public API to delete one or more candidates for project requirements.
2040: * @param p_api_version_number API standard version number
2041: * @rep:paraminfo {@rep:required}
2042: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
2043: * @param p_commit API standard (default = F): indicates if transaction will be committed
2044: * @param p_candidate_in_tbl Table of candidate records
2038: /*#
2039: * This is a public API to delete one or more candidates for project requirements.
2040: * @param p_api_version_number API standard version number
2041: * @rep:paraminfo {@rep:required}
2042: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
2043: * @param p_commit API standard (default = F): indicates if transaction will be committed
2044: * @param p_candidate_in_tbl Table of candidate records
2045: * @rep:paraminfo {@rep:required}
2046: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2039: * This is a public API to delete one or more candidates for project requirements.
2040: * @param p_api_version_number API standard version number
2041: * @rep:paraminfo {@rep:required}
2042: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
2043: * @param p_commit API standard (default = F): indicates if transaction will be committed
2044: * @param p_candidate_in_tbl Table of candidate records
2045: * @rep:paraminfo {@rep:required}
2046: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2047: * @rep:paraminfo {@rep:required}
2042: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
2043: * @param p_commit API standard (default = F): indicates if transaction will be committed
2044: * @param p_candidate_in_tbl Table of candidate records
2045: * @rep:paraminfo {@rep:required}
2046: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2047: * @rep:paraminfo {@rep:required}
2048: * @param x_msg_count API standard: number of error messages
2049: * @rep:paraminfo {@rep:required}
2050: * @param x_msg_data API standard: error message
2044: * @param p_candidate_in_tbl Table of candidate records
2045: * @rep:paraminfo {@rep:required}
2046: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2047: * @rep:paraminfo {@rep:required}
2048: * @param x_msg_count API standard: number of error messages
2049: * @rep:paraminfo {@rep:required}
2050: * @param x_msg_data API standard: error message
2051: * @rep:paraminfo {@rep:required}
2052: * @rep:scope public
2046: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2047: * @rep:paraminfo {@rep:required}
2048: * @param x_msg_count API standard: number of error messages
2049: * @rep:paraminfo {@rep:required}
2050: * @param x_msg_data API standard: error message
2051: * @rep:paraminfo {@rep:required}
2052: * @rep:scope public
2053: * @rep:lifecycle active
2054: * @rep:displayname Delete Candidates
2071: * Description: This procedure creates a log for one or more candidates for
2072: * project requirements.
2073: * Parameters:
2074: * Parameter Name Null? Description
2075: * P_COMMIT NULL API standard (default = F)
2076: * P_INIT_MSG_LIST NULL API standard (default = T)
2077: * P_API_VERSION_NUMBER NOT NULL API standard
2078: * P_CANDIDATE_LOG_TBL NOT NULL Table of candidate review records.
2079: * Please see the CANDIDATE_LOG_TBL_TYPE
2072: * project requirements.
2073: * Parameters:
2074: * Parameter Name Null? Description
2075: * P_COMMIT NULL API standard (default = F)
2076: * P_INIT_MSG_LIST NULL API standard (default = T)
2077: * P_API_VERSION_NUMBER NOT NULL API standard
2078: * P_CANDIDATE_LOG_TBL NOT NULL Table of candidate review records.
2079: * Please see the CANDIDATE_LOG_TBL_TYPE
2080: * datatype table.
2073: * Parameters:
2074: * Parameter Name Null? Description
2075: * P_COMMIT NULL API standard (default = F)
2076: * P_INIT_MSG_LIST NULL API standard (default = T)
2077: * P_API_VERSION_NUMBER NOT NULL API standard
2078: * P_CANDIDATE_LOG_TBL NOT NULL Table of candidate review records.
2079: * Please see the CANDIDATE_LOG_TBL_TYPE
2080: * datatype table.
2081: * X_CANDIDATE_REVIEW_ID_TBL N/A Table to store the candidate review IDs
2091: * error exists
2092: */
2093: /*#
2094: * This is a public API to create log for one or more candidates for project requirements.
2095: * @param p_api_version_number API standard version number
2096: * @rep:paraminfo {@rep:required}
2097: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
2098: * @param p_commit API standard (default = F): indicates if transaction will be committed
2099: * @param p_candidate_log_tbl Table of candidate review records
2093: /*#
2094: * This is a public API to create log for one or more candidates for project requirements.
2095: * @param p_api_version_number API standard version number
2096: * @rep:paraminfo {@rep:required}
2097: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
2098: * @param p_commit API standard (default = F): indicates if transaction will be committed
2099: * @param p_candidate_log_tbl Table of candidate review records
2100: * @rep:paraminfo {@rep:required}
2101: * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
2094: * This is a public API to create log for one or more candidates for project requirements.
2095: * @param p_api_version_number API standard version number
2096: * @rep:paraminfo {@rep:required}
2097: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
2098: * @param p_commit API standard (default = F): indicates if transaction will be committed
2099: * @param p_candidate_log_tbl Table of candidate review records
2100: * @rep:paraminfo {@rep:required}
2101: * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
2102: * @rep:paraminfo {@rep:required}
2099: * @param p_candidate_log_tbl Table of candidate review records
2100: * @rep:paraminfo {@rep:required}
2101: * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
2102: * @rep:paraminfo {@rep:required}
2103: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2104: * @rep:paraminfo {@rep:required}
2105: * @param x_msg_count API standard: number of error messages
2106: * @rep:paraminfo {@rep:required}
2107: * @param x_msg_data API standard: error message
2101: * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
2102: * @rep:paraminfo {@rep:required}
2103: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2104: * @rep:paraminfo {@rep:required}
2105: * @param x_msg_count API standard: number of error messages
2106: * @rep:paraminfo {@rep:required}
2107: * @param x_msg_data API standard: error message
2108: * @rep:paraminfo {@rep:required}
2109: * @rep:scope public
2103: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2104: * @rep:paraminfo {@rep:required}
2105: * @param x_msg_count API standard: number of error messages
2106: * @rep:paraminfo {@rep:required}
2107: * @param x_msg_data API standard: error message
2108: * @rep:paraminfo {@rep:required}
2109: * @rep:scope public
2110: * @rep:lifecycle active
2111: * @rep:displayname Create Candidate Log