1 PACKAGE as_interest_types_pub AUTHID CURRENT_USER as
2 /* $Header: asxintys.pls 115.5 2003/10/10 08:58:13 gbatra ship $ */
3 --
4 -- Package Name : AS_INTEREST_TYPES_PUB
5 -- Purpose : Public API to Create and Update Interest Types in the Oracle
6 -- Sales Online.
7 --
8 -- History
9 --
10 -- 09/12/2002 Rajan T Created
11 --
12
13 -- Start of Comments
14 -- Record Name : interest_type_rec_type
15 -- Type : Global
16 -- End of Comments
17
18 TYPE interest_type_rec_type IS RECORD (
19 interest_type_id NUMBER ,
20 last_update_date DATE ,
21 last_updated_by NUMBER ,
22 creation_date DATE ,
23 created_by NUMBER ,
24 last_update_login NUMBER ,
25 master_enabled_flag VARCHAR2(1) ,
26 interest_type VARCHAR2(80) ,
27 company_classification_flag VARCHAR2(1) ,
28 contact_interest_flag VARCHAR2(1) ,
29 lead_classification_flag VARCHAR2(1) ,
30 expected_purchase_flag VARCHAR2(1) ,
31 current_environment_flag VARCHAR2(1) ,
32 enabled_flag VARCHAR2(1) ,
33 org_id NUMBER ,
34 description VARCHAR2(240) ,
35 prod_cat_set_id NUMBER ,
36 prod_cat_id NUMBER
37 );
38
39 g_miss_interest_type_rec interest_type_rec_type;
40
41 -- Start of Comments
42 -- API Name : create_interest_type
43 -- Type : Public
44 -- End of Comments
45
46 PROCEDURE create_interest_type(
47 p_api_version_number IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
49 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
50 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_interest_type_rec IN interest_type_rec_type DEFAULT g_miss_interest_type_rec,
55 x_interest_type_id OUT NOCOPY NUMBER
56 );
57
58 -- Start of Comments
59 -- API Name : update_interest_type
60 -- Type : Public
61 -- End of Comments
62
63 PROCEDURE update_interest_type(
64 p_api_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
66 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
67 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_interest_type_rec IN as_interest_types_pub.interest_type_rec_type DEFAULT g_miss_interest_type_rec
72 );
73
74 END as_interest_types_pub;