APPS.EAM_CREATEUPDATE_SAFETY_PVT SQL Statements

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

Line: 68

Wrapper procedure on top of Public Permit API.This is used to create/update permit
This in turn will call  PROCESS_WORK_PERMIT in EAM_PROCESS_PERMIT_PUB
***********************************************************************************************************/

PROCEDURE CREATE_UPDATE_PERMIT
          (    p_commit                          IN           VARCHAR2 := FND_API.G_FALSE
              , p_work_permit_header_rec         IN           EAM_PROCESS_PERMIT_PUB.eam_wp_header_rec_type
              , p_permit_wo_association_tbl      IN           EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type
              , x_permit_id                      OUT NOCOPY   NUMBER
              , x_return_status                  OUT NOCOPY   VARCHAR2
              , x_msg_count                      OUT NOCOPY   NUMBER
          )IS
 BEGIN

        EAM_PROCESS_PERMIT_PUB.PROCESS_WORK_PERMIT
          (
            p_bo_identifier                => 'EAM'
            , p_api_version_number         => 1.0
            , p_init_msg_list              =>  FALSE
            , p_commit                     => p_commit
            , p_work_permit_header_rec    => p_work_permit_header_rec
            , p_permit_wo_association_tbl  => p_permit_wo_association_tbl
            , x_permit_id                  => x_permit_id
            , x_return_status              => x_return_status
            , x_msg_count                  => x_msg_count
          );

Line: 98

END CREATE_UPDATE_PERMIT;