DBA Data[Home] [Help]

APPS.QP_LIMIT_BALANCES_UTIL dependencies on QP_LIMITS_PUB

Line 56: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_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_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
57: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
58: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
59: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
60: );

Line 57: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=

53:
54: PROCEDURE Clear_Dependent_Attr
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
57: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
58: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
59: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
60: );
61:

Line 58: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC

54: PROCEDURE Clear_Dependent_Attr
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
57: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
58: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
59: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
60: );
61:
62: -- Procedure Apply_Attribute_Changes

Line 59: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type

55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
57: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
58: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
59: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
60: );
61:
62: -- Procedure Apply_Attribute_Changes
63:

Line 65: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

61:
62: -- Procedure Apply_Attribute_Changes
63:
64: PROCEDURE Apply_Attribute_Changes
65: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
66: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
67: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
68: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
69: );

Line 66: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=

62: -- Procedure Apply_Attribute_Changes
63:
64: PROCEDURE Apply_Attribute_Changes
65: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
66: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
67: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
68: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
69: );
70:

Line 67: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC

63:
64: PROCEDURE Apply_Attribute_Changes
65: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
66: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
67: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
68: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
69: );
70:
71: -- Function Complete_Record

Line 68: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type

64: PROCEDURE Apply_Attribute_Changes
65: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
66: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
67: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
68: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
69: );
70:
71: -- Function Complete_Record
72:

Line 74: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

70:
71: -- Function Complete_Record
72:
73: FUNCTION Complete_Record
74: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
75: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
76: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
77:
78: -- Function Convert_Miss_To_Null

Line 75: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

71: -- Function Complete_Record
72:
73: FUNCTION Complete_Record
74: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
75: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
76: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
77:
78: -- Function Convert_Miss_To_Null
79:

Line 76: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;

72:
73: FUNCTION Complete_Record
74: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
75: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
76: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
77:
78: -- Function Convert_Miss_To_Null
79:
80: FUNCTION Convert_Miss_To_Null

Line 81: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

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

Line 82: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;

78: -- Function Convert_Miss_To_Null
79:
80: FUNCTION Convert_Miss_To_Null
81: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
82: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
83:
84: -- Procedure Update_Row
85:
86: PROCEDURE Update_Row

Line 87: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

83:
84: -- Procedure Update_Row
85:
86: PROCEDURE Update_Row
87: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
88: );
89:
90: -- Procedure Insert_Row
91:

Line 93: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

89:
90: -- Procedure Insert_Row
91:
92: PROCEDURE Insert_Row
93: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
94: );
95:
96: -- Procedure Delete_Row
97:

Line 106: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;

102: -- Function Query_Row
103:
104: FUNCTION Query_Row
105: ( p_limit_balance_id IN NUMBER
106: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
107:
108: -- Function Query_Rows
109:
110: --

Line 117: ) RETURN QP_Limits_PUB.Limit_Balances_Tbl_Type;

113: ( p_limit_balance_id IN NUMBER :=
114: FND_API.G_MISS_NUM
115: , p_limit_id IN NUMBER :=
116: FND_API.G_MISS_NUM
117: ) RETURN QP_Limits_PUB.Limit_Balances_Tbl_Type;
118:
119: -- Procedure lock_Row
120: --
121:

Line 124: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

120: --
121:
122: PROCEDURE Lock_Row
123: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
125: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
126: );
127:
128: -- Function Get_Values

Line 125: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type

121:
122: PROCEDURE Lock_Row
123: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
125: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
126: );
127:
128: -- Function Get_Values
129:

Line 131: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

127:
128: -- Function Get_Values
129:
130: FUNCTION Get_Values
131: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
132: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
133: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
134: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
135:

Line 132: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=

128: -- Function Get_Values
129:
130: FUNCTION Get_Values
131: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
132: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
133: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
134: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
135:
136: -- Function Get_Ids

Line 133: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC

129:
130: FUNCTION Get_Values
131: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
132: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
133: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
134: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
135:
136: -- Function Get_Ids
137:

Line 134: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type;

130: FUNCTION Get_Values
131: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
132: , p_old_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type :=
133: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC
134: ) RETURN QP_Limits_PUB.Limit_Balances_Val_Rec_Type;
135:
136: -- Function Get_Ids
137:
138: FUNCTION Get_Ids

Line 139: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type

135:
136: -- Function Get_Ids
137:
138: FUNCTION Get_Ids
139: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
140: , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
141: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
142:
143: END QP_Limit_Balances_Util;

Line 140: , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type

136: -- Function Get_Ids
137:
138: FUNCTION Get_Ids
139: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
140: , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
141: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
142:
143: END QP_Limit_Balances_Util;

Line 141: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;

137:
138: FUNCTION Get_Ids
139: ( p_LIMIT_BALANCES_rec IN QP_Limits_PUB.Limit_Balances_Rec_Type
140: , p_LIMIT_BALANCES_val_rec IN QP_Limits_PUB.Limit_Balances_Val_Rec_Type
141: ) RETURN QP_Limits_PUB.Limit_Balances_Rec_Type;
142:
143: END QP_Limit_Balances_Util;