DBA Data[Home] [Help]

APPS.QP_PRICING_ATTR_UTIL dependencies on QP_MODIFIERS_PUB

Line 55: , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

51: -- Procedure Clear_Dependent_Attr
52:
53: PROCEDURE Clear_Dependent_Attr
54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
56: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
57: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
58: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
59: );

Line 56: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=

52:
53: PROCEDURE Clear_Dependent_Attr
54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
56: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
57: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
58: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
59: );
60:

Line 57: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC

53: PROCEDURE Clear_Dependent_Attr
54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
56: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
57: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
58: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
59: );
60:
61: -- Procedure Apply_Attribute_Changes

Line 58: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type

54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
56: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
57: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
58: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
59: );
60:
61: -- Procedure Apply_Attribute_Changes
62:

Line 64: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

60:
61: -- Procedure Apply_Attribute_Changes
62:
63: PROCEDURE Apply_Attribute_Changes
64: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
65: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
66: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
67: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
68: );

Line 65: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=

61: -- Procedure Apply_Attribute_Changes
62:
63: PROCEDURE Apply_Attribute_Changes
64: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
65: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
66: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
67: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
68: );
69:

Line 66: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC

62:
63: PROCEDURE Apply_Attribute_Changes
64: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
65: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
66: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
67: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
68: );
69:
70: -- Function Complete_Record

Line 67: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type

63: PROCEDURE Apply_Attribute_Changes
64: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
65: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
66: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
67: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
68: );
69:
70: -- Function Complete_Record
71:

Line 73: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

69:
70: -- Function Complete_Record
71:
72: FUNCTION Complete_Record
73: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
74: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
75: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null

Line 74: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

70: -- Function Complete_Record
71:
72: FUNCTION Complete_Record
73: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
74: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
75: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null
78:

Line 75: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

71:
72: FUNCTION Complete_Record
73: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
74: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
75: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null

Line 80: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

76:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
80: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
81: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
82:
83: -- Procedure Update_Row
84:

Line 81: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
80: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
81: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
82:
83: -- Procedure Update_Row
84:
85: PROCEDURE Update_Row

Line 86: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

82:
83: -- Procedure Update_Row
84:
85: PROCEDURE Update_Row
86: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
87: );
88:
89: -- Procedure Insert_Row
90:

Line 92: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

88:
89: -- Procedure Insert_Row
90:
91: PROCEDURE Insert_Row
92: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
93: );
94:
95: -- Procedure Delete_Row
96:

Line 105: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

101: -- Function Query_Row
102:
103: FUNCTION Query_Row
104: ( p_pricing_attribute_id IN NUMBER
105: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
106:
107: -- Function Query_Rows
108:
109: --

Line 116: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

112: ( p_pricing_attribute_id IN NUMBER :=
113: FND_API.G_MISS_NUM
114: , p_list_line_id IN NUMBER :=
115: FND_API.G_MISS_NUM
116: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
117:
118: -- Procedure lock_Row
119: --
120:

Line 123: , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

119: --
120:
121: PROCEDURE Lock_Row
122: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123: , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
124: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
125: );
126:
127: -- Function Get_Values

Line 124: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type

120:
121: PROCEDURE Lock_Row
122: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123: , p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
124: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
125: );
126:
127: -- Function Get_Values
128:

Line 130: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

126:
127: -- Function Get_Values
128:
129: FUNCTION Get_Values
130: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
131: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
132: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
133: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
134:

Line 131: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=

127: -- Function Get_Values
128:
129: FUNCTION Get_Values
130: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
131: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
132: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
133: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
134:
135: -- Function Get_Ids

Line 132: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC

128:
129: FUNCTION Get_Values
130: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
131: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
132: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
133: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
134:
135: -- Function Get_Ids
136:

Line 133: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;

129: FUNCTION Get_Values
130: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
131: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
132: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC
133: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
134:
135: -- Function Get_Ids
136:
137: FUNCTION Get_Ids

Line 138: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

134:
135: -- Function Get_Ids
136:
137: FUNCTION Get_Ids
138: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
139: , p_PRICING_ATTR_val_rec IN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type
140: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
141:
142: Procedure Pre_Write_Process

Line 139: , p_PRICING_ATTR_val_rec IN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type

135: -- Function Get_Ids
136:
137: FUNCTION Get_Ids
138: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
139: , p_PRICING_ATTR_val_rec IN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type
140: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
141:
142: Procedure Pre_Write_Process
143: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

Line 140: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

136:
137: FUNCTION Get_Ids
138: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
139: , p_PRICING_ATTR_val_rec IN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type
140: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
141:
142: Procedure Pre_Write_Process
143: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
144: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=

Line 143: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

139: , p_PRICING_ATTR_val_rec IN QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type
140: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
141:
142: Procedure Pre_Write_Process
143: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
144: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
145: QP_Modifiers_PUB.G_MISS_Pricing_Attr_REC
146: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
147: );

Line 144: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=

140: ) RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
141:
142: Procedure Pre_Write_Process
143: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
144: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
145: QP_Modifiers_PUB.G_MISS_Pricing_Attr_REC
146: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
147: );
148:

Line 145: QP_Modifiers_PUB.G_MISS_Pricing_Attr_REC

141:
142: Procedure Pre_Write_Process
143: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
144: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
145: QP_Modifiers_PUB.G_MISS_Pricing_Attr_REC
146: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
147: );
148:
149: END QP_Pricing_Attr_Util;

Line 146: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type

142: Procedure Pre_Write_Process
143: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
144: , p_old_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
145: QP_Modifiers_PUB.G_MISS_Pricing_Attr_REC
146: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Rec_Type
147: );
148:
149: END QP_Pricing_Attr_Util;