DBA Data[Home] [Help]

PACKAGE: APPS.AR_CMGT_HZ_COVER_API

Source


1 PACKAGE AR_CMGT_HZ_COVER_API AUTHID CURRENT_USER AS
2 /* $Header: ARCMHZCS.pls 120.2.12010000.2 2009/06/11 14:20:36 mraymond ship $  */
3 
4 /*=======================================================================+
5  |  Declare PUBLIC Data Types and Variables
6  +=======================================================================*/
7 
8 /*=======================================================================+
9  |  Declare PUBLIC Exceptions
10  +=======================================================================*/
11 
12 
13 /*========================================================================
14  | PUBLIC PROCEDURE
15  |      update_organization()
16  | DESCRIPTION
17  |
18  | PSEUDO CODE/LOGIC
19  |
20  | PARAMETERS
21  |      p_party_id          IN      resource_id
22  |      p_year_established  IN
23  |      p_url               IN
24  |      p_sic_code_type     IN
25  |      p_sic_code          IN
26  |      p_tax_reference     IN
27  |      p_duns_number_c     IN
28  |
29  | KNOWN ISSUES
30  |
31  | NOTES
32  |
33  | MODIFICATION HISTORY
34  | Date                  Author            Description of Changes
35  |
36  *=======================================================================*/
37 PROCEDURE update_organization(p_party_id           NUMBER,  --15
38                               p_year_established   NUMBER := NULL,
39                               p_employees_total    NUMBER := NULL,
40                               p_url                VARCHAR2 := NULL,
41                               p_sic_code_type      VARCHAR2 := NULL,
42                               p_sic_code           VARCHAR2 := NULL ,
43                               p_tax_reference      VARCHAR2  := NULL,
44                               p_duns_number_c      VARCHAR2  := NULL
45                              );
46 
47 PROCEDURE create_party_profile(p_party_id IN   NUMBER,
48                                p_return_status OUT NOCOPY VARCHAR2);
49 
50 PROCEDURE dump_api_output_data(p_return_status   VARCHAR2,
51                             p_msg_count       NUMBER,
52                             p_msg_data        VARCHAR2);
53 END AR_CMGT_HZ_COVER_API;