APPS.AST_WRAPUP_ADM_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

PROCEDURE INSERT_OUTCOME(
	P_API_VERSION			        IN  NUMBER,
	P_INIT_MSG_LIST			        IN  VARCHAR2 := FND_API.G_FALSE,
	P_COMMIT				        IN  VARCHAR2 := FND_API.G_FALSE,
	P_VALIDATION_LEVEL		        IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
	X_RETURN_STATUS			        OUT VARCHAR2,
	X_MSG_COUNT				        OUT NUMBER,
	X_MSG_DATA				        OUT VARCHAR2,
    P_RESULT_REQUIRED               IN  VARCHAR2,
    P_VERSATILITY_CODE              IN  NUMBER,
    P_GENERATE_PUBLIC_CALLBACK      IN  VARCHAR2,
    P_GENERATE_PRIVATE_CALLBACK     IN  VARCHAR2,
    P_SCORE                         IN  NUMBER,
    P_POSITIVE_OUTCOME_FLAG         IN  VARCHAR2,
    P_LANGUAGE                      IN  VARCHAR2,
    P_LONG_DESCRIPTION              IN  VARCHAR2,
    P_SHORT_DESCRIPTION             IN  VARCHAR2,
    P_OUTCOME_CODE                  IN  VARCHAR2,
    P_MEDIA_TYPE                    IN  VARCHAR2,
    X_OUTCOME_ID                    OUT NUMBER
)
AS
	l_api_name	CONSTANT VARCHAR2(30) := 'INSERT_OUTCOME';

Line: 45

    SELECT JTF_IH_OUTCOMES_S1.NEXTVAL
    FROM DUAL;

Line: 49

    CURSOR l_insert_b_check_csr IS
    SELECT 'x'
    FROM JTF_IH_OUTCOMES_B
    WHERE OUTCOME_ID = l_outcome_id;

Line: 55

    CURSOR l_insert_tl_check_csr IS
    SELECT 'x'
    FROM JTF_IH_OUTCOMES_TL
    WHERE OUTCOME_ID = l_outcome_id;

Line: 62

	SAVEPOINT	INSERT_OUTCOME_PVT;

Line: 85

    INSERT INTO JTF_IH_OUTCOMES_TL
    (
        OUTCOME_ID,
        LANGUAGE,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        SOURCE_LANG,
        LONG_DESCRIPTION,
        SHORT_DESCRIPTION,
        OUTCOME_CODE,
        MEDIA_TYPE
    )
    VALUES
    (
        L_OUTCOME_ID,
        P_LANGUAGE,
        L_API_VERSION,
        G_USER_ID,
        SYSDATE,
        G_USER_ID,
        SYSDATE,
        G_LOGIN_ID,
        P_LANGUAGE,
        P_LONG_DESCRIPTION,
        P_SHORT_DESCRIPTION,
        P_OUTCOME_CODE,
        P_MEDIA_TYPE
    );

Line: 119

    OPEN l_insert_tl_check_csr;

Line: 120

    FETCH l_insert_tl_check_csr INTO l_dummy;

Line: 121

    IF (l_insert_tl_check_csr%notfound) THEN
      CLOSE l_insert_tl_check_csr;

Line: 125

    CLOSE l_insert_tl_check_csr;

Line: 128

    INSERT INTO JTF_IH_OUTCOMES_B
    (
        OUTCOME_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        RESULT_REQUIRED,
        VERSATILITY_CODE,
        GENERATE_PUBLIC_CALLBACK,
        GENERATE_PRIVATE_CALLBACK,
        SCORE,
        POSITIVE_OUTCOME_FLAG
    )
    VALUES
    (
        L_OUTCOME_ID,
        L_API_VERSION,
        G_USER_ID,
        SYSDATE,
        G_USER_ID,
        SYSDATE,
        G_LOGIN_ID,
        P_RESULT_REQUIRED,
        P_VERSATILITY_CODE,
        P_GENERATE_PUBLIC_CALLBACK,
        P_GENERATE_PRIVATE_CALLBACK,
        P_SCORE,
        P_POSITIVE_OUTCOME_FLAG
    );

