APPS.POS_ASBN SQL Statements

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

Line: 211

FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
BEGIN

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

Line: 216

END item_updateable;

Line: 454

        '/POS_ASBN.UPDATE_HEADER" target="header" method=GET">');

Line: 517

          IF item_updateable(l_attribute_index) THEN

              htp.p('' ||
                    '' ||
                     item_name(l_attribute_index) ||
                    '' ||
                    ' ' ||

Line: 594

PROCEDURE UPDATE_HEADER  ( pos_invoice_number     IN VARCHAR2 DEFAULT null,
                           pos_invoice_date       IN VARCHAR2 DEFAULT null,
			   pos_freight_amount	  IN VARCHAR2 DEFAULT null
		         )
IS
l_invoice_date DATE;

Line: 616

  update pos_asn_shop_cart_headers  set
    invoice_num    = pos_invoice_number,
    invoice_date   = l_invoice_date,
    freight_amount = fnd_number.canonical_to_number(rtrim(ltrim(pos_freight_amount)))
  where session_id = icx_sec.getID(icx_sec.PV_SESSION_ID);

Line: 627

END update_header;