APPS.PA_CI_ACTIONS_PUB SQL Statements

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

Line: 23

    P_LAST_UPDATED_BY 	        in NUMBER default fnd_global.user_id,
    P_LAST_UPDATE_DATE 	        in DATE default sysdate,
    P_LAST_UPDATE_LOGIN 	    in NUMBER default fnd_global.user_id,
    x_return_status             OUT NOCOPY VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2
)
    IS
    l_msg_index_out        NUMBER;

Line: 131

    P_LAST_UPDATED_BY 	        in NUMBER default fnd_global.user_id,
    P_LAST_UPDATE_DATE 	        in DATE default sysdate,
    P_LAST_UPDATE_LOGIN 	    in NUMBER default fnd_global.user_id,
    x_return_status             OUT NOCOPY VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2) IS

    l_msg_index_out        NUMBER;

Line: 206

    P_LAST_UPDATED_BY 	        in NUMBER default fnd_global.user_id,
    P_LAST_UPDATE_DATE 	        in DATE default sysdate,
    P_LAST_UPDATE_LOGIN 	    in NUMBER default fnd_global.user_id,
    x_return_status             OUT NOCOPY VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2
) IS
    l_msg_index_out        NUMBER;

Line: 294

    P_LAST_UPDATED_BY 	        in NUMBER default fnd_global.user_id,
    P_LAST_UPDATE_DATE 	        in DATE default sysdate,
    P_LAST_UPDATE_LOGIN 	    in NUMBER default fnd_global.user_id,
    x_return_status             OUT NOCOPY VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2
    ) IS
    l_party_id number;

Line: 356

                P_LAST_UPDATED_BY   =>  P_LAST_UPDATED_BY,
                P_LAST_UPDATE_DATE  =>  P_LAST_UPDATE_DATE,
                P_LAST_UPDATE_LOGIN =>  P_LAST_UPDATE_LOGIN,
                x_return_status     =>  x_return_status,
                x_msg_count         =>  x_msg_count,
                x_msg_data          =>  x_msg_data
            );

Line: 410

                P_LAST_UPDATED_BY 	        in NUMBER default fnd_global.user_id,
                P_LAST_UPDATE_DATE 	        in DATE default sysdate,
                P_LAST_UPDATE_LOGIN 	    in NUMBER default fnd_global.user_id,
                x_return_status             OUT NOCOPY VARCHAR2,
                x_msg_count                 OUT NOCOPY NUMBER,
                x_msg_data                  OUT NOCOPY VARCHAR2)

    IS
    BEGIN
        IF p_commit = FND_API.G_TRUE
        THEN
            SAVEPOINT ADD_CI_COMMENT;

Line: 468

PROCEDURE UPDATE_CI_COMMENT(
                p_api_version         	IN     NUMBER :=  1.0,
                p_init_msg_list       	IN     VARCHAR2 := fnd_api.g_true,
                p_commit              	IN     VARCHAR2 := FND_API.g_false,
                p_validate_only       	IN     VARCHAR2 := FND_API.g_true,
                p_max_msg_count       	IN     NUMBER := FND_API.g_miss_num,
                p_ci_comment_id       	IN     NUMBER,
                p_comment_text        	IN     VARCHAR2,
		p_record_version_number IN     NUMBER,
                P_LAST_UPDATED_BY 	in NUMBER default fnd_global.user_id,
                P_LAST_UPDATE_DATE 	in DATE default sysdate,
                P_LAST_UPDATE_LOGIN 	in NUMBER default fnd_global.user_id,
                x_return_status         OUT NOCOPY VARCHAR2,
                x_msg_count             OUT NOCOPY NUMBER,
                x_msg_data              OUT NOCOPY VARCHAR2)

   IS
    BEGIN
        IF p_commit = FND_API.G_TRUE
        THEN
            SAVEPOINT UPDATE_CI_COMMENT;

Line: 496

                PA_CI_ACTIONS_PVT.UPDATE_CI_COMMENT(
                p_api_version => P_API_VERSION,
                p_init_msg_list => P_INIT_MSG_LIST,
                p_commit => P_COMMIT,
                p_validate_only => P_VALIDATE_ONLY,
                p_max_msg_count => P_MAX_MSG_COUNT,
                p_ci_comment_id => P_CI_COMMENT_ID,
                p_comment_text => P_COMMENT_TEXT,
		p_record_version_number => P_RECORD_VERSION_NUMBER,
                P_LAST_UPDATED_BY   =>  P_LAST_UPDATED_BY,
                P_LAST_UPDATE_DATE  =>  P_LAST_UPDATE_DATE,
                P_LAST_UPDATE_LOGIN =>  P_LAST_UPDATE_LOGIN,
                x_return_status => x_return_status,
                x_msg_count => x_msg_count,
                x_msg_data => x_msg_data
                );

Line: 530

                               p_procedure_name => 'UPDATE_CI_COMMENT',
                               p_error_text     => SUBSTRB(SQLERRM,1,240));