[Home] [Help]
PACKAGE: APPS.EC_APPLICATION_ADVICE_PUB
Source
1 PACKAGE EC_Application_Advice_PUB AUTHID CURRENT_USER AS
2 -- $Header: ECPADVOS.pls 120.3 2005/09/29 11:29:54 arsriniv ship $
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'EC_Application_Advice_PUB';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ECPADVOB.pls';
9
10
11 PROCEDURE create_advice(
12 p_api_version_number IN NUMBER,
13 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
15 p_commit IN VARCHAR2 := FND_API.G_FALSE,
16 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17 p_return_status OUT NOCOPY VARCHAR2,
18 p_msg_count OUT NOCOPY NUMBER,
19 p_msg_data OUT NOCOPY VARCHAR2,
20 p_communication_method IN VARCHAR2,
21 p_related_document_id IN VARCHAR2,
22 p_tp_header_id IN NUMBER,
23 p_tp_location_code IN VARCHAR2,
24 p_document_type IN VARCHAR2,
25 p_document_code IN VARCHAR2,
26 p_transaction_control1 IN VARCHAR2 default NULL,
27 p_transaction_control2 IN VARCHAR2 default NULL,
28 p_transaction_control3 IN VARCHAR2 default NULL,
29 p_entity_code IN VARCHAR2 default NULL,
30 p_entity_name IN VARCHAR2 default NULL,
31 p_entity_address1 IN VARCHAR2 default NULL,
32 p_entity_address2 IN VARCHAR2 default NULL,
33 p_entity_address3 IN VARCHAR2 default NULL,
34 p_entity_address4 IN VARCHAR2 default NULL,
35 p_entity_city IN VARCHAR2 default NULL,
36 p_entity_postal_code IN VARCHAR2 default NULL,
37 p_entity_country IN VARCHAR2 default NULL,
38 p_entity_state IN VARCHAR2 default NULL,
39 p_entity_province IN VARCHAR2 default NULL,
40 p_entity_county IN VARCHAR2 default NULL,
41 p_external_reference_1 IN VARCHAR2 default NULL,
42 p_external_reference_2 IN VARCHAR2 default NULL,
43 p_external_reference_3 IN VARCHAR2 default NULL,
44 p_external_reference_4 IN VARCHAR2 default NULL,
45 p_external_reference_5 IN VARCHAR2 default NULL,
46 p_external_reference_6 IN VARCHAR2 default NULL,
47 p_internal_reference_1 IN VARCHAR2 default NULL,
48 p_internal_reference_2 IN VARCHAR2 default NULL,
49 p_internal_reference_3 IN VARCHAR2 default NULL,
50 p_internal_reference_4 IN VARCHAR2 default NULL,
51 p_internal_reference_5 IN VARCHAR2 default NULL,
52 p_internal_reference_6 IN VARCHAR2 default NULL,
53 p_advice_header_id OUT NOCOPY NUMBER
54 );
55
56 PROCEDURE create_advice_line(
57 p_api_version_number IN NUMBER,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
60 p_commit IN VARCHAR2 := FND_API.G_FALSE,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62 p_return_status OUT NOCOPY VARCHAR2,
63 p_msg_count OUT NOCOPY NUMBER,
64 p_msg_data OUT NOCOPY VARCHAR2,
65 p_advice_header_id IN NUMBER,
66 p_advice_date_time IN DATE,
67 p_advice_status_code IN VARCHAR2,
68 p_external_reference_1 IN VARCHAR2 default NULL,
69 p_external_reference_2 IN VARCHAR2 default NULL,
70 p_external_reference_3 IN VARCHAR2 default NULL,
71 p_external_reference_4 IN VARCHAR2 default NULL,
72 p_external_reference_5 IN VARCHAR2 default NULL,
73 p_external_reference_6 IN VARCHAR2 default NULL,
74 p_internal_reference_1 IN VARCHAR2 default NULL,
75 p_internal_reference_2 IN VARCHAR2 default NULL,
76 p_internal_reference_3 IN VARCHAR2 default NULL,
77 p_internal_reference_4 IN VARCHAR2 default NULL,
78 p_internal_reference_5 IN VARCHAR2 default NULL,
79 p_internal_reference_6 IN VARCHAR2 default NULL,
80 p_advo_message_code IN VARCHAR2 default NULL,
81 p_advo_message_desc IN VARCHAR2 default NULL,
82 p_advo_data_bad IN VARCHAR2 default NULL,
83 p_advo_data_good IN VARCHAR2 default NULL
84 );
85
86 END;
87