2: /* $Header: pvstchgs.pls 115.3 2003/12/04 01:42:54 pklin noship $ */
3:
4: PROCEDURE STATUS_CHANGE_NOTIFICATION(
5: p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: P_BENEFIT_ID IN NUMBER,
10: P_STATUS IN VARCHAR2,
3:
4: PROCEDURE STATUS_CHANGE_NOTIFICATION(
5: p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: P_BENEFIT_ID IN NUMBER,
10: P_STATUS IN VARCHAR2,
11: P_ENTITY_ID IN NUMBER,
4: PROCEDURE STATUS_CHANGE_NOTIFICATION(
5: p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: P_BENEFIT_ID IN NUMBER,
10: P_STATUS IN VARCHAR2,
11: P_ENTITY_ID IN NUMBER,
12: P_PARTNER_ID IN NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2);
19:
20: PROCEDURE STATUS_CHANGE_LOGGING(
21: p_api_version_number IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_BENEFIT_ID IN NUMBER,
26: P_STATUS IN VARCHAR2,
19:
20: PROCEDURE STATUS_CHANGE_LOGGING(
21: p_api_version_number IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_BENEFIT_ID IN NUMBER,
26: P_STATUS IN VARCHAR2,
27: P_ENTITY_ID IN NUMBER,
20: PROCEDURE STATUS_CHANGE_LOGGING(
21: p_api_version_number IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: P_BENEFIT_ID IN NUMBER,
26: P_STATUS IN VARCHAR2,
27: P_ENTITY_ID IN NUMBER,
28: P_PARTNER_ID IN NUMBER,
52: p_event in out nocopy wf_event_t) return varchar2;
53:
54: PROCEDURE STATUS_CHANGE_RAISE (
55: p_api_version_number IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_event_name IN VARCHAR2,
60: p_benefit_id IN NUMBER,
53:
54: PROCEDURE STATUS_CHANGE_RAISE (
55: p_api_version_number IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_event_name IN VARCHAR2,
60: p_benefit_id IN NUMBER,
61: p_entity_id IN NUMBER,
54: PROCEDURE STATUS_CHANGE_RAISE (
55: p_api_version_number IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_event_name IN VARCHAR2,
60: p_benefit_id IN NUMBER,
61: p_entity_id IN NUMBER,
62: p_status_code IN VARCHAR2,