DBA Data[Home] [Help]

APPS.QP_VALIDATE_LIMIT_ATTRS dependencies on QP_LIMITS_PUB

Line 11: ,p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

7:
8:
9: PROCEDURE Validate_List_Header_Limits
10: (x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11: ,p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
12: ,p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
13: )
14: IS
15: l_list_type_code VARCHAR2(30) := null;

Line 12: ,p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

8:
9: PROCEDURE Validate_List_Header_Limits
10: (x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11: ,p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
12: ,p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
13: )
14: IS
15: l_list_type_code VARCHAR2(30) := null;
16: l_error_code NUMBER := 0;

Line 132: ,p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

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

Line 133: ,p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

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

Line 687: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

683: -- Procedure Entity
684:
685: PROCEDURE Entity
686: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
687: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
688: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
689: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
690: )
691: IS

Line 688: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

684:
685: PROCEDURE Entity
686: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
687: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
688: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
689: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
690: )
691: IS
692: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

Line 689: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

685: PROCEDURE Entity
686: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
687: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
688: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
689: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
690: )
691: IS
692: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
693: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

Line 692: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;

688: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
689: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
690: )
691: IS
692: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
693: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
694: l_flex_field_name VARCHAR2(30);
695: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
696: l_context_error VARCHAR2(1);

Line 693: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

689: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
690: )
691: IS
692: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
693: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
694: l_flex_field_name VARCHAR2(30);
695: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
696: l_context_error VARCHAR2(1);
697: l_attribute_error VARCHAR2(1);

Line 930: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

926: -- Procedure Attributes
927:
928: PROCEDURE Attributes
929: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
930: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
931: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
932: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
933: )
934: IS

Line 931: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

927:
928: PROCEDURE Attributes
929: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
930: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
931: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
932: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
933: )
934: IS
935: BEGIN

Line 932: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

928: PROCEDURE Attributes
929: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
930: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
931: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
932: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
933: )
934: IS
935: BEGIN
936:

Line 1286: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

1282:
1283:
1284: PROCEDURE Entity_Insert
1285: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1286: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1287: )
1288: IS
1289: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1290: l_dummy NUMBER := 0;

Line 1342: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

1338:
1339:
1340: PROCEDURE Entity_Delete
1341: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1342: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1343: )
1344: IS
1345: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1346: l_dummy NUMBER := 0;

Line 1398: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

1394:
1395:
1396: PROCEDURE Entity_Update
1397: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1398: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1399: )
1400: IS
1401: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1402: l_limit_attrs_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

Line 1402: l_limit_attrs_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1398: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1399: )
1400: IS
1401: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1402: l_limit_attrs_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1403: l_error_code NUMBER := 0;
1404: l_dummy NUMBER := 0;
1405: l_consumed_amount NUMBER := 0;
1406: BEGIN