12:
13: /*FOR INSERT */
14: PROCEDURE INSERT_GROUP(
15: P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_GROUP_ID IN NUMBER,
19: P_GROUP_NUMBER IN VARCHAR2,
20: P_EMAIL_ADDRESS IN VARCHAR2,
13: /*FOR INSERT */
14: PROCEDURE INSERT_GROUP(
15: P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_GROUP_ID IN NUMBER,
19: P_GROUP_NUMBER IN VARCHAR2,
20: P_EMAIL_ADDRESS IN VARCHAR2,
21: P_START_DATE_ACTIVE IN DATE,
33: /* FOR UPDATE */
34:
35: PROCEDURE UPDATE_GROUP(
36: P_API_VERSION IN NUMBER,
37: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: P_GROUP_ID IN NUMBER,
40: P_GROUP_NUMBER IN VARCHAR2,
41: P_EMAIL_ADDRESS IN VARCHAR2,
34:
35: PROCEDURE UPDATE_GROUP(
36: P_API_VERSION IN NUMBER,
37: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: P_GROUP_ID IN NUMBER,
40: P_GROUP_NUMBER IN VARCHAR2,
41: P_EMAIL_ADDRESS IN VARCHAR2,
42: P_START_DATE_ACTIVE IN DATE,
39: P_GROUP_ID IN NUMBER,
40: P_GROUP_NUMBER IN VARCHAR2,
41: P_EMAIL_ADDRESS IN VARCHAR2,
42: P_START_DATE_ACTIVE IN DATE,
43: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
44: P_ACCOUNTING_CODE IN VARCHAR2,
45: P_EXCLUSIVE_FLAG IN VARCHAR2,
46: P_GROUP_NAME IN VARCHAR2,
47: P_GROUP_DESC IN VARCHAR2,
54: --FOR DELETE
55:
56: PROCEDURE DELETE_GROUP(
57: P_API_VERSION IN NUMBER,
58: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: P_GROUP_ID IN NUMBER,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62: X_MSG_COUNT OUT NOCOPY NUMBER,
55:
56: PROCEDURE DELETE_GROUP(
57: P_API_VERSION IN NUMBER,
58: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: P_GROUP_ID IN NUMBER,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62: X_MSG_COUNT OUT NOCOPY NUMBER,
63: X_MSG_DATA OUT NOCOPY VARCHAR2 );