APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 29: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;

25: v_interface_line_attribute3 VARCHAR2(30); -- := pr_new.interface_line_attribute3;
26: v_interface_line_attribute6 VARCHAR2(30);
27: v_customer_trx_line_id number;
28: v_header_id number;
29: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
30: CURSOR SO_PICKING_RECORD_CHECK IS
31: SELECT 1
32: FROM JAI_OM_WSH_LINES_ALL A,WSH_NEW_DELIVERIES B
33: WHERE A.delivery_id = B.DELIVERY_ID AND

Line 3191: FROM JAI_OM_OE_BOND_REG_HDRS

3187: t_rec_old jai_ar_trxs%rowtype;
3188:
3189: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS
3190: SELECT register_code
3191: FROM JAI_OM_OE_BOND_REG_HDRS
3192: WHERE organization_id = p_org_id
3193: AND location_id = p_loc_id
3194: AND register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
3195: WHERE order_type_id = p_batch_source_id AND order_flag ='N');

Line 4407: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;

4403: v_tax_line_count NUMBER;
4404: J_organization_id NUMBER;
4405: J_location_id NUMBER;
4406: J_batch_source_id NUMBER;
4407: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4408:
4409: CURSOR get_header_info_cur IS
4410: SELECT A.organization_id,
4411: A.location_id,

Line 4422: FROM JAI_OM_OE_BOND_REG_HDRS

4418: CURSOR get_register_code_cur(p_organization_id NUMBER,
4419: p_location_id NUMBER,
4420: p_batch_source_id NUMBER) IS
4421: SELECT register_code
4422: FROM JAI_OM_OE_BOND_REG_HDRS
4423: WHERE organization_id = p_organization_id
4424: AND location_id = p_location_id
4425: AND register_id IN (SELECT register_id
4426: FROM JAI_OM_OE_BOND_REG_DTLS

Line 4951: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;

4947: link_to_cust_trx_line_id = pr_new.customer_trx_line_id ;
4948:
4949:
4950: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;
4951: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;
4952: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4953:
4954: CURSOR check_reference_existed
4955: IS

Line 4952: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;

4948:
4949:
4950: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;
4951: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;
4952: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4953:
4954: CURSOR check_reference_existed
4955: IS
4956: SELECT 1