47: -- Procedure to create subscription for an associated document
48: PROCEDURE CREATE_SUBSCRIPTION
49: (
50: p_api_version IN NUMBER := 1.0 ,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
48: PROCEDURE CREATE_SUBSCRIPTION
49: (
50: p_api_version IN NUMBER := 1.0 ,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
56: x_return_status OUT NOCOPY VARCHAR2 ,
49: (
50: p_api_version IN NUMBER := 1.0 ,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
56: x_return_status OUT NOCOPY VARCHAR2 ,
57: x_msg_count OUT NOCOPY NUMBER ,
50: p_api_version IN NUMBER := 1.0 ,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
56: x_return_status OUT NOCOPY VARCHAR2 ,
57: x_msg_count OUT NOCOPY NUMBER ,
58: x_msg_data OUT NOCOPY VARCHAR2);
60: -- Procedure to Modify subscription for an associated document
61: PROCEDURE MODIFY_SUBSCRIPTION
62: (
63: p_api_version IN NUMBER := 1.0 ,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
66: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
61: PROCEDURE MODIFY_SUBSCRIPTION
62: (
63: p_api_version IN NUMBER := 1.0 ,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
66: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
69: x_return_status OUT NOCOPY VARCHAR2 ,
62: (
63: p_api_version IN NUMBER := 1.0 ,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
66: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
69: x_return_status OUT NOCOPY VARCHAR2 ,
70: x_msg_count OUT NOCOPY NUMBER ,
63: p_api_version IN NUMBER := 1.0 ,
64: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
65: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
66: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
69: x_return_status OUT NOCOPY VARCHAR2 ,
70: x_msg_count OUT NOCOPY NUMBER ,
71: x_msg_data OUT NOCOPY VARCHAR2);
74: -- not supported in this phase)
75: PROCEDURE DELETE_SUBSCRIPTION
76: (
77: p_api_version IN NUMBER := 1.0 ,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
80: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
75: PROCEDURE DELETE_SUBSCRIPTION
76: (
77: p_api_version IN NUMBER := 1.0 ,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
80: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
83: x_return_status OUT NOCOPY VARCHAR2 ,
76: (
77: p_api_version IN NUMBER := 1.0 ,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
80: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
83: x_return_status OUT NOCOPY VARCHAR2 ,
84: x_msg_count OUT NOCOPY NUMBER ,
77: p_api_version IN NUMBER := 1.0 ,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
80: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
83: x_return_status OUT NOCOPY VARCHAR2 ,
84: x_msg_count OUT NOCOPY NUMBER ,
85: x_msg_data OUT NOCOPY VARCHAR2);