1: PACKAGE IGC_CC_SEC_GROUP_PKG AUTHID CURRENT_USER as
2: /* $Header: IGCCSCGS.pls 120.4.12000000.1 2007/08/20 12:14:41 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: IGCCSCGS.pls 120.4.12000000.1 2007/08/20 12:14:41 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:
37: P_LAST_UPDATE_LOGIN NUMBER
38: );
39:
40: PROCEDURE Update_Row( p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: p_return_status OUT NOCOPY VARCHAR2,
45: p_msg_count OUT NOCOPY NUMBER,
38: );
39:
40: PROCEDURE Update_Row( p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: p_return_status OUT NOCOPY VARCHAR2,
45: p_msg_count OUT NOCOPY NUMBER,
46: p_msg_data OUT NOCOPY VARCHAR2,
39:
40: PROCEDURE Update_Row( p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: p_return_status OUT NOCOPY VARCHAR2,
45: p_msg_count OUT NOCOPY NUMBER,
46: p_msg_data OUT NOCOPY VARCHAR2,
47:
71: P_LAST_UPDATE_LOGIN NUMBER
72: );
73:
74: PROCEDURE Lock_Row( p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_return_status OUT NOCOPY VARCHAR2,
79: p_msg_count OUT NOCOPY NUMBER,
72: );
73:
74: PROCEDURE Lock_Row( p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_return_status OUT NOCOPY VARCHAR2,
79: p_msg_count OUT NOCOPY NUMBER,
80: p_msg_data OUT NOCOPY VARCHAR2,
73:
74: PROCEDURE Lock_Row( p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_return_status OUT NOCOPY VARCHAR2,
79: p_msg_count OUT NOCOPY NUMBER,
80: p_msg_data OUT NOCOPY VARCHAR2,
81:
103: p_row_locked OUT NOCOPY VARCHAR2
104: );
105:
106: PROCEDURE Delete_Row( p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: p_return_status OUT NOCOPY VARCHAR2,
111: p_msg_count OUT NOCOPY NUMBER,
104: );
105:
106: PROCEDURE Delete_Row( p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: p_return_status OUT NOCOPY VARCHAR2,
111: p_msg_count OUT NOCOPY NUMBER,
112: p_msg_data OUT NOCOPY VARCHAR2,
105:
106: PROCEDURE Delete_Row( p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110: p_return_status OUT NOCOPY VARCHAR2,
111: p_msg_count OUT NOCOPY NUMBER,
112: p_msg_data OUT NOCOPY VARCHAR2,
113:
114: P_ROWID VARCHAR2);
115:
116: PROCEDURE CHECK_UNIQUE(
117: -- p_api_version IN NUMBER,
118: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
120: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: -- p_return_status OUT NOCOPY VARCHAR2,
122: -- p_msg_count OUT NOCOPY NUMBER,
115:
116: PROCEDURE CHECK_UNIQUE(
117: -- p_api_version IN NUMBER,
118: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
120: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: -- p_return_status OUT NOCOPY VARCHAR2,
122: -- p_msg_count OUT NOCOPY NUMBER,
123: -- p_msg_data OUT NOCOPY VARCHAR2,
116: PROCEDURE CHECK_UNIQUE(
117: -- p_api_version IN NUMBER,
118: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
120: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: -- p_return_status OUT NOCOPY VARCHAR2,
122: -- p_msg_count OUT NOCOPY NUMBER,
123: -- p_msg_data OUT NOCOPY VARCHAR2,
124: