3:
4: PROCEDURE CREATE_SUBSCRIPTION_Pre
5: (
6:
7: p_x_subscription_tbl IN OUT NOCOPY AHL_DI_SUBSCRIPTION_PVT.subscription_tbl,
8: x_return_status OUT NOCOPY VARCHAR2 ,
9: x_msg_count OUT NOCOPY NUMBER ,
10: x_msg_data OUT NOCOPY VARCHAR2
11: );
12:
13: PROCEDURE CREATE_SUBSCRIPTION_Post
14: (
15:
16: p_subscription_tbl IN AHL_DI_SUBSCRIPTION_PVT.subscription_tbl,
17: x_return_status OUT NOCOPY VARCHAR2 ,
18: x_msg_count OUT NOCOPY NUMBER ,
19: x_msg_data OUT NOCOPY VARCHAR2
20: );
22:
23: PROCEDURE MODIFY_SUBSCRIPTION_Pre
24: (
25:
26: p_x_subscription_tbl IN OUT NOCOPY AHL_DI_SUBSCRIPTION_PVT.subscription_tbl,
27: x_return_status OUT NOCOPY VARCHAR2 ,
28: x_msg_count OUT NOCOPY NUMBER ,
29: x_msg_data OUT NOCOPY VARCHAR2
30:
32:
33: PROCEDURE MODIFY_SUBSCRIPTION_Post
34: (
35:
36: p_subscription_tbl IN AHL_DI_SUBSCRIPTION_PVT.subscription_tbl,
37: x_return_status OUT NOCOPY VARCHAR2 ,
38: x_msg_count OUT NOCOPY NUMBER ,
39: x_msg_data OUT NOCOPY VARCHAR2
40: