APPS.IBE_SH_QUOTE_ACCESS_PKG dependencies on FND_API

Line 8: p_quote_sharee_id IN NUMBER := FND_API.G_MISS_NUM,

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_SH_QUOTE_ACCESS_PVT';
5:
6: PROCEDURE Insert_Row
7: (
8: p_quote_sharee_id IN NUMBER := FND_API.G_MISS_NUM,
9: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
10: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_program_update_date IN DATE := FND_API.G_MISS_DATE,

Line 9: p_request_id IN NUMBER := FND_API.G_MISS_NUM,

5:
6: PROCEDURE Insert_Row
7: (
8: p_quote_sharee_id IN NUMBER := FND_API.G_MISS_NUM,
9: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
10: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

Line 10: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,

6: PROCEDURE Insert_Row
7: (
8: p_quote_sharee_id IN NUMBER := FND_API.G_MISS_NUM,
9: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
10: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
14: p_created_by IN NUMBER := FND_GLOBAL.USER_ID,

Line 11: p_program_id IN NUMBER := FND_API.G_MISS_NUM,

7: (
8: p_quote_sharee_id IN NUMBER := FND_API.G_MISS_NUM,
9: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
10: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
14: p_created_by IN NUMBER := FND_GLOBAL.USER_ID,
15: p_creation_date IN DATE := SYSDATE ,

Line 12: p_program_update_date IN DATE := FND_API.G_MISS_DATE,

8: p_quote_sharee_id IN NUMBER := FND_API.G_MISS_NUM,
9: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
10: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
14: p_created_by IN NUMBER := FND_GLOBAL.USER_ID,
15: p_creation_date IN DATE := SYSDATE ,
16: p_last_updated_by IN NUMBER := FND_GLOBAL.USER_ID,

Line 13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

9: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
10: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
12: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
14: p_created_by IN NUMBER := FND_GLOBAL.USER_ID,
15: p_creation_date IN DATE := SYSDATE ,
16: p_last_updated_by IN NUMBER := FND_GLOBAL.USER_ID,
17: p_last_update_date IN DATE := SYSDATE ,

Line 18: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

14: p_created_by IN NUMBER := FND_GLOBAL.USER_ID,
15: p_creation_date IN DATE := SYSDATE ,
16: p_last_updated_by IN NUMBER := FND_GLOBAL.USER_ID,
17: p_last_update_date IN DATE := SYSDATE ,
18: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
19: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_quote_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
21: p_update_privilege_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,

Line 19: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,

15: p_creation_date IN DATE := SYSDATE ,
16: p_last_updated_by IN NUMBER := FND_GLOBAL.USER_ID,
17: p_last_update_date IN DATE := SYSDATE ,
18: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
19: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_quote_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
21: p_update_privilege_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 20: p_quote_sharee_number IN NUMBER := FND_API.G_MISS_NUM,

16: p_last_updated_by IN NUMBER := FND_GLOBAL.USER_ID,
17: p_last_update_date IN DATE := SYSDATE ,
18: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
19: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_quote_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
21: p_update_privilege_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
24: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

Line 21: p_update_privilege_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

17: p_last_update_date IN DATE := SYSDATE ,
18: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
19: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_quote_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
21: p_update_privilege_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
24: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
25: p_start_date_active IN DATE := SYSDATE ,

Line 22: p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,

18: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
19: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_quote_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
21: p_update_privilege_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
24: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
25: p_start_date_active IN DATE := SYSDATE ,
26: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 23: p_party_id IN NUMBER := FND_API.G_MISS_NUM,

19: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
20: p_quote_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
21: p_update_privilege_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
24: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
25: p_start_date_active IN DATE := SYSDATE ,
26: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
27: p_recipient_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 24: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

20: p_quote_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
21: p_update_privilege_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
24: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
25: p_start_date_active IN DATE := SYSDATE ,
26: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
27: p_recipient_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_contact_point_id IN NUMBER := FND_API.G_MISS_NUM

Line 26: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

22: p_security_group_id IN NUMBER := FND_API.G_MISS_NUM,
23: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
24: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
25: p_start_date_active IN DATE := SYSDATE ,
26: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
27: p_recipient_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_contact_point_id IN NUMBER := FND_API.G_MISS_NUM
29: )
30: IS

Line 27: p_recipient_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

23: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
24: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
25: p_start_date_active IN DATE := SYSDATE ,
26: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
27: p_recipient_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_contact_point_id IN NUMBER := FND_API.G_MISS_NUM
29: )
30: IS
31:

Line 28: p_contact_point_id IN NUMBER := FND_API.G_MISS_NUM

24: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
25: p_start_date_active IN DATE := SYSDATE ,
26: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
27: p_recipient_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_contact_point_id IN NUMBER := FND_API.G_MISS_NUM
29: )
30: IS
31:
32: BEGIN

Line 59: DECODE(p_quote_sharee_id ,FND_API.G_MISS_NUM,NULL,p_quote_sharee_id),

55: CONTACT_POINT_ID
56:
57: ) VALUES (
58:
59: DECODE(p_quote_sharee_id ,FND_API.G_MISS_NUM,NULL,p_quote_sharee_id),
60: DECODE(p_REQUEST_ID ,FND_API.G_MISS_NUM,NULL,p_REQUEST_ID),
61: DECODE(p_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
62: DECODE(p_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_ID),
63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),

Line 60: DECODE(p_REQUEST_ID ,FND_API.G_MISS_NUM,NULL,p_REQUEST_ID),

56:
57: ) VALUES (
58:
59: DECODE(p_quote_sharee_id ,FND_API.G_MISS_NUM,NULL,p_quote_sharee_id),
60: DECODE(p_REQUEST_ID ,FND_API.G_MISS_NUM,NULL,p_REQUEST_ID),
61: DECODE(p_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
62: DECODE(p_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_ID),
63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),
64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),

