DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_TERMS_QA_PVT

Line 7143: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

7139: */
7140: PROCEDURE check_notifications (
7141: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7142: p_severity IN VARCHAR2,
7143: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
7144: x_return_status OUT NOCOPY VARCHAR2
7145: ) IS
7146:
7147: l_api_version CONSTANT NUMBER := 1;

Line 7150: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

7146:
7147: l_api_version CONSTANT NUMBER := 1;
7148: l_api_name CONSTANT VARCHAR2(30) := 'check_notifications';
7149: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7150: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7151: l_index PLS_INTEGER := 0;
7152: l_start PLS_INTEGER := 0;
7153: l_message_txt VARCHAR2(2000);
7154: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

Line 7269: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

7265: */
7266: PROCEDURE check_internal_contacts (
7267: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7268: p_severity IN VARCHAR2,
7269: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
7270: x_return_status OUT NOCOPY VARCHAR2
7271: ) IS
7272:
7273: l_api_version CONSTANT NUMBER := 1;

Line 7276: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

7272:
7273: l_api_version CONSTANT NUMBER := 1;
7274: l_api_name CONSTANT VARCHAR2(30) := 'check_internal_contacts';
7275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7276: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7277: l_index PLS_INTEGER := 0;
7278: l_start PLS_INTEGER := 0;
7279: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7280: l_contact_exists VARCHAR2(1);

Line 7447: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

7443: */
7444: PROCEDURE check_internal_contacts_valid (
7445: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7446: p_severity IN VARCHAR2,
7447: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
7448: x_return_status OUT NOCOPY VARCHAR2
7449: ) IS
7450:
7451: l_api_version CONSTANT NUMBER := 1;

Line 7454: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

7450:
7451: l_api_version CONSTANT NUMBER := 1;
7452: l_api_name CONSTANT VARCHAR2(30) := 'check_internal_contacts_valid';
7453: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7454: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7455: l_index PLS_INTEGER := 0;
7456: l_start PLS_INTEGER := 0;
7457: l_message_txt VARCHAR2(2000);
7458: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

Line 7612: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

7608: */
7609: PROCEDURE check_external_contacts (
7610: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7611: p_severity IN VARCHAR2,
7612: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
7613: x_return_status OUT NOCOPY VARCHAR2
7614: ) IS
7615:
7616: l_api_version CONSTANT NUMBER := 1;

Line 7619: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

7615:
7616: l_api_version CONSTANT NUMBER := 1;
7617: l_api_name CONSTANT VARCHAR2(30) := 'check_external_contacts';
7618: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7619: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7620: l_index PLS_INTEGER := 0;
7621: l_start PLS_INTEGER := 0;
7622: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;
7623: l_contact_exists VARCHAR2(1);

Line 7753: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

7749: PROCEDURE check_due_dates (
7750: del_rec IN OKC_DELIVERABLES%ROWTYPE,
7751: p_severity IN VARCHAR2,
7752: p_bus_doc_date_events_tbl IN OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE,
7753: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
7754: x_return_status OUT NOCOPY VARCHAR2
7755: ) IS
7756:
7757: l_api_version CONSTANT NUMBER := 1;

Line 7760: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

7756:
7757: l_api_version CONSTANT NUMBER := 1;
7758: l_api_name CONSTANT VARCHAR2(30) := 'check_due_dates';
7759: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
7760: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
7761: l_index PLS_INTEGER := 0;
7762: l_start PLS_INTEGER := 0;
7763: l_message_txt VARCHAR2(2000);
7764: l_qa_code VARCHAR2(80) := 'CHECK_DUE_DATES';

Line 8121: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

8117: */
8118: PROCEDURE check_amendments (
8119: del_rec IN OKC_DELIVERABLES%ROWTYPE,
8120: p_severity IN VARCHAR2,
8121: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
8122: x_return_status OUT NOCOPY VARCHAR2
8123: ) IS
8124:
8125: l_api_version CONSTANT NUMBER := 1;

Line 8128: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

8124:
8125: l_api_version CONSTANT NUMBER := 1;
8126: l_api_name CONSTANT VARCHAR2(30) := 'check_amendments';
8127: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8128: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8129: l_index PLS_INTEGER := 0;
8130: l_start PLS_INTEGER := 0;
8131: l_message_txt VARCHAR2(2000);
8132: l_doc_type_class OKC_BUS_DOC_TYPES_B.document_type_class%TYPE;

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

8209:
8210: END check_amendments;
8211:
8212: PROCEDURE update_error_table
8213: (px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
8214: p_qa_severity IN VARCHAR2,
8215: p_qa_code IN VARCHAR2,
8216: p_error_msg_name IN VARCHAR2,
8217: p_del_variable_name IN VARCHAR2,

Line 8273: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

8269: PROCEDURE check_deliverables_var_usage(
8270: p_severity IN VARCHAR2,
8271: p_bus_doc_type IN VARCHAR2,
8272: p_bus_doc_id IN NUMBER,
8273: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
8274: x_return_status OUT NOCOPY VARCHAR2) IS
8275:
8276: l_api_version CONSTANT NUMBER := 1;
8277: l_api_name CONSTANT VARCHAR2(30) := 'check_deliverables_var_usage';

Line 8279: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

8275:
8276: l_api_version CONSTANT NUMBER := 1;
8277: l_api_name CONSTANT VARCHAR2(30) := 'check_deliverables_var_usage';
8278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8279: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8280: l_index PLS_INTEGER := 0;
8281: l_start PLS_INTEGER := 0;
8282: l_message_txt VARCHAR2(2000);
8283: l_qa_code VARCHAR2(80) := 'CHECK_DELIVERABLES_VAR_USAGE';

Line 8624: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

8620: ***********************/
8621: PROCEDURE check_external_party_exists (
8622: del_rec IN OKC_DELIVERABLES%ROWTYPE,
8623: p_severity IN VARCHAR2,
8624: px_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
8625: x_return_status OUT NOCOPY VARCHAR2
8626: ) IS
8627:
8628: l_api_version CONSTANT NUMBER := 1;

Line 8631: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

8627:
8628: l_api_version CONSTANT NUMBER := 1;
8629: l_api_name CONSTANT VARCHAR2(30) := 'check_external_party_exists';
8630: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8631: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8632: l_index PLS_INTEGER := 0;
8633: l_start PLS_INTEGER := 0;
8634:
8635: l_qa_code VARCHAR2(80) := 'CHECK_EXTERNAL_PARTY_EXISTS';

Line 8743: p_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,

8739: p_doc_type IN VARCHAR2,
8740: p_doc_id IN NUMBER,
8741: p_mode IN VARCHAR2,
8742: p_bus_doc_date_events_tbl IN OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE,
8743: p_qa_result_tbl IN OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type,
8744: x_msg_data OUT NOCOPY VARCHAR2,
8745: x_msg_count OUT NOCOPY NUMBER,
8746: x_return_status OUT NOCOPY VARCHAR2,
8747: x_qa_return_status IN OUT NOCOPY VARCHAR2)

Line 8756: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

8752: l_qa_severity_warning CONSTANT VARCHAR2(1) := 'W';
8753: l_qa_severity_error CONSTANT VARCHAR2(1) := 'E';
8754:
8755: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
8756: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
8757:
8758: l_start PLS_INTEGER := 0;
8759: l_end PLS_INTEGER := 0;
8760: del_cur del_cur_type;