52: -- Procedure Clear_Dependent_Attr
53:
54: PROCEDURE Clear_Dependent_Attr
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
57: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
58: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
59: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
60: );
53:
54: PROCEDURE Clear_Dependent_Attr
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
57: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
58: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
59: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
60: );
61:
54: PROCEDURE Clear_Dependent_Attr
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
57: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
58: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
59: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
60: );
61:
62: -- Procedure Apply_Attribute_Changes
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
57: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
58: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
59: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
60: );
61:
62: -- Procedure Apply_Attribute_Changes
63:
61:
62: -- Procedure Apply_Attribute_Changes
63:
64: PROCEDURE Apply_Attribute_Changes
65: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
66: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
67: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
68: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
69: );
62: -- Procedure Apply_Attribute_Changes
63:
64: PROCEDURE Apply_Attribute_Changes
65: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
66: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
67: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
68: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
69: );
70:
63:
64: PROCEDURE Apply_Attribute_Changes
65: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
66: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
67: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
68: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
69: );
70:
71: -- Function Complete_Record
64: PROCEDURE Apply_Attribute_Changes
65: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
66: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
67: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
68: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
69: );
70:
71: -- Function Complete_Record
72:
70:
71: -- Function Complete_Record
72:
73: FUNCTION Complete_Record
74: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
75: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
76: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
77:
78: -- Function Convert_Miss_To_Null
71: -- Function Complete_Record
72:
73: FUNCTION Complete_Record
74: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
75: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
76: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
77:
78: -- Function Convert_Miss_To_Null
79:
72:
73: FUNCTION Complete_Record
74: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
75: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
76: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
77:
78: -- Function Convert_Miss_To_Null
79:
80: FUNCTION Convert_Miss_To_Null
77:
78: -- Function Convert_Miss_To_Null
79:
80: FUNCTION Convert_Miss_To_Null
81: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
82: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
83:
84: -- Procedure Update_Row
85:
78: -- Function Convert_Miss_To_Null
79:
80: FUNCTION Convert_Miss_To_Null
81: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
82: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
83:
84: -- Procedure Update_Row
85:
86: PROCEDURE Update_Row
83:
84: -- Procedure Update_Row
85:
86: PROCEDURE Update_Row
87: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
88: );
89:
90: -- Procedure Insert_Row
91:
89:
90: -- Procedure Insert_Row
91:
92: PROCEDURE Insert_Row
93: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
94: );
95:
96: -- Procedure Delete_Row
97:
102: -- Function Query_Row
103:
104: FUNCTION Query_Row
105: ( p_pricing_attribute_id IN NUMBER
106: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
107:
108: -- Function Query_Rows
109:
110: --
113: ( p_pricing_attribute_id IN NUMBER :=
114: FND_API.G_MISS_NUM
115: , p_list_line_id IN NUMBER :=
116: FND_API.G_MISS_NUM
117: ) RETURN QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
118:
119: -- Procedure lock_Row
120: --
121:
120: --
121:
122: PROCEDURE Lock_Row
123: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
125: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
126: );
127:
128: -- Function Get_Values
121:
122: PROCEDURE Lock_Row
123: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
125: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
126: );
127:
128: -- Function Get_Values
129:
127:
128: -- Function Get_Values
129:
130: FUNCTION Get_Values
131: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
132: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
133: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
134: ) RETURN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
135:
128: -- Function Get_Values
129:
130: FUNCTION Get_Values
131: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
132: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
133: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
134: ) RETURN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
135:
136: -- Function Get_Ids
129:
130: FUNCTION Get_Values
131: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
132: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
133: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
134: ) RETURN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
135:
136: -- Function Get_Ids
137:
130: FUNCTION Get_Values
131: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
132: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
133: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
134: ) RETURN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
135:
136: -- Function Get_Ids
137:
138: FUNCTION Get_Ids
135:
136: -- Function Get_Ids
137:
138: FUNCTION Get_Ids
139: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
140: , p_PRICING_ATTR_val_rec IN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type
141: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
142:
143: Procedure Pre_Write_Process
136: -- Function Get_Ids
137:
138: FUNCTION Get_Ids
139: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
140: , p_PRICING_ATTR_val_rec IN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type
141: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
142:
143: Procedure Pre_Write_Process
144: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
137:
138: FUNCTION Get_Ids
139: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
140: , p_PRICING_ATTR_val_rec IN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type
141: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
142:
143: Procedure Pre_Write_Process
144: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
145: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
140: , p_PRICING_ATTR_val_rec IN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type
141: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
142:
143: Procedure Pre_Write_Process
144: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
145: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
146: QP_Price_List_PUB.G_MISS_Pricing_Attr_REC
147: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
148: );
141: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;
142:
143: Procedure Pre_Write_Process
144: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
145: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
146: QP_Price_List_PUB.G_MISS_Pricing_Attr_REC
147: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
148: );
149:
142:
143: Procedure Pre_Write_Process
144: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
145: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
146: QP_Price_List_PUB.G_MISS_Pricing_Attr_REC
147: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
148: );
149:
150: END QP_pll_pricing_attr_Util;
143: Procedure Pre_Write_Process
144: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
145: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
146: QP_Price_List_PUB.G_MISS_Pricing_Attr_REC
147: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type
148: );
149:
150: END QP_pll_pricing_attr_Util;