[Home] [Help]
1136: * Description: This procedure enables you to create project requirements.
1137: *
1138: * Parameters:
1139: * Parameter Name Null? Description
1140: * P_COMMIT NULL API standard (default = F)
1141: * P_INIT_MSG_LIST NULL API standard (default = T)
1142: * P_API_VERSION_NUMBER NOT NULL API standard
1143: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1144: * see the REQUIREMENT_IN_TBL_TYPE
1137: *
1138: * Parameters:
1139: * Parameter Name Null? Description
1140: * P_COMMIT NULL API standard (default = F)
1141: * P_INIT_MSG_LIST NULL API standard (default = T)
1142: * P_API_VERSION_NUMBER NOT NULL API standard
1143: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1144: * see the REQUIREMENT_IN_TBL_TYPE
1145: * datatype table.
1138: * Parameters:
1139: * Parameter Name Null? Description
1140: * P_COMMIT NULL API standard (default = F)
1141: * P_INIT_MSG_LIST NULL API standard (default = T)
1142: * P_API_VERSION_NUMBER NOT NULL API standard
1143: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1144: * see the REQUIREMENT_IN_TBL_TYPE
1145: * datatype table.
1146: * X_REQUIREMENT_ID_TBL N/A Table of requirement IDs created by
1156: * error exists
1157: */
1158: /*#
1159: * This is a public API to create one or more requirements for one or more projects
1160: * @param p_api_version_number API standard version number
1161: * @rep:paraminfo {@rep:required}
1162: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1163: * @param p_commit API standard (default = F): indicates if transaction will be committed
1164: * @param p_requirement_in_tbl Table of requirement records
1158: /*#
1159: * This is a public API to create one or more requirements for one or more projects
1160: * @param p_api_version_number API standard version number
1161: * @rep:paraminfo {@rep:required}
1162: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1163: * @param p_commit API standard (default = F): indicates if transaction will be committed
1164: * @param p_requirement_in_tbl Table of requirement records
1165: * @rep:paraminfo {@rep:required}
1166: * @param x_requirement_id_tbl Table of requirement IDs created by the API
1159: * This is a public API to create one or more requirements for one or more projects
1160: * @param p_api_version_number API standard version number
1161: * @rep:paraminfo {@rep:required}
1162: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1163: * @param p_commit API standard (default = F): indicates if transaction will be committed
1164: * @param p_requirement_in_tbl Table of requirement records
1165: * @rep:paraminfo {@rep:required}
1166: * @param x_requirement_id_tbl Table of requirement IDs created by the API
1167: * @rep:paraminfo {@rep:required}
1164: * @param p_requirement_in_tbl Table of requirement records
1165: * @rep:paraminfo {@rep:required}
1166: * @param x_requirement_id_tbl Table of requirement IDs created by the API
1167: * @rep:paraminfo {@rep:required}
1168: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1169: * @rep:paraminfo {@rep:required}
1170: * @param x_msg_count API standard: number of error messages
1171: * @rep:paraminfo {@rep:required}
1172: * @param x_msg_data API standard: error message
1166: * @param x_requirement_id_tbl Table of requirement IDs created by the API
1167: * @rep:paraminfo {@rep:required}
1168: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1169: * @rep:paraminfo {@rep:required}
1170: * @param x_msg_count API standard: number of error messages
1171: * @rep:paraminfo {@rep:required}
1172: * @param x_msg_data API standard: error message
1173: * @rep:paraminfo {@rep:required}
1174: * @rep:scope public
1168: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1169: * @rep:paraminfo {@rep:required}
1170: * @param x_msg_count API standard: number of error messages
1171: * @rep:paraminfo {@rep:required}
1172: * @param x_msg_data API standard: error message
1173: * @rep:paraminfo {@rep:required}
1174: * @rep:scope public
1175: * @rep:lifecycle active
1176: * @rep:displayname Create Requirements
1193: * Description: This procedure enables you to update project requirements.
1194: *
1195: * Parameters:
1196: * Parameter Name Null? Description
1197: * P_COMMIT NULL API standard (default = F)
1198: * P_INIT_MSG_LIST NULL API standard (default = T)
1199: * P_API_VERSION_NUMBER NOT NULL API standard
1200: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1201: * see the REQUIREMENT_IN_TBL_TYPE
1194: *
1195: * Parameters:
1196: * Parameter Name Null? Description
1197: * P_COMMIT NULL API standard (default = F)
1198: * P_INIT_MSG_LIST NULL API standard (default = T)
1199: * P_API_VERSION_NUMBER NOT NULL API standard
1200: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1201: * see the REQUIREMENT_IN_TBL_TYPE
1202: * datatype table.
1195: * Parameters:
1196: * Parameter Name Null? Description
1197: * P_COMMIT NULL API standard (default = F)
1198: * P_INIT_MSG_LIST NULL API standard (default = T)
1199: * P_API_VERSION_NUMBER NOT NULL API standard
1200: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1201: * see the REQUIREMENT_IN_TBL_TYPE
1202: * datatype table.
1203: * X_RETURN_STATUS N/A The return status of the API. Valid
1210: * error exists
1211: */
1212: /*#
1213: * This is a public API to update one or more requirements for one or more projects
1214: * @param p_api_version_number API standard version number
1215: * @rep:paraminfo {@rep:required}
1216: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1217: * @param p_commit API standard (default = F): indicates if transaction will be committed
1218: * @param p_requirement_in_tbl Table of requirement records
1212: /*#
1213: * This is a public API to update one or more requirements for one or more projects
1214: * @param p_api_version_number API standard version number
1215: * @rep:paraminfo {@rep:required}
1216: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1217: * @param p_commit API standard (default = F): indicates if transaction will be committed
1218: * @param p_requirement_in_tbl Table of requirement records
1219: * @rep:paraminfo {@rep:required}
1220: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1213: * This is a public API to update one or more requirements for one or more projects
1214: * @param p_api_version_number API standard version number
1215: * @rep:paraminfo {@rep:required}
1216: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1217: * @param p_commit API standard (default = F): indicates if transaction will be committed
1218: * @param p_requirement_in_tbl Table of requirement records
1219: * @rep:paraminfo {@rep:required}
1220: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1221: * @rep:paraminfo {@rep:required}
1216: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1217: * @param p_commit API standard (default = F): indicates if transaction will be committed
1218: * @param p_requirement_in_tbl Table of requirement records
1219: * @rep:paraminfo {@rep:required}
1220: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1221: * @rep:paraminfo {@rep:required}
1222: * @param x_msg_count API standard: number of error messages
1223: * @rep:paraminfo {@rep:required}
1224: * @param x_msg_data API standard: error message
1218: * @param p_requirement_in_tbl Table of requirement records
1219: * @rep:paraminfo {@rep:required}
1220: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1221: * @rep:paraminfo {@rep:required}
1222: * @param x_msg_count API standard: number of error messages
1223: * @rep:paraminfo {@rep:required}
1224: * @param x_msg_data API standard: error message
1225: * @rep:paraminfo {@rep:required}
1226: * @rep:scope public
1220: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1221: * @rep:paraminfo {@rep:required}
1222: * @param x_msg_count API standard: number of error messages
1223: * @rep:paraminfo {@rep:required}
1224: * @param x_msg_data API standard: error message
1225: * @rep:paraminfo {@rep:required}
1226: * @rep:scope public
1227: * @rep:lifecycle active
1228: * @rep:displayname Update Requirements
1244: * Description: This procedure enables you to delete project requirements.
1245: *
1246: * Parameters:
1247: * Parameter Name Null? Description
1248: * P_COMMIT NULL API standard (default = F)
1249: * P_INIT_MSG_LIST NULL API standard (default = T)
1250: * P_API_VERSION_NUMBER NOT NULL API standard
1251: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1252: * see the REQUIREMENT_IN_TBL_TYPE
1245: *
1246: * Parameters:
1247: * Parameter Name Null? Description
1248: * P_COMMIT NULL API standard (default = F)
1249: * P_INIT_MSG_LIST NULL API standard (default = T)
1250: * P_API_VERSION_NUMBER NOT NULL API standard
1251: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1252: * see the REQUIREMENT_IN_TBL_TYPE
1253: * datatype table.
1246: * Parameters:
1247: * Parameter Name Null? Description
1248: * P_COMMIT NULL API standard (default = F)
1249: * P_INIT_MSG_LIST NULL API standard (default = T)
1250: * P_API_VERSION_NUMBER NOT NULL API standard
1251: * P_REQUIREMENT_IN_TBL NOT NULL Table of requirement records. Please
1252: * see the REQUIREMENT_IN_TBL_TYPE
1253: * datatype table.
1254: * X_RETURN_STATUS N/A The return status of the API. Valid
1261: * error exists
1262: */
1263: /*#
1264: * This is a public API to delete one or more requirements for one or more projects
1265: * @param p_api_version_number API standard version number
1266: * @rep:paraminfo {@rep:required}
1267: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1268: * @param p_commit API standard (default = F): indicates if transaction will be committed
1269: * @param p_requirement_in_tbl Table of requirement records
1263: /*#
1264: * This is a public API to delete one or more requirements for one or more projects
1265: * @param p_api_version_number API standard version number
1266: * @rep:paraminfo {@rep:required}
1267: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1268: * @param p_commit API standard (default = F): indicates if transaction will be committed
1269: * @param p_requirement_in_tbl Table of requirement records
1270: * @rep:paraminfo {@rep:required}
1271: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1264: * This is a public API to delete one or more requirements for one or more projects
1265: * @param p_api_version_number API standard version number
1266: * @rep:paraminfo {@rep:required}
1267: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1268: * @param p_commit API standard (default = F): indicates if transaction will be committed
1269: * @param p_requirement_in_tbl Table of requirement records
1270: * @rep:paraminfo {@rep:required}
1271: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1272: * @rep:paraminfo {@rep:required}
1267: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1268: * @param p_commit API standard (default = F): indicates if transaction will be committed
1269: * @param p_requirement_in_tbl Table of requirement records
1270: * @rep:paraminfo {@rep:required}
1271: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1272: * @rep:paraminfo {@rep:required}
1273: * @param x_msg_count API standard: number of error messages
1274: * @rep:paraminfo {@rep:required}
1275: * @param x_msg_data API standard: error message
1269: * @param p_requirement_in_tbl Table of requirement records
1270: * @rep:paraminfo {@rep:required}
1271: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1272: * @rep:paraminfo {@rep:required}
1273: * @param x_msg_count API standard: number of error messages
1274: * @rep:paraminfo {@rep:required}
1275: * @param x_msg_data API standard: error message
1276: * @rep:paraminfo {@rep:required}
1277: * @rep:scope public
1271: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1272: * @rep:paraminfo {@rep:required}
1273: * @param x_msg_count API standard: number of error messages
1274: * @rep:paraminfo {@rep:required}
1275: * @param x_msg_data API standard: error message
1276: * @rep:paraminfo {@rep:required}
1277: * @rep:scope public
1278: * @rep:lifecycle active
1279: * @rep:displayname Delete Requirements
1295: * Description: This procedure enables you to staff requirements.
1296: *
1297: * Parameters:
1298: * Parameter Name Null? Description
1299: * P_COMMIT NULL API standard (default = F)
1300: * P_INIT_MSG_LIST NULL API standard (default = T)
1301: * P_API_VERSION_NUMBER NOT NULL API standard
1302: * P_STAFF_REQUIREMENT_TBL NOT NULL Table of staffing information for each
1303: * requirement. Please see the
1296: *
1297: * Parameters:
1298: * Parameter Name Null? Description
1299: * P_COMMIT NULL API standard (default = F)
1300: * P_INIT_MSG_LIST NULL API standard (default = T)
1301: * P_API_VERSION_NUMBER NOT NULL API standard
1302: * P_STAFF_REQUIREMENT_TBL NOT NULL Table of staffing information for each
1303: * requirement. Please see the
1304: * Staff_requirement_tbl_TYPE datatype
1297: * Parameters:
1298: * Parameter Name Null? Description
1299: * P_COMMIT NULL API standard (default = F)
1300: * P_INIT_MSG_LIST NULL API standard (default = T)
1301: * P_API_VERSION_NUMBER NOT NULL API standard
1302: * P_STAFF_REQUIREMENT_TBL NOT NULL Table of staffing information for each
1303: * requirement. Please see the
1304: * Staff_requirement_tbl_TYPE datatype
1305: * table.
1315: * error exists
1316: */
1317: /*#
1318: * This is a public API to staff one or more requirements for one or more projects
1319: * @param p_api_version_number API standard version number
1320: * @rep:paraminfo {@rep:required}
1321: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1322: * @param p_commit API standard (default = F): indicates if transaction will be committed
1323: * @param p_staff_requirement_tbl Table of staffing information for each requirement
1317: /*#
1318: * This is a public API to staff one or more requirements for one or more projects
1319: * @param p_api_version_number API standard version number
1320: * @rep:paraminfo {@rep:required}
1321: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1322: * @param p_commit API standard (default = F): indicates if transaction will be committed
1323: * @param p_staff_requirement_tbl Table of staffing information for each requirement
1324: * @rep:paraminfo {@rep:required}
1325: * @param x_assignment_id_tbl Table of staffed assignment IDs.
1318: * This is a public API to staff one or more requirements for one or more projects
1319: * @param p_api_version_number API standard version number
1320: * @rep:paraminfo {@rep:required}
1321: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1322: * @param p_commit API standard (default = F): indicates if transaction will be committed
1323: * @param p_staff_requirement_tbl Table of staffing information for each requirement
1324: * @rep:paraminfo {@rep:required}
1325: * @param x_assignment_id_tbl Table of staffed assignment IDs.
1326: * @rep:paraminfo {@rep:required}
1323: * @param p_staff_requirement_tbl Table of staffing information for each requirement
1324: * @rep:paraminfo {@rep:required}
1325: * @param x_assignment_id_tbl Table of staffed assignment IDs.
1326: * @rep:paraminfo {@rep:required}
1327: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1328: * @rep:paraminfo {@rep:required}
1329: * @param x_msg_count API standard: number of error messages
1330: * @rep:paraminfo {@rep:required}
1331: * @param x_msg_data API standard: error message
1325: * @param x_assignment_id_tbl Table of staffed assignment IDs.
1326: * @rep:paraminfo {@rep:required}
1327: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1328: * @rep:paraminfo {@rep:required}
1329: * @param x_msg_count API standard: number of error messages
1330: * @rep:paraminfo {@rep:required}
1331: * @param x_msg_data API standard: error message
1332: * @rep:paraminfo {@rep:required}
1333: * @rep:scope public
1327: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1328: * @rep:paraminfo {@rep:required}
1329: * @param x_msg_count API standard: number of error messages
1330: * @rep:paraminfo {@rep:required}
1331: * @param x_msg_data API standard: error message
1332: * @rep:paraminfo {@rep:required}
1333: * @rep:scope public
1334: * @rep:lifecycle active
1335: * @rep:displayname Staff Requirements
1353: * project assignments or requirements.
1354: *
1355: * Parameters:
1356: * Parameter Name Null? Description
1357: * P_COMMIT NULL API standard (default = F)
1358: * P_INIT_MSG_LIST NULL API standard (default = T)
1359: * P_API_VERSION_NUMBER NOT NULL API standard
1360: * P_REQ_ASGN_ID_TBL NOT NULL Table of requirement or assignment IDs.
1361: * Reference: pa_project_assignments.assignment_id
1354: *
1355: * Parameters:
1356: * Parameter Name Null? Description
1357: * P_COMMIT NULL API standard (default = F)
1358: * P_INIT_MSG_LIST NULL API standard (default = T)
1359: * P_API_VERSION_NUMBER NOT NULL API standard
1360: * P_REQ_ASGN_ID_TBL NOT NULL Table of requirement or assignment IDs.
1361: * Reference: pa_project_assignments.assignment_id
1362: * X_REQ_ASGN_ID_TBL N/A Table of requirement or assignment IDs
1355: * Parameters:
1356: * Parameter Name Null? Description
1357: * P_COMMIT NULL API standard (default = F)
1358: * P_INIT_MSG_LIST NULL API standard (default = T)
1359: * P_API_VERSION_NUMBER NOT NULL API standard
1360: * P_REQ_ASGN_ID_TBL NOT NULL Table of requirement or assignment IDs.
1361: * Reference: pa_project_assignments.assignment_id
1362: * X_REQ_ASGN_ID_TBL N/A Table of requirement or assignment IDs
1363: * created by the API.
1372: * error exists
1373: */
1374: /*#
1375: * This is a public API to copy one or more team roles
1376: * @param p_api_version_number API standard version number
1377: * @rep:paraminfo {@rep:required}
1378: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1379: * @param p_commit API standard (default = F): indicates if transaction will be committed
1380: * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1374: /*#
1375: * This is a public API to copy one or more team roles
1376: * @param p_api_version_number API standard version number
1377: * @rep:paraminfo {@rep:required}
1378: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1379: * @param p_commit API standard (default = F): indicates if transaction will be committed
1380: * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1381: * @rep:paraminfo {@rep:required}
1382: * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1375: * This is a public API to copy one or more team roles
1376: * @param p_api_version_number API standard version number
1377: * @rep:paraminfo {@rep:required}
1378: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1379: * @param p_commit API standard (default = F): indicates if transaction will be committed
1380: * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1381: * @rep:paraminfo {@rep:required}
1382: * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1383: * @rep:paraminfo {@rep:required}
1380: * @param p_req_asgn_id_tbl Table of requirement or assignment IDs
1381: * @rep:paraminfo {@rep:required}
1382: * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1383: * @rep:paraminfo {@rep:required}
1384: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1385: * @rep:paraminfo {@rep:required}
1386: * @param x_msg_count API standard: number of error messages
1387: * @rep:paraminfo {@rep:required}
1388: * @param x_msg_data API standard: error message
1382: * @param x_req_asgn_id_tbl Table of requirement or assignment IDs
1383: * @rep:paraminfo {@rep:required}
1384: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1385: * @rep:paraminfo {@rep:required}
1386: * @param x_msg_count API standard: number of error messages
1387: * @rep:paraminfo {@rep:required}
1388: * @param x_msg_data API standard: error message
1389: * @rep:paraminfo {@rep:required}
1390: * @rep:scope public
1384: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1385: * @rep:paraminfo {@rep:required}
1386: * @param x_msg_count API standard: number of error messages
1387: * @rep:paraminfo {@rep:required}
1388: * @param x_msg_data API standard: error message
1389: * @rep:paraminfo {@rep:required}
1390: * @rep:scope public
1391: * @rep:lifecycle active
1392: * @rep:displayname Copy Team Roles
1409: * Description: This procedure enables you to create project assignments.
1410: *
1411: * Parameters:
1412: * Parameter Name Null? Description
1413: * P_COMMIT NULL API standard (default = F)
1414: * P_INIT_MSG_LIST NULL API standard (default = T)
1415: * P_API_VERSION_NUMBER NOT NULL API standard
1416: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1417: * see the ASSIGNMENT_IN_TBL_TYPE
1410: *
1411: * Parameters:
1412: * Parameter Name Null? Description
1413: * P_COMMIT NULL API standard (default = F)
1414: * P_INIT_MSG_LIST NULL API standard (default = T)
1415: * P_API_VERSION_NUMBER NOT NULL API standard
1416: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1417: * see the ASSIGNMENT_IN_TBL_TYPE
1418: * datatype table.
1411: * Parameters:
1412: * Parameter Name Null? Description
1413: * P_COMMIT NULL API standard (default = F)
1414: * P_INIT_MSG_LIST NULL API standard (default = T)
1415: * P_API_VERSION_NUMBER NOT NULL API standard
1416: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1417: * see the ASSIGNMENT_IN_TBL_TYPE
1418: * datatype table.
1419: * X_ASSIGNMENT_ID_TBL N/A Table to store assignment IDs created
1429: * error exists
1430: */
1431: /*#
1432: * This is a public API to create one or more assignments for one or more projects
1433: * @param p_api_version_number API standard version number
1434: * @rep:paraminfo {@rep:required}
1435: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1436: * @param p_commit API standard (default = F): indicates if transaction will be committed
1437: * @param p_assignment_in_tbl Table of assignment records
1431: /*#
1432: * This is a public API to create one or more assignments for one or more projects
1433: * @param p_api_version_number API standard version number
1434: * @rep:paraminfo {@rep:required}
1435: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1436: * @param p_commit API standard (default = F): indicates if transaction will be committed
1437: * @param p_assignment_in_tbl Table of assignment records
1438: * @rep:paraminfo {@rep:required}
1439: * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1432: * This is a public API to create one or more assignments for one or more projects
1433: * @param p_api_version_number API standard version number
1434: * @rep:paraminfo {@rep:required}
1435: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1436: * @param p_commit API standard (default = F): indicates if transaction will be committed
1437: * @param p_assignment_in_tbl Table of assignment records
1438: * @rep:paraminfo {@rep:required}
1439: * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1440: * @rep:paraminfo {@rep:required}
1437: * @param p_assignment_in_tbl Table of assignment records
1438: * @rep:paraminfo {@rep:required}
1439: * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1440: * @rep:paraminfo {@rep:required}
1441: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1442: * @rep:paraminfo {@rep:required}
1443: * @param x_msg_count API standard: number of error messages
1444: * @rep:paraminfo {@rep:required}
1445: * @param x_msg_data API standard: error message
1439: * @param x_assignment_id_tbl Table to store assignment IDs created by the API
1440: * @rep:paraminfo {@rep:required}
1441: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1442: * @rep:paraminfo {@rep:required}
1443: * @param x_msg_count API standard: number of error messages
1444: * @rep:paraminfo {@rep:required}
1445: * @param x_msg_data API standard: error message
1446: * @rep:paraminfo {@rep:required}
1447: * @rep:scope public
1441: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1442: * @rep:paraminfo {@rep:required}
1443: * @param x_msg_count API standard: number of error messages
1444: * @rep:paraminfo {@rep:required}
1445: * @param x_msg_data API standard: error message
1446: * @rep:paraminfo {@rep:required}
1447: * @rep:scope public
1448: * @rep:lifecycle active
1449: * @rep:displayname Create Assignments
1466: * Description: This procedure enables you to update project assignments.
1467: *
1468: * Parameters:
1469: * Parameter Name Null? Description
1470: * P_COMMIT NULL API standard (default = F)
1471: * P_INIT_MSG_LIST NULL API standard (default = T)
1472: * P_API_VERSION_NUMBER NOT NULL API standard
1473: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1474: * see the ASSIGNMENT_IN_TBL_TYPE
1467: *
1468: * Parameters:
1469: * Parameter Name Null? Description
1470: * P_COMMIT NULL API standard (default = F)
1471: * P_INIT_MSG_LIST NULL API standard (default = T)
1472: * P_API_VERSION_NUMBER NOT NULL API standard
1473: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1474: * see the ASSIGNMENT_IN_TBL_TYPE
1475: * datatype table.
1468: * Parameters:
1469: * Parameter Name Null? Description
1470: * P_COMMIT NULL API standard (default = F)
1471: * P_INIT_MSG_LIST NULL API standard (default = T)
1472: * P_API_VERSION_NUMBER NOT NULL API standard
1473: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1474: * see the ASSIGNMENT_IN_TBL_TYPE
1475: * datatype table.
1476: * X_RETURN_STATUS N/A The return status of the API. Valid
1483: * error exists
1484: */
1485: /*#
1486: * This is a public API to update one or more assignments for one or more projects.
1487: * @param p_api_version_number API standard version number
1488: * @rep:paraminfo {@rep:required}
1489: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1490: * @param p_commit API standard (default = F): indicates if transaction will be committed
1491: * @param p_assignment_in_tbl Table of assignment records
1485: /*#
1486: * This is a public API to update one or more assignments for one or more projects.
1487: * @param p_api_version_number API standard version number
1488: * @rep:paraminfo {@rep:required}
1489: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1490: * @param p_commit API standard (default = F): indicates if transaction will be committed
1491: * @param p_assignment_in_tbl Table of assignment records
1492: * @rep:paraminfo {@rep:required}
1493: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1486: * This is a public API to update one or more assignments for one or more projects.
1487: * @param p_api_version_number API standard version number
1488: * @rep:paraminfo {@rep:required}
1489: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1490: * @param p_commit API standard (default = F): indicates if transaction will be committed
1491: * @param p_assignment_in_tbl Table of assignment records
1492: * @rep:paraminfo {@rep:required}
1493: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1494: * @rep:paraminfo {@rep:required}
1489: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1490: * @param p_commit API standard (default = F): indicates if transaction will be committed
1491: * @param p_assignment_in_tbl Table of assignment records
1492: * @rep:paraminfo {@rep:required}
1493: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1494: * @rep:paraminfo {@rep:required}
1495: * @param x_msg_count API standard: number of error messages
1496: * @rep:paraminfo {@rep:required}
1497: * @param x_msg_data API standard: error message
1491: * @param p_assignment_in_tbl Table of assignment records
1492: * @rep:paraminfo {@rep:required}
1493: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1494: * @rep:paraminfo {@rep:required}
1495: * @param x_msg_count API standard: number of error messages
1496: * @rep:paraminfo {@rep:required}
1497: * @param x_msg_data API standard: error message
1498: * @rep:paraminfo {@rep:required}
1499: * @rep:scope public
1493: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1494: * @rep:paraminfo {@rep:required}
1495: * @param x_msg_count API standard: number of error messages
1496: * @rep:paraminfo {@rep:required}
1497: * @param x_msg_data API standard: error message
1498: * @rep:paraminfo {@rep:required}
1499: * @rep:scope public
1500: * @rep:lifecycle active
1501: * @rep:displayname Update Assignments
1517: * Description: This procedure enables you to delete project assignments.
1518: *
1519: * Parameters:
1520: * Parameter Name Null? Description
1521: * P_COMMIT NULL API standard (default = F)
1522: * P_INIT_MSG_LIST NULL API standard (default = T)
1523: * P_API_VERSION_NUMBER NOT NULL API standard
1524: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1525: * see the ASSIGNMENT_IN_TBL_TYPE
1518: *
1519: * Parameters:
1520: * Parameter Name Null? Description
1521: * P_COMMIT NULL API standard (default = F)
1522: * P_INIT_MSG_LIST NULL API standard (default = T)
1523: * P_API_VERSION_NUMBER NOT NULL API standard
1524: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1525: * see the ASSIGNMENT_IN_TBL_TYPE
1526: * datatype table.
1519: * Parameters:
1520: * Parameter Name Null? Description
1521: * P_COMMIT NULL API standard (default = F)
1522: * P_INIT_MSG_LIST NULL API standard (default = T)
1523: * P_API_VERSION_NUMBER NOT NULL API standard
1524: * P_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1525: * see the ASSIGNMENT_IN_TBL_TYPE
1526: * datatype table.
1527: * X_RETURN_STATUS N/A The return status of the API. Valid
1534: * error exists
1535: */
1536: /*#
1537: * This is a public API to Delete one or more assignments for one or more projects.
1538: * @param p_api_version_number API standard version number
1539: * @rep:paraminfo {@rep:required}
1540: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1541: * @param p_commit API standard (default = F): indicates if transaction will be committed
1542: * @param p_assignment_in_tbl Table of assignment records
1536: /*#
1537: * This is a public API to Delete one or more assignments for one or more projects.
1538: * @param p_api_version_number API standard version number
1539: * @rep:paraminfo {@rep:required}
1540: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1541: * @param p_commit API standard (default = F): indicates if transaction will be committed
1542: * @param p_assignment_in_tbl Table of assignment records
1543: * @rep:paraminfo {@rep:required}
1544: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1537: * This is a public API to Delete one or more assignments for one or more projects.
1538: * @param p_api_version_number API standard version number
1539: * @rep:paraminfo {@rep:required}
1540: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1541: * @param p_commit API standard (default = F): indicates if transaction will be committed
1542: * @param p_assignment_in_tbl Table of assignment records
1543: * @rep:paraminfo {@rep:required}
1544: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1545: * @rep:paraminfo {@rep:required}
1540: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1541: * @param p_commit API standard (default = F): indicates if transaction will be committed
1542: * @param p_assignment_in_tbl Table of assignment records
1543: * @rep:paraminfo {@rep:required}
1544: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1545: * @rep:paraminfo {@rep:required}
1546: * @param x_msg_count API standard: number of error messages
1547: * @rep:paraminfo {@rep:required}
1548: * @param x_msg_data API standard: error message
1542: * @param p_assignment_in_tbl Table of assignment records
1543: * @rep:paraminfo {@rep:required}
1544: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1545: * @rep:paraminfo {@rep:required}
1546: * @param x_msg_count API standard: number of error messages
1547: * @rep:paraminfo {@rep:required}
1548: * @param x_msg_data API standard: error message
1549: * @rep:paraminfo {@rep:required}
1550: * @rep:scope public
1544: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1545: * @rep:paraminfo {@rep:required}
1546: * @param x_msg_count API standard: number of error messages
1547: * @rep:paraminfo {@rep:required}
1548: * @param x_msg_data API standard: error message
1549: * @rep:paraminfo {@rep:required}
1550: * @rep:scope public
1551: * @rep:lifecycle active
1552: * @rep:displayname Delete Assignments
1567: * assignments.
1568: *
1569: * Parameters:
1570: * Parameter Name Null? Description
1571: * P_COMMIT NULL API standard (default = F)
1572: * P_INIT_MSG_LIST NULL API standard (default = T)
1573: * P_API_VERSION_NUMBER NOT NULL API standard
1574: * P_SUBMIT_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1575: * see the SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1568: *
1569: * Parameters:
1570: * Parameter Name Null? Description
1571: * P_COMMIT NULL API standard (default = F)
1572: * P_INIT_MSG_LIST NULL API standard (default = T)
1573: * P_API_VERSION_NUMBER NOT NULL API standard
1574: * P_SUBMIT_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1575: * see the SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1576: * datatype table.
1569: * Parameters:
1570: * Parameter Name Null? Description
1571: * P_COMMIT NULL API standard (default = F)
1572: * P_INIT_MSG_LIST NULL API standard (default = T)
1573: * P_API_VERSION_NUMBER NOT NULL API standard
1574: * P_SUBMIT_ASSIGNMENT_IN_TBL NOT NULL Table of assignment records. Please
1575: * see the SUBMIT_ASSIGNMENT_IN_TBL_TYPE
1576: * datatype table.
1577: * X_RETURN_STATUS N/A The return status of the API. Valid
1584: * error exists
1585: */
1586: /*#
1587: * This is a public API to submit/approve one or more assignments for one or more projects.
1588: * @param p_api_version_number API standard version number
1589: * @rep:paraminfo {@rep:required}
1590: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1591: * @param p_commit API standard (default = F): indicates if transaction will be committed
1592: * @param p_submit_assignment_in_tbl Table of assignment records
1586: /*#
1587: * This is a public API to submit/approve one or more assignments for one or more projects.
1588: * @param p_api_version_number API standard version number
1589: * @rep:paraminfo {@rep:required}
1590: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1591: * @param p_commit API standard (default = F): indicates if transaction will be committed
1592: * @param p_submit_assignment_in_tbl Table of assignment records
1593: * @rep:paraminfo {@rep:required}
1594: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1587: * This is a public API to submit/approve one or more assignments for one or more projects.
1588: * @param p_api_version_number API standard version number
1589: * @rep:paraminfo {@rep:required}
1590: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1591: * @param p_commit API standard (default = F): indicates if transaction will be committed
1592: * @param p_submit_assignment_in_tbl Table of assignment records
1593: * @rep:paraminfo {@rep:required}
1594: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1595: * @rep:paraminfo {@rep:required}
1590: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1591: * @param p_commit API standard (default = F): indicates if transaction will be committed
1592: * @param p_submit_assignment_in_tbl Table of assignment records
1593: * @rep:paraminfo {@rep:required}
1594: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1595: * @rep:paraminfo {@rep:required}
1596: * @param x_msg_count API standard: number of error messages
1597: * @rep:paraminfo {@rep:required}
1598: * @param x_msg_data API standard: error message
1592: * @param p_submit_assignment_in_tbl Table of assignment records
1593: * @rep:paraminfo {@rep:required}
1594: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1595: * @rep:paraminfo {@rep:required}
1596: * @param x_msg_count API standard: number of error messages
1597: * @rep:paraminfo {@rep:required}
1598: * @param x_msg_data API standard: error message
1599: * @rep:paraminfo {@rep:required}
1600: * @rep:scope public
1594: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1595: * @rep:paraminfo {@rep:required}
1596: * @param x_msg_count API standard: number of error messages
1597: * @rep:paraminfo {@rep:required}
1598: * @param x_msg_data API standard: error message
1599: * @rep:paraminfo {@rep:required}
1600: * @rep:scope public
1601: * @rep:lifecycle active
1602: * @rep:displayname Submit Assignments
1618: * Description: This procedure enables you to create competences for
1619: * project requirements.
1620: * Parameters:
1621: * Parameter Name Null? Description
1622: * P_COMMIT NULL API standard (default = F)
1623: * P_INIT_MSG_LIST NULL API standard (default = T)
1624: * P_API_VERSION_NUMBER NOT NULL API standard
1625: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1626: * see the COMPETENCE_IN_TBL_TYPE
1619: * project requirements.
1620: * Parameters:
1621: * Parameter Name Null? Description
1622: * P_COMMIT NULL API standard (default = F)
1623: * P_INIT_MSG_LIST NULL API standard (default = T)
1624: * P_API_VERSION_NUMBER NOT NULL API standard
1625: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1626: * see the COMPETENCE_IN_TBL_TYPE
1627: * datatype table.
1620: * Parameters:
1621: * Parameter Name Null? Description
1622: * P_COMMIT NULL API standard (default = F)
1623: * P_INIT_MSG_LIST NULL API standard (default = T)
1624: * P_API_VERSION_NUMBER NOT NULL API standard
1625: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1626: * see the COMPETENCE_IN_TBL_TYPE
1627: * datatype table.
1628: * X_COMPETENCE_ELEMENT_ID_TBL N/A Table to store the competence element
1638: * error exists
1639: */
1640: /*#
1641: * This is a public API to create one or more competences for one or more project requirements.
1642: * @param p_api_version_number API standard version number
1643: * @rep:paraminfo {@rep:required}
1644: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1645: * @param p_commit API standard (default = F): indicates if transaction will be committed
1646: * @param p_competence_in_tbl Table of competence records
1640: /*#
1641: * This is a public API to create one or more competences for one or more project requirements.
1642: * @param p_api_version_number API standard version number
1643: * @rep:paraminfo {@rep:required}
1644: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1645: * @param p_commit API standard (default = F): indicates if transaction will be committed
1646: * @param p_competence_in_tbl Table of competence records
1647: * @rep:paraminfo {@rep:required}
1648: * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1641: * This is a public API to create one or more competences for one or more project requirements.
1642: * @param p_api_version_number API standard version number
1643: * @rep:paraminfo {@rep:required}
1644: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1645: * @param p_commit API standard (default = F): indicates if transaction will be committed
1646: * @param p_competence_in_tbl Table of competence records
1647: * @rep:paraminfo {@rep:required}
1648: * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1649: * @rep:paraminfo {@rep:required}
1646: * @param p_competence_in_tbl Table of competence records
1647: * @rep:paraminfo {@rep:required}
1648: * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1649: * @rep:paraminfo {@rep:required}
1650: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1651: * @rep:paraminfo {@rep:required}
1652: * @param x_msg_count API standard: number of error messages
1653: * @rep:paraminfo {@rep:required}
1654: * @param x_msg_data API standard: error message
1648: * @param x_competence_element_id_tbl Table to store the competence element IDs created by the API
1649: * @rep:paraminfo {@rep:required}
1650: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1651: * @rep:paraminfo {@rep:required}
1652: * @param x_msg_count API standard: number of error messages
1653: * @rep:paraminfo {@rep:required}
1654: * @param x_msg_data API standard: error message
1655: * @rep:paraminfo {@rep:required}
1656: * @rep:scope public
1650: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1651: * @rep:paraminfo {@rep:required}
1652: * @param x_msg_count API standard: number of error messages
1653: * @rep:paraminfo {@rep:required}
1654: * @param x_msg_data API standard: error message
1655: * @rep:paraminfo {@rep:required}
1656: * @rep:scope public
1657: * @rep:lifecycle active
1658: * @rep:displayname Create Requirement Competence
1675: * Description: This procedure enables you to update competences for
1676: * project requirements.
1677: * Parameters:
1678: * Parameter Name Null? Description
1679: * P_COMMIT NULL API standard (default = F)
1680: * P_INIT_MSG_LIST NULL API standard (default = T)
1681: * P_API_VERSION_NUMBER NOT NULL API standard
1682: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1683: * see the COMPETENCE_IN_TBL_TYPE
1676: * project requirements.
1677: * Parameters:
1678: * Parameter Name Null? Description
1679: * P_COMMIT NULL API standard (default = F)
1680: * P_INIT_MSG_LIST NULL API standard (default = T)
1681: * P_API_VERSION_NUMBER NOT NULL API standard
1682: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1683: * see the COMPETENCE_IN_TBL_TYPE
1684: * datatype table.
1677: * Parameters:
1678: * Parameter Name Null? Description
1679: * P_COMMIT NULL API standard (default = F)
1680: * P_INIT_MSG_LIST NULL API standard (default = T)
1681: * P_API_VERSION_NUMBER NOT NULL API standard
1682: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1683: * see the COMPETENCE_IN_TBL_TYPE
1684: * datatype table.
1685: * X_RETURN_STATUS N/A The return status of the API. Valid
1692: * error exists
1693: */
1694: /*#
1695: * This is a public API to update one or more competences for one or more project requirements
1696: * @param p_api_version_number API standard version number
1697: * @rep:paraminfo {@rep:required}
1698: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1699: * @param p_commit API standard (default = F): indicates if transaction will be committed
1700: * @param p_competence_in_tbl Table of competence records
1694: /*#
1695: * This is a public API to update one or more competences for one or more project requirements
1696: * @param p_api_version_number API standard version number
1697: * @rep:paraminfo {@rep:required}
1698: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1699: * @param p_commit API standard (default = F): indicates if transaction will be committed
1700: * @param p_competence_in_tbl Table of competence records
1701: * @rep:paraminfo {@rep:required}
1702: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1695: * This is a public API to update one or more competences for one or more project requirements
1696: * @param p_api_version_number API standard version number
1697: * @rep:paraminfo {@rep:required}
1698: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1699: * @param p_commit API standard (default = F): indicates if transaction will be committed
1700: * @param p_competence_in_tbl Table of competence records
1701: * @rep:paraminfo {@rep:required}
1702: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1703: * @rep:paraminfo {@rep:required}
1698: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1699: * @param p_commit API standard (default = F): indicates if transaction will be committed
1700: * @param p_competence_in_tbl Table of competence records
1701: * @rep:paraminfo {@rep:required}
1702: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1703: * @rep:paraminfo {@rep:required}
1704: * @param x_msg_count API standard: number of error messages
1705: * @rep:paraminfo {@rep:required}
1706: * @param x_msg_data API standard: error message
1700: * @param p_competence_in_tbl Table of competence records
1701: * @rep:paraminfo {@rep:required}
1702: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1703: * @rep:paraminfo {@rep:required}
1704: * @param x_msg_count API standard: number of error messages
1705: * @rep:paraminfo {@rep:required}
1706: * @param x_msg_data API standard: error message
1707: * @rep:paraminfo {@rep:required}
1708: * @rep:scope public
1702: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1703: * @rep:paraminfo {@rep:required}
1704: * @param x_msg_count API standard: number of error messages
1705: * @rep:paraminfo {@rep:required}
1706: * @param x_msg_data API standard: error message
1707: * @rep:paraminfo {@rep:required}
1708: * @rep:scope public
1709: * @rep:lifecycle active
1710: * @rep:displayname Update Requirement Competence
1727: * Description: This procedure enables you to delete competences for
1728: * project requirements.
1729: * Parameters:
1730: * Parameter Name Null? Description
1731: * P_COMMIT NULL API standard (default = F)
1732: * P_INIT_MSG_LIST NULL API standard (default = T)
1733: * P_API_VERSION_NUMBER NOT NULL API standard
1734: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1735: * see the COMPETENCE_IN_TBL_TYPE
1728: * project requirements.
1729: * Parameters:
1730: * Parameter Name Null? Description
1731: * P_COMMIT NULL API standard (default = F)
1732: * P_INIT_MSG_LIST NULL API standard (default = T)
1733: * P_API_VERSION_NUMBER NOT NULL API standard
1734: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1735: * see the COMPETENCE_IN_TBL_TYPE
1736: * datatype table.
1729: * Parameters:
1730: * Parameter Name Null? Description
1731: * P_COMMIT NULL API standard (default = F)
1732: * P_INIT_MSG_LIST NULL API standard (default = T)
1733: * P_API_VERSION_NUMBER NOT NULL API standard
1734: * P_COMPETENCE_IN_TBL NOT NULL Table of competence records. Please
1735: * see the COMPETENCE_IN_TBL_TYPE
1736: * datatype table.
1737: * X_RETURN_STATUS N/A The return status of the API. Valid
1744: * error exists
1745: */
1746: /*#
1747: * This is a public API to delete one or more competences for one or more project requirements.
1748: * @param p_api_version_number API standard version number
1749: * @rep:paraminfo {@rep:required}
1750: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1751: * @param p_commit API standard (default = F): indicates if transaction will be committed
1752: * @param p_competence_in_tbl Table of competence records
1746: /*#
1747: * This is a public API to delete one or more competences for one or more project requirements.
1748: * @param p_api_version_number API standard version number
1749: * @rep:paraminfo {@rep:required}
1750: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1751: * @param p_commit API standard (default = F): indicates if transaction will be committed
1752: * @param p_competence_in_tbl Table of competence records
1753: * @rep:paraminfo {@rep:required}
1754: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1747: * This is a public API to delete one or more competences for one or more project requirements.
1748: * @param p_api_version_number API standard version number
1749: * @rep:paraminfo {@rep:required}
1750: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1751: * @param p_commit API standard (default = F): indicates if transaction will be committed
1752: * @param p_competence_in_tbl Table of competence records
1753: * @rep:paraminfo {@rep:required}
1754: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1755: * @rep:paraminfo {@rep:required}
1750: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1751: * @param p_commit API standard (default = F): indicates if transaction will be committed
1752: * @param p_competence_in_tbl Table of competence records
1753: * @rep:paraminfo {@rep:required}
1754: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1755: * @rep:paraminfo {@rep:required}
1756: * @param x_msg_count API standard: number of error messages
1757: * @rep:paraminfo {@rep:required}
1758: * @param x_msg_data API standard: error message
1752: * @param p_competence_in_tbl Table of competence records
1753: * @rep:paraminfo {@rep:required}
1754: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1755: * @rep:paraminfo {@rep:required}
1756: * @param x_msg_count API standard: number of error messages
1757: * @rep:paraminfo {@rep:required}
1758: * @param x_msg_data API standard: error message
1759: * @rep:paraminfo {@rep:required}
1760: * @rep:scope public
1754: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1755: * @rep:paraminfo {@rep:required}
1756: * @param x_msg_count API standard: number of error messages
1757: * @rep:paraminfo {@rep:required}
1758: * @param x_msg_data API standard: error message
1759: * @rep:paraminfo {@rep:required}
1760: * @rep:scope public
1761: * @rep:lifecycle active
1762: * @rep:displayname Delete Requirement Competence
1780: * Description: This procedure enables you to nominate candidates for
1781: * project requirements.
1782: * Parameters:
1783: * Parameter Name Null? Description
1784: * P_COMMIT NULL API standard (default = F)
1785: * P_INIT_MSG_LIST NULL API standard (default = T)
1786: * P_API_VERSION_NUMBER NOT NULL API standard
1787: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1788: * the CANDIDATE_IN_TBL_TYPE datatype table.
1781: * project requirements.
1782: * Parameters:
1783: * Parameter Name Null? Description
1784: * P_COMMIT NULL API standard (default = F)
1785: * P_INIT_MSG_LIST NULL API standard (default = T)
1786: * P_API_VERSION_NUMBER NOT NULL API standard
1787: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1788: * the CANDIDATE_IN_TBL_TYPE datatype table.
1789: * X_CANDIDATE_ID_TBL N/A Table to store the candidate IDs
1782: * Parameters:
1783: * Parameter Name Null? Description
1784: * P_COMMIT NULL API standard (default = F)
1785: * P_INIT_MSG_LIST NULL API standard (default = T)
1786: * P_API_VERSION_NUMBER NOT NULL API standard
1787: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1788: * the CANDIDATE_IN_TBL_TYPE datatype table.
1789: * X_CANDIDATE_ID_TBL N/A Table to store the candidate IDs
1790: * created by the API.
1799: * error exists
1800: */
1801: /*#
1802: * This is a public API to create/nominate one or more candidates for project requirements
1803: * @param p_api_version_number API standard version number
1804: * @rep:paraminfo {@rep:required}
1805: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1806: * @param p_commit API standard (default = F): indicates if transaction will be committed
1807: * @param p_candidate_in_tbl Table of candidate records
1801: /*#
1802: * This is a public API to create/nominate one or more candidates for project requirements
1803: * @param p_api_version_number API standard version number
1804: * @rep:paraminfo {@rep:required}
1805: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1806: * @param p_commit API standard (default = F): indicates if transaction will be committed
1807: * @param p_candidate_in_tbl Table of candidate records
1808: * @rep:paraminfo {@rep:required}
1809: * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1802: * This is a public API to create/nominate one or more candidates for project requirements
1803: * @param p_api_version_number API standard version number
1804: * @rep:paraminfo {@rep:required}
1805: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1806: * @param p_commit API standard (default = F): indicates if transaction will be committed
1807: * @param p_candidate_in_tbl Table of candidate records
1808: * @rep:paraminfo {@rep:required}
1809: * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1810: * @rep:paraminfo {@rep:required}
1807: * @param p_candidate_in_tbl Table of candidate records
1808: * @rep:paraminfo {@rep:required}
1809: * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1810: * @rep:paraminfo {@rep:required}
1811: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1812: * @rep:paraminfo {@rep:required}
1813: * @param x_msg_count API standard: number of error messages
1814: * @rep:paraminfo {@rep:required}
1815: * @param x_msg_data API standard: error message
1809: * @param x_candidate_id_tbl Table to store the candidate IDs created by the API.
1810: * @rep:paraminfo {@rep:required}
1811: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1812: * @rep:paraminfo {@rep:required}
1813: * @param x_msg_count API standard: number of error messages
1814: * @rep:paraminfo {@rep:required}
1815: * @param x_msg_data API standard: error message
1816: * @rep:paraminfo {@rep:required}
1817: * @rep:scope public
1811: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1812: * @rep:paraminfo {@rep:required}
1813: * @param x_msg_count API standard: number of error messages
1814: * @rep:paraminfo {@rep:required}
1815: * @param x_msg_data API standard: error message
1816: * @rep:paraminfo {@rep:required}
1817: * @rep:scope public
1818: * @rep:lifecycle active
1819: * @rep:displayname Create Candidates
1837: * Description: This procedure enables you to update the candidates for
1838: * project requirements.
1839: * Parameters:
1840: * Parameter Name Null? Description
1841: * P_COMMIT NULL API standard (default = F)
1842: * P_INIT_MSG_LIST NULL API standard (default = T)
1843: * P_API_VERSION_NUMBER NOT NULL API standard
1844: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1845: * the CANDIDATE_IN_TBL_TYPE datatype table.
1838: * project requirements.
1839: * Parameters:
1840: * Parameter Name Null? Description
1841: * P_COMMIT NULL API standard (default = F)
1842: * P_INIT_MSG_LIST NULL API standard (default = T)
1843: * P_API_VERSION_NUMBER NOT NULL API standard
1844: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1845: * the CANDIDATE_IN_TBL_TYPE datatype table.
1846: * X_RETURN_STATUS N/A The return status of the API. Valid
1839: * Parameters:
1840: * Parameter Name Null? Description
1841: * P_COMMIT NULL API standard (default = F)
1842: * P_INIT_MSG_LIST NULL API standard (default = T)
1843: * P_API_VERSION_NUMBER NOT NULL API standard
1844: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1845: * the CANDIDATE_IN_TBL_TYPE datatype table.
1846: * X_RETURN_STATUS N/A The return status of the API. Valid
1847: * values are: S (success)
1853: * error exists
1854: */
1855: /*#
1856: * This is a public API to update one or more candidates for project requirements
1857: * @param p_api_version_number API standard version number
1858: * @rep:paraminfo {@rep:required}
1859: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1860: * @param p_commit API standard (default = F): indicates if transaction will be committed
1861: * @param p_candidate_in_tbl Table of candidate records
1855: /*#
1856: * This is a public API to update one or more candidates for project requirements
1857: * @param p_api_version_number API standard version number
1858: * @rep:paraminfo {@rep:required}
1859: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1860: * @param p_commit API standard (default = F): indicates if transaction will be committed
1861: * @param p_candidate_in_tbl Table of candidate records
1862: * @rep:paraminfo {@rep:required}
1863: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1856: * This is a public API to update one or more candidates for project requirements
1857: * @param p_api_version_number API standard version number
1858: * @rep:paraminfo {@rep:required}
1859: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1860: * @param p_commit API standard (default = F): indicates if transaction will be committed
1861: * @param p_candidate_in_tbl Table of candidate records
1862: * @rep:paraminfo {@rep:required}
1863: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1864: * @rep:paraminfo {@rep:required}
1859: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1860: * @param p_commit API standard (default = F): indicates if transaction will be committed
1861: * @param p_candidate_in_tbl Table of candidate records
1862: * @rep:paraminfo {@rep:required}
1863: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1864: * @rep:paraminfo {@rep:required}
1865: * @param x_msg_count API standard: number of error messages
1866: * @rep:paraminfo {@rep:required}
1867: * @param x_msg_data API standard: error message
1861: * @param p_candidate_in_tbl Table of candidate records
1862: * @rep:paraminfo {@rep:required}
1863: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1864: * @rep:paraminfo {@rep:required}
1865: * @param x_msg_count API standard: number of error messages
1866: * @rep:paraminfo {@rep:required}
1867: * @param x_msg_data API standard: error message
1868: * @rep:paraminfo {@rep:required}
1869: * @rep:scope public
1863: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1864: * @rep:paraminfo {@rep:required}
1865: * @param x_msg_count API standard: number of error messages
1866: * @rep:paraminfo {@rep:required}
1867: * @param x_msg_data API standard: error message
1868: * @rep:paraminfo {@rep:required}
1869: * @rep:scope public
1870: * @rep:lifecycle active
1871: * @rep:displayname Update Candidates
1888: * Description: This procedure enables you to delete candidates from
1889: * project requirements.
1890: * Parameters:
1891: * Parameter Name Null? Description
1892: * P_COMMIT NULL API standard (default = F)
1893: * P_INIT_MSG_LIST NULL API standard (default = T)
1894: * P_API_VERSION_NUMBER NOT NULL API standard
1895: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1896: * the CANDIDATE_IN_TBL_TYPE datatype table.
1889: * project requirements.
1890: * Parameters:
1891: * Parameter Name Null? Description
1892: * P_COMMIT NULL API standard (default = F)
1893: * P_INIT_MSG_LIST NULL API standard (default = T)
1894: * P_API_VERSION_NUMBER NOT NULL API standard
1895: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1896: * the CANDIDATE_IN_TBL_TYPE datatype table.
1897: * X_RETURN_STATUS N/A The return status of the API. Valid
1890: * Parameters:
1891: * Parameter Name Null? Description
1892: * P_COMMIT NULL API standard (default = F)
1893: * P_INIT_MSG_LIST NULL API standard (default = T)
1894: * P_API_VERSION_NUMBER NOT NULL API standard
1895: * P_CANDIDATE_IN_TBL NOT NULL Table of candidate records. Please see
1896: * the CANDIDATE_IN_TBL_TYPE datatype table.
1897: * X_RETURN_STATUS N/A The return status of the API. Valid
1898: * values are: S (success)
1904: * error exists
1905: */
1906: /*#
1907: * This is a public API to delete one or more candidates for project requirements.
1908: * @param p_api_version_number API standard version number
1909: * @rep:paraminfo {@rep:required}
1910: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1911: * @param p_commit API standard (default = F): indicates if transaction will be committed
1912: * @param p_candidate_in_tbl Table of candidate records
1906: /*#
1907: * This is a public API to delete one or more candidates for project requirements.
1908: * @param p_api_version_number API standard version number
1909: * @rep:paraminfo {@rep:required}
1910: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1911: * @param p_commit API standard (default = F): indicates if transaction will be committed
1912: * @param p_candidate_in_tbl Table of candidate records
1913: * @rep:paraminfo {@rep:required}
1914: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1907: * This is a public API to delete one or more candidates for project requirements.
1908: * @param p_api_version_number API standard version number
1909: * @rep:paraminfo {@rep:required}
1910: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1911: * @param p_commit API standard (default = F): indicates if transaction will be committed
1912: * @param p_candidate_in_tbl Table of candidate records
1913: * @rep:paraminfo {@rep:required}
1914: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1915: * @rep:paraminfo {@rep:required}
1910: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1911: * @param p_commit API standard (default = F): indicates if transaction will be committed
1912: * @param p_candidate_in_tbl Table of candidate records
1913: * @rep:paraminfo {@rep:required}
1914: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1915: * @rep:paraminfo {@rep:required}
1916: * @param x_msg_count API standard: number of error messages
1917: * @rep:paraminfo {@rep:required}
1918: * @param x_msg_data API standard: error message
1912: * @param p_candidate_in_tbl Table of candidate records
1913: * @rep:paraminfo {@rep:required}
1914: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1915: * @rep:paraminfo {@rep:required}
1916: * @param x_msg_count API standard: number of error messages
1917: * @rep:paraminfo {@rep:required}
1918: * @param x_msg_data API standard: error message
1919: * @rep:paraminfo {@rep:required}
1920: * @rep:scope public
1914: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1915: * @rep:paraminfo {@rep:required}
1916: * @param x_msg_count API standard: number of error messages
1917: * @rep:paraminfo {@rep:required}
1918: * @param x_msg_data API standard: error message
1919: * @rep:paraminfo {@rep:required}
1920: * @rep:scope public
1921: * @rep:lifecycle active
1922: * @rep:displayname Delete Candidates
1939: * Description: This procedure creates a log for one or more candidates for
1940: * project requirements.
1941: * Parameters:
1942: * Parameter Name Null? Description
1943: * P_COMMIT NULL API standard (default = F)
1944: * P_INIT_MSG_LIST NULL API standard (default = T)
1945: * P_API_VERSION_NUMBER NOT NULL API standard
1946: * P_CANDIDATE_LOG_TBL NOT NULL Table of candidate review records.
1947: * Please see the CANDIDATE_LOG_TBL_TYPE
1940: * project requirements.
1941: * Parameters:
1942: * Parameter Name Null? Description
1943: * P_COMMIT NULL API standard (default = F)
1944: * P_INIT_MSG_LIST NULL API standard (default = T)
1945: * P_API_VERSION_NUMBER NOT NULL API standard
1946: * P_CANDIDATE_LOG_TBL NOT NULL Table of candidate review records.
1947: * Please see the CANDIDATE_LOG_TBL_TYPE
1948: * datatype table.
1941: * Parameters:
1942: * Parameter Name Null? Description
1943: * P_COMMIT NULL API standard (default = F)
1944: * P_INIT_MSG_LIST NULL API standard (default = T)
1945: * P_API_VERSION_NUMBER NOT NULL API standard
1946: * P_CANDIDATE_LOG_TBL NOT NULL Table of candidate review records.
1947: * Please see the CANDIDATE_LOG_TBL_TYPE
1948: * datatype table.
1949: * X_CANDIDATE_REVIEW_ID_TBL N/A Table to store the candidate review IDs
1959: * error exists
1960: */
1961: /*#
1962: * This is a public API to create log for one or more candidates for project requirements.
1963: * @param p_api_version_number API standard version number
1964: * @rep:paraminfo {@rep:required}
1965: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1966: * @param p_commit API standard (default = F): indicates if transaction will be committed
1967: * @param p_candidate_log_tbl Table of candidate review records
1961: /*#
1962: * This is a public API to create log for one or more candidates for project requirements.
1963: * @param p_api_version_number API standard version number
1964: * @rep:paraminfo {@rep:required}
1965: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1966: * @param p_commit API standard (default = F): indicates if transaction will be committed
1967: * @param p_candidate_log_tbl Table of candidate review records
1968: * @rep:paraminfo {@rep:required}
1969: * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
1962: * This is a public API to create log for one or more candidates for project requirements.
1963: * @param p_api_version_number API standard version number
1964: * @rep:paraminfo {@rep:required}
1965: * @param p_init_msg_list API standard (default = T): indicates if message stack will be initialized
1966: * @param p_commit API standard (default = F): indicates if transaction will be committed
1967: * @param p_candidate_log_tbl Table of candidate review records
1968: * @rep:paraminfo {@rep:required}
1969: * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
1970: * @rep:paraminfo {@rep:required}
1967: * @param p_candidate_log_tbl Table of candidate review records
1968: * @rep:paraminfo {@rep:required}
1969: * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
1970: * @rep:paraminfo {@rep:required}
1971: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1972: * @rep:paraminfo {@rep:required}
1973: * @param x_msg_count API standard: number of error messages
1974: * @rep:paraminfo {@rep:required}
1975: * @param x_msg_data API standard: error message
1969: * @param x_candidate_review_id_tbl Table to store the candidate review IDs created by the API
1970: * @rep:paraminfo {@rep:required}
1971: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1972: * @rep:paraminfo {@rep:required}
1973: * @param x_msg_count API standard: number of error messages
1974: * @rep:paraminfo {@rep:required}
1975: * @param x_msg_data API standard: error message
1976: * @rep:paraminfo {@rep:required}
1977: * @rep:scope public
1971: * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1972: * @rep:paraminfo {@rep:required}
1973: * @param x_msg_count API standard: number of error messages
1974: * @rep:paraminfo {@rep:required}
1975: * @param x_msg_data API standard: error message
1976: * @rep:paraminfo {@rep:required}
1977: * @rep:scope public
1978: * @rep:lifecycle active
1979: * @rep:displayname Create Candidate Log