Line: 162

    OPEN l_insert_b_check_csr;

Line: 163

    FETCH l_insert_b_check_csr INTO l_dummy;

Line: 164

    IF (l_insert_b_check_csr%notfound) THEN
      CLOSE l_insert_b_check_csr;

Line: 168

    CLOSE l_insert_b_check_csr;

Line: 183

		ROLLBACK TO INSERT_OUTCOME_PVT;

Line: 188

		ROLLBACK TO INSERT_OUTCOME_PVT;

Line: 193

		ROLLBACK TO INSERT_OUTCOME_PVT;

Line: 200

END INSERT_OUTCOME;

Line: 202

PROCEDURE UPDATE_OUTCOME(
	P_API_VERSION			        IN  NUMBER,
	P_INIT_MSG_LIST			        IN  VARCHAR2 := FND_API.G_FALSE,
	P_COMMIT				        IN  VARCHAR2 := FND_API.G_FALSE,
	P_VALIDATION_LEVEL		        IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
	X_RETURN_STATUS			        OUT VARCHAR2,
	X_MSG_COUNT				        OUT NUMBER,
	X_MSG_DATA				        OUT VARCHAR2,
    P_OUTCOME_ID                    IN  NUMBER,
    P_RESULT_REQUIRED               IN  VARCHAR2,
    P_VERSATILITY_CODE              IN  NUMBER,
    P_GENERATE_PUBLIC_CALLBACK      IN  VARCHAR2,
    P_GENERATE_PRIVATE_CALLBACK     IN  VARCHAR2,
    P_SCORE                         IN  NUMBER,
    P_POSITIVE_OUTCOME_FLAG         IN  VARCHAR2,
    P_LANGUAGE                      IN  VARCHAR2,
    P_LONG_DESCRIPTION              IN  VARCHAR2,
    P_SHORT_DESCRIPTION             IN  VARCHAR2,
    P_OUTCOME_CODE                  IN  VARCHAR2,
    P_MEDIA_TYPE                    IN  VARCHAR2
)
AS
	l_api_name	CONSTANT VARCHAR2(30) := 'UPDATE_OUTCOME';

Line: 232

	SAVEPOINT	UPDATE_OUTCOME_PVT;

Line: 250

    UPDATE JTF_IH_OUTCOMES_TL
    SET
        LANGUAGE = P_LANGUAGE,
        LAST_UPDATED_BY = G_USER_ID,
        LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATE_LOGIN = G_LOGIN_ID,
        SOURCE_LANG = P_LANGUAGE,
        LONG_DESCRIPTION = P_LONG_DESCRIPTION,
        SHORT_DESCRIPTION = P_SHORT_DESCRIPTION,
        OUTCOME_CODE = P_OUTCOME_CODE,
        MEDIA_TYPE = P_MEDIA_TYPE
    WHERE
        OUTCOME_ID = P_OUTCOME_ID AND
        LANGUAGE = P_LANGUAGE;

Line: 266

    UPDATE JTF_IH_OUTCOMES_B
    SET
        LAST_UPDATED_BY = G_USER_ID,
        LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATE_LOGIN = G_LOGIN_ID,
        RESULT_REQUIRED = P_RESULT_REQUIRED,
        VERSATILITY_CODE = P_VERSATILITY_CODE,
        GENERATE_PUBLIC_CALLBACK = P_GENERATE_PUBLIC_CALLBACK,
        GENERATE_PRIVATE_CALLBACK = P_GENERATE_PRIVATE_CALLBACK,
        SCORE = P_SCORE,
        POSITIVE_OUTCOME_FLAG = P_POSITIVE_OUTCOME_FLAG
    WHERE
        OUTCOME_ID = P_OUTCOME_ID;

Line: 292

		ROLLBACK TO UPDATE_OUTCOME_PVT;

Line: 297

		ROLLBACK TO UPDATE_OUTCOME_PVT;

