DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_OM_WSH_LINES_ALL

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

61: BEGIN
62: lv_context := rtrim(lv_object_name || '.'||lv_member_name,'.');
63: END set_debug_context;
64:
65: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
66: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
67: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
68: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
69: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,

Line 66: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,

62: lv_context := rtrim(lv_object_name || '.'||lv_member_name,'.');
63: END set_debug_context;
64:
65: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
66: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
67: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
68: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
69: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
70: p_currency_code IN VARCHAR2 ,

Line 67: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,

63: END set_debug_context;
64:
65: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
66: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
67: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
68: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
69: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
70: p_currency_code IN VARCHAR2 ,
71: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 68: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,

64:
65: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
66: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
67: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
68: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
69: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
70: p_currency_code IN VARCHAR2 ,
71: p_process_flag OUT NOCOPY VARCHAR2 ,
72: p_process_message OUT NOCOPY VARCHAR2

Line 69: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,

65: PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
66: p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
67: p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
68: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
69: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
70: p_currency_code IN VARCHAR2 ,
71: p_process_flag OUT NOCOPY VARCHAR2 ,
72: p_process_message OUT NOCOPY VARCHAR2
73: )

Line 84: JAI_OM_WSH_LINES_ALL jspl ,

80: jsptl.* ,
81: jrttv.regime_id,
82: jtc.tax_type
83: FROM
84: JAI_OM_WSH_LINES_ALL jspl ,
85: JAI_OM_WSH_LINE_TAXES jsptl,
86: JAI_CMN_TAXES_ALL jtc ,
87: jai_regime_tax_types_v jrttv
88: WHERE

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

92: AND jsptl.tax_id = jtc.tax_id
93: AND jtc.tax_type = jrttv.tax_type
94: AND jrttv.regime_code = jai_constants.tcs_regime;
95:
96: CURSOR cur_get_order_num( cp_hdr_id JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE)
97: IS
98: SELECT
99: order_number
100: FROM