DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_TERMS_DEVIATIONS_T

Line 5341: FROM OKC_TERMS_DEVIATIONS_T

5337: RETURN VARCHAR2 is
5338:
5339: CURSOR csr_config_data IS
5340: SELECT config_header_id,config_revision_number
5341: FROM OKC_TERMS_DEVIATIONS_T
5342: WHERE sequence_id = p_sequence_id
5343: AND rownum < 2;
5344:
5345: CURSOR csr_variable_value(l_object_code VARCHAR2) IS

Line 8353: -- Insert header variables into okc_terms_deviations_t

8349: FETCH l_get_item_details_csr INTO l_item_name,l_item_description;
8350: CLOSE l_get_item_details_csr;
8351:
8352:
8353: -- Insert header variables into okc_terms_deviations_t
8354:
8355:
8356: INSERT INTO OKC_TERMS_DEVIATIONS_T
8357: (

Line 8356: INSERT INTO OKC_TERMS_DEVIATIONS_T

8352:
8353: -- Insert header variables into okc_terms_deviations_t
8354:
8355:
8356: INSERT INTO OKC_TERMS_DEVIATIONS_T
8357: (
8358: SEQUENCE_ID,
8359: DOCUMENT_TYPE,
8360: DOCUMENT_ID,

Line 8419: -- Insert header variables into okc_terms_deviations_t

8415: --FETCH l_get_item_details_csr INTO l_item_name,l_item_description;
8416: --CLOSE l_get_item_details_csr;
8417:
8418:
8419: -- Insert header variables into okc_terms_deviations_t
8420:
8421:
8422: INSERT INTO OKC_TERMS_DEVIATIONS_T
8423: (

Line 8422: INSERT INTO OKC_TERMS_DEVIATIONS_T

8418:
8419: -- Insert header variables into okc_terms_deviations_t
8420:
8421:
8422: INSERT INTO OKC_TERMS_DEVIATIONS_T
8423: (
8424: SEQUENCE_ID,
8425: DOCUMENT_TYPE,
8426: DOCUMENT_ID,

Line 8494: -- Insert Clause details into okc_terms_deviations_t

8490: THEN
8491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8492: END IF;
8493:
8494: -- Insert Clause details into okc_terms_deviations_t
8495:
8496:
8497: INSERT INTO OKC_TERMS_DEVIATIONS_T
8498: (

Line 8497: INSERT INTO OKC_TERMS_DEVIATIONS_T

8493:
8494: -- Insert Clause details into okc_terms_deviations_t
8495:
8496:
8497: INSERT INTO OKC_TERMS_DEVIATIONS_T
8498: (
8499: SEQUENCE_ID,
8500: DOCUMENT_TYPE,
8501: DOCUMENT_ID,

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

8914:
8915: END IF; -- Check for presence of Deviations from Expert
8916: END IF;
8917:
8918: -- Step 7: Insert Clauses and Terms deviations into okc_terms_deviations_t
8919:
8920: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8922: G_MODULE||l_api_name,

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

8919:
8920: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
8922: G_MODULE||l_api_name,
8923: '170: Step 7: Insert Clauses and Terms deviations into okc_terms_deviations_t');
8924: END IF;
8925:
8926: populate_terms_deviations_tbl(
8927: p_api_version => 1.0,