APPS.JAI_WSH_EXP_HANDLING_PKG dependencies on JAI_WSH_EXCEPTIONS_T

Line 47: from JAI_WSH_EXCEPTIONS_T

43: IS
44:
45: cursor c_get_exp_details is
46: select *
47: from JAI_WSH_EXCEPTIONS_T
48: where delivery_id = p_delivery_id
49: order by exception_entity;
50:
51: ln_count NUMBER := 0;

Line 105: rec_exp_msg JAI_WSH_EXCEPTIONS_T%ROWTYPE;

101:
102: le_sub EXCEPTION;
103: le_val EXCEPTION;
104: lt_exp_msg jai_om_wdd_processing_pkg.exp_tbl_type := jai_om_wdd_processing_pkg.exp_tbl_type();
105: rec_exp_msg JAI_WSH_EXCEPTIONS_T%ROWTYPE;
106: ln_req_id NUMBER;
107: lv_error_exist VARCHAR2(1);
108: lb_completion_status BOOLEAN;
109: lv_return_code VARCHAR2(240);

Line 129: from JAI_WSH_EXCEPTIONS_T

125: );
126:
127: cursor c_om_interface_exist is
128: select 'Y'
129: from JAI_WSH_EXCEPTIONS_T
130: where delivery_id = p_delivery_id and
131: exception_entity = 'OM_INTERFACE';
132:
133: cursor c_inv_interface_exist is

Line 135: from JAI_WSH_EXCEPTIONS_T

131: exception_entity = 'OM_INTERFACE';
132:
133: cursor c_inv_interface_exist is
134: select 'Y'
135: from JAI_WSH_EXCEPTIONS_T
136: where delivery_id = p_delivery_id and
137: exception_entity = 'INVENTORY_INTERFACE';
138:
139: BEGIN