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.

[Home] [Help]

APPS.OE_ORDER_IMPORT_MAIN_PVT dependencies on OE_HEADERS_IFACE_ALL

Line 37: tabname => 'OE_HEADERS_IFACE_ALL');

33: oe_debug_pub.add( 'BEFORE CALLING PERF STATISTICS API' ) ;
34: END IF;
35:
36: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
37: tabname => 'OE_HEADERS_IFACE_ALL');
38: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
39: tabname => 'OE_LINES_IFACE_ALL');
40: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
41: tabname => 'OE_ACTIONS_IFACE_ALL');

Line 192: FROM oe_headers_iface_all

188: , sold_to_org
189: , change_sequence
190: , nvl(closed_flag, 'N')
191: ,org_id
192: FROM oe_headers_iface_all
193: WHERE request_id = l_request_id
194: AND decode(p_perf_param, 'Y',
195: nvl(error_flag,'N'), ' ')
196: = decode(p_perf_param, 'Y',

Line 410: FROM oe_headers_iface_all

406: -----------------------------------------------------------
407: */
408: /* oe_debug_pub.add('No of orders in inf table');
409: SELECT COUNT(*) INTO l_ord_count
410: FROM oe_headers_iface_all
411: WHERE order_source_id = 1084
412: AND ( nvl(NULL,' ') = ' ' OR
413: (nvl(NULL,' ') <> ' ' AND
414: nvl(NULL,' ') = nvl(orig_sys_document_ref,' ')))

Line 456: UPDATE oe_headers_iface_all

452: (p_operating_unit IS NULL AND
453: p_default_org_id IS NOT NULL)
454: THEN
455:
456: UPDATE oe_headers_iface_all
457: SET request_id = l_request_id,
458: org_id = p_default_org_id
459: WHERE order_source_id = l_order_source_id
460: AND ( nvl(l_orig_sys_document_ref,' ') = ' ' OR

Line 492: FROM oe_headers_iface_all -- MOAC

488: COMMIT;
489:
490: SELECT COUNT(*)
491: INTO l_row_count
492: FROM oe_headers_iface_all -- MOAC
493: WHERE request_id = l_request_id;
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add( 'ROW COUNT = '||L_ROW_COUNT ) ;
496: END IF;

Line 566: UPDATE oe_headers_iface_all

562: END IF;
563:
564: IF (p_perf_param = 'Y') THEN
565: -- only update one record
566: UPDATE oe_headers_iface_all
567: SET request_id = new_request_id
568: WHERE request_id = l_request_id
569: AND ROWNUM =1;
570: ELSE

Line 572: UPDATE oe_headers_iface_all

568: WHERE request_id = l_request_id
569: AND ROWNUM =1;
570: ELSE
571: -- update batchsize records
572: UPDATE oe_headers_iface_all
573: SET request_id = new_request_id
574: WHERE request_id = l_request_id
575: AND ROWNUM <= batch_size;
576: END IF;

Line 626: FROM oe_headers_iface_all

622: SET request_id = l_request_id
623: WHERE (order_source_id, orig_sys_document_ref, nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
624: ( SELECT order_source_id, orig_sys_document_ref,
625: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
626: FROM oe_headers_iface_all
627: WHERE request_id = l_request_id);
628: /*AND decode(p_perf_param, 'Y',
629: nvl(error_flag,'N'), ' ')
630: = decode(p_perf_param, 'Y',

Line 645: FROM oe_headers_iface_all

641: WHERE (order_source_id, orig_sys_document_ref,
642: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
643: ( SELECT order_source_id, orig_sys_document_ref,
644: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
645: FROM oe_headers_iface_all
646: WHERE request_id = l_request_id) ;
647: /*AND decode(p_perf_param, 'Y',
648: nvl(error_flag,'N'), ' ')
649: = decode(p_perf_param, 'Y',

Line 661: FROM oe_headers_iface_all

657: WHERE (order_source_id, orig_sys_document_ref,
658: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
659: ( SELECT order_source_id, orig_sys_document_ref,
660: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
661: FROM oe_headers_iface_all
662: WHERE request_id = l_request_id) ;
663: /* AND decode(p_perf_param, 'Y',
664: nvl(error_flag,'N'), ' ')
665: = decode(p_perf_param, 'Y',

Line 682: FROM oe_headers_iface_all

678: WHERE (order_source_id, orig_sys_document_ref,
679: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
680: ( SELECT order_source_id, orig_sys_document_ref,
681: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
682: FROM oe_headers_iface_all
683: WHERE request_id = l_request_id) ;
684: /* AND decode(p_perf_param, 'Y',
685: nvl(error_flag,'N'), ' ')
686: = decode(p_perf_param, 'Y',

Line 698: FROM oe_headers_iface_all

694: WHERE (order_source_id, orig_sys_document_ref,
695: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
696: ( SELECT order_source_id, orig_sys_document_ref,
697: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
698: FROM oe_headers_iface_all
699: WHERE request_id = l_request_id) ;
700: /*AND decode(p_perf_param, 'Y',
701: nvl(error_flag,'N'), ' ')
702: = decode(p_perf_param, 'Y',

Line 713: FROM oe_headers_iface_all

709: WHERE (order_source_id, orig_sys_document_ref,
710: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
711: ( SELECT order_source_id, orig_sys_document_ref,
712: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
713: FROM oe_headers_iface_all
714: WHERE request_id = l_request_id) ;
715: /*AND decode(p_perf_param, 'Y',
716: nvl(error_flag,'N'), ' ')
717: = decode(p_perf_param, 'Y',

Line 728: FROM oe_headers_iface_all

724: WHERE (order_source_id, orig_sys_document_ref,
725: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
726: ( SELECT order_source_id, orig_sys_document_ref,
727: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
728: FROM oe_headers_iface_all
729: WHERE request_id = l_request_id) ;
730: /* AND decode(p_perf_param, 'Y',
731: nvl(error_flag,'N'), ' ')
732: = decode(p_perf_param, 'Y',

Line 743: FROM oe_headers_iface_all

739: WHERE (order_source_id, orig_sys_document_ref,
740: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
741: ( SELECT order_source_id, orig_sys_document_ref,
742: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)
743: FROM oe_headers_iface_all
744: WHERE request_id = l_request_id) ;
745: /* AND decode(p_perf_param, 'Y',
746: nvl(error_flag,'N'), ' ')
747: = decode(p_perf_param, 'Y',

Line 1056: from oe_headers_iface_all --MOAC

1052: loop
1053:
1054: select rowidtochar(rowid)
1055: into l_rowid
1056: from oe_headers_iface_all --MOAC
1057: where request_id = l_pnt_request_id
1058: and rownum = 1;
1059:
1060: UPDATE oe_headers_iface_all --MOAC

Line 1060: UPDATE oe_headers_iface_all --MOAC

1056: from oe_headers_iface_all --MOAC
1057: where request_id = l_pnt_request_id
1058: and rownum = 1;
1059:
1060: UPDATE oe_headers_iface_all --MOAC
1061: SET request_id = l_request_id
1062: WHERE request_id = l_pnt_request_id
1063: AND nvl(error_flag,'N') = 'N'
1064: AND rowidtochar(rowid) = l_rowid

Line 1240: FROM oe_headers_iface_all

1236:
1237:
1238: SELECT closed_flag
1239: INTO l_closed_flag
1240: FROM oe_headers_iface_all
1241: WHERE orig_sys_document_ref = p_orig_sys_document_ref
1242: AND order_source_id = p_order_source_id
1243: AND nvl(sold_to_org_id, -999) = nvl(p_sold_to_org_id, -999)
1244: AND nvl(sold_to_org, ' ') = nvl(p_sold_to_org, ' ')