APPS.POS_ASN_DETAILS_S SQL Statements

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

Line: 88

/* item_updateable
 * ---------------
 */
FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
BEGIN
 RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');

Line: 153

 SELECT invoice_num
 INTO   invoice_num
 FROM   pos_asn_shop_cart_headers
 WHERE  session_id = l_session_id;

Line: 234

        '/pos_asn_details_s.update_details" target="content" method=GET">');

Line: 346

/* paint_updateable_field
 * ----------------------
 */
PROCEDURE paint_updateable_field(p_attribute_index NUMBER,
                                 p_result_index    NUMBER,
                                 p_current_col     NUMBER) IS
BEGIN

  htp.p('' ||
        ''||
        '' ||
        item_lov(p_attribute_index) ||
        '');

Line: 368

END paint_updateable_field;

Line: 372

/* paint_nonupdateable_field
 * -------------------------
 */
PROCEDURE paint_nonupdateable_field(p_attribute_index NUMBER,
                                    p_result_index NUMBER,
                                    p_current_col  NUMBER,
                                    p_colspan      NUMBER DEFAULT NULL) IS
  l_colspan VARCHAR2(12);

Line: 431

END paint_nonupdateable_field;

Line: 512

         IF item_updateable(l_attribute_index) THEN

           paint_single_record_prompt(l_attribute_index);

Line: 515

           paint_updateable_field(l_attribute_index,
                                   l_result_index,
                                   l_current_col);

Line: 524

             paint_nonupdateable_field(l_attribute_index,
                                       l_result_index,
                                       l_current_col,
                                       6);

Line: 531

             paint_nonupdateable_field(l_attribute_index,
                                       l_result_index,
                                       l_current_col);

Line: 557

/* update_details
 * --------------
 */
PROCEDURE update_details(pos_asn_line_id            IN VARCHAR2 DEFAULT NULL,
                         pos_asn_line_split_id      IN VARCHAR2 DEFAULT NULL,
                         pos_expected_receipt_date  IN VARCHAR2 DEFAULT NULL,
                         pos_packing_slip           IN VARCHAR2 DEFAULT NULL,
                         pos_waybill_airbill_num    IN VARCHAR2 DEFAULT NULL,
                         pos_bill_of_lading         IN VARCHAR2 DEFAULT NULL,
                         pos_barcode_label          IN VARCHAR2 DEFAULT NULL,
                         pos_country_of_origin      IN VARCHAR2 DEFAULT NULL,
                         pos_country_of_origin_code IN VARCHAR2 DEFAULT NULL,
                         pos_vendor_cum_shipped_qty IN VARCHAR2 DEFAULT NULL,
                         pos_num_of_containers      IN VARCHAR2 DEFAULT NULL,
                         pos_container_num          IN VARCHAR2 DEFAULT NULL,
                         pos_vendor_lot_num         IN VARCHAR2 DEFAULT NULL,
                         pos_freight_carrier        IN VARCHAR2 DEFAULT NULL,
                         pos_freight_carrier_code   IN VARCHAR2 DEFAULT NULL,
                         pos_truck_num              IN VARCHAR2 DEFAULT NULL,
                         pos_reason_id              IN VARCHAR2 DEFAULT NULL,
                         pos_reason_name            IN VARCHAR2 DEFAULT NULL,
                         pos_ship_to_organization_id IN VARCHAR2 DEFAULT NULL)

IS

  l_format_mask        icx_sessions.DATE_FORMAT_MASK%TYPE;

Line: 588

  select date_format_mask
    into l_format_mask
    from icx_sessions
   where session_id = l_session_id;

Line: 595

  UPDATE pos_asn_shop_cart_details SET

    expected_receipt_date  = fnd_date.chardate_to_date(pos_expected_receipt_date),
    packing_slip           = pos_packing_slip,
    waybill_airbill_num    = pos_waybill_airbill_num,
    bill_of_lading         = pos_bill_of_lading,
    barcode_label          = pos_barcode_label,
    country_of_origin_code = pos_country_of_origin_code,
    vendor_cum_shipped_qty = to_number(pos_vendor_cum_shipped_qty),
    num_of_containers      = to_number(pos_num_of_containers),
    container_num          = pos_container_num,
    vendor_lot_num         = pos_vendor_lot_num,
    freight_carrier_code   = pos_freight_carrier_code,
    truck_num              = pos_truck_num,
    reason_id              = to_number(pos_reason_id)

  WHERE asn_line_id = to_number(pos_asn_line_id) AND
        asn_line_split_id = to_number(pos_asn_line_split_id) AND
        session_id = l_session_id;

Line: 622

END update_details;