APPS.JAI_CMN_RG_MASTER_ORG_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 1262: FROM JAI_CMN_RG_I_TRXS a, JAI_CMN_INVENTORY_ORGS b

1258: AND location_id = nvl(p_location_id,0);
1259:
1260: CURSOR rgi_register_id_cur(p_ec_code IN VARCHAR2) IS
1261: SELECT register_id
1262: FROM JAI_CMN_RG_I_TRXS a, JAI_CMN_INVENTORY_ORGS b
1263: WHERE ( a.posted_flag IS NULL OR a.posted_flag = 'N' ) --rchandan for bug#4428980
1264: AND ( a.master_flag IS NULL OR a.master_flag = 'N' ) --rchandan for bug#4428980
1265: AND a.organization_id = b.organization_id
1266: AND a.location_id = b.location_id

Line 1273: FROM JAI_CMN_RG_I_TRXS a

1269: ORDER BY a.inventory_item_id, a.Register_Id;
1270:
1271: CURSOR rgi_cur(p_register_id IN NUMBER) IS
1272: SELECT *
1273: FROM JAI_CMN_RG_I_TRXS a
1274: WHERE a.register_id = p_register_id;
1275:
1276: CURSOR balance_cur(p_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
1277: p_inventory_item_id IN Number, p_fin_year IN Number) IS

Line 1280: FROM JAI_CMN_RG_I_TRXS

1276: CURSOR balance_cur(p_serial_no IN NUMBER, p_organization_id IN Number, p_location_id IN Number,
1277: p_inventory_item_id IN Number, p_fin_year IN Number) IS
1278: SELECT NVL(balance_packed, 0), NVL(balance_loose, 0)
1279: , nvl(manufactured_qty, 0) -- Vijay Shankar for Bug# 3165687
1280: FROM JAI_CMN_RG_I_TRXS
1281: WHERE slno = p_serial_no
1282: AND organization_id = p_organization_id
1283: AND location_id = nvl(p_location_id,0)
1284: AND fin_year = p_fin_year

Line 1289: FROM JAI_CMN_RG_I_TRXS

1285: AND inventory_item_id = p_inventory_item_id;
1286:
1287: CURSOR c_max_fin_year(p_organization_id IN NUMBER, p_location_id IN NUMBER, p_inventory_item_id NUMBER) IS
1288: SELECT max(fin_year)
1289: FROM JAI_CMN_RG_I_TRXS
1290: WHERE organization_id = p_organization_id
1291: AND location_id = nvl(p_location_id,0)
1292: AND inventory_item_id = p_inventory_item_id;
1293:

Line 1296: FROM JAI_CMN_RG_I_TRXS

1292: AND inventory_item_id = p_inventory_item_id;
1293:
1294: CURSOR serial_no_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER, p_inventory_item_id NUMBER, p_fin_year NUMBER) IS
1295: SELECT nvl(max(slno), 0)
1296: FROM JAI_CMN_RG_I_TRXS
1297: WHERE organization_id = p_organization_id
1298: AND location_id = nvl(p_location_id,0)
1299: AND inventory_item_id = p_inventory_item_id
1300: AND fin_year = p_fin_year;

Line 1475: INSERT INTO JAI_CMN_RG_I_TRXS ( register_id,

1471: ||', serial_no->' || v_serial_no);
1472: END IF;
1473:
1474: v_statement_id := '8';
1475: INSERT INTO JAI_CMN_RG_I_TRXS ( register_id,
1476: register_id_part_ii,
1477: fin_year,
1478: slno,
1479: TRANSACTION_SOURCE_NUM,

Line 1588: UPDATE JAI_CMN_RG_I_TRXS

1584: 'N',
1585: 'Y' );
1586:
1587: v_statement_id := '9';
1588: UPDATE JAI_CMN_RG_I_TRXS
1589: SET posted_flag = 'Y',
1590: master_flag = 'N'
1591: WHERE register_id = rgi_rec.register_id;
1592: