12: p_relationship_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
13: p_one_to_one IN VARCHAR2 := FND_API.G_FALSE ,
14: p_for_all_versions IN VARCHAR2 := FND_API.G_FALSE
15: )
16: RETURN ASO_Quote_Pub.Related_Obj_Tbl_Type
17: IS
18: TYPE Csr_Type IS REF CURSOR;
19: l_csr Csr_Type;
20: l_related_obj_rec ASO_Quote_Pub.Related_Obj_Rec_Type;
16: RETURN ASO_Quote_Pub.Related_Obj_Tbl_Type
17: IS
18: TYPE Csr_Type IS REF CURSOR;
19: l_csr Csr_Type;
20: l_related_obj_rec ASO_Quote_Pub.Related_Obj_Rec_Type;
21: l_related_obj_tbl ASO_Quote_Pub.Related_Obj_Tbl_Type;
22: BEGIN
23: IF FND_API.To_Boolean(p_for_all_versions)
24: AND p_quote_object_type_code = 'HEADER' THEN
17: IS
18: TYPE Csr_Type IS REF CURSOR;
19: l_csr Csr_Type;
20: l_related_obj_rec ASO_Quote_Pub.Related_Obj_Rec_Type;
21: l_related_obj_tbl ASO_Quote_Pub.Related_Obj_Tbl_Type;
22: BEGIN
23: IF FND_API.To_Boolean(p_for_all_versions)
24: AND p_quote_object_type_code = 'HEADER' THEN
25: -- CREATE
114: )
115: IS
116: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Relationship';
117: L_API_VERSION CONSTANT NUMBER := 1.0;
118: l_related_obj_rec ASO_Quote_Pub.Related_Obj_Rec_Type;
119: l_related_obj_tbl ASO_Quote_Pub.Related_Obj_Tbl_Type;
120: l_related_object_id NUMBER;
121: i NUMBER;
122: BEGIN
115: IS
116: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Relationship';
117: L_API_VERSION CONSTANT NUMBER := 1.0;
118: l_related_obj_rec ASO_Quote_Pub.Related_Obj_Rec_Type;
119: l_related_obj_tbl ASO_Quote_Pub.Related_Obj_Tbl_Type;
120: l_related_object_id NUMBER;
121: i NUMBER;
122: BEGIN
123: -- Standard Start of API savepoint
259: IS
260: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Relationship';
261: L_API_VERSION CONSTANT NUMBER := 1.0;
262:
263: l_related_obj_rec ASO_Quote_Pub.Related_Obj_Rec_Type;
264: l_related_obj_tbl ASO_Quote_Pub.Related_Obj_Tbl_Type;
265: l_related_object_id NUMBER;
266: BEGIN
267: -- Standard Start of API savepoint
260: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Relationship';
261: L_API_VERSION CONSTANT NUMBER := 1.0;
262:
263: l_related_obj_rec ASO_Quote_Pub.Related_Obj_Rec_Type;
264: l_related_obj_tbl ASO_Quote_Pub.Related_Obj_Tbl_Type;
265: l_related_object_id NUMBER;
266: BEGIN
267: -- Standard Start of API savepoint
268: SAVEPOINT Delete_Relationship_Pvt;