APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_OM_OE_SO_LINES

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

965: and jtc.tax_type IN (jai_constants.tax_type_service,jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)
966: --and jtc.tax_type = 'Service'
967: group by service_type_code;
968:
969: cursor c_get_so_line_srvtyp (cp_line_id JAI_OM_OE_SO_LINES.line_id%type ) is
970: select service_type_code, sum(jstl.tax_amount) service_tax_amount
971: from JAI_OM_OE_SO_LINES jsl
972: , JAI_OM_OE_SO_TAXES jstl
973: , jai_cmn_taxes_all jtc

Line 971: from JAI_OM_OE_SO_LINES jsl

967: group by service_type_code;
968:
969: cursor c_get_so_line_srvtyp (cp_line_id JAI_OM_OE_SO_LINES.line_id%type ) is
970: select service_type_code, sum(jstl.tax_amount) service_tax_amount
971: from JAI_OM_OE_SO_LINES jsl
972: , JAI_OM_OE_SO_TAXES jstl
973: , jai_cmn_taxes_all jtc
974: where jsl.line_id = cp_line_id
975: and jsl.line_id = jstl.line_id

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

980: group by service_type_code;
981:
982: /*The following cursor added by rchandan for RMA */
983:
984: cursor c_get_rma_line_srvtyp (cp_line_id jai_om_oe_so_lines.line_id%type )
985: is
986: select service_type_code, sum(jrtl.tax_amount) service_tax_amount
987: from JAI_OM_OE_RMA_LINES jrl
988: , JAI_OM_OE_RMA_TAXES jrtl

Line 1766: update JAI_OM_OE_SO_LINES set service_type_code = rec.service_type_code

1762: and po_line_id = rec.document_line_id;
1763:
1764: elsif rec.transaction_source = 'ORDER MANAGEMENT' then
1765:
1766: update JAI_OM_OE_SO_LINES set service_type_code = rec.service_type_code
1767: , last_update_date = sysdate
1768: , last_updated_by = lv_user_id
1769: , last_update_login = lv_login_id
1770: where header_id = rec.document_id