DBA Data[Home] [Help]

PACKAGE: APPS.WSH_INTERFACE_VALIDATIONS_PKG

Source


1 PACKAGE Wsh_interface_validations_pkg AUTHID CURRENT_USER AS
2 /* $Header: WSHINVDS.pls 115.2 2002/11/12 01:43:13 nparikh ship $ */
3 
4    C_sdebug   CONSTANT NUMBER := Wsh_debug_sv.C_level1;
5    C_debug    CONSTANT NUMBER := Wsh_debug_sv.C_level2;
6 
7    TYPE Interface_errors_rec_type IS RECORD (
8       P_message_name                VARCHAR2 (30) DEFAULT NULL,
9       P_text                        VARCHAR2 (2000) DEFAULT NULL,
10       P_token1                      VARCHAR2 (250) DEFAULT NULL,
11       P_value1                      VARCHAR2 (250) DEFAULT NULL,
12       P_token2                      VARCHAR2 (250) DEFAULT NULL,
13       P_value2                      VARCHAR2 (250) DEFAULT NULL,
14       P_token3                      VARCHAR2 (250) DEFAULT NULL,
15       P_value3                      VARCHAR2 (250) DEFAULT NULL,
16       P_token4                      VARCHAR2 (250) DEFAULT NULL,
17       P_value4                      VARCHAR2 (250) DEFAULT NULL,
18       P_token5                      VARCHAR2 (250) DEFAULT NULL,
19       P_value5                      VARCHAR2 (250) DEFAULT NULL,
20       P_token6                      VARCHAR2 (250) DEFAULT NULL,
21       P_value6                      VARCHAR2 (250) DEFAULT NULL,
22       P_token7                      VARCHAR2 (250) DEFAULT NULL,
23       P_value7                      VARCHAR2 (250) DEFAULT NULL,
24       P_token8                      VARCHAR2 (250) DEFAULT NULL,
25       P_value8                      VARCHAR2 (250) DEFAULT NULL,
26       P_token9                      VARCHAR2 (250) DEFAULT NULL,
27       P_value9                      VARCHAR2 (250) DEFAULT NULL,
28       P_token10                     VARCHAR2 (250) DEFAULT NULL,
29       P_value10                     VARCHAR2 (250) DEFAULT NULL,
30       P_token11                     VARCHAR2 (250) DEFAULT NULL,
31       P_value11                     VARCHAR2 (250) DEFAULT NULL,
32       P_interface_table_name        Wsh_interface_errors.Interface_table_name%TYPE,
33       P_interface_id                Wsh_interface_errors.Interface_id%TYPE);
34 
35    PROCEDURE Validate_document (
36       P_doc_type               IN       VARCHAR2,
37       P_doc_number             IN       VARCHAR2,
38       P_trading_partner_Code   IN       VARCHAR2,
39       P_action_type            IN       VARCHAR2,
40       P_doc_direction          IN       VARCHAR2,
41       P_orig_document_number   IN       VARCHAR2,
42 	X_Trading_Partner_ID	 OUT NOCOPY 	    NUMBER,
43       X_valid_doc              OUT NOCOPY       VARCHAR2,
44       X_return_status          OUT NOCOPY       VARCHAR2
45    );
46 
47    PROCEDURE Validate_deliveries (
48       P_delivery_id     IN       NUMBER,
49       X_return_status   OUT NOCOPY       VARCHAR2
50    );
51 
52    PROCEDURE Compare_ship_request_advice (
53       P_delivery_id     IN       NUMBER,
54       X_return_status   OUT NOCOPY       VARCHAR2
55    );
56 
57    PROCEDURE Log_interface_errors (
58       P_interface_errors_rec   IN       Interface_errors_rec_type,
59       p_msg_data               IN       VARCHAR2 DEFAULT NULL,
60       p_api_name	       IN       VARCHAR2,
61       X_return_status          OUT NOCOPY       VARCHAR2
62    );
63 END Wsh_interface_validations_pkg;