DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_TERMS_QA_PVT

Line 7544: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

7540: */
7541: PROCEDURE check_notifications (
7542: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7543: p_severity IN VARCHAR2,
7544: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
7545: x_return_status OUT NOCOPY VARCHAR2
7546: ) IS
7547:
7548: l_api_version CONSTANT NUMBER := 1;

Line 7551: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

7547:
7548: l_api_version CONSTANT NUMBER := 1;
7549: l_api_name CONSTANT VARCHAR2(30) := 'check_notifications';
7550: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7551: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7552: l_index PLS_INTEGER := 0;
7553: l_start PLS_INTEGER := 0;
7554: l_message_txt VARCHAR2(2000);
7555: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

Line 7690: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

7686: */
7687: PROCEDURE check_internal_contacts (
7688: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7689: p_severity IN VARCHAR2,
7690: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
7691: x_return_status OUT NOCOPY VARCHAR2
7692: ) IS
7693:
7694: l_api_version CONSTANT NUMBER := 1;

Line 7697: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

7693:
7694: l_api_version CONSTANT NUMBER := 1;
7695: l_api_name CONSTANT VARCHAR2(30) := 'check_internal_contacts';
7696: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7697: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7698: l_index PLS_INTEGER := 0;
7699: l_start PLS_INTEGER := 0;
7700: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7701: l_contact_exists VARCHAR2(1);

Line 7945: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

7941:
7942: PROCEDURE check_exhibit_details (
7943: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7944: p_severity IN VARCHAR2,
7945: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
7946: x_return_status OUT NOCOPY VARCHAR2
7947: )
7948: IS
7949: l_api_version CONSTANT NUMBER := 1;

Line 7952: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

7948: IS
7949: l_api_version CONSTANT NUMBER := 1;
7950: l_api_name CONSTANT VARCHAR2(30) := 'check_exhibit_details';
7951: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7952: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7953: l_index PLS_INTEGER := 0;
7954: l_start PLS_INTEGER := 0;
7955: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7956: l_contact_exists VARCHAR2(1);

Line 8083: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

8079: */
8080: PROCEDURE check_internal_contacts_valid (
8081: del_rec IN OKC_DELIVERABLES%ROWTYPE,
8082: p_severity IN VARCHAR2,
8083: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
8084: x_return_status OUT NOCOPY VARCHAR2
8085: ) IS
8086:
8087: l_api_version CONSTANT NUMBER := 1;

Line 8090: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

8086:
8087: l_api_version CONSTANT NUMBER := 1;
8088: l_api_name CONSTANT VARCHAR2(30) := 'check_internal_contacts_valid';
8089: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8090: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8091: l_index PLS_INTEGER := 0;
8092: l_start PLS_INTEGER := 0;
8093: l_message_txt VARCHAR2(2000);
8094: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

Line 8277: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

8273: */
8274: PROCEDURE check_external_contacts (
8275: del_rec IN OKC_DELIVERABLES%ROWTYPE,
8276: p_severity IN VARCHAR2,
8277: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
8278: x_return_status OUT NOCOPY VARCHAR2
8279: ) IS
8280:
8281: l_api_version CONSTANT NUMBER := 1;

Line 8284: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

8280:
8281: l_api_version CONSTANT NUMBER := 1;
8282: l_api_name CONSTANT VARCHAR2(30) := 'check_external_contacts';
8283: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8284: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8285: l_index PLS_INTEGER := 0;
8286: l_start PLS_INTEGER := 0;
8287: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
8288: l_contact_exists VARCHAR2(1);

Line 8456: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

8452: del_rec IN OKC_DELIVERABLES%ROWTYPE,
8453: p_severity IN VARCHAR2,
8454: p_bus_doc_date_events_tbl IN OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE,
8455: p_doc_type IN VARCHAR2, --Acq plan Messages Cleanup
8456: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
8457: x_return_status OUT NOCOPY VARCHAR2
8458: ) IS
8459:
8460: l_api_version CONSTANT NUMBER := 1;

Line 8463: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

