APPS.OZF_OFFER_PVT dependencies on QP_QUALIFIERS

Line 1403: FROM qp_qualifiers qpq

1399: ,qpq.attribute14
1400: ,qpq.attribute15
1401: ,qpq.list_line_id
1402: ,qpq.list_header_id
1403: FROM qp_qualifiers qpq
1404: WHERE qpq.list_line_id = p_list_line_id;
1405:
1406: CURSOR c_rltd_modifier_id(p_qp_list_header_id NUMBER, p_modifier_id NUMBER) IS
1407: SELECT related_modifier_id

Line 1444: DELETE FROM qp_qualifiers

1440: FETCH c_rltd_modifier_id INTO l_rltd_modifier_id;
1441: CLOSE c_rltd_modifier_id;
1442: debug_message('jl rltd modifier id: ' || l_rltd_modifier_id);
1443: IF l_rltd_modifier_id IS NOT NULL AND l_rltd_modifier_id <> fnd_api.g_miss_num THEN
1444: DELETE FROM qp_qualifiers
1445: WHERE list_header_id = l_modifier_qualifier.list_header_id
1446: AND list_line_id = l_rltd_modifier_id;
1447:
1448: l_index := l_index + 1;

Line 2158: FROM qp_qualifiers

2154: )
2155: IS
2156: CURSOR c_qualifier_id(l_list_header_id NUMBER) IS
2157: SELECT qualifier_id
2158: FROM qp_qualifiers
2159: WHERE list_header_id = l_list_header_id
2160: AND qualifier_context = 'SOLD_BY'
2161: ORDER BY qualifier_id;
2162:

Line 2266: FROM qp_qualifiers

2262: l_qualifier_id NUMBER;
2263:
2264: CURSOR c_qualifier_id(l_list_header_id NUMBER) IS
2265: SELECT qualifier_id
2266: FROM qp_qualifiers
2267: WHERE list_header_id = l_list_header_id
2268: AND list_line_id = -1
2269: AND qualifier_context IN ('CUSTOMER', 'CUSTOMER_GROUP','TERRITORY')
2270: and rownum < 2;

Line 2274: FROM qp_qualifiers

2270: and rownum < 2;
2271:
2272: CURSOR c_sm_qualifier_id(l_list_header_id NUMBER) IS
2273: SELECT qualifier_id
2274: FROM qp_qualifiers
2275: WHERE list_header_id = l_list_header_id
2276: AND list_line_id = -1
2277: AND qualifier_context IN ('SOLD_BY');
2278:

Line 2518: FROM qp_qualifiers

2514: l_error_location NUMBER := 0;
2515:
2516: CURSOR c_qualifier_id(l_list_header_id NUMBER) IS
2517: SELECT qualifier_id
2518: FROM qp_qualifiers
2519: WHERE list_header_id = l_list_header_id
2520: AND qualifier_context IN ('CUSTOMER', 'CUSTOMER_GROUP','TERRITORY')
2521: ORDER BY qualifier_id;
2522: l_qualifier_id NUMBER;

Line 4113: UPDATE qp_qualifiers

