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 140: UPDATE qp_qualifiers

136: IS
137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: UPDATE qp_qualifiers
141: SET active_flag = p_active_flag
142: WHERE list_header_id = p_list_header_id;
143:
144: IF p_active_flag = 'Y'

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

146: update qp_pte_segments set used_in_setup='Y'
147: where nvl(used_in_setup,'N')='N'
148: and segment_id in
149: (select a.segment_id
150: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c
151: where c.list_header_id = p_list_header_id
152: and a.segment_mapping_column = c.qualifier_attribute
153: and a.prc_context_id = b.prc_context_id
154: and b.prc_context_type = 'QUALIFIER'

Line 1038: FROM qp_qualifiers a

1034:
1035: CURSOR count_cur(a_qualifier_rule_id NUMBER, a_pte_code VARCHAR2)
1036: IS
1037: SELECT a.qualifier_grouping_no
1038: FROM qp_qualifiers a
1039: WHERE a.qualifier_rule_id = a_qualifier_rule_id
1040: AND EXISTS (SELECT 'x'
1041: FROM qp_qualifiers b, qp_prc_contexts_b d,
1042: qp_segments_b e, qp_pte_segments f

Line 1041: FROM qp_qualifiers b, qp_prc_contexts_b d,

1037: SELECT a.qualifier_grouping_no
1038: FROM qp_qualifiers a
1039: WHERE a.qualifier_rule_id = a_qualifier_rule_id
1040: AND EXISTS (SELECT 'x'
1041: FROM qp_qualifiers b, qp_prc_contexts_b d,
1042: qp_segments_b e, qp_pte_segments f
1043: WHERE b.qualifier_context = d.prc_context_code
1044: AND b.qualifier_attribute = e.segment_mapping_column
1045: AND d.prc_context_id = e.prc_context_id

Line 1054: FROM qp_qualifiers c, qp_prc_contexts_b d1,

1050: AND (b.qualifier_grouping_no = a.qualifier_grouping_no or
1051: b.qualifier_grouping_no = -1))
1052:
1053: AND EXISTS (SELECT 'x'
1054: FROM qp_qualifiers c, qp_prc_contexts_b d1,
1055: qp_segments_b e1, qp_pte_segments f1
1056: WHERE c.qualifier_context = d1.prc_context_code
1057: AND c.qualifier_attribute = e1.segment_mapping_column
1058: AND d1.prc_context_id = e1.prc_context_id

Line 1134: QP_QUALIFIERS qpq

1130:
1131: Cursor C_modifier(p_list_header_id number) IS
1132: SELECT count(1)
1133: FROM QP_LIST_HEADERS qplh ,
1134: QP_QUALIFIERS qpq
1135: WHERE qplh.list_header_id = p_list_header_id
1136: AND qplh.list_header_id = qpq.list_header_id
1137: AND qpq.qualifier_context = 'MODLIST'
1138: AND qpq.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4';

Line 1342: from qp_qualifiers

1338:
1339: Begin
1340: select 1 into l_dummy from dual where
1341: exists ( Select 'Y'
1342: from qp_qualifiers
1343: where list_header_id = p_list_header_id
1344: and NOT (qualifier_context = 'MODLIST' AND
1345: qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'));
1346: Exception

Line 1366: from qp_qualifiers q

1362: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1363: where qpl.list_header_id=p_list_header_id
1364: and exists (
1365: select 'X'
1366: from qp_qualifiers q
1367: where q.list_header_id=qpl.list_header_id
1368: and q.list_line_id = -1);
1369:
1370: -- Line level qualifiers

Line 1376: from qp_qualifiers q

1372: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 8
1373: where qpl.list_header_id=p_list_header_id
1374: and exists (
1375: select 'X'
1376: from qp_qualifiers q
1377: where q.list_header_id=qpl.list_header_id
1378: and q.list_line_id=qpl.list_line_id);
1379:
1380: END IF; --If list_type_code is 'PRL or 'AGR'

Line 1621: from qp_qualifiers

1617:
1618: Begin
1619: select 1 into l_dummy from dual where
1620: exists ( Select 'Y'
1621: from qp_qualifiers
1622: where list_header_id = l_list_header_id
1623: and NOT (qualifier_context = 'MODLIST' AND
1624: qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'));
1625: Exception

Line 1646: from qp_qualifiers q

1642: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 2
1643: where qpl.list_line_id=p_list_line_id
1644: and exists (
1645: select 'X'
1646: from qp_qualifiers q
1647: where q.list_header_id=qpl.list_header_id
1648: and q.list_line_id = -1)
1649: returning qpl.qualification_ind into l_qualification_ind;
1650:

Line 1657: from qp_qualifiers q

1653: set qpl.qualification_ind=nvl(qpl.qualification_ind,0) + 8
1654: where qpl.list_line_id=p_list_line_id
1655: and exists (
1656: select 'X'
1657: from qp_qualifiers q
1658: where q.list_header_id=qpl.list_header_id
1659: and q.list_line_id=p_list_line_id)
1660: returning qpl.qualification_ind into l_qualification_ind;
1661:

Line 2223: from qp_qualifiers

2219: )
2220: is
2221: cursor c_qualifiers is
2222: select qualifier_context, qualifier_attribute
2223: from qp_qualifiers
2224: where list_header_id = p_list_header_id
2225: and ((qualifier_grouping_no = p_qualifier_grouping_no) OR (qualifier_grouping_no = -1))
2226: and list_line_id = p_list_line_id;
2227:

Line 2363: from qp_qualifiers

2359: where list_header_id = p_list_header_id;
2360:
2361: cursor c_qual_grp_no is
2362: select distinct qualifier_grouping_no qualifier_grouping_no
2363: from qp_qualifiers
2364: where list_header_id = p_list_header_id
2365: and list_line_id = p_list_line_id
2366: and qualifier_grouping_no <> -1;
2367:

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

2483:
2484: oe_debug_pub.add('process update_changed_lines_add');
2485:
2486: --please note that this is being done from concurrent program
2487: --QP: Maintain denormalised data in qp_qualifiers also in which
2488: --case the procedure update_changed_lines_product in QPXDENOB.pls
2489: --is called. Any changes made to this routine needs to be
2490: --communicated to DENOB as well.
2491: --also this same operation is done in 3 other procedures in this

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

2531:
2532: oe_debug_pub.add('process update_changed_lines_del');
2533:
2534: --please note that this is being done from concurrent program
2535: --QP: Maintain denormalised data in qp_qualifiers also in which
2536: --case the procedure update_changed_lines_product in QPXDENOB.pls
2537: --is called. Any changes made to this routine needs to be
2538: --communicated to DENOB as well.
2539: --also this same operation is done in 3 other procedures in this

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

2602:
2603: oe_debug_pub.add('process update_changed_lines_ph');
2604:
2605: --please note that this is being done from concurrent program
2606: --QP: Maintain denormalised data in qp_qualifiers also in which
2607: --case the procedure update_changed_lines_product in QPXDENOB.pls
2608: --is called. Any changes made to this routine needs to be
2609: --communicated to DENOB as well.
2610: --also this same operation is done in 3 other procedures in this

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

2716: begin
2717:
2718: oe_debug_pub.add('process update_changed_lines_act');
2719: --please note that this is being done from concurrent program
2720: --QP: Maintain denormalised data in qp_qualifiers also in which
2721: --case the procedure update_changed_lines_product in QPXDENOB.pls
2722: --is called. Any changes made to this routine needs to be
2723: --communicated to DENOB as well.
2724: --also this same operation is done in 3 other procedures in this