APPS.JAI_OM_WSH_PKG dependencies on DUAL

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

1848: jai_constants.source_wsh
1849: );
1850:
1851: lv_statement_no := '31';
1852: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
1853: 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 );
1854: ELSIF v_item_class IN ('CGEX','CGIN') THEN
1855: v_qty_reg_type := 'C';
1856:

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

1899: v_last_updated_by ,
1900: v_last_update_login
1901: );
1902: lv_statement_no := '33';
1903: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
1904: 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 );
1905: END IF;
1906: END IF;
1907: -- Start of Bug 3446362

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

2032: END IF;
2033:
2034: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') and nvl(v_excise_exempt_type,'$$$') not in ('CT3') THEN -- sriram - bug# 3368475
2035:
2036: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2037: IF v_reg_type IN( 'RG23A','RG23C') THEN
2038: lv_statement_no := '36';
2039: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2040: lv_statement_no := '37';

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

2035:
2036: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2037: IF v_reg_type IN( 'RG23A','RG23C') THEN
2038: lv_statement_no := '36';
2039: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2040: lv_statement_no := '37';
2041: UPDATE
2042: JAI_CMN_RG_I_TRXS
2043: SET

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

2052: WHERE
2053: register_id = v_rg23_part_i_no;
2054: ELSIF v_reg_type IN( 'PLA') THEN
2055: lv_statement_no := '38';
2056: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2057: lv_statement_no := '39';
2058: UPDATE
2059: JAI_CMN_RG_I_TRXS
2060: SET

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

2071: END IF;
2072:
2073: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') and nvl(v_excise_exempt_type,'$$$') not in ('CT3') THEN -- sriram - bug# 3368475
2074: lv_statement_no := '40';
2075: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2076: IF v_reg_type IN( 'RG23A','RG23C')
2077: THEN
2078: lv_statement_no := '41';
2079: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

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

2075: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2076: IF v_reg_type IN( 'RG23A','RG23C')
2077: THEN
2078: lv_statement_no := '41';
2079: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2080: lv_statement_no := '42';
2081: UPDATE JAI_CMN_RG_23AC_I_TRXS
2082: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
2083: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID

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

2085: WHERE register_id = v_rg23_part_ii_no)
2086: WHERE register_id = v_rg23_part_i_no;
2087: ELSIF v_reg_type IN( 'PLA') THEN
2088: lv_statement_no := '43';
2089: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2090: lv_statement_no := '44';
2091: UPDATE
2092: JAI_CMN_RG_23AC_I_TRXS
2093: SET

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

2262: END IF;
2263:
2264: --END 7043292
2265: lv_statement_no := '54';
2266: SELECT JAI_CMN_RG_23D_TRXS_S.NEXTVAL INTO v_register_id FROM Dual;
2267:
2268: lv_statement_no := '59';
2269:
2270: jai_om_rg_pkg.Ja_In_Rg23d_Entry(