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.MSC_CL_PRE_PROCESS dependencies on MSC_ST_SUPPLIES

Line 564: 'create index MSC_ST_SUPPLIES_N1_'||v_instance_code

560: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
561: application_short_name => 'MSC',
562: statement_type => AD_DDL.CREATE_INDEX,
563: statement =>
564: 'create index MSC_ST_SUPPLIES_N1_'||v_instance_code
565: ||' on MSC_ST_SUPPLIES '
566: ||'(SR_INSTANCE_CODE, ORDER_NUMBER, PURCH_LINE_NUM, ORDER_TYPE, COMPANY_NAME) '
567: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
568: object_name =>'MSC_ST_SUPPLIES_N1_'||v_instance_code);

Line 565: ||' on MSC_ST_SUPPLIES '

561: application_short_name => 'MSC',
562: statement_type => AD_DDL.CREATE_INDEX,
563: statement =>
564: 'create index MSC_ST_SUPPLIES_N1_'||v_instance_code
565: ||' on MSC_ST_SUPPLIES '
566: ||'(SR_INSTANCE_CODE, ORDER_NUMBER, PURCH_LINE_NUM, ORDER_TYPE, COMPANY_NAME) '
567: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
568: object_name =>'MSC_ST_SUPPLIES_N1_'||v_instance_code);
569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N1_'||v_instance_code);

Line 568: object_name =>'MSC_ST_SUPPLIES_N1_'||v_instance_code);

564: 'create index MSC_ST_SUPPLIES_N1_'||v_instance_code
565: ||' on MSC_ST_SUPPLIES '
566: ||'(SR_INSTANCE_CODE, ORDER_NUMBER, PURCH_LINE_NUM, ORDER_TYPE, COMPANY_NAME) '
567: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
568: object_name =>'MSC_ST_SUPPLIES_N1_'||v_instance_code);
569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N1_'||v_instance_code);
570:
571: EXCEPTION
572: WHEN OTHERS THEN

Line 569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N1_'||v_instance_code);

565: ||' on MSC_ST_SUPPLIES '
566: ||'(SR_INSTANCE_CODE, ORDER_NUMBER, PURCH_LINE_NUM, ORDER_TYPE, COMPANY_NAME) '
567: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
568: object_name =>'MSC_ST_SUPPLIES_N1_'||v_instance_code);
569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N1_'||v_instance_code);
570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));

Line 573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));

569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N1_'||v_instance_code);
570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));
574: END;
575:
576: BEGIN
577: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 581: 'create index MSC_ST_SUPPLIES_N2_'||v_instance_code

577: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
578: application_short_name => 'MSC',
579: statement_type => AD_DDL.CREATE_INDEX,
580: statement =>
581: 'create index MSC_ST_SUPPLIES_N2_'||v_instance_code
582: ||' on MSC_ST_SUPPLIES '
583: ||'(sr_instance_code, schedule_line_num, schedule_designator, organization_code, order_type, company_name) '
584: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
585: object_name =>'MSC_ST_SUPPLIES_N2_'||v_instance_code);

Line 582: ||' on MSC_ST_SUPPLIES '

578: application_short_name => 'MSC',
579: statement_type => AD_DDL.CREATE_INDEX,
580: statement =>
581: 'create index MSC_ST_SUPPLIES_N2_'||v_instance_code
582: ||' on MSC_ST_SUPPLIES '
583: ||'(sr_instance_code, schedule_line_num, schedule_designator, organization_code, order_type, company_name) '
584: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
585: object_name =>'MSC_ST_SUPPLIES_N2_'||v_instance_code);
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N2_'||v_instance_code);

Line 585: object_name =>'MSC_ST_SUPPLIES_N2_'||v_instance_code);

581: 'create index MSC_ST_SUPPLIES_N2_'||v_instance_code
582: ||' on MSC_ST_SUPPLIES '
583: ||'(sr_instance_code, schedule_line_num, schedule_designator, organization_code, order_type, company_name) '
584: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
585: object_name =>'MSC_ST_SUPPLIES_N2_'||v_instance_code);
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N2_'||v_instance_code);
587:
588: EXCEPTION
589: WHEN OTHERS THEN

Line 586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N2_'||v_instance_code);

582: ||' on MSC_ST_SUPPLIES '
583: ||'(sr_instance_code, schedule_line_num, schedule_designator, organization_code, order_type, company_name) '
584: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
585: object_name =>'MSC_ST_SUPPLIES_N2_'||v_instance_code);
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N2_'||v_instance_code);
587:
588: EXCEPTION
589: WHEN OTHERS THEN
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Created Index MSC_ST_SUPPLIES_N2_'||v_instance_code);
587:
588: EXCEPTION
589: WHEN OTHERS THEN
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
591: END;
592:
593: BEGIN
594: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 598: 'create index MSC_ST_SUPPLIES_N3_'||v_instance_code

594: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
595: application_short_name => 'MSC',
596: statement_type => AD_DDL.CREATE_INDEX,
597: statement =>
598: 'create index MSC_ST_SUPPLIES_N3_'||v_instance_code
599: ||' on MSC_ST_SUPPLIES '
600: ||'(sr_instance_code, item_name, organization_code, order_type, company_name) '
601: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
602: object_name =>'MSC_ST_SUPPLIES_N3_'||v_instance_code);

Line 599: ||' on MSC_ST_SUPPLIES '

595: application_short_name => 'MSC',
596: statement_type => AD_DDL.CREATE_INDEX,
597: statement =>
598: 'create index MSC_ST_SUPPLIES_N3_'||v_instance_code
599: ||' on MSC_ST_SUPPLIES '
600: ||'(sr_instance_code, item_name, organization_code, order_type, company_name) '
601: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
602: object_name =>'MSC_ST_SUPPLIES_N3_'||v_instance_code);
603:

Line 602: object_name =>'MSC_ST_SUPPLIES_N3_'||v_instance_code);

598: 'create index MSC_ST_SUPPLIES_N3_'||v_instance_code
599: ||' on MSC_ST_SUPPLIES '
600: ||'(sr_instance_code, item_name, organization_code, order_type, company_name) '
601: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
602: object_name =>'MSC_ST_SUPPLIES_N3_'||v_instance_code);
603:
604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N3_'||v_instance_code);
605:
606:

Line 604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N3_'||v_instance_code);

600: ||'(sr_instance_code, item_name, organization_code, order_type, company_name) '
601: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
602: object_name =>'MSC_ST_SUPPLIES_N3_'||v_instance_code);
603:
604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N3_'||v_instance_code);
605:
606:
607: EXCEPTION
608: WHEN OTHERS THEN

Line 609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

605:
606:
607: EXCEPTION
608: WHEN OTHERS THEN
609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
610: END;
611:
612: BEGIN
613: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 617: 'create index MSC_ST_SUPPLIES_N4_'||v_instance_code

613: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
614: application_short_name => 'MSC',
615: statement_type => AD_DDL.CREATE_INDEX,
616: statement =>
617: 'create index MSC_ST_SUPPLIES_N4_'||v_instance_code
618: ||' on MSC_ST_SUPPLIES '
619: ||'(sr_instance_code,wip_entity_name, organization_code,order_type, company_name) '
620: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
621: object_name =>'MSC_ST_SUPPLIES_N4_'||v_instance_code);

Line 618: ||' on MSC_ST_SUPPLIES '

614: application_short_name => 'MSC',
615: statement_type => AD_DDL.CREATE_INDEX,
616: statement =>
617: 'create index MSC_ST_SUPPLIES_N4_'||v_instance_code
618: ||' on MSC_ST_SUPPLIES '
619: ||'(sr_instance_code,wip_entity_name, organization_code,order_type, company_name) '
620: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
621: object_name =>'MSC_ST_SUPPLIES_N4_'||v_instance_code);
622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N4_'||v_instance_code);

Line 621: object_name =>'MSC_ST_SUPPLIES_N4_'||v_instance_code);

617: 'create index MSC_ST_SUPPLIES_N4_'||v_instance_code
618: ||' on MSC_ST_SUPPLIES '
619: ||'(sr_instance_code,wip_entity_name, organization_code,order_type, company_name) '
620: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
621: object_name =>'MSC_ST_SUPPLIES_N4_'||v_instance_code);
622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N4_'||v_instance_code);
623:
624:
625: EXCEPTION

Line 622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N4_'||v_instance_code);

618: ||' on MSC_ST_SUPPLIES '
619: ||'(sr_instance_code,wip_entity_name, organization_code,order_type, company_name) '
620: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
621: object_name =>'MSC_ST_SUPPLIES_N4_'||v_instance_code);
622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N4_'||v_instance_code);
623:
624:
625: EXCEPTION
626: WHEN OTHERS THEN

Line 627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N4_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

623:
624:
625: EXCEPTION
626: WHEN OTHERS THEN
627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N4_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
628: END;
629:
630: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUPPLIES', v_instance_id, -1);
631:

Line 630: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUPPLIES', v_instance_id, -1);

626: WHEN OTHERS THEN
627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N4_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
628: END;
629:
630: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUPPLIES', v_instance_id, -1);
631:
632: END IF;
633:
634: IF v_mat_dmd_enabled = SYS_YES THEN

Line 1704: 'create index MSC_ST_SUPPLIES_N5_'||v_instance_code

1700: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1701: application_short_name => 'MSC',
1702: statement_type => AD_DDL.CREATE_INDEX,
1703: statement =>
1704: 'create index MSC_ST_SUPPLIES_N5_'||v_instance_code
1705: ||' on MSC_ST_SUPPLIES '
1706: ||' (batch_id, order_type, sr_instance_code, deleted_flag) '
1707: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1708: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);

Line 1705: ||' on MSC_ST_SUPPLIES '

1701: application_short_name => 'MSC',
1702: statement_type => AD_DDL.CREATE_INDEX,
1703: statement =>
1704: 'create index MSC_ST_SUPPLIES_N5_'||v_instance_code
1705: ||' on MSC_ST_SUPPLIES '
1706: ||' (batch_id, order_type, sr_instance_code, deleted_flag) '
1707: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1708: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);
1709:

Line 1708: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);

1704: 'create index MSC_ST_SUPPLIES_N5_'||v_instance_code
1705: ||' on MSC_ST_SUPPLIES '
1706: ||' (batch_id, order_type, sr_instance_code, deleted_flag) '
1707: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1708: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);
1709:
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N5_'||v_instance_code);
1711:
1712: EXCEPTION

