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_PROJECT_TASKS

Line 1023: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code

1019: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1020: application_short_name => 'MSC',
1021: statement_type => AD_DDL.CREATE_INDEX,
1022: statement =>
1023: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code
1024: ||' on MSC_ST_PROJECT_TASKS '
1025: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '
1026: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1027: object_name =>'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);

Line 1024: ||' on MSC_ST_PROJECT_TASKS '

1020: application_short_name => 'MSC',
1021: statement_type => AD_DDL.CREATE_INDEX,
1022: statement =>
1023: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code
1024: ||' on MSC_ST_PROJECT_TASKS '
1025: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '
1026: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1027: object_name =>'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1028:

Line 1027: object_name =>'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);

1023: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code
1024: ||' on MSC_ST_PROJECT_TASKS '
1025: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '
1026: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1027: object_name =>'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1028:
1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1030:
1031: EXCEPTION

Line 1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);

1025: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '
1026: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1027: object_name =>'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1028:
1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1030:
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

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

1029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1030:
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1034: END;
1035:
1036: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PROJECT_TASKS', v_instance_id, -1);
1037:

Line 1036: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PROJECT_TASKS', v_instance_id, -1);

1032: WHEN OTHERS THEN
1033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1034: END;
1035:
1036: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PROJECT_TASKS', v_instance_id, -1);
1037:
1038: END IF;
1039:
1040: IF v_dmd_class_enabled = SYS_YES THEN

Line 2258: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,

2254: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2255: application_short_name => 'MSC',
2256: statement_type => AD_DDL.DROP_INDEX,
2257: statement =>
2258: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,
2259: object_name => 'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2260:
2261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2262:

Line 2259: object_name => 'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);

2255: application_short_name => 'MSC',
2256: statement_type => AD_DDL.DROP_INDEX,
2257: statement =>
2258: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,
2259: object_name => 'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2260:
2261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2262:
2263:

Line 2261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);

2257: statement =>
2258: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,
2259: object_name => 'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2260:
2261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2262:
2263:
2264: EXCEPTION
2265: WHEN OTHERS THEN

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

2262:
2263:
2264: EXCEPTION
2265: WHEN OTHERS THEN
2266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2267: END;
2268:
2269: END IF;
2270:

Line 26909: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

26905: p_token1 => 'COLUMN_NAMES',
26906: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
26907: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
26908: p_token2 => 'MASTER_TABLE',
26909: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
26910:
26911: IF lv_return <> 0 THEN
26912: RAISE ex_logging_err;
26913: END IF;

Line 26942: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

26938: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
26939: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
26940: ||' TASK_NUMBER',
26941: p_token2 => 'MASTER_TABLE',
26942: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
26943:
26944: IF lv_return <> 0 THEN
26945: RAISE ex_logging_err;
26946: END IF;

Line 29645: lv_batch_id msc_st_project_tasks.batch_id%TYPE;

29641: lv_error_text VARCHAR2(250);
29642: lv_where_str VARCHAR2(5000);
29643: lv_sql_stmt VARCHAR2(5000);
29644: lv_cursor_stmt VARCHAR2(5000);
29645: lv_batch_id msc_st_project_tasks.batch_id%TYPE;
29646: lv_message_text msc_errors.error_text%TYPE;
29647:
29648: ex_logging_err EXCEPTION;
29649:

Line 29652: FROM msc_st_project_tasks

29648: ex_logging_err EXCEPTION;
29649:
29650: CURSOR c2(p_batch_id NUMBER) IS
29651: SELECT rowid
29652: FROM msc_st_project_tasks
29653: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
29654: AND sr_instance_code = v_instance_code
29655: AND batch_id = p_batch_id;
29656:

Line 29659: FROM msc_st_project_tasks

