43:
44: ------------------------------------------------------------------------------
45: -- GLOBAL CONSTANTS
46: ------------------------------------------------------------------------------
47: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
48: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
49: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
50: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
44: ------------------------------------------------------------------------------
45: -- GLOBAL CONSTANTS
46: ------------------------------------------------------------------------------
47: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
48: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
49: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
50: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
45: -- GLOBAL CONSTANTS
46: ------------------------------------------------------------------------------
47: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
48: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
49: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
50: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
53: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
46: ------------------------------------------------------------------------------
47: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
48: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
49: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
50: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
53: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
54: G_DLV_QA_TYPE CONSTANT VARCHAR2(30) := 'DELIVERABLE';
47: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
48: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
49: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
50: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
51: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
52: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
53: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
54: G_DLV_QA_TYPE CONSTANT VARCHAR2(30) := 'DELIVERABLE';
55:
93: ***/
94:
95: PROCEDURE copy_del_for_amendment (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
98: p_source_doc_id IN NUMBER,
99: p_source_doc_type IN VARCHAR2,
100: p_target_doc_id IN NUMBER,
101: p_target_doc_type IN VARCHAR2,
169: as a second step (of Sync process), we call copy, during which we should not copy the locked deliverables from award to mod.
170: ***/
171: PROCEDURE copy_deliverables (
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
174: p_source_doc_id IN NUMBER,
175: p_source_doc_type IN VARCHAR2,
176: p_target_doc_id IN NUMBER,
177: p_target_doc_type IN VARCHAR2,
365: delete the deliverable, status history and attachments.
366: ***/
367: PROCEDURE purge_doc_deliverables (
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
370: p_doc_table IN OKC_TERMS_UTIL_GRP.doc_tbl_type,
371: x_msg_data OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,
373: x_return_status OUT NOCOPY VARCHAR2);
426: **/
427:
428: FUNCTION get_last_amendment_date (
429: p_api_version IN NUMBER
430: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
431:
432: ,x_return_status OUT NOCOPY VARCHAR2
433: ,x_msg_data OUT NOCOPY VARCHAR2
434: ,x_msg_count OUT NOCOPY NUMBER
459: * any error or warning is found on the deliverables on the bus doc.
460: */
461: PROCEDURE validate_deliverable_for_qa (
462: p_api_version IN NUMBER,
463: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
464: p_doc_type IN VARCHAR2,
465: p_doc_id IN NUMBER,
466: p_mode IN VARCHAR2,
467: p_bus_doc_date_events_tbl IN OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE,
492: x_return_status OUT NOCOPY VARCHAR2);
493:
494: PROCEDURE delete_del_status_hist_attach(
495: p_api_version IN NUMBER,
496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497: p_deliverable_id IN NUMBER,
498: p_bus_doc_id IN NUMBER,
499: p_bus_doc_version IN NUMBER,
500: p_bus_doc_type IN VARCHAR2,
564:
565: FUNCTION deliverables_exist
566: (
567: p_api_version IN NUMBER,
568: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
569: x_return_status OUT NOCOPY VARCHAR2,
570: x_msg_data OUT NOCOPY VARCHAR2,
571: x_msg_count OUT NOCOPY NUMBER,
572: p_doctype IN VARCHAR2,
630:
631:
632: FUNCTION deliverables_amended (
633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635:
636: x_return_status OUT NOCOPY VARCHAR2,
637: x_msg_data OUT NOCOPY VARCHAR2,
638: x_msg_count OUT NOCOPY NUMBER,
674: ***/
675:
676: PROCEDURE copy_response_deliverables (
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
679: p_source_doc_id IN NUMBER,
680: p_source_doc_type IN VARCHAR2,
681: p_target_doc_id IN NUMBER,
682: p_target_doc_type IN VARCHAR2,
709: to the variable.
710: ***/
711: FUNCTION deliverable_amendment_exists (
712: p_api_version IN NUMBER,
713: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
714: p_bus_doc_type IN VARCHAR2,
715: p_bus_doc_id IN NUMBER,
716: p_variable_code IN VARCHAR2,
717: x_msg_data OUT NOCOPY VARCHAR2,
737:
738: -- bug#4075168 New API for Template Revision
739: PROCEDURE CopyDelForTemplateRevision(
740: p_api_version IN NUMBER,
741: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
742: p_source_doc_id IN NUMBER,
743: p_source_doc_type IN VARCHAR2,
744: p_target_doc_id IN NUMBER,
745: p_target_doc_type IN VARCHAR2,
760: --Pre-reqs : None.
761: --Parameters :
762: --IN : p_api_version IN NUMBER Required
763: -- : p_init_msg_list IN VARCHAR2 Optional
764: -- Default = FND_API.G_FALSE
765: -- : p_commit IN VARCHAR2 Optional
766: -- Default = FND_API.G_FALSE
767: -- : p_bus_doc_id IN NUMBER Required
768: -- Contract ID of the contract to be deleted
762: --IN : p_api_version IN NUMBER Required
763: -- : p_init_msg_list IN VARCHAR2 Optional
764: -- Default = FND_API.G_FALSE
765: -- : p_commit IN VARCHAR2 Optional
766: -- Default = FND_API.G_FALSE
767: -- : p_bus_doc_id IN NUMBER Required
768: -- Contract ID of the contract to be deleted
769: -- : p_bus_doc_type IN VARCHAR2 Required
770: -- Type of the contract to be deleted
785: --Note :
786: -- End of comments
787: PROCEDURE deleteDeliverables(
788: p_api_version IN NUMBER,
789: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
790: p_commit IN VARCHAR2:=FND_API.G_FALSE,
791: p_bus_doc_id IN NUMBER,
792: p_bus_doc_type IN VARCHAR2,
793: p_bus_doc_version IN NUMBER,
786: -- End of comments
787: PROCEDURE deleteDeliverables(
788: p_api_version IN NUMBER,
789: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
790: p_commit IN VARCHAR2:=FND_API.G_FALSE,
791: p_bus_doc_id IN NUMBER,
792: p_bus_doc_type IN VARCHAR2,
793: p_bus_doc_version IN NUMBER,
794: p_prev_del_active IN VARCHAR2 := 'N',