DBA Data[Home] [Help]

APPS.OKC_REP_CLOSEOUT_PVT dependencies on OKC_TERMS_QA_PVT

Line 597: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

593: l_warning_found Boolean := FALSE;
594: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
595: l_bus_doc_date_events_tbl OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE;
596: l_sequence_id NUMBER;
597: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
598:
599: CURSOR c_get_doc_details IS
600: SELECT orcu.business_document_type, orcu.business_document_id,
601: orca.contract_effective_date

Line 726: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');

722: END IF; -- l_qa_result_tbl.COUNT > 0 THEN
723:
724: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
726: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');
727: END IF;
728: -- Load eror in the DB table
729: OKC_TERMS_QA_PVT.Log_QA_Messages(
730: x_return_status => x_return_status,

Line 729: OKC_TERMS_QA_PVT.Log_QA_Messages(

725: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
726: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');
727: END IF;
728: -- Load eror in the DB table
729: OKC_TERMS_QA_PVT.Log_QA_Messages(
730: x_return_status => x_return_status,
731:
732: p_qa_result_tbl => l_qa_result_tbl,
733: x_sequence_id => x_sequence_id

Line 737: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');

733: x_sequence_id => x_sequence_id
734: );
735: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
736: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
737: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');
738: END IF;
739: --------------------------------------------
740: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1863: x_qa_result_tbl OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type)

1859: x_msg_data OUT NOCOPY VARCHAR2,
1860: x_msg_count OUT NOCOPY NUMBER,
1861: x_return_status OUT NOCOPY VARCHAR2,
1862: x_qa_return_status OUT NOCOPY VARCHAR2,
1863: x_qa_result_tbl OUT NOCOPY OKC_TERMS_QA_PVT.qa_result_tbl_type)
1864: IS
1865:
1866: l_api_name VARCHAR2(30);
1867: l_api_version NUMBER;

Line 1874: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;

1870: l_warning_found Boolean := FALSE;
1871: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1872: l_bus_doc_date_events_tbl OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE;
1873: l_sequence_id NUMBER;
1874: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
1875:
1876: CURSOR c_get_doc_details IS
1877: SELECT orcu.contract_type, orcu.contract_id,
1878: orca.contract_effective_date

Line 2004: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');

2000: END IF; -- l_qa_result_tbl.COUNT > 0 THEN
2001:
2002: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2003: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2004: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');
2005: END IF;
2006:
2007: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2008: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2009: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');

2005: END IF;
2006:
2007: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2008: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2009: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');
2010: END IF;
2011: --------------------------------------------
2012: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;