DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on WSH_INTERFACE_VALIDATIONS_PKG

Line 42: x_interface_errors_rec_tab IN OUT NOCOPY WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab,

38:
39: PROCEDURE Populate_Error_Records(
40: p_interface_id IN NUMBER,
41: p_interface_table_name IN VARCHAR2,
42: x_interface_errors_rec_tab IN OUT NOCOPY WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab,
43: x_return_status OUT NOCOPY VARCHAR2 );
44: --
45: --=============================================================================
46: -- PUBLIC PROCEDURE :

Line 915: interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;

911:
912: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
913: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
914:
915: interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
916: interface_error_tab WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab;
917: l_dummy WSH_UTIL_CORE.Id_Tab_Type;
918: -- LSP PROJECT : begin
919: l_modify_otm_flag VARCHAR2(1);

Line 916: interface_error_tab WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab;

912: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
913: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
914:
915: interface_error_rec WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_type;
916: interface_error_tab WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab;
917: l_dummy WSH_UTIL_CORE.Id_Tab_Type;
918: -- LSP PROJECT : begin
919: l_modify_otm_flag VARCHAR2(1);
920: l_modify_oe_iface_flag VARCHAR2(1);

Line 2442: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors', WSH_DEBUG_SV.C_PROC_LEVEL);

2438: --
2439: IF interface_error_tab.count > 0 THEN
2440: --
2441: IF l_debug_on THEN
2442: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors', WSH_DEBUG_SV.C_PROC_LEVEL);
2443: END IF;
2444: --
2445: WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors (
2446: p_interface_errors_rec_tab => interface_error_tab,

Line 2445: WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors (

2441: IF l_debug_on THEN
2442: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors', WSH_DEBUG_SV.C_PROC_LEVEL);
2443: END IF;
2444: --
2445: WSH_INTERFACE_VALIDATIONS_PKG.Log_Interface_Errors (
2446: p_interface_errors_rec_tab => interface_error_tab,
2447: p_interface_action_code => g_interface_action_code,
2448: x_return_status => l_return_status);
2449:

Line 5907: x_interface_error_tab OUT NOCOPY WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab,

5903: p_header_id IN NUMBER,
5904: p_del_interface_rec IN OUT NOCOPY Del_Interface_Rec_Type,
5905: x_om_line_tbl_type OUT NOCOPY OM_Line_Tbl_Type,
5906: x_details_interface_rec_tab OUT NOCOPY Del_Details_Interface_Rec_Tab,
5907: x_interface_error_tab OUT NOCOPY WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab,
5908: x_return_status OUT NOCOPY VARCHAR2 )
5909: IS
5910: CURSOR c_del_details_interface_rec
5911: IS

Line 6924: x_interface_errors_rec_tab IN OUT NOCOPY WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab,

6920: --
6921: PROCEDURE Populate_Error_Records(
6922: p_interface_id IN NUMBER,
6923: p_interface_table_name IN VARCHAR2,
6924: x_interface_errors_rec_tab IN OUT NOCOPY WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab,
6925: x_return_status OUT NOCOPY VARCHAR2 )
6926: IS
6927: l_error_count NUMBER;
6928: l_msg_count NUMBER;

Line 7010: x_interface_error_tab OUT NOCOPY WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab,

7006: --=============================================================================
7007: --
7008: PROCEDURE Validate_Interface_Details(
7009: p_details_interface_tab IN OUT NOCOPY Del_Details_Interface_Rec_Tab,
7010: x_interface_error_tab OUT NOCOPY WSH_INTERFACE_VALIDATIONS_PKG.interface_errors_rec_tab,
7011: x_return_status OUT NOCOPY VARCHAR2 )
7012: IS
7013:
7014: CURSOR c_delivery_details_info(c_line_id NUMBER)