Line 61: DECODE(p_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),

57: ) VALUES (
58:
59: DECODE(p_quote_sharee_id ,FND_API.G_MISS_NUM,NULL,p_quote_sharee_id),
60: DECODE(p_REQUEST_ID ,FND_API.G_MISS_NUM,NULL,p_REQUEST_ID),
61: DECODE(p_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
62: DECODE(p_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_ID),
63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),
64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),
65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),

Line 62: DECODE(p_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_ID),

58:
59: DECODE(p_quote_sharee_id ,FND_API.G_MISS_NUM,NULL,p_quote_sharee_id),
60: DECODE(p_REQUEST_ID ,FND_API.G_MISS_NUM,NULL,p_REQUEST_ID),
61: DECODE(p_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
62: DECODE(p_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_ID),
63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),
64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),
65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),
66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),

Line 63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),

59: DECODE(p_quote_sharee_id ,FND_API.G_MISS_NUM,NULL,p_quote_sharee_id),
60: DECODE(p_REQUEST_ID ,FND_API.G_MISS_NUM,NULL,p_REQUEST_ID),
61: DECODE(p_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
62: DECODE(p_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_ID),
63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),
64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),
65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),
66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),
67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),

Line 64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),

60: DECODE(p_REQUEST_ID ,FND_API.G_MISS_NUM,NULL,p_REQUEST_ID),
61: DECODE(p_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
62: DECODE(p_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_ID),
63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),
64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),
65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),
66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),
67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),

Line 65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),

61: DECODE(p_PROGRAM_APPLICATION_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
62: DECODE(p_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_ID),
63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),
64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),
65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),
66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),
67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),
69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),

Line 66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),

62: DECODE(p_PROGRAM_ID ,FND_API.G_MISS_NUM,NULL,p_PROGRAM_ID),
63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),
64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),
65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),
66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),
67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),
69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),

Line 67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),

63: DECODE(p_PROGRAM_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_PROGRAM_UPDATE_DATE),
64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),
65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),
66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),
67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),
69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),
71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),

Line 68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),

64: DECODE(p_OBJECT_VERSION_NUMBER ,FND_API.G_MISS_NUM,NULL,p_OBJECT_VERSION_NUMBER),
65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),
66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),
67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),
69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),
71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),
72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),

Line 69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),

65: DECODE(p_CREATED_BY ,FND_API.G_MISS_NUM,NULL,p_CREATED_BY),
66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),
67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),
69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),
71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),
72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),
73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),

Line 70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),

66: DECODE(p_CREATION_DATE ,FND_API.G_MISS_DATE,NULL,p_CREATION_DATE),
67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),
69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),
71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),
72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),
73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),
74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),

Line 71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),

67: DECODE(p_LAST_UPDATED_BY ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATED_BY),
68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),
69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),
71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),
72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),
73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),
74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),
75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),

Line 72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),

68: DECODE(p_LAST_UPDATE_DATE ,FND_API.G_MISS_DATE,NULL,p_LAST_UPDATE_DATE),
69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),
71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),
72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),
73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),
74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),
75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),
76: DECODE(p_START_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_START_DATE_ACTIVE),

Line 73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),

69: DECODE(p_LAST_UPDATE_LOGIN ,FND_API.G_MISS_NUM,NULL,p_LAST_UPDATE_LOGIN),
70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),
71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),
72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),
73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),
74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),
75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),
76: DECODE(p_START_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_START_DATE_ACTIVE),
77: DECODE(p_END_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_END_DATE_ACTIVE),

Line 74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),

70: DECODE(p_QUOTE_HEADER_ID ,FND_API.G_MISS_NUM,NULL,p_QUOTE_HEADER_ID),
71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),
72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),
73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),
74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),
75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),
76: DECODE(p_START_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_START_DATE_ACTIVE),
77: DECODE(p_END_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_END_DATE_ACTIVE),
78: DECODE(p_RECIPIENT_NAME ,FND_API.G_MISS_CHAR,NULL,p_RECIPIENT_NAME),