Line: 302

		ROLLBACK TO UPDATE_OUTCOME_PVT;

Line: 309

END UPDATE_OUTCOME;

Line: 311

PROCEDURE INSERT_RESULT(
	P_API_VERSION			        IN  NUMBER,
	P_INIT_MSG_LIST			        IN  VARCHAR2 := FND_API.G_FALSE,
	P_COMMIT				        IN  VARCHAR2 := FND_API.G_FALSE,
	P_VALIDATION_LEVEL		        IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
	X_RETURN_STATUS			        OUT VARCHAR2,
	X_MSG_COUNT				        OUT NUMBER,
	X_MSG_DATA				        OUT VARCHAR2,
    P_REASON_REQUIRED               IN  VARCHAR2,
    P_VERSATILITY_CODE              IN  NUMBER,
    P_GENERATE_PUBLIC_CALLBACK      IN  VARCHAR2,
    P_GENERATE_PRIVATE_CALLBACK     IN  VARCHAR2,
    P_POSITIVE_RESULT_FLAG         IN  VARCHAR2,
    P_LANGUAGE                      IN  VARCHAR2,
    P_LONG_DESCRIPTION              IN  VARCHAR2,
    P_SHORT_DESCRIPTION             IN  VARCHAR2,
    P_RESULT_CODE                   IN  VARCHAR2,
    P_MEDIA_TYPE                    IN  VARCHAR2,
    X_RESULT_ID                     OUT NUMBER
)
AS
	l_api_name	CONSTANT VARCHAR2(30) := 'INSERT_RESULT';

Line: 343

    SELECT JTF_IH_RESULTS_S1.NEXTVAL
    FROM DUAL;

Line: 347

    CURSOR l_insert_b_check_csr IS
    SELECT 'x'
    FROM JTF_IH_RESULTS_B
    WHERE RESULT_ID = l_RESULT_id;

Line: 353

    CURSOR l_insert_tl_check_csr IS
    SELECT 'x'
    FROM JTF_IH_RESULTS_TL
    WHERE RESULT_ID = l_RESULT_id;

Line: 360

	SAVEPOINT	INSERT_RESULT_PVT;

Line: 383

    INSERT INTO JTF_IH_RESULTS_TL
    (
        RESULT_ID,
        LANGUAGE,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        SOURCE_LANG,
        LONG_DESCRIPTION,
        SHORT_DESCRIPTION,
        RESULT_CODE,
        MEDIA_TYPE
    )
    VALUES
    (
        L_RESULT_ID,
        P_LANGUAGE,
        L_API_VERSION,
        G_USER_ID,
        SYSDATE,
        G_USER_ID,
        SYSDATE,
        G_LOGIN_ID,
        P_LANGUAGE,
        P_LONG_DESCRIPTION,
        P_SHORT_DESCRIPTION,
        P_RESULT_CODE,
        P_MEDIA_TYPE
    );

Line: 417

    OPEN l_insert_tl_check_csr;

Line: 418

    FETCH l_insert_tl_check_csr INTO l_dummy;

Line: 419

    IF (l_insert_tl_check_csr%notfound) THEN
      CLOSE l_insert_tl_check_csr;

Line: 423

    CLOSE l_insert_tl_check_csr;

Line: 426

    INSERT INTO JTF_IH_RESULTS_B
    (
        RESULT_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        RESULT_REQUIRED,
        VERSATILITY_CODE,
        GENERATE_PUBLIC_CALLBACK,
        GENERATE_PRIVATE_CALLBACK,
        POSITIVE_RESPONSE_FLAG
    )
    VALUES
    (
        L_RESULT_ID,
        L_API_VERSION,
        G_USER_ID,
        SYSDATE,
        G_USER_ID,
        SYSDATE,
        G_LOGIN_ID,
        P_REASON_REQUIRED,
        P_VERSATILITY_CODE,
        P_GENERATE_PUBLIC_CALLBACK,
        P_GENERATE_PRIVATE_CALLBACK,
        P_POSITIVE_RESULT_FLAG
    );

