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_23AC_I_TRXS_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS_S

Line 26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,

22: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE,
23: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE,
24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,

Line 27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,

23: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE,
24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,

Line 28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,

24: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE,
25: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE,
26: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE,
27: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE,
28: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE,
29: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE,
30: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE,
31: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE,
32: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE,

Line 231: JAI_CMN_RG_23AC_I_TRXS_S.nextval,

227: LAST_UPDATE_LOGIN,
228: POSTED_FLAG,
229: MASTER_FLAG
230: ) VALUES (
231: JAI_CMN_RG_23AC_I_TRXS_S.nextval,
232: ln_fin_year,
233: ln_slno,
234: ln_transaction_id,
235: P_INVENTORY_ITEM_ID,

Line 329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,

325: P_CUSTOMER_SITE_ID IN JAI_CMN_RG_23AC_I_TRXS.customer_site_id%TYPE DEFAULT NULL,
326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,

Line 330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,

326: P_GOODS_ISSUE_ID IN JAI_CMN_RG_23AC_I_TRXS.GOODS_ISSUE_ID_REF%TYPE DEFAULT NULL,
327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,

Line 331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,

327: P_GOODS_ISSUE_DATE IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_date%TYPE DEFAULT NULL,
328: P_GOODS_ISSUE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.goods_issue_quantity%TYPE DEFAULT NULL,
329: P_SALES_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.SALES_INVOICE_NO%TYPE DEFAULT NULL,
330: P_SALES_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_date%TYPE DEFAULT NULL,
331: P_SALES_INVOICE_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.sales_invoice_quantity%TYPE DEFAULT NULL,
332: P_EXCISE_INVOICE_ID IN JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE DEFAULT NULL,
333: P_EXCISE_INVOICE_DATE IN JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE DEFAULT NULL,
334: P_OTH_RECEIPT_QUANTITY IN JAI_CMN_RG_23AC_I_TRXS.oth_receipt_quantity%TYPE DEFAULT NULL,
335: P_OTH_RECEIPT_ID IN JAI_CMN_RG_23AC_I_TRXS.OTH_RECEIPT_ID_REF%TYPE DEFAULT NULL,

Line 375: UPDATE JAI_CMN_RG_23AC_I_TRXS SET

371: ld_last_update_date := SYSDATE;
372: ln_last_updated_by := FND_GLOBAL.user_id;
373: ln_last_update_login := FND_GLOBAL.login_id;
374:
375: UPDATE JAI_CMN_RG_23AC_I_TRXS SET
376: QUANTITY_RECEIVED = nvl(P_QUANTITY_RECEIVED, QUANTITY_RECEIVED),
377: RECEIPT_REF = nvl(P_RECEIPT_ID, RECEIPT_REF),
378: TRANSACTION_TYPE = nvl(P_TRANSACTION_TYPE, TRANSACTION_TYPE),
379: RECEIPT_DATE = nvl(P_RECEIPT_DATE, RECEIPT_DATE),