APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_OM_OE_SO_LINES

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

1046:
1047: /*
1048: || Check that the document has has TCS type of tax.
1049: */
1050: CURSOR cur_chk_tcs_applicable ( cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE )
1051: IS
1052: SELECT
1053: 1
1054: FROM

Line 1055: JAI_OM_OE_SO_LINES jsl ,

1051: IS
1052: SELECT
1053: 1
1054: FROM
1055: JAI_OM_OE_SO_LINES jsl ,
1056: JAI_OM_OE_SO_TAXES jstl ,
1057: JAI_CMN_TAXES_ALL jtc ,
1058: jai_regime_tax_types_v jrttv
1059: WHERE

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

1068: /*
1069: ||Now that some lines have got TCS type of taxes , check that all lines have got tcs type of taxes
1070: ||if any one line does not have TCS type of tax then throw an error
1071: */
1072: CURSOR cur_chk_tcs_for_all_lines ( cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE )
1073: IS
1074: SELECT
1075: 1
1076: FROM

Line 1077: JAI_OM_OE_SO_LINES jsl, oe_order_lines_all oola

1073: IS
1074: SELECT
1075: 1
1076: FROM
1077: JAI_OM_OE_SO_LINES jsl, oe_order_lines_all oola
1078: WHERE
1079: jsl.header_id = cp_header_id
1080: /*9154563 - Added clause to check for canceled_flag also*/
1081: AND oola.header_id = jsl.header_id

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

1098: /*******
1099: || Validate that the inventory_items for all lines of the sales order should have the same TCS item classification
1100: || for the same has already been settled
1101: ********/
1102: CURSOR cur_validate_all_items ( cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE )
1103: IS
1104: SELECT
1105: inventory_item_id
1106: FROM

Line 1107: JAI_OM_OE_SO_LINES jsl

1103: IS
1104: SELECT
1105: inventory_item_id
1106: FROM
1107: JAI_OM_OE_SO_LINES jsl
1108: WHERE
1109: jsl.header_id = cp_header_id;
1110:
1111: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;