APPS.QP_VALIDATE_QUALIFIER_RULES dependencies on QP_QUALIFIER_RULES

Line 14: FROM QP_QUALIFIER_RULES

10: p_qualifier_rule_id IN NUMBER)RETURN BOOLEAN IS
11: CURSOR c_QualifierName(p_name Varchar2,
12: p_qualifier_rule_id NUMBER ) is
13: SELECT 'DUPLICATE'
14: FROM QP_QUALIFIER_RULES
15: WHERE upper(name) = upper(p_name)
16: AND qualifier_rule_id <> p_qualifier_rule_id;
17:
18: l_status VARCHAR2(20);

Line 42: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

38: -- Procedure Entity
39:
40: PROCEDURE Entity
41: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
43: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
44: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
45: )
46: IS

Line 43: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=

39:
40: PROCEDURE Entity
41: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
43: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
44: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
45: )
46: IS
47: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 44: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC

40: PROCEDURE Entity
41: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
43: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
44: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
45: )
46: IS
47: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
48:

Line 176: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

172: -- Procedure Attributes
173:
174: PROCEDURE Attributes
175: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
177: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
178: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
179: )
180: IS

Line 177: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=

173:
174: PROCEDURE Attributes
175: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
177: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
178: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
179: )
180: IS
181: BEGIN

Line 178: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC

174: PROCEDURE Attributes
175: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
177: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
178: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
179: )
180: IS
181: BEGIN
182:

Line 525: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIER_RULES' ) THEN

521: --dbms_output.put_line('validating flex fields');
522:
523:
524:
525: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIER_RULES' ) THEN
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: END IF;
528:
529:

Line 565: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

561: -- Procedure Entity_Delete
562:
563: PROCEDURE Entity_Delete
564: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
565: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
566: )
567: IS
568: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
569: BEGIN