eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_QUALIFIERS

Line 17: from qp_qualifiers a , qp_qualifiers b

13: l_status VARCHAR2(20);
14: DUPLICATE_DISCOUNT EXCEPTION;
15: Cursor C_Qualifiers(p_qualifier_rule_id number) IS
16: Select 'DUPLICATE'
17: from qp_qualifiers a , qp_qualifiers b
18: where a.qualifier_rule_id = b.qualifier_rule_id
19: and a.qualifier_rule_id = p_qualifier_rule_id
20: and a.qualifier_grouping_no = b.qualifier_grouping_no
21: and a.qualifier_context = b.qualifier_context

Line 132: UPDATE qp_qualifiers

128: IS
129: BEGIN
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: UPDATE qp_qualifiers
133: SET active_flag = p_active_flag
134: WHERE list_header_id = p_list_header_id;
135:
136: IF p_active_flag = 'Y'

Line 142: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c

138: update qp_pte_segments set used_in_setup='Y'
139: where nvl(used_in_setup,'N')='N'
140: and segment_id in
141: (select a.segment_id
142: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c
143: where c.list_header_id = p_list_header_id
144: and a.segment_mapping_column = c.qualifier_attribute
145: and a.prc_context_id = b.prc_context_id
146: and b.prc_context_type = 'QUALIFIER'

Line 1030: FROM qp_qualifiers a

1026:
1027: CURSOR count_cur(a_qualifier_rule_id NUMBER, a_pte_code VARCHAR2)
1028: IS
1029: SELECT a.qualifier_grouping_no
1030: FROM qp_qualifiers a
1031: WHERE a.qualifier_rule_id = a_qualifier_rule_id
1032: AND EXISTS (SELECT 'x'
1033: FROM qp_qualifiers b, qp_prc_contexts_b d,
1034: qp_segments_b e, qp_pte_segments f

Line 1033: FROM qp_qualifiers b, qp_prc_contexts_b d,

1029: SELECT a.qualifier_grouping_no
1030: FROM qp_qualifiers a
1031: WHERE a.qualifier_rule_id = a_qualifier_rule_id
1032: AND EXISTS (SELECT 'x'
1033: FROM qp_qualifiers b, qp_prc_contexts_b d,
1034: qp_segments_b e, qp_pte_segments f
1035: WHERE b.qualifier_context = d.prc_context_code
1036: AND b.qualifier_attribute = e.segment_mapping_column
1037: AND d.prc_context_id = e.prc_context_id

Line 1046: FROM qp_qualifiers c, qp_prc_contexts_b d1,

1042: AND (b.qualifier_grouping_no = a.qualifier_grouping_no or
1043: b.qualifier_grouping_no = -1))
1044:
1045: AND EXISTS (SELECT 'x'
1046: FROM qp_qualifiers c, qp_prc_contexts_b d1,
1047: qp_segments_b e1, qp_pte_segments f1
1048: WHERE c.qualifier_context = d1.prc_context_code
1049: AND c.qualifier_attribute = e1.segment_mapping_column
1050: AND d1.prc_context_id = e1.prc_context_id

Line 1126: QP_QUALIFIERS qpq

1122:
1123: Cursor C_modifier(p_list_header_id number) IS
1124: SELECT count(1)
1125: FROM QP_LIST_HEADERS qplh ,
1126: QP_QUALIFIERS qpq
1127: WHERE qplh.list_header_id = p_list_header_id
1128: AND qplh.list_header_id = qpq.list_header_id
1129: AND qpq.qualifier_context = 'MODLIST'
1130: AND qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4';

Line 1334: from qp_qualifiers

1330:
1331: Begin
1332: select 1 into l_dummy from dual where
1333: exists ( Select 'Y'
1334: from qp_qualifiers
1335: where list_header_id = p_list_header_id
1336: and NOT (qualifier_context = 'MODLIST' AND
1337: qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'));
1338: Exception

Line 1358: from qp_qualifiers q

1354: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1355: where qpl.list_header_id=p_list_header_id
1356: and exists (
1357: select 'X'
1358: from qp_qualifiers q
1359: where q.list_header_id=qpl.list_header_id
1360: and q.list_line_id = -1);
1361:
1362: -- Line level qualifiers

Line 1368: from qp_qualifiers q

1364: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 8
1365: where qpl.list_header_id=p_list_header_id
1366: and exists (
1367: select 'X'
1368: from qp_qualifiers q
1369: where q.list_header_id=qpl.list_header_id
1370: and q.list_line_id=qpl.list_line_id);
1371:
1372: END IF; --If list_type_code is 'PRL or 'AGR'

Line 1613: from qp_qualifiers

1609:
1610: Begin
1611: select 1 into l_dummy from dual where
1612: exists ( Select 'Y'
1613: from qp_qualifiers
1614: where list_header_id = l_list_header_id
1615: and NOT (qualifier_context = 'MODLIST' AND
1616: qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'));
1617: Exception

Line 1638: from qp_qualifiers q

1634: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1635: where qpl.list_line_id=p_list_line_id
1636: and exists (
1637: select 'X'
1638: from qp_qualifiers q
1639: where q.list_header_id=qpl.list_header_id
1640: and q.list_line_id = -1)
1641: returning qpl.qualification_ind into l_qualification_ind;
1642:

Line 1649: from qp_qualifiers q

1645: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 8
1646: where qpl.list_line_id=p_list_line_id
1647: and exists (
1648: select 'X'
1649: from qp_qualifiers q
1650: where q.list_header_id=qpl.list_header_id
1651: and q.list_line_id=p_list_line_id)
1652: returning qpl.qualification_ind into l_qualification_ind;
1653:

Line 2212: from qp_qualifiers

2208: )
2209: is
2210: cursor c_qualifiers is
2211: select qualifier_context, qualifier_attribute
2212: from qp_qualifiers
2213: where list_header_id = p_list_header_id
2214: and ((qualifier_grouping_no = p_qualifier_grouping_no) OR (qualifier_grouping_no = -1))
2215: and list_line_id = p_list_line_id;
2216:

Line 2352: from qp_qualifiers

2348: where list_header_id = p_list_header_id;
2349:
2350: cursor c_qual_grp_no is
2351: select distinct qualifier_grouping_no qualifier_grouping_no
2352: from qp_qualifiers
2353: where list_header_id = p_list_header_id
2354: and list_line_id = p_list_line_id
2355: and qualifier_grouping_no <> -1;
2356:

Line 2476: --QP: Maintain denormalised data in qp_qualifiers also in which

2472:
2473: oe_debug_pub.add('process update_changed_lines_add');
2474:
2475: --please note that this is being done from concurrent program
2476: --QP: Maintain denormalised data in qp_qualifiers also in which
2477: --case the procedure update_changed_lines_product in QPXDENOB.pls
2478: --is called. Any changes made to this routine needs to be
2479: --communicated to DENOB as well.
2480: --also this same operation is done in 3 other procedures in this

Line 2524: --QP: Maintain denormalised data in qp_qualifiers also in which

2520:
2521: oe_debug_pub.add('process update_changed_lines_del');
2522:
2523: --please note that this is being done from concurrent program
2524: --QP: Maintain denormalised data in qp_qualifiers also in which
2525: --case the procedure update_changed_lines_product in QPXDENOB.pls
2526: --is called. Any changes made to this routine needs to be
2527: --communicated to DENOB as well.
2528: --also this same operation is done in 3 other procedures in this

Line 2595: --QP: Maintain denormalised data in qp_qualifiers also in which

2591:
2592: oe_debug_pub.add('process update_changed_lines_ph');
2593:
2594: --please note that this is being done from concurrent program
2595: --QP: Maintain denormalised data in qp_qualifiers also in which
2596: --case the procedure update_changed_lines_product in QPXDENOB.pls
2597: --is called. Any changes made to this routine needs to be
2598: --communicated to DENOB as well.
2599: --also this same operation is done in 3 other procedures in this

Line 2709: --QP: Maintain denormalised data in qp_qualifiers also in which

2705: begin
2706:
2707: oe_debug_pub.add('process update_changed_lines_act');
2708: --please note that this is being done from concurrent program
2709: --QP: Maintain denormalised data in qp_qualifiers also in which
2710: --case the procedure update_changed_lines_product in QPXDENOB.pls
2711: --is called. Any changes made to this routine needs to be
2712: --communicated to DENOB as well.
2713: --also this same operation is done in 3 other procedures in this