8459:
8460: l_api_version CONSTANT NUMBER := 1;
8461: l_api_name CONSTANT VARCHAR2(30) := 'check_due_dates';
8462: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8463: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8464: l_index PLS_INTEGER := 0;
8465: l_start PLS_INTEGER := 0;
8466: l_message_txt VARCHAR2(2000);
8467: l_qa_code VARCHAR2(80) := 'CHECK_DUE_DATES';

Line 8892: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

8888: */
8889: PROCEDURE check_amendments (
8890: del_rec IN OKC_DELIVERABLES%ROWTYPE,
8891: p_severity IN VARCHAR2,
8892: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
8893: x_return_status OUT NOCOPY VARCHAR2
8894: ) IS
8895:
8896: l_api_version CONSTANT NUMBER := 1;

Line 8899: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

8895:
8896: l_api_version CONSTANT NUMBER := 1;
8897: l_api_name CONSTANT VARCHAR2(30) := 'check_amendments';
8898: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8899: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8900: l_index PLS_INTEGER := 0;
8901: l_start PLS_INTEGER := 0;
8902: l_message_txt VARCHAR2(2000);
8903: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

Line 9008: (px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

9004:
9005: END check_amendments;
9006:
9007: PROCEDURE update_error_table
9008: (px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
9009: p_qa_severity IN VARCHAR2,
9010: p_qa_code IN VARCHAR2,
9011: p_error_msg_name IN VARCHAR2,
9012: p_del_variable_name IN VARCHAR2,

Line 9068: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

9064: PROCEDURE check_deliverables_var_usage(
9065: p_severity IN VARCHAR2,
9066: p_bus_doc_type IN VARCHAR2,
9067: p_bus_doc_id IN NUMBER,
9068: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
9069: x_return_status OUT NOCOPY VARCHAR2) IS
9070:
9071: l_api_version CONSTANT NUMBER := 1;
9072: l_api_name CONSTANT VARCHAR2(30) := 'check_deliverables_var_usage';

Line 9074: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

9070:
9071: l_api_version CONSTANT NUMBER := 1;
9072: l_api_name CONSTANT VARCHAR2(30) := 'check_deliverables_var_usage';
9073: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
9074: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
9075: l_index PLS_INTEGER := 0;
9076: l_start PLS_INTEGER := 0;
9077: l_message_txt VARCHAR2(2000);
9078: l_qa_code VARCHAR2(80) := 'CHECK_DELIVERABLES_VAR_USAGE';

Line 9425: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

9421: ***********************/
9422: PROCEDURE check_external_party_exists (
9423: del_rec IN OKC_DELIVERABLES%ROWTYPE,
9424: p_severity IN VARCHAR2,
9425: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
9426: x_return_status OUT NOCOPY VARCHAR2
9427: ) IS
9428:
9429: l_api_version CONSTANT NUMBER := 1;

Line 9432: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

9428:
9429: l_api_version CONSTANT NUMBER := 1;
9430: l_api_name CONSTANT VARCHAR2(30) := 'check_external_party_exists';
9431: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
9432: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
9433: l_index PLS_INTEGER := 0;
9434: l_start PLS_INTEGER := 0;
9435:
9436: l_qa_code VARCHAR2(80) := 'CHECK_EXTERNAL_PARTY_EXISTS';

Line 9569: p_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

9565: p_doc_type IN VARCHAR2,
9566: p_doc_id IN NUMBER,
9567: p_mode IN VARCHAR2,
9568: p_bus_doc_date_events_tbl IN OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE,
9569: p_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
9570: x_msg_data OUT NOCOPY VARCHAR2,
9571: x_msg_count OUT NOCOPY NUMBER,
9572: x_return_status OUT NOCOPY VARCHAR2,
9573: x_qa_return_status IN OUT NOCOPY VARCHAR2)

Line 9582: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

9578: l_qa_severity_warning CONSTANT VARCHAR2(1) := 'W';
9579: l_qa_severity_error CONSTANT VARCHAR2(1) := 'E';
9580:
9581: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
9582: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
9583:
9584: l_start PLS_INTEGER := 0;
9585: l_end PLS_INTEGER := 0;
9586: del_cur del_cur_type;