1 PACKAGE IBE_ShopList_Line_Relation_PKG AUTHID CURRENT_USER AS
2 /* $Header: IBEVSLRS.pls 115.3 2002/12/21 08:09:05 ajlee ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_ShopList_Line_Relation_PKG';
5
6 -- Start of Comments
7 -- Package name : IBE_Shop_List_Line_Relationship_PKG
8 -- Purpose :
9 -- History :
10 -- NOTE :
11 -- End of Comments
12
13
14 PROCEDURE Insert_Row(
15 x_shlitem_rel_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_shp_list_item_id IN NUMBER ,
27 p_related_shp_list_item_id IN NUMBER ,
28 p_relationship_type_code IN VARCHAR2
29 );
30
31
32 PROCEDURE Update_Row(
33 p_shlitem_rel_id IN NUMBER ,
34 p_request_id IN NUMBER ,
35 p_program_application_id IN NUMBER ,
36 p_program_id IN NUMBER ,
37 p_program_update_date IN DATE ,
38 p_object_version_number IN NUMBER ,
39 p_created_by IN NUMBER ,
40 p_creation_date IN DATE ,
41 p_last_updated_by IN NUMBER ,
42 p_last_update_date IN DATE ,
43 p_last_update_login IN NUMBER ,
44 p_shp_list_item_id IN NUMBER ,
45 p_related_shp_list_item_id IN NUMBER ,
46 p_relationship_type_code IN VARCHAR2
47 );
48
49
50 PROCEDURE Delete_Row(p_shlitem_rel_id IN NUMBER);
51
52 END IBE_ShopList_Line_Relation_PKG;