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 DUAL

Line 173: from dual;

169:
170: --Insert the message into Interface error table.
171: Select qp_interface_errors_s.nextval
172: into l_error_id
173: from dual;
174:
175: INSERT INTO
176: QP_INTERFACE_ERRORS
177: (error_id,last_update_date, last_updated_by, creation_date,

Line 1112: from DUAL;

1108: qp_bulk_loader_pub.write_log('Entering Entity_header validation');
1109:
1110: select fnd_date.date_to_canonical(TRUNC(SYSDATE))
1111: into l_start_date_active
1112: from DUAL;
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:

Line 1139: from dual;

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:
1142: p_header_rec.version_no(I) := '1';
1143: p_header_rec.automatic_flag(I) := 'Y';

Line 1290: into l_first_date_hash from dual;

1286: l_date_length := null;
1287:
1288: begin
1289: select substr(p_header_rec.start_date_active(I),5,1)
1290: into l_first_date_hash from dual;
1291: select substr(p_header_rec.start_date_active(I),8,1)
1292: into l_second_date_hash from dual;
1293: select length(p_header_rec.start_date_active(I))
1294: into l_date_length from dual;

Line 1292: into l_second_date_hash from dual;

1288: begin
1289: select substr(p_header_rec.start_date_active(I),5,1)
1290: into l_first_date_hash from dual;
1291: select substr(p_header_rec.start_date_active(I),8,1)
1292: into l_second_date_hash from dual;
1293: select length(p_header_rec.start_date_active(I))
1294: into l_date_length from dual;
1295:
1296: IF l_date_length<>10 or l_first_date_hash<>'/' or l_second_date_hash<>'/'

Line 1294: into l_date_length from dual;

1290: into l_first_date_hash from dual;
1291: select substr(p_header_rec.start_date_active(I),8,1)
1292: into l_second_date_hash from dual;
1293: select length(p_header_rec.start_date_active(I))
1294: into l_date_length from dual;
1295:
1296: IF l_date_length<>10 or l_first_date_hash<>'/' or l_second_date_hash<>'/'
1297: THEN
1298: p_header_rec.process_status_flag(I):=NULL;

Line 1320: into l_first_date_hash from dual;

1316: l_date_length := null;
1317:
1318: begin
1319: select substr(p_header_rec.end_date_active(I),5,1)
1320: into l_first_date_hash from dual;
1321: select substr(p_header_rec.end_date_active(I),8,1)
1322: into l_second_date_hash from dual;
1323: select length(p_header_rec.end_date_active(I))
1324: into l_date_length from dual;

Line 1322: into l_second_date_hash from dual;

1318: begin
1319: select substr(p_header_rec.end_date_active(I),5,1)
1320: into l_first_date_hash from dual;
1321: select substr(p_header_rec.end_date_active(I),8,1)
1322: into l_second_date_hash from dual;
1323: select length(p_header_rec.end_date_active(I))
1324: into l_date_length from dual;
1325:
1326: IF l_date_length<>10 or l_first_date_hash<>'/' or l_second_date_hash<>'/'

Line 1324: into l_date_length from dual;

1320: into l_first_date_hash from dual;
1321: select substr(p_header_rec.end_date_active(I),8,1)
1322: into l_second_date_hash from dual;
1323: select length(p_header_rec.end_date_active(I))
1324: into l_date_length from dual;
1325:
1326: IF l_date_length<>10 or l_first_date_hash<>'/' or l_second_date_hash<>'/'
1327: THEN
1328: p_header_rec.process_status_flag(I):=NULL;

Line 1909: from dual;

1905: /*-- populating some internal fields --*/
1906: If p_line_rec.interface_action_code(I)='INSERT' THEN
1907: select qp_list_lines_s.nextval
1908: into p_line_rec.list_line_id(I)
1909: from dual;
1910: end if;
1911: p_line_rec.list_line_no(I):= p_line_rec.list_line_id(I);
1912: p_line_rec.pricing_phase_id(I) := 1;
1913: p_line_rec.automatic_flag(I) := 'Y';

Line 2784: into p_qualifier_rec.qualifier_id(I) from dual;

2780: p_qualifier_rec.orig_sys_line_ref(I) := '-1';
2781:
2782: If p_qualifier_rec.interface_action_code(I)='INSERT' THEN
2783: Select qp_qualifiers_s.nextval
2784: into p_qualifier_rec.qualifier_id(I) from dual;
2785: end if;
2786:
2787:
2788:

Line 2868: from dual

2864: qp_bulk_msg.add(l_msg_rec);
2865: ELSIF p_qualifier_rec.qualify_hier_descendents_flag(I) in ('Y','y') THEN
2866: BEGIN
2867: select 'Y' into l_hierarchy_enabled
2868: from dual
2869: where exists(select 'X'
2870: from qp_segments_b qs,qp_prc_contexts_b qpc
2871: where
2872: qs.prc_context_id = qpc.prc_context_id and

Line 3831: from dual;

3827:
3828: IF p_pricing_attr_rec.interface_action_code(I) = 'INSERT' THEN
3829: Select qp_pricing_attr_group_no_s.nextval
3830: into p_pricing_attr_rec.attribute_grouping_no(I)
3831: from dual;
3832: END IF;
3833:
3834: p_pricing_attr_rec.pricing_phase_id(I):=1;
3835:

Line 6218: from dual

6214: and qpip.product_attribute_context = 'ITEM'
6215: and qpip.product_attribute = 'PRICING_ATTRIBUTE2'
6216: AND NOT EXISTS (
6217: select 'EXISTS'
6218: from dual
6219: where QP_BULK_VALIDATE.product_uom(
6220: qpip.product_uom_code,
6221: to_number(qpip.product_attr_value),
6222: qplh.list_header_id) = 'TRUE'