APPS.OZF_OFFER_PVT dependencies on QP_QUALIFIERS

Line 1302: FROM qp_qualifiers qpq

1298: ,qpq.attribute14
1299: ,qpq.attribute15
1300: ,qpq.list_line_id
1301: ,qpq.list_header_id
1302: FROM qp_qualifiers qpq
1303: WHERE qpq.list_line_id = p_list_line_id;
1304:
1305: CURSOR c_rltd_modifier_id(p_qp_list_header_id NUMBER, p_modifier_id NUMBER) IS
1306: SELECT related_modifier_id

Line 1343: DELETE FROM qp_qualifiers

1339: FETCH c_rltd_modifier_id INTO l_rltd_modifier_id;
1340: CLOSE c_rltd_modifier_id;
1341: debug_message('jl rltd modifier id: ' || l_rltd_modifier_id);
1342: IF l_rltd_modifier_id IS NOT NULL AND l_rltd_modifier_id <> fnd_api.g_miss_num THEN
1343: DELETE FROM qp_qualifiers
1344: WHERE list_header_id = l_modifier_qualifier.list_header_id
1345: AND list_line_id = l_rltd_modifier_id;
1346:
1347: l_index := l_index + 1;

Line 2047: FROM qp_qualifiers

2043: )
2044: IS
2045: CURSOR c_qualifier_id(l_list_header_id NUMBER) IS
2046: SELECT qualifier_id
2047: FROM qp_qualifiers
2048: WHERE list_header_id = l_list_header_id
2049: AND qualifier_context = 'SOLD_BY'
2050: ORDER BY qualifier_id;
2051:

Line 2155: FROM qp_qualifiers

2151: l_qualifier_id NUMBER;
2152:
2153: CURSOR c_qualifier_id(l_list_header_id NUMBER) IS
2154: SELECT qualifier_id
2155: FROM qp_qualifiers
2156: WHERE list_header_id = l_list_header_id
2157: AND list_line_id = -1
2158: AND qualifier_context IN ('CUSTOMER', 'CUSTOMER_GROUP','TERRITORY')
2159: and rownum < 2;

Line 2163: FROM qp_qualifiers

2159: and rownum < 2;
2160:
2161: CURSOR c_sm_qualifier_id(l_list_header_id NUMBER) IS
2162: SELECT qualifier_id
2163: FROM qp_qualifiers
2164: WHERE list_header_id = l_list_header_id
2165: AND list_line_id = -1
2166: AND qualifier_context IN ('SOLD_BY');
2167:

Line 2356: FROM qp_qualifiers

2352: l_error_location NUMBER := 0;
2353:
2354: CURSOR c_qualifier_id(l_list_header_id NUMBER) IS
2355: SELECT qualifier_id
2356: FROM qp_qualifiers
2357: WHERE list_header_id = l_list_header_id
2358: AND qualifier_context IN ('CUSTOMER', 'CUSTOMER_GROUP','TERRITORY')
2359: ORDER BY qualifier_id;
2360: l_qualifier_id NUMBER;

Line 3932: UPDATE qp_qualifiers

3928: UPDATE qp_list_headers_b
3929: SET active_flag = 'Y'
3930: WHERE list_header_id = p_offer_rec.qp_list_header_id;
3931:
3932: UPDATE qp_qualifiers
3933: SET active_flag='Y'
3934: WHERE list_header_id = p_offer_rec.qp_list_header_id;
3935: /*
3936: IF p_offer_rec.offer_type = 'DEAL' THEN

Line 4045: FROM qp_qualifiers

4041: l_ship_id NUMBER := 0;
4042:
4043: CURSOR c_qualifier_id(l_list_header_id NUMBER) IS
4044: SELECT qualifier_id , qualifier_context , qualifier_attribute
4045: FROM qp_qualifiers
4046: WHERE list_header_id = l_list_header_id
4047: AND qualifier_context = 'ORDER'
4048: AND qualifier_attribute in ('QUALIFIER_ATTRIBUTE1','QUALIFIER_ATTRIBUTE8');
4049:

Line 6402: UPDATE qp_qualifiers

6398: UPDATE qp_list_headers_b
6399: SET active_flag = 'Y'
6400: WHERE list_header_id = p_qp_list_header_id;
6401:
6402: UPDATE qp_qualifiers
6403: SET active_flag='Y'
6404: WHERE list_header_id = p_qp_list_header_id;
6405: END IF;
6406: END IF;

Line 8572: UPDATE qp_qualifiers

8568: UPDATE qp_list_headers_b
8569: SET active_flag = 'Y'
8570: WHERE list_header_id = p_modifier_list_rec.qp_list_header_id;
8571: -- Forward port bug 3143594. 11i.10 bug is 3614058
8572: UPDATE qp_qualifiers
8573: SET active_flag = 'Y'
8574: WHERE list_header_id = p_modifier_list_rec.qp_list_header_id;
8575:
8576: END IF;

Line 11051: FROM qp_qualifiers

11047: AND end_customer_flag = 'Y';
11048:
11049: CURSOR cur_get_old_qualifiers IS
11050: SELECT qualifier_id
11051: FROM qp_qualifiers
11052: WHERE list_header_id = p_qp_list_header_id;
11053:
11054: CURSOR cur_get_internal_order_number IS
11055: SELECT internal_order_number,org_id