Line 1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N5_'||v_instance_code);

1706: ||' (batch_id, order_type, sr_instance_code, deleted_flag) '
1707: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1708: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);
1709:
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N5_'||v_instance_code);
1711:
1712: EXCEPTION
1713: WHEN OTHERS THEN
1714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N5_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 1714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N5_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SUPPLIES_N5_'||v_instance_code);
1711:
1712: EXCEPTION
1713: WHEN OTHERS THEN
1714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N5_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1715: END;
1716:
1717: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUPPLIES', v_instance_id, -1);
1718:

Line 1717: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUPPLIES', v_instance_id, -1);

1713: WHEN OTHERS THEN
1714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N5_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1715: END;
1716:
1717: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUPPLIES', v_instance_id, -1);
1718:
1719: ELSIF p_batch_index = 'DEMAND' THEN
1720:
1721: BEGIN

Line 1836: 'drop index MSC_ST_SUPPLIES_N1_'||v_instance_code,

1832: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1833: application_short_name => 'MSC',
1834: statement_type => AD_DDL.DROP_INDEX,
1835: statement =>
1836: 'drop index MSC_ST_SUPPLIES_N1_'||v_instance_code,
1837: object_name => 'MSC_ST_SUPPLIES_N1_'||v_instance_code);
1838:
1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N1_'||v_instance_code);
1840:

Line 1837: object_name => 'MSC_ST_SUPPLIES_N1_'||v_instance_code);

1833: application_short_name => 'MSC',
1834: statement_type => AD_DDL.DROP_INDEX,
1835: statement =>
1836: 'drop index MSC_ST_SUPPLIES_N1_'||v_instance_code,
1837: object_name => 'MSC_ST_SUPPLIES_N1_'||v_instance_code);
1838:
1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N1_'||v_instance_code);
1840:
1841: EXCEPTION

Line 1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N1_'||v_instance_code);

1835: statement =>
1836: 'drop index MSC_ST_SUPPLIES_N1_'||v_instance_code,
1837: object_name => 'MSC_ST_SUPPLIES_N1_'||v_instance_code);
1838:
1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N1_'||v_instance_code);
1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 1843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N1_'||v_instance_code);
1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1844: END;
1845:
1846: BEGIN
1847: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 1851: 'drop index MSC_ST_SUPPLIES_N2_'||v_instance_code,

1847: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1848: application_short_name => 'MSC',
1849: statement_type => AD_DDL.DROP_INDEX,
1850: statement =>
1851: 'drop index MSC_ST_SUPPLIES_N2_'||v_instance_code,
1852: object_name => 'MSC_ST_SUPPLIES_N2_'||v_instance_code);
1853:
1854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N2_'||v_instance_code);
1855: EXCEPTION

Line 1852: object_name => 'MSC_ST_SUPPLIES_N2_'||v_instance_code);

1848: application_short_name => 'MSC',
1849: statement_type => AD_DDL.DROP_INDEX,
1850: statement =>
1851: 'drop index MSC_ST_SUPPLIES_N2_'||v_instance_code,
1852: object_name => 'MSC_ST_SUPPLIES_N2_'||v_instance_code);
1853:
1854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N2_'||v_instance_code);
1855: EXCEPTION
1856: WHEN OTHERS THEN

Line 1854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N2_'||v_instance_code);

1850: statement =>
1851: 'drop index MSC_ST_SUPPLIES_N2_'||v_instance_code,
1852: object_name => 'MSC_ST_SUPPLIES_N2_'||v_instance_code);
1853:
1854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N2_'||v_instance_code);
1855: EXCEPTION
1856: WHEN OTHERS THEN
1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1858: END;

Line 1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1853:
1854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N2_'||v_instance_code);
1855: EXCEPTION
1856: WHEN OTHERS THEN
1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1858: END;
1859:
1860: BEGIN
1861: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 1865: 'drop index MSC_ST_SUPPLIES_N3_'||v_instance_code,

1861: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1862: application_short_name => 'MSC',
1863: statement_type => AD_DDL.DROP_INDEX,
1864: statement =>
1865: 'drop index MSC_ST_SUPPLIES_N3_'||v_instance_code,
1866: object_name => 'MSC_ST_SUPPLIES_N3_'||v_instance_code);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N3_'||v_instance_code);
1869: EXCEPTION

Line 1866: object_name => 'MSC_ST_SUPPLIES_N3_'||v_instance_code);

1862: application_short_name => 'MSC',
1863: statement_type => AD_DDL.DROP_INDEX,
1864: statement =>
1865: 'drop index MSC_ST_SUPPLIES_N3_'||v_instance_code,
1866: object_name => 'MSC_ST_SUPPLIES_N3_'||v_instance_code);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N3_'||v_instance_code);
1869: EXCEPTION
1870: WHEN OTHERS THEN

Line 1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N3_'||v_instance_code);

1864: statement =>
1865: 'drop index MSC_ST_SUPPLIES_N3_'||v_instance_code,
1866: object_name => 'MSC_ST_SUPPLIES_N3_'||v_instance_code);
1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N3_'||v_instance_code);
1869: EXCEPTION
1870: WHEN OTHERS THEN
1871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1872: END;

Line 1871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1867:
1868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N3_'||v_instance_code);
1869: EXCEPTION
1870: WHEN OTHERS THEN
1871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1872: END;
1873:
1874: BEGIN
1875: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 1879: 'drop index MSC_ST_SUPPLIES_N4_'||v_instance_code,

1875: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1876: application_short_name => 'MSC',
1877: statement_type => AD_DDL.DROP_INDEX,
1878: statement =>
1879: 'drop index MSC_ST_SUPPLIES_N4_'||v_instance_code,
1880: object_name => 'MSC_ST_SUPPLIES_N4_'||v_instance_code);
1881:
1882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N4_'||v_instance_code);
1883: EXCEPTION

Line 1880: object_name => 'MSC_ST_SUPPLIES_N4_'||v_instance_code);

1876: application_short_name => 'MSC',
1877: statement_type => AD_DDL.DROP_INDEX,
1878: statement =>
1879: 'drop index MSC_ST_SUPPLIES_N4_'||v_instance_code,
1880: object_name => 'MSC_ST_SUPPLIES_N4_'||v_instance_code);
1881:
1882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N4_'||v_instance_code);
1883: EXCEPTION
1884: WHEN OTHERS THEN

Line 1882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N4_'||v_instance_code);

1878: statement =>
1879: 'drop index MSC_ST_SUPPLIES_N4_'||v_instance_code,
1880: object_name => 'MSC_ST_SUPPLIES_N4_'||v_instance_code);
1881:
1882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N4_'||v_instance_code);
1883: EXCEPTION
1884: WHEN OTHERS THEN
1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N4_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1886: END;

Line 1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N4_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1881:
1882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N4_'||v_instance_code);
1883: EXCEPTION
1884: WHEN OTHERS THEN
1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N4_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1886: END;
1887:
1888: BEGIN
1889: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 1893: 'drop index MSC_ST_SUPPLIES_N5_'||v_instance_code,

1889: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1890: application_short_name => 'MSC',
1891: statement_type => AD_DDL.DROP_INDEX,
1892: statement =>
1893: 'drop index MSC_ST_SUPPLIES_N5_'||v_instance_code,
1894: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);
1895:
1896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N5_'||v_instance_code);
1897:

Line 1894: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);

1890: application_short_name => 'MSC',
1891: statement_type => AD_DDL.DROP_INDEX,
1892: statement =>
1893: 'drop index MSC_ST_SUPPLIES_N5_'||v_instance_code,
1894: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);
1895:
1896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N5_'||v_instance_code);
1897:
1898: EXCEPTION

Line 1896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N5_'||v_instance_code);

1892: statement =>
1893: 'drop index MSC_ST_SUPPLIES_N5_'||v_instance_code,
1894: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);
1895:
1896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N5_'||v_instance_code);
1897:
1898: EXCEPTION
1899: WHEN OTHERS THEN
1900: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N5_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 1900: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N5_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SUPPLIES_N5_'||v_instance_code);
1897:
1898: EXCEPTION
1899: WHEN OTHERS THEN
1900: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N5_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1901: END;
1902:
1903: msc_analyse_tables_pk.analyse_table( 'MSC_LOCAL_ID_SUPPLY', v_instance_id, -1);
1904:

Line 29586: | records from the msc_st_supplies table. The following |

