DBA Data[Home] [Help]

APPS.OPIMPXWI dependencies on OPIMPXIN

Line 855: OPIMPXIN.calc_wip_completion( l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
857: EDW_LOG.PUT_LINE('End time: ' ||
858: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
859:

Line 877: OPIMPXIN.calc_wip_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
879: EDW_LOG.PUT_LINE('End time: ' ||
880: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
881:

Line 897: OPIMPXIN.calc_assembly_return(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
899: EDW_LOG.PUT_LINE('End time: ' ||
900: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
901:

Line 917: OPIMPXIN.calc_po_deliveries(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
919: EDW_LOG.PUT_LINE('End time: ' ||
920: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
921:

Line 937: OPIMPXIN.calc_value_to_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
939: EDW_LOG.PUT_LINE('End time: ' ||
940: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
941:

Line 957: OPIMPXIN.calc_value_from_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
959: EDW_LOG.PUT_LINE('End time: ' ||
960: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
961:

Line 977: OPIMPXIN.calc_customer_shipment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
979: EDW_LOG.PUT_LINE('End time: ' ||
980: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
981:

Line 997: OPIMPXIN.calc_inv_adjustment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
999: EDW_LOG.PUT_LINE('End time: ' ||
1000: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1001:

Line 1017: OPIMPXIN.calc_total_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
1019: EDW_LOG.PUT_LINE('End time: ' ||
1020: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1021:

Line 1037: OPIMPXIN.calc_total_receipt(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

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;
1039: EDW_LOG.PUT_LINE('End time: ' ||
1040: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1041:

Line 1726: OPIMPXIN.Insert_update_push_log(

1722:
1723:
1724: l_statement := 4;
1725:
1726: OPIMPXIN.Insert_update_push_log(
1727: p_trx_date => p_trx_date ,
1728: p_organization_id => p_organization_id,
1729: p_item_id => p_item_id,
1730: p_cost_group_id => p_cost_group_id,

Line 2275: OPIMPXIN.Insert_update_push_log(

2271: FROM mtl_system_items
2272: WHERE inventory_item_id=l_item_id
2273: AND organization_id = Org_id;
2274:
2275: OPIMPXIN.Insert_update_push_log(
2276: p_trx_date => p_from_date ,
2277: p_organization_id => Org_id,
2278: p_item_id => l_item_id,
2279: p_cost_group_id => l_cost_group_id,