APPS.QP_VALIDATE_QUALIFIERS dependencies on QP_QUALIFIERS

Line 28: FROM qp_qualifiers

24: THEN
25: SELECT 1 INTO l_count
26: FROM DUAL
27: WHERE EXISTS( SELECT qualifier_id
28: FROM qp_qualifiers
29: WHERE qualifier_rule_id = p_QUALIFIERS_rec.qualifier_rule_id
30: AND qualifier_grouping_no = p_QUALIFIERS_rec.qualifier_grouping_no
31: AND qualifier_context = p_QUALIFIERS_rec.qualifier_context
32: AND qualifier_attribute = p_QUALIFIERS_rec.qualifier_attribute

Line 42: FROM qp_qualifiers

38: ELSE
39: SELECT 1 INTO l_count
40: FROM DUAL
41: WHERE EXISTS ( SELECT qualifier_id
42: FROM qp_qualifiers
43: WHERE list_header_id = p_QUALIFIERS_rec.list_header_id
44: AND qualifier_grouping_no = p_QUALIFIERS_rec.qualifier_grouping_no
45: AND qualifier_context = p_QUALIFIERS_rec.qualifier_context
46: AND qualifier_attribute = p_QUALIFIERS_rec.qualifier_attribute

Line 87: FROM QP_QUALIFIERS

83: p_start_date date,
84: p_qualifier_rule_id number,
85: p_qualifier_id number) is
86: SELECT 'CHANGED'
87: FROM QP_QUALIFIERS
88: WHERE qualifier_rule_id = p_qualifier_rule_id
89: AND qualifier_grouping_no = p_qualifier_grouping_no
90: AND start_date_active <> p_start_date
91: AND qualifier_id <> p_qualifier_id;

Line 127: FROM QP_QUALIFIERS

123: p_end_date date,
124: p_qualifier_rule_id number,
125: p_qualifier_id number ) is
126: SELECT 'CHANGED'
127: FROM QP_QUALIFIERS
128: WHERE qualifier_rule_id = p_qualifier_rule_id
129: AND qualifier_grouping_no = p_qualifier_grouping_no
130: AND end_date_active <> p_end_date
131: AND qualifier_id <> p_qualifier_id;

Line 658: FROM QP_QUALIFIERS

654:
655:
656: /* SELECT qualifier_id
657: INTO l_qualifier_id
658: FROM QP_QUALIFIERS
659: WHERE qualifier_id = p_QUALIFIERS_rec.qualifier_id;
660:
661: If SQL%NOTFOUND
662: Then

Line 1902: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIERS' ) THEN

1898:
1899: -- Validate descriptive flexfield.
1900:
1901: --dbms_output.put_line('validating flex ');
1902: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIERS' ) THEN
1903: x_return_status := FND_API.G_RET_STS_ERROR;
1904: END IF;
1905: --dbms_output.put_line('status is '||x_return_status);
1906: