eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_INV_MMT_TRIGGER_PKG dependencies on JAI_OM_RG_PKG

Line 814: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(v_temp_organization_id,v_temp_loc_id,v_temp_inv_item_id,v_f_year,v_reg_type,v_srno);

810: FETCH srno_i_cur INTO v_srno;
811: CLOSE srno_i_cur;
812: */
813: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS*/
814: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(v_temp_organization_id,v_temp_loc_id,v_temp_inv_item_id,v_f_year,v_reg_type,v_srno);
815: /*Bug 9550254 - End*/
816: IF NVL (v_srno, 0) = 0 THEN
817: v_srno := 1;
818: v_sr_no := 0;

Line 950: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_temp_loc_id,pr_new.inventory_item_id,v_f_year,

946: FETCH srno_ii_cur INTO v_srno1, v_bal_packed, v_bal_loose;
947: CLOSE srno_ii_cur;
948: */
949: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_I_TRXS*/
950: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_temp_loc_id,pr_new.inventory_item_id,v_f_year,
951: v_srno1,v_bal_packed);
952: /*Bug 9550254 - End*/
953:
954: --Start adding by Sriram on 18-may-01

Line 1178: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,

1174: FETCH srno_i_cur INTO v_srno;
1175: CLOSE srno_i_cur;
1176: */
1177: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS*/
1178: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,
1179: v_f_year,v_reg_type,v_srno);
1180: /*Bug 9550254 - End*/
1181:
1182: IF NVL (v_srno, 0) = 0

Line 1240: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,

1236: FETCH srno_ii_cur INTO v_srno1, v_bal_packed, v_bal_loose;
1237: CLOSE srno_ii_cur;
1238: */
1239: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_I_TRXS*/
1240: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,
1241: v_srno1,v_bal_packed);
1242: /*Bug 9550254 - End*/
1243:
1244: /*

Line 1258: /Commented for Bug 9550254 as it is already calculated by jai_om_rg_pkg.ja_in_rgi_balance above/

1254: */
1255: IF NVL (v_srno1, 0) = 0 THEN
1256: v_srno1 := 1;
1257: v_sr_no := 0;
1258: /*Commented for Bug 9550254 as it is already calculated by jai_om_rg_pkg.ja_in_rgi_balance above*/
1259: -- v_bal_packed := 0;
1260: -- v_bal_loose := 0;
1261: ELSE
1262: v_sr_no := v_srno1;

Line 1439: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,

1435: FETCH srno_i_cur INTO v_srno;
1436: CLOSE srno_i_cur;
1437: */
1438: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS*/
1439: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,
1440: v_f_year,v_reg_type,v_srno);
1441:
1442: /*Bug 9550254 - End*/
1443:

Line 1579: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,v_srno,v_bal_packed);

1575: FETCH srno_ii_cur INTO v_srno, v_bal_packed, v_bal_loose;
1576: CLOSE srno_ii_cur;
1577: */
1578: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_I_TRXS*/
1579: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,v_srno,v_bal_packed);
1580: /*Bug 9550254 - Start*/
1581:
1582: IF NVL (v_srno, 0) = 0 THEN
1583: v_srno := 1;

Line 1674: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,

1670: FETCH srno_i_cur INTO v_srno;
1671: CLOSE srno_i_cur;
1672: */
1673: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS*/
1674: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,
1675: v_f_year,v_reg_type,v_srno);
1676: /*Bug 9550254 - End*/
1677: IF NVL (v_srno, 0) = 0 THEN
1678: v_srno := 1;

Line 1815: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,

1811: FETCH srno_ii_cur INTO v_srno, v_bal_packed, v_bal_loose;
1812: CLOSE srno_ii_cur;
1813: */
1814: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_I_TRXS*/
1815: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,
1816: v_srno,v_bal_packed);
1817: /*Bug 9550254 - End*/
1818:
1819: IF NVL (v_srno, 0) = 0 THEN

Line 2022: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,

2018: FETCH srno_i_cur INTO v_srno;
2019: CLOSE srno_i_cur;
2020: */
2021: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS*/
2022: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,
2023: v_f_year,v_reg_type,v_srno);
2024: /*Bug 9550254 - End*/
2025: IF NVL (v_srno, 0) = 0 THEN
2026: v_srno := 1;

Line 2138: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,

2134: FETCH srno_ii_cur INTO v_srno, v_bal_packed, v_bal_loose;
2135: CLOSE srno_ii_cur;
2136: */
2137: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_I_TRXS*/
2138: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,
2139: v_srno,v_bal_packed);
2140:
2141: /*Bug 9550254 - End*/
2142:

Line 2146: /Commented for Bug 9550254 as they are calculated via jai_om_rg_pkg.ja_in_rgi_balance above/

2142:
2143: IF NVL (v_srno, 0) = 0 THEN
2144: v_srno := 1;
2145: v_sr_no := 0;
2146: /*Commented for Bug 9550254 as they are calculated via jai_om_rg_pkg.ja_in_rgi_balance above*/
2147: --v_bal_packed := 0;
2148: --v_bal_loose := 0;
2149: ELSE
2150: v_sr_no := v_srno;

Line 2293: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,

2289: FETCH srno_i_cur INTO v_srno;
2290: CLOSE srno_i_cur;
2291: */
2292: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS*/
2293: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,
2294: v_f_year,v_reg_type,v_srno);
2295: /*Bug 9550254 - End*/
2296: IF v_srno = 0 THEN
2297: /*Bug 9550254 - Start*/

Line 2415: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,

2411: FETCH srno_ii_cur INTO v_srno, v_bal_packed, v_bal_loose;
2412: CLOSE srno_ii_cur;
2413: */
2414: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_I_TRXS*/
2415: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,
2416: v_srno,v_bal_packed);
2417: /*Bug 9550254 - End*/
2418: IF NVL (v_srno, 0) = 0 THEN
2419: v_srno := 1;

Line 2420: /Bug 9550254 - Commented the below as it is already calculated via jai_om_rg_pkg.ja_in_rgi_balance/

2416: v_srno,v_bal_packed);
2417: /*Bug 9550254 - End*/
2418: IF NVL (v_srno, 0) = 0 THEN
2419: v_srno := 1;
2420: /*Bug 9550254 - Commented the below as it is already calculated via jai_om_rg_pkg.ja_in_rgi_balance*/
2421: -- v_bal_packed := 0;
2422: -- v_bal_loose := 0;
2423: ELSE
2424: v_srno := v_srno + 1;

Line 2681: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,

2677: FETCH srno_i_cur INTO v_srno;
2678: CLOSE srno_i_cur;
2679: */
2680: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS*/
2681: v_opening_qty := jai_om_rg_pkg.ja_in_rg23i_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,
2682: v_f_year,v_reg_type,v_srno);
2683: /*Bug 9550254 - End*/
2684:
2685: IF NVL (v_srno, 0) = 0

Line 2795: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,

2791: FETCH srno_ii_cur INTO v_srno, v_bal_packed, v_bal_loose;
2792: CLOSE srno_ii_cur;
2793: */
2794: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_I_TRXS*/
2795: v_bal_loose := jai_om_rg_pkg.ja_in_rgi_balance(pr_new.organization_id,v_loc_id,pr_new.inventory_item_id,v_f_year,
2796: v_srno,v_bal_packed);
2797: /*Bug 9550254 - End*/
2798:
2799: IF NVL (v_srno, 0) = 0