45: -- Procedure Clear_Dependent_Attr
46:
47: PROCEDURE Clear_Dependent_Attr
48: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
50: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
51: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
52: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
53: );
46:
47: PROCEDURE Clear_Dependent_Attr
48: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
50: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
51: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
52: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
53: );
54:
47: PROCEDURE Clear_Dependent_Attr
48: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
50: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
51: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
52: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
53: );
54:
55: -- Procedure Apply_Attribute_Changes
48: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
50: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
51: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
52: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
53: );
54:
55: -- Procedure Apply_Attribute_Changes
56:
54:
55: -- Procedure Apply_Attribute_Changes
56:
57: PROCEDURE Apply_Attribute_Changes
58: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
59: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
60: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
61: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
62: );
55: -- Procedure Apply_Attribute_Changes
56:
57: PROCEDURE Apply_Attribute_Changes
58: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
59: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
60: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
61: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
62: );
63:
56:
57: PROCEDURE Apply_Attribute_Changes
58: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
59: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
60: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
61: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
62: );
63:
64: -- Function Complete_Record
57: PROCEDURE Apply_Attribute_Changes
58: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
59: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
60: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
61: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
62: );
63:
64: -- Function Complete_Record
65:
63:
64: -- Function Complete_Record
65:
66: FUNCTION Complete_Record
67: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
68: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
69: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
70:
71: -- Function Convert_Miss_To_Null
64: -- Function Complete_Record
65:
66: FUNCTION Complete_Record
67: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
68: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
69: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
70:
71: -- Function Convert_Miss_To_Null
72:
65:
66: FUNCTION Complete_Record
67: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
68: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
69: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
70:
71: -- Function Convert_Miss_To_Null
72:
73: FUNCTION Convert_Miss_To_Null
70:
71: -- Function Convert_Miss_To_Null
72:
73: FUNCTION Convert_Miss_To_Null
74: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
75: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
76:
77: -- Procedure Update_Row
78:
71: -- Function Convert_Miss_To_Null
72:
73: FUNCTION Convert_Miss_To_Null
74: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
75: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
76:
77: -- Procedure Update_Row
78:
79: PROCEDURE Update_Row
76:
77: -- Procedure Update_Row
78:
79: PROCEDURE Update_Row
80: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
81: );
82:
83: -- Procedure Insert_Row
84:
82:
83: -- Procedure Insert_Row
84:
85: PROCEDURE Insert_Row
86: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
87: );
88:
89: -- Procedure Delete_Row
90:
97:
98: FUNCTION Query_Row
99: ( p_name IN VARCHAR2
100: , p_price_list_id IN NUMBER
101: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
102:
103: -- Procedure lock_Row
104: --
105:
104: --
105:
106: PROCEDURE Lock_Row
107: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
109: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
110: );
111:
112: -- Function Get_Values
105:
106: PROCEDURE Lock_Row
107: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
109: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
110: );
111:
112: -- Function Get_Values
113:
111:
112: -- Function Get_Values
113:
114: FUNCTION Get_Values
115: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
116: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
117: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
118: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;
119:
112: -- Function Get_Values
113:
114: FUNCTION Get_Values
115: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
116: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
117: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
118: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;
119:
120: -- Function Get_Ids
113:
114: FUNCTION Get_Values
115: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
116: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
117: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
118: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;
119:
120: -- Function Get_Ids
121:
114: FUNCTION Get_Values
115: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
116: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
117: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
118: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;
119:
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
119:
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
123: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
124: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
125: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
126:
127: -- Function Get_Ids
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
123: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
124: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
125: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
126:
127: -- Function Get_Ids
128:
121:
122: FUNCTION Get_Ids
123: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
124: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
125: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
126:
127: -- Function Get_Ids
128:
129: END OE_Price_List_Util;