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_CMN_RG_23AC_I_TRXS

Line 138: FROM JAI_CMN_RG_23AC_I_TRXS

134: p_f_year IN NUMBER
135: )
136: IS
137: SELECT MAX (slno)
138: FROM JAI_CMN_RG_23AC_I_TRXS
139: WHERE organization_id = p_organization_id
140: AND location_id = p_loc_id
141: AND inventory_item_id = p_inv_item_id
142: AND register_type = p_reg_type

Line 181: FROM JAI_CMN_RG_23AC_I_TRXS

177: p_f_year IN NUMBER
178: )
179: IS
180: SELECT opening_balance_qty, closing_balance_qty
181: FROM JAI_CMN_RG_23AC_I_TRXS
182: WHERE slno = p_sr_no
183: AND organization_id = p_organization_id
184: AND location_id = p_loc_id
185: AND register_type = p_reg_type

Line 813: /Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS/

809: OPEN srno_i_cur ( v_temp_organization_id, v_temp_inv_item_id, v_temp_loc_id, v_reg_type, v_f_year );
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;

Line 1034: INSERT INTO JAI_CMN_RG_23AC_I_TRXS(

1030: end if;
1031: END IF;
1032: /*end bug 9122545*/
1033: --added rounding precision of 5 fro bug 9466919
1034: INSERT INTO JAI_CMN_RG_23AC_I_TRXS(
1035: register_id, fin_year, slno, last_update_date, last_updated_by,
1036: creation_date, created_by, last_update_login, TRANSACTION_SOURCE_NUM, inventory_item_id,
1037: organization_id, transaction_type, range_no, division_no, GOODS_ISSUE_ID_REF,
1038: goods_issue_date, goods_issue_quantity, OTH_RECEIPT_ID_REF, oth_receipt_date, oth_receipt_quantity,

Line 1042: JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno, pr_new.last_update_date, pr_new.last_updated_by,

1038: goods_issue_date, goods_issue_quantity, OTH_RECEIPT_ID_REF, oth_receipt_date, oth_receipt_quantity,
1039: register_type, location_id, transaction_uom_code, transaction_date,
1040: opening_balance_qty, closing_balance_qty, primary_uom_code
1041: ) VALUES (
1042: JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno, pr_new.last_update_date, pr_new.last_updated_by,
1043: SYSDATE, pr_new.created_by, pr_new.last_update_login, v_temp_trans_type_id, v_temp_inv_item_id,
1044: v_temp_organization_id, v_t_type, v_temp_range_no, v_temp_division_no, v_iss_id,
1045: v_iss_date, round(v_iss_qty,5), v_rec_id, v_rec_date, round(v_rec_qty,5),
1046: v_reg_type, v_temp_loc_id, v_temp_trans_uom, TRUNC (v_temp_trans_date),

Line 1177: /Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS/

1173: OPEN srno_i_cur ( pr_new.organization_id, pr_new.inventory_item_id, v_loc_id, v_reg_type, v_f_year );
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:

Line 1438: /Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS/

1434: OPEN srno_i_cur(pr_new.organization_id, pr_new.inventory_item_id, v_loc_id, v_reg_type, v_f_year );
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*/

Line 1493: INSERT INTO JAI_CMN_RG_23AC_I_TRXS

1489: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20110, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
1490: end if;
1491: END IF;
1492: /*End bug 9122545*/
1493: INSERT INTO JAI_CMN_RG_23AC_I_TRXS
1494: (register_id, fin_year, slno,
1495: last_update_date, last_updated_by, creation_date,
1496: created_by, last_update_login,
1497: TRANSACTION_SOURCE_NUM, inventory_item_id,

Line 1505: VALUES (JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,

1501: oth_receipt_date, oth_receipt_quantity,
1502: register_type, location_id, transaction_uom_code,
1503: transaction_date, opening_balance_qty,
1504: closing_balance_qty, primary_uom_code)
1505: VALUES (JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
1506: pr_new.last_update_date, pr_new.last_updated_by, SYSDATE,
1507: pr_new.created_by, pr_new.last_update_login,
1508: pr_new.transaction_type_id, pr_new.inventory_item_id,
1509: pr_new.organization_id, v_t_type, v_range_no,

Line 1673: /Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS/

1669: OPEN srno_i_cur(pr_new.organization_id, pr_new.inventory_item_id, v_loc_id, v_reg_type, v_f_year );
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

Line 1748: INSERT INTO JAI_CMN_RG_23AC_I_TRXS

1744: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20111, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
1745: end if;
1746: END IF;
1747: /*end bug 9122545*/
1748: INSERT INTO JAI_CMN_RG_23AC_I_TRXS
1749: (register_id,
1750: fin_year,
1751: slno,
1752: last_update_date,

Line 1775: VALUES (JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL,

1771: transaction_date,
1772: opening_balance_qty,
1773: closing_balance_qty,
1774: primary_uom_code)
1775: VALUES (JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL,
1776: v_f_year,
1777: v_srno,
1778: pr_new.last_update_date,
1779: pr_new.last_updated_by,

Line 2021: /Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS/

2017: OPEN srno_i_cur ( pr_new.organization_id, pr_new.inventory_item_id, v_loc_id, v_reg_type, v_f_year );
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

Line 2074: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (

2070: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20112, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
2071: end if;
2072: END IF;
2073: /*end bug 9122545*/
2074: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (
2075: register_id, fin_year, slno,
2076: last_update_date, last_updated_by, creation_date,
2077: created_by, last_update_login,
2078: TRANSACTION_SOURCE_NUM, inventory_item_id,

Line 2087: JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,

2083: transaction_uom_code, transaction_date,
2084: opening_balance_qty, closing_balance_qty,
2085: primary_uom_code
2086: ) VALUES (
2087: JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2088: pr_new.last_update_date, pr_new.last_updated_by, SYSDATE,
2089: pr_new.created_by, pr_new.last_update_login,
2090: pr_new.transaction_type_id, pr_new.inventory_item_id,
2091: pr_new.organization_id, v_t_type, v_range_no,

Line 2292: /Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS/

2288: OPEN srno_i_cur(pr_new.organization_id, pr_new.inventory_item_id, v_loc_id, v_reg_type, v_f_year );
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

Line 2368: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (

2364: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20113, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
2365: end if;
2366: END IF;
2367: /*end bug 9122545*/
2368: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (
2369: register_id, fin_year, slno,
2370: last_update_date, last_updated_by, creation_date,
2371: created_by, last_update_login,
2372: TRANSACTION_SOURCE_NUM, inventory_item_id,

Line 2381: JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,

2377: transaction_uom_code, transaction_date,
2378: opening_balance_qty, closing_balance_qty,
2379: primary_uom_code
2380: ) VALUES (
2381: JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2382: pr_new.last_update_date, pr_new.last_updated_by, SYSDATE,
2383: pr_new.created_by, pr_new.last_update_login,
2384: pr_new.transaction_type_id, pr_new.inventory_item_id,
2385: pr_new.organization_id, v_t_type, v_range_no,

Line 2680: /Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_23AC_I_TRXS/

2676: );
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:

Line 2745: INSERT INTO JAI_CMN_RG_23AC_I_TRXS

2741: APP_EXCEPTION.RAISE_EXCEPTION('JA', -20114, 'Enough RG23 Part1 balances do not exist. Register Type,Org,Loc-'||v_reg_type||','||pr_new.organization_id||','||v_loc_id);
2742: end if;
2743: END IF;
2744: /*end bug 9122545*/
2745: INSERT INTO JAI_CMN_RG_23AC_I_TRXS
2746: (register_id, fin_year, slno,
2747: last_update_date, last_updated_by, creation_date,
2748: created_by, last_update_login,
2749: TRANSACTION_SOURCE_NUM, inventory_item_id,

Line 2757: VALUES (JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,

2753: oth_receipt_date, oth_receipt_quantity,
2754: register_type, location_id, transaction_uom_code,
2755: transaction_date, opening_balance_qty,
2756: closing_balance_qty, primary_uom_code)
2757: VALUES (JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2758: pr_new.last_update_date, pr_new.last_updated_by, SYSDATE,
2759: pr_new.created_by, pr_new.last_update_login,
2760: pr_new.transaction_type_id, pr_new.inventory_item_id,
2761: pr_new.organization_id, v_t_type, v_range_no,