[Home] [Help]
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
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
932: END IF; --aaa
933:
934: IF v_insert_flag = 1 THEN --bbb
935: IF v_rg23_flag = 1 THEN
936: INSERT INTO JAI_CMN_RG_23AC_I_TRXS(
937: register_id, fin_year, slno, last_update_date, last_updated_by,
938: creation_date, created_by, last_update_login, TRANSACTION_SOURCE_NUM, inventory_item_id,
939: organization_id, transaction_type, range_no, division_no, GOODS_ISSUE_ID_REF,
940: goods_issue_date, goods_issue_quantity, OTH_RECEIPT_ID_REF, oth_receipt_date, oth_receipt_quantity,
940: goods_issue_date, goods_issue_quantity, OTH_RECEIPT_ID_REF, oth_receipt_date, oth_receipt_quantity,
941: register_type, location_id, transaction_uom_code, transaction_date,
942: opening_balance_qty, closing_balance_qty, primary_uom_code
943: ) VALUES (
944: JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno, pr_new.last_update_date, pr_new.last_updated_by,
945: SYSDATE, pr_new.created_by, pr_new.last_update_login, v_temp_trans_type_id, v_temp_inv_item_id,
946: v_temp_organization_id, v_t_type, v_temp_range_no, v_temp_division_no, v_iss_id,
947: v_iss_date, v_iss_qty, v_rec_id, v_rec_date, v_rec_qty,
948: v_reg_type, v_temp_loc_id, v_temp_trans_uom, TRUNC (v_temp_trans_date),
1331: v_closing_qty := v_new_trans_qty;
1332: END IF;
1333: END IF;
1334:
1335: INSERT INTO JAI_CMN_RG_23AC_I_TRXS
1336: (register_id, fin_year, slno,
1337: last_update_date, last_updated_by, creation_date,
1338: created_by, last_update_login,
1339: TRANSACTION_SOURCE_NUM, inventory_item_id,
1343: oth_receipt_date, oth_receipt_quantity,
1344: register_type, location_id, transaction_uom_code,
1345: transaction_date, opening_balance_qty,
1346: closing_balance_qty, primary_uom_code)
1347: VALUES (JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
1348: pr_new.last_update_date, pr_new.last_updated_by, SYSDATE,
1349: pr_new.created_by, pr_new.last_update_login,
1350: pr_new.transaction_type_id, pr_new.inventory_item_id,
1351: pr_new.organization_id, v_t_type, v_range_no,
1552:
1553: END IF;
1554:
1555: IF v_hit_rg23_qty > 0 THEN
1556: INSERT INTO JAI_CMN_RG_23AC_I_TRXS
1557: (register_id,
1558: fin_year,
1559: slno,
1560: last_update_date,
1579: transaction_date,
1580: opening_balance_qty,
1581: closing_balance_qty,
1582: primary_uom_code)
1583: VALUES (JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL,
1584: v_f_year,
1585: v_srno,
1586: pr_new.last_update_date,
1587: pr_new.last_updated_by,
1844: v_closing_qty := v_new_trans_qty;
1845: END IF;
1846: END IF;
1847:
1848: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (
1849: register_id, fin_year, slno,
1850: last_update_date, last_updated_by, creation_date,
1851: created_by, last_update_login,
1852: TRANSACTION_SOURCE_NUM, inventory_item_id,
1857: transaction_uom_code, transaction_date,
1858: opening_balance_qty, closing_balance_qty,
1859: primary_uom_code
1860: ) VALUES (
1861: JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
1862: pr_new.last_update_date, pr_new.last_updated_by, SYSDATE,
1863: pr_new.created_by, pr_new.last_update_login,
1864: pr_new.transaction_type_id, pr_new.inventory_item_id,
1865: pr_new.organization_id, v_t_type, v_range_no,
2101: IF v_hit_rg23_qty > 0 THEN
2102:
2103: v_iss_qty := v_hit_rg23_qty;
2104:
2105: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (
2106: register_id, fin_year, slno,
2107: last_update_date, last_updated_by, creation_date,
2108: created_by, last_update_login,
2109: TRANSACTION_SOURCE_NUM, inventory_item_id,
2114: transaction_uom_code, transaction_date,
2115: opening_balance_qty, closing_balance_qty,
2116: primary_uom_code
2117: ) VALUES (
2118: JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2119: pr_new.last_update_date, pr_new.last_updated_by, SYSDATE,
2120: pr_new.created_by, pr_new.last_update_login,
2121: pr_new.transaction_type_id, pr_new.inventory_item_id,
2122: pr_new.organization_id, v_t_type, v_range_no,
2408: v_closing_qty := v_new_trans_qty;
2409: END IF;
2410: END IF;
2411:
2412: INSERT INTO JAI_CMN_RG_23AC_I_TRXS
2413: (register_id, fin_year, slno,
2414: last_update_date, last_updated_by, creation_date,
2415: created_by, last_update_login,
2416: TRANSACTION_SOURCE_NUM, inventory_item_id,
2420: oth_receipt_date, oth_receipt_quantity,
2421: register_type, location_id, transaction_uom_code,
2422: transaction_date, opening_balance_qty,
2423: closing_balance_qty, primary_uom_code)
2424: VALUES (JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, v_f_year, v_srno,
2425: pr_new.last_update_date, pr_new.last_updated_by, SYSDATE,
2426: pr_new.created_by, pr_new.last_update_login,
2427: pr_new.transaction_type_id, pr_new.inventory_item_id,
2428: pr_new.organization_id, v_t_type, v_range_no,