APPS.GMO_OPERT_CERT_GTMP_DBL SQL Statements

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

Line: 25

 |      - insert_row
 |
 |
 |
 =============================================================================
*/

   /* Api start of comments
 +============================================================================
 |   FUNCTION NAME
 |      insert_row
 |
 |   TYPE
 |      Private
 |   USAGE
 |      Insert_Row will insert a row in gmo_opert_cert_gtmp
 |
 |
 |   DESCRIPTION
 |      Insert_Row will insert a row in gmo_opert_cert_gtmp

 |   HISTORY
 |   12-MAR-07 Pawan Kumar   Created
 |
 |
 |
 +=============================================================================
 Api end of comments
*/

   PROCEDURE INSERT_ROW (
    p_ERECORD_ID               IN NUMBER
   ,p_Operator_certificate_id  IN NUMBER
   ,p_EVENT_KEY                IN VARCHAR2
   ,p_EVENT_NAME               IN VARCHAR2
   ,x_return_status            OUT NOCOPY VARCHAR2) IS


BEGIN
   -- Initially let us assign the return status to success
      x_return_status := fnd_api.g_ret_sts_success;

Line: 70

     INSERT INTO gmo_opert_cert_gtmp
                         (ERECORD_ID
                         ,Operator_certificate_id
                         ,EVENT_KEY
                         ,EVENT_NAME
                         )
                 VALUES ( p_ERECORD_ID
                         ,p_Operator_certificate_id
                         ,p_EVENT_KEY
                         ,p_EVENT_NAME

                         ) ;

Line: 95

   END insert_row;