DBA Data[Home] [Help]

APPS.JAI_OM_UTILS_PKG dependencies on JAI_OM_OE_SO_LINES

Line 950: p_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE ,

946:
947:
948: FUNCTION validate_excise_exemption
949: (
950: p_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE ,
951: p_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ,
952: p_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ,
953: p_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ,
954: p_error_msg OUT NOCOPY VARCHAR2

Line 951: p_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ,

947:
948: FUNCTION validate_excise_exemption
949: (
950: p_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE ,
951: p_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ,
952: p_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ,
953: p_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ,
954: p_error_msg OUT NOCOPY VARCHAR2
955: )

Line 952: p_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ,

948: FUNCTION validate_excise_exemption
949: (
950: p_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE ,
951: p_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ,
952: p_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ,
953: p_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ,
954: p_error_msg OUT NOCOPY VARCHAR2
955: )
956: RETURN VARCHAR2

Line 953: p_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ,

949: (
950: p_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE ,
951: p_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ,
952: p_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ,
953: p_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ,
954: p_error_msg OUT NOCOPY VARCHAR2
955: )
956: RETURN VARCHAR2
957: /***************************************************************************************************************************************************************

Line 966: JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the table JAI_OM_OE_SO_TAXES

962:
963: Bug : 3436541
964:
965: Purpose : This function validates the different valid combination of values that can exist between
966: JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the table JAI_OM_OE_SO_TAXES
967:
968: A sales order In India Localization Order Management should be allowed to be shipped only when the
969: following conditions are satisfied: -
970: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like

Line 970: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like

966: JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the table JAI_OM_OE_SO_TAXES
967:
968: A sales order In India Localization Order Management should be allowed to be shipped only when the
969: following conditions are satisfied: -
970: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
971: 'EXCISE_EXEMPT_CERT', 'CT2','CT3' should not have Modvat Receovery type of taxes attached
972: ( table JAI_OM_OE_SO_TAXES)
973:
974: 2. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like

Line 974: 2. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like

970: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
971: 'EXCISE_EXEMPT_CERT', 'CT2','CT3' should not have Modvat Receovery type of taxes attached
972: ( table JAI_OM_OE_SO_TAXES)
973:
974: 2. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
975: 'EXCISE_EXEMPT_CERT_OTH', 'CT2_OTH' should have modvat recovery type of tax attached
976: ( table JAI_OM_OE_SO_TAXES)
977:
978: 3. A sales order which does not have any excise exemptions specified (Null value for field

Line 979: JAI_OM_OE_SO_LINES.excise_exempt_type) should not have any Modvat Recovery type of taxes

975: 'EXCISE_EXEMPT_CERT_OTH', 'CT2_OTH' should have modvat recovery type of tax attached
976: ( table JAI_OM_OE_SO_TAXES)
977:
978: 3. A sales order which does not have any excise exemptions specified (Null value for field
979: JAI_OM_OE_SO_LINES.excise_exempt_type) should not have any Modvat Recovery type of taxes
980: ( table JAI_OM_OE_SO_TAXES).
981:
982: This function returns an error when any of the above conditions are not satisified.
983: