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_RPO_PRE_PROCESS dependencies on MSC_ST_DEMANDS

Line 647: lv_batch_id msc_st_demands.batch_id%TYPE;

643: lv_error_text VARCHAR2(250);
644: lv_where_str VARCHAR2(5000);
645: lv_sql_stmt VARCHAR2(5000);
646: lv_column_names VARCHAR2(5000);
647: lv_batch_id msc_st_demands.batch_id%TYPE;
648: lv_message_text msc_errors.error_text%TYPE;
649:
650: ex_logging_err EXCEPTION;
651:

Line 654: FROM msc_st_demands

650: ex_logging_err EXCEPTION;
651:
652: CURSOR c1(p_batch_id NUMBER) IS
653: SELECT rowid
654: FROM msc_st_demands
655: WHERE process_flag IN (MSC_CL_PRE_PROCESS.G_IN_PROCESS)
656: AND batch_id = p_batch_id
657: AND sr_instance_code = MSC_CL_PRE_PROCESS.v_instance_code;
658:

Line 676: 'UPDATE msc_st_demands msd1 '

672: --Different SQL is used because in XML we can identify the latest records
673: --whereas in batch load we cannot.
674: MSC_CL_PRE_PROCESS.v_sql_stmt := 02;
675: lv_sql_stmt :=
676: 'UPDATE msc_st_demands msd1 '
677: ||' SET process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
678: ||' error_text = '||''''||lv_message_text||''''
679: ||' WHERE EXISTS( SELECT 1 '
680: ||' FROM msc_st_demands msd2'

Line 680: ||' FROM msc_st_demands msd2'

676: 'UPDATE msc_st_demands msd1 '
677: ||' SET process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
678: ||' error_text = '||''''||lv_message_text||''''
679: ||' WHERE EXISTS( SELECT 1 '
680: ||' FROM msc_st_demands msd2'
681: ||' WHERE msd2.sr_instance_code = msd1.sr_instance_code'
682: ||' AND msd2.organization_code = msd1.organization_code'
683: ||' AND msd2.wip_entity_name = msd1.wip_entity_name'
684: ||' AND msd2.repair_number = msd1.repair_number'

Line 734: ' UPDATE msc_st_demands '

730: FROM dual;
731:
732: MSC_CL_PRE_PROCESS.v_sql_stmt := 04;
733: lv_sql_stmt :=
734: ' UPDATE msc_st_demands '
735: ||' SET batch_id = :lv_batch_id'
736: ||' WHERE process_flag IN ('||MSC_CL_PRE_PROCESS.G_IN_PROCESS||','||MSC_CL_PRE_PROCESS.G_ERROR_FLG||')'
737: ||' AND sr_instance_code = :v_instance_code'
738: ||' AND origination_type IN (77) '

Line 760: UPDATE msc_st_demands

756: CLOSE c1;
757:
758: MSC_CL_PRE_PROCESS.v_sql_stmt := 05;
759: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
760: UPDATE msc_st_demands
761: SET st_transaction_id = msc_st_demands_s.NEXTVAL,
762: refresh_id = MSC_CL_PRE_PROCESS.v_refresh_id,
763: last_update_date = MSC_CL_PRE_PROCESS.v_current_date,
764: last_updated_by = MSC_CL_PRE_PROCESS.v_current_user,

Line 761: SET st_transaction_id = msc_st_demands_s.NEXTVAL,

757:
758: MSC_CL_PRE_PROCESS.v_sql_stmt := 05;
759: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
760: UPDATE msc_st_demands
761: SET st_transaction_id = msc_st_demands_s.NEXTVAL,
762: refresh_id = MSC_CL_PRE_PROCESS.v_refresh_id,
763: last_update_date = MSC_CL_PRE_PROCESS.v_current_date,
764: last_updated_by = MSC_CL_PRE_PROCESS.v_current_user,
765: creation_date = MSC_CL_PRE_PROCESS.v_current_date,

