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_BULK_VALIDATE dependencies on QP_LIST_HEADERS

Line 1117: l_header_flex_enabled := get_flex_enabled_flag('QP_LIST_HEADERS');

1113:
1114: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');
1115: l_qp_source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
1116:
1117: l_header_flex_enabled := get_flex_enabled_flag('QP_LIST_HEADERS');
1118: qp_bulk_loader_pub.write_log('Flex enabled '||l_header_flex_enabled);
1119:
1120: FOR I IN 1..p_header_rec.orig_sys_header_ref.COUNT
1121: LOOP

Line 1137: Select qp_list_headers_b_s.nextval

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:

Line 1520: --Checking for uniqueness of the Name in qp_list_headers.

1516: qp_bulk_msg.add(l_msg_rec);
1517: END IF;
1518: END IF;
1519:
1520: --Checking for uniqueness of the Name in qp_list_headers.
1521: l_exist:=null;
1522: Begin
1523: Select 1 into l_exist
1524: from qp_list_headers_tl

Line 1524: from qp_list_headers_tl

1520: --Checking for uniqueness of the Name in qp_list_headers.
1521: l_exist:=null;
1522: Begin
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

Line 1527: (select list_header_id From qp_list_headers_b

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)

Line 1566: --Checking for uniqueness of orig_sys_header_ref in qp_list_headers

1562: qp_bulk_msg.add(l_msg_rec);
1563: END IF;
1564: END IF;
1565:
1566: --Checking for uniqueness of orig_sys_header_ref in qp_list_headers
1567: --and qp_interface_list_headers
1568:
1569: l_exist := NULL;
1570:

Line 1573: from qp_list_headers_b

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)

Line 1701: (p_flex_name =>'QP_LIST_HEADERS'

1697: IF l_header_flex_enabled = 'Y' THEN
1698: qp_bulk_loader_pub.write_log( 'Header Flex enabled ');
1699:
1700: IF NOT Init_Desc_Flex
1701: (p_flex_name =>'QP_LIST_HEADERS'
1702: ,p_context => p_header_rec.context(i)
1703: ,p_attribute1 => p_header_rec.attribute1(i)
1704: ,p_attribute2 => p_header_rec.attribute2(i)
1705: ,p_attribute3 => p_header_rec.attribute3(i)

Line 1922: from qp_list_headers_b

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;

Line 2500: from qp_list_headers_b

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

Line 2919: select 1 into l_exist from qp_list_headers_b

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');

Line 3130: from qp_list_headers_b

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;

Line 3153: FROM QP_interface_list_headers qpilh, qp_list_headers qplh

3149: **/
3150: BEGIN
3151: SELECT qplh.list_header_id
3152: INTO l_list_header_id
3153: FROM QP_interface_list_headers qpilh, qp_list_headers qplh
3154: WHERE qplh.list_header_id = to_number(p_qualifier_rec.qualifier_attr_value(I))
3155: AND qpilh.ORIG_SYS_HEADER_REF = p_qualifier_rec.ORIG_SYS_HEADER_REF(I)
3156: AND qplh.currency_code = qpilh.currency_code;
3157: EXCEPTION

Line 3172: FROM QP_LIST_HEADERS_TL

3168: qp_bulk_loader_pub.write_log( 'Secondary Price List read from qp_list_header');
3169: BEGIN
3170: SELECT to_char(list_header_id)
3171: INTO p_qualifier_rec.qualifier_attr_value(I)
3172: FROM QP_LIST_HEADERS_TL
3173: WHERE NAME = p_qualifier_rec.qualifier_attr_value_code(I)
3174: AND LANGUAGE = userenv('LANG');
3175: EXCEPTION
3176: WHEN NO_DATA_FOUND THEN

Line 3810: from qp_list_headers_b

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;

Line 5544: AND EXISTS ( Select qlht.name from qp_list_headers_tl qlht

5540: FROM QP_INTERFACE_LIST_HEADERS qpih
5541: WHERE qpih.request_id = p_request_id
5542: AND qpih.process_status_flag ='P' --is null
5543: AND qpih.interface_action_code IN ('INSERT')
5544: AND EXISTS ( Select qlht.name from qp_list_headers_tl qlht
5545: where qlht.name= qpih.name
5546: and qlht.language = qpih.language);
5547:
5548: qp_bulk_loader_pub.write_log('Count '||SQL%ROWCOUNT);

Line 5699: select 1 from qp_list_headers qplh

5695: WHERE qpih.request_id = p_request_id
5696: AND qpih.process_status_flag ='P' --is null
5697: AND qpih.interface_action_code ='UPDATE'
5698: AND EXISTS(
5699: select 1 from qp_list_headers qplh
5700: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
5701: and qplh.rounding_factor <> qpih.rounding_factor
5702: );
5703: --Bug#5208112 RAVI END

Line 5809: FROM qp_list_headers_b

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:

Line 6118: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

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

Line 6204: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

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