10: -- p_api_version IN NUMBER (required)
11: -- API Version of this procedure
12: --
13: -- p_init_msg_list IN VARCHAR2 (optional)
14: -- DEFAULT = FND_API.G_FALSE,
15: --
16: -- p_commit IN VARCHAR2 (optional)
17: -- DEFAULT = FND_API.G_FALSE
18: --
13: -- p_init_msg_list IN VARCHAR2 (optional)
14: -- DEFAULT = FND_API.G_FALSE,
15: --
16: -- p_commit IN VARCHAR2 (optional)
17: -- DEFAULT = FND_API.G_FALSE
18: --
19: --
20: -- OUT NOCOPY /* file.sql.39 change */ :
21: -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
34: -- Notes :
35: -- END OF comments
36: PROCEDURE ExecCheck (
37: p_api_version IN NUMBER ,
38: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
41: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
42: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
35: -- END OF comments
36: PROCEDURE ExecCheck (
37: p_api_version IN NUMBER ,
38: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
41: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
42: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
43: p_sum_detail_flag IN NUMBER,
58: -- p_api_version IN NUMBER (required)
59: -- API Version of this procedure
60: --
61: -- p_init_msg_list IN VARCHAR2 (optional)
62: -- DEFAULT = FND_API.G_FALSE,
63: --
64: -- p_commit IN VARCHAR2 (optional)
65: -- DEFAULT = FND_API.G_FALSE
66: --
61: -- p_init_msg_list IN VARCHAR2 (optional)
62: -- DEFAULT = FND_API.G_FALSE,
63: --
64: -- p_commit IN VARCHAR2 (optional)
65: -- DEFAULT = FND_API.G_FALSE
66: --
67: --
68: -- OUT NOCOPY /* file.sql.39 change */ :
69: -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
80: -- Notes :
81: -- END OF comments
82: PROCEDURE CheckPrerequisites (
83: p_api_version IN NUMBER ,
84: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
86: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
87: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
88: p_sum_detail_flag IN NUMBER,
101: -- p_api_version IN NUMBER (required)
102: -- API Version of this procedure
103: --
104: -- p_init_msg_list IN VARCHAR2 (optional)
105: -- DEFAULT = FND_API.G_FALSE,
106: --
107: -- p_commit IN VARCHAR2 (optional)
108: -- DEFAULT = FND_API.G_FALSE
109: --
104: -- p_init_msg_list IN VARCHAR2 (optional)
105: -- DEFAULT = FND_API.G_FALSE,
106: --
107: -- p_commit IN VARCHAR2 (optional)
108: -- DEFAULT = FND_API.G_FALSE
109: --
110: --
111: -- OUT NOCOPY /* file.sql.39 change */ :
112: -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
123: -- Notes :
124: -- END OF comments
125: PROCEDURE SendNotifications (
126: p_api_version IN NUMBER ,
127: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
128: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
130: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
131: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
124: -- END OF comments
125: PROCEDURE SendNotifications (
126: p_api_version IN NUMBER ,
127: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
128: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
130: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
131: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
132: p_organization_id IN NUMBER,
144: -- p_api_version IN NUMBER (required)
145: -- API Version of this procedure
146: --
147: -- p_init_msg_list IN VARCHAR2 (optional)
148: -- DEFAULT = FND_API.G_FALSE,
149: --
150: -- p_commit IN VARCHAR2 (optional)
151: -- DEFAULT = FND_API.G_FALSE
152: --
147: -- p_init_msg_list IN VARCHAR2 (optional)
148: -- DEFAULT = FND_API.G_FALSE,
149: --
150: -- p_commit IN VARCHAR2 (optional)
151: -- DEFAULT = FND_API.G_FALSE
152: --
153: -- p_seq_num IN NUMBER
154: -- Sequence number of rows which have to be deleted
155: --
172: -- Notes :
173: -- END OF comments
174: PROCEDURE PurgeTempTable (
175: p_api_version IN NUMBER ,
176: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
177: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
178: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
179: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
180: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
173: -- END OF comments
174: PROCEDURE PurgeTempTable (
175: p_api_version IN NUMBER ,
176: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
177: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
178: x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
179: x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
180: x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
181: p_seq_num IN NUMBER