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_CMN_RG_23D_TRXS_PKG dependencies on JAI_CMN_RG_23D_TRXS_S

Line 28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,

24: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE,
25: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE,
26: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE,
27: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE,
28: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE,
29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,

Line 33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,

29: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE,
30: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE,
31: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE,
32: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE,
33: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE,
34: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE,
35: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE,
36: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE,
37: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE,

Line 246: JAI_CMN_RG_23D_TRXS_S.nextval,

242: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
243: other_tax_credit,
244: other_tax_debit
245: ) VALUES (
246: JAI_CMN_RG_23D_TRXS_S.nextval,
247: P_ORGANIZATION_ID,
248: P_LOCATION_ID,
249: ln_slno, --
250: ln_fin_year, --

Line 335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,

331:
332: P_REGISTER_ID IN JAI_CMN_RG_23D_TRXS.register_id%TYPE DEFAULT NULL,
333: P_ORGANIZATION_ID IN JAI_CMN_RG_23D_TRXS.organization_id%TYPE DEFAULT NULL,
334: P_LOCATION_ID IN JAI_CMN_RG_23D_TRXS.location_id%TYPE DEFAULT NULL,
335: P_SLNO IN JAI_CMN_RG_23D_TRXS.slno%TYPE DEFAULT NULL,
336: P_FIN_YEAR IN JAI_CMN_RG_23D_TRXS.fin_year%TYPE DEFAULT NULL,
337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,

Line 341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,

337: P_TRANSACTION_TYPE IN JAI_CMN_RG_23D_TRXS.transaction_type%TYPE DEFAULT NULL,
338: P_RECEIPT_ID IN JAI_CMN_RG_23D_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,
339: P_QUANTITY_RECEIVED IN JAI_CMN_RG_23D_TRXS.quantity_received%TYPE DEFAULT NULL,
340: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23D_TRXS.inventory_item_id%TYPE DEFAULT NULL,
341: P_SUBINVENTORY IN JAI_CMN_RG_23D_TRXS.subinventory%TYPE DEFAULT NULL,
342: P_REFERENCE_LINE_ID IN JAI_CMN_RG_23D_TRXS.reference_line_id%TYPE DEFAULT NULL,
343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,

Line 347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,

343: P_PRIMARY_UOM_CODE IN JAI_CMN_RG_23D_TRXS.primary_uom_code%TYPE DEFAULT NULL,
344: P_TRANSACTION_UOM_CODE IN JAI_CMN_RG_23D_TRXS.transaction_uom_code%TYPE DEFAULT NULL,
345: P_CUSTOMER_ID IN JAI_CMN_RG_23D_TRXS.customer_id%TYPE DEFAULT NULL,
346: P_BILL_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.bill_to_site_id%TYPE DEFAULT NULL,
347: P_SHIP_TO_SITE_ID IN JAI_CMN_RG_23D_TRXS.ship_to_site_id%TYPE DEFAULT NULL,
348: P_QUANTITY_ISSUED IN JAI_CMN_RG_23D_TRXS.quantity_issued%TYPE DEFAULT NULL,
349: P_REGISTER_CODE IN JAI_CMN_RG_23D_TRXS.register_code%TYPE DEFAULT NULL,
350: P_RELEASED_DATE IN JAI_CMN_RG_23D_TRXS.released_date%TYPE DEFAULT NULL,
351: P_COMM_INVOICE_NO IN JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE DEFAULT NULL,

Line 400: UPDATE JAI_CMN_RG_23D_TRXS SET

396: ) IS
397: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_23d_trxs_pkg.update_row'; /* Added by Ramananda for bug#4407165 */
398: BEGIN
399:
400: UPDATE JAI_CMN_RG_23D_TRXS SET
401: REGISTER_ID = nvl(P_REGISTER_ID, REGISTER_ID),
402: ORGANIZATION_ID = nvl(P_ORGANIZATION_ID, ORGANIZATION_ID),
403: LOCATION_ID = nvl(P_LOCATION_ID, LOCATION_ID),
404: SLNO = nvl(P_SLNO, SLNO),

Line 611: SELECT JAI_CMN_RG_23D_TRXS_S.nextval

607: v_closing_bal_qty Number :=0;
608: v_opening_bal_qty Number :=0;
609:
610: Cursor get_regid_cur IS
611: SELECT JAI_CMN_RG_23D_TRXS_S.nextval
612: FROM dual;
613:
614: CURSOR fin_year_CUR is
615: SELECT max(fin_year) fin_year