APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 638: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;

634: v_order_invoice_type_up VARCHAR2(25);
635: v_register_code_up VARCHAR2(25);
636: v_errbuf VARCHAR2(250);
637:
638: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
639: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
640: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
641:
642: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

Line 639: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;

635: v_register_code_up VARCHAR2(25);
636: v_errbuf VARCHAR2(250);
637:
638: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
639: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
640: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
641:
642: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
643: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;

Line 640: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;

636: v_errbuf VARCHAR2(250);
637:
638: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
639: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
640: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
641:
642: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
643: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;
644:

Line 669: FROM JAI_OM_OE_BOND_REG_HDRS

665: WHERE organization_id = p_org_id AND location_id = p_loc_id;
666:
667: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
668: SELECT register_code
669: FROM JAI_OM_OE_BOND_REG_HDRS
670: WHERE organization_id = p_org_id AND location_id = p_loc_id AND
671: register_id IN (SELECT register_id
672: FROM JAI_OM_OE_BOND_REG_DTLS
673: WHERE order_type_id = pr_new.batch_source_id AND order_flag= 'N');

Line 706: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

702: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
703: SELECT NVL(register_balance,0) register_balance
704: FROM JAI_OM_OE_BOND_TRXS
705: WHERE transaction_id = (SELECT MAX(A.transaction_id)
706: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
707: WHERE A.register_id = B.register_id
708: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
709:
710: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS

Line 714: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

710: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
711: SELECT NVL(rg23d_register_balance,0) rg23d_register_balance
712: FROM JAI_OM_OE_BOND_TRXS
713: WHERE transaction_id = (SELECT MAX(A.transaction_id)
714: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
715: WHERE A.register_id = B.register_id
716: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
717:
718: CURSOR line_cur IS