29655: AND batch_id = p_batch_id;
29656:
29657: CURSOR c3(p_batch_id NUMBER) IS
29658: SELECT max(rowid)
29659: FROM msc_st_project_tasks
29660: WHERE process_flag = G_IN_PROCESS
29661: AND sr_instance_code = v_instance_code
29662: AND batch_id = p_batch_id
29663: AND NVL(project_id,NULL_VALUE) = NULL_VALUE

Line 29670: FROM msc_st_project_tasks

29666: project_number ;
29667:
29668: CURSOR c4(p_batch_id NUMBER) IS
29669: SELECT MAX(rowid)
29670: FROM msc_st_project_tasks
29671: WHERE process_flag = G_IN_PROCESS
29672: AND sr_instance_code = v_instance_code
29673: AND batch_id = p_batch_id
29674: AND NVL(task_id,NULL_VALUE) = NULL_VALUE

Line 29683: FROM msc_st_project_tasks

29679:
29680:
29681: CURSOR c5(p_batch_id NUMBER) IS
29682: SELECT max(rowid)
29683: FROM msc_st_project_tasks
29684: WHERE process_flag = G_IN_PROCESS
29685: AND sr_instance_code = v_instance_code
29686: AND batch_id = p_batch_id
29687: AND NVL(costing_group_id,NULL_VALUE) = NULL_VALUE

Line 29710: 'UPDATE msc_st_project_tasks mspt1 '

29706: END IF;
29707:
29708: v_sql_stmt := 01;
29709: lv_sql_stmt:=
29710: 'UPDATE msc_st_project_tasks mspt1 '
29711: ||' SET process_flag ='||G_ERROR_FLG||','
29712: ||' error_text = '||''''||lv_message_text||''''
29713: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_project_tasks mspt2'
29714: ||' WHERE mspt2.sr_instance_code = mspt1.sr_instance_code'

Line 29713: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_project_tasks mspt2'

29709: lv_sql_stmt:=
29710: 'UPDATE msc_st_project_tasks mspt1 '
29711: ||' SET process_flag ='||G_ERROR_FLG||','
29712: ||' error_text = '||''''||lv_message_text||''''
29713: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_project_tasks mspt2'
29714: ||' WHERE mspt2.sr_instance_code = mspt1.sr_instance_code'
29715: ||' AND NVL(mspt2.company_name,'||''''||NULL_CHAR||''''||') '
29716: ||' = NVL(mspt1.company_name,'||''''||NULL_CHAR||''''||') '
29717: ||' AND mspt2.organization_code = mspt1.organization_code'

Line 29747: 'UPDATE msc_st_project_tasks mspt1'

29743:
29744: v_sql_stmt := 02;
29745:
29746: lv_sql_stmt :=
29747: 'UPDATE msc_st_project_tasks mspt1'
29748: ||' SET process_flag ='|| G_ERROR_FLG||','
29749: ||' error_text = '||''''||lv_message_text||''''
29750: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_project_tasks mspt2'
29751: ||' WHERE mspt2.sr_instance_code = mspt1.sr_instance_code'

Line 29750: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_project_tasks mspt2'

29746: lv_sql_stmt :=
29747: 'UPDATE msc_st_project_tasks mspt1'
29748: ||' SET process_flag ='|| G_ERROR_FLG||','
29749: ||' error_text = '||''''||lv_message_text||''''
29750: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_project_tasks mspt2'
29751: ||' WHERE mspt2.sr_instance_code = mspt1.sr_instance_code'
29752: ||' AND NVL(mspt2.company_name,'||''''||NULL_CHAR||''''||') '
29753: ||' = NVL(mspt1.company_name,'||''''||NULL_CHAR||''''||') '
29754: ||' AND mspt2.organization_code = mspt1.organization_code'

Line 29806: ' UPDATE msc_st_project_tasks '

29802: CLOSE c1;
29803:
29804: v_sql_stmt := 04;
29805: lv_sql_stmt :=
29806: ' UPDATE msc_st_project_tasks '
29807: ||' SET batch_id = :lv_batch_id'
29808: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
29809: ||' AND sr_instance_code = :v_instance_code'
29810: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 29826: UPDATE msc_st_project_tasks

