43: -- Procedure Clear_Dependent_Attr
44:
45: PROCEDURE Clear_Dependent_Attr
46: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
47: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
48: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_REC
50: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
51: );
44:
45: PROCEDURE Clear_Dependent_Attr
46: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
47: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
48: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_REC
50: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
51: );
52:
45: PROCEDURE Clear_Dependent_Attr
46: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
47: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
48: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_REC
50: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
51: );
52:
53: -- Procedure Apply_Attribute_Changes
46: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
47: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
48: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_REC
50: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
51: );
52:
53: -- Procedure Apply_Attribute_Changes
54:
52:
53: -- Procedure Apply_Attribute_Changes
54:
55: PROCEDURE Apply_Attribute_Changes
56: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
57: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
58: QP_Attr_Map_PUB.G_MISS_SOU_REC
59: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
60: );
53: -- Procedure Apply_Attribute_Changes
54:
55: PROCEDURE Apply_Attribute_Changes
56: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
57: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
58: QP_Attr_Map_PUB.G_MISS_SOU_REC
59: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
60: );
61:
54:
55: PROCEDURE Apply_Attribute_Changes
56: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
57: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
58: QP_Attr_Map_PUB.G_MISS_SOU_REC
59: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
60: );
61:
62: -- Function Complete_Record
55: PROCEDURE Apply_Attribute_Changes
56: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
57: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
58: QP_Attr_Map_PUB.G_MISS_SOU_REC
59: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
60: );
61:
62: -- Function Complete_Record
63:
61:
62: -- Function Complete_Record
63:
64: FUNCTION Complete_Record
65: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
66: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
67: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
68:
69: -- Function Convert_Miss_To_Null
62: -- Function Complete_Record
63:
64: FUNCTION Complete_Record
65: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
66: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
67: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
68:
69: -- Function Convert_Miss_To_Null
70:
63:
64: FUNCTION Complete_Record
65: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
66: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
67: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
68:
69: -- Function Convert_Miss_To_Null
70:
71: FUNCTION Convert_Miss_To_Null
68:
69: -- Function Convert_Miss_To_Null
70:
71: FUNCTION Convert_Miss_To_Null
72: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
73: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
74:
75: -- Procedure Update_Row
76:
69: -- Function Convert_Miss_To_Null
70:
71: FUNCTION Convert_Miss_To_Null
72: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
73: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
74:
75: -- Procedure Update_Row
76:
77: PROCEDURE Update_Row
74:
75: -- Procedure Update_Row
76:
77: PROCEDURE Update_Row
78: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
79: );
80:
81: -- Procedure Insert_Row
82:
80:
81: -- Procedure Insert_Row
82:
83: PROCEDURE Insert_Row
84: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
85: );
86:
87: -- Procedure Delete_Row
88:
93: -- Function Query_Row
94:
95: FUNCTION Query_Row
96: ( p_attribute_sourcing_id IN NUMBER
97: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
98:
99: -- Function Query_Rows
100:
101: --
104: ( p_attribute_sourcing_id IN NUMBER :=
105: FND_API.G_MISS_NUM
106: , p_segment_pte_id IN NUMBER :=
107: FND_API.G_MISS_NUM
108: ) RETURN QP_Attr_Map_PUB.Sou_Tbl_Type;
109:
110: -- Procedure lock_Row
111: --
112:
111: --
112:
113: PROCEDURE Lock_Row
114: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
116: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
117: );
118:
119: -- Function Get_Values
112:
113: PROCEDURE Lock_Row
114: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
116: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
117: );
118:
119: -- Function Get_Values
120:
118:
119: -- Function Get_Values
120:
121: FUNCTION Get_Values
122: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
123: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
124: QP_Attr_Map_PUB.G_MISS_SOU_REC
125: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type;
126:
119: -- Function Get_Values
120:
121: FUNCTION Get_Values
122: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
123: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
124: QP_Attr_Map_PUB.G_MISS_SOU_REC
125: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type;
126:
127: -- Function Get_Ids
120:
121: FUNCTION Get_Values
122: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
123: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
124: QP_Attr_Map_PUB.G_MISS_SOU_REC
125: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type;
126:
127: -- Function Get_Ids
128:
121: FUNCTION Get_Values
122: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
123: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
124: QP_Attr_Map_PUB.G_MISS_SOU_REC
125: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type;
126:
127: -- Function Get_Ids
128:
129: FUNCTION Get_Ids
126:
127: -- Function Get_Ids
128:
129: FUNCTION Get_Ids
130: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
131: , p_SOU_val_rec IN QP_Attr_Map_PUB.Sou_Val_Rec_Type
132: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
133:
134: END QP_Sou_Util;
127: -- Function Get_Ids
128:
129: FUNCTION Get_Ids
130: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
131: , p_SOU_val_rec IN QP_Attr_Map_PUB.Sou_Val_Rec_Type
132: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
133:
134: END QP_Sou_Util;
128:
129: FUNCTION Get_Ids
130: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
131: , p_SOU_val_rec IN QP_Attr_Map_PUB.Sou_Val_Rec_Type
132: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
133:
134: END QP_Sou_Util;