APPS.BOMPOPIF SQL Statements

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

Line: 19

|		del_rec_flag	delete processed rows                       |
|    		prog_appid      program application_id                      |
|    		prog_id  	program id                                  |
|    		request_id      request_id                                  |
|    		user_id		user id                                     |
|    		login_id	login id                                    |
| Return:	1 if success                                                |
|		SQLCODE if failure                                          |
| History:	                                                            |
|    09/26/93   Shreyas Shah	creation date                               |
|    03/27/97   Julie Maeyama	Modified to call new packages               |
|    01/15/05   Bhavnesh Patel  Added Batch Id                              |
|                                                                           |
+==========================================================================*/

/*--------------------------bmopinp_open_interface_process-------------------

NAME
   bmopinp_open_interface_process
DESCRIPTION
    Open Interface Import for null batch id .
RETURNS
    0 if successful
    SQLCODE if unsuccessful
NOTES
-----------------------------------------------------------------------------*/
FUNCTION bmopinp_open_interface_process (
    org_id		NUMBER,
    all_org		NUMBER		:= 1,
    val_rtg_flag	NUMBER		:= 1,
    val_bom_flag	NUMBER		:= 1,
    pro_rtg_flag	NUMBER		:= 1,
    pro_bom_flag	NUMBER		:= 1,
    del_rec_flag	NUMBER		:= 1,
    prog_appid		NUMBER		:= -1,
    prog_id		NUMBER		:= -1,
    request_id		NUMBER		:= -1,
    user_id		NUMBER		:= -1,
    login_id		NUMBER		:= -1,
    err_text     IN OUT NOCOPY 	VARCHAR2
)
    return INTEGER
IS
  l_return_status INTEGER := 0;

Line: 119

    l_delete_rows	VARCHAR2(1); -- boolean value

Line: 140

       l_delete_rows := FND_API.G_TRUE;

Line: 142

       l_delete_rows := FND_API.G_FALSE;

Line: 167

		 , p_delete_rows => del_rec_flag
		 , x_err_text	 => err_msg
     , p_batch_id => p_batch_id
		 );

Line: 190

       p_delete_rows         =>      l_delete_rows
     );