DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on FND_API

Line 47: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

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;

Line 48: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

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';

Line 49: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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';

Line 50: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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';

Line 51: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 97: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

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,

Line 168: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

164: internal_party_contact_id,
165: ***/
166: PROCEDURE copy_deliverables (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
169: p_source_doc_id IN NUMBER,
170: p_source_doc_type IN VARCHAR2,
171: p_target_doc_id IN NUMBER,
172: p_target_doc_type IN VARCHAR2,

Line 361: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

357: delete the deliverable, status history and attachments.
358: ***/
359: PROCEDURE purge_doc_deliverables (
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
362: p_doc_table IN OKC_TERMS_UTIL_GRP.doc_tbl_type,
363: x_msg_data OUT NOCOPY VARCHAR2,
364: x_msg_count OUT NOCOPY NUMBER,
365: x_return_status OUT NOCOPY VARCHAR2);

Line 413: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

409: **/
410:
411: FUNCTION get_last_amendment_date (
412: p_api_version IN NUMBER
413: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
414:
415: ,x_return_status OUT NOCOPY VARCHAR2
416: ,x_msg_data OUT NOCOPY VARCHAR2
417: ,x_msg_count OUT NOCOPY NUMBER

Line 446: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

442: * any error or warning is found on the deliverables on the bus doc.
443: */
444: PROCEDURE validate_deliverable_for_qa (
445: p_api_version IN NUMBER,
446: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
447: p_doc_type IN VARCHAR2,
448: p_doc_id IN NUMBER,
449: p_mode IN VARCHAR2,
450: p_bus_doc_date_events_tbl IN OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE,

Line 479: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

475: x_return_status OUT NOCOPY VARCHAR2);
476:
477: PROCEDURE delete_del_status_hist_attach(
478: p_api_version IN NUMBER,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
480: p_deliverable_id IN NUMBER,
481: p_bus_doc_id IN NUMBER,
482: p_bus_doc_version IN NUMBER,
483: p_bus_doc_type IN VARCHAR2,

Line 551: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

547:
548: FUNCTION deliverables_exist
549: (
550: p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
552: x_return_status OUT NOCOPY VARCHAR2,
553: x_msg_data OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: p_doctype IN VARCHAR2,

Line 617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

613:
614:
615: FUNCTION deliverables_amended (
616: p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618:
619: x_return_status OUT NOCOPY VARCHAR2,
620: x_msg_data OUT NOCOPY VARCHAR2,
621: x_msg_count OUT NOCOPY NUMBER,

Line 661: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

657: ***/
658:
659: PROCEDURE copy_response_deliverables (
660: p_api_version IN NUMBER,
661: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
662: p_source_doc_id IN NUMBER,
663: p_source_doc_type IN VARCHAR2,
664: p_target_doc_id IN NUMBER,
665: p_target_doc_type IN VARCHAR2,

Line 696: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

692: to the variable.
693: ***/
694: FUNCTION deliverable_amendment_exists (
695: p_api_version IN NUMBER,
696: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
697: p_bus_doc_type IN VARCHAR2,
698: p_bus_doc_id IN NUMBER,
699: p_variable_code IN VARCHAR2,
700: x_msg_data OUT NOCOPY VARCHAR2,

Line 724: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

720:
721: -- bug#4075168 New API for Template Revision
722: PROCEDURE CopyDelForTemplateRevision(
723: p_api_version IN NUMBER,
724: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
725: p_source_doc_id IN NUMBER,
726: p_source_doc_type IN VARCHAR2,
727: p_target_doc_id IN NUMBER,
728: p_target_doc_type IN VARCHAR2,

Line 747: -- Default = FND_API.G_FALSE

743: --Pre-reqs : None.
744: --Parameters :
745: --IN : p_api_version IN NUMBER Required
746: -- : p_init_msg_list IN VARCHAR2 Optional
747: -- Default = FND_API.G_FALSE
748: -- : p_commit IN VARCHAR2 Optional
749: -- Default = FND_API.G_FALSE
750: -- : p_bus_doc_id IN NUMBER Required
751: -- Contract ID of the contract to be deleted

Line 749: -- Default = FND_API.G_FALSE

745: --IN : p_api_version IN NUMBER Required
746: -- : p_init_msg_list IN VARCHAR2 Optional
747: -- Default = FND_API.G_FALSE
748: -- : p_commit IN VARCHAR2 Optional
749: -- Default = FND_API.G_FALSE
750: -- : p_bus_doc_id IN NUMBER Required
751: -- Contract ID of the contract to be deleted
752: -- : p_bus_doc_type IN VARCHAR2 Required
753: -- Type of the contract to be deleted

Line 772: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

768: --Note :
769: -- End of comments
770: PROCEDURE deleteDeliverables(
771: p_api_version IN NUMBER,
772: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
773: p_commit IN VARCHAR2:=FND_API.G_FALSE,
774: p_bus_doc_id IN NUMBER,
775: p_bus_doc_type IN VARCHAR2,
776: p_bus_doc_version IN NUMBER,

Line 773: p_commit IN VARCHAR2:=FND_API.G_FALSE,

769: -- End of comments
770: PROCEDURE deleteDeliverables(
771: p_api_version IN NUMBER,
772: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
773: p_commit IN VARCHAR2:=FND_API.G_FALSE,
774: p_bus_doc_id IN NUMBER,
775: p_bus_doc_type IN VARCHAR2,
776: p_bus_doc_version IN NUMBER,
777: p_prev_del_active IN VARCHAR2 := 'N',