DBA Data[Home] [Help]

APPS.JAI_CMN_RG_23AC_II_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS_S

Line 247: JAI_CMN_RG_23AC_II_TRXS_S.nextval, -- P_REGISTER_ID,

243: -- following two parameter added by Vijay Shankar for Bug#3940588 as part of Edu Cess Enhancement
244: other_tax_credit,
245: other_tax_debit
246: ) VALUES (
247: JAI_CMN_RG_23AC_II_TRXS_S.nextval, -- P_REGISTER_ID,
248: ln_fin_year, --P_FIN_YEAR,
249: ln_slno, --P_SLNO,
250: ln_transaction_id, --P_TRANSACTION_ID,
251: P_INVENTORY_ITEM_ID,

Line 326: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,

322: PROCEDURE update_row(
323:
324: P_REGISTER_ID IN JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE DEFAULT NULL,
325: P_FIN_YEAR IN JAI_CMN_RG_23AC_II_TRXS.fin_year%TYPE DEFAULT NULL,
326: P_SLNO IN JAI_CMN_RG_23AC_II_TRXS.slno%TYPE DEFAULT NULL,
327: P_TRANSACTION_ID IN JAI_CMN_RG_23AC_II_TRXS.TRANSACTION_SOURCE_NUM%TYPE DEFAULT NULL,
328: P_INVENTORY_ITEM_ID IN JAI_CMN_RG_23AC_II_TRXS.inventory_item_id%TYPE DEFAULT NULL,
329: P_ORGANIZATION_ID IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE DEFAULT NULL,
330: P_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE DEFAULT NULL,

Line 370: UPDATE JAI_CMN_RG_23AC_II_TRXS SET

366: P_ADDITIONAL_CVD IN NUMBER DEFAULT NULL -- Harshita for bug 5096787
367: ) IS
368: BEGIN
369:
370: UPDATE JAI_CMN_RG_23AC_II_TRXS SET
371: REGISTER_ID = nvl(P_REGISTER_ID, REGISTER_ID),
372: FIN_YEAR = nvl(P_FIN_YEAR, FIN_YEAR),
373: SLNO = nvl(P_SLNO, SLNO),
374: TRANSACTION_SOURCE_NUM = nvl(P_TRANSACTION_ID, TRANSACTION_SOURCE_NUM),