DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_TERMS_UDV_WITH_PROCEDURE_T

Line 5187: DELETE FROM OKC_TERMS_UDV_WITH_PROCEDURE_T;

5183: /* Initialize API return status to success */
5184: x_return_status := G_RET_STS_SUCCESS;
5185:
5186: /* Clear the temp table */
5187: DELETE FROM OKC_TERMS_UDV_WITH_PROCEDURE_T;
5188:
5189: FOR csr_udv_with_procs_rec IN csr_get_udv_with_procs LOOP
5190:
5191: /* Get the variable value */

Line 5211: INSERT INTO OKC_TERMS_UDV_WITH_PROCEDURE_T

5207:
5208: /* Insert data into the temp table */
5209: IF l_variable_value IS NOT NULL THEN
5210:
5211: INSERT INTO OKC_TERMS_UDV_WITH_PROCEDURE_T
5212: (
5213: VARIABLE_CODE,
5214: VARIABLE_VALUE,
5215: DOC_TYPE,