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 127: FROM dual;

123: l_msg := fnd_message.Get;
124:
125: SELECT qp_interface_errors_s.NEXTVAL
126: INTO l_error_id
127: FROM dual;
128:
129: INSERT INTO qp_interface_errors(error_id, last_update_date, last_updated_by,
130: creation_date, created_by, last_update_login, request_id,
131: program_application_id, program_id, program_update_date, entity_type,

Line 956: from DUAL;

952: qp_bulk_loader_pub.write_log('Entering Entity_header validation');
953:
954: select fnd_date.date_to_canonical(TRUNC(SYSDATE))
955: into l_start_date_active
956: from DUAL;
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:

Line 983: from dual;

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

Line 1134: into l_first_date_hash from dual;

1130: l_date_length := null;
1131:
1132: begin
1133: select substr(p_header_rec.start_date_active(I),5,1)
1134: into l_first_date_hash from dual;
1135: select substr(p_header_rec.start_date_active(I),8,1)
1136: into l_second_date_hash from dual;
1137: select length(p_header_rec.start_date_active(I))
1138: into l_date_length from dual;

Line 1136: into l_second_date_hash from dual;

1132: begin
1133: select substr(p_header_rec.start_date_active(I),5,1)
1134: into l_first_date_hash from dual;
1135: select substr(p_header_rec.start_date_active(I),8,1)
1136: into l_second_date_hash from dual;
1137: select length(p_header_rec.start_date_active(I))
1138: into l_date_length from dual;
1139:
1140: IF l_date_length<>10 or l_first_date_hash<>'/' or l_second_date_hash<>'/'

Line 1138: into l_date_length from dual;

1134: into l_first_date_hash from dual;
1135: select substr(p_header_rec.start_date_active(I),8,1)
1136: into l_second_date_hash from dual;
1137: select length(p_header_rec.start_date_active(I))
1138: into l_date_length from dual;
1139:
1140: IF l_date_length<>10 or l_first_date_hash<>'/' or l_second_date_hash<>'/'
1141: THEN
1142: p_header_rec.process_status_flag(I):=NULL;

Line 1164: into l_first_date_hash from dual;

1160: l_date_length := null;
1161:
1162: begin
1163: select substr(p_header_rec.end_date_active(I),5,1)
1164: into l_first_date_hash from dual;
1165: select substr(p_header_rec.end_date_active(I),8,1)
1166: into l_second_date_hash from dual;
1167: select length(p_header_rec.end_date_active(I))
1168: into l_date_length from dual;

Line 1166: into l_second_date_hash from dual;

1162: begin
1163: select substr(p_header_rec.end_date_active(I),5,1)
1164: into l_first_date_hash from dual;
1165: select substr(p_header_rec.end_date_active(I),8,1)
1166: into l_second_date_hash from dual;
1167: select length(p_header_rec.end_date_active(I))
1168: into l_date_length from dual;
1169:
1170: IF l_date_length<>10 or l_first_date_hash<>'/' or l_second_date_hash<>'/'

Line 1168: into l_date_length from dual;

1164: into l_first_date_hash from dual;
1165: select substr(p_header_rec.end_date_active(I),8,1)
1166: into l_second_date_hash from dual;
1167: select length(p_header_rec.end_date_active(I))
1168: into l_date_length from dual;
1169:
1170: IF l_date_length<>10 or l_first_date_hash<>'/' or l_second_date_hash<>'/'
1171: THEN
1172: p_header_rec.process_status_flag(I):=NULL;

Line 1753: from dual;

1749: /*-- populating some internal fields --*/
1750: If p_line_rec.interface_action_code(I)='INSERT' THEN
1751: select qp_list_lines_s.nextval
1752: into p_line_rec.list_line_id(I)
1753: from dual;
1754: end if;
1755: p_line_rec.list_line_no(I):= p_line_rec.list_line_id(I);
1756: p_line_rec.pricing_phase_id(I) := 1;
1757: p_line_rec.automatic_flag(I) := 'Y';

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

2652: p_qualifier_rec.orig_sys_line_ref(I) := '-1';
2653:
2654: If p_qualifier_rec.interface_action_code(I)='INSERT' THEN
2655: Select qp_qualifiers_s.nextval
2656: into p_qualifier_rec.qualifier_id(I) from dual;
2657: end if;
2658:
2659:
2660:

Line 2740: from dual

2736: qp_bulk_msg.add(l_msg_rec);
2737: ELSIF p_qualifier_rec.qualify_hier_descendents_flag(I) in ('Y','y') THEN
2738: BEGIN
2739: select 'Y' into l_hierarchy_enabled
2740: from dual
2741: where exists(select 'X'
2742: from qp_segments_b qs,qp_prc_contexts_b qpc
2743: where
2744: qs.prc_context_id = qpc.prc_context_id and

Line 3719: from dual;

3715:
3716: IF p_pricing_attr_rec.interface_action_code(I) = 'INSERT' THEN
3717: Select qp_pricing_attr_group_no_s.nextval
3718: into p_pricing_attr_rec.attribute_grouping_no(I)
3719: from dual;
3720: END IF;
3721:
3722: p_pricing_attr_rec.pricing_phase_id(I):=1;
3723:

Line 6206: from dual

6202: and qpip.product_attribute_context = 'ITEM'
6203: and qpip.product_attribute = 'PRICING_ATTRIBUTE2'
6204: AND NOT EXISTS (
6205: select 'EXISTS'
6206: from dual
6207: where QP_BULK_VALIDATE.product_uom(
6208: qpip.product_uom_code,
6209: to_number(qpip.product_attr_value),
6210: qplh.list_header_id) = 'TRUE'