1 PACKAGE IBE_SH_QUOTE_ACCESS_PKG AUTHID CURRENT_USER as
2 /* $Header: IBEVSCSS.pls 115.3 2003/01/30 03:30:45 mannamra ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_SH_QUOTE_ACCESS_PVT';
5
6
7 PROCEDURE Insert_Row
8 (
9 p_quote_sharee_id IN NUMBER := FND_API.G_MISS_NUM,
10 p_request_id IN NUMBER := FND_API.G_MISS_NUM,
11 p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
12 p_program_id IN NUMBER := FND_API.G_MISS_NUM,
13 p_program_update_date IN DATE := FND_API.G_MISS_DATE,
14 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
15 p_created_by IN NUMBER := FND_GLOBAL.USER_ID,
16 p_creation_date IN DATE := SYSDATE ,
17 p_last_updated_by IN NUMBER := FND_GLOBAL.USER_ID,
18 p_last_update_date IN DATE := SYSDATE ,
19 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
20 p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
21 p_quote_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
22 p_update_privilege_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
23 p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,
24 p_party_id IN NUMBER := FND_API.G_MISS_NUM,
25 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
26 p_start_date_active IN DATE := SYSDATE ,
27 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
28 p_recipient_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
29 p_contact_point_id IN NUMBER := FND_API.G_MISS_NUM
30 );
31
32
33 PROCEDURE Update_Row
34 (
35 p_QUOTE_SHAREE_ID IN NUMBER := FND_API.G_MISS_NUM,
36 p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
37 p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
38 p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
39 p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
40 p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
41 p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
42 p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
43 p_LAST_UPDATED_BY IN NUMBER := FND_GLOBAL.USER_ID,
44 p_LAST_UPDATE_DATE IN DATE := SYSDATE ,
45 p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
46 p_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
47 p_QUOTE_SHAREE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
48 p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
50 p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
51 p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
52 p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
53 p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
54 p_RECIPIENT_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
55 p_CONTACT_POINT_ID IN NUMBER := FND_API.G_MISS_NUM
56 );
57
58
59
60 PROCEDURE Delete_Row
61 (
62 p_quote_header_id IN NUMBER,
63 p_party_id IN NUMBER,
64 p_cust_account_id IN NUMBER
65 );
66
67 END IBE_SH_QUOTE_ACCESS_PKG;