DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 141: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,

137: --Added by Chong for DTC ER 2012/09/11 Get TCS calendar from regime start
138:
139: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
140:
141: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
142: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
143: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
144: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
145: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,

Line 142: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,

138:
139: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
140:
141: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
142: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
143: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
144: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
145: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
146: p_currency_code IN VARCHAR2 ,

Line 143: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,

139: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
140:
141: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
142: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
143: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
144: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
145: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
146: p_currency_code IN VARCHAR2 ,
147: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 144: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,

140:
141: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
142: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
143: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
144: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
145: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
146: p_currency_code IN VARCHAR2 ,
147: p_process_flag OUT NOCOPY VARCHAR2 ,
148: p_process_message OUT NOCOPY VARCHAR2

Line 145: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,

141: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
142: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
143: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
144: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
145: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
146: p_currency_code IN VARCHAR2 ,
147: p_process_flag OUT NOCOPY VARCHAR2 ,
148: p_process_message OUT NOCOPY VARCHAR2
149: )

Line 160: JAI_OM_WSH_LINES_ALL jspl ,

156: jsptl.* ,
157: jrttv.regime_id,
158: jtc.tax_type
159: FROM
160: JAI_OM_WSH_LINES_ALL jspl ,
161: JAI_OM_WSH_LINE_TAXES jsptl,
162: JAI_CMN_TAXES_ALL jtc ,
163: jai_regime_tax_types_v jrttv
164: WHERE

Line 172: CURSOR cur_get_order_num( cp_hdr_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE)

168: AND jsptl.tax_id = jtc.tax_id
169: AND jtc.tax_type = jrttv.tax_type
170: AND jrttv.regime_code = jai_constants.tcs_regime;
171:
172: CURSOR cur_get_order_num( cp_hdr_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE)
173: IS
174: SELECT
175: order_number
176: FROM