Line: 458

    OPEN l_insert_b_check_csr;

Line: 459

    FETCH l_insert_b_check_csr INTO l_dummy;

Line: 460

    IF (l_insert_b_check_csr%notfound) THEN
      CLOSE l_insert_b_check_csr;

Line: 464

    CLOSE l_insert_b_check_csr;

Line: 479

		ROLLBACK TO INSERT_RESULT_PVT;

Line: 484

		ROLLBACK TO INSERT_RESULT_PVT;

Line: 489

		ROLLBACK TO INSERT_RESULT_PVT;

Line: 496

END INSERT_RESULT;

Line: 498

PROCEDURE UPDATE_RESULT(
	P_API_VERSION			        IN  NUMBER,
	P_INIT_MSG_LIST			        IN  VARCHAR2 := FND_API.G_FALSE,
	P_COMMIT				        IN  VARCHAR2 := FND_API.G_FALSE,
	P_VALIDATION_LEVEL		        IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
	X_RETURN_STATUS			        OUT VARCHAR2,
	X_MSG_COUNT				        OUT NUMBER,
	X_MSG_DATA				        OUT VARCHAR2,
    P_RESULT_ID                    IN  NUMBER,
    P_REASON_REQUIRED               IN  VARCHAR2,
    P_VERSATILITY_CODE              IN  NUMBER,
    P_GENERATE_PUBLIC_CALLBACK      IN  VARCHAR2,
    P_GENERATE_PRIVATE_CALLBACK     IN  VARCHAR2,
    P_POSITIVE_RESULT_FLAG         IN  VARCHAR2,
    P_LANGUAGE                      IN  VARCHAR2,
    P_LONG_DESCRIPTION              IN  VARCHAR2,
    P_SHORT_DESCRIPTION             IN  VARCHAR2,
    P_RESULT_CODE                  IN  VARCHAR2,
    P_MEDIA_TYPE                    IN  VARCHAR2
)
AS
	l_api_name	CONSTANT VARCHAR2(30) := 'UPDATE_RESULT';

Line: 527

	SAVEPOINT	UPDATE_RESULT_PVT;

Line: 545

    UPDATE JTF_IH_RESULTS_TL
    SET
        LANGUAGE = P_LANGUAGE,
        LAST_UPDATED_BY = G_USER_ID,
        LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATE_LOGIN = G_LOGIN_ID,
        SOURCE_LANG = P_LANGUAGE,
        LONG_DESCRIPTION = P_LONG_DESCRIPTION,
        SHORT_DESCRIPTION = P_SHORT_DESCRIPTION,
        RESULT_CODE = P_RESULT_CODE,
        MEDIA_TYPE = P_MEDIA_TYPE
    WHERE
        RESULT_ID = P_RESULT_ID AND
        LANGUAGE = P_LANGUAGE;

Line: 561

    UPDATE JTF_IH_RESULTS_B
    SET
        LAST_UPDATED_BY = G_USER_ID,
        LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATE_LOGIN = G_LOGIN_ID,
        RESULT_REQUIRED = P_REASON_REQUIRED,
        VERSATILITY_CODE = P_VERSATILITY_CODE,
        GENERATE_PUBLIC_CALLBACK = P_GENERATE_PUBLIC_CALLBACK,
        GENERATE_PRIVATE_CALLBACK = P_GENERATE_PRIVATE_CALLBACK,
        POSITIVE_RESPONSE_FLAG = P_POSITIVE_RESULT_FLAG
    WHERE
        RESULT_ID = P_RESULT_ID;

Line: 586

		ROLLBACK TO UPDATE_RESULT_PVT;

Line: 591

		ROLLBACK TO UPDATE_RESULT_PVT;

Line: 596

		ROLLBACK TO UPDATE_RESULT_PVT;

Line: 603

END UPDATE_RESULT;

Line: 605

PROCEDURE INSERT_REASON(
	P_API_VERSION			        IN  NUMBER,
	P_INIT_MSG_LIST			        IN  VARCHAR2 := FND_API.G_FALSE,
	P_COMMIT				        IN  VARCHAR2 := FND_API.G_FALSE,
	P_VALIDATION_LEVEL		        IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
	X_RETURN_STATUS			        OUT VARCHAR2,
	X_MSG_COUNT				        OUT NUMBER,
	X_MSG_DATA				        OUT VARCHAR2,
    P_VERSATILITY_CODE              IN  NUMBER,
    P_GENERATE_PUBLIC_CALLBACK      IN  VARCHAR2,
    P_GENERATE_PRIVATE_CALLBACK     IN  VARCHAR2,
    P_LANGUAGE                      IN  VARCHAR2,
    P_LONG_DESCRIPTION              IN  VARCHAR2,
    P_SHORT_DESCRIPTION             IN  VARCHAR2,
    P_REASON_CODE                   IN  VARCHAR2,
    P_MEDIA_TYPE                    IN  VARCHAR2,
    X_REASON_ID                     OUT NUMBER
)
AS
	l_api_name	CONSTANT VARCHAR2(30) := 'INSERT_REASON';

Line: 635

    SELECT JTF_IH_REASONS_S1.NEXTVAL
    FROM DUAL;

Line: 639

    CURSOR l_insert_b_check_csr IS
    SELECT 'x'
    FROM JTF_IH_REASONS_B
    WHERE REASON_ID = l_REASON_id;

Line: 645

    CURSOR l_insert_tl_check_csr IS
    SELECT 'x'
    FROM JTF_IH_REASONS_TL
    WHERE REASON_ID = l_REASON_id;

Line: 652

	SAVEPOINT	INSERT_REASON_PVT;

Line: 675

    INSERT INTO JTF_IH_REASONS_TL
    (
        REASON_ID,
        LANGUAGE,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        SOURCE_LANG,
        LONG_DESCRIPTION,
        SHORT_DESCRIPTION,
        REASON_CODE,
        MEDIA_TYPE
    )
    VALUES
    (
        L_REASON_ID,
        P_LANGUAGE,
        L_API_VERSION,
        G_USER_ID,
        SYSDATE,
        G_USER_ID,
        SYSDATE,
        G_LOGIN_ID,
        P_LANGUAGE,
        P_LONG_DESCRIPTION,
        P_SHORT_DESCRIPTION,
        P_REASON_CODE,
        P_MEDIA_TYPE
    );

Line: 709

    OPEN l_insert_tl_check_csr;

Line: 710

    FETCH l_insert_tl_check_csr INTO l_dummy;

Line: 711

    IF (l_insert_tl_check_csr%notfound) THEN
      CLOSE l_insert_tl_check_csr;

Line: 715

    CLOSE l_insert_tl_check_csr;

Line: 718

    INSERT INTO JTF_IH_REASONS_B
    (
        REASON_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        VERSATILITY_CODE,
        GENERATE_PUBLIC_CALLBACK,
        GENERATE_PRIVATE_CALLBACK
    )
    VALUES
    (
        L_REASON_ID,
        L_API_VERSION,
        G_USER_ID,
        SYSDATE,
        G_USER_ID,
        SYSDATE,
        G_LOGIN_ID,
        P_VERSATILITY_CODE,
        P_GENERATE_PUBLIC_CALLBACK,
        P_GENERATE_PRIVATE_CALLBACK
    );

Line: 746

    OPEN l_insert_b_check_csr;

Line: 747

    FETCH l_insert_b_check_csr INTO l_dummy;

Line: 748

    IF (l_insert_b_check_csr%notfound) THEN
      CLOSE l_insert_b_check_csr;

Line: 752

    CLOSE l_insert_b_check_csr;

Line: 767

		ROLLBACK TO INSERT_REASON_PVT;

Line: 772

		ROLLBACK TO INSERT_REASON_PVT;

Line: 777

		ROLLBACK TO INSERT_REASON_PVT;

Line: 784

END INSERT_REASON;

Line: 786