Line 75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),

71: DECODE(p_QUOTE_SHAREE_NUMBER ,FND_API.G_MISS_NUM,NULL,p_QUOTE_SHAREE_NUMBER),
72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),
73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),
74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),
75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),
76: DECODE(p_START_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_START_DATE_ACTIVE),
77: DECODE(p_END_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_END_DATE_ACTIVE),
78: DECODE(p_RECIPIENT_NAME ,FND_API.G_MISS_CHAR,NULL,p_RECIPIENT_NAME),
79: DECODE(p_CONTACT_POINT_ID ,FND_API.G_MISS_NUM,NULL,p_CONTACT_POINT_ID)

Line 76: DECODE(p_START_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_START_DATE_ACTIVE),

72: DECODE(p_UPDATE_PRIVILEGE_TYPE_CODE ,FND_API.G_MISS_CHAR,NULL,p_UPDATE_PRIVILEGE_TYPE_CODE),
73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),
74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),
75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),
76: DECODE(p_START_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_START_DATE_ACTIVE),
77: DECODE(p_END_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_END_DATE_ACTIVE),
78: DECODE(p_RECIPIENT_NAME ,FND_API.G_MISS_CHAR,NULL,p_RECIPIENT_NAME),
79: DECODE(p_CONTACT_POINT_ID ,FND_API.G_MISS_NUM,NULL,p_CONTACT_POINT_ID)
80: );

Line 77: DECODE(p_END_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_END_DATE_ACTIVE),

73: DECODE(p_SECURITY_GROUP_ID ,FND_API.G_MISS_NUM,NULL,p_SECURITY_GROUP_ID),
74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),
75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),
76: DECODE(p_START_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_START_DATE_ACTIVE),
77: DECODE(p_END_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_END_DATE_ACTIVE),
78: DECODE(p_RECIPIENT_NAME ,FND_API.G_MISS_CHAR,NULL,p_RECIPIENT_NAME),
79: DECODE(p_CONTACT_POINT_ID ,FND_API.G_MISS_NUM,NULL,p_CONTACT_POINT_ID)
80: );
81:

Line 78: DECODE(p_RECIPIENT_NAME ,FND_API.G_MISS_CHAR,NULL,p_RECIPIENT_NAME),

