DBA Data[Home] [Help]

APPS.QP_VALIDATE_LIMITS dependencies on QP_LIMITS_PUB

Line 10: ,p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Limits';
7:
8: PROCEDURE Validate_List_Header_Limits
9: (x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10: ,p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
11: )
12: IS
13: l_list_type_code VARCHAR2(30) := null;
14: l_error_code NUMBER := 0;

Line 133: ,p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

129: -- Procedure Entity
130:
131: PROCEDURE Validate_List_Line_Limits
132: (x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
133: ,p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
134: )
135: IS
136: l_list_line_type_code VARCHAR2(30) := null;
137: l_application_method VARCHAR2(30) := null;

Line 726: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

722:
723:
724: PROCEDURE Entity
725: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
726: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
727: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
728: QP_Limits_PUB.G_MISS_LIMITS_REC
729: )
730: IS

Line 727: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

723:
724: PROCEDURE Entity
725: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
726: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
727: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
728: QP_Limits_PUB.G_MISS_LIMITS_REC
729: )
730: IS
731: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 728: QP_Limits_PUB.G_MISS_LIMITS_REC

724: PROCEDURE Entity
725: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
726: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
727: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
728: QP_Limits_PUB.G_MISS_LIMITS_REC
729: )
730: IS
731: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
732: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

Line 732: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

728: QP_Limits_PUB.G_MISS_LIMITS_REC
729: )
730: IS
731: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
732: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
733: BEGIN
734: l_LIMITS_rec := p_LIMITS_rec;
735: -- Check required attributes.
736:

Line 819: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

815: -- Procedure Attributes
816:
817: PROCEDURE Attributes
818: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
819: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
820: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
821: QP_Limits_PUB.G_MISS_LIMITS_REC
822: )
823: IS

Line 820: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

816:
817: PROCEDURE Attributes
818: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
819: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
820: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
821: QP_Limits_PUB.G_MISS_LIMITS_REC
822: )
823: IS
824: BEGIN

Line 821: QP_Limits_PUB.G_MISS_LIMITS_REC

817: PROCEDURE Attributes
818: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
819: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
820: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
821: QP_Limits_PUB.G_MISS_LIMITS_REC
822: )
823: IS
824: BEGIN
825:

Line 1290: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

1286: -- Procedure Entity_Delete
1287:
1288: PROCEDURE Entity_Delete
1289: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1290: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
1291: )
1292: IS
1293: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1294: l_dummy NUMBER := 0;

Line 1345: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

1341:
1342:
1343: PROCEDURE Entity_Update
1344: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1345: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
1346: )
1347: IS
1348: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1349: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

Line 1349: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

1345: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
1346: )
1347: IS
1348: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1349: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
1350: l_error_code NUMBER := 0;
1351: l_dummy NUMBER := 0;
1352: l_consumed_amount NUMBER := 0;
1353: BEGIN