APPS.WSH_WSHRDXCP_XMLP_PKG dependencies on WSH_WSHRDXCP_XMLP_PKG

Line 1: PACKAGE BODY WSH_WSHRDXCP_XMLP_PKG AS

1: PACKAGE BODY WSH_WSHRDXCP_XMLP_PKG AS
2: /* $Header: WSHRDXCPB.pls 120.6 2010/07/07 13:07:05 gbhargav ship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: C_DATE_FORMAT varchar2(20);
5: BEGIN

Line 209: ,WSH_WSHRDXCP_XMLP_PKG.c_exception_locationformula(EXCEPTION_LOCATION_ID) C_Exception_Location

205: ,we.REQUEST_ID
206: ,WND.NAME DEL_NAME
207: ,WT.NAME TRP_NAME
208: --Bug 8800213 added following columns as main query has these columns.
209: ,WSH_WSHRDXCP_XMLP_PKG.c_exception_locationformula(EXCEPTION_LOCATION_ID) C_Exception_Location
210: ,WSH_WSHRDXCP_XMLP_PKG.c_logged_locationformula(LOGGED_AT_LOCATION_ID) C_Logged_Location
211: ,WSH_WSHRDXCP_XMLP_PKG.cf_container_nameformula(we.CONTAINER_NAME, we.DELIVERY_DETAIL_ID) CF_container_name
212: ,WSH_WSHRDXCP_XMLP_PKG.cf_delivery_nameformula(we.DELIVERY_DETAIL_ID, WND.NAME) CF_delivery_name
213: ,WSH_WSHRDXCP_XMLP_PKG.CP_delivery_detail_id_p CP_delivery_detail_id';

Line 210: ,WSH_WSHRDXCP_XMLP_PKG.c_logged_locationformula(LOGGED_AT_LOCATION_ID) C_Logged_Location

206: ,WND.NAME DEL_NAME
207: ,WT.NAME TRP_NAME
208: --Bug 8800213 added following columns as main query has these columns.
209: ,WSH_WSHRDXCP_XMLP_PKG.c_exception_locationformula(EXCEPTION_LOCATION_ID) C_Exception_Location
210: ,WSH_WSHRDXCP_XMLP_PKG.c_logged_locationformula(LOGGED_AT_LOCATION_ID) C_Logged_Location
211: ,WSH_WSHRDXCP_XMLP_PKG.cf_container_nameformula(we.CONTAINER_NAME, we.DELIVERY_DETAIL_ID) CF_container_name
212: ,WSH_WSHRDXCP_XMLP_PKG.cf_delivery_nameformula(we.DELIVERY_DETAIL_ID, WND.NAME) CF_delivery_name
213: ,WSH_WSHRDXCP_XMLP_PKG.CP_delivery_detail_id_p CP_delivery_detail_id';
214:

Line 211: ,WSH_WSHRDXCP_XMLP_PKG.cf_container_nameformula(we.CONTAINER_NAME, we.DELIVERY_DETAIL_ID) CF_container_name

207: ,WT.NAME TRP_NAME
208: --Bug 8800213 added following columns as main query has these columns.
209: ,WSH_WSHRDXCP_XMLP_PKG.c_exception_locationformula(EXCEPTION_LOCATION_ID) C_Exception_Location
210: ,WSH_WSHRDXCP_XMLP_PKG.c_logged_locationformula(LOGGED_AT_LOCATION_ID) C_Logged_Location
211: ,WSH_WSHRDXCP_XMLP_PKG.cf_container_nameformula(we.CONTAINER_NAME, we.DELIVERY_DETAIL_ID) CF_container_name
212: ,WSH_WSHRDXCP_XMLP_PKG.cf_delivery_nameformula(we.DELIVERY_DETAIL_ID, WND.NAME) CF_delivery_name
213: ,WSH_WSHRDXCP_XMLP_PKG.CP_delivery_detail_id_p CP_delivery_detail_id';
214:
215: L_DEL_LINES_CONT_TEMP :=

Line 212: ,WSH_WSHRDXCP_XMLP_PKG.cf_delivery_nameformula(we.DELIVERY_DETAIL_ID, WND.NAME) CF_delivery_name

208: --Bug 8800213 added following columns as main query has these columns.
209: ,WSH_WSHRDXCP_XMLP_PKG.c_exception_locationformula(EXCEPTION_LOCATION_ID) C_Exception_Location
210: ,WSH_WSHRDXCP_XMLP_PKG.c_logged_locationformula(LOGGED_AT_LOCATION_ID) C_Logged_Location
211: ,WSH_WSHRDXCP_XMLP_PKG.cf_container_nameformula(we.CONTAINER_NAME, we.DELIVERY_DETAIL_ID) CF_container_name
212: ,WSH_WSHRDXCP_XMLP_PKG.cf_delivery_nameformula(we.DELIVERY_DETAIL_ID, WND.NAME) CF_delivery_name
213: ,WSH_WSHRDXCP_XMLP_PKG.CP_delivery_detail_id_p CP_delivery_detail_id';
214:
215: L_DEL_LINES_CONT_TEMP :=
216: 'from

Line 213: ,WSH_WSHRDXCP_XMLP_PKG.CP_delivery_detail_id_p CP_delivery_detail_id';

209: ,WSH_WSHRDXCP_XMLP_PKG.c_exception_locationformula(EXCEPTION_LOCATION_ID) C_Exception_Location
210: ,WSH_WSHRDXCP_XMLP_PKG.c_logged_locationformula(LOGGED_AT_LOCATION_ID) C_Logged_Location
211: ,WSH_WSHRDXCP_XMLP_PKG.cf_container_nameformula(we.CONTAINER_NAME, we.DELIVERY_DETAIL_ID) CF_container_name
212: ,WSH_WSHRDXCP_XMLP_PKG.cf_delivery_nameformula(we.DELIVERY_DETAIL_ID, WND.NAME) CF_delivery_name
213: ,WSH_WSHRDXCP_XMLP_PKG.CP_delivery_detail_id_p CP_delivery_detail_id';
214:
215: L_DEL_LINES_CONT_TEMP :=
216: 'from
217: wsh_exceptions we,

Line 439: END WSH_WSHRDXCP_XMLP_PKG;

435: BEGIN
436: RETURN CP_WAREHOUSE_NAME;
437: END CP_WAREHOUSE_NAME_P;
438:
439: END WSH_WSHRDXCP_XMLP_PKG;
440: