APPS.JAI_OM_WSH_PKG dependencies on DUAL

Line 1954: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;

1950: jai_constants.source_wsh
1951: );
1952:
1953: lv_statement_no := '31';
1954: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
1955: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 42.1 ja_in_rg_I_entry is made register_id -> ' || v_part_i_register_id );
1956: ELSIF v_item_class IN ('CGEX','CGIN') THEN
1957: v_qty_reg_type := 'C';
1958:

Line 2005: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;

2001: v_last_updated_by ,
2002: v_last_update_login
2003: );
2004: lv_statement_no := '33';
2005: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
2006: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 42.2 ja_in_rg23_part_I_entry is made, register_id -> ' || v_part_i_register_id );
2007: END IF;
2008: END IF;
2009: -- Start of Bug 3446362

Line 2138: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;

2134: END IF;
2135:
2136: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') and nvl(v_excise_exempt_type,'$$$') not in ('CT3') THEN -- sriram - bug# 3368475
2137:
2138: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2139: IF v_reg_type IN( 'RG23A','RG23C') THEN
2140: lv_statement_no := '36';
2141: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2142: lv_statement_no := '37';

Line 2141: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

2137:
2138: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2139: IF v_reg_type IN( 'RG23A','RG23C') THEN
2140: lv_statement_no := '36';
2141: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2142: lv_statement_no := '37';
2143: UPDATE
2144: JAI_CMN_RG_I_TRXS
2145: SET

Line 2158: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;

2154: WHERE
2155: register_id = v_rg23_part_i_no;
2156: ELSIF v_reg_type IN( 'PLA') THEN
2157: lv_statement_no := '38';
2158: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2159: lv_statement_no := '39';
2160: UPDATE
2161: JAI_CMN_RG_I_TRXS
2162: SET

Line 2177: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;

2173: END IF;
2174:
2175: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') and nvl(v_excise_exempt_type,'$$$') not in ('CT3') THEN -- sriram - bug# 3368475
2176: lv_statement_no := '40';
2177: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2178: IF v_reg_type IN( 'RG23A','RG23C')
2179: THEN
2180: lv_statement_no := '41';
2181: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

Line 2181: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

2177: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2178: IF v_reg_type IN( 'RG23A','RG23C')
2179: THEN
2180: lv_statement_no := '41';
2181: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2182: lv_statement_no := '42';
2183: UPDATE JAI_CMN_RG_23AC_I_TRXS
2184: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
2185: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID

Line 2191: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;

2187: WHERE register_id = v_rg23_part_ii_no)
2188: WHERE register_id = v_rg23_part_i_no;
2189: ELSIF v_reg_type IN( 'PLA') THEN
2190: lv_statement_no := '43';
2191: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2192: lv_statement_no := '44';
2193: UPDATE
2194: JAI_CMN_RG_23AC_I_TRXS
2195: SET

Line 2389: SELECT JAI_CMN_RG_23D_TRXS_S.NEXTVAL INTO v_register_id FROM Dual;

2385: END IF;
2386:
2387: --END 7043292
2388: lv_statement_no := '54';
2389: SELECT JAI_CMN_RG_23D_TRXS_S.NEXTVAL INTO v_register_id FROM Dual;
2390:
2391: lv_statement_no := '59';
2392:
2393: jai_om_rg_pkg.Ja_In_Rg23d_Entry(