APPS.POS_ASL_TOLERANCE_PKG SQL Statements

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

Line: 110

FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
BEGIN

 RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');

Line: 115

END item_updateable;

Line: 259

  htp.p('
');

Line: 390

                IF item_updateable(l_attribute_index) THEN
                  htp.p('' ||
                      '' ||
                      '' ||
		      item_lov_multi(l_attribute_index,l_current_row) ||
                      '');

Line: 457

                IF item_updateable(l_attribute_index) THEN

                  htp.p('' ||
                        '' ||
                        '' || item_lov_multi(l_attribute_index,l_current_row) ||
                         '');

Line: 528

                IF item_updateable(l_attribute_index) THEN

                  htp.p('' ||
                        '' ||
                        '' || item_lov_multi(l_attribute_index,l_current_row) ||
                         '');

Line: 666

    delete from po_supplier_item_tolerance
    where asl_id = to_number(p_asl_id)
    and using_organization_id = -1;

Line: 673

        insert into po_supplier_item_tolerance
          (
           ASL_ID,
           USING_ORGANIZATION_ID,
           NUMBER_OF_DAYS,
           TOLERANCE,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN,
           CREATION_DATE,
           CREATED_BY
           )
        values (
           to_number(p_asl_id),
           -1,
           nvl(to_number(pos_days_in_advance(l_counter)), 0),
           nvl(to_number(pos_tolerance(l_counter)), 0),
           sysdate,
           l_user_id,
           l_user_id,
           sysdate,
           l_user_id );