APPS.JAI_OM_WSH_PKG dependencies on JAI_OM_OE_GEN_TAXINV_T

Line 681: DELETE from JAI_OM_OE_GEN_TAXINV_T statement got deleted in file version 615.5(Bug# 2736191) somehow. This statement is

677: adding this condition to the if which takes care of this issue.Also taken care of register type '23D_DOM_WITHOUT_EXCISE'
678: which was not handled till now.
679:
680: 25 2003/02/19 cbabu for Bug# 2803409, FileVersion# 615.7
681: DELETE from JAI_OM_OE_GEN_TAXINV_T statement got deleted in file version 615.5(Bug# 2736191) somehow. This statement is
682: reincorporated with his bug. Bugs 2736191 and 2769436 were made obsolete and this bug needs to be send instead of them
683:
684: 26. 2003/02/20 ssumaith - Bug # 2663211 File Version # 615.8
685: Excise invoice generation logic in this procedure has been removed and instead a call to the

Line 1120: FROM JAI_OM_OE_GEN_TAXINV_T ja_tmp

1116: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1 START Delivery id = ' || p_delivery_id );
1117: FOR Each_record IN
1118: (
1119: SELECT *
1120: FROM JAI_OM_OE_GEN_TAXINV_T ja_tmp
1121: WHERE delivery_id = p_delivery_id
1122: and /*The idea of putting the exists is to see that do not process a delivery ,if it has
1123: at least one delivery detail with inv_interfaced_flag = 'N' */
1124: not exists

Line 2325: DELETE JAI_OM_OE_GEN_TAXINV_T WHERE delivery_detail_id = each_record.delivery_detail_id;

2321: END IF; --y999
2322: -- cbabu for Bug# 2803409
2323: -- This statement got deleted with Bug# 2736191
2324: lv_statement_no := '61';
2325: DELETE JAI_OM_OE_GEN_TAXINV_T WHERE delivery_detail_id = each_record.delivery_detail_id;
2326:
2327: v_bonded_flag := 'N' ;
2328: v_trading_flag := 'N' ;
2329: v_rg23a_balance := 0 ;

Line 2910: From JAI_OM_OE_GEN_TAXINV_T

2906: END IF ;
2907:
2908: ELSE
2909: FOR temp_rec IN ( Select distinct delivery_id
2910: From JAI_OM_OE_GEN_TAXINV_T
2911: )
2912: LOOP
2913: BEGIN
2914: fnd_file.put_line ( fnd_file.log , ' Calling jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id );