DBA Data[Home] [Help]

APPS.CN_RULE_PVT dependencies on CN_RULE_PVT

Line 1: PACKAGE BODY CN_Rule_PVT AS

1: PACKAGE BODY CN_Rule_PVT AS
2: --$Header: cnvruleb.pls 120.5 2006/03/07 04:57:39 hanaraya ship $
3:
4: --Global Variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_Rule_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_Rule_PVT';

1: PACKAGE BODY CN_Rule_PVT AS
2: --$Header: cnvruleb.pls 120.5 2006/03/07 04:57:39 hanaraya ship $
3:
4: --Global Variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_Rule_PVT';
6: G_LAST_UPDATE_DATE DATE := Sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := Sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;

Line 20: p_rule_rec IN CN_Rule_PVT.rule_rec_type,

16: (
17: x_return_status OUT NOCOPY VARCHAR2 ,
18: x_msg_count OUT NOCOPY NUMBER ,
19: x_msg_data OUT NOCOPY VARCHAR2 ,
20: p_rule_rec IN CN_Rule_PVT.rule_rec_type,
21: p_action IN VARCHAR2,
22: p_loading_status IN VARCHAR2,
23: x_loading_status OUT NOCOPY VARCHAR2
24: )

Line 205: -- CN_Rule_PVT.rule_rec_type

201: -- Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional
203: -- Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_rule_rec IN
205: -- CN_Rule_PVT.rule_rec_type
206: --
207: -- OUT : x_return_status OUT VARCHAR2(1)
208: -- x_msg_count OUT NUMBER
209: -- x_msg_data OUT VARCHAR2(2000)

Line 231: p_rule_rec IN OUT NOCOPY CN_Rule_PVT.rule_rec_type,

227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: x_loading_status OUT NOCOPY VARCHAR2,
231: p_rule_rec IN OUT NOCOPY CN_Rule_PVT.rule_rec_type,
232: x_rule_id OUT NOCOPY NUMBER
233: )
234: IS
235:

Line 476: -- CN_Rule_PVT.rule_rec_type

472: -- Default = FND_API.G_FALSE
473: -- p_validation_level IN NUMBER Optional
474: -- Default = FND_API.G_VALID_LEVEL_FULL
475: -- p_rule_rec_type IN
476: -- CN_Rule_PVT.rule_rec_type
477: --
478: -- OUT : x_return_status OUT VARCHAR2(1)
479: -- x_msg_count OUT NUMBER
480: -- x_msg_data OUT VARCHAR2(2000)

Line 503: p_old_rule_rec IN CN_Rule_PVT.rule_rec_type,

499: x_return_status OUT NOCOPY VARCHAR2,
500: x_msg_count OUT NOCOPY NUMBER,
501: x_msg_data OUT NOCOPY VARCHAR2,
502: x_loading_status OUT NOCOPY VARCHAR2,
503: p_old_rule_rec IN CN_Rule_PVT.rule_rec_type,
504: p_rule_rec IN OUT NOCOPY CN_Rule_PVT.rule_rec_type
505: ) IS
506:
507: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule';

Line 504: p_rule_rec IN OUT NOCOPY CN_Rule_PVT.rule_rec_type

500: x_msg_count OUT NOCOPY NUMBER,
501: x_msg_data OUT NOCOPY VARCHAR2,
502: x_loading_status OUT NOCOPY VARCHAR2,
503: p_old_rule_rec IN CN_Rule_PVT.rule_rec_type,
504: p_rule_rec IN OUT NOCOPY CN_Rule_PVT.rule_rec_type
505: ) IS
506:
507: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule';
508: l_api_version CONSTANT NUMBER := 1.0;

Line 1334: END CN_Rule_PVT;

1330:
1331: END get_rule_exp;
1332:
1333:
1334: END CN_Rule_PVT;