[Home] [Help]
132: v_tot_addl_ed_amt NUMBER ;
133: v_tot_oth_ed_amt NUMBER ;
134: v_old_register JAI_OM_WSH_LINES_ALL.REGISTER%TYPE ;
135: v_old_excise_invoice_no VARCHAR2(200) ;
136: v_status_code WSH_NEW_DELIVERIES.STATUS_CODE%TYPE ;
137: v_org_id NUMBER ; --2001/04/01 Vijay
138: v_source_line_id_pick NUMBER ;
139: v_no_records_fetched NUMBER := 0 ; --28/05/02 cbabu for debug
140: v_trans_type_up VARCHAR2(3) ;
423:
424: --Anuradha Parthasarathy
425: CURSOR get_delivery_status(p_delivery_id NUMBER) IS
426: SELECT status_code,initial_pickup_date
427: FROM Wsh_New_deliveries
428: WHERE delivery_id = p_delivery_id;
429: ----------------------------------------------
430: --Cursor added by Jagdish on 2001/09/13
431: CURSOR get_order_line_id(p_delivery_detail_id NUMBER) IS
448: /* Ramananda for File.Sql.35 */
449: 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'
450: v_std_text varchar2(50); -- := 'India Localization Entry for sales order # '; -- bug # 3158976
451: v_ref_23 gl_interface.reference23%type; -- := 'process_delivery'; -- holds the object name -- 'process_delivery'
452: v_ref_24 gl_interface.reference24%type; -- := 'wsh_new_deliveries'; -- holds the table name -- ' wsh_new_deliveries'
453: v_ref_25 gl_interface.reference25%type; -- := 'delivery_id'; -- holds the column name -- 'delivery_id'
454: /* Ramananda for File.Sql.35 */
455:
456: v_ref_26 gl_interface.reference26%type ; -- holds the column value -- eg -- 13645
1187: v_category_name := 'Register India' ;
1188: v_ref_10 := 'India Localization Entry for sales order # '; -- will hold a standard text such as 'India Localization Entry for sales order'
1189: v_std_text := 'India Localization Entry for sales order # '; -- bug # 3158976
1190: v_ref_23 := 'process_delivery'; -- holds the object name -- 'process_delivery'
1191: v_ref_24 := 'wsh_new_deliveries'; -- holds the table name -- ' wsh_new_deliveries'
1192: v_ref_25 := 'delivery_id'; -- holds the column name -- 'delivery_id';
1193: /* Ramananda for File.Sql.35 */
1194:
1195: lv_block_no := '0';
1204: not exists
1205: ( select 1
1206: FROM
1207: wsh_delivery_details wdd ,
1208: wsh_new_deliveries wnd ,
1209: wsh_delivery_assignments wda
1210: WHERE
1211: wdd.delivery_detail_id = wda.delivery_detail_id AND
1212: wda.Delivery_Id = wnd.Delivery_Id AND