APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_OM_OE_SO_LINES

Line 1707: cursor c_get_so_line_srvtyp (cp_line_id JAI_OM_OE_SO_LINES.line_id%type ) is

1703: /*Added by Qinglei for bug#13741544 end*/
1704: AND araa.status= jai_constants.ar_status_app;
1705: --End bug#9298508
1706:
1707: cursor c_get_so_line_srvtyp (cp_line_id JAI_OM_OE_SO_LINES.line_id%type ) is
1708: select service_type_code, sum(jstl.tax_amount) service_tax_amount
1709: from JAI_OM_OE_SO_LINES jsl
1710: , JAI_OM_OE_SO_TAXES jstl
1711: , jai_cmn_taxes_all jtc

Line 1709: from JAI_OM_OE_SO_LINES jsl

1705: --End bug#9298508
1706:
1707: cursor c_get_so_line_srvtyp (cp_line_id JAI_OM_OE_SO_LINES.line_id%type ) is
1708: select service_type_code, sum(jstl.tax_amount) service_tax_amount
1709: from JAI_OM_OE_SO_LINES jsl
1710: , JAI_OM_OE_SO_TAXES jstl
1711: , jai_cmn_taxes_all jtc
1712: where jsl.line_id = cp_line_id
1713: and jsl.line_id = jstl.line_id

Line 1723: cursor c_get_rma_line_srvtyp (cp_line_id jai_om_oe_so_lines.line_id%type )

1719: group by service_type_code;
1720:
1721: /*The following cursor added by rchandan for RMA */
1722:
1723: cursor c_get_rma_line_srvtyp (cp_line_id jai_om_oe_so_lines.line_id%type )
1724: is
1725: select service_type_code, sum(jrtl.tax_amount) service_tax_amount
1726: from JAI_OM_OE_RMA_LINES jrl
1727: , JAI_OM_OE_RMA_TAXES jrtl

Line 3190: update JAI_OM_OE_SO_LINES set service_type_code = rec.service_type_code

3186: and po_line_id = rec.document_line_id;
3187:
3188: elsif rec.transaction_source = 'ORDER MANAGEMENT' then
3189:
3190: update JAI_OM_OE_SO_LINES set service_type_code = rec.service_type_code
3191: , last_update_date = sysdate
3192: , last_updated_by = lv_user_id
3193: , last_update_login = lv_login_id
3194: where header_id = rec.document_id