1: PACKAGE IGC_CC_SEC_GROUP_USERS_PKG AUTHID CURRENT_USER as
2: /* $Header: IGCCSCUS.pls 120.4.12000000.1 2007/08/20 12:14:48 mbremkum ship $ */
3:
4: PROCEDURE Insert_Row( p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8: p_return_status OUT NOCOPY VARCHAR2,
9: p_msg_count OUT NOCOPY NUMBER,
2: /* $Header: IGCCSCUS.pls 120.4.12000000.1 2007/08/20 12:14:48 mbremkum ship $ */
3:
4: PROCEDURE Insert_Row( p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8: p_return_status OUT NOCOPY VARCHAR2,
9: p_msg_count OUT NOCOPY NUMBER,
10: p_msg_data OUT NOCOPY VARCHAR2,
3:
4: PROCEDURE Insert_Row( p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8: p_return_status OUT NOCOPY VARCHAR2,
9: p_msg_count OUT NOCOPY NUMBER,
10: p_msg_data OUT NOCOPY VARCHAR2,
11:
35: P_LAST_UPDATE_LOGIN NUMBER
36: );
37:
38: PROCEDURE Update_Row( p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: p_return_status OUT NOCOPY VARCHAR2,
43: p_msg_count OUT NOCOPY NUMBER,
36: );
37:
38: PROCEDURE Update_Row( p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: p_return_status OUT NOCOPY VARCHAR2,
43: p_msg_count OUT NOCOPY NUMBER,
44: p_msg_data OUT NOCOPY VARCHAR2,
37:
38: PROCEDURE Update_Row( p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: p_return_status OUT NOCOPY VARCHAR2,
43: p_msg_count OUT NOCOPY NUMBER,
44: p_msg_data OUT NOCOPY VARCHAR2,
45:
67: P_LAST_UPDATE_LOGIN NUMBER
68: );
69:
70: PROCEDURE Lock_Row( p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: p_return_status OUT NOCOPY VARCHAR2,
75: p_msg_count OUT NOCOPY NUMBER,
68: );
69:
70: PROCEDURE Lock_Row( p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: p_return_status OUT NOCOPY VARCHAR2,
75: p_msg_count OUT NOCOPY NUMBER,
76: p_msg_data OUT NOCOPY VARCHAR2,
69:
70: PROCEDURE Lock_Row( p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72: p_commit IN VARCHAR2 := FND_API.G_FALSE,
73: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: p_return_status OUT NOCOPY VARCHAR2,
75: p_msg_count OUT NOCOPY NUMBER,
76: p_msg_data OUT NOCOPY VARCHAR2,
77:
97: p_row_locked OUT NOCOPY VARCHAR2
98: );
99:
100: PROCEDURE Delete_Row( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: p_return_status OUT NOCOPY VARCHAR2,
105: p_msg_count OUT NOCOPY NUMBER,
98: );
99:
100: PROCEDURE Delete_Row( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: p_return_status OUT NOCOPY VARCHAR2,
105: p_msg_count OUT NOCOPY NUMBER,
106: p_msg_data OUT NOCOPY VARCHAR2,
99:
100: PROCEDURE Delete_Row( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: p_return_status OUT NOCOPY VARCHAR2,
105: p_msg_count OUT NOCOPY NUMBER,
106: p_msg_data OUT NOCOPY VARCHAR2,
107: