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.OPIMPXWI dependencies on DUAL

Line 484: select sysdate into l_print_date from dual;

480:
481: -- Make sure from and to date are not null
482:
483: EDW_LOG.PUT_LINE('At start EXTRACT IDS LOG');
484: select sysdate into l_print_date from dual;
485: EDW_LOG.PUT_LINE('Start time: ' ||
486: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
487:
488: if p_from_date is null then -- check from date

Line 613: select sysdate into l_print_date from dual;

609:
610: l_statement := 30;
611:
612: EDW_LOG.PUT_LINE('Calling OPIMPDAT.get_push_dates ...');
613: select sysdate into l_print_date from dual;
614: EDW_LOG.PUT_LINE('Start time: ' ||
615: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
616:
617: OPIMPDAT.get_push_dates(

Line 634: select sysdate into l_print_date from dual;

630: l_errnum,
631: l_retcode,
632: l_errbuf,
633: l_txn_flag);
634: select sysdate into l_print_date from dual;
635: EDW_LOG.PUT_LINE('End time: ' ||
636: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
637:
638: if l_errnum <> 0 THEN

Line 669: select sysdate into l_print_date from dual;

665: which include the lastest pushed transaction date will not be purged.
666: --------------------------------------------------------------------*/
667: l_statement := 40;
668: EDW_LOG.PUT_LINE('Calling purge_opi_ids_push_log ...');
669: select sysdate into l_print_date from dual;
670: EDW_LOG.PUT_LINE('Start time: ' ||
671: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
672:
673: -- if we are running across periods, then we must not only recompute

Line 699: select sysdate into l_print_date from dual;

695: l_errnum,
696: l_retcode,
697: l_errbuf);
698:
699: select sysdate into l_print_date from dual;
700: EDW_LOG.PUT_LINE('End time: ' ||
701: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
702:
703: if l_errnum <> 0 then

Line 761: select sysdate into l_print_date from dual;

757:
758: END ;
759:
760: EDW_LOG.PUT_LINE('Calling calc_begin_inv ...');
761: select sysdate into l_print_date from dual;
762: EDW_LOG.PUT_LINE('Start time: ' ||
763: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
764:
765: calc_begin_inv(inv_from_date, org_id,status);

Line 766: select sysdate into l_print_date from dual;

762: EDW_LOG.PUT_LINE('Start time: ' ||
763: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
764:
765: calc_begin_inv(inv_from_date, org_id,status);
766: select sysdate into l_print_date from dual;
767: EDW_LOG.PUT_LINE('End time: ' ||
768: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
769:
770: if status > 0 then

Line 799: select sysdate into l_print_date from dual;

795: end if;
796:
797:
798: EDW_LOG.PUT_LINE('Calling calc_inv_balance ...');
799: select sysdate into l_print_date from dual;
800: EDW_LOG.PUT_LINE('Start time: ' ||
801: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
802: -- ------------------------------------------------------------------
803: -- Calling calc_inv_balance to calculate the Inv daily balance

Line 818: select sysdate into l_print_date from dual;

814: calc_inv_balance(inv_from_date,
815: to_date,org_id,
816: status);
817: END IF;
818: select sysdate into l_print_date from dual;
819: EDW_LOG.PUT_LINE('End time: ' ||
820: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
821:
822: if status > 0 then

Line 852: select sysdate into l_print_date from dual;

848: -- for each organization
849: --
850: -- --------------------------------------------------------------
851: EDW_LOG.PUT_LINE ('Calling calc_wip_completion ....');
852: select sysdate into l_print_date from dual;
853: EDW_LOG.PUT_LINE('Start time: ' ||
854: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
855: OPIMPXIN.calc_wip_completion( l_errbuf,l_retcode,inv_from_date,to_date,org_id);
856: select sysdate into l_print_date from dual;

Line 856: select sysdate into l_print_date from dual;

852: select sysdate into l_print_date from dual;
853: EDW_LOG.PUT_LINE('Start time: ' ||
854: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
855: OPIMPXIN.calc_wip_completion( l_errbuf,l_retcode,inv_from_date,to_date,org_id);
856: select sysdate into l_print_date from dual;
857: EDW_LOG.PUT_LINE('End time: ' ||
858: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
859:
860: if l_retcode = '2' then

Line 874: select sysdate into l_print_date from dual;

870:
871:
872:
873: EDW_LOG.PUT_LINE ('Calling calc_wip_issue ....');
874: select sysdate into l_print_date from dual;
875: EDW_LOG.PUT_LINE('Start time: ' ||
876: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
877: OPIMPXIN.calc_wip_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
878: select sysdate into l_print_date from dual;

Line 878: select sysdate into l_print_date from dual;

874: select sysdate into l_print_date from dual;
875: EDW_LOG.PUT_LINE('Start time: ' ||
876: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
877: OPIMPXIN.calc_wip_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
878: select sysdate into l_print_date from dual;
879: EDW_LOG.PUT_LINE('End time: ' ||
880: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
881:
882: if l_retcode = '2' then

Line 894: select sysdate into l_print_date from dual;

890: goto next_org;
891: end if;
892:
893: EDW_LOG.PUT_LINE ('Calling calc_assembly_return ....');
894: select sysdate into l_print_date from dual;
895: EDW_LOG.PUT_LINE('Start time: ' ||
896: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
897: OPIMPXIN.calc_assembly_return(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
898: select sysdate into l_print_date from dual;

Line 898: select sysdate into l_print_date from dual;

894: select sysdate into l_print_date from dual;
895: EDW_LOG.PUT_LINE('Start time: ' ||
896: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
897: OPIMPXIN.calc_assembly_return(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
898: select sysdate into l_print_date from dual;
899: EDW_LOG.PUT_LINE('End time: ' ||
900: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
901:
902: if l_retcode = '2' then

Line 914: select sysdate into l_print_date from dual;

910: goto next_org;
911: end if;
912:
913: EDW_LOG.PUT_LINE ('Calling calc_po_deliveries ....');
914: select sysdate into l_print_date from dual;
915: EDW_LOG.PUT_LINE('Start time: ' ||
916: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
917: OPIMPXIN.calc_po_deliveries(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
918: select sysdate into l_print_date from dual;

Line 918: select sysdate into l_print_date from dual;

914: select sysdate into l_print_date from dual;
915: EDW_LOG.PUT_LINE('Start time: ' ||
916: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
917: OPIMPXIN.calc_po_deliveries(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
918: select sysdate into l_print_date from dual;
919: EDW_LOG.PUT_LINE('End time: ' ||
920: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
921:
922: if l_retcode = '2' then

Line 934: select sysdate into l_print_date from dual;

930: goto next_org;
931: end if;
932:
933: EDW_LOG.PUT_LINE ('Calling calc_value_to_orgs ....');
934: select sysdate into l_print_date from dual;
935: EDW_LOG.PUT_LINE('Start time: ' ||
936: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
937: OPIMPXIN.calc_value_to_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
938: select sysdate into l_print_date from dual;

Line 938: select sysdate into l_print_date from dual;

934: select sysdate into l_print_date from dual;
935: EDW_LOG.PUT_LINE('Start time: ' ||
936: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
937: OPIMPXIN.calc_value_to_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
938: select sysdate into l_print_date from dual;
939: EDW_LOG.PUT_LINE('End time: ' ||
940: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
941:
942: if l_retcode = '2' then

Line 954: select sysdate into l_print_date from dual;

950: goto next_org;
951: end if;
952:
953: EDW_LOG.PUT_LINE ('Calling calc_value_from_orgs ....');
954: select sysdate into l_print_date from dual;
955: EDW_LOG.PUT_LINE('Start time: ' ||
956: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
957: OPIMPXIN.calc_value_from_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
958: select sysdate into l_print_date from dual;

Line 958: select sysdate into l_print_date from dual;

954: select sysdate into l_print_date from dual;
955: EDW_LOG.PUT_LINE('Start time: ' ||
956: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
957: OPIMPXIN.calc_value_from_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
958: select sysdate into l_print_date from dual;
959: EDW_LOG.PUT_LINE('End time: ' ||
960: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
961:
962: if l_retcode = '2' then

Line 974: select sysdate into l_print_date from dual;

970: goto next_org;
971: end if;
972:
973: EDW_LOG.PUT_LINE ('Calling calc_customer_shipment ....');
974: select sysdate into l_print_date from dual;
975: EDW_LOG.PUT_LINE('Start time: ' ||
976: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
977: OPIMPXIN.calc_customer_shipment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
978: select sysdate into l_print_date from dual;

Line 978: select sysdate into l_print_date from dual;

974: select sysdate into l_print_date from dual;
975: EDW_LOG.PUT_LINE('Start time: ' ||
976: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
977: OPIMPXIN.calc_customer_shipment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
978: select sysdate into l_print_date from dual;
979: EDW_LOG.PUT_LINE('End time: ' ||
980: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
981:
982: if l_retcode = '2' then

Line 994: select sysdate into l_print_date from dual;

990: goto next_org;
991: end if;
992:
993: EDW_LOG.PUT_LINE ('Calling calc_inv_adjustment ....');
994: select sysdate into l_print_date from dual;
995: EDW_LOG.PUT_LINE('Start time: ' ||
996: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
997: OPIMPXIN.calc_inv_adjustment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
998: select sysdate into l_print_date from dual;

Line 998: select sysdate into l_print_date from dual;

994: select sysdate into l_print_date from dual;
995: EDW_LOG.PUT_LINE('Start time: ' ||
996: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
997: OPIMPXIN.calc_inv_adjustment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
998: select sysdate into l_print_date from dual;
999: EDW_LOG.PUT_LINE('End time: ' ||
1000: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1001:
1002: if l_retcode = '2' then

Line 1014: select sysdate into l_print_date from dual;

1010: goto next_org;
1011: end if;
1012:
1013: EDW_LOG.PUT_LINE ('Calling calc_total_issue ....');
1014: select sysdate into l_print_date from dual;
1015: EDW_LOG.PUT_LINE('Start time: ' ||
1016: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1017: OPIMPXIN.calc_total_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
1018: select sysdate into l_print_date from dual;

Line 1018: select sysdate into l_print_date from dual;

1014: select sysdate into l_print_date from dual;
1015: EDW_LOG.PUT_LINE('Start time: ' ||
1016: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1017: OPIMPXIN.calc_total_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
1018: select sysdate into l_print_date from dual;
1019: EDW_LOG.PUT_LINE('End time: ' ||
1020: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1021:
1022: if l_retcode = '2' then

Line 1034: select sysdate into l_print_date from dual;

1030: goto next_org;
1031: end if;
1032:
1033: EDW_LOG.PUT_LINE ('Calling calc_total_receipt ....');
1034: select sysdate into l_print_date from dual;
1035: EDW_LOG.PUT_LINE('Start time: ' ||
1036: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1037: OPIMPXIN.calc_total_receipt(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
1038: select sysdate into l_print_date from dual;

Line 1038: select sysdate into l_print_date from dual;

1034: select sysdate into l_print_date from dual;
1035: EDW_LOG.PUT_LINE('Start time: ' ||
1036: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1037: OPIMPXIN.calc_total_receipt(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
1038: select sysdate into l_print_date from dual;
1039: EDW_LOG.PUT_LINE('End time: ' ||
1040: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1041:
1042: if l_retcode = '2' then

Line 1056: select sysdate into l_print_date from dual;

1052:
1053: END IF; -- end of calculating activity measures based on profile option
1054:
1055: EDW_LOG.PUT_LINE ('Calling calc_intrst_balance ....');
1056: select sysdate into l_print_date from dual;
1057: EDW_LOG.PUT_LINE('Start time: ' ||
1058: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1059: calc_intrst_balance(inv_from_date,to_date,org_id,status);
1060: select sysdate into l_print_date from dual;

Line 1060: select sysdate into l_print_date from dual;

1056: select sysdate into l_print_date from dual;
1057: EDW_LOG.PUT_LINE('Start time: ' ||
1058: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1059: calc_intrst_balance(inv_from_date,to_date,org_id,status);
1060: select sysdate into l_print_date from dual;
1061: EDW_LOG.PUT_LINE('End time: ' ||
1062: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1063:
1064: if status > 0 then

Line 1085: select sysdate into l_print_date from dual;

1081: -- Call wip procedure regardless of l_txn_flag, because both MMT
1082: -- and WT must be accumulated for WIP balances.
1083:
1084: EDW_LOG.PUT_LINE('Calling OPIMPXWP.calc_wip_balance ...');
1085: select sysdate into l_print_date from dual;
1086: EDW_LOG.PUT_LINE('Start time: ' ||
1087: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1088: OPIMPXWP.calc_wip_balance(org_id,
1089: inv_from_date,

Line 1098: select sysdate into l_print_date from dual;

1094: l_first_push,
1095: l_errnum,
1096: l_retcode,
1097: l_errbuf);
1098: select sysdate into l_print_date from dual;
1099: EDW_LOG.PUT_LINE('End time: ' ||
1100: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1101:
1102: if l_errnum <> 0 then

Line 1117: select sysdate into l_print_date from dual;

1113: --
1114: -- ------------------------------------------------------------------
1115:
1116: EDW_LOG.PUT_LINE ('Calling calc_prd_start_end ....');
1117: select sysdate into l_print_date from dual;
1118: EDW_LOG.PUT_LINE('Start time: ' ||
1119: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1120: opi_edw_ids_calc.calc_prd_start_end ( inv_from_date,
1121: to_date,

Line 1124: select sysdate into l_print_date from dual;

1120: opi_edw_ids_calc.calc_prd_start_end ( inv_from_date,
1121: to_date,
1122: org_id,
1123: status);
1124: select sysdate into l_print_date from dual;
1125: EDW_LOG.PUT_LINE('End time: ' ||
1126: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1127:
1128: if status > 0 then

Line 1167: select sysdate into l_print_date from dual;

1163:
1164: end loop; -- end c_inv_org loop
1165:
1166: EDW_LOG.PUT_LINE ('Done with inv balance extraction in opi_extract_ids.'); -- Remove . for bug 3556719
1167: select sysdate into l_print_date from dual;
1168: EDW_LOG.PUT_LINE('End time: ' ||
1169: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1170:
1171: EXCEPTION