APPS.QP_VALIDATE_PRICING_ATTR dependencies on QP_LIST_LINES

Line 41: FROM qp_list_lines

37:
38: CURSOR list_line_type_code_cur(a_list_line_id NUMBER)
39: IS
40: SELECT *
41: FROM qp_list_lines
42: WHERE list_line_id = a_list_line_id;
43:
44: CURSOR gsa_cur(a_list_header_id NUMBER)
45: IS

Line 561: from qp_list_lines

557: IF (fnd_profile.value('QP_ALLOW_DUPLICATE_MODIFIERS') <> 'Y' AND
558: (l_qp_status = 'S' or gsa_ind_cur.gsa_indicator = 'Y')) THEN
559: select start_date_active, end_date_active , list_header_id
560: into l_start_date_active, l_end_date_active, l_list_header_id
561: from qp_list_lines
562: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
563:
564: OE_Debug_Pub.add ( ' Value Set 1' || l_start_date_active || l_end_date_active );
565:

Line 731: FROM qp_list_headers_b h, qp_list_lines l

727:
728: -- We have to use list_line_id here because list_header_id has not been populated yet.
729: SELECT h.pte_code, h.source_system_code
730: INTO l_pte_code, l_ss_code
731: FROM qp_list_headers_b h, qp_list_lines l
732: WHERE l.list_line_id = p_PRICING_ATTR_rec.list_line_id
733: AND l.list_header_id = h.list_header_id;
734:
735: QP_UTIL.Get_Item_Cat_Info(

Line 810: from qp_list_lines

806:
807: -- Get the list_header_id from the list_line_id, since the list_header_id is not set in
808: -- the p_PRICING_ATTR_rec.list_header_id yet.
809: select list_header_id into l_uom_list_header_id
810: from qp_list_lines
811: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
812:
813: IF NOT QP_VALIDATE.Product_Uom(p_PRICING_ATTR_rec.product_uom_code, -- sfiresto 4753707
814: to_number(p_PRICING_ATTR_rec.product_attr_value),

Line 1051: FROM QP_LIST_LINES

1047: BEGIN
1048:
1049: SELECT LIST_LINE_TYPE_CODE
1050: INTO l_primary_list_line_type_code
1051: FROM QP_LIST_LINES
1052: WHERE LIST_LINE_ID = ( select from_rltd_modifier_id
1053: from qp_rltd_modifiers
1054: where to_rltd_modifier_id
1055: = p_PRICING_ATTR_rec.list_line_id);

Line 1978: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c,

1974: l_y_list_line_id NUMBER;
1975:
1976: CURSOR get_rec(l_List_Line_ID NUMBER ) is
1977: select a.list_line_id col1, b.list_line_id col2
1978: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c,
1979: qp_list_lines c1
1980: where a.list_line_id = l_List_Line_ID
1981: and b.list_line_id <> l_List_Line_ID
1982: and b.product_attribute_context = a.product_attribute_context

Line 1979: qp_list_lines c1

1975:
1976: CURSOR get_rec(l_List_Line_ID NUMBER ) is
1977: select a.list_line_id col1, b.list_line_id col2
1978: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c,
1979: qp_list_lines c1
1980: where a.list_line_id = l_List_Line_ID
1981: and b.list_line_id <> l_List_Line_ID
1982: and b.product_attribute_context = a.product_attribute_context
1983: and b.product_attribute = a.product_attribute

Line 2016: from qp_list_lines c, qp_list_lines c1

2012:
2013:
2014: CURSOR get_rec_no_attr(l_List_Line_ID NUMBER ) is
2015: select c.list_line_id col1, c1.list_line_id col2
2016: from qp_list_lines c, qp_list_lines c1
2017: where c.list_line_id = l_List_Line_ID
2018: and c1.list_line_id <> l_List_Line_ID
2019: and c.list_line_type_code = c1.list_line_type_code
2020: and c.modifier_level_code = c1.modifier_level_code

Line 2104: from qp_list_lines

2100:
2101: begin
2102: SELECT start_date_active, end_date_active
2103: into l_sdate, l_edate
2104: from qp_list_lines
2105: where list_line_id = rec.col2;
2106: exception
2107: when no_data_found then null;
2108: end;

Line 2214: from qp_list_lines

2210:
2211: begin
2212: SELECT start_date_active, end_date_active
2213: into l_sdate, l_edate
2214: from qp_list_lines
2215: where list_line_id = rec.col2;
2216: exception
2217: when no_data_found then null;
2218: end;