29822: CLOSE c2;
29823:
29824: v_sql_stmt := 05;
29825: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29826: UPDATE msc_st_project_tasks
29827: SET st_transaction_id = msc_st_project_tasks_s.NEXTVAL,
29828: refresh_id = v_refresh_id,
29829: last_update_date = v_current_date,
29830: last_updated_by = v_current_user,

Line 29827: SET st_transaction_id = msc_st_project_tasks_s.NEXTVAL,

29823:
29824: v_sql_stmt := 05;
29825: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29826: UPDATE msc_st_project_tasks
29827: SET st_transaction_id = msc_st_project_tasks_s.NEXTVAL,
29828: refresh_id = v_refresh_id,
29829: last_update_date = v_current_date,
29830: last_updated_by = v_current_user,
29831: creation_date = v_current_date,

Line 29843: p_token_value1 => 'MSC_ST_PROJECT_TASKS');

29839: p_error_code => 'MSC_PP_NO_DELETION',
29840: p_message_text => lv_message_text,
29841: p_error_text => lv_error_text,
29842: p_token1 => 'TABLE_NAME',
29843: p_token_value1 => 'MSC_ST_PROJECT_TASKS');
29844:
29845: IF lv_return <> 0 THEN
29846: RAISE ex_logging_err;
29847: END IF;

Line 29852: ' UPDATE msc_st_project_tasks '

29848:
29849: --Deletion is not allowed on this table.
29850: v_sql_stmt := 06;
29851: lv_sql_stmt :=
29852: ' UPDATE msc_st_project_tasks '
29853: ||' SET process_flag = '||G_ERROR_FLG||','
29854: ||' error_text = '||''''||lv_message_text||''''
29855: ||' WHERE deleted_flag = '||SYS_YES
29856: ||' AND process_flag = '||G_IN_PROCESS

Line 29882: ' UPDATE msc_st_project_tasks '

29878: -- Error out record if project_number is NULL
29879:
29880: v_sql_stmt := 07;
29881: lv_sql_stmt :=
29882: ' UPDATE msc_st_project_tasks '
29883: ||' SET process_flag = '||G_ERROR_FLG||','
29884: ||' error_text = '||''''||lv_message_text||''''
29885: ||' WHERE NVL(project_number,'||''''||NULL_CHAR||''''||')'
29886: ||' = '||''''||NULL_CHAR||''''

Line 29913: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name =>'MSC_ST_PROJECT_TASKS',

29909: END IF;
29910:
29911: -- Derive organization id
29912: lv_return :=
29913: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name =>'MSC_ST_PROJECT_TASKS',
29914: p_org_partner_name =>'ORGANIZATION_CODE',
29915: p_org_partner_id =>'ORGANIZATION_ID',
29916: p_instance_code => v_instance_code,
29917: p_partner_type => G_ORGANIZATION,

