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;
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;
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;
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;
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
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;
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;
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);
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);
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
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
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:
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;
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;
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;
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