4109: UPDATE qp_list_headers_b
4110: SET active_flag = 'Y'
4111: WHERE list_header_id = p_offer_rec.qp_list_header_id;
4112:
4113: UPDATE qp_qualifiers
4114: SET active_flag='Y'
4115: WHERE list_header_id = p_offer_rec.qp_list_header_id;
4116: /*
4117: IF p_offer_rec.offer_type = 'DEAL' THEN

Line 4244: FROM qp_qualifiers

4240: l_ship_id NUMBER := 0;
4241:
4242: CURSOR c_qualifier_id(l_list_header_id NUMBER) IS
4243: SELECT qualifier_id , qualifier_context , qualifier_attribute
4244: FROM qp_qualifiers
4245: WHERE list_header_id = l_list_header_id
4246: AND qualifier_context = 'ORDER'
4247: AND qualifier_attribute in ('QUALIFIER_ATTRIBUTE1','QUALIFIER_ATTRIBUTE8');
4248:

Line 6932: UPDATE qp_qualifiers

6928: UPDATE qp_list_headers_b
6929: SET active_flag = 'Y'
6930: WHERE list_header_id = p_qp_list_header_id;
6931:
6932: UPDATE qp_qualifiers
6933: SET active_flag='Y'
6934: WHERE list_header_id = p_qp_list_header_id;
6935: END IF;
6936: END IF;

Line 9106: UPDATE qp_qualifiers

9102: UPDATE qp_list_headers_b
9103: SET active_flag = 'Y'
9104: WHERE list_header_id = p_modifier_list_rec.qp_list_header_id;
9105: -- Forward port bug 3143594. 11i.10 bug is 3614058
9106: UPDATE qp_qualifiers
9107: SET active_flag = 'Y'
9108: WHERE list_header_id = p_modifier_list_rec.qp_list_header_id;
9109:
9110: END IF;

Line 11686: FROM qp_qualifiers

11682: */
11683:
11684: CURSOR cur_get_old_qualifiers IS
11685: SELECT qualifier_id
11686: FROM qp_qualifiers
11687: WHERE list_header_id = p_qp_list_header_id
11688: --bug 12632240 ninarasi
11689: AND ((qualifier_context = 'CUSTOMER'
11690: AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE2', 'QUALIFIER_ATTRIBUTE14',

Line 11719: FROM qp_qualifiers

11715: AND org_id=p_org_id;
11716:
11717: CURSOR cur_get_modlist_count IS --bug 12632240 ninarasi
11718: SELECT COUNT(qualifier_id)
11719: FROM qp_qualifiers
11720: WHERE list_header_id = p_qp_list_header_id
11721: AND (qualifier_context = 'MODLIST'
11722: AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE32'
11723: AND qualifier_grouping_no = -1

Line 11736: --Bug 13981597 - cursor to fetch customers to be deleted from qp_qualifiers

11732: AND end_customer_flag = 'Y'
11733: AND NVL(operation_flag, 'I') = 'I';
11734:
11735:
11736: --Bug 13981597 - cursor to fetch customers to be deleted from qp_qualifiers
11737: CURSOR cur_get_del_qualifiers IS
11738: SELECT qualifier_id
11739: FROM qp_qualifiers
11740: WHERE list_header_id = p_qp_list_header_id

Line 11739: FROM qp_qualifiers

11735:
11736: --Bug 13981597 - cursor to fetch customers to be deleted from qp_qualifiers
11737: CURSOR cur_get_del_qualifiers IS
11738: SELECT qualifier_id
11739: FROM qp_qualifiers
11740: WHERE list_header_id = p_qp_list_header_id
11741: AND list_line_id = -1
11742: AND qualifier_attribute = l_qualifier_attribute
11743: AND qualifier_context = l_qualifier_context

Line 11760: FROM qp_qualifiers

11756:
11757: --Bug 13981597 - cursor to fetch max grouping number
11758: CURSOR cur_max_qualifier_grouping_no IS
11759: SELECT NVL(max(qualifier_grouping_no),0) + 10
11760: FROM qp_qualifiers
11761: WHERE list_header_id = p_qp_list_header_id
11762: AND list_line_id =-1
11763: AND qualifier_grouping_no > 0;
11764:

Line 11983: --Delete if operation_flag is D and the corresponding records are available in qp_qualifiers

11979: l_qualifier_attribute := 'QUALIFIER_ATTRIBUTE1';
11980: l_qualifier_attr_value := cust_line_rec.cust_usage_value;
11981: END IF;
11982:
11983: --Delete if operation_flag is D and the corresponding records are available in qp_qualifiers
11984: IF cust_line_rec.operation_flag = 'D' THEN
11985:
11986: x_qualifier_tbl(l_qual_index).qualifier_id := NULL;
11987: