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 961: l_header_flex_enabled := get_flex_enabled_flag('QP_LIST_HEADERS');

957:
958: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');
959: l_qp_source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
960:
961: l_header_flex_enabled := get_flex_enabled_flag('QP_LIST_HEADERS');
962: qp_bulk_loader_pub.write_log('Flex enabled '||l_header_flex_enabled);
963:
964: FOR I IN 1..p_header_rec.orig_sys_header_ref.COUNT
965: LOOP

Line 981: Select qp_list_headers_b_s.nextval

977:
978: -- Populating internal fields --
979:
980: IF p_header_rec.interface_action_code(I) = 'INSERT' THEN
981: Select qp_list_headers_b_s.nextval
982: into p_header_rec.list_header_id(I)
983: from dual;
984: END IF;
985:

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

1360: qp_bulk_msg.add(l_msg_rec);
1361: END IF;
1362: END IF;
1363:
1364: --Checking for uniqueness of the Name in qp_list_headers.
1365: l_exist:=null;
1366: Begin
1367: Select 1 into l_exist
1368: from qp_list_headers_tl

Line 1368: from qp_list_headers_tl

1364: --Checking for uniqueness of the Name in qp_list_headers.
1365: l_exist:=null;
1366: Begin
1367: Select 1 into l_exist
1368: from qp_list_headers_tl
1369: where name= p_header_rec.name(I)
1370: and list_header_id <>
1371: (select list_header_id From qp_list_headers_b
1372: -- ENH unod alcoa changes RAVI

Line 1371: (select list_header_id From qp_list_headers_b

1367: Select 1 into l_exist
1368: from qp_list_headers_tl
1369: where name= p_header_rec.name(I)
1370: and list_header_id <>
1371: (select list_header_id From qp_list_headers_b
1372: -- ENH unod alcoa changes RAVI
1373: /**
1374: The key between interface and qp tables is only orig_sys_hdr_ref
1375: (not list_header_id)

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

1406: qp_bulk_msg.add(l_msg_rec);
1407: END IF;
1408: END IF;
1409:
1410: --Checking for uniqueness of orig_sys_header_ref in qp_list_headers
1411: --and qp_interface_list_headers
1412:
1413: l_exist := NULL;
1414:

Line 1417: from qp_list_headers_b

1413: l_exist := NULL;
1414:
1415: BEGIN
1416: select 1, list_header_id into l_exist, l_list_header_id
1417: from qp_list_headers_b
1418: -- ENH unod alcoa changes START RAVI
1419: /**
1420: The key between interface and qp tables is only orig_sys_hdr_ref
1421: (not list_header_id)

Line 1545: (p_flex_name =>'QP_LIST_HEADERS'

1541: IF l_header_flex_enabled = 'Y' THEN
1542: qp_bulk_loader_pub.write_log( 'Header Flex enabled ');
1543:
1544: IF NOT Init_Desc_Flex
1545: (p_flex_name =>'QP_LIST_HEADERS'
1546: ,p_context => p_header_rec.context(i)
1547: ,p_attribute1 => p_header_rec.attribute1(i)
1548: ,p_attribute2 => p_header_rec.attribute2(i)
1549: ,p_attribute3 => p_header_rec.attribute3(i)

Line 1766: from qp_list_headers_b

1762: l_orig_sys_header_ref <> p_line_rec.orig_sys_header_ref(I) THEN
1763: Begin
1764: select list_header_id, start_date_active
1765: into p_line_rec.list_header_id(I), l_start_date
1766: from qp_list_headers_b
1767: where orig_system_header_ref = p_line_rec.orig_sys_header_ref(I);
1768: Exception
1769: When no_data_found then
1770: p_line_rec.list_header_id(I) := -1;

Line 2372: from qp_list_headers_b

2368: IF l_header_start_date IS NULL THEN
2369: BEGIN
2370: select start_date_active, end_date_active
2371: into l_header_start_date, l_header_end_date
2372: from qp_list_headers_b
2373: where orig_system_header_ref=p_line_rec.orig_sys_header_ref(I);
2374: EXCEPTION
2375: WHEN OTHERS
2376: THEN

Line 2791: select 1 into l_exist from qp_list_headers_b

2787: IF p_qualifier_rec.qualifier_context(I) = 'MODLIST'
2788: AND p_qualifier_rec.qualifier_attribute(I) = 'QUALIFIER_ATTRIBUTE4'
2789: THEN
2790: begin
2791: select 1 into l_exist from qp_list_headers_b
2792: where list_header_id = to_number(p_qualifier_rec.qualifier_attr_value(I));
2793: exception when others then
2794: p_qualifier_rec.process_status_flag(I):=NULL;
2795: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 3003: from qp_list_headers_b

2999:
3000: Begin
3001: select list_header_id, active_flag
3002: into p_qualifier_rec.list_header_id(I), p_qualifier_rec.active_flag(i)
3003: from qp_list_headers_b
3004: where orig_system_header_ref = p_qualifier_rec.orig_sys_header_ref(I);
3005: Exception
3006: When NO_DATA_FOUND then
3007: p_qualifier_rec.process_status_flag(I):=NULL;

Line 3026: FROM QP_interface_list_headers qpilh, qp_list_headers qplh

3022: **/
3023: BEGIN
3024: SELECT qplh.list_header_id
3025: INTO l_list_header_id
3026: FROM QP_interface_list_headers qpilh, qp_list_headers qplh
3027: WHERE qplh.list_header_id = to_number(p_qualifier_rec.qualifier_attr_value(I))
3028: AND qpilh.ORIG_SYS_HEADER_REF = p_qualifier_rec.ORIG_SYS_HEADER_REF(I)
3029: AND qplh.currency_code = qpilh.currency_code;
3030: EXCEPTION

Line 3045: FROM QP_LIST_HEADERS_TL

3041: qp_bulk_loader_pub.write_log( 'Secondary Price List read from qp_list_header');
3042: BEGIN
3043: SELECT to_char(list_header_id)
3044: INTO p_qualifier_rec.qualifier_attr_value(I)
3045: FROM QP_LIST_HEADERS_TL
3046: WHERE NAME = p_qualifier_rec.qualifier_attr_value_code(I)
3047: AND LANGUAGE = userenv('LANG');
3048: EXCEPTION
3049: WHEN NO_DATA_FOUND THEN

Line 3698: from qp_list_headers_b

3694:
3695: BEGIN
3696: select list_header_id
3697: into p_pricing_attr_rec.list_header_id(I)
3698: from qp_list_headers_b
3699: where orig_system_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
3700: EXCEPTION
3701: WHEN NO_DATA_FOUND THEN
3702: p_pricing_attr_rec.list_header_id(I) := -1;

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

5528: FROM QP_INTERFACE_LIST_HEADERS qpih
5529: WHERE qpih.request_id = p_request_id
5530: AND qpih.process_status_flag ='P' --is null
5531: AND qpih.interface_action_code IN ('INSERT')
5532: AND EXISTS ( Select qlht.name from qp_list_headers_tl qlht
5533: where qlht.name= qpih.name
5534: and qlht.language = qpih.language);
5535:
5536: qp_bulk_loader_pub.write_log('Count '||SQL%ROWCOUNT);

Line 5687: select 1 from qp_list_headers qplh

5683: WHERE qpih.request_id = p_request_id
5684: AND qpih.process_status_flag ='P' --is null
5685: AND qpih.interface_action_code ='UPDATE'
5686: AND EXISTS(
5687: select 1 from qp_list_headers qplh
5688: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
5689: and qplh.rounding_factor <> qpih.rounding_factor
5690: );
5691: --Bug#5208112 RAVI END

Line 5797: FROM qp_list_headers_b

5793: AND qpiq.process_status_flag ='P' --is null
5794: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5795: AND qpiq.orig_sys_header_ref is NOT NULL
5796: AND NOT EXISTS ( SELECT orig_system_header_ref
5797: FROM qp_list_headers_b
5798: WHERE orig_system_header_ref = qpiq.orig_sys_header_ref);
5799:
5800: --3. Secondary Pricelist
5801:

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

6102: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6103: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6104: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6105: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6106: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6107: WHERE qpil.request_id = p_request_id
6108: AND qpip.request_id = p_request_id -- bug no 5881528
6109: AND qpil.process_status_flag ='P' --is null
6110: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6188: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6189: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6190: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6191: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6192: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6193: WHERE qpil.request_id = p_request_id
6194: AND qpip.request_id = p_request_id -- bug no 5881528
6195: AND qpil.process_status_flag ='P' --is null
6196: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref