[Home] [Help]
1133:
1134: -- Populating internal fields --
1135:
1136: IF p_header_rec.interface_action_code(I) = 'INSERT' THEN
1137: Select qp_list_headers_b_s.nextval
1138: into p_header_rec.list_header_id(I)
1139: from dual;
1140: END IF;
1141:
1523: Select 1 into l_exist
1524: from qp_list_headers_tl
1525: where name= p_header_rec.name(I)
1526: and list_header_id <>
1527: (select list_header_id From qp_list_headers_b
1528: -- ENH unod alcoa changes RAVI
1529: /**
1530: The key between interface and qp tables is only orig_sys_hdr_ref
1531: (not list_header_id)
1569: l_exist := NULL;
1570:
1571: BEGIN
1572: select 1, list_header_id into l_exist, l_list_header_id
1573: from qp_list_headers_b
1574: -- ENH unod alcoa changes START RAVI
1575: /**
1576: The key between interface and qp tables is only orig_sys_hdr_ref
1577: (not list_header_id)
1918: l_orig_sys_header_ref <> p_line_rec.orig_sys_header_ref(I) THEN
1919: Begin
1920: select list_header_id, start_date_active
1921: into p_line_rec.list_header_id(I), l_start_date
1922: from qp_list_headers_b
1923: where orig_system_header_ref = p_line_rec.orig_sys_header_ref(I);
1924: Exception
1925: When no_data_found then
1926: p_line_rec.list_header_id(I) := -1;
2496: IF l_header_start_date IS NULL THEN
2497: BEGIN
2498: select start_date_active, end_date_active
2499: into l_header_start_date, l_header_end_date
2500: from qp_list_headers_b
2501: where orig_system_header_ref=p_line_rec.orig_sys_header_ref(I);
2502: EXCEPTION
2503: WHEN OTHERS
2504: THEN
2915: IF p_qualifier_rec.qualifier_context(I) = 'MODLIST'
2916: AND p_qualifier_rec.qualifier_attribute(I) = 'QUALIFIER_ATTRIBUTE4'
2917: THEN
2918: begin
2919: select 1 into l_exist from qp_list_headers_b
2920: where list_header_id = to_number(p_qualifier_rec.qualifier_attr_value(I));
2921: exception when others then
2922: p_qualifier_rec.process_status_flag(I):=NULL;
2923: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
3126:
3127: Begin
3128: select list_header_id, active_flag
3129: into p_qualifier_rec.list_header_id(I), p_qualifier_rec.active_flag(i)
3130: from qp_list_headers_b
3131: where orig_system_header_ref = p_qualifier_rec.orig_sys_header_ref(I);
3132: Exception
3133: When NO_DATA_FOUND then
3134: p_qualifier_rec.process_status_flag(I):=NULL;
3806:
3807: BEGIN
3808: select list_header_id
3809: into p_pricing_attr_rec.list_header_id(I)
3810: from qp_list_headers_b
3811: where orig_system_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
3812: EXCEPTION
3813: WHEN NO_DATA_FOUND THEN
3814: p_pricing_attr_rec.list_header_id(I) := -1;
5805: AND qpiq.process_status_flag ='P' --is null
5806: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5807: AND qpiq.orig_sys_header_ref is NOT NULL
5808: AND NOT EXISTS ( SELECT orig_system_header_ref
5809: FROM qp_list_headers_b
5810: WHERE orig_system_header_ref = qpiq.orig_sys_header_ref);
5811:
5812: --3. Secondary Pricelist
5813:
6114: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6115: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6116: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6117: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6118: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6119: WHERE qpil.request_id = p_request_id
6120: AND qpip.request_id = p_request_id -- bug no 5881528
6121: AND qpil.process_status_flag ='P' --is null
6122: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref
6200: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6201: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6202: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6203: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6204: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6205: WHERE qpil.request_id = p_request_id
6206: AND qpip.request_id = p_request_id -- bug no 5881528
6207: AND qpil.process_status_flag ='P' --is null
6208: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref