APPS.IEX_TRX_GRID_PUB SQL Statements

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

Line: 24

 * @param x_rows_processed Number of rows updated
 * @rep:scope internal
 * @rep:displayname Set_Unpaid_Reason
 * @rep:lifecycle active
 * @rep:compatibility S
 */

  G_PKG_NAME    CONSTANT VARCHAR2(30) := 'IEX_TRX_GRID_PUB';

Line: 65

    l_last_updated_by number   := FND_GLOBAL.USER_ID;

Line: 66

    l_last_update_login number := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),0);

Line: 69

       select count(*) from iex_lookups_v where lookup_type = 'IEX_UNPAID_REASON'
                                     and lookup_code = c_unpaid_reason_code
                                     and enabled_flag = 'Y';

Line: 141

    l_sql_stmt := 'UPDATE iex_delinquencies_all  SET unpaid_reason_code = :b_unpaid_reason ' ||
                  ' ,last_update_date = to_date(''' || sysdate || ''' , ''DD-MON-RR'')' ||
		  ' ,last_update_login = ' || l_last_update_login ||
                  ' , last_updated_by =' || l_last_updated_by ||
                  ' WHERE delinquency_id IN (' || p_del_ids  || ')';