Line 29950: (p_table_name => 'MSC_ST_PROJECT_TASKS',

29946: lv_where_str :=
29947: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
29948:
29949: lv_return := MSC_ST_UTIL.LOG_ERROR
29950: (p_table_name => 'MSC_ST_PROJECT_TASKS',
29951: p_instance_code => v_instance_code,
29952: p_row => lv_column_names,
29953: p_severity => G_SEV_WARNING,
29954: p_message_text => lv_message_text,

Line 29988: (p_table_name => 'MSC_ST_PROJECT_TASKS',

29984:
29985: lv_where_str := ' AND NVL(seiban_number_flag,'||NULL_VALUE||') NOT IN (1,2) ';
29986:
29987: lv_return := MSC_ST_UTIL.LOG_ERROR
29988: (p_table_name => 'MSC_ST_PROJECT_TASKS',
29989: p_instance_code => v_instance_code,
29990: p_row => lv_column_names,
29991: p_severity => G_SEV_WARNING,
29992: p_message_text => lv_message_text,

Line 30006: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name => 'MSC_ST_PROJECT_TASKS',

30002: END IF;
30003:
30004: -- Derive Project id
30005: lv_return :=
30006: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name => 'MSC_ST_PROJECT_TASKS',
30007: p_proj_col_name => 'PROJECT_NUMBER',
30008: p_proj_task_col_id => 'PROJECT_ID',
30009: p_instance_code => v_instance_code,
30010: p_entity_name => 'PROJECT_ID',

Line 30022: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name =>'MSC_ST_PROJECT_TASKS',

30018: END IF;
30019:
30020: -- Derive task id
30021: lv_return :=
30022: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name =>'MSC_ST_PROJECT_TASKS',
30023: p_proj_col_name =>'PROJECT_NUMBER',
30024: p_proj_task_col_id =>'TASK_ID',
30025: p_task_col_name =>'TASK_NUMBER',
30026: p_instance_code => v_instance_code,

Line 30041: 'UPDATE msc_st_project_tasks '

30037: -- UPdate task_name with the task_number
30038:
30039: v_sql_stmt := 07;
30040: lv_sql_stmt :=
30041: 'UPDATE msc_st_project_tasks '
30042: ||' SET task_name = task_number'
30043: ||' WHERE sr_instance_code = :v_instance_code'
30044: ||' AND process_flag = '||G_IN_PROCESS
30045: ||' AND NVL(task_number,'||''''||NULL_CHAR||''''||') '

Line 30060: 'UPDATE msc_st_project_tasks mstp'

30056:
30057: v_sql_stmt := 08;
30058:
30059: lv_sql_stmt :=
30060: 'UPDATE msc_st_project_tasks mstp'
30061: ||' SET costing_group_id = ( SELECT local_id '
30062: ||' FROM msc_local_id_misc mlim'
30063: ||' WHERE mlim.char1 = mstp.sr_instance_code'
30064: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 30087: pEntityName => 'MSC_ST_PROJECT_TASKS',

30083: (ERRBUF => lv_error_text,
30084: RETCODE => lv_return,
30085: pBatchID => lv_batch_id,
30086: pInstanceCode => v_instance_code,
30087: pEntityName => 'MSC_ST_PROJECT_TASKS',
30088: pInstanceID => v_instance_id);
30089:
30090: IF NVL(lv_return,0) <> 0 THEN
30091: RAISE ex_logging_err;

Line 30105: UPDATE msc_st_project_tasks

30101: IF c5%ROWCOUNT > 0 THEN
30102:
30103: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30104:
30105: UPDATE msc_st_project_tasks
30106: SET costing_group_id = msc_st_costing_group_id_s.NEXTVAL
30107: WHERE rowid = lb_rowid(j);
30108:
30109:

Line 30147: FROM msc_st_project_tasks

30143: v_current_date,
30144: v_current_user,
30145: v_current_date,
30146: v_current_user
30147: FROM msc_st_project_tasks
30148: WHERE rowid = lb_rowid(j);
30149: END IF;
30150: CLOSE c5;
30151:

Line 30157: 'UPDATE msc_st_project_tasks mstp'

30153:
30154: v_sql_stmt := 11;
30155:
30156: lv_sql_stmt :=
30157: 'UPDATE msc_st_project_tasks mstp'
30158: ||' SET costing_group_id = ( SELECT local_id '
30159: ||' FROM msc_local_id_misc mlim'
30160: ||' WHERE mlim.char1 = mstp.sr_instance_code'
30161: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 30190: UPDATE msc_st_project_tasks

30186: IF c3%ROWCOUNT > 0 THEN
30187:
30188: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30189:
30190: UPDATE msc_st_project_tasks
30191: SET project_id = msc_st_project_id_s.NEXTVAL
30192: WHERE rowid = lb_rowid(j);
30193:
30194:

Line 30234: FROM msc_st_project_tasks

30230: v_current_date,
30231: v_current_user,
30232: v_current_date,
30233: v_current_user
30234: FROM msc_st_project_tasks
30235: WHERE rowid = lb_rowid(j);
30236: END IF;
30237:
30238: CLOSE c3;

Line 30242: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name => 'MSC_ST_PROJECT_TASKS',

30238: CLOSE c3;
30239:
30240: -- Derive Project id
30241: lv_return :=
30242: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name => 'MSC_ST_PROJECT_TASKS',
30243: p_proj_col_name => 'PROJECT_NUMBER',
30244: p_proj_task_col_id => 'PROJECT_ID',
30245: p_instance_code => v_instance_code,
30246: p_entity_name => 'PROJECT_ID',

Line 30267: UPDATE msc_st_project_tasks

30263: IF c4%ROWCOUNT > 0 THEN
30264:
30265: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
30266:
30267: UPDATE msc_st_project_tasks
30268: SET task_id = msc_st_task_id_s.NEXTVAL
30269: WHERE rowid = lb_rowid(j);
30270:
30271: v_sql_stmt := 15;

Line 30314: FROM msc_st_project_tasks

30310: v_current_date,
30311: v_current_user,
30312: v_current_date,
30313: v_current_user
30314: FROM msc_st_project_tasks
30315: WHERE rowid = lb_rowid(j);
30316: END IF;
30317: CLOSE c4;
30318:

Line 30321: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name =>'MSC_ST_PROJECT_TASKS',

30317: CLOSE c4;
30318:
30319: -- Derive task id
30320: lv_return :=
30321: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name =>'MSC_ST_PROJECT_TASKS',
30322: p_proj_col_name =>'PROJECT_NUMBER',
30323: p_proj_task_col_id =>'TASK_ID',
30324: p_task_col_name =>'TASK_NUMBER',
30325: p_instance_code => v_instance_code,

Line 30379: ||' FROM msc_st_project_tasks'

30375: ||' last_update_date,'
30376: ||' last_updated_by,'
30377: ||' creation_date,'
30378: ||' created_by'
30379: ||' FROM msc_st_project_tasks'
30380: ||' WHERE sr_instance_code = :v_instance_code'
30381: ||' AND process_flag = '||G_IN_PROCESS
30382: ||' AND batch_id = :lv_batch_id' ;
30383:

Line 30390: ' DELETE FROM msc_st_project_tasks '

30386: -- Delete all the records from msc_st_projects_tasks where task number is NULL
30387: -- This is done as records with only task name is inserted in msc_st_projects_tasks
30388:
30389: lv_sql_stmt :=
30390: ' DELETE FROM msc_st_project_tasks '
30391: ||' WHERE NVL(task_number, '||''''||NULL_CHAR||''''||') '
30392: ||' = '||''''||NULL_CHAR||''''
30393: ||' AND sr_instance_code = :v_instance_code'
30394: ||' AND process_flag = '||G_IN_PROCESS

Line 30401: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_PROJECT_TASKS',

30397: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
30398:
30399: -- Set the process flag as Valid and poulate instance_id
30400: lv_return :=
30401: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_PROJECT_TASKS',
30402: p_instance_id => v_instance_id,
30403: p_instance_code => v_instance_code,
30404: p_process_flag => G_VALID,
30405: p_error_text => lv_error_text,

Line 30417: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_PROJECT_TASKS',

30413:
30414: -- At the end calling the LOG_ERROR for logging all errored out records
30415:
30416: lv_return :=
30417: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_PROJECT_TASKS',
30418: p_instance_code => v_instance_code,
30419: p_row => lv_column_names,
30420: p_severity => G_SEV_ERROR,
30421: p_message_text => NULL,

Line 35017: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

35013: p_token1 => 'COLUMN_NAMES',
35014: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
35015: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
35016: p_token2 => 'MASTER_TABLE',
35017: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
35018:
35019: IF lv_return <> 0 THEN
35020: RAISE ex_logging_err;
35021: END IF;

Line 35050: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

35046: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
35047: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
35048: ||' TASK_NUMBER',
35049: p_token2 => 'MASTER_TABLE',
35050: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
35051:
35052: IF lv_return <> 0 THEN
35053: RAISE ex_logging_err;
35054: END IF;

Line 36937: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

36933: p_token1 => 'COLUMN_NAMES',
36934: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
36935: ||'ORGANIZATION_CODE,PROJECT_NUMBER',
36936: p_token2 => 'MASTER_TABLE',
36937: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
36938:
36939: IF lv_return <> 0 THEN
36940: RAISE ex_logging_err;
36941: END IF;

Line 36971: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

36967: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
36968: ||'ORGANIZATION_CODE,PROJECT_NUMBER,'
36969: ||'TASK_NUMBER' ,
36970: p_token2 => 'MASTER_TABLE',
36971: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
36972:
36973: IF lv_return <> 0 THEN
36974: RAISE ex_logging_err;
36975: END IF;

Line 38452: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

38448: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
38449: ||'ORGANIZATION_CODE,PROJECT_NUMBER'
38450: ||'TASK_NUMBER' ,
38451: p_token2 => 'MASTER_TABLE',
38452: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
38453:
38454: IF lv_return <> 0 THEN
38455: RAISE ex_logging_err;
38456: END IF;

Line 39155: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

39151: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
39152: ||'ORGANIZATION_CODE,PROJECT_NUMBER'
39153: ||'TASK_NUMBER' ,
39154: p_token2 => 'MASTER_TABLE',
39155: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
39156:
39157: IF lv_return <> 0 THEN
39158: RAISE ex_logging_err;
39159: END IF;

Line 43935: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

43931: p_token1 => 'COLUMN_NAMES',
43932: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
43933: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
43934: p_token2 => 'MASTER_TABLE',
43935: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
43936:
43937: IF lv_return <> 0 THEN
43938: RAISE ex_logging_err;
43939: END IF;

Line 43969: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

43965: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
43966: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
43967: ||' TASK_NUMBER',
43968: p_token2 => 'MASTER_TABLE',
43969: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
43970:
43971: IF lv_return <> 0 THEN
43972: RAISE ex_logging_err;
43973: END IF;

Line 48233: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

48229: p_token1 => 'COLUMN_NAMES',
48230: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
48231: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
48232: p_token2 => 'MASTER_TABLE',
48233: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
48234:
48235: IF lv_return <> 0 THEN
48236: RAISE ex_logging_err;
48237: END IF;

Line 48266: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

48262: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
48263: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
48264: ||' TASK_NUMBER',
48265: p_token2 => 'MASTER_TABLE',
48266: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
48267:
48268: IF lv_return <> 0 THEN
48269: RAISE ex_logging_err;
48270: END IF;

Line 50363: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

50359: p_token1 => 'COLUMN_NAMES',
50360: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
50361: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
50362: p_token2 => 'MASTER_TABLE',
50363: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
50364:
50365: IF lv_return <> 0 THEN
50366: RAISE ex_logging_err;
50367: END IF;

Line 50397: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

50393: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
50394: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
50395: ||' TASK_NUMBER',
50396: p_token2 => 'MASTER_TABLE',
50397: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
50398:
50399: IF lv_return <> 0 THEN
50400: RAISE ex_logging_err;
50401: END IF;

Line 55978: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_PROJECT_TASKS');

55974: End IF;
55975: END IF;
55976:
55977: IF v_project_enabled = SYS_YES THEN
55978: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_PROJECT_TASKS');
55979: IF lv_count > 0 Then
55980: prec.project_flag:= SYS_YES;
55981: End IF;
55982: END IF;