DBA Data[Home] [Help]

APPS.QP_FORMULA_UTIL dependencies on QP_PRICE_FORMULA_PUB

Line 39: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

35: -- Procedure Clear_Dependent_Attr
36:
37: PROCEDURE Clear_Dependent_Attr
38: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
39: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
40: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
41: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
42: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
43: );

Line 40: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=

36:
37: PROCEDURE Clear_Dependent_Attr
38: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
39: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
40: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
41: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
42: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
43: );
44:

Line 41: QP_Price_Formula_PUB.G_MISS_FORMULA_REC

37: PROCEDURE Clear_Dependent_Attr
38: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
39: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
40: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
41: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
42: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
43: );
44:
45: -- Procedure Apply_Attribute_Changes

Line 42: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type

38: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
39: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
40: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
41: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
42: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
43: );
44:
45: -- Procedure Apply_Attribute_Changes
46:

Line 48: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

44:
45: -- Procedure Apply_Attribute_Changes
46:
47: PROCEDURE Apply_Attribute_Changes
48: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
49: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
50: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
51: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
52: );

Line 49: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=

45: -- Procedure Apply_Attribute_Changes
46:
47: PROCEDURE Apply_Attribute_Changes
48: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
49: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
50: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
51: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
52: );
53:

Line 50: QP_Price_Formula_PUB.G_MISS_FORMULA_REC

46:
47: PROCEDURE Apply_Attribute_Changes
48: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
49: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
50: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
51: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
52: );
53:
54: -- Function Complete_Record

Line 51: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type

47: PROCEDURE Apply_Attribute_Changes
48: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
49: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
50: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
51: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
52: );
53:
54: -- Function Complete_Record
55:

Line 57: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

53:
54: -- Function Complete_Record
55:
56: FUNCTION Complete_Record
57: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
58: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
59: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
60:
61: -- Function Convert_Miss_To_Null

Line 58: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

54: -- Function Complete_Record
55:
56: FUNCTION Complete_Record
57: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
58: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
59: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
60:
61: -- Function Convert_Miss_To_Null
62:

Line 59: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;

55:
56: FUNCTION Complete_Record
57: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
58: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
59: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
60:
61: -- Function Convert_Miss_To_Null
62:
63: FUNCTION Convert_Miss_To_Null

Line 64: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

60:
61: -- Function Convert_Miss_To_Null
62:
63: FUNCTION Convert_Miss_To_Null
64: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
65: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
66:
67: -- Procedure Update_Row
68:

Line 65: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;

61: -- Function Convert_Miss_To_Null
62:
63: FUNCTION Convert_Miss_To_Null
64: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
65: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
66:
67: -- Procedure Update_Row
68:
69: PROCEDURE Update_Row

Line 70: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

66:
67: -- Procedure Update_Row
68:
69: PROCEDURE Update_Row
70: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
71: );
72:
73: -- Procedure Insert_Row
74:

Line 76: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

72:
73: -- Procedure Insert_Row
74:
75: PROCEDURE Insert_Row
76: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
77: );
78:
79: -- Procedure Delete_Row
80:

Line 89: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;

85: -- Function Query_Row
86:
87: FUNCTION Query_Row
88: ( p_price_formula_id IN NUMBER
89: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
90:
91: -- Procedure lock_Row
92: --
93:

Line 96: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

92: --
93:
94: PROCEDURE Lock_Row
95: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
97: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
98: );
99:
100: -- Function Get_Values

Line 97: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type

93:
94: PROCEDURE Lock_Row
95: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
97: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
98: );
99:
100: -- Function Get_Values
101:

Line 103: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

99:
100: -- Function Get_Values
101:
102: FUNCTION Get_Values
103: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
104: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
105: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
106: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;
107:

Line 104: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=

100: -- Function Get_Values
101:
102: FUNCTION Get_Values
103: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
104: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
105: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
106: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;
107:
108: -- Function Get_Ids

Line 105: QP_Price_Formula_PUB.G_MISS_FORMULA_REC

101:
102: FUNCTION Get_Values
103: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
104: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
105: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
106: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;
107:
108: -- Function Get_Ids
109:

Line 106: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;

102: FUNCTION Get_Values
103: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
104: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
105: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
106: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;
107:
108: -- Function Get_Ids
109:
110: FUNCTION Get_Ids

Line 111: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type

107:
108: -- Function Get_Ids
109:
110: FUNCTION Get_Ids
111: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
112: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
113: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
114:
115: END QP_Formula_Util;

Line 112: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type

108: -- Function Get_Ids
109:
110: FUNCTION Get_Ids
111: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
112: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
113: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
114:
115: END QP_Formula_Util;

Line 113: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;

109:
110: FUNCTION Get_Ids
111: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
112: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
113: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
114:
115: END QP_Formula_Util;