APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_OM_OE_SO_LINES

Line 564: CURSOR cur_chk_tcs_applicable ( cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE )

560:
561: /*
562: || Check that the document has has TCS type of tax.
563: */
564: CURSOR cur_chk_tcs_applicable ( cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE )
565: IS
566: SELECT
567: 1
568: FROM

Line 569: JAI_OM_OE_SO_LINES jsl ,

565: IS
566: SELECT
567: 1
568: FROM
569: JAI_OM_OE_SO_LINES jsl ,
570: JAI_OM_OE_SO_TAXES jstl ,
571: JAI_CMN_TAXES_ALL jtc ,
572: jai_regime_tax_types_v jrttv
573: WHERE

Line 586: CURSOR cur_chk_tcs_for_all_lines ( cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE )

582: /*
583: ||Now that some lines have got TCS type of taxes , check that all lines have got tcs type of taxes
584: ||if any one line does not have TCS type of tax then throw an error
585: */
586: CURSOR cur_chk_tcs_for_all_lines ( cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE )
587: IS
588: SELECT
589: 1
590: FROM

Line 591: JAI_OM_OE_SO_LINES jsl

587: IS
588: SELECT
589: 1
590: FROM
591: JAI_OM_OE_SO_LINES jsl
592: WHERE
593: jsl.header_id = cp_header_id
594: AND NOT EXISTS (
595: SELECT

Line 612: CURSOR cur_validate_all_items ( cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE )

608: /*******
609: || Validate that the inventory_items for all lines of the sales order should have the same TCS item classification
610: || for the same has already been settled
611: ********/
612: CURSOR cur_validate_all_items ( cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE )
613: IS
614: SELECT
615: inventory_item_id
616: FROM

Line 617: JAI_OM_OE_SO_LINES jsl

613: IS
614: SELECT
615: inventory_item_id
616: FROM
617: JAI_OM_OE_SO_LINES jsl
618: WHERE
619: jsl.header_id = cp_header_id;
620:
621: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;