APPS.AS_BUSINESS_EVENT_PUB SQL Statements

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

Line: 53

PROCEDURE Before_Oppty_Update(
    p_api_version_number        IN  NUMBER,
    p_init_msg_list             IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_commit                    IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_validation_level          IN  NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
    p_lead_id                   IN NUMBER,
    x_return_status             OUT NOCOPY VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2,
    x_event_key                 OUT NOCOPY VARCHAR2
) IS

l_api_name              CONSTANT VARCHAR2(30) := 'Before_Oppty_Update';

Line: 68

l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Before_Oppty_Update';

Line: 72

    SAVEPOINT BEFORE_OPPTY_UPDATE_PUB;

Line: 105

                        'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Oppty_Update');

Line: 108

    AS_BUSINESS_EVENT_PVT.Before_Oppty_Update
    (
        p_lead_id       => p_lead_id,
        x_event_key     => x_event_key
    );

Line: 181

End Before_Oppty_Update;

Line: 216

PROCEDURE Update_oppty_post_event(
    p_api_version_number        IN  NUMBER,
    p_init_msg_list             IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_commit                    IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_validation_level          IN  NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
    p_lead_id                   IN NUMBER,
    p_event_key                 IN VARCHAR2,
    x_return_status             OUT NOCOPY VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2
) IS

l_api_name              CONSTANT VARCHAR2(30) := 'Update_oppty_post_event';

Line: 231

l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Update_oppty_post_event';

Line: 235

    SAVEPOINT UPDATE_OPPTY_POST_EVENT_PUB;

Line: 268

                        'Public API: Calling AS_BUSINESS_EVENT_PVT.Update_oppty_post_event');

Line: 271

    AS_BUSINESS_EVENT_PVT.Update_oppty_post_event
    (
        p_lead_id       => p_lead_id,
        p_event_key     => p_event_key
    );

Line: 344

End Update_oppty_post_event;

Line: 384

PROCEDURE Before_Opp_Lines_Update(
    p_api_version_number        IN  NUMBER,
    p_init_msg_list             IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_commit                    IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_validation_level          IN  NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
    p_lead_id                   IN NUMBER,
    x_return_status             OUT NOCOPY VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2,
    x_event_key                 OUT NOCOPY VARCHAR2
) IS

l_api_name              CONSTANT VARCHAR2(30) := 'Before_Opp_Lines_Update';

Line: 399

l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Before_Opp_Lines_Update';

Line: 403

    SAVEPOINT BEFORE_OPP_LINES_UPDATE_PUB;

Line: 436

                        'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Opp_Lines_Update');

Line: 439

    AS_BUSINESS_EVENT_PVT.Before_Opp_Lines_Update
    (
        p_lead_id       => p_lead_id,
        x_event_key     => x_event_key
    );

Line: 512

End Before_Opp_Lines_Update;

Line: 715

PROCEDURE Before_Opp_STeam_Update(
    p_api_version_number        IN  NUMBER,
    p_init_msg_list             IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_commit                    IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_validation_level          IN  NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
    p_lead_id                   IN NUMBER,
    x_return_status             OUT NOCOPY VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2,
    x_event_key                 OUT NOCOPY VARCHAR2
) IS

l_api_name              CONSTANT VARCHAR2(30) := 'Before_Opp_STeam_Update';

Line: 730

l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Before_Opp_STeam_Update';

Line: 734

    SAVEPOINT BEFORE_OPP_STEAM_UPDATE_PUB;

Line: 767

                        'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Opp_STeam_Update');

Line: 770

    AS_BUSINESS_EVENT_PVT.Before_Opp_STeam_Update
    (
        p_lead_id       => p_lead_id,
        x_event_key     => x_event_key
    );

Line: 843

End Before_Opp_STeam_Update;

Line: 1046

PROCEDURE Before_Cust_STeam_Update(
    p_api_version_number        IN  NUMBER,
    p_init_msg_list             IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_commit                    IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_validation_level          IN  NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
    p_cust_id                   IN NUMBER,
    x_return_status             OUT NOCOPY VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2,
    x_event_key                 OUT NOCOPY VARCHAR2
) IS

l_api_name              CONSTANT VARCHAR2(30) := 'Before_Cust_STeam_Update';

Line: 1061

l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Before_Cust_STeam_Update';

Line: 1065

    SAVEPOINT BEFORE_CUST_STEAM_UPDATE_PUB;

Line: 1098

                        'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Cust_STeam_Update');

Line: 1101

    AS_BUSINESS_EVENT_PVT.Before_Cust_STeam_Update
    (
        p_cust_id       => p_cust_id,
        x_event_key     => x_event_key
    );

Line: 1174

End Before_Cust_STeam_Update;