DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_TERMS_DEVIATIONS_T

Line 5143: FROM OKC_TERMS_DEVIATIONS_T

5139: RETURN VARCHAR2 is
5140:
5141: CURSOR csr_config_data IS
5142: SELECT config_header_id,config_revision_number
5143: FROM OKC_TERMS_DEVIATIONS_T
5144: WHERE sequence_id = p_sequence_id
5145: AND rownum < 2;
5146:
5147: CURSOR csr_variable_value(l_object_code VARCHAR2) IS

Line 8026: -- Insert header variables into okc_terms_deviations_t

8022: FETCH l_get_item_details_csr INTO l_item_name,l_item_description;
8023: CLOSE l_get_item_details_csr;
8024:
8025:
8026: -- Insert header variables into okc_terms_deviations_t
8027:
8028:
8029: INSERT INTO OKC_TERMS_DEVIATIONS_T
8030: (

Line 8029: INSERT INTO OKC_TERMS_DEVIATIONS_T

8025:
8026: -- Insert header variables into okc_terms_deviations_t
8027:
8028:
8029: INSERT INTO OKC_TERMS_DEVIATIONS_T
8030: (
8031: SEQUENCE_ID,
8032: DOCUMENT_TYPE,
8033: DOCUMENT_ID,

Line 8092: -- Insert header variables into okc_terms_deviations_t

8088: --FETCH l_get_item_details_csr INTO l_item_name,l_item_description;
8089: --CLOSE l_get_item_details_csr;
8090:
8091:
8092: -- Insert header variables into okc_terms_deviations_t
8093:
8094:
8095: INSERT INTO OKC_TERMS_DEVIATIONS_T
8096: (

Line 8095: INSERT INTO OKC_TERMS_DEVIATIONS_T

8091:
8092: -- Insert header variables into okc_terms_deviations_t
8093:
8094:
8095: INSERT INTO OKC_TERMS_DEVIATIONS_T
8096: (
8097: SEQUENCE_ID,
8098: DOCUMENT_TYPE,
8099: DOCUMENT_ID,

Line 8167: -- Insert Clause details into okc_terms_deviations_t

8163: THEN
8164: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8165: END IF;
8166:
8167: -- Insert Clause details into okc_terms_deviations_t
8168:
8169:
8170: INSERT INTO OKC_TERMS_DEVIATIONS_T
8171: (

Line 8170: INSERT INTO OKC_TERMS_DEVIATIONS_T

8166:
8167: -- Insert Clause details into okc_terms_deviations_t
8168:
8169:
8170: INSERT INTO OKC_TERMS_DEVIATIONS_T
8171: (
8172: SEQUENCE_ID,
8173: DOCUMENT_TYPE,
8174: DOCUMENT_ID,

Line 8591: -- Step 7: Insert Clauses and Terms deviations into okc_terms_deviations_t

8587:
8588: END IF; -- Check for presence of Deviations from Expert
8589: END IF;
8590:
8591: -- Step 7: Insert Clauses and Terms deviations into okc_terms_deviations_t
8592:
8593: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8594: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8595: G_MODULE||l_api_name,

Line 8596: '170: Step 7: Insert Clauses and Terms deviations into okc_terms_deviations_t');

8592:
8593: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8594: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8595: G_MODULE||l_api_name,
8596: '170: Step 7: Insert Clauses and Terms deviations into okc_terms_deviations_t');
8597: END IF;
8598:
8599: populate_terms_deviations_tbl(
8600: p_api_version => 1.0,