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_template varchar2
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_template varchar2
31: -- p_template must be provided to the api. This is the
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_template varchar2
31: -- p_template must be provided to the api. This is the
32: -- parent of the template relationship being inserted
33: -- p_related_template
56: -- Delete_Relation
57: -- Parameters :
58: -- IN : p_api_version_number number current version = 1.0
59: -- p_init_msg_list varchar2 standard api parameter
60: -- defaults to FND_API.G_FALSE, set to
61: -- FND_API.G_TRUE to have api initialize message list
62: -- p_simulate varchar2 standard api parameter
63: -- defaults to FND_API.G_FALSE, set to
64: -- FND_API.G_TRUE for simulation mode (api will not
57: -- Parameters :
58: -- IN : p_api_version_number number current version = 1.0
59: -- p_init_msg_list varchar2 standard api parameter
60: -- defaults to FND_API.G_FALSE, set to
61: -- FND_API.G_TRUE to have api initialize message list
62: -- p_simulate varchar2 standard api parameter
63: -- defaults to FND_API.G_FALSE, set to
64: -- FND_API.G_TRUE for simulation mode (api will not
65: -- commit any changes)
59: -- p_init_msg_list varchar2 standard api parameter
60: -- defaults to FND_API.G_FALSE, set to
61: -- FND_API.G_TRUE to have api initialize message list
62: -- p_simulate varchar2 standard api parameter
63: -- defaults to FND_API.G_FALSE, set to
64: -- FND_API.G_TRUE for simulation mode (api will not
65: -- commit any changes)
66: -- p_commit varchar2 standard api parameter
67: -- defaults to FND_API.G_FALSE, set to
60: -- defaults to FND_API.G_FALSE, set to
61: -- FND_API.G_TRUE to have api initialize message list
62: -- p_simulate varchar2 standard api parameter
63: -- defaults to FND_API.G_FALSE, set to
64: -- FND_API.G_TRUE for simulation mode (api will not
65: -- commit any changes)
66: -- p_commit varchar2 standard api parameter
67: -- defaults to FND_API.G_FALSE, set to
68: -- FND_API.G_TRUE to have api commit changes
63: -- defaults to FND_API.G_FALSE, set to
64: -- FND_API.G_TRUE for simulation mode (api will not
65: -- commit any changes)
66: -- p_commit varchar2 standard api parameter
67: -- defaults to FND_API.G_FALSE, set to
68: -- FND_API.G_TRUE to have api commit changes
69: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
70: -- p_validation_level number standard api parameter
71: -- defaults to FND_API.G_VALID_LEVEL_FULL
64: -- FND_API.G_TRUE for simulation mode (api will not
65: -- commit any changes)
66: -- p_commit varchar2 standard api parameter
67: -- defaults to FND_API.G_FALSE, set to
68: -- FND_API.G_TRUE to have api commit changes
69: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
70: -- p_validation_level number standard api parameter
71: -- defaults to FND_API.G_VALID_LEVEL_FULL
72: -- p_template varchar2
65: -- commit any changes)
66: -- p_commit varchar2 standard api parameter
67: -- defaults to FND_API.G_FALSE, set to
68: -- FND_API.G_TRUE to have api commit changes
69: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
70: -- p_validation_level number standard api parameter
71: -- defaults to FND_API.G_VALID_LEVEL_FULL
72: -- p_template varchar2
73: -- p_template must be provided to the api. This is the
67: -- defaults to FND_API.G_FALSE, set to
68: -- FND_API.G_TRUE to have api commit changes
69: -- p_commit is ignored if p_simulate = FND_API.G_TRUE
70: -- p_validation_level number standard api parameter
71: -- defaults to FND_API.G_VALID_LEVEL_FULL
72: -- p_template varchar2
73: -- p_template must be provided to the api. This is the
74: -- parent of the template relationship being deleted
75: -- p_related_template
100:
101:
102: PROCEDURE Insert_Relation
103: ( p_api_version_number IN NUMBER ,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
105: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
106: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
108: p_return_status OUT VARCHAR2 ,
101:
102: PROCEDURE Insert_Relation
103: ( p_api_version_number IN NUMBER ,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
105: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
106: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
108: p_return_status OUT VARCHAR2 ,
109: p_msg_count OUT NUMBER ,
102: PROCEDURE Insert_Relation
103: ( p_api_version_number IN NUMBER ,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
105: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
106: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
108: p_return_status OUT VARCHAR2 ,
109: p_msg_count OUT NUMBER ,
110: p_msg_data OUT VARCHAR2 ,
103: ( p_api_version_number IN NUMBER ,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
105: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
106: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
108: p_return_status OUT VARCHAR2 ,
109: p_msg_count OUT NUMBER ,
110: p_msg_data OUT VARCHAR2 ,
111: p_template IN VARCHAR2 DEFAULT NULL ,
116:
117:
118: PROCEDURE Delete_Relation
119: ( p_api_version_number IN NUMBER ,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
121: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
124: p_return_status OUT VARCHAR2 ,
117:
118: PROCEDURE Delete_Relation
119: ( p_api_version_number IN NUMBER ,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
121: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
124: p_return_status OUT VARCHAR2 ,
125: p_msg_count OUT NUMBER ,
118: PROCEDURE Delete_Relation
119: ( p_api_version_number IN NUMBER ,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
121: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
124: p_return_status OUT VARCHAR2 ,
125: p_msg_count OUT NUMBER ,
126: p_msg_data OUT VARCHAR2 ,
119: ( p_api_version_number IN NUMBER ,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
121: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
124: p_return_status OUT VARCHAR2 ,
125: p_msg_count OUT NUMBER ,
126: p_msg_data OUT VARCHAR2 ,
127: p_template IN VARCHAR2 DEFAULT NULL ,