APPS.POS_ASL_CAPACITY_PKG SQL Statements

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

Line: 112

FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
BEGIN

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

Line: 117

END item_updateable;

Line: 264

  htp.p('
');

Line: 390

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

Line: 456

                IF item_updateable(l_attribute_index) THEN

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

Line: 529

                IF item_updateable(l_attribute_index) THEN

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

Line: 818

            update po_supplier_item_capacity
               set from_date        = l_from_date,
                   to_date          = l_to_date,
                   capacity_per_day = nvl(l_capacity_per_day, 0),
		   last_update_date = sysdate,
		   last_updated_by  = l_user_id
             where capacity_id = l_capacity_id;

Line: 826

            insert into po_supplier_item_capacity
            (CAPACITY_ID,
             ASL_ID,
             USING_ORGANIZATION_ID,
             FROM_DATE,
             TO_DATE,
             CAPACITY_PER_DAY,
             LAST_UPDATE_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_LOGIN,
             CREATION_DATE,
             CREATED_BY)
            values (
             po_supplier_item_capacity_s.nextval,
             to_number(p_asl_id),
             -1,
             l_from_date,
	     l_to_date,
	     l_capacity_per_day,
  	     sysdate,
	     l_user_id,
	     l_user_id,
	     sysdate,
	     l_user_id);

Line: 855

           delete from po_supplier_item_capacity
           where capacity_id = l_capacity_id;