DBA Data[Home] [Help]

APPS.QP_LIMITS_UTIL dependencies on QP_LIMITS_PUB

Line 55: , p_LIMITS_rec IN QP_Limits_PUB.Limits_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_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
56: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
57: QP_Limits_PUB.G_MISS_LIMITS_REC
58: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
59: );

Line 56: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

52:
53: PROCEDURE Clear_Dependent_Attr
54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
56: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
57: QP_Limits_PUB.G_MISS_LIMITS_REC
58: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
59: );
60:

Line 57: QP_Limits_PUB.G_MISS_LIMITS_REC

53: PROCEDURE Clear_Dependent_Attr
54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
56: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
57: QP_Limits_PUB.G_MISS_LIMITS_REC
58: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
59: );
60:
61: -- Procedure Apply_Attribute_Changes

Line 58: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

54: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
55: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
56: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
57: QP_Limits_PUB.G_MISS_LIMITS_REC
58: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
59: );
60:
61: -- Procedure Apply_Attribute_Changes
62:

Line 64: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

60:
61: -- Procedure Apply_Attribute_Changes
62:
63: PROCEDURE Apply_Attribute_Changes
64: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
65: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
66: QP_Limits_PUB.G_MISS_LIMITS_REC
67: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68: );

Line 65: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

61: -- Procedure Apply_Attribute_Changes
62:
63: PROCEDURE Apply_Attribute_Changes
64: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
65: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
66: QP_Limits_PUB.G_MISS_LIMITS_REC
67: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68: );
69:

Line 66: QP_Limits_PUB.G_MISS_LIMITS_REC

62:
63: PROCEDURE Apply_Attribute_Changes
64: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
65: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
66: QP_Limits_PUB.G_MISS_LIMITS_REC
67: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68: );
69:
70: -- Function Complete_Record

Line 67: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

63: PROCEDURE Apply_Attribute_Changes
64: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
65: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
66: QP_Limits_PUB.G_MISS_LIMITS_REC
67: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68: );
69:
70: -- Function Complete_Record
71:

Line 73: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

69:
70: -- Function Complete_Record
71:
72: FUNCTION Complete_Record
73: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
74: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
75: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null

Line 74: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

70: -- Function Complete_Record
71:
72: FUNCTION Complete_Record
73: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
74: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
75: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null
78:

Line 75: ) RETURN QP_Limits_PUB.Limits_Rec_Type;

71:
72: FUNCTION Complete_Record
73: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
74: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
75: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null

Line 80: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

76:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
80: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
81: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
82:
83: -- Procedure Update_Row
84:

Line 81: ) RETURN QP_Limits_PUB.Limits_Rec_Type;

77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
80: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
81: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
82:
83: -- Procedure Update_Row
84:
85: PROCEDURE Update_Row

Line 86: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

82:
83: -- Procedure Update_Row
84:
85: PROCEDURE Update_Row
86: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
87: );
88:
89: -- Procedure Insert_Row
90:

Line 92: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

88:
89: -- Procedure Insert_Row
90:
91: PROCEDURE Insert_Row
92: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
93: );
94:
95: -- Procedure Delete_Row
96:

Line 105: ) RETURN QP_Limits_PUB.Limits_Rec_Type;

101: -- Function Query_Row
102:
103: FUNCTION Query_Row
104: ( p_limit_id IN NUMBER
105: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
106:
107: -- Procedure lock_Row
108: --
109:

Line 112: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

108: --
109:
110: PROCEDURE Lock_Row
111: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
113: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
114: );
115:
116: -- Function Get_Values

Line 113: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

109:
110: PROCEDURE Lock_Row
111: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
113: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
114: );
115:
116: -- Function Get_Values
117:

Line 119: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

115:
116: -- Function Get_Values
117:
118: FUNCTION Get_Values
119: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
120: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
121: QP_Limits_PUB.G_MISS_LIMITS_REC
122: ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;
123:

Line 120: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

116: -- Function Get_Values
117:
118: FUNCTION Get_Values
119: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
120: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
121: QP_Limits_PUB.G_MISS_LIMITS_REC
122: ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;
123:
124: -- Function Get_Ids

Line 121: QP_Limits_PUB.G_MISS_LIMITS_REC

117:
118: FUNCTION Get_Values
119: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
120: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
121: QP_Limits_PUB.G_MISS_LIMITS_REC
122: ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;
123:
124: -- Function Get_Ids
125:

Line 122: ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;

118: FUNCTION Get_Values
119: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
120: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
121: QP_Limits_PUB.G_MISS_LIMITS_REC
122: ) RETURN QP_Limits_PUB.Limits_Val_Rec_Type;
123:
124: -- Function Get_Ids
125:
126: FUNCTION Get_Ids

Line 127: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

123:
124: -- Function Get_Ids
125:
126: FUNCTION Get_Ids
127: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
128: , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type
129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process

Line 128: , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type

124: -- Function Get_Ids
125:
126: FUNCTION Get_Ids
127: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
128: , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type
129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

Line 129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;

125:
126: FUNCTION Get_Ids
127: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
128: , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type
129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

Line 132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

128: , p_LIMITS_val_rec IN QP_Limits_PUB.Limits_Val_Rec_Type
129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
134: QP_Limits_PUB.G_MISS_LIMITS_REC
135: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
136: );

Line 133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

129: ) RETURN QP_Limits_PUB.Limits_Rec_Type;
130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
134: QP_Limits_PUB.G_MISS_LIMITS_REC
135: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
136: );
137:

Line 134: QP_Limits_PUB.G_MISS_LIMITS_REC

130:
131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
134: QP_Limits_PUB.G_MISS_LIMITS_REC
135: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
136: );
137:
138:

Line 135: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

131: Procedure Pre_Write_Process
132: ( p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
133: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
134: QP_Limits_PUB.G_MISS_LIMITS_REC
135: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
136: );
137:
138:
139: END QP_Limits_Util;