PROCEDURE UPDATE_REASON(
	P_API_VERSION			        IN  NUMBER,
	P_INIT_MSG_LIST			        IN  VARCHAR2 := FND_API.G_FALSE,
	P_COMMIT				        IN  VARCHAR2 := FND_API.G_FALSE,
	P_VALIDATION_LEVEL		        IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
	X_RETURN_STATUS			        OUT VARCHAR2,
	X_MSG_COUNT				        OUT NUMBER,
	X_MSG_DATA				        OUT VARCHAR2,
    P_REASON_ID                    IN  NUMBER,
    P_VERSATILITY_CODE              IN  NUMBER,
    P_GENERATE_PUBLIC_CALLBACK      IN  VARCHAR2,
    P_GENERATE_PRIVATE_CALLBACK     IN  VARCHAR2,
    P_LANGUAGE                      IN  VARCHAR2,
    P_LONG_DESCRIPTION              IN  VARCHAR2,
    P_SHORT_DESCRIPTION             IN  VARCHAR2,
    P_REASON_CODE                  IN  VARCHAR2,
    P_MEDIA_TYPE                    IN  VARCHAR2
)
AS
	l_api_name	CONSTANT VARCHAR2(30) := 'UPDATE_REASON';

Line: 813

	SAVEPOINT	UPDATE_REASON_PVT;

Line: 831

    UPDATE JTF_IH_REASONS_TL
    SET
        LANGUAGE = P_LANGUAGE,
        LAST_UPDATED_BY = G_USER_ID,
        LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATE_LOGIN = G_LOGIN_ID,
        SOURCE_LANG = P_LANGUAGE,
        LONG_DESCRIPTION = P_LONG_DESCRIPTION,
        SHORT_DESCRIPTION = P_SHORT_DESCRIPTION,
        REASON_CODE = P_REASON_CODE,
        MEDIA_TYPE = P_MEDIA_TYPE
    WHERE
        REASON_ID = P_REASON_ID AND
        LANGUAGE = P_LANGUAGE;

Line: 847

    UPDATE JTF_IH_REASONS_B
    SET
        LAST_UPDATED_BY = G_USER_ID,
        LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATE_LOGIN = G_LOGIN_ID,
        VERSATILITY_CODE = P_VERSATILITY_CODE,
        GENERATE_PUBLIC_CALLBACK = P_GENERATE_PUBLIC_CALLBACK,
        GENERATE_PRIVATE_CALLBACK = P_GENERATE_PRIVATE_CALLBACK
    WHERE
        REASON_ID = P_REASON_ID;

Line: 870

		ROLLBACK TO UPDATE_REASON_PVT;

Line: 875

		ROLLBACK TO UPDATE_REASON_PVT;

Line: 880

		ROLLBACK TO UPDATE_REASON_PVT;

Line: 887

END UPDATE_REASON;

Line: 928

    DELETE FROM JTF_IH_OUTCOME_RESULTS
    WHERE OUTCOME_ID = P_OUTCOME_ID AND RESULT_ID = P_RESULT_ID;

Line: 933

        INSERT INTO JTF_IH_OUTCOME_RESULTS
        (
            RESULT_ID,
            OUTCOME_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
        )
        VALUES
        (
            P_RESULT_ID,
            P_OUTCOME_ID,
            L_API_VERSION,
            G_USER_ID,
            SYSDATE,
            G_USER_ID,
            SYSDATE,
            G_LOGIN_ID
        );

Line: 1027

    DELETE FROM JTF_IH_RESULT_REASONS
    WHERE RESULT_ID = P_RESULT_ID AND REASON_ID = P_REASON_ID;

Line: 1032

        INSERT INTO JTF_IH_RESULT_REASONS
        (
            RESULT_ID,
            REASON_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
        )
        VALUES
        (
            P_RESULT_ID,
            P_REASON_ID,
            L_API_VERSION,
            G_USER_ID,
            SYSDATE,
            G_USER_ID,
            SYSDATE,
            G_LOGIN_ID
        );