DBA Data[Home] [Help]

APPS.CN_RULESET_PVT dependencies on FND_API

Line 16: -- with the defaults (fnd_api.g_miss_num etc. ) if this API is invoked

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

Line 28: -- Default = FND_API.G_FALSE

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

Line 30: -- Default = FND_API.G_FALSE

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

Line 32: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 54: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 75: -- Default = FND_API.G_FALSE

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

Line 77: -- Default = FND_API.G_FALSE

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

Line 79: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 102: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 121: -- Default = FND_API.G_FALSE

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

Line 123: -- Default = FND_API.G_FALSE

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

Line 125: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 149: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,