29582:
29583:
29584: /*==========================================================================+
29585: | DESCRIPTION : This procedure is called for validating supplies related |
29586: | records from the msc_st_supplies table. The following |
29587: | types are considered for the validation. |
29588: | Supply Source Order Type |
29589: | -------------------------------------------- |
29590: | Purchase Order 1 |

Line 29616: FROM msc_st_supplies

29612: PRAGMA EXCEPTION_INIT(busy, -54);
29613:
29614: CURSOR c1(p_batch_id NUMBER) IS
29615: SELECT rowid
29616: FROM msc_st_supplies
29617: WHERE order_type IN(1,2,5,8,11,12,18,73,74,87)
29618: AND process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
29619: AND NVL(batch_id,NULL_VALUE)=p_batch_id
29620: AND sr_instance_code = v_instance_code;

Line 29624: FROM msc_st_supplies

29620: AND sr_instance_code = v_instance_code;
29621:
29622: CURSOR c2(p_batch_id NUMBER) IS
29623: SELECT rowid
29624: FROM msc_st_supplies
29625: WHERE NVL(sr_mtl_supply_id,NULL_VALUE) = NULL_VALUE
29626: AND order_type IN(1,2,8,11,12,73,74,87)
29627: AND process_flag = G_IN_PROCESS
29628: AND NVL(batch_id,NULL_VALUE) =p_batch_id

Line 29633: FROM msc_st_supplies

29629: AND sr_instance_code = v_instance_code;
29630:
29631: CURSOR c3(p_batch_id NUMBER) IS
29632: SELECT max(rowid)
29633: FROM msc_st_supplies
29634: WHERE NVL(disposition_id,NULL_VALUE) = NULL_VALUE
29635: AND order_type IN(1,2,8,11,12,73,74,87)
29636: AND deleted_flag = SYS_NO
29637: AND process_flag = G_IN_PROCESS

Line 29644: FROM msc_st_supplies

29640: GROUP BY sr_instance_code,company_name,order_number,order_type;
29641:
29642: CURSOR c4(p_batch_id NUMBER) IS
29643: SELECT rowid
29644: FROM msc_st_supplies
29645: WHERE NVL(po_line_id,NULL_VALUE) = NULL_VALUE
29646: AND deleted_flag = SYS_NO
29647: AND order_type IN(1,2,8,11,12,73,74,87)
29648: AND process_flag = G_IN_PROCESS

Line 29654: FROM msc_st_supplies

29650: AND sr_instance_code = v_instance_code;
29651:
29652: CURSOR c5(p_batch_id NUMBER) IS
29653: SELECT rowid
29654: FROM msc_st_supplies
29655: WHERE NVL(disposition_id,NULL_VALUE) = NULL_VALUE
29656: AND order_type = 5
29657: AND process_flag = G_IN_PROCESS
29658: AND NVL(batch_id,NULL_VALUE) =p_batch_id

Line 29663: FROM msc_st_supplies

29659: AND sr_instance_code = v_instance_code;
29660:
29661: CURSOR c6(p_batch_id NUMBER) IS
29662: SELECT rowid
29663: FROM msc_st_supplies
29664: WHERE order_type = 18
29665: AND process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
29666: AND NVL(batch_id,NULL_VALUE)=p_batch_id
29667: AND sr_instance_code = v_instance_code;

Line 29671: FROM msc_st_supplies ms1 ,

29667: AND sr_instance_code = v_instance_code;
29668:
29669: CURSOR c_lock(p_batch_id NUMBER) IS
29670: SELECT 'X'
29671: FROM msc_st_supplies ms1 ,
29672: msc_st_supplies ms2
29673: WHERE ms1.batch_id = p_batch_id
29674: AND ms1.batch_id <> nvl(ms2.batch_id,NULL_VALUE)
29675: AND ms1.disposition_id IS NULL

Line 29672: msc_st_supplies ms2

29668:
29669: CURSOR c_lock(p_batch_id NUMBER) IS
29670: SELECT 'X'
29671: FROM msc_st_supplies ms1 ,
29672: msc_st_supplies ms2
29673: WHERE ms1.batch_id = p_batch_id
29674: AND ms1.batch_id <> nvl(ms2.batch_id,NULL_VALUE)
29675: AND ms1.disposition_id IS NULL
29676: AND ms2.disposition_id IS NULL

Line 29734: 'UPDATE msc_st_supplies '

29730: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
29731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
29732: v_sql_stmt := 2.0;
29733: lv_sql_stmt :=
29734: 'UPDATE msc_st_supplies '
29735: ||' SET process_flag = 1, '
29736: ||' batch_id = NULL'
29737: ||' WHERE batch_id = :p_batch_id'
29738: ||' AND order_type IN(1,2,8,11,12,73,74,87)'

Line 29753: 'UPDATE msc_st_supplies mss '

29749: END LOOP ;
29750:
29751: v_sql_stmt := 2.1;
29752: lv_sql_stmt :=
29753: 'UPDATE msc_st_supplies mss '
29754: ||' SET disposition_id = (SELECT local_id'
29755: ||' FROM msc_local_id_supply mls'
29756: ||' WHERE mls.char3 = mss.order_number'
29757: ||' AND mls.number1 = mss.order_type'

Line 29784: UPDATE msc_st_supplies

29780:
29781: IF c3%ROWCOUNT > 0 THEN
29782: v_sql_stmt := 3.0;
29783: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29784: UPDATE msc_st_supplies
29785: SET disposition_id = msc_st_disposition_id_s.NEXTVAL
29786: WHERE rowid = lb_rowid(j);
29787:
29788: v_sql_stmt := 3.1;

Line 29820: FROM msc_st_supplies

29816: v_current_date,
29817: v_current_user,
29818: v_current_date,
29819: v_current_user
29820: FROM msc_st_supplies
29821: WHERE rowid = lb_rowid(j);
29822: END IF;
29823: CLOSE c3 ;
29824:

Line 29827: 'UPDATE msc_st_supplies mss '

29823: CLOSE c3 ;
29824:
29825: v_sql_stmt := 4.0;
29826: lv_sql_stmt :=
29827: 'UPDATE msc_st_supplies mss '
29828: ||' SET disposition_id = (SELECT local_id'
29829: ||' FROM msc_local_id_supply mls'
29830: ||' WHERE mls.char3 = mss.order_number'
29831: ||' AND mls.number1 = mss.order_type'

Line 29863: UPDATE msc_st_supplies

29859: IF c1%ROWCOUNT > 0 THEN
29860:
29861: v_sql_stmt := 5.0;
29862: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29863: UPDATE msc_st_supplies
29864: SET st_transaction_id = msc_st_supplies_s.NEXTVAL,
29865: refresh_id = v_refresh_id,
29866: last_update_date = v_current_date,
29867: last_updated_by = v_current_user,

Line 29864: SET st_transaction_id = msc_st_supplies_s.NEXTVAL,

29860:
29861: v_sql_stmt := 5.0;
29862: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29863: UPDATE msc_st_supplies
29864: SET st_transaction_id = msc_st_supplies_s.NEXTVAL,
29865: refresh_id = v_refresh_id,
29866: last_update_date = v_current_date,
29867: last_updated_by = v_current_user,
29868: creation_date = v_current_date,

Line 29882: (p_table_name => 'MSC_ST_SUPPLIES',

29878:
29879: --Log a warning for those records where the deleted_flag has a value other
29880: --SYS_NO
29881: lv_return := MSC_ST_UTIL.LOG_ERROR
29882: (p_table_name => 'MSC_ST_SUPPLIES',
29883: p_instance_code => v_instance_code,
29884: p_row => lv_column_names,
29885: p_severity => G_SEV_WARNING,
29886: p_message_text => lv_message_text,

Line 29915: 'UPDATE msc_st_supplies '

29911: END IF;
29912:
29913: v_sql_stmt := 5.1;
29914: lv_sql_stmt :=
29915: 'UPDATE msc_st_supplies '
29916: ||' SET error_text = ''' || lv_message_text || ''','
29917: ||' process_flag = '||G_ERROR_FLG
29918: ||' WHERE NEED_BY_DATE is null '
29919: ||' AND PROMISED_DATE is null '

Line 29948: (p_table_name => 'MSC_ST_SUPPLIES',

29944: END IF;
29945:
29946: --Derive Organization_id
29947: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
29948: (p_table_name => 'MSC_ST_SUPPLIES',
29949: p_org_partner_name => 'ORGANIZATION_CODE',
29950: p_org_partner_id => 'ORGANIZATION_ID',
29951: p_instance_code => v_instance_code,
29952: p_partner_type => G_ORGANIZATION,

Line 29973: UPDATE msc_st_supplies mss

29969: IF c6%ROWCOUNT > 0 THEN
29970:
29971: v_sql_stmt := 2.2;
29972: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29973: UPDATE msc_st_supplies mss
29974: SET mss.condition_type = (SELECT nvl(msi.condition_type,'G' )
29975: FROM msc_sub_inventories msi
29976: WHERE msi.organization_id = mss.organization_id
29977: AND msi.plan_id = -1

Line 29992: UPDATE msc_st_supplies mss

29988: msc_util.initialize_common_globals (v_instance_id);
29989:
29990: v_sql_stmt := 2.3;
29991: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29992: UPDATE msc_st_supplies mss
29993: SET mss.ITEM_TYPE_ID = MSC_UTIL.G_PARTCONDN_ITEMTYPEID,
29994: mss.ITEM_TYPE_VALUE =DECODE(mss.condition_type,'G',MSC_UTIL.G_PARTCONDN_GOOD,'B',MSC_UTIL.G_PARTCONDN_BAD,MSC_UTIL.G_PARTCONDN_GOOD)
29995: WHERE rowid = lb_rowid(j);
29996:

Line 30014: UPDATE MSC_ST_SUPPLIES

30010: IF lv_return <> 0 THEN
30011: RAISE ex_logging_err;
30012: END IF;
30013:
30014: UPDATE MSC_ST_SUPPLIES
30015: SET PLANNING_PARTNER_SITE_ID = (SELECT local_id
30016: FROM msc_local_id_setup
30017: WHERE char1 = sr_instance_code
30018: AND NVL(char2,NULL_CHAR) = NVL(company_name,NULL_CHAR)

Line 30031: UPDATE MSC_ST_SUPPLIES

30027: AND ORDER_TYPE = 18;
30028:
30029:
30030:
30031: UPDATE MSC_ST_SUPPLIES
30032: SET PLANNING_PARTNER_SITE_ID = (SELECT local_id
30033: FROM msc_local_id_setup
30034: WHERE char1 = sr_instance_code
30035: AND char3 = PLANNING_PARTNER_SITE_CODE

Line 30045: UPDATE MSC_ST_SUPPLIES mss1

30041: AND process_flag = G_IN_PROCESS
30042: AND PLANNING_TP_TYPE = 2
30043: AND ORDER_TYPE =18;
30044:
30045: UPDATE MSC_ST_SUPPLIES mss1
30046: SET process_flag = G_ERROR_FLG,
30047: error_text = lv_message_text
30048: WHERE EXISTS( SELECT 1
30049: FROM MSC_ST_SUPPLIES mss2

Line 30049: FROM MSC_ST_SUPPLIES mss2

30045: UPDATE MSC_ST_SUPPLIES mss1
30046: SET process_flag = G_ERROR_FLG,
30047: error_text = lv_message_text
30048: WHERE EXISTS( SELECT 1
30049: FROM MSC_ST_SUPPLIES mss2
30050: WHERE mss2.sr_instance_code = mss1.sr_instance_code
30051: AND mss2.process_flag = G_IN_PROCESS
30052: AND NVL(mss2.planning_partner_site_id,NULL_VALUE) = NULL_VALUE
30053: GROUP BY sr_instance_code HAVING COUNT(*) > 0)

Line 30059: UPDATE MSC_ST_SUPPLIES

30055: AND mss1.sr_instance_code = v_instance_code
30056: AND NVL(mss1.planning_partner_site_id,NULL_VALUE) = NULL_VALUE
30057: AND ORDER_TYPE=18;
30058:
30059: UPDATE MSC_ST_SUPPLIES
30060: SET OWNING_PARTNER_SITE_ID = (SELECT local_id
30061: FROM msc_local_id_setup
30062: WHERE char1 = sr_instance_code
30063: AND NVL(char2,NULL_CHAR) = NVL(company_name,NULL_CHAR)

Line 30074: UPDATE MSC_ST_SUPPLIES

30070: AND process_flag = G_IN_PROCESS
30071: AND OWNING_TP_TYPE = 1
30072: AND ORDER_TYPE=18;
30073:
30074: UPDATE MSC_ST_SUPPLIES
30075: SET OWNING_PARTNER_SITE_ID = (SELECT local_id
30076: FROM msc_local_id_setup
30077: WHERE char1 = sr_instance_code
30078: AND char3 = OWNING_PARTNER_SITE_CODE

Line 30100: UPDATE MSC_ST_SUPPLIES mss1

30096: IF lv_return <> 0 THEN
30097: RAISE ex_logging_err;
30098: END IF;
30099:
30100: UPDATE MSC_ST_SUPPLIES mss1
30101: SET process_flag = G_ERROR_FLG,
30102: error_text = lv_message_text
30103: WHERE EXISTS( SELECT 1
30104: FROM MSC_ST_SUPPLIES mss2

Line 30104: FROM MSC_ST_SUPPLIES mss2

30100: UPDATE MSC_ST_SUPPLIES mss1
30101: SET process_flag = G_ERROR_FLG,
30102: error_text = lv_message_text
30103: WHERE EXISTS( SELECT 1
30104: FROM MSC_ST_SUPPLIES mss2
30105: WHERE mss2.sr_instance_code = mss1.sr_instance_code
30106: AND mss2.process_flag = G_IN_PROCESS
30107: AND NVL(mss2.owning_partner_site_id,NULL_VALUE) = NULL_VALUE
30108: GROUP BY sr_instance_code HAVING COUNT(*) > 0)

Line 30132: (p_table_name => 'MSC_ST_SUPPLIES',

30128: END IF;
30129:
30130: --Derive Inventory_item_id
30131: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
30132: (p_table_name => 'MSC_ST_SUPPLIES',
30133: p_item_col_name => 'ITEM_NAME',
30134: p_item_col_id => 'INVENTORY_ITEM_ID',
30135: p_instance_id => v_instance_id,
30136: p_instance_code => v_instance_code,

Line 30162: (p_table_name => 'MSC_ST_SUPPLIES',

30158: END IF;
30159:
30160: --Derive Supplier_id
30161: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
30162: (p_table_name => 'MSC_ST_SUPPLIES',
30163: p_org_partner_name => 'SUPPLIER_NAME',
30164: p_org_partner_id => 'SUPPLIER_ID',
30165: p_instance_code => v_instance_code,
30166: p_partner_type => G_VENDOR,

Line 30193: (p_table_name => 'MSC_ST_SUPPLIES',

30189: END IF;
30190:
30191: --Derive Supplier_site_id
30192: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
30193: (p_table_name => 'MSC_ST_SUPPLIES',
30194: p_partner_name => 'SUPPLIER_NAME',
30195: p_partner_site_code => 'SUPPLIER_SITE_CODE',
30196: p_partner_site_id => 'SUPPLIER_SITE_ID',
30197: p_instance_code => v_instance_code,

Line 30229: 'UPDATE msc_st_supplies '

30225: END IF;
30226:
30227: v_sql_stmt := 10;
30228: lv_sql_stmt :=
30229: 'UPDATE msc_st_supplies '
30230: ||' SET error_text = '||''''||lv_message_text||''''||','
30231: ||' process_flag = '||G_ERROR_FLG
30232: ||' WHERE (((NVL(order_number, '||''''||NULL_CHAR||''''||') '
30233: ||' = '||''''||NULL_CHAR||''''

Line 30283: (p_table_name => 'MSC_ST_SUPPLIES',

30279: ||' AND order_type IN(2,11,12,73,87)'
30280: ||' AND process_flag = '||G_IN_PROCESS;
30281:
30282: lv_return := MSC_ST_UTIL.LOG_ERROR
30283: (p_table_name => 'MSC_ST_SUPPLIES',
30284: p_instance_code => v_instance_code,
30285: p_row => lv_column_names,
30286: p_severity => G_SEV_WARNING,
30287: p_message_text => lv_message_text,

Line 30300: 'UPDATE msc_st_supplies '

30296: -- end
30297:
30298: /*
30299: lv_sql_stmt :=
30300: 'UPDATE msc_st_supplies '
30301: ||' SET process_flag = '||G_ERROR_FLG||','
30302: ||' error_text = '||''''||lv_message_text||''''
30303: ||' WHERE NVL(new_dock_date,SYSDATE-36500) > NVL(new_schedule_date,SYSDATE-36500)'
30304: ||' AND deleted_flag ='||SYS_NO

Line 30333: 'UPDATE msc_st_supplies'

30329:
30330: --Negative quantities are allowed only for the order type On-Hand(18)
30331: v_sql_stmt := 11;
30332: lv_sql_stmt :=
30333: 'UPDATE msc_st_supplies'
30334: ||' SET process_flag = '||G_ERROR_FLG||','
30335: ||' error_text = '||''''||lv_message_text||''''
30336: ||' WHERE new_order_quantity <= 0'
30337: ||' AND order_type <> 18'

Line 30364: p_token_value3 => 'MSC_ST_SUPPLIES');

30360: ||' DESIGNATOR',
30361: p_token2 => 'MASTER_TABLE',
30362: p_token_value2 => 'MSC_ST_DESIGNATORS',
30363: p_token3 => 'CHILD_TABLE',
30364: p_token_value3 => 'MSC_ST_SUPPLIES');
30365:
30366: IF lv_return <> 0 THEN
30367: RAISE ex_logging_err;
30368: END IF;

Line 30372: 'UPDATE msc_st_supplies mss'

30368: END IF;
30369:
30370: v_sql_stmt := 12;
30371: lv_sql_stmt :=
30372: 'UPDATE msc_st_supplies mss'
30373: ||' SET process_flag = '||G_ERROR_FLG||','
30374: ||' error_text = '||''''||lv_message_text||''''
30375: ||' WHERE NOT EXISTS(SELECT 1'
30376: ||' FROM msc_st_designators msd'

Line 30422: p_token_value3 => 'MSC_ST_SUPPLIES');

30418: p_token_value1 => 'SHIP_TO_PARTY_NAME',
30419: p_token2 => 'MASTER_TABLE',
30420: p_token_value2 => 'MSC_ST_DESIGNATORS',
30421: p_token3 => 'CHILD_TABLE',
30422: p_token_value3 => 'MSC_ST_SUPPLIES');
30423:
30424: IF lv_return <> 0 THEN
30425: RAISE ex_logging_err;
30426: END IF;

Line 30430: 'UPDATE msc_st_supplies '

30426: END IF;
30427:
30428: v_sql_stmt := 13;
30429: lv_sql_stmt :=
30430: 'UPDATE msc_st_supplies '
30431: ||' SET process_flag = '||G_ERROR_FLG||','
30432: ||' error_text = '||''''||lv_message_text||''''
30433: ||' WHERE NOT EXISTS (SELECT 1'
30434: ||' FROM hz_parties '

Line 30461: p_token_value3 => 'MSC_ST_SUPPLIES');

30457: ||' SHIP_TO_SITE_CODE',
30458: p_token2 => 'MASTER_TABLE',
30459: p_token_value2 => 'MSC_ST_DESIGNATORS',
30460: p_token3 => 'CHILD_TABLE',
30461: p_token_value3 => 'MSC_ST_SUPPLIES');
30462:
30463: IF lv_return <> 0 THEN
30464: RAISE ex_logging_err;
30465: END IF;

Line 30469: 'UPDATE msc_st_supplies ms'

30465: END IF;
30466:
30467: v_sql_stmt := 14;
30468: lv_sql_stmt :=
30469: 'UPDATE msc_st_supplies ms'
30470: ||' SET process_flag = '||G_ERROR_FLG||','
30471: ||' error_text = '||''''||lv_message_text||''''
30472: ||' WHERE NOT EXISTS (SELECT 1'
30473: ||' FROM hz_parties hp,hz_party_sites hps'

Line 30512: (p_table_name => 'MSC_ST_SUPPLIES',

30508:
30509: --Log a warning for those records where the firm_planned_type has a value other
30510: --NOT IN (1,2)
30511: lv_return := MSC_ST_UTIL.LOG_ERROR
30512: (p_table_name => 'MSC_ST_SUPPLIES',
30513: p_instance_code => v_instance_code,
30514: p_row => lv_column_names,
30515: p_severity => G_SEV_WARNING,
30516: p_message_text => lv_message_text,

Line 30545: (p_table_name => 'MSC_ST_SUPPLIES',

30541: END IF;
30542:
30543: --Derive Project Id.
30544: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
30545: (p_table_name => 'MSC_ST_SUPPLIES',
30546: p_proj_col_name => 'PROJECT_NUMBER',
30547: p_proj_task_col_id => 'PROJECT_ID',
30548: p_instance_code => v_instance_code,
30549: p_entity_name => 'PROJECT_ID',

Line 30578: (p_table_name => 'MSC_ST_SUPPLIES',

30574: END IF;
30575:
30576: --Derive Task Id.
30577: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
30578: (p_table_name => 'MSC_ST_SUPPLIES',
30579: p_proj_col_name => 'PROJECT_NUMBER',
30580: p_proj_task_col_id => 'TASK_ID',
30581: p_instance_code => v_instance_code,
30582: p_entity_name => 'TASK_ID',

Line 30609: (p_table_name => 'MSC_ST_SUPPLIES',

30605: END IF;
30606:
30607: --Derive FROM_ORGANIZATION_ID
30608: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
30609: (p_table_name => 'MSC_ST_SUPPLIES',
30610: p_org_partner_name => 'FROM_ORGANIZATION_CODE',
30611: p_org_partner_id => 'FROM_ORGANIZATION_ID',
30612: p_instance_code => v_instance_code,
30613: p_partner_type => G_ORGANIZATION,

Line 30628: 'UPDATE msc_st_supplies mss'

30624:
30625: --Derive source_Organization_id and source_sr_instance_id,
30626: v_sql_stmt := 15;
30627: lv_sql_stmt :=
30628: 'UPDATE msc_st_supplies mss'
30629: ||' SET source_organization_id = from_organization_id,'
30630: ||' source_sr_instance_id = (select instance_id'
30631: ||' FROM msc_apps_instances mai'
30632: ||' WHERE mai.instance_code = mss.source_sr_instance_code)'

Line 30649: 'UPDATE msc_st_supplies mss '

30645: --Deriving disposition_id and po_line_id for the supply type PO, Purchase
30646: --Req. and intransit supplies
30647: v_sql_stmt := 16;
30648: lv_sql_stmt :=
30649: 'UPDATE msc_st_supplies mss '
30650: ||' SET disposition_id = (SELECT local_id'
30651: ||' FROM msc_local_id_supply mls'
30652: ||' WHERE mls.char3 = mss.order_number'
30653: ||' AND mls.number1 = mss.order_type'

Line 30682: 'UPDATE msc_st_supplies mss'

30678: v_instance_code;
30679:
30680: v_sql_stmt := 17;
30681: lv_sql_stmt :=
30682: 'UPDATE msc_st_supplies mss'
30683: ||' SET sr_mtl_supply_id = (SELECT local_id'
30684: ||' FROM msc_local_id_supply mls'
30685: ||' WHERE mls.char4 = mss.order_number'
30686: ||' AND mls.number1 = mss.purch_line_num'

Line 30721: 'UPDATE msc_st_supplies '

30717: --the record will be errored out.
30718: v_sql_stmt := 18;
30719:
30720: lv_sql_stmt :=
30721: 'UPDATE msc_st_supplies '
30722: ||' SET process_flag = '||G_ERROR_FLG||','
30723: ||' error_text = '||''''||lv_message_text||''''
30724: ||' WHERE NVL(sr_mtl_supply_id,'||NULL_VALUE||') = '||NULL_VALUE
30725: ||' AND deleted_flag ='||SYS_YES

Line 30741: 'UPDATE msc_st_supplies mss'

30737:
30738: --Deriving disposition_id for the Plan Orders.
30739: v_sql_stmt := 19;
30740: lv_sql_stmt :=
30741: 'UPDATE msc_st_supplies mss'
30742: ||' SET disposition_id = (SELECT local_id'
30743: ||' FROM msc_local_id_supply mls'
30744: ||' WHERE mls.char4 = mss.schedule_designator'
30745: ||' AND mls.char5 = mss.schedule_line_num'

Line 30770: 'UPDATE msc_st_supplies '

30766: --errored out.
30767: v_sql_stmt := 20;
30768:
30769: lv_sql_stmt :=
30770: 'UPDATE msc_st_supplies '
30771: ||' SET process_flag = '||G_ERROR_FLG||','
30772: ||' error_text = '||''''||lv_message_text||''''
30773: ||' WHERE NVL(disposition_id,'||NULL_VALUE||') = '||NULL_VALUE
30774: ||' AND deleted_flag ='||SYS_YES

Line 30793: pEntityName => 'MSC_ST_SUPPLIES',

30789: (ERRBUF => lv_error_text,
30790: RETCODE => lv_return,
30791: pBatchID => p_batch_id,
30792: pInstanceCode => v_instance_code,
30793: pEntityName => 'MSC_ST_SUPPLIES',
30794: pInstanceID => v_instance_id);
30795:
30796: IF NVL(lv_return,0) <> 0 THEN
30797: RAISE ex_logging_err;

Line 30809: UPDATE msc_st_supplies

30805: IF c2%ROWCOUNT > 0 THEN
30806:
30807: v_sql_stmt := 22;
30808: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30809: UPDATE msc_st_supplies
30810: SET sr_mtl_supply_id = msc_st_sr_mtl_supply_id_s.NEXTVAL
30811: WHERE rowid = lb_rowid(j);
30812:
30813: v_sql_stmt := 23;

Line 30865: FROM msc_st_supplies

30861: v_current_date,
30862: v_current_user,
30863: v_current_date,
30864: v_current_user
30865: FROM msc_st_supplies
30866: WHERE rowid = lb_rowid(j);
30867: END IF;
30868: CLOSE c2 ;
30869:

Line 30878: UPDATE msc_st_supplies

30874:
30875: IF c4%ROWCOUNT > 0 THEN
30876: v_sql_stmt := 26;
30877: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30878: UPDATE msc_st_supplies
30879: SET po_line_id = msc_st_po_line_id_s.NEXTVAL
30880: WHERE rowid = lb_rowid(j);
30881:
30882: v_sql_stmt := 27;

Line 30932: FROM msc_st_supplies

30928: v_current_date,
30929: v_current_user,
30930: v_current_date,
30931: v_current_user
30932: FROM msc_st_supplies
30933: WHERE rowid = lb_rowid(j);
30934:
30935: END IF;
30936: CLOSE c4 ;

Line 30945: UPDATE msc_st_supplies

30941:
30942: IF c5%ROWCOUNT > 0 THEN
30943: v_sql_stmt := 28;
30944: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30945: UPDATE msc_st_supplies
30946: SET disposition_id = msc_st_disposition_id_s.NEXTVAL
30947: WHERE rowid = lb_rowid(j);
30948:
30949: v_sql_stmt := 29;

Line 31001: FROM msc_st_supplies

30997: v_current_date,
30998: v_current_user,
30999: v_current_date,
31000: v_current_user
31001: FROM msc_st_supplies
31002: WHERE rowid = lb_rowid(j);
31003:
31004: END IF;
31005: CLOSE c5 ;

Line 31011: 'UPDATE msc_st_supplies mss'

31007:
31008: --Updating line_id using disposition_id for the Plan Orders.
31009: v_sql_stmt := 30;
31010: lv_sql_stmt :=
31011: 'UPDATE msc_st_supplies mss'
31012: ||' SET line_id = disposition_id'
31013: ||' WHERE order_type = 5'
31014: ||' AND process_flag = '||G_IN_PROCESS
31015: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'

Line 31027: 'UPDATE msc_st_supplies mss '

31023: v_instance_code;
31024:
31025: v_sql_stmt := 31;
31026: lv_sql_stmt :=
31027: 'UPDATE msc_st_supplies mss '
31028: ||' SET disposition_id = (SELECT local_id'
31029: ||' FROM msc_local_id_supply mls'
31030: ||' WHERE mls.char3 = mss.order_number'
31031: ||' AND mls.number1 = mss.order_type'

Line 31058: ' UPDATE msc_st_supplies mss '

31054: -- in msc_item_suppliers and that particular ASL is VMI enabled
31055:
31056: v_sql_stmt := 32;
31057: lv_sql_stmt :=
31058: ' UPDATE msc_st_supplies mss '
31059: ||' SET vmi_flag = ''Y'''
31060: ||' WHERE exists (SELECT 1 FROM MSC_TP_ID_LID mtil,'
31061: ||' MSC_TP_SITE_ID_LID mtsil,'
31062: ||' MSC_ITEM_ID_LID t1,'

Line 31158: 'UPDATE msc_st_supplies mss'

31154:
31155: -- bug 2903052 defaulting the new_schedule_date as sysdate for onhand supply
31156:
31157: lv_sql_stmt :=
31158: 'UPDATE msc_st_supplies mss'
31159: ||' SET new_schedule_date = SYSDATE'
31160: ||' WHERE deleted_flag ='|| SYS_NO
31161: ||' AND process_flag ='|| G_IN_PROCESS
31162: ||' AND order_type = 18'

Line 31177: (p_table_name => 'MSC_ST_SUPPLIES',

31173:
31174:
31175:
31176: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
31177: (p_table_name => 'MSC_ST_SUPPLIES',
31178: p_instance_id => v_instance_id,
31179: p_instance_code => v_instance_code,
31180: p_process_flag => G_VALID,
31181: p_error_text => lv_error_text,

Line 31190: (p_table_name => 'MSC_ST_SUPPLIES',

31186: RAISE ex_logging_err;
31187: END IF;
31188:
31189: lv_return := MSC_ST_UTIL.LOG_ERROR
31190: (p_table_name => 'MSC_ST_SUPPLIES',
31191: p_instance_code => v_instance_code,
31192: p_row => lv_column_names,
31193: p_severity => G_SEV_ERROR,
31194: p_message_text => NULL,

Line 42409: | in the msc_st_supplies table. Order_types considered are |

42405:
42406:
42407: /*==========================================================================+
42408: | DESCRIPTION : This procedure validates Work Order supply related reocrds |
42409: | in the msc_st_supplies table. Order_types considered are |
42410: | Supply Source Order Type |
42411: | -------------------------------------------- |
42412: | Discrete Job 3 |
42413: | Non-Standard Job 7 |

Line 42427: lv_batch_id msc_st_supplies.batch_id%TYPE;

42423: lv_where_str VARCHAR2(5000);
42424: lv_sql_stmt VARCHAR2(5000);
42425: lv_column_names VARCHAR2(5000); --stores concatenated column names
42426: lv_message_text msc_errors.error_text%TYPE;
42427: lv_batch_id msc_st_supplies.batch_id%TYPE;
42428: ex_logging_err EXCEPTION;
42429:
42430: CURSOR c1(p_batch_id NUMBER) IS
42431: SELECT rowid

Line 42432: FROM msc_st_supplies

42428: ex_logging_err EXCEPTION;
42429:
42430: CURSOR c1(p_batch_id NUMBER) IS
42431: SELECT rowid
42432: FROM msc_st_supplies
42433: WHERE order_type IN(3,7,27,14,15)
42434: AND process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
42435: AND NVL(batch_id,NULL_VALUE)=p_batch_id
42436: AND sr_instance_code = v_instance_code;

Line 42440: FROM msc_st_supplies

42436: AND sr_instance_code = v_instance_code;
42437:
42438: CURSOR c2(p_batch_id NUMBER) IS
42439: SELECT rowid
42440: FROM msc_st_supplies
42441: WHERE NVL(wip_entity_id,NULL_VALUE) = NULL_VALUE
42442: AND process_flag = G_IN_PROCESS
42443: AND NVL(batch_id,NULL_VALUE) =p_batch_id
42444: AND sr_instance_code = v_instance_code;

Line 42448: FROM msc_st_supplies

42444: AND sr_instance_code = v_instance_code;
42445:
42446: CURSOR c3(p_batch_id NUMBER) IS
42447: SELECT max(rowid)
42448: FROM msc_st_supplies
42449: WHERE NVL(schedule_group_id,NULL_VALUE) = NULL_VALUE
42450: AND deleted_flag = SYS_NO
42451: AND process_flag = G_IN_PROCESS
42452: AND NVL(batch_id,NULL_VALUE) = p_batch_id

Line 42458: FROM msc_st_supplies

42454: GROUP BY sr_instance_code,company_name,organization_code,schedule_group_name;
42455:
42456: CURSOR c4(p_batch_id NUMBER) IS
42457: SELECT rowid
42458: FROM msc_st_supplies
42459: WHERE process_flag = G_IN_PROCESS
42460: AND sr_instance_code = v_instance_code
42461: AND batch_id = p_batch_id
42462: AND NVL(JOB_OP_SEQ_NUM, NULL_VALUE) = NULL_VALUE

Line 42483: 'UPDATE msc_st_supplies mss1'

42479: --Duplicate records check for the records whose source is XML for
42480: --WO supplies
42481: v_sql_stmt := 01;
42482: lv_sql_stmt :=
42483: 'UPDATE msc_st_supplies mss1'
42484: ||' SET process_flag = '||G_ERROR_FLG||','
42485: ||' error_text = '||''''||lv_message_text||''''
42486: ||' WHERE message_id < (SELECT MAX(message_id)'
42487: ||' FROM msc_st_supplies mss2'

Line 42487: ||' FROM msc_st_supplies mss2'

42483: 'UPDATE msc_st_supplies mss1'
42484: ||' SET process_flag = '||G_ERROR_FLG||','
42485: ||' error_text = '||''''||lv_message_text||''''
42486: ||' WHERE message_id < (SELECT MAX(message_id)'
42487: ||' FROM msc_st_supplies mss2'
42488: ||' WHERE mss2.sr_instance_code'
42489: ||' = mss1.sr_instance_code'
42490: ||' AND NVL(mss2.company_name,'||''''||NULL_CHAR||''''||') = '
42491: ||' NVL(mss1.company_name,'||''''||NULL_CHAR||''''||')'

Line 42524: 'UPDATE msc_st_supplies mss1 '

42520: --Different SQL is used because in XML we can identify the latest records
42521: --whereas in batch load we cannot.
42522: v_sql_stmt := 02;
42523: lv_sql_stmt :=
42524: 'UPDATE msc_st_supplies mss1 '
42525: ||' SET process_flag = '||G_ERROR_FLG||','
42526: ||' error_text = '||''''||lv_message_text||''''
42527: ||' WHERE EXISTS( SELECT 1 '
42528: ||' FROM msc_st_supplies mss2'

Line 42528: ||' FROM msc_st_supplies mss2'

42524: 'UPDATE msc_st_supplies mss1 '
42525: ||' SET process_flag = '||G_ERROR_FLG||','
42526: ||' error_text = '||''''||lv_message_text||''''
42527: ||' WHERE EXISTS( SELECT 1 '
42528: ||' FROM msc_st_supplies mss2'
42529: ||' WHERE mss2.sr_instance_code'
42530: ||' = mss1.sr_instance_code'
42531: ||' AND NVL(mss2.company_name, '||''''||NULL_CHAR||''''||')= '
42532: ||' NVL(mss1.company_name, '||''''||NULL_CHAR||''''||')'

Line 42592: ' UPDATE msc_st_supplies '

42588: FROM dual;
42589:
42590: v_sql_stmt := 04;
42591: lv_sql_stmt :=
42592: ' UPDATE msc_st_supplies '
42593: ||' SET batch_id = :lv_batch_id'
42594: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
42595: ||' AND order_type IN(3,7,27,14,15)'
42596: ||' AND sr_instance_code = :v_instance_code'

Line 42615: UPDATE msc_st_supplies

42611: CLOSE c1;
42612:
42613: v_sql_stmt := 03;
42614: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
42615: UPDATE msc_st_supplies
42616: SET st_transaction_id = msc_st_supplies_s.NEXTVAL,
42617: refresh_id = v_refresh_id,
42618: last_update_date = v_current_date,
42619: last_updated_by = v_current_user,

Line 42616: SET st_transaction_id = msc_st_supplies_s.NEXTVAL,

42612:
42613: v_sql_stmt := 03;
42614: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
42615: UPDATE msc_st_supplies
42616: SET st_transaction_id = msc_st_supplies_s.NEXTVAL,
42617: refresh_id = v_refresh_id,
42618: last_update_date = v_current_date,
42619: last_updated_by = v_current_user,
42620: creation_date = v_current_date,

Line 42643: (p_table_name => 'MSC_ST_SUPPLIES',

42639: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
42640: --Log a warning for those records where the deleted_flag has a value other
42641: --SYS_NO
42642: lv_return := MSC_ST_UTIL.LOG_ERROR
42643: (p_table_name => 'MSC_ST_SUPPLIES',
42644: p_instance_code => v_instance_code,
42645: p_row => lv_column_names,
42646: p_severity => G_SEV_WARNING,
42647: p_message_text => lv_message_text,

Line 42673: (p_table_name => 'MSC_ST_SUPPLIES',

42669: END IF;
42670:
42671: --Derive Organization_id
42672: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
42673: (p_table_name => 'MSC_ST_SUPPLIES',
42674: p_org_partner_name => 'ORGANIZATION_CODE',
42675: p_org_partner_id => 'ORGANIZATION_ID',
42676: p_instance_code => v_instance_code,
42677: p_partner_type => G_ORGANIZATION,

Line 42703: (p_table_name => 'MSC_ST_SUPPLIES',

42699: END IF;
42700:
42701: --Derive Inventory_item_id
42702: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
42703: (p_table_name => 'MSC_ST_SUPPLIES',
42704: p_item_col_name => 'ITEM_NAME',
42705: p_item_col_id => 'INVENTORY_ITEM_ID',
42706: p_instance_id => v_instance_id,
42707: p_instance_code => v_instance_code,

Line 42733: 'UPDATE msc_st_supplies '

42729: END IF;
42730:
42731: v_sql_stmt := 04;
42732: lv_sql_stmt :=
42733: 'UPDATE msc_st_supplies '
42734: ||' SET error_text = '||''''||lv_message_text||''''||','
42735: ||' process_flag = '||G_ERROR_FLG
42736: ||' WHERE (NVL(new_schedule_date,sysdate-36500) = sysdate-36500'
42737: ||' OR NVL(new_order_quantity,'||NULL_VALUE|| ')= '||NULL_VALUE||')'

Line 42764: 'UPDATE msc_st_supplies '

42760: END IF;
42761:
42762: v_sql_stmt := 05;
42763: lv_sql_stmt :=
42764: 'UPDATE msc_st_supplies '
42765: ||' SET error_text = '||''''||lv_message_text||''''||','
42766: ||' process_flag = '||G_ERROR_FLG
42767: ||' WHERE NVL(wip_entity_name,'||''''||NULL_CHAR||''''||') '
42768: ||' = '||''''||NULL_CHAR||''''

Line 42802: (p_table_name => 'MSC_ST_SUPPLIES',

42798: --Log a warning for those records where the firm_planned_type has a value
42799: --other than 1 and 2
42800:
42801: lv_return := MSC_ST_UTIL.LOG_ERROR
42802: (p_table_name => 'MSC_ST_SUPPLIES',
42803: p_instance_code => v_instance_code,
42804: p_row => lv_column_names,
42805: p_severity => G_SEV_WARNING,
42806: p_message_text => lv_message_text,

Line 42840: (p_table_name => 'MSC_ST_SUPPLIES',

42836: --Log a warning for those records where the wip_status_code has a value other
42837: --than SYS_NO
42838:
42839: lv_return := MSC_ST_UTIL.LOG_ERROR
42840: (p_table_name => 'MSC_ST_SUPPLIES',
42841: p_instance_code => v_instance_code,
42842: p_row => lv_column_names,
42843: p_severity => G_SEV_WARNING,
42844: p_message_text => lv_message_text,

Line 42878: (p_table_name => 'MSC_ST_SUPPLIES',

42874: --Log a warning for those records where the firm_planned_type has a value other
42875: --than SYS_NO
42876:
42877: lv_return := MSC_ST_UTIL.LOG_ERROR
42878: (p_table_name => 'MSC_ST_SUPPLIES',
42879: p_instance_code => v_instance_code,
42880: p_row => lv_column_names,
42881: p_severity => G_SEV_WARNING,
42882: p_message_text => lv_message_text,

Line 42916: (p_table_name => 'MSC_ST_SUPPLIES',

42912: --Log a warning for those records where the wip_supply_type has a value other
42913: --than SYS_NO
42914:
42915: lv_return := MSC_ST_UTIL.LOG_ERROR
42916: (p_table_name => 'MSC_ST_SUPPLIES',
42917: p_instance_code => v_instance_code,
42918: p_row => lv_column_names,
42919: p_severity => G_SEV_WARNING,
42920: p_message_text => lv_message_text,

Line 42934: 'UPDATE msc_st_supplies'

42930: END IF;
42931:
42932: v_sql_stmt := 06;
42933: lv_sql_stmt :=
42934: 'UPDATE msc_st_supplies'
42935: ||' SET order_number = wip_entity_name'
42936: ||' WHERE NVL(order_number,'||''''||NULL_CHAR||''''||')'
42937: ||' = '||''''||NULL_CHAR||''''
42938: ||' AND deleted_flag = '||SYS_NO

Line 42955: 'UPDATE msc_st_supplies '

42951: -- ASSEMBLY NAME in BOM NAME column for all such records
42952:
42953: v_sql_stmt := 07;
42954: lv_sql_stmt :=
42955: 'UPDATE msc_st_supplies '
42956: ||' SET bill_name = item_name'
42957: ||' WHERE sr_instance_code = :v_instance_code'
42958: ||' AND order_type in (3, 14)'
42959: ||' AND process_flag ='||G_IN_PROCESS

Line 42977: 'UPDATE msc_st_supplies '

42973:
42974: v_sql_stmt := 08;
42975:
42976: lv_sql_stmt :=
42977: 'UPDATE msc_st_supplies '
42978: ||' SET routing_name = item_name'
42979: ||' WHERE sr_instance_code = :v_instance_code'
42980: ||' AND order_type in (3, 14)'
42981: ||' AND process_flag ='|| G_IN_PROCESS

Line 42994: (p_table_name => 'MSC_ST_SUPPLIES',

42990:
42991: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
42992:
42993: lv_return := MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
42994: (p_table_name => 'MSC_ST_SUPPLIES',
42995: p_bom_col_name => 'BILL_NAME',
42996: p_bom_col_id => 'BILL_SEQUENCE_ID',
42997: p_instance_code => v_instance_code,
42998: p_batch_id => lv_batch_id,

Line 43008: (p_table_name => 'MSC_ST_SUPPLIES',

43004: RAISE ex_logging_err;
43005: END IF;
43006:
43007: lv_return := MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
43008: (p_table_name => 'MSC_ST_SUPPLIES',
43009: p_rtg_col_name => 'ROUTING_NAME',
43010: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
43011: p_instance_code => v_instance_code,
43012: p_batch_id => lv_batch_id,

Line 43025: 'UPDATE msc_st_supplies mss'

43021:
43022:
43023: v_sql_stmt := 09;
43024: lv_sql_stmt :=
43025: 'UPDATE msc_st_supplies mss'
43026: ||' SET schedule_group_id = (SELECT local_id'
43027: ||' FROM msc_local_id_supply mls'
43028: ||' WHERE mls.char4 = mss.schedule_group_name'
43029: ||' AND mls.char3 = mss.organization_code'

Line 43090: (p_table_name => 'MSC_ST_SUPPLIES',

43086: --Log a warning for those records where the bill_sequence_id or
43087: --routing_sequence_id has null values
43088:
43089: lv_return := MSC_ST_UTIL.LOG_ERROR
43090: (p_table_name => 'MSC_ST_SUPPLIES',
43091: p_instance_code => v_instance_code,
43092: p_row => lv_column_names,
43093: p_severity => G_SEV_WARNING,
43094: p_message_text => lv_message_text,

Line 43107: 'UPDATE msc_st_supplies mss'

43103:
43104: --Deriving wip_entity_id
43105: v_sql_stmt := 10;
43106: lv_sql_stmt :=
43107: 'UPDATE msc_st_supplies mss'
43108: ||' SET wip_entity_id = (SELECT local_id'
43109: ||' FROM msc_local_id_supply mls'
43110: ||' WHERE mls.char4 = mss.wip_entity_name'
43111: ||' AND mls.char3 = mss.organization_code'

Line 43141: 'UPDATE msc_st_supplies '

43137:
43138: v_sql_stmt := 11;
43139:
43140: lv_sql_stmt :=
43141: 'UPDATE msc_st_supplies '
43142: ||' SET process_flag = '||G_ERROR_FLG||','
43143: ||' error_text = '||''''||lv_message_text||''''
43144: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
43145: ||' AND deleted_flag ='||SYS_YES

Line 43161: 'UPDATE msc_st_supplies '

43157:
43158: -- update the jump_op_seq_num for lot based jobs for the operations jumped outside the network
43159:
43160: lv_sql_stmt :=
43161: 'UPDATE msc_st_supplies '
43162: ||' SET jump_op_seq_num = 50000'
43163: ||' WHERE NVL(jump_op_seq_code,'||''''||NULL_CHAR||''''||') '
43164: ||' = '||''''||50000||''''
43165: ||' AND process_flag = '||G_IN_PROCESS

Line 43179: 'UPDATE msc_st_supplies mss'

43175: v_instance_code;
43176:
43177:
43178: lv_sql_stmt :=
43179: 'UPDATE msc_st_supplies mss'
43180: ||' SET jump_op_seq_num = (SELECT number1'
43181: ||' FROM msc_local_id_setup mls'
43182: ||' WHERE NVL(mls.char5,'||''''||NULL_CHAR||''''||') = '
43183: ||' NVL(mss.jump_op_seq_code,'||''''||NULL_CHAR||''''||') '

Line 43214: pEntityName => 'MSC_ST_SUPPLIES_WO',

43210: (ERRBUF => lv_error_text,
43211: RETCODE => lv_return,
43212: pBatchID => lv_batch_id,
43213: pInstanceCode => v_instance_code,
43214: pEntityName => 'MSC_ST_SUPPLIES_WO',
43215: pInstanceID => v_instance_id);
43216:
43217: IF NVL(lv_return,0) <> 0 THEN
43218: RAISE ex_logging_err;

Line 43228: UPDATE msc_st_supplies

43224:
43225: IF c2%ROWCOUNT > 0 THEN
43226: v_sql_stmt := 12;
43227: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43228: UPDATE msc_st_supplies
43229: SET wip_entity_id = msc_st_wip_entity_id_s.NEXTVAL
43230: WHERE rowid = lb_rowid(j);
43231:
43232: v_sql_stmt := 13;

Line 43274: FROM msc_st_supplies

43270: v_current_date,
43271: v_current_user,
43272: v_current_date,
43273: v_current_user
43274: FROM msc_st_supplies
43275: WHERE rowid = lb_rowid(j);
43276:
43277: END IF;
43278: CLOSE c2 ;

Line 43287: UPDATE msc_st_supplies

43283:
43284: IF c3%ROWCOUNT > 0 THEN
43285: v_sql_stmt := 14;
43286: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43287: UPDATE msc_st_supplies
43288: SET schedule_group_id = msc_st_schedule_group_id_s.NEXTVAL
43289: WHERE rowid = lb_rowid(j);
43290:
43291: v_sql_stmt := 15;

Line 43333: FROM msc_st_supplies

43329: v_current_date,
43330: v_current_user,
43331: v_current_date,
43332: v_current_user
43333: FROM msc_st_supplies
43334: WHERE rowid = lb_rowid(j);
43335:
43336: END IF;
43337: CLOSE c3;

Line 43341: UPDATE msc_st_supplies

43337: CLOSE c3;
43338:
43339: --Update disposition_id with the wip_entity_id.
43340: v_sql_stmt := 16;
43341: UPDATE msc_st_supplies
43342: SET disposition_id = wip_entity_id
43343: WHERE process_flag = G_IN_PROCESS
43344: AND batch_id = lv_batch_id
43345: AND sr_instance_code = v_instance_code;

Line 43364: (p_table_name => 'MSC_ST_SUPPLIES',

43360: END IF;
43361:
43362: --Derive Project Id.
43363: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
43364: (p_table_name => 'MSC_ST_SUPPLIES',
43365: p_proj_col_name => 'PROJECT_NUMBER',
43366: p_proj_task_col_id => 'PROJECT_ID',
43367: p_instance_code => v_instance_code,
43368: p_entity_name => 'PROJECT_ID',

Line 43397: (p_table_name => 'MSC_ST_SUPPLIES',

43393: END IF;
43394:
43395: --Derive Task Id.
43396: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
43397: (p_table_name => 'MSC_ST_SUPPLIES',
43398: p_proj_col_name => 'PROJECT_NUMBER',
43399: p_proj_task_col_id => 'TASK_ID',
43400: p_instance_code => v_instance_code,
43401: p_entity_name => 'TASK_ID',

Line 43417: 'UPDATE msc_st_supplies mss '

43413:
43414:
43415: v_sql_stmt := 17;
43416: lv_sql_stmt :=
43417: 'UPDATE msc_st_supplies mss '
43418: ||' SET schedule_group_id = (SELECT local_id'
43419: ||' FROM msc_local_id_supply mls'
43420: ||' WHERE mls.char4 = mss.schedule_group_name'
43421: ||' AND mls.char3 = mss.organization_code'

Line 43446: UPDATE msc_st_supplies

43442: IF c4%ROWCOUNT > 0 THEN
43443:
43444: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43445:
43446: UPDATE msc_st_supplies
43447: SET job_op_seq_num =
43448: to_number(decode(length(rtrim(job_op_seq_code,'0123456789')),
43449: NULL,job_op_seq_code,'1'))
43450: WHERE rowid = lb_rowid(j);

Line 43455: (p_table_name => 'MSC_ST_SUPPLIES',

43451: END IF;
43452: CLOSE c4;
43453:
43454: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
43455: (p_table_name => 'MSC_ST_SUPPLIES',
43456: p_instance_id => v_instance_id,
43457: p_instance_code => v_instance_code,
43458: p_process_flag => G_VALID,
43459: p_error_text => lv_error_text,

Line 43467: (p_table_name => 'MSC_ST_SUPPLIES',

43463: RAISE ex_logging_err;
43464: END IF;
43465:
43466: lv_return := MSC_ST_UTIL.LOG_ERROR
43467: (p_table_name => 'MSC_ST_SUPPLIES',
43468: p_instance_code => v_instance_code,
43469: p_row => lv_column_names,
43470: p_severity => G_SEV_ERROR,
43471: p_message_text => NULL,

Line 43816: p_token_value2 => 'MSC_ST_SUPPLIES',

43812: p_token1 => 'COLUMN_NAMES',
43813: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
43814: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
43815: p_token2 => 'MASTER_TABLE',
43816: p_token_value2 => 'MSC_ST_SUPPLIES',
43817: p_token3 => 'CHILD_TABLE' ,
43818: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );
43819:
43820: IF lv_return <> 0 THEN

Line 45127: p_token_value2 => 'MSC_ST_SUPPLIES',

45123: p_token1 => 'COLUMN_NAMES',
45124: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
45125: ||' ORGANIZATION_CODE,WIP_ENTITY_NAME',
45126: p_token2 => 'MASTER_TABLE',
45127: p_token_value2 => 'MSC_ST_SUPPLIES',
45128: p_token3 => 'CHILD_TABLE' ,
45129: p_token_value3 => 'MSC_ST_DEMANDS' );
45130:
45131: IF lv_return <> 0 THEN

Line 46335: p_token_value2 => 'MSC_ST_SUPPLIES',

46331: p_token1 => 'COLUMN_NAMES',
46332: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
46333: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
46334: p_token2 => 'MASTER_TABLE',
46335: p_token_value2 => 'MSC_ST_SUPPLIES',
46336: p_token3 => 'CHILD_TABLE' ,
46337: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );
46338:
46339: IF lv_return <> 0 THEN

Line 47147: p_token_value2 => 'MSC_ST_SUPPLIES',

47143: p_token1 => 'COLUMN_NAMES',
47144: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
47145: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
47146: p_token2 => 'MASTER_TABLE',
47147: p_token_value2 => 'MSC_ST_SUPPLIES',
47148: p_token3 => 'CHILD_TABLE' ,
47149: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );
47150:
47151: IF lv_return <> 0 THEN

Line 47737: p_token_value2 => 'MSC_ST_SUPPLIES',

47733: p_token1 => 'COLUMN_NAMES',
47734: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
47735: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
47736: p_token2 => 'MASTER_TABLE',
47737: p_token_value2 => 'MSC_ST_SUPPLIES',
47738: p_token3 => 'CHILD_TABLE' ,
47739: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );
47740:
47741: IF lv_return <> 0 THEN

Line 48565: p_token_value2 => 'MSC_ST_SUPPLIES',

48561: p_token1 => 'COLUMN_NAMES',
48562: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
48563: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
48564: p_token2 => 'MASTER_TABLE',
48565: p_token_value2 => 'MSC_ST_SUPPLIES',
48566: p_token3 => 'CHILD_TABLE' ,
48567: p_token_value3 => 'MSC_ST_JOB_OP_RESOURCES' );
48568:
48569: IF lv_return <> 0 THEN

Line 49403: 'UPDATE msc_st_supplies mss1 '

49399: --Duplicate records check for the records whose source is XML for
49400: --PO, Purchase Req and Intransit supplies
49401: v_sql_stmt := 03;
49402: lv_sql_stmt :=
49403: 'UPDATE msc_st_supplies mss1 '
49404: ||' SET process_flag = '||G_ERROR_FLG||','
49405: ||' error_text = '||''''||lv_message_text||''''
49406: ||' WHERE message_id < (SELECT MAX(message_id)'
49407: ||' FROM msc_st_supplies mss2'

Line 49407: ||' FROM msc_st_supplies mss2'

49403: 'UPDATE msc_st_supplies mss1 '
49404: ||' SET process_flag = '||G_ERROR_FLG||','
49405: ||' error_text = '||''''||lv_message_text||''''
49406: ||' WHERE message_id < (SELECT MAX(message_id)'
49407: ||' FROM msc_st_supplies mss2'
49408: ||' WHERE mss2.sr_instance_code'
49409: ||' = mss1.sr_instance_code'
49410: ||' AND mss2.order_number = mss1.order_number'
49411: ||' AND mss2.purch_line_num = mss1.purch_line_num'

Line 49433: 'UPDATE msc_st_supplies mss1'

49429: --Duplicate records check for the records whose source is XML for
49430: --Plan Orders
49431: v_sql_stmt := 04;
49432: lv_sql_stmt :=
49433: 'UPDATE msc_st_supplies mss1'
49434: ||' SET process_flag = '||G_ERROR_FLG||','
49435: ||' error_text = '||''''||lv_message_text||''''
49436: ||' WHERE message_id < (SELECT MAX(message_id)'
49437: ||' FROM msc_st_supplies mss2'

Line 49437: ||' FROM msc_st_supplies mss2'

49433: 'UPDATE msc_st_supplies mss1'
49434: ||' SET process_flag = '||G_ERROR_FLG||','
49435: ||' error_text = '||''''||lv_message_text||''''
49436: ||' WHERE message_id < (SELECT MAX(message_id)'
49437: ||' FROM msc_st_supplies mss2'
49438: ||' WHERE mss2.sr_instance_code '
49439: ||' = mss1.sr_instance_code'
49440: ||' AND NVL(mss2.company_name,'||''''||NULL_CHAR||''''||') = '
49441: ||' NVL(mss1.company_name,'||''''||NULL_CHAR||''''||')'

Line 49464: 'UPDATE msc_st_supplies mss1 '

49460: --Duplicate records check for the records whose source is XML for
49461: --on hand supplies
49462: v_sql_stmt := 05;
49463: lv_sql_stmt :=
49464: 'UPDATE msc_st_supplies mss1 '
49465: ||' SET process_flag = '||G_ERROR_FLG||','
49466: ||' error_text = '||''''||lv_message_text||''''
49467: ||' WHERE message_id < (SELECT MAX(message_id)'
49468: ||' FROM msc_st_supplies mss2'

Line 49468: ||' FROM msc_st_supplies mss2'

49464: 'UPDATE msc_st_supplies mss1 '
49465: ||' SET process_flag = '||G_ERROR_FLG||','
49466: ||' error_text = '||''''||lv_message_text||''''
49467: ||' WHERE message_id < (SELECT MAX(message_id)'
49468: ||' FROM msc_st_supplies mss2'
49469: ||' WHERE mss2.sr_instance_code = mss1.sr_instance_code'
49470: ||' AND NVL(mss2.company_name,'||''''||NULL_CHAR||''''||') = '
49471: ||' NVL(mss1.company_name,'||''''||NULL_CHAR||''''||')'
49472: ||' AND mss2.organization_code = mss1.organization_code '

Line 49516: 'UPDATE msc_st_supplies mss1 '

49512: --whereas in batch load we cannot.
49513: --Check for PO, purchase req. and intransit supplies.
49514: v_sql_stmt := 06;
49515: lv_sql_stmt :=
49516: 'UPDATE msc_st_supplies mss1 '
49517: ||' SET process_flag = '||G_ERROR_FLG||','
49518: ||' error_text = '||''''||lv_message_text||''''
49519: ||' WHERE EXISTS( SELECT 1 '
49520: ||' FROM msc_st_supplies mss2'

Line 49520: ||' FROM msc_st_supplies mss2'

49516: 'UPDATE msc_st_supplies mss1 '
49517: ||' SET process_flag = '||G_ERROR_FLG||','
49518: ||' error_text = '||''''||lv_message_text||''''
49519: ||' WHERE EXISTS( SELECT 1 '
49520: ||' FROM msc_st_supplies mss2'
49521: ||' WHERE mss2.sr_instance_code'
49522: ||' = mss1.sr_instance_code'
49523: ||' AND NVL(mss2.company_name, '||''''||NULL_CHAR||''''||') = '
49524: ||' NVL(mss1.company_name, '||''''||NULL_CHAR||''''||')'

Line 49548: 'UPDATE msc_st_supplies mss1 '

49544:
49545: --Duplicate Check for plan orders(batch load).
49546: v_sql_stmt := 08;
49547: lv_sql_stmt :=
49548: 'UPDATE msc_st_supplies mss1 '
49549: ||' SET process_flag = '||G_ERROR_FLG||','
49550: ||' error_text = '||''''||lv_message_text||''''
49551: ||' WHERE EXISTS( SELECT 1 '
49552: ||' FROM msc_st_supplies mss2'

Line 49552: ||' FROM msc_st_supplies mss2'

49548: 'UPDATE msc_st_supplies mss1 '
49549: ||' SET process_flag = '||G_ERROR_FLG||','
49550: ||' error_text = '||''''||lv_message_text||''''
49551: ||' WHERE EXISTS( SELECT 1 '
49552: ||' FROM msc_st_supplies mss2'
49553: ||' WHERE mss2.sr_instance_code'
49554: ||' = mss1.sr_instance_code'
49555: ||' AND NVL(mss2.company_name,'||''''||NULL_CHAR||''''||') = '
49556: ||' NVL(mss1.company_name,'||''''||NULL_CHAR||''''||')'

Line 49580: 'UPDATE msc_st_supplies mss1'

49576:
49577: --Duplicate Check for on hand supplies(batch load).
49578: v_sql_stmt := 09;
49579: lv_sql_stmt :=
49580: 'UPDATE msc_st_supplies mss1'
49581: ||' SET process_flag = '||G_ERROR_FLG||','
49582: ||' error_text = '||''''||lv_message_text||''''
49583: ||' WHERE EXISTS( SELECT 1 '
49584: ||' FROM msc_st_supplies mss2'

Line 49584: ||' FROM msc_st_supplies mss2'

49580: 'UPDATE msc_st_supplies mss1'
49581: ||' SET process_flag = '||G_ERROR_FLG||','
49582: ||' error_text = '||''''||lv_message_text||''''
49583: ||' WHERE EXISTS( SELECT 1 '
49584: ||' FROM msc_st_supplies mss2'
49585: ||' WHERE mss2.sr_instance_code = mss1.sr_instance_code'
49586: ||' AND NVL(mss2.company_name,'||''''||NULL_CHAR||''''||') = '
49587: ||' NVL(mss1.company_name,'||''''||NULL_CHAR||''''||')'
49588: ||' AND mss2.organization_code = mss1.organization_code '

Line 49640: 'UPDATE msc_st_supplies '

49636:
49637:
49638: v_sql_stmt := 10;
49639: lv_sql_stmt :=
49640: 'UPDATE msc_st_supplies '
49641: ||' SET process_flag = '||G_ERROR_FLG||','
49642: ||' error_text = '||''''||lv_message_text||''''
49643: ||' WHERE order_type NOT IN(1,2,3,5,7,8,11,12,14,15,16,18,27,75,73,74,87,86)'
49644: ||' AND process_flag = '||G_IN_PROCESS

Line 50850: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SUPPLIES',p_erp_enabled => 'Y');

50846: END IF;
50847:
50848: IF v_mat_sup_enabled = SYS_YES OR v_iro_enabled = SYS_YES or v_ero_enabled = SYS_YES
50849: THEN
50850: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SUPPLIES',p_erp_enabled => 'Y');
50851: IF lv_count > 0 Then
50852: prec.oh_flag:= SYS_YES;
50853: prec.po_flag:= SYS_YES;
50854: prec.mps_flag:= SYS_YES;

Line 53858: cursor c2 is SELECT rowid FROM msc_st_supplies

53854: lb_batch NumTblTyp := NumTblTyp(0);
53855: lv_batch_id PLS_INTEGER;
53856: lv_batch_start PLS_INTEGER;
53857: lv_batch_last PLS_INTEGER;
53858: cursor c2 is SELECT rowid FROM msc_st_supplies
53859: WHERE PROCESS_FLAG IN(G_IN_PROCESS,G_ERROR_FLG)
53860: AND ORDER_TYPE IN(1,2,5,8,11,12,18,73,74,87)
53861: AND NVL(batch_id,NULL_VALUE) = NULL_VALUE
53862: AND sr_instance_code = v_instance_code;

Line 53887: UPDATE msc_st_supplies

53883:
53884: lv_batch_last := lv_batch_id;
53885:
53886: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
53887: UPDATE msc_st_supplies
53888: SET batch_id = lb_batch(j)
53889: WHERE rowid = lb_rowid(j);
53890:
53891: commit;