APPS.AMS_EVTREGS_PUB SQL Statements

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

Line: 223

/* add procedure update_regisrration info...make a rec with
updated column values...and then call update_registration..
*/

PROCEDURE Update_registration(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    P_evt_regs_Rec               IN   AMS_EvtRegs_PVT.evt_regs_Rec_Type,
    p_block_fulfillment          IN   VARCHAR2     := 'F',
    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_registration';

Line: 245

      SAVEPOINT UPDATE_Registration_PUB;

Line: 270

      AMS_EvtRegs_CUHK.Update_registration_pre(  x_evt_regs_Rec => l_evt_regs_Rec
                                               , x_return_status => l_return_status
                                              );

Line: 286

      AMS_EvtRegs_VUHK.Update_registration_pre(  x_evt_regs_Rec => l_evt_regs_Rec
                                               , x_return_status => l_return_status
                                              );

Line: 304

    AMS_evtregs_PVT.Update_evtregs(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
    P_evt_regs_Rec               => l_evt_regs_Rec,
    p_block_fulfillment          => p_block_fulfillment,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 329

      AMS_EvtRegs_VUHK.Update_registration_post(  p_evt_regs_Rec => l_evt_regs_Rec
                                                , x_return_status => l_return_status
                                               );

Line: 345

      AMS_EvtRegs_CUHK.Update_registration_post(  p_evt_regs_Rec => l_evt_regs_Rec
                                                , x_return_status => l_return_status
                                               );

Line: 374

      ROLLBACK TO update_registration_pub;

Line: 383

      ROLLBACK TO update_registration_pub;

Line: 393

      ROLLBACK TO update_registration_pub;

Line: 407

End Update_registration;

Line: 620

PROCEDURE delete_Registration(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_object_version		   IN   NUMBER,
    p_event_registration_id	   IN   NUMBER,

    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) := 'delete_Registration';

Line: 639

      SAVEPOINT delete_Registration_PUB;

Line: 661

      AMS_EvtRegs_CUHK.delete_Registration_pre(  x_object_version => l_object_version
                                               , x_event_registration_id =>l_event_registration_id
                                               , X_Return_Status => l_Return_Status
                                              );

Line: 677

      AMS_EvtRegs_VUHK.delete_Registration_pre(  x_object_version => l_object_version
                                               , x_event_registration_id =>l_event_registration_id
                                               , X_Return_Status => l_Return_Status
                                              );

Line: 693

    AMS_evtregs_PVT.delete_evtregs(
				p_api_version_number         => l_api_version_number,
				p_init_msg_list              => FND_API.G_FALSE,
				p_commit                     => p_commit,
				p_object_version             => l_object_version,
				p_event_registration_id		 => l_event_registration_id,

				X_Return_Status              => x_return_status,
				X_Msg_Count                  => x_msg_count,
				X_Msg_Data                   => x_msg_data);

Line: 713

      AMS_EvtRegs_VUHK.delete_Registration_post(  p_object_version => l_object_version
                                                , p_event_registration_id =>l_event_registration_id
                                                , X_Return_Status => l_Return_Status
                                              );

Line: 729

      AMS_EvtRegs_CUHK.delete_Registration_post(  p_object_version => l_object_version
                                                , p_event_registration_id =>l_event_registration_id
                                                , X_Return_Status => l_Return_Status
                                               );

Line: 762

      ROLLBACK TO delete_Registration_PUB;

Line: 771

      ROLLBACK TO delete_Registration_PUB;

Line: 780

      ROLLBACK TO delete_Registration_PUB;

Line: 794

End delete_Registration;