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.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_SYS_PARAMETERS

Line 139: OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD := OE_Sys_Parameters.value('ONT_SCHEDULE_LINE_ON_HOLD');

135: -- It will also include system parameters that only change
136: -- during the OU change.
137: ------------------------------------------------------------
138:
139: OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD := OE_Sys_Parameters.value('ONT_SCHEDULE_LINE_ON_HOLD');
140:
141: OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE := OE_Sys_Parameters.value('ONT_RESERVATION_TIME_FENCE');
142:
143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');

Line 141: OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE := OE_Sys_Parameters.value('ONT_RESERVATION_TIME_FENCE');

137: ------------------------------------------------------------
138:
139: OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD := OE_Sys_Parameters.value('ONT_SCHEDULE_LINE_ON_HOLD');
140:
141: OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE := OE_Sys_Parameters.value('ONT_RESERVATION_TIME_FENCE');
142:
143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');
144:
145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');

Line 143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');

139: OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD := OE_Sys_Parameters.value('ONT_SCHEDULE_LINE_ON_HOLD');
140:
141: OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE := OE_Sys_Parameters.value('ONT_RESERVATION_TIME_FENCE');
142:
143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');
144:
145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');
146:
147: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');

Line 145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');

141: OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE := OE_Sys_Parameters.value('ONT_RESERVATION_TIME_FENCE');
142:
143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');
144:
145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');
146:
147: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
148:
149: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');

Line 147: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');

143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');
144:
145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');
146:
147: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
148:
149: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
150:
151:

Line 149: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');

145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');
146:
147: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
148:
149: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
150:
151:
152: ----------------------------------------------------------
153: -- Load Hold Sources into globals

Line 352: oe_sys_parameters_all sys

348: , NULL request_id
349: , NULL batch_id
350: , h.org_id
351: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432
352: oe_sys_parameters_all sys
353: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
354: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
355: AND h.org_id = l.org_id
356: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313

Line 429: oe_sys_parameters_all sys

425: , NULL request_id
426: , NULL batch_id
427: , h.org_id org_id
428: FROM oe_headers_interface h, oe_lines_iface_all l, --bug 4685432
429: oe_sys_parameters_all sys
430: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
431: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
432: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
433: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'

Line 482: oe_sys_parameters_all sys

478: , NULL request_id
479: , NULL batch_id
480: , l_default_org_id org_id
481: FROM oe_headers_iface_all h, oe_lines_iface_all l, --bug 4685432
482: oe_sys_parameters_all sys
483: WHERE h.order_source_id = nvl(p_order_source_id,h.order_source_id)
484: AND h.orig_sys_document_ref = nvl(p_orig_sys_document_ref,h.orig_sys_document_ref)
485: AND nvl(sys.org_id,l_default_org_id) = l_default_org_id --bug 4685432, 5209313
486: AND sys.org_id(+) = h.org_id

Line 539: FROM oe_sys_parameters_syn

535: -- Get Customer Acceptance enabled OU
536: -------------------------------------
537: CURSOR ca_enabled_cur IS
538: SELECT count(org_id), org_id
539: FROM oe_sys_parameters_syn
540: WHERE parameter_code = 'ENABLE_FULFILLMENT_ACCEPTANCE'
541: AND nvl(parameter_value,'N') = 'Y'
542: AND ((p_operating_unit IS NULL) OR (org_id = p_operating_unit))
543: GROUP BY org_id

Line 698: oe_sys_parameters_all sys

694: FROM(
695: SELECT /* MOAC_SQL_CHANGE */
696: h.orig_sys_document_ref orig_sys_document_ref
697: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
698: oe_sys_parameters_all sys
699: WHERE request_id IS NULL
700: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
701: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'
702: AND nvl(sys.parameter_value,'N') = 'N'

Line 756: oe_sys_parameters_all sys

752: AND operation_code <> 'BOOK_ORDER')
753: UNION
754: SELECT h.orig_sys_document_ref orig_sys_document_ref
755: FROM oe_headers_iface_all h, oe_order_sources os, --bug 4685432
756: oe_sys_parameters_all sys
757: WHERE request_id IS NULL
758: AND nvl(sys.org_id,l_default_org_id) = l_default_org_id --bug 4685432, 5209313
759: AND sys.org_id(+) = h.org_id
760: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'

Line 805: oe_sys_parameters_all sys

801: oe_debug_pub.add('p_process_recs_with_no_org =N',1);
802: SELECT /* MOAC_SQL_CHANGE */ count(*)
803: INTO l_row_count
804: FROM oe_headers_interface h, oe_order_sources os, --bug 4685432
805: oe_sys_parameters_all sys
806: WHERE request_id IS NULL
807: AND sys.org_id(+) = h.org_id --bug 4685432, 5209313
808: AND sys.parameter_code(+) = 'ENABLE_FULFILLMENT_ACCEPTANCE'
809: AND nvl(sys.parameter_value,'N') = 'N'

Line 1261: --IF OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',G_ORG_ID) = 'Y'

1257: -----------------------------------------------------------
1258: --Customer Acceptance
1259: --If Customer Acceptance is enabled then HVOP is not supported
1260: -----------------------------------------------------------
1261: --IF OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',G_ORG_ID) = 'Y'
1262: --THEN
1263: -- FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ACCEPTANCE');
1264: -- fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);
1265: -- retcode := 2;