74: DECODE(p_PARTY_ID ,FND_API.G_MISS_NUM,NULL,p_PARTY_ID),
75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),
76: DECODE(p_START_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_START_DATE_ACTIVE),
77: DECODE(p_END_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_END_DATE_ACTIVE),
78: DECODE(p_RECIPIENT_NAME ,FND_API.G_MISS_CHAR,NULL,p_RECIPIENT_NAME),
79: DECODE(p_CONTACT_POINT_ID ,FND_API.G_MISS_NUM,NULL,p_CONTACT_POINT_ID)
80: );
81:
82: /* p_REQUEST_ID ,

Line 79: DECODE(p_CONTACT_POINT_ID ,FND_API.G_MISS_NUM,NULL,p_CONTACT_POINT_ID)

75: DECODE(p_CUST_ACCOUNT_ID ,FND_API.G_MISS_NUM,NULL,p_CUST_ACCOUNT_ID),
76: DECODE(p_START_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_START_DATE_ACTIVE),
77: DECODE(p_END_DATE_ACTIVE ,FND_API.G_MISS_DATE,NULL,p_END_DATE_ACTIVE),
78: DECODE(p_RECIPIENT_NAME ,FND_API.G_MISS_CHAR,NULL,p_RECIPIENT_NAME),
79: DECODE(p_CONTACT_POINT_ID ,FND_API.G_MISS_NUM,NULL,p_CONTACT_POINT_ID)
80: );
81:
82: /* p_REQUEST_ID ,
83: p_PROGRAM_APPLICATION_ID ,

Line 110: p_QUOTE_SHAREE_ID IN NUMBER := FND_API.G_MISS_NUM,

106:
107:
108: PROCEDURE Update_Row
109: (
110: p_QUOTE_SHAREE_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
113: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
114: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,

Line 111: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,

107:
108: PROCEDURE Update_Row
109: (
110: p_QUOTE_SHAREE_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
113: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
114: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
115: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,

Line 112: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,

108: PROCEDURE Update_Row
109: (
110: p_QUOTE_SHAREE_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
113: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
114: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
115: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
116: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,

Line 113: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,

109: (
110: p_QUOTE_SHAREE_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
113: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
114: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
115: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
116: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
117: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,

Line 114: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,

110: p_QUOTE_SHAREE_ID IN NUMBER := FND_API.G_MISS_NUM,
111: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
113: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
114: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
115: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
116: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
117: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
118: p_LAST_UPDATED_BY IN NUMBER := FND_GLOBAL.USER_ID,

Line 115: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,

111: p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
112: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
113: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
114: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
115: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
116: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
117: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
118: p_LAST_UPDATED_BY IN NUMBER := FND_GLOBAL.USER_ID,
119: p_LAST_UPDATE_DATE IN DATE := SYSDATE,

Line 116: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,

112: p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
113: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
114: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
115: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
116: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
117: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
118: p_LAST_UPDATED_BY IN NUMBER := FND_GLOBAL.USER_ID,
119: p_LAST_UPDATE_DATE IN DATE := SYSDATE,
120: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,

Line 117: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,

113: p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
114: p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
115: p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
116: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
117: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
118: p_LAST_UPDATED_BY IN NUMBER := FND_GLOBAL.USER_ID,
119: p_LAST_UPDATE_DATE IN DATE := SYSDATE,
120: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
121: p_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 120: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,

116: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
117: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
118: p_LAST_UPDATED_BY IN NUMBER := FND_GLOBAL.USER_ID,
119: p_LAST_UPDATE_DATE IN DATE := SYSDATE,
120: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
121: p_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
122: p_QUOTE_SHAREE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
123: p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 121: p_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,

117: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
118: p_LAST_UPDATED_BY IN NUMBER := FND_GLOBAL.USER_ID,
119: p_LAST_UPDATE_DATE IN DATE := SYSDATE,
120: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
121: p_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
122: p_QUOTE_SHAREE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
123: p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 122: p_QUOTE_SHAREE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,

118: p_LAST_UPDATED_BY IN NUMBER := FND_GLOBAL.USER_ID,
119: p_LAST_UPDATE_DATE IN DATE := SYSDATE,
120: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
121: p_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
122: p_QUOTE_SHAREE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
123: p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 123: p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,

119: p_LAST_UPDATE_DATE IN DATE := SYSDATE,
120: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
121: p_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
122: p_QUOTE_SHAREE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
123: p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
127: p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,

Line 124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,

120: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
121: p_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
122: p_QUOTE_SHAREE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
123: p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
127: p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
128: p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,

Line 125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,

121: p_QUOTE_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
122: p_QUOTE_SHAREE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
123: p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
127: p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
128: p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
129: p_RECIPIENT_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,

122: p_QUOTE_SHAREE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
123: p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
127: p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
128: p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
129: p_RECIPIENT_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_CONTACT_POINT_ID IN NUMBER := FND_API.G_MISS_NUM

Line 127: p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,

123: p_UPDATE_PRIVILEGE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
127: p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
128: p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
129: p_RECIPIENT_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_CONTACT_POINT_ID IN NUMBER := FND_API.G_MISS_NUM
131: )

Line 128: p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,

124: p_SECURITY_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
127: p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
128: p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
129: p_RECIPIENT_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_CONTACT_POINT_ID IN NUMBER := FND_API.G_MISS_NUM
131: )
132: IS

Line 129: p_RECIPIENT_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,

125: p_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
127: p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
128: p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
129: p_RECIPIENT_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_CONTACT_POINT_ID IN NUMBER := FND_API.G_MISS_NUM
131: )
132: IS
133:

Line 130: p_CONTACT_POINT_ID IN NUMBER := FND_API.G_MISS_NUM

126: p_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
127: p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
128: p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
129: p_RECIPIENT_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_CONTACT_POINT_ID IN NUMBER := FND_API.G_MISS_NUM
131: )
132: IS
133:
134: BEGIN

Line 138: -- QUOTE_SHAREE_ID = decode(p_QUOTE_SHAREE_ID,FND_API.G_MISS_NUM,QUOTE_SHAREE_ID, p_QUOTE_SHAREE_ID),

134: BEGIN
135:
136: UPDATE IBE_SH_QUOTE_ACCESS
137: SET
138: -- QUOTE_SHAREE_ID = decode(p_QUOTE_SHAREE_ID,FND_API.G_MISS_NUM,QUOTE_SHAREE_ID, p_QUOTE_SHAREE_ID),
139: REQUEST_ID = decode(p_REQUEST_ID,FND_API.G_MISS_NUM,REQUEST_ID, p_REQUEST_ID),
140: PROGRAM_APPLICATION_ID = decode(p_PROGRAM_APPLICATION_ID,FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,
141: p_PROGRAM_APPLICATION_ID),
142: PROGRAM_ID = decode(p_PROGRAM_ID,FND_API.G_MISS_NUM,PROGRAM_ID, p_PROGRAM_ID),

Line 139: REQUEST_ID = decode(p_REQUEST_ID,FND_API.G_MISS_NUM,REQUEST_ID, p_REQUEST_ID),

135:
136: UPDATE IBE_SH_QUOTE_ACCESS
137: SET
138: -- QUOTE_SHAREE_ID = decode(p_QUOTE_SHAREE_ID,FND_API.G_MISS_NUM,QUOTE_SHAREE_ID, p_QUOTE_SHAREE_ID),
139: REQUEST_ID = decode(p_REQUEST_ID,FND_API.G_MISS_NUM,REQUEST_ID, p_REQUEST_ID),
140: PROGRAM_APPLICATION_ID = decode(p_PROGRAM_APPLICATION_ID,FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,
141: p_PROGRAM_APPLICATION_ID),
142: PROGRAM_ID = decode(p_PROGRAM_ID,FND_API.G_MISS_NUM,PROGRAM_ID, p_PROGRAM_ID),
143: PROGRAM_UPDATE_DATE = decode(p_PROGRAM_UPDATE_DATE,FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,

Line 140: PROGRAM_APPLICATION_ID = decode(p_PROGRAM_APPLICATION_ID,FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,

136: UPDATE IBE_SH_QUOTE_ACCESS
137: SET
138: -- QUOTE_SHAREE_ID = decode(p_QUOTE_SHAREE_ID,FND_API.G_MISS_NUM,QUOTE_SHAREE_ID, p_QUOTE_SHAREE_ID),
139: REQUEST_ID = decode(p_REQUEST_ID,FND_API.G_MISS_NUM,REQUEST_ID, p_REQUEST_ID),
140: PROGRAM_APPLICATION_ID = decode(p_PROGRAM_APPLICATION_ID,FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,
141: p_PROGRAM_APPLICATION_ID),
142: PROGRAM_ID = decode(p_PROGRAM_ID,FND_API.G_MISS_NUM,PROGRAM_ID, p_PROGRAM_ID),
143: PROGRAM_UPDATE_DATE = decode(p_PROGRAM_UPDATE_DATE,FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,
144: p_PROGRAM_UPDATE_DATE),

Line 142: PROGRAM_ID = decode(p_PROGRAM_ID,FND_API.G_MISS_NUM,PROGRAM_ID, p_PROGRAM_ID),

138: -- QUOTE_SHAREE_ID = decode(p_QUOTE_SHAREE_ID,FND_API.G_MISS_NUM,QUOTE_SHAREE_ID, p_QUOTE_SHAREE_ID),
139: REQUEST_ID = decode(p_REQUEST_ID,FND_API.G_MISS_NUM,REQUEST_ID, p_REQUEST_ID),
140: PROGRAM_APPLICATION_ID = decode(p_PROGRAM_APPLICATION_ID,FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,
141: p_PROGRAM_APPLICATION_ID),
142: PROGRAM_ID = decode(p_PROGRAM_ID,FND_API.G_MISS_NUM,PROGRAM_ID, p_PROGRAM_ID),
143: PROGRAM_UPDATE_DATE = decode(p_PROGRAM_UPDATE_DATE,FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,
144: p_PROGRAM_UPDATE_DATE),
145: OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,
146: p_OBJECT_VERSION_NUMBER),

Line 143: PROGRAM_UPDATE_DATE = decode(p_PROGRAM_UPDATE_DATE,FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,

139: REQUEST_ID = decode(p_REQUEST_ID,FND_API.G_MISS_NUM,REQUEST_ID, p_REQUEST_ID),
140: PROGRAM_APPLICATION_ID = decode(p_PROGRAM_APPLICATION_ID,FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,
141: p_PROGRAM_APPLICATION_ID),
142: PROGRAM_ID = decode(p_PROGRAM_ID,FND_API.G_MISS_NUM,PROGRAM_ID, p_PROGRAM_ID),
143: PROGRAM_UPDATE_DATE = decode(p_PROGRAM_UPDATE_DATE,FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,
144: p_PROGRAM_UPDATE_DATE),
145: OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,
146: p_OBJECT_VERSION_NUMBER),
147: CREATED_BY = decode(p_CREATED_BY,FND_API.G_MISS_NUM,CREATED_BY, p_CREATED_BY),

Line 145: OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,

141: p_PROGRAM_APPLICATION_ID),
142: PROGRAM_ID = decode(p_PROGRAM_ID,FND_API.G_MISS_NUM,PROGRAM_ID, p_PROGRAM_ID),
143: PROGRAM_UPDATE_DATE = decode(p_PROGRAM_UPDATE_DATE,FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,
144: p_PROGRAM_UPDATE_DATE),
145: OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,
146: p_OBJECT_VERSION_NUMBER),
147: CREATED_BY = decode(p_CREATED_BY,FND_API.G_MISS_NUM,CREATED_BY, p_CREATED_BY),
148: CREATION_DATE = decode(p_CREATION_DATE,FND_API.G_MISS_DATE,CREATION_DATE, p_CREATION_DATE),
149: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 147: CREATED_BY = decode(p_CREATED_BY,FND_API.G_MISS_NUM,CREATED_BY, p_CREATED_BY),

143: PROGRAM_UPDATE_DATE = decode(p_PROGRAM_UPDATE_DATE,FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,
144: p_PROGRAM_UPDATE_DATE),
145: OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,
146: p_OBJECT_VERSION_NUMBER),
147: CREATED_BY = decode(p_CREATED_BY,FND_API.G_MISS_NUM,CREATED_BY, p_CREATED_BY),
148: CREATION_DATE = decode(p_CREATION_DATE,FND_API.G_MISS_DATE,CREATION_DATE, p_CREATION_DATE),
149: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,LAST_UPDATED_BY, p_LAST_UPDATED_BY),
150: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
151: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 148: CREATION_DATE = decode(p_CREATION_DATE,FND_API.G_MISS_DATE,CREATION_DATE, p_CREATION_DATE),

144: p_PROGRAM_UPDATE_DATE),
145: OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,
146: p_OBJECT_VERSION_NUMBER),
147: CREATED_BY = decode(p_CREATED_BY,FND_API.G_MISS_NUM,CREATED_BY, p_CREATED_BY),
148: CREATION_DATE = decode(p_CREATION_DATE,FND_API.G_MISS_DATE,CREATION_DATE, p_CREATION_DATE),
149: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,LAST_UPDATED_BY, p_LAST_UPDATED_BY),
150: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
151: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
152: QUOTE_HEADER_ID = decode(p_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),

Line 149: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,LAST_UPDATED_BY, p_LAST_UPDATED_BY),

145: OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,
146: p_OBJECT_VERSION_NUMBER),
147: CREATED_BY = decode(p_CREATED_BY,FND_API.G_MISS_NUM,CREATED_BY, p_CREATED_BY),
148: CREATION_DATE = decode(p_CREATION_DATE,FND_API.G_MISS_DATE,CREATION_DATE, p_CREATION_DATE),
149: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,LAST_UPDATED_BY, p_LAST_UPDATED_BY),
150: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
151: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
152: QUOTE_HEADER_ID = decode(p_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
153: QUOTE_SHAREE_NUMBER = decode(p_QUOTE_SHAREE_NUMBER,FND_API.G_MISS_NUM,QUOTE_SHAREE_NUMBER,

Line 150: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

146: p_OBJECT_VERSION_NUMBER),
147: CREATED_BY = decode(p_CREATED_BY,FND_API.G_MISS_NUM,CREATED_BY, p_CREATED_BY),
148: CREATION_DATE = decode(p_CREATION_DATE,FND_API.G_MISS_DATE,CREATION_DATE, p_CREATION_DATE),
149: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,LAST_UPDATED_BY, p_LAST_UPDATED_BY),
150: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
151: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
152: QUOTE_HEADER_ID = decode(p_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
153: QUOTE_SHAREE_NUMBER = decode(p_QUOTE_SHAREE_NUMBER,FND_API.G_MISS_NUM,QUOTE_SHAREE_NUMBER,
154: p_QUOTE_SHAREE_NUMBER),

Line 151: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

147: CREATED_BY = decode(p_CREATED_BY,FND_API.G_MISS_NUM,CREATED_BY, p_CREATED_BY),
148: CREATION_DATE = decode(p_CREATION_DATE,FND_API.G_MISS_DATE,CREATION_DATE, p_CREATION_DATE),
149: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,LAST_UPDATED_BY, p_LAST_UPDATED_BY),
150: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
151: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
152: QUOTE_HEADER_ID = decode(p_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
153: QUOTE_SHAREE_NUMBER = decode(p_QUOTE_SHAREE_NUMBER,FND_API.G_MISS_NUM,QUOTE_SHAREE_NUMBER,
154: p_QUOTE_SHAREE_NUMBER),
155: UPDATE_PRIVILEGE_TYPE_CODE = decode(p_UPDATE_PRIVILEGE_TYPE_CODE,FND_API.G_MISS_CHAR,UPDATE_PRIVILEGE_TYPE_CODE,

Line 152: QUOTE_HEADER_ID = decode(p_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),

148: CREATION_DATE = decode(p_CREATION_DATE,FND_API.G_MISS_DATE,CREATION_DATE, p_CREATION_DATE),
149: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,LAST_UPDATED_BY, p_LAST_UPDATED_BY),
150: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
151: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
152: QUOTE_HEADER_ID = decode(p_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
153: QUOTE_SHAREE_NUMBER = decode(p_QUOTE_SHAREE_NUMBER,FND_API.G_MISS_NUM,QUOTE_SHAREE_NUMBER,
154: p_QUOTE_SHAREE_NUMBER),
155: UPDATE_PRIVILEGE_TYPE_CODE = decode(p_UPDATE_PRIVILEGE_TYPE_CODE,FND_API.G_MISS_CHAR,UPDATE_PRIVILEGE_TYPE_CODE,
156: p_UPDATE_PRIVILEGE_TYPE_CODE),

Line 153: QUOTE_SHAREE_NUMBER = decode(p_QUOTE_SHAREE_NUMBER,FND_API.G_MISS_NUM,QUOTE_SHAREE_NUMBER,

149: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY,FND_API.G_MISS_NUM,LAST_UPDATED_BY, p_LAST_UPDATED_BY),
150: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
151: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
152: QUOTE_HEADER_ID = decode(p_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
153: QUOTE_SHAREE_NUMBER = decode(p_QUOTE_SHAREE_NUMBER,FND_API.G_MISS_NUM,QUOTE_SHAREE_NUMBER,
154: p_QUOTE_SHAREE_NUMBER),
155: UPDATE_PRIVILEGE_TYPE_CODE = decode(p_UPDATE_PRIVILEGE_TYPE_CODE,FND_API.G_MISS_CHAR,UPDATE_PRIVILEGE_TYPE_CODE,
156: p_UPDATE_PRIVILEGE_TYPE_CODE),
157: SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),

Line 155: UPDATE_PRIVILEGE_TYPE_CODE = decode(p_UPDATE_PRIVILEGE_TYPE_CODE,FND_API.G_MISS_CHAR,UPDATE_PRIVILEGE_TYPE_CODE,

151: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
152: QUOTE_HEADER_ID = decode(p_QUOTE_HEADER_ID,FND_API.G_MISS_NUM,QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
153: QUOTE_SHAREE_NUMBER = decode(p_QUOTE_SHAREE_NUMBER,FND_API.G_MISS_NUM,QUOTE_SHAREE_NUMBER,
154: p_QUOTE_SHAREE_NUMBER),
155: UPDATE_PRIVILEGE_TYPE_CODE = decode(p_UPDATE_PRIVILEGE_TYPE_CODE,FND_API.G_MISS_CHAR,UPDATE_PRIVILEGE_TYPE_CODE,
156: p_UPDATE_PRIVILEGE_TYPE_CODE),
157: SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
158: PARTY_ID = decode(p_PARTY_ID,FND_API.G_MISS_NUM,PARTY_ID, p_PARTY_ID),
159: CUST_ACCOUNT_ID = decode(p_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM,CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),

Line 157: SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),

153: QUOTE_SHAREE_NUMBER = decode(p_QUOTE_SHAREE_NUMBER,FND_API.G_MISS_NUM,QUOTE_SHAREE_NUMBER,
154: p_QUOTE_SHAREE_NUMBER),
155: UPDATE_PRIVILEGE_TYPE_CODE = decode(p_UPDATE_PRIVILEGE_TYPE_CODE,FND_API.G_MISS_CHAR,UPDATE_PRIVILEGE_TYPE_CODE,
156: p_UPDATE_PRIVILEGE_TYPE_CODE),
157: SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
158: PARTY_ID = decode(p_PARTY_ID,FND_API.G_MISS_NUM,PARTY_ID, p_PARTY_ID),
159: CUST_ACCOUNT_ID = decode(p_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM,CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
160: START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE,FND_API.G_MISS_DATE,START_DATE_ACTIVE, p_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE,FND_API.G_MISS_DATE,END_DATE_ACTIVE, p_END_DATE_ACTIVE),

Line 158: PARTY_ID = decode(p_PARTY_ID,FND_API.G_MISS_NUM,PARTY_ID, p_PARTY_ID),

154: p_QUOTE_SHAREE_NUMBER),
155: UPDATE_PRIVILEGE_TYPE_CODE = decode(p_UPDATE_PRIVILEGE_TYPE_CODE,FND_API.G_MISS_CHAR,UPDATE_PRIVILEGE_TYPE_CODE,
156: p_UPDATE_PRIVILEGE_TYPE_CODE),
157: SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
158: PARTY_ID = decode(p_PARTY_ID,FND_API.G_MISS_NUM,PARTY_ID, p_PARTY_ID),
159: CUST_ACCOUNT_ID = decode(p_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM,CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
160: START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE,FND_API.G_MISS_DATE,START_DATE_ACTIVE, p_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE,FND_API.G_MISS_DATE,END_DATE_ACTIVE, p_END_DATE_ACTIVE),
162: RECIPIENT_NAME = decode(p_RECIPIENT_NAME,FND_API.G_MISS_CHAR,RECIPIENT_NAME, p_RECIPIENT_NAME),

Line 159: CUST_ACCOUNT_ID = decode(p_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM,CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),

155: UPDATE_PRIVILEGE_TYPE_CODE = decode(p_UPDATE_PRIVILEGE_TYPE_CODE,FND_API.G_MISS_CHAR,UPDATE_PRIVILEGE_TYPE_CODE,
156: p_UPDATE_PRIVILEGE_TYPE_CODE),
157: SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
158: PARTY_ID = decode(p_PARTY_ID,FND_API.G_MISS_NUM,PARTY_ID, p_PARTY_ID),
159: CUST_ACCOUNT_ID = decode(p_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM,CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
160: START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE,FND_API.G_MISS_DATE,START_DATE_ACTIVE, p_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE,FND_API.G_MISS_DATE,END_DATE_ACTIVE, p_END_DATE_ACTIVE),
162: RECIPIENT_NAME = decode(p_RECIPIENT_NAME,FND_API.G_MISS_CHAR,RECIPIENT_NAME, p_RECIPIENT_NAME),
163: CONTACT_POINT_ID = decode(p_CONTACT_POINT_ID,FND_API.G_MISS_NUM,CONTACT_POINT_ID, p_CONTACT_POINT_ID)

Line 160: START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE,FND_API.G_MISS_DATE,START_DATE_ACTIVE, p_START_DATE_ACTIVE),

156: p_UPDATE_PRIVILEGE_TYPE_CODE),
157: SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
158: PARTY_ID = decode(p_PARTY_ID,FND_API.G_MISS_NUM,PARTY_ID, p_PARTY_ID),
159: CUST_ACCOUNT_ID = decode(p_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM,CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
160: START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE,FND_API.G_MISS_DATE,START_DATE_ACTIVE, p_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE,FND_API.G_MISS_DATE,END_DATE_ACTIVE, p_END_DATE_ACTIVE),
162: RECIPIENT_NAME = decode(p_RECIPIENT_NAME,FND_API.G_MISS_CHAR,RECIPIENT_NAME, p_RECIPIENT_NAME),
163: CONTACT_POINT_ID = decode(p_CONTACT_POINT_ID,FND_API.G_MISS_NUM,CONTACT_POINT_ID, p_CONTACT_POINT_ID)
164:

Line 161: END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE,FND_API.G_MISS_DATE,END_DATE_ACTIVE, p_END_DATE_ACTIVE),

157: SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
158: PARTY_ID = decode(p_PARTY_ID,FND_API.G_MISS_NUM,PARTY_ID, p_PARTY_ID),
159: CUST_ACCOUNT_ID = decode(p_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM,CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
160: START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE,FND_API.G_MISS_DATE,START_DATE_ACTIVE, p_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE,FND_API.G_MISS_DATE,END_DATE_ACTIVE, p_END_DATE_ACTIVE),
162: RECIPIENT_NAME = decode(p_RECIPIENT_NAME,FND_API.G_MISS_CHAR,RECIPIENT_NAME, p_RECIPIENT_NAME),
163: CONTACT_POINT_ID = decode(p_CONTACT_POINT_ID,FND_API.G_MISS_NUM,CONTACT_POINT_ID, p_CONTACT_POINT_ID)
164:
165: WHERE

Line 162: RECIPIENT_NAME = decode(p_RECIPIENT_NAME,FND_API.G_MISS_CHAR,RECIPIENT_NAME, p_RECIPIENT_NAME),

158: PARTY_ID = decode(p_PARTY_ID,FND_API.G_MISS_NUM,PARTY_ID, p_PARTY_ID),
159: CUST_ACCOUNT_ID = decode(p_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM,CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
160: START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE,FND_API.G_MISS_DATE,START_DATE_ACTIVE, p_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE,FND_API.G_MISS_DATE,END_DATE_ACTIVE, p_END_DATE_ACTIVE),
162: RECIPIENT_NAME = decode(p_RECIPIENT_NAME,FND_API.G_MISS_CHAR,RECIPIENT_NAME, p_RECIPIENT_NAME),
163: CONTACT_POINT_ID = decode(p_CONTACT_POINT_ID,FND_API.G_MISS_NUM,CONTACT_POINT_ID, p_CONTACT_POINT_ID)
164:
165: WHERE
166: /* quote_header_id = p_quote_header_id

Line 163: CONTACT_POINT_ID = decode(p_CONTACT_POINT_ID,FND_API.G_MISS_NUM,CONTACT_POINT_ID, p_CONTACT_POINT_ID)

159: CUST_ACCOUNT_ID = decode(p_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM,CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
160: START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE,FND_API.G_MISS_DATE,START_DATE_ACTIVE, p_START_DATE_ACTIVE),
161: END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE,FND_API.G_MISS_DATE,END_DATE_ACTIVE, p_END_DATE_ACTIVE),
162: RECIPIENT_NAME = decode(p_RECIPIENT_NAME,FND_API.G_MISS_CHAR,RECIPIENT_NAME, p_RECIPIENT_NAME),
163: CONTACT_POINT_ID = decode(p_CONTACT_POINT_ID,FND_API.G_MISS_NUM,CONTACT_POINT_ID, p_CONTACT_POINT_ID)
164:
165: WHERE
166: /* quote_header_id = p_quote_header_id
167: and party_id = p_party_id