DBA Data[Home] [Help]

APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on QP_PRICE_LIST_PUB

Line 56: , p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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: );

Line 57: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=

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:

Line 58: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC

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

Line 59: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type

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:

Line 65: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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: );

Line 66: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=

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:

Line 67: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC

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

Line 68: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type

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:

Line 74: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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

Line 75: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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:

Line 76: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;

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

Line 81: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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:

Line 82: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;

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

Line 87: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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:

Line 93: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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:

Line 106: ) RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;

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: --

Line 117: ) RETURN QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

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:

Line 124: , p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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

Line 125: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type

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:

Line 131: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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:

Line 132: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=

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

Line 133: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC

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:

Line 134: ) RETURN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;

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

Line 139: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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

Line 140: , p_PRICING_ATTR_val_rec IN QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type

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

Line 141: ) RETURN 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 :=

Line 144: ( 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 :=
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: );

Line 145: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_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: );
149:

Line 146: QP_Price_List_PUB.G_MISS_Pricing_Attr_REC

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;

Line 147: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Rec_Type

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;