1 PACKAGE IBE_Shop_List_Header_PKG AUTHID CURRENT_USER AS
2 /* $Header: IBEVSLHS.pls 115.2 2002/12/13 02:39:08 mannamra ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Shop_List_Header_PKG';
5
6 -- Start of Comments
7 -- Package name : IBE_Shop_List_Header_PKG
8 -- Purpose :
9 -- History :
10 -- NOTE :
11 -- End of Comments
12
13
14 PROCEDURE Insert_Row(
15 x_shp_list_id OUT NOCOPY NUMBER ,
16 p_request_id IN NUMBER ,
17 p_program_application_id IN NUMBER ,
18 p_program_id IN NUMBER ,
19 p_program_update_date IN DATE ,
20 p_object_version_number IN NUMBER ,
21 p_created_by IN NUMBER ,
22 p_creation_date IN DATE ,
23 p_last_updated_by IN NUMBER ,
24 p_last_update_date IN DATE ,
25 p_last_update_login IN NUMBER ,
26 p_party_id IN NUMBER ,
27 p_cust_account_id IN NUMBER ,
28 p_shopping_list_name IN VARCHAR2,
29 p_description IN VARCHAR2,
30 p_attribute_category IN VARCHAR2,
31 p_attribute1 IN VARCHAR2,
32 p_attribute2 IN VARCHAR2,
33 p_attribute3 IN VARCHAR2,
34 p_attribute4 IN VARCHAR2,
35 p_attribute5 IN VARCHAR2,
36 p_attribute6 IN VARCHAR2,
37 p_attribute7 IN VARCHAR2,
38 p_attribute8 IN VARCHAR2,
39 p_attribute9 IN VARCHAR2,
40 p_attribute10 IN VARCHAR2,
41 p_attribute11 IN VARCHAR2,
42 p_attribute12 IN VARCHAR2,
43 p_attribute13 IN VARCHAR2,
44 p_attribute14 IN VARCHAR2,
45 p_attribute15 IN VARCHAR2,
46 p_org_id IN NUMBER);
47
48
49 PROCEDURE Update_Row(
50 p_shp_list_id IN NUMBER ,
51 p_request_id IN NUMBER ,
52 p_program_application_id IN NUMBER ,
53 p_program_id IN NUMBER ,
54 p_program_update_date IN DATE ,
55 p_object_version_number IN NUMBER ,
56 p_created_by IN NUMBER ,
57 p_creation_date IN DATE ,
58 p_last_updated_by IN NUMBER ,
59 p_last_update_date IN DATE ,
60 p_last_update_login IN NUMBER ,
61 p_party_id IN NUMBER ,
62 p_cust_account_id IN NUMBER ,
63 p_shopping_list_name IN VARCHAR2,
64 p_description IN VARCHAR2,
65 p_attribute_category IN VARCHAR2,
66 p_attribute1 IN VARCHAR2,
67 p_attribute2 IN VARCHAR2,
68 p_attribute3 IN VARCHAR2,
69 p_attribute4 IN VARCHAR2,
70 p_attribute5 IN VARCHAR2,
71 p_attribute6 IN VARCHAR2,
72 p_attribute7 IN VARCHAR2,
73 p_attribute8 IN VARCHAR2,
74 p_attribute9 IN VARCHAR2,
75 p_attribute10 IN VARCHAR2,
76 p_attribute11 IN VARCHAR2,
77 p_attribute12 IN VARCHAR2,
78 p_attribute13 IN VARCHAR2,
79 p_attribute14 IN VARCHAR2,
80 p_attribute15 IN VARCHAR2,
81 p_org_id IN NUMBER);
82
83
84 PROCEDURE Delete_Row(
85 p_shp_list_id IN NUMBER,
86 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
87 );
88
89 END IBE_Shop_List_Header_PKG;