12: org_id number
13: );
14:
15: -- NOTE : Due to a bug in FORMS 6.0.4, the record type cannot be initialized
16: -- with the defaults (fnd_api.g_miss_num etc. ) if this API is invoked
17: -- from forms. Hence this version does not initialize the variables
18:
19: -- Start of comments
20: -- API name : Create_Rule
24: -- Pre-reqs : None.
25: -- Parameters :
26: -- IN : p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Optional
28: -- Default = FND_API.G_FALSE
29: -- p_commit IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Optional
32: -- Default = FND_API.G_VALID_LEVEL_FULL
26: -- IN : p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Optional
28: -- Default = FND_API.G_FALSE
29: -- p_commit IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Optional
32: -- Default = FND_API.G_VALID_LEVEL_FULL
33: -- p_ruleset_rec_type IN
34: -- CN_RuleSet_PVT.ruleset_rec_type
28: -- Default = FND_API.G_FALSE
29: -- p_commit IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Optional
32: -- Default = FND_API.G_VALID_LEVEL_FULL
33: -- p_ruleset_rec_type IN
34: -- CN_RuleSet_PVT.ruleset_rec_type
35: --
36: -- OUT : x_return_status OUT VARCHAR2(1)
49: -- End of comments
50:
51: PROCEDURE create_ruleset
52: ( p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
50:
51: PROCEDURE create_ruleset
52: ( p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
51: PROCEDURE create_ruleset
52: ( p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: x_loading_status OUT NOCOPY VARCHAR2,
71: -- Pre-reqs : None.
72: -- Parameters :
73: -- IN : p_api_version IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional
75: -- Default = FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default = FND_API.G_VALID_LEVEL_FULL
73: -- IN : p_api_version IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional
75: -- Default = FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_ruleset_rec_type IN
81: -- CN_RuleSet_PVT.ruleset_rec_type
75: -- Default = FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_ruleset_rec_type IN
81: -- CN_RuleSet_PVT.ruleset_rec_type
82: --
83: -- OUT : x_return_status OUT VARCHAR2(1)
97:
98:
99: PROCEDURE Update_Ruleset
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
98:
99: PROCEDURE Update_Ruleset
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
99: PROCEDURE Update_Ruleset
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: x_loading_status OUT NOCOPY VARCHAR2,
117: -- Pre-reqs : None.
118: -- Parameters :
119: -- IN : p_api_version IN NUMBER Required
120: -- p_init_msg_list IN VARCHAR2 Optional
121: -- Default = FND_API.G_FALSE
122: -- p_commit IN VARCHAR2 Optional
123: -- Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional
125: -- Default = FND_API.G_VALID_LEVEL_FULL
119: -- IN : p_api_version IN NUMBER Required
120: -- p_init_msg_list IN VARCHAR2 Optional
121: -- Default = FND_API.G_FALSE
122: -- p_commit IN VARCHAR2 Optional
123: -- Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional
125: -- Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_ruleset_rec_type IN
127: -- CN_RuleSet_PVT.ruleset_rec_type
121: -- Default = FND_API.G_FALSE
122: -- p_commit IN VARCHAR2 Optional
123: -- Default = FND_API.G_FALSE
124: -- p_validation_level IN NUMBER Optional
125: -- Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_ruleset_rec_type IN
127: -- CN_RuleSet_PVT.ruleset_rec_type
128: -- p_rule_attr_rec_tbl_type IN
129: -- CN_RuleSet_PVT.rule_attr_rec_tbl_type
144: -- End of comments
145: /*
146: PROCEDURE Delete_Ruleset
147: ( p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
145: /*
146: PROCEDURE Delete_Ruleset
147: ( p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
146: PROCEDURE Delete_Ruleset
147: ( p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: x_loading_status OUT NOCOPY VARCHAR2,