[Home] [Help]
127: v_tot_addl_ed_amt NUMBER ;
128: v_tot_oth_ed_amt NUMBER ;
129: v_old_register JAI_OM_WSH_LINES_ALL.REGISTER%TYPE ;
130: v_old_excise_invoice_no VARCHAR2(200) ;
131: v_status_code WSH_NEW_DELIVERIES.STATUS_CODE%TYPE ;
132: v_org_id NUMBER ; --2001/04/01 Vijay
133: v_source_line_id_pick NUMBER ;
134: v_no_records_fetched NUMBER := 0 ; --28/05/02 cbabu for debug
135: v_trans_type_up VARCHAR2(3) ;
410:
411: --Anuradha Parthasarathy
412: CURSOR get_delivery_status(p_delivery_id NUMBER) IS
413: SELECT status_code,initial_pickup_date
414: FROM Wsh_New_deliveries
415: WHERE delivery_id = p_delivery_id;
416: ----------------------------------------------
417: --Cursor added by Jagdish on 2001/09/13
418: CURSOR get_order_line_id(p_delivery_detail_id NUMBER) IS
435: /* Ramananda for File.Sql.35 */
436: v_ref_10 gl_interface.reference10%type; -- := 'India Localization Entry for sales order # '; -- will hold a standard text such as 'India Localization Entry for sales order'
437: v_std_text varchar2(50); -- := 'India Localization Entry for sales order # '; -- bug # 3158976
438: v_ref_23 gl_interface.reference23%type; -- := 'process_delivery'; -- holds the object name -- 'process_delivery'
439: v_ref_24 gl_interface.reference24%type; -- := 'wsh_new_deliveries'; -- holds the table name -- ' wsh_new_deliveries'
440: v_ref_25 gl_interface.reference25%type; -- := 'delivery_id'; -- holds the column name -- 'delivery_id'
441: /* Ramananda for File.Sql.35 */
442:
443: v_ref_26 gl_interface.reference26%type ; -- holds the column value -- eg -- 13645
1107: v_category_name := 'Register India' ;
1108: v_ref_10 := 'India Localization Entry for sales order # '; -- will hold a standard text such as 'India Localization Entry for sales order'
1109: v_std_text := 'India Localization Entry for sales order # '; -- bug # 3158976
1110: v_ref_23 := 'process_delivery'; -- holds the object name -- 'process_delivery'
1111: v_ref_24 := 'wsh_new_deliveries'; -- holds the table name -- ' wsh_new_deliveries'
1112: v_ref_25 := 'delivery_id'; -- holds the column name -- 'delivery_id';
1113: /* Ramananda for File.Sql.35 */
1114:
1115: lv_block_no := '0';
1124: not exists
1125: ( select 1
1126: FROM
1127: wsh_delivery_details wdd ,
1128: wsh_new_deliveries wnd ,
1129: wsh_delivery_assignments wda
1130: WHERE
1131: wdd.delivery_detail_id = wda.delivery_detail_id AND
1132: wda.Delivery_Id = wnd.Delivery_Id AND