eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PRICE_LIST_LINE_UTIL dependencies on OE_PRICE_LIST_PUB

Line 70: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

66: -- Procedure Clear_Dependent_Attr
67:
68: PROCEDURE Clear_Dependent_Attr
69: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
70: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
71: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
72: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
73: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
74: );

Line 71: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=

67:
68: PROCEDURE Clear_Dependent_Attr
69: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
70: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
71: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
72: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
73: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
74: );
75:

Line 72: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

68: PROCEDURE Clear_Dependent_Attr
69: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
70: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
71: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
72: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
73: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
74: );
75:
76: -- Procedure Apply_Attribute_Changes

Line 73: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type

69: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
70: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
71: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
72: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
73: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
74: );
75:
76: -- Procedure Apply_Attribute_Changes
77:

Line 79: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

75:
76: -- Procedure Apply_Attribute_Changes
77:
78: PROCEDURE Apply_Attribute_Changes
79: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
80: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
81: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
82: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
83: );

Line 80: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=

76: -- Procedure Apply_Attribute_Changes
77:
78: PROCEDURE Apply_Attribute_Changes
79: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
80: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
81: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
82: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
83: );
84:

Line 81: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

77:
78: PROCEDURE Apply_Attribute_Changes
79: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
80: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
81: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
82: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
83: );
84:
85: -- Function Complete_Record

Line 82: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type

78: PROCEDURE Apply_Attribute_Changes
79: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
80: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
81: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
82: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
83: );
84:
85: -- Function Complete_Record
86:

Line 88: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

84:
85: -- Function Complete_Record
86:
87: FUNCTION Complete_Record
88: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
89: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
90: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
91:
92: -- Function Convert_Miss_To_Null

Line 89: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

85: -- Function Complete_Record
86:
87: FUNCTION Complete_Record
88: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
89: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
90: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
91:
92: -- Function Convert_Miss_To_Null
93:

Line 90: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;

86:
87: FUNCTION Complete_Record
88: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
89: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
90: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
91:
92: -- Function Convert_Miss_To_Null
93:
94: FUNCTION Convert_Miss_To_Null

Line 95: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

91:
92: -- Function Convert_Miss_To_Null
93:
94: FUNCTION Convert_Miss_To_Null
95: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
96: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
97:
98: -- Procedure Update_Row
99:

Line 96: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;

92: -- Function Convert_Miss_To_Null
93:
94: FUNCTION Convert_Miss_To_Null
95: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
96: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
97:
98: -- Procedure Update_Row
99:
100: PROCEDURE Update_Row

Line 101: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

97:
98: -- Procedure Update_Row
99:
100: PROCEDURE Update_Row
101: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
102: );
103:
104: -- Procedure Insert_Row
105:

Line 107: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

103:
104: -- Procedure Insert_Row
105:
106: PROCEDURE Insert_Row
107: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
108: );
109:
110: -- Procedure Delete_Row
111:

Line 121: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;

117:
118: FUNCTION Query_Row
119: ( p_price_list_Line_id IN NUMBER
120: , p_price_list_id IN NUMBER
121: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
122:
123: -- Function Query_Rows
124:
125: --

Line 132: ) RETURN OE_Price_List_PUB.Price_List_Line_Tbl_Type;

128: ( p_price_list_line_id IN NUMBER :=
129: FND_API.G_MISS_NUM
130: , p_price_list_id IN NUMBER :=
131: FND_API.G_MISS_NUM
132: ) RETURN OE_Price_List_PUB.Price_List_Line_Tbl_Type;
133:
134:
135: PROCEDURE Lock_Row
136: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 137: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

133:
134:
135: PROCEDURE Lock_Row
136: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
138: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
139: );
140:
141: -- Function Get_Values

Line 138: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type

134:
135: PROCEDURE Lock_Row
136: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
138: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
139: );
140:
141: -- Function Get_Values
142:

Line 144: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

140:
141: -- Function Get_Values
142:
143: FUNCTION Get_Values
144: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
145: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
146: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
147: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
148:

Line 145: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=

141: -- Function Get_Values
142:
143: FUNCTION Get_Values
144: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
145: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
146: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
147: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
148:
149: -- Function Get_Ids

Line 146: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

142:
143: FUNCTION Get_Values
144: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
145: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
146: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
147: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
148:
149: -- Function Get_Ids
150:

Line 147: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;

143: FUNCTION Get_Values
144: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
145: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
146: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
147: ) RETURN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type;
148:
149: -- Function Get_Ids
150:
151: FUNCTION Get_Ids

Line 152: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type

148:
149: -- Function Get_Ids
150:
151: FUNCTION Get_Ids
152: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
153: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
154: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
155:
156: PROCEDURE maintain_pricing_attributes

Line 153: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type

149: -- Function Get_Ids
150:
151: FUNCTION Get_Ids
152: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
153: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
154: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
155:
156: PROCEDURE maintain_pricing_attributes
157: ( p_PRICE_LIST_LINE_rec in OE_PRICE_LIST_PUB.Price_List_Line_Rec_Type,

Line 154: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;

150:
151: FUNCTION Get_Ids
152: ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
153: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
154: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
155:
156: PROCEDURE maintain_pricing_attributes
157: ( p_PRICE_LIST_LINE_rec in OE_PRICE_LIST_PUB.Price_List_Line_Rec_Type,
158: operation in varchar2,

Line 157: ( p_PRICE_LIST_LINE_rec in OE_PRICE_LIST_PUB.Price_List_Line_Rec_Type,

153: , p_PRICE_LIST_LINE_val_rec IN OE_Price_List_PUB.Price_List_Line_Val_Rec_Type
154: ) RETURN OE_Price_List_PUB.Price_List_Line_Rec_Type;
155:
156: PROCEDURE maintain_pricing_attributes
157: ( p_PRICE_LIST_LINE_rec in OE_PRICE_LIST_PUB.Price_List_Line_Rec_Type,
158: operation in varchar2,
159: x_return_status out NOCOPY /* file.sql.39 change */ varchar2);
160:
161: PROCEDURE lock_pricing_attributes( p_list_line_id in number,

Line 169: ) RETURN OE_Price_List_PUB.Pricing_Attr_Tbl_Type;

165: ( p_pricing_attribute_id IN NUMBER :=
166: FND_API.G_MISS_NUM
167: , p_list_line_id IN NUMBER :=
168: FND_API.G_MISS_NUM
169: ) RETURN OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
170:
171:
172: END OE_Price_List_Line_Util;