APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 1183: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;

1179:
1180: J_organization_id NUMBER;
1181: J_location_id NUMBER;
1182: J_batch_source_id NUMBER;
1183: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
1184:
1185: CURSOR get_header_info_cur IS
1186: SELECT A.organization_id,
1187: A.location_id,

Line 1198: FROM JAI_OM_OE_BOND_REG_HDRS

1194: CURSOR get_register_code_cur(p_organization_id NUMBER,
1195: p_location_id NUMBER,
1196: p_batch_source_id NUMBER) IS
1197: SELECT register_code
1198: FROM JAI_OM_OE_BOND_REG_HDRS
1199: WHERE organization_id = p_organization_id
1200: AND location_id = p_location_id
1201: AND register_id IN (SELECT register_id
1202: FROM JAI_OM_OE_BOND_REG_DTLS

Line 1264: FROM JAI_OM_OE_BOND_REG_HDRS

1260: location_id = p_location_id;
1261:
1262: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS
1263: SELECT register_code
1264: FROM JAI_OM_OE_BOND_REG_HDRS
1265: WHERE organization_id = p_org_id AND
1266: location_id = p_loc_id AND
1267: register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
1268: WHERE order_type_id = p_batch_source_id AND order_flag ='N');

Line 2701: introduction of 3 new columns in the JAI_OM_OE_BOND_REG_HDRS table and also call to the new package jai_cmn_bond_register_pkg.

2697:
2698: For Multiple Bond Register Enhancement,
2699: Instead of using the cursors for fetching the register associated with the invoice type , a call has been made to the procedures
2700: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
2701: introduction of 3 new columns in the JAI_OM_OE_BOND_REG_HDRS table and also call to the new package jai_cmn_bond_register_pkg.
2702:
2703: This fix has introduced huge dependency . All future changes in this object should have this bug as a prereq
2704:
2705:

Line 4699: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;

4695: link_to_cust_trx_line_id = pr_new.customer_trx_line_id ;
4696: /*added by csahoo for bug#6407648, end*/
4697:
4698: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;
4699: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;
4700: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4701: /*
4702: || End of bug4567935 (115 bug4404898)
4703: */

Line 4700: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;

4696: /*added by csahoo for bug#6407648, end*/
4697:
4698: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;
4699: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;
4700: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4701: /*
4702: || End of bug4567935 (115 bug4404898)
4703: */
4704: