20: -- Pre-reqs : None.
21: -- Parameters :
22: -- IN : p_api_version IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional
24: -- Default = FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
22: -- IN : p_api_version IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional
24: -- Default = FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
29: -- p_RuleAttribute_rec IN
30: -- CN_RuleAttribute_PVT.RuleAttribute_rec_type
24: -- Default = FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
29: -- p_RuleAttribute_rec IN
30: -- CN_RuleAttribute_PVT.RuleAttribute_rec_type
31: --
32: -- OUT : x_return_status OUT VARCHAR2(1)
45: -- End of comments
46:
47: PROCEDURE Create_RuleAttribute
48: ( p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
46:
47: PROCEDURE Create_RuleAttribute
48: ( p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
47: PROCEDURE Create_RuleAttribute
48: ( p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
55: x_loading_status OUT NOCOPY VARCHAR2,
63: -- Pre-reqs : None.
64: -- Parameters :
65: -- IN : p_api_version IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional
67: -- Default = FND_API.G_FALSE
68: -- p_commit IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional
71: -- Default = FND_API.G_VALID_LEVEL_FULL
65: -- IN : p_api_version IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional
67: -- Default = FND_API.G_FALSE
68: -- p_commit IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional
71: -- Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_RuleAttribute_rec IN
73: -- CN_RuleAttribute_PVT.RuleAttribute_rec_type
67: -- Default = FND_API.G_FALSE
68: -- p_commit IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional
71: -- Default = FND_API.G_VALID_LEVEL_FULL
72: -- p_RuleAttribute_rec IN
73: -- CN_RuleAttribute_PVT.RuleAttribute_rec_type
74: --
75: -- OUT : x_return_status OUT VARCHAR2(1)
96:
97:
98: PROCEDURE Update_RuleAttribute
99: ( p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
97:
98: PROCEDURE Update_RuleAttribute
99: ( p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
98: PROCEDURE Update_RuleAttribute
99: ( p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: x_loading_status OUT NOCOPY VARCHAR2,
115: -- Pre-reqs : None.
116: -- Parameters :
117: -- IN : p_api_version IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional
119: -- Default = FND_API.G_FALSE
120: -- p_commit IN VARCHAR2 Optional
121: -- Default = FND_API.G_FALSE
122: -- p_validation_level IN NUMBER Optional
123: -- Default = FND_API.G_VALID_LEVEL_FULL
117: -- IN : p_api_version IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional
119: -- Default = FND_API.G_FALSE
120: -- p_commit IN VARCHAR2 Optional
121: -- Default = FND_API.G_FALSE
122: -- p_validation_level IN NUMBER Optional
123: -- Default = FND_API.G_VALID_LEVEL_FULL
124: -- p_attribute_rule_id IN
125: -- cn_attribute_rule.attribute_rule_id%type
119: -- Default = FND_API.G_FALSE
120: -- p_commit IN VARCHAR2 Optional
121: -- Default = FND_API.G_FALSE
122: -- p_validation_level IN NUMBER Optional
123: -- Default = FND_API.G_VALID_LEVEL_FULL
124: -- p_attribute_rule_id IN
125: -- cn_attribute_rule.attribute_rule_id%type
126: --
127: -- OUT : x_return_status OUT VARCHAR2(1)
140: -- End of comments
141:
142: PROCEDURE Delete_RuleAttribute
143: ( p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
141:
142: PROCEDURE Delete_RuleAttribute
143: ( p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
142: PROCEDURE Delete_RuleAttribute
143: ( p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: x_loading_status OUT NOCOPY VARCHAR2,