14: -- Insert_Relation
15: -- Parameters :
16: -- IN : p_api_version_number number current version = 1.0
17: -- p_init_msg_list varchar2 standard api parameter
18: -- defaults to FND_API.G_FALSE, set to
19: -- FND_API.G_TRUE to have api initialize message list
20: -- p_simulate varchar2 standard api parameter
21: -- defaults to FND_API.G_FALSE, set to
22: -- FND_API.G_TRUE for simulation mode (api will not
15: -- Parameters :
16: -- IN : p_api_version_number number current version = 1.0
17: -- p_init_msg_list varchar2 standard api parameter
18: -- defaults to FND_API.G_FALSE, set to
19: -- FND_API.G_TRUE to have api initialize message list
20: -- p_simulate varchar2 standard api parameter
21: -- defaults to FND_API.G_FALSE, set to
22: -- FND_API.G_TRUE for simulation mode (api will not
23: -- commit any changes)
17: -- p_init_msg_list varchar2 standard api parameter
18: -- defaults to FND_API.G_FALSE, set to
19: -- FND_API.G_TRUE to have api initialize message list
20: -- p_simulate varchar2 standard api parameter
21: -- defaults to FND_API.G_FALSE, set to
22: -- FND_API.G_TRUE for simulation mode (api will not
23: -- commit any changes)
24: -- p_commit varchar2 standard api parameter
25: -- defaults to FND_API.G_FALSE, set to
18: -- defaults to FND_API.G_FALSE, set to
19: -- FND_API.G_TRUE to have api initialize message list
20: -- p_simulate varchar2 standard api parameter
21: -- defaults to FND_API.G_FALSE, set to
22: -- FND_API.G_TRUE for simulation mode (api will not
23: -- commit any changes)
24: -- p_commit varchar2 standard api parameter
25: -- defaults to FND_API.G_FALSE, set to
26: -- FND_API.G_TRUE to have api commit changes
21: -- defaults to FND_API.G_FALSE, set to
22: -- FND_API.G_TRUE for simulation mode (api will not
23: -- commit any changes)
24: -- p_commit varchar2 standard api parameter
25: -- defaults to FND_API.G_FALSE, set to
26: -- FND_API.G_TRUE to have api commit changes
27: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
28: -- p_validation_level number standard api parameter
29: -- defaults to FND_API.G_VALID_LEVEL_FULL
22: -- FND_API.G_TRUE for simulation mode (api will not
23: -- commit any changes)
24: -- p_commit varchar2 standard api parameter
25: -- defaults to FND_API.G_FALSE, set to
26: -- FND_API.G_TRUE to have api commit changes
27: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
28: -- p_validation_level number standard api parameter
29: -- defaults to FND_API.G_VALID_LEVEL_FULL
30: -- p_category_set_id number
23: -- commit any changes)
24: -- p_commit varchar2 standard api parameter
25: -- defaults to FND_API.G_FALSE, set to
26: -- FND_API.G_TRUE to have api commit changes
27: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
28: -- p_validation_level number standard api parameter
29: -- defaults to FND_API.G_VALID_LEVEL_FULL
30: -- p_category_set_id number
31: -- either p_category_set_id or p_category_set must
25: -- defaults to FND_API.G_FALSE, set to
26: -- FND_API.G_TRUE to have api commit changes
27: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
28: -- p_validation_level number standard api parameter
29: -- defaults to FND_API.G_VALID_LEVEL_FULL
30: -- p_category_set_id number
31: -- either p_category_set_id or p_category_set must
32: -- be provided to the api. If p_category_set_id is
33: -- provided, then p_category_set is ignored. If
69: -- Delet_Relation
70: -- Parameters :
71: -- IN : p_api_version_number number current version = 1.0
72: -- p_init_msg_list varchar2 standard api parameter
73: -- defaults to FND_API.G_FALSE, set to
74: -- FND_API.G_TRUE to have api initialize message list
75: -- p_simulate varchar2 standard api parameter
76: -- defaults to FND_API.G_FALSE, set to
77: -- FND_API.G_TRUE for simulation mode (api will not
70: -- Parameters :
71: -- IN : p_api_version_number number current version = 1.0
72: -- p_init_msg_list varchar2 standard api parameter
73: -- defaults to FND_API.G_FALSE, set to
74: -- FND_API.G_TRUE to have api initialize message list
75: -- p_simulate varchar2 standard api parameter
76: -- defaults to FND_API.G_FALSE, set to
77: -- FND_API.G_TRUE for simulation mode (api will not
78: -- commit any changes)
72: -- p_init_msg_list varchar2 standard api parameter
73: -- defaults to FND_API.G_FALSE, set to
74: -- FND_API.G_TRUE to have api initialize message list
75: -- p_simulate varchar2 standard api parameter
76: -- defaults to FND_API.G_FALSE, set to
77: -- FND_API.G_TRUE for simulation mode (api will not
78: -- commit any changes)
79: -- p_commit varchar2 standard api parameter
80: -- defaults to FND_API.G_FALSE, set to
73: -- defaults to FND_API.G_FALSE, set to
74: -- FND_API.G_TRUE to have api initialize message list
75: -- p_simulate varchar2 standard api parameter
76: -- defaults to FND_API.G_FALSE, set to
77: -- FND_API.G_TRUE for simulation mode (api will not
78: -- commit any changes)
79: -- p_commit varchar2 standard api parameter
80: -- defaults to FND_API.G_FALSE, set to
81: -- FND_API.G_TRUE to have api commit changes
76: -- defaults to FND_API.G_FALSE, set to
77: -- FND_API.G_TRUE for simulation mode (api will not
78: -- commit any changes)
79: -- p_commit varchar2 standard api parameter
80: -- defaults to FND_API.G_FALSE, set to
81: -- FND_API.G_TRUE to have api commit changes
82: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
83: -- p_validation_level number standard api parameter
84: -- defaults to FND_API.G_VALID_LEVEL_FULL
77: -- FND_API.G_TRUE for simulation mode (api will not
78: -- commit any changes)
79: -- p_commit varchar2 standard api parameter
80: -- defaults to FND_API.G_FALSE, set to
81: -- FND_API.G_TRUE to have api commit changes
82: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
83: -- p_validation_level number standard api parameter
84: -- defaults to FND_API.G_VALID_LEVEL_FULL
85: -- p_category_set_id number
78: -- commit any changes)
79: -- p_commit varchar2 standard api parameter
80: -- defaults to FND_API.G_FALSE, set to
81: -- FND_API.G_TRUE to have api commit changes
82: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
83: -- p_validation_level number standard api parameter
84: -- defaults to FND_API.G_VALID_LEVEL_FULL
85: -- p_category_set_id number
86: -- either p_category_set_id or p_category_set must
80: -- defaults to FND_API.G_FALSE, set to
81: -- FND_API.G_TRUE to have api commit changes
82: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
83: -- p_validation_level number standard api parameter
84: -- defaults to FND_API.G_VALID_LEVEL_FULL
85: -- p_category_set_id number
86: -- either p_category_set_id or p_category_set must
87: -- be provided to the api. If p_category_set_id is
88: -- provided, then p_category_set is ignored. If
126:
127:
128: PROCEDURE Insert_Relation
129: ( p_api_version_number IN NUMBER ,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
134: p_return_status OUT VARCHAR2 ,
127:
128: PROCEDURE Insert_Relation
129: ( p_api_version_number IN NUMBER ,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
134: p_return_status OUT VARCHAR2 ,
135: p_msg_count OUT NUMBER ,
128: PROCEDURE Insert_Relation
129: ( p_api_version_number IN NUMBER ,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
134: p_return_status OUT VARCHAR2 ,
135: p_msg_count OUT NUMBER ,
136: p_msg_data OUT VARCHAR2 ,
129: ( p_api_version_number IN NUMBER ,
130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
132: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
134: p_return_status OUT VARCHAR2 ,
135: p_msg_count OUT NUMBER ,
136: p_msg_data OUT VARCHAR2 ,
137: p_category_set_id IN NUMBER DEFAULT NULL ,
146:
147:
148: PROCEDURE Delete_Relation
149: ( p_api_version_number IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
154: p_return_status OUT VARCHAR2 ,
147:
148: PROCEDURE Delete_Relation
149: ( p_api_version_number IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
154: p_return_status OUT VARCHAR2 ,
155: p_msg_count OUT NUMBER ,
148: PROCEDURE Delete_Relation
149: ( p_api_version_number IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
154: p_return_status OUT VARCHAR2 ,
155: p_msg_count OUT NUMBER ,
156: p_msg_data OUT VARCHAR2 ,
149: ( p_api_version_number IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
154: p_return_status OUT VARCHAR2 ,
155: p_msg_count OUT NUMBER ,
156: p_msg_data OUT VARCHAR2 ,
157: p_category_set_id IN NUMBER DEFAULT NULL ,