APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 1112: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;

1108:
1109: J_organization_id NUMBER;
1110: J_location_id NUMBER;
1111: J_batch_source_id NUMBER;
1112: v_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
1113:
1114: CURSOR get_header_info_cur IS
1115: SELECT A.organization_id,
1116: A.location_id,

Line 1127: FROM JAI_OM_OE_BOND_REG_HDRS

1123: CURSOR get_register_code_cur(p_organization_id NUMBER,
1124: p_location_id NUMBER,
1125: p_batch_source_id NUMBER) IS
1126: SELECT register_code
1127: FROM JAI_OM_OE_BOND_REG_HDRS
1128: WHERE organization_id = p_organization_id
1129: AND location_id = p_location_id
1130: AND register_id IN (SELECT register_id
1131: FROM JAI_OM_OE_BOND_REG_DTLS

Line 1193: FROM JAI_OM_OE_BOND_REG_HDRS

1189: location_id = p_location_id;
1190:
1191: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS
1192: SELECT register_code
1193: FROM JAI_OM_OE_BOND_REG_HDRS
1194: WHERE organization_id = p_org_id AND
1195: location_id = p_loc_id AND
1196: register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
1197: WHERE order_type_id = p_batch_source_id AND order_flag ='N');

Line 2491: 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.

2487:
2488: For Multiple Bond Register Enhancement,
2489: Instead of using the cursors for fetching the register associated with the invoice type , a call has been made to the procedures
2490: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
2491: 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.
2492:
2493: This fix has introduced huge dependency . All future changes in this object should have this bug as a prereq
2494:
2495:

Line 4368: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;

4364: link_to_cust_trx_line_id = pr_new.customer_trx_line_id ;
4365: /*added by csahoo for bug#6407648, end*/
4366:
4367: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;
4368: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;
4369: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4370: /*
4371: || End of bug4567935 (115 bug4404898)
4372: */

Line 4369: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;

4365: /*added by csahoo for bug#6407648, end*/
4366:
4367: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;
4368: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;
4369: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4370: /*
4371: || End of bug4567935 (115 bug4404898)
4372: */
4373: BEGIN