APPS.QP_LIMIT_ATTRS_UTIL dependencies on QP_LIMITS_PUB

Line 45: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

41: -- Procedure Clear_Dependent_Attr
42:
43: PROCEDURE Clear_Dependent_Attr
44: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
46: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
47: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
48: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
49: );

Line 46: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

42:
43: PROCEDURE Clear_Dependent_Attr
44: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
46: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
47: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
48: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
49: );
50:

Line 47: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

43: PROCEDURE Clear_Dependent_Attr
44: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
46: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
47: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
48: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
49: );
50:
51: -- Procedure Apply_Attribute_Changes

Line 48: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type

44: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
46: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
47: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
48: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
49: );
50:
51: -- Procedure Apply_Attribute_Changes
52:

Line 54: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

50:
51: -- Procedure Apply_Attribute_Changes
52:
53: PROCEDURE Apply_Attribute_Changes
54: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
55: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
56: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
57: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
58: );

Line 55: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

51: -- Procedure Apply_Attribute_Changes
52:
53: PROCEDURE Apply_Attribute_Changes
54: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
55: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
56: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
57: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
58: );
59:

Line 56: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

52:
53: PROCEDURE Apply_Attribute_Changes
54: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
55: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
56: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
57: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
58: );
59:
60: -- Function Complete_Record

Line 57: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type

53: PROCEDURE Apply_Attribute_Changes
54: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
55: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
56: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
57: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
58: );
59:
60: -- Function Complete_Record
61:

Line 63: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

59:
60: -- Function Complete_Record
61:
62: FUNCTION Complete_Record
63: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
64: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
65: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
66:
67: -- Function Convert_Miss_To_Null

Line 64: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

60: -- Function Complete_Record
61:
62: FUNCTION Complete_Record
63: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
64: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
65: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
66:
67: -- Function Convert_Miss_To_Null
68:

Line 65: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;

61:
62: FUNCTION Complete_Record
63: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
64: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
65: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
66:
67: -- Function Convert_Miss_To_Null
68:
69: FUNCTION Convert_Miss_To_Null

Line 70: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

66:
67: -- Function Convert_Miss_To_Null
68:
69: FUNCTION Convert_Miss_To_Null
70: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
71: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
72:
73: -- Procedure Update_Row
74:

Line 71: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;

67: -- Function Convert_Miss_To_Null
68:
69: FUNCTION Convert_Miss_To_Null
70: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
71: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
72:
73: -- Procedure Update_Row
74:
75: PROCEDURE Update_Row

Line 76: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

72:
73: -- Procedure Update_Row
74:
75: PROCEDURE Update_Row
76: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
77: );
78:
79: -- Procedure Insert_Row
80:

Line 82: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

78:
79: -- Procedure Insert_Row
80:
81: PROCEDURE Insert_Row
82: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
83: );
84:
85: -- Procedure Delete_Row
86:

Line 95: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;

91: -- Function Query_Row
92:
93: FUNCTION Query_Row
94: ( p_limit_attribute_id IN NUMBER
95: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
96:
97: -- Function Query_Rows
98:
99: --

Line 106: ) RETURN QP_Limits_PUB.Limit_Attrs_Tbl_Type;

102: ( p_limit_attribute_id IN NUMBER :=
103: FND_API.G_MISS_NUM
104: , p_limit_id IN NUMBER :=
105: FND_API.G_MISS_NUM
106: ) RETURN QP_Limits_PUB.Limit_Attrs_Tbl_Type;
107:
108: -- Procedure lock_Row
109: --
110:

Line 113: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

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

Line 114: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type

110:
111: PROCEDURE Lock_Row
112: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
114: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
115: );
116:
117: -- Function Get_Values
118:

Line 120: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

116:
117: -- Function Get_Values
118:
119: FUNCTION Get_Values
120: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
121: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
122: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
123: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
124:

Line 121: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

117: -- Function Get_Values
118:
119: FUNCTION Get_Values
120: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
121: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
122: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
123: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
124:
125: -- Function Get_Ids

Line 122: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

118:
119: FUNCTION Get_Values
120: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
121: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
122: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
123: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
124:
125: -- Function Get_Ids
126:

Line 123: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;

119: FUNCTION Get_Values
120: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
121: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
122: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
123: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
124:
125: -- Function Get_Ids
126:
127: FUNCTION Get_Ids

Line 128: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

124:
125: -- Function Get_Ids
126:
127: FUNCTION Get_Ids
128: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
129: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
130: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
131:
132: Procedure Pre_Write_Process

Line 129: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type

125: -- Function Get_Ids
126:
127: FUNCTION Get_Ids
128: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
129: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
130: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
131:
132: Procedure Pre_Write_Process
133: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

Line 130: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;

126:
127: FUNCTION Get_Ids
128: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
129: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
130: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
131:
132: Procedure Pre_Write_Process
133: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
134: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

Line 133: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

129: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
130: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
131:
132: Procedure Pre_Write_Process
133: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
134: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
135: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
136: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
137: );

Line 134: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

130: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
131:
132: Procedure Pre_Write_Process
133: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
134: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
135: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
136: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
137: );
138:

Line 135: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

131:
132: Procedure Pre_Write_Process
133: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
134: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
135: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
136: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
137: );
138:
139: END QP_Limit_Attrs_Util;

Line 136: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type

132: Procedure Pre_Write_Process
133: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
134: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
135: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
136: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
137: );
138:
139: END QP_Limit_Attrs_Util;