64: -- Procedure Clear_Dependent_Attr
65:
66: PROCEDURE Clear_Dependent_Attr
67: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
68: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
69: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
71: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
72: );
65:
66: PROCEDURE Clear_Dependent_Attr
67: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
68: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
69: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
71: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
72: );
73:
66: PROCEDURE Clear_Dependent_Attr
67: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
68: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
69: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
71: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
72: );
73:
74: -- Procedure Apply_Attribute_Changes
67: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
68: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
69: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
71: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
72: );
73:
74: -- Procedure Apply_Attribute_Changes
75:
73:
74: -- Procedure Apply_Attribute_Changes
75:
76: PROCEDURE Apply_Attribute_Changes
77: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
78: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
79: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
80: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
81: );
74: -- Procedure Apply_Attribute_Changes
75:
76: PROCEDURE Apply_Attribute_Changes
77: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
78: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
79: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
80: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
81: );
82:
75:
76: PROCEDURE Apply_Attribute_Changes
77: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
78: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
79: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
80: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
81: );
82:
83: -- Function Complete_Record
76: PROCEDURE Apply_Attribute_Changes
77: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
78: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
79: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
80: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
81: );
82:
83: -- Function Complete_Record
84:
82:
83: -- Function Complete_Record
84:
85: FUNCTION Complete_Record
86: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
87: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
88: ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
89:
90: -- Function Convert_Miss_To_Null
83: -- Function Complete_Record
84:
85: FUNCTION Complete_Record
86: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
87: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
88: ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
89:
90: -- Function Convert_Miss_To_Null
91:
84:
85: FUNCTION Complete_Record
86: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
87: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
88: ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
89:
90: -- Function Convert_Miss_To_Null
91:
92: FUNCTION Convert_Miss_To_Null
89:
90: -- Function Convert_Miss_To_Null
91:
92: FUNCTION Convert_Miss_To_Null
93: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
94: ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
95:
96: -- Procedure Update_Row
97:
90: -- Function Convert_Miss_To_Null
91:
92: FUNCTION Convert_Miss_To_Null
93: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
94: ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
95:
96: -- Procedure Update_Row
97:
98: PROCEDURE Update_Row
95:
96: -- Procedure Update_Row
97:
98: PROCEDURE Update_Row
99: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
100: );
101:
102: -- Procedure Insert_Row
103:
101:
102: -- Procedure Insert_Row
103:
104: PROCEDURE Insert_Row
105: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
106: );
107:
108: -- Procedure Delete_Row
109:
114: -- Function Query_Row
115:
116: FUNCTION Query_Row
117: ( p_list_header_id IN NUMBER
118: ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
119:
120: -- Procedure lock_Row
121: --
122:
121: --
122:
123: PROCEDURE Lock_Row
124: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
126: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
127: );
128:
129: -- Function Get_Values
122:
123: PROCEDURE Lock_Row
124: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
126: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
127: );
128:
129: -- Function Get_Values
130:
128:
129: -- Function Get_Values
130:
131: FUNCTION Get_Values
132: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
133: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
134: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
135: ) RETURN QP_Price_List_PUB.Price_List_Val_Rec_Type;
136:
129: -- Function Get_Values
130:
131: FUNCTION Get_Values
132: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
133: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
134: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
135: ) RETURN QP_Price_List_PUB.Price_List_Val_Rec_Type;
136:
137: -- Function Get_Ids
130:
131: FUNCTION Get_Values
132: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
133: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
134: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
135: ) RETURN QP_Price_List_PUB.Price_List_Val_Rec_Type;
136:
137: -- Function Get_Ids
138:
131: FUNCTION Get_Values
132: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
133: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
134: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
135: ) RETURN QP_Price_List_PUB.Price_List_Val_Rec_Type;
136:
137: -- Function Get_Ids
138:
139: FUNCTION Get_Ids
136:
137: -- Function Get_Ids
138:
139: FUNCTION Get_Ids
140: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
141: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
142: ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
143:
144:
137: -- Function Get_Ids
138:
139: FUNCTION Get_Ids
140: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
141: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
142: ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
143:
144:
145: --ENH Upgrade BOAPI for orig_sys...ref RAVI
138:
139: FUNCTION Get_Ids
140: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
141: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
142: ) RETURN QP_Price_List_PUB.Price_List_Rec_Type;
143:
144:
145: --ENH Upgrade BOAPI for orig_sys...ref RAVI
146: FUNCTION Get_Orig_Sys_Hdr(