[Home] [Help]
PACKAGE: APPS.AS_INTEREST_CODES_PUB
Source
1 PACKAGE as_interest_codes_pub AUTHID CURRENT_USER as
2 /* $Header: asxintcs.pls 115.5 2003/10/10 08:58:12 gbatra ship $ */
3 --
4 --****************************************************************************
5 -- Name : AS_INTEREST_CODES_PUB
6 --
7 -- Purpose : Public API to Create and Update Interest Codes in the Oracle
8 -- Sales Online.
9 --
10 -- History:
11 --
12 -- 09/12/2002 Rajan T Created
13 --
14 --****************************************************************************
15 -- Start of Comments
16 -- Record Name : interest_code_rec_type
17 -- Type : Global
18 -- End of Comments
19
20 TYPE interest_code_rec_type IS RECORD (
21 interest_code_id NUMBER ,
22 last_update_date DATE ,
23 last_updated_by NUMBER ,
24 creation_date DATE ,
25 created_by NUMBER ,
26 last_update_login NUMBER ,
27 request_id NUMBER ,
28 program_application_id NUMBER ,
29 program_id NUMBER ,
30 program_update_date DATE ,
31 interest_type_id NUMBER ,
32 parent_interest_code_id NUMBER ,
33 master_enabled_flag VARCHAR2(1) ,
34 category_id NUMBER ,
35 category_set_id NUMBER ,
36 pf_item_id NUMBER ,
37 pf_organization_id NUMBER ,
38 currency_code VARCHAR2(15) ,
39 price NUMBER ,
40 attribute_category VARCHAR2(30) ,
41 attribute1 VARCHAR2(150) ,
42 attribute2 VARCHAR2(150) ,
43 attribute3 VARCHAR2(150) ,
44 attribute4 VARCHAR2(150) ,
45 attribute5 VARCHAR2(150) ,
46 attribute6 VARCHAR2(150) ,
47 attribute7 VARCHAR2(150) ,
48 attribute8 VARCHAR2(150) ,
49 attribute9 VARCHAR2(150) ,
50 attribute10 VARCHAR2(150) ,
51 attribute11 VARCHAR2(150) ,
52 attribute12 VARCHAR2(150) ,
53 attribute13 VARCHAR2(150) ,
54 attribute14 VARCHAR2(150) ,
55 attribute15 VARCHAR2(150) ,
56 code VARCHAR2(100) ,
57 description VARCHAR2(240) ,
58 prod_cat_set_id NUMBER ,
59 prod_cat_id NUMBER
60 );
61 g_miss_interest_code_rec interest_code_rec_type;
62
63 -- Start of Comments
64 -- API Name : crete_interest_code
65 -- Type : Public
66 -- End of Comments
67
68 PROCEDURE create_interest_code(
69 p_api_version_number IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
71 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
72 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_interest_code_rec IN interest_code_rec_type DEFAULT g_miss_interest_code_rec,
77 x_interest_code_id OUT NOCOPY NUMBER
78 );
79
80 -- Start of Comments
81 -- API Name : update_interest_code
82 -- Type : Public
83 -- End of Comments
84
85 PROCEDURE update_interest_code(
86 p_api_version_number IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
88 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
89 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_interest_code_rec IN interest_code_rec_type DEFAULT g_miss_interest_code_rec
94 );
95
96 END as_interest_codes_pub;