Line 791: (p_table_name => 'MSC_ST_DEMANDS',

787: ||' NOT IN(1,2)';
788: --Log a warning for those records where the deleted_flag has a value other
789: --than SYS_NO
790: lv_return := MSC_ST_UTIL.LOG_ERROR
791: (p_table_name => 'MSC_ST_DEMANDS',
792: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
793: p_row => lv_column_names,
794: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,
795: p_message_text => lv_message_text,

Line 821: (p_table_name => 'MSC_ST_DEMANDS',

817: END IF;
818:
819: --Derive Organization_id
820: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
821: (p_table_name => 'MSC_ST_DEMANDS',
822: p_org_partner_name => 'ORGANIZATION_CODE',
823: p_org_partner_id => 'ORGANIZATION_ID',
824: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
825: p_partner_type => MSC_CL_PRE_PROCESS.G_ORGANIZATION,

Line 851: (p_table_name => 'MSC_ST_DEMANDS',

847: END IF;
848:
849: --Derive Inventory_item_id
850: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
851: (p_table_name => 'MSC_ST_DEMANDS',
852: p_item_col_name => 'ITEM_NAME',
853: p_item_col_id => 'INVENTORY_ITEM_ID',
854: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
855: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 882: (p_table_name => 'MSC_ST_DEMANDS',

878: END IF;
879:
880: --Derive Inventory_item_id
881: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
882: (p_table_name => 'MSC_ST_DEMANDS',
883: p_item_col_name => 'USING_ASSEMBLY_ITEM_NAME',
884: p_item_col_id => 'USING_ASSEMBLY_ITEM_ID',
885: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
886: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 914: 'UPDATE msc_st_demands '

910: END IF;
911:
912: MSC_CL_PRE_PROCESS.v_sql_stmt := 06;
913: lv_sql_stmt :=
914: 'UPDATE msc_st_demands '
915: ||' SET error_text = '||''''||lv_message_text||''''||','
916: ||' process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG
917: ||' WHERE (using_requirement_quantity IS NULL ' ||' OR using_assembly_demand_date IS NULL)'
918: ||' AND process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS

Line 948: 'UPDATE msc_st_demands '

944: END IF;
945:
946: MSC_CL_PRE_PROCESS.v_sql_stmt := 07;
947: lv_sql_stmt :=
948: 'UPDATE msc_st_demands '
949: ||' SET error_text = '||''''||lv_message_text||''''||','
950: ||' process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG
951: ||' WHERE repair_number is NULL'
952: ||' AND process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS

Line 968: 'UPDATE msc_st_demands msd'

964: --- derive repair line id
965:
966: MSC_CL_PRE_PROCESS.v_sql_stmt := 08;
967: lv_sql_stmt :=
968: 'UPDATE msc_st_demands msd'
969: ||' SET repair_line_id = (SELECT local_id'
970: ||' FROM msc_local_id_supply mls'
971: ||' WHERE mls.char4 = msd.wip_entity_name'
972: ||' AND mls.char3 = msd.organization_code'

Line 1002: 'UPDATE msc_st_demands '

998: END IF;
999: MSC_CL_PRE_PROCESS.v_sql_stmt := 09;
1000:
1001: lv_sql_stmt :=
1002: 'UPDATE msc_st_demands '
1003: ||' SET process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
1004: ||' error_text = '||''''||lv_message_text||''''
1005: ||' WHERE repair_line_id is null '
1006: ||' AND deleted_flag ='||MSC_CL_PRE_PROCESS.SYS_YES

Line 1033: 'UPDATE msc_st_demands '

1029: END IF;
1030:
1031: MSC_CL_PRE_PROCESS.v_sql_stmt := 10;
1032: lv_sql_stmt :=
1033: 'UPDATE msc_st_demands '
1034: ||' SET error_text = '||''''||lv_message_text||''''||','
1035: ||' process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG
1036: ||' WHERE nvl(ITEM_TYPE_VALUE,-1) not in (1,2)'
1037: ||' AND process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS

Line 1051: (p_table_name => 'MSC_ST_DEMANDS',

1047: MSC_CL_PRE_PROCESS.v_instance_code;
1048:
1049: ---- validating project and task :
1050: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
1051: (p_table_name => 'MSC_ST_DEMANDS',
1052: p_proj_col_name => 'PROJECT_NUMBER',
1053: p_proj_task_col_id => 'PROJECT_ID',
1054: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1055: p_entity_name => 'PROJECT_ID',

Line 1084: (p_table_name => 'MSC_ST_DEMANDS',

1080: END IF;
1081:
1082: --Derive Task Id.
1083: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
1084: (p_table_name => 'MSC_ST_DEMANDS',
1085: p_proj_col_name => 'PROJECT_NUMBER',
1086: p_proj_task_col_id => 'TASK_ID',
1087: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1088: p_entity_name => 'TASK_ID',

Line 1107: pEntityName => 'MSC_ST_DEMANDS',

1103: (ERRBUF => lv_error_text,
1104: RETCODE => lv_return,
1105: pBatchID => lv_batch_id,
1106: pInstanceCode => MSC_CL_PRE_PROCESS.v_instance_code,
1107: pEntityName => 'MSC_ST_DEMANDS',
1108: pInstanceID => MSC_CL_PRE_PROCESS.v_instance_id);
1109:
1110: IF NVL(lv_return,0) <> 0 THEN
1111: RAISE ex_logging_err;

Line 1115: (p_table_name => 'MSC_ST_DEMANDS',

1111: RAISE ex_logging_err;
1112: END IF;
1113:
1114: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
1115: (p_table_name => 'MSC_ST_DEMANDS',
1116: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
1117: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1118: p_process_flag => MSC_CL_PRE_PROCESS.G_VALID,
1119: p_error_text => lv_error_text,

Line 1128: (p_table_name => 'MSC_ST_DEMANDS',

1124: RAISE ex_logging_err;
1125: END IF;
1126:
1127: lv_return := MSC_ST_UTIL.LOG_ERROR
1128: (p_table_name => 'MSC_ST_DEMANDS',
1129: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
1130: p_row => lv_column_names,
1131: p_severity => MSC_CL_PRE_PROCESS.G_SEV_ERROR,
1132: p_message_text => NULL,

Line 1146: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_DEMANDS'||'('

1142:
1143: EXCEPTION
1144:
1145: WHEN too_many_rows THEN
1146: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_DEMANDS'||'('
1147: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
1148: ROLLBACK ;
1149:
1150: WHEN ex_logging_err THEN

Line 1155: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_DEMANDS '||'('

1151: msc_st_util.log_message(lv_error_text);
1152: ROLLBACK;
1153:
1154: WHEN OTHERS THEN
1155: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_DEMANDS '||'('
1156: ||MSC_CL_PRE_PROCESS.v_sql_stmt||')'|| SQLERRM, 1, 240);
1157: msc_st_util.log_message(lv_error_text);
1158: ROLLBACK;
1159:

Line 2273: lv_batch_id msc_st_demands.batch_id%TYPE;

2269: lv_error_text VARCHAR2(250);
2270: lv_where_str VARCHAR2(5000);
2271: lv_sql_stmt VARCHAR2(5000);
2272: lv_cursor_stmt VARCHAR2(5000);
2273: lv_batch_id msc_st_demands.batch_id%TYPE;
2274: lv_message_text msc_errors.error_text%TYPE;
2275:
2276: ex_logging_err EXCEPTION;
2277:

Line 2280: FROM msc_st_demands

2276: ex_logging_err EXCEPTION;
2277:
2278: CURSOR c1(p_batch_id NUMBER) IS
2279: SELECT rowid
2280: FROM msc_st_demands
2281: WHERE process_flag IN (MSC_CL_PRE_PROCESS.G_IN_PROCESS,MSC_CL_PRE_PROCESS.G_ERROR_FLG)
2282: AND origination_type =77
2283: AND batch_id = p_batch_id
2284: AND sr_instance_code = MSC_CL_PRE_PROCESS.v_instance_code

Line 2289: FROM msc_st_demands

2285: AND ENTITY='ERO';
2286:
2287: CURSOR c2(p_batch_id NUMBER) IS
2288: SELECT max(rowid)
2289: FROM msc_st_demands
2290: WHERE process_flag = MSC_CL_PRE_PROCESS.G_IN_PROCESS
2291: AND sr_instance_code = MSC_CL_PRE_PROCESS.v_instance_code
2292: AND batch_id = p_batch_id
2293: AND origination_type =77 -- Not for flow schedule

Line 2323: 'UPDATE msc_st_demands msd1'

2319:
2320: MSC_CL_PRE_PROCESS.v_sql_stmt := 01;
2321:
2322: lv_sql_stmt :=
2323: 'UPDATE msc_st_demands msd1'
2324: ||' SET process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
2325: ||' error_text = '||''''||lv_message_text||''''
2326: ||' WHERE message_id < (SELECT MAX(message_id)'
2327: ||' FROM msc_st_demands msd2'

Line 2327: ||' FROM msc_st_demands msd2'

2323: 'UPDATE msc_st_demands msd1'
2324: ||' SET process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
2325: ||' error_text = '||''''||lv_message_text||''''
2326: ||' WHERE message_id < (SELECT MAX(message_id)'
2327: ||' FROM msc_st_demands msd2'
2328: ||' WHERE msd2.sr_instance_code '
2329: ||' = msd1.sr_instance_code '
2330: ||' AND msd2.organization_code '
2331: ||' = msd1.organization_code '

Line 2370: 'UPDATE msc_st_demands msd1'

2366:
2367: MSC_CL_PRE_PROCESS.v_sql_stmt := 02;
2368:
2369: lv_sql_stmt :=
2370: 'UPDATE msc_st_demands msd1'
2371: ||' SET process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
2372: ||' error_text = '||''''||lv_message_text||''''
2373: ||' WHERE EXISTS( SELECT 1 '
2374: ||' FROM msc_st_demands msd2'

Line 2374: ||' FROM msc_st_demands msd2'

2370: 'UPDATE msc_st_demands msd1'
2371: ||' SET process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
2372: ||' error_text = '||''''||lv_message_text||''''
2373: ||' WHERE EXISTS( SELECT 1 '
2374: ||' FROM msc_st_demands msd2'
2375: ||' WHERE msd2.sr_instance_code '
2376: ||' = msd1.sr_instance_code '
2377: ||' AND msd2.organization_code '
2378: ||' = msd1.organization_code '

Line 2435: ' UPDATE msc_st_demands '

2431: FROM DUAL;
2432:
2433: MSC_CL_PRE_PROCESS.v_sql_stmt := 04;
2434: lv_sql_stmt :=
2435: ' UPDATE msc_st_demands '
2436: ||' SET batch_id = :lv_batch_id'
2437: ||' WHERE process_flag IN ('||MSC_CL_PRE_PROCESS.G_IN_PROCESS||','||MSC_CL_PRE_PROCESS.G_ERROR_FLG||')'
2438: ||' AND sr_instance_code = :v_instance_code'
2439: ||' AND origination_type =77'

Line 2461: UPDATE msc_st_demands

2457: CLOSE c1;
2458:
2459: MSC_CL_PRE_PROCESS.v_sql_stmt := 03;
2460: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
2461: UPDATE msc_st_demands
2462: SET st_transaction_id = msc_st_demands_s.NEXTVAL,
2463: refresh_id = MSC_CL_PRE_PROCESS.v_refresh_id,
2464: last_update_date = MSC_CL_PRE_PROCESS.v_current_date,
2465: last_updated_by = MSC_CL_PRE_PROCESS.v_current_user,

Line 2462: SET st_transaction_id = msc_st_demands_s.NEXTVAL,

2458:
2459: MSC_CL_PRE_PROCESS.v_sql_stmt := 03;
2460: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
2461: UPDATE msc_st_demands
2462: SET st_transaction_id = msc_st_demands_s.NEXTVAL,
2463: refresh_id = MSC_CL_PRE_PROCESS.v_refresh_id,
2464: last_update_date = MSC_CL_PRE_PROCESS.v_current_date,
2465: last_updated_by = MSC_CL_PRE_PROCESS.v_current_user,
2466: creation_date = MSC_CL_PRE_PROCESS.v_current_date,

Line 2491: (p_table_name => 'MSC_ST_DEMANDS',

2487: lv_where_str :=
2488: ' AND NVL(deleted_flag,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') NOT IN(1,2)';
2489:
2490: lv_return := MSC_ST_UTIL.LOG_ERROR
2491: (p_table_name => 'MSC_ST_DEMANDS',
2492: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2493: p_row => lv_column_names,
2494: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,
2495: p_message_text => lv_message_text,

Line 2522: (p_table_name => 'MSC_ST_DEMANDS',

2518: END IF;
2519:
2520: --Derive Organization_id
2521: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
2522: (p_table_name => 'MSC_ST_DEMANDS',
2523: p_org_partner_name => 'ORGANIZATION_CODE',
2524: p_org_partner_id => 'ORGANIZATION_ID',
2525: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2526: p_partner_type => MSC_CL_PRE_PROCESS.G_ORGANIZATION,

Line 2553: (p_table_name => 'MSC_ST_DEMANDS',

2549: END IF;
2550:
2551: --Derive Inventory_item_id
2552: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
2553: (p_table_name => 'MSC_ST_DEMANDS',
2554: p_item_col_name => 'ITEM_NAME',
2555: p_item_col_id => 'INVENTORY_ITEM_ID',
2556: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
2557: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 2584: (p_table_name => 'MSC_ST_DEMANDS',

2580: END IF;
2581:
2582: --Derive Using_assembly_item_id
2583: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
2584: (p_table_name => 'MSC_ST_DEMANDS',
2585: p_item_col_name => 'USING_ASSEMBLY_ITEM_NAME',
2586: p_item_col_id => 'USING_ASSEMBLY_ITEM_ID',
2587: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
2588: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,

Line 2604: 'UPDATE msc_st_demands msd'

2600: -- Derive WIP_ENTITY_ID
2601: MSC_CL_PRE_PROCESS.v_sql_stmt := 04;
2602:
2603: lv_sql_stmt :=
2604: 'UPDATE msc_st_demands msd'
2605: ||' SET wip_entity_id = ( SELECT local_id '
2606: ||' FROM msc_local_id_supply mlid'
2607: ||' WHERE mlid.char1 = msd.sr_instance_code'
2608: ||' AND NVL(mlid.char2,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 2637: p_token_value3 => 'MSC_ST_DEMANDS' );

2633: ||' ORGANIZATION_CODE,WIP_ENTITY_NAME',
2634: p_token2 => 'MASTER_TABLE',
2635: p_token_value2 => 'MSC_ST_SUPPLIES',
2636: p_token3 => 'CHILD_TABLE' ,
2637: p_token_value3 => 'MSC_ST_DEMANDS' );
2638:
2639: IF lv_return <> 0 THEN
2640: RAISE ex_logging_err;
2641: END IF;

Line 2647: 'UPDATE msc_st_demands '

2643: -- Error out records where WIP_ENTITY_ID is NULL;
2644:
2645: MSC_CL_PRE_PROCESS.v_sql_stmt := 05;
2646: lv_sql_stmt :=
2647: 'UPDATE msc_st_demands '
2648: ||' SET process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
2649: ||' error_text = '||''''||lv_message_text||''''
2650: ||' WHERE NVL(wip_entity_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') ='||MSC_CL_PRE_PROCESS.NULL_VALUE
2651: ||' AND process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS

Line 2684: 'UPDATE msc_st_demands '

2680: -- Error out records where using_assembly_demand_date is NULL
2681:
2682: MSC_CL_PRE_PROCESS.v_sql_stmt := 06;
2683: lv_sql_stmt :=
2684: 'UPDATE msc_st_demands '
2685: ||' SET process_flag = '||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
2686: ||' error_text = '||''''||lv_message_text||''''
2687: ||' WHERE (NVL(using_requirement_quantity,'||MSC_CL_PRE_PROCESS.NULL_VALUE||')='||MSC_CL_PRE_PROCESS.NULL_VALUE
2688: ||' OR NVL(using_assembly_demand_date,SYSDATE-36500) = SYSDATE-36500 )'

Line 2707: ' UPDATE msc_st_demands'

2703: -- Update using_assembly_item_id = inventory_item_id
2704:
2705: MSC_CL_PRE_PROCESS.v_sql_stmt := 07;
2706: lv_sql_stmt :=
2707: ' UPDATE msc_st_demands'
2708: ||' SET using_assembly_item_id = inventory_item_id'
2709: ||' WHERE process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS
2710: ||' AND NVL(using_assembly_item_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = '||MSC_CL_PRE_PROCESS.NULL_VALUE
2711: ||' AND deleted_flag = '||MSC_CL_PRE_PROCESS.SYS_NO

Line 2729: ' UPDATE msc_st_demands'

2725: -- Update order_number = wip_entity_name
2726:
2727: MSC_CL_PRE_PROCESS.v_sql_stmt := 08;
2728: lv_sql_stmt :=
2729: ' UPDATE msc_st_demands'
2730: ||' SET order_number = wip_entity_name'
2731: ||' WHERE process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS
2732: ||' AND deleted_flag = '||MSC_CL_PRE_PROCESS.SYS_NO
2733: ||' AND process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS

Line 2750: ' UPDATE msc_st_demands'

2746: -- Update disposition_id = wip_entity_id
2747:
2748: MSC_CL_PRE_PROCESS.v_sql_stmt := 09;
2749: lv_sql_stmt :=
2750: ' UPDATE msc_st_demands'
2751: ||' SET disposition_id = wip_entity_id'
2752: ||' WHERE process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS
2753: ||' AND NVL(wip_entity_id,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = '||MSC_CL_PRE_PROCESS.NULL_VALUE
2754: ||' AND deleted_flag = '||MSC_CL_PRE_PROCESS.SYS_NO

Line 2774: ' UPDATE msc_st_demands'

2770: -- This is not reqd for flow schedule
2771:
2772: MSC_CL_PRE_PROCESS.v_sql_stmt := 10;
2773: lv_sql_stmt :=
2774: ' UPDATE msc_st_demands'
2775: ||' SET mps_date_required = using_assembly_demand_date'
2776: ||' WHERE process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS
2777: ||' AND NVL(mps_date_required,SYSDATE-36500) = SYSDATE-36500'
2778: ||' AND process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS

Line 2815: (p_table_name => 'MSC_ST_DEMANDS',

2811: ||' AND origination_type =77'
2812: ||' AND ENTITY=''ERO''';
2813:
2814: lv_return := MSC_ST_UTIL.LOG_ERROR
2815: (p_table_name => 'MSC_ST_DEMANDS',
2816: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2817: p_row => lv_column_names,
2818: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,
2819: p_message_text => lv_message_text,

Line 2854: (p_table_name => 'MSC_ST_DEMANDS',

2850: ||' AND origination_type =77'
2851: ||' AND ENTITY=''ERO''' ;
2852:
2853: lv_return := MSC_ST_UTIL.LOG_ERROR
2854: (p_table_name => 'MSC_ST_DEMANDS',
2855: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2856: p_row => lv_column_names,
2857: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,
2858: p_message_text => lv_message_text,

Line 2874: ' UPDATE msc_st_demands'

2870: -- If routing_name is is NULL populate the item_name in routing name
2871:
2872: MSC_CL_PRE_PROCESS.v_sql_stmt := 11;
2873: lv_sql_stmt :=
2874: ' UPDATE msc_st_demands'
2875: ||' SET routing_name = nvl(USING_ASSEMBLY_ITEM_NAME,item_name)' /* bug 3768813 */
2876: ||' WHERE process_flag = '||MSC_CL_PRE_PROCESS.G_IN_PROCESS
2877: ||' AND NVL(routing_name,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||')'
2878: ||' = '||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''

Line 2897: (p_table_name => 'MSC_ST_DEMANDS',

2893:
2894: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
2895:
2896: lv_return :=msc_st_util.derive_routing_sequence_id
2897: (p_table_name => 'MSC_ST_DEMANDS',
2898: p_rtg_col_name => 'ROUTING_NAME',
2899: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
2900: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
2901: p_batch_id => lv_batch_id,

Line 2912: 'update msc_st_demands msd'

2908: end if;
2909:
2910: MSC_CL_PRE_PROCESS.v_sql_stmt := 11;
2911: lv_sql_stmt:=
2912: 'update msc_st_demands msd'
2913: ||' set operation_seq_num = '
2914: ||' (select operation_seq_num '
2915: ||' from msc_routing_operations mro '
2916: ||' where mro.routing_sequence_id = msd.routing_sequence_id and '

Line 2938: 'UPDATE msc_st_demands msd'

2934: -- Derive operation seq num from local id table
2935:
2936: MSC_CL_PRE_PROCESS.v_sql_stmt := 12;
2937: lv_sql_stmt:=
2938: 'UPDATE msc_st_demands msd'
2939: ||' SET operation_seq_num= (SELECT number1'
2940: ||' FROM msc_local_id_setup mlis'
2941: ||' WHERE mlis.char1 = msd.sr_instance_code'
2942: ||' AND NVL(mlis.char2,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 2981: 'UPDATE msc_st_demands '

2977:
2978: MSC_CL_PRE_PROCESS.v_sql_stmt := 13;
2979:
2980: lv_sql_stmt :=
2981: 'UPDATE msc_st_demands '
2982: ||' SET process_flag ='||MSC_CL_PRE_PROCESS.G_ERROR_FLG||','
2983: ||' error_text = '||''''||lv_message_text||''''
2984: ||' WHERE NVL(operation_seq_num,'||MSC_CL_PRE_PROCESS.NULL_VALUE||') = '||MSC_CL_PRE_PROCESS.NULL_VALUE
2985: ||' AND deleted_flag ='||MSC_CL_PRE_PROCESS.SYS_YES

Line 3015: (p_table_name => 'MSC_ST_DEMANDS',

3011: END IF;
3012:
3013: --Derive Project Id.
3014: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
3015: (p_table_name => 'MSC_ST_DEMANDS',
3016: p_proj_col_name => 'PROJECT_NUMBER',
3017: p_proj_task_col_id => 'PROJECT_ID',
3018: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3019: p_entity_name => 'PROJECT_ID',

Line 3049: (p_table_name => 'MSC_ST_DEMANDS',

3045: END IF;
3046:
3047: --Derive Task Id.
3048: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
3049: (p_table_name => 'MSC_ST_DEMANDS',
3050: p_proj_col_name => 'PROJECT_NUMBER',
3051: p_proj_task_col_id => 'TASK_ID',
3052: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3053: p_entity_name => 'TASK_ID',

Line 3088: (p_table_name => 'MSC_ST_DEMANDS',

3084: ||' AND origination_type =77 AND deleted_flag ='||MSC_CL_PRE_PROCESS.SYS_NO
3085: ||' AND ENTITY=''ERO''' ;
3086:
3087: lv_return := MSC_ST_UTIL.LOG_ERROR
3088: (p_table_name => 'MSC_ST_DEMANDS',
3089: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3090: p_row => lv_column_names,
3091: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,
3092: p_message_text => lv_message_text,

Line 3127: (p_table_name => 'MSC_ST_DEMANDS',

3123: ||' AND origination_type =77 AND deleted_flag ='||MSC_CL_PRE_PROCESS.SYS_NO
3124: ||' AND ENTITY=''ERO''' ;
3125:
3126: lv_return := MSC_ST_UTIL.LOG_ERROR
3127: (p_table_name => 'MSC_ST_DEMANDS',
3128: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3129: p_row => lv_column_names,
3130: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,
3131: p_message_text => lv_message_text,

Line 3166: (p_table_name => 'MSC_ST_DEMANDS',

3162: ||' AND origination_type =77 AND deleted_flag ='||MSC_CL_PRE_PROCESS.SYS_NO
3163: ||' AND ENTITY=''ERO''' ;
3164:
3165: lv_return := MSC_ST_UTIL.LOG_ERROR
3166: (p_table_name => 'MSC_ST_DEMANDS',
3167: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3168: p_row => lv_column_names,
3169: p_severity => MSC_CL_PRE_PROCESS.G_SEV_WARNING,
3170: p_message_text => lv_message_text,

Line 3188: pEntityName => 'MSC_ST_DEMANDS',

3184: (ERRBUF => lv_error_text,
3185: RETCODE => lv_return,
3186: pBatchID => lv_batch_id,
3187: pInstanceCode => MSC_CL_PRE_PROCESS.v_instance_code,
3188: pEntityName => 'MSC_ST_DEMANDS',
3189: pInstanceID => MSC_CL_PRE_PROCESS.v_instance_id);
3190:
3191: IF NVL(lv_return,0) <> 0 THEN
3192: RAISE ex_logging_err;

Line 3208: UPDATE msc_st_demands

3204: -- SELECT msc_st_operation_sequence_id_s.NEXTVAL
3205: -- INTO lv_local_id
3206: -- FROM DUAL;
3207:
3208: UPDATE msc_st_demands
3209: SET operation_seq_num =
3210: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),
3211: NULL,operation_seq_code,'1'))
3212: WHERE rowid = lb_rowid(j);

Line 3268: FROM msc_st_demands

3264: MSC_CL_PRE_PROCESS.v_current_date,
3265: MSC_CL_PRE_PROCESS.v_current_user,
3266: MSC_CL_PRE_PROCESS.v_current_date,
3267: MSC_CL_PRE_PROCESS.v_current_user
3268: FROM msc_st_demands
3269: WHERE rowid = lb_rowid(j) ;
3270:
3271: END IF;
3272: CLOSE c2;

Line 3278: 'UPDATE msc_st_demands msd'

3274: -- Update operation seq num from local id table
3275:
3276: MSC_CL_PRE_PROCESS.v_sql_stmt := 12;
3277: lv_sql_stmt:=
3278: 'UPDATE msc_st_demands msd'
3279: ||' SET operation_seq_num= (SELECT number1'
3280: ||' FROM msc_local_id_setup mlis'
3281: ||' WHERE mlis.char1 = msd.sr_instance_code'
3282: ||' AND NVL(mlis.char2,'||''''||MSC_CL_PRE_PROCESS.NULL_CHAR||''''||') '

Line 3305: (p_table_name => 'MSC_ST_DEMANDS',

3301: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_PRE_PROCESS.v_instance_code,lv_batch_id;
3302:
3303:
3304: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
3305: (p_table_name => 'MSC_ST_DEMANDS',
3306: p_instance_id => MSC_CL_PRE_PROCESS.v_instance_id,
3307: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3308: p_process_flag => MSC_CL_PRE_PROCESS.G_VALID,
3309: p_error_text => lv_error_text,

Line 3318: (p_table_name => 'MSC_ST_DEMANDS',

3314: RAISE ex_logging_err;
3315: END IF;
3316:
3317: lv_return := MSC_ST_UTIL.LOG_ERROR
3318: (p_table_name => 'MSC_ST_DEMANDS',
3319: p_instance_code => MSC_CL_PRE_PROCESS.v_instance_code,
3320: p_row => lv_column_names,
3321: p_severity => MSC_CL_PRE_PROCESS.G_SEV_ERROR,
3322: p_message_text => NULL,