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.

[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_PROJECT_TASKS

Line 1015: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code

1011: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1012: application_short_name => 'MSC',
1013: statement_type => AD_DDL.CREATE_INDEX,
1014: statement =>
1015: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code
1016: ||' on MSC_ST_PROJECT_TASKS '
1017: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '
1018: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1019: object_name =>'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);

Line 1016: ||' on MSC_ST_PROJECT_TASKS '

1012: application_short_name => 'MSC',
1013: statement_type => AD_DDL.CREATE_INDEX,
1014: statement =>
1015: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code
1016: ||' on MSC_ST_PROJECT_TASKS '
1017: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '
1018: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1019: object_name =>'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1020:

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

1015: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code
1016: ||' on MSC_ST_PROJECT_TASKS '
1017: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '
1018: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1019: object_name =>'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1020:
1021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1022:
1023: EXCEPTION

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

1017: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '
1018: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1019: object_name =>'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1020:
1021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: 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 1025: 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));

1021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: 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));
1026: END;
1027:
1028: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PROJECT_TASKS', v_instance_id, -1);
1029:

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

1024: WHEN OTHERS THEN
1025: 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));
1026: END;
1027:
1028: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PROJECT_TASKS', v_instance_id, -1);
1029:
1030: END IF;
1031:
1032: IF v_dmd_class_enabled = SYS_YES THEN

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

2246: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2247: application_short_name => 'MSC',
2248: statement_type => AD_DDL.DROP_INDEX,
2249: statement =>
2250: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,
2251: object_name => 'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2252:
2253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2254:

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

2247: application_short_name => 'MSC',
2248: statement_type => AD_DDL.DROP_INDEX,
2249: statement =>
2250: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,
2251: object_name => 'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2252:
2253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2254:
2255:

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

2249: statement =>
2250: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,
2251: object_name => 'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2252:
2253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2254:
2255:
2256: EXCEPTION
2257: WHEN OTHERS THEN

Line 2258: 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));

2254:
2255:
2256: EXCEPTION
2257: WHEN OTHERS THEN
2258: 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));
2259: END;
2260:
2261: END IF;
2262:

Line 23420: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

23416: p_token1 => 'COLUMN_NAMES',
23417: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
23418: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
23419: p_token2 => 'MASTER_TABLE',
23420: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
23421:
23422: IF lv_return <> 0 THEN
23423: RAISE ex_logging_err;
23424: END IF;

Line 23453: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

23449: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
23450: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
23451: ||' TASK_NUMBER',
23452: p_token2 => 'MASTER_TABLE',
23453: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
23454:
23455: IF lv_return <> 0 THEN
23456: RAISE ex_logging_err;
23457: END IF;

Line 26131: lv_batch_id msc_st_project_tasks.batch_id%TYPE;

26127: lv_error_text VARCHAR2(250);
26128: lv_where_str VARCHAR2(5000);
26129: lv_sql_stmt VARCHAR2(5000);
26130: lv_cursor_stmt VARCHAR2(5000);
26131: lv_batch_id msc_st_project_tasks.batch_id%TYPE;
26132: lv_message_text msc_errors.error_text%TYPE;
26133:
26134: ex_logging_err EXCEPTION;
26135:

Line 26138: FROM msc_st_project_tasks

26134: ex_logging_err EXCEPTION;
26135:
26136: CURSOR c2(p_batch_id NUMBER) IS
26137: SELECT rowid
26138: FROM msc_st_project_tasks
26139: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
26140: AND sr_instance_code = v_instance_code
26141: AND batch_id = p_batch_id;
26142:

Line 26145: FROM msc_st_project_tasks

26141: AND batch_id = p_batch_id;
26142:
26143: CURSOR c3(p_batch_id NUMBER) IS
26144: SELECT max(rowid)
26145: FROM msc_st_project_tasks
26146: WHERE process_flag = G_IN_PROCESS
26147: AND sr_instance_code = v_instance_code
26148: AND batch_id = p_batch_id
26149: AND NVL(project_id,NULL_VALUE) = NULL_VALUE

Line 26156: FROM msc_st_project_tasks

26152: project_number ;
26153:
26154: CURSOR c4(p_batch_id NUMBER) IS
26155: SELECT MAX(rowid)
26156: FROM msc_st_project_tasks
26157: WHERE process_flag = G_IN_PROCESS
26158: AND sr_instance_code = v_instance_code
26159: AND batch_id = p_batch_id
26160: AND NVL(task_id,NULL_VALUE) = NULL_VALUE

Line 26169: FROM msc_st_project_tasks

26165:
26166:
26167: CURSOR c5(p_batch_id NUMBER) IS
26168: SELECT max(rowid)
26169: FROM msc_st_project_tasks
26170: WHERE process_flag = G_IN_PROCESS
26171: AND sr_instance_code = v_instance_code
26172: AND batch_id = p_batch_id
26173: AND NVL(costing_group_id,NULL_VALUE) = NULL_VALUE

Line 26196: 'UPDATE msc_st_project_tasks mspt1 '

26192: END IF;
26193:
26194: v_sql_stmt := 01;
26195: lv_sql_stmt:=
26196: 'UPDATE msc_st_project_tasks mspt1 '
26197: ||' SET process_flag ='||G_ERROR_FLG||','
26198: ||' error_text = '||''''||lv_message_text||''''
26199: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_project_tasks mspt2'
26200: ||' WHERE mspt2.sr_instance_code = mspt1.sr_instance_code'

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

26195: lv_sql_stmt:=
26196: 'UPDATE msc_st_project_tasks mspt1 '
26197: ||' SET process_flag ='||G_ERROR_FLG||','
26198: ||' error_text = '||''''||lv_message_text||''''
26199: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_project_tasks mspt2'
26200: ||' WHERE mspt2.sr_instance_code = mspt1.sr_instance_code'
26201: ||' AND NVL(mspt2.company_name,'||''''||NULL_CHAR||''''||') '
26202: ||' = NVL(mspt1.company_name,'||''''||NULL_CHAR||''''||') '
26203: ||' AND mspt2.organization_code = mspt1.organization_code'

Line 26233: 'UPDATE msc_st_project_tasks mspt1'

26229:
26230: v_sql_stmt := 02;
26231:
26232: lv_sql_stmt :=
26233: 'UPDATE msc_st_project_tasks mspt1'
26234: ||' SET process_flag ='|| G_ERROR_FLG||','
26235: ||' error_text = '||''''||lv_message_text||''''
26236: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_project_tasks mspt2'
26237: ||' WHERE mspt2.sr_instance_code = mspt1.sr_instance_code'

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

26232: lv_sql_stmt :=
26233: 'UPDATE msc_st_project_tasks mspt1'
26234: ||' SET process_flag ='|| G_ERROR_FLG||','
26235: ||' error_text = '||''''||lv_message_text||''''
26236: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_project_tasks mspt2'
26237: ||' WHERE mspt2.sr_instance_code = mspt1.sr_instance_code'
26238: ||' AND NVL(mspt2.company_name,'||''''||NULL_CHAR||''''||') '
26239: ||' = NVL(mspt1.company_name,'||''''||NULL_CHAR||''''||') '
26240: ||' AND mspt2.organization_code = mspt1.organization_code'

Line 26292: ' UPDATE msc_st_project_tasks '

26288: CLOSE c1;
26289:
26290: v_sql_stmt := 04;
26291: lv_sql_stmt :=
26292: ' UPDATE msc_st_project_tasks '
26293: ||' SET batch_id = :lv_batch_id'
26294: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
26295: ||' AND sr_instance_code = :v_instance_code'
26296: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 26312: UPDATE msc_st_project_tasks

26308: CLOSE c2;
26309:
26310: v_sql_stmt := 05;
26311: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26312: UPDATE msc_st_project_tasks
26313: SET st_transaction_id = msc_st_project_tasks_s.NEXTVAL,
26314: refresh_id = v_refresh_id,
26315: last_update_date = v_current_date,
26316: last_updated_by = v_current_user,

Line 26313: SET st_transaction_id = msc_st_project_tasks_s.NEXTVAL,

26309:
26310: v_sql_stmt := 05;
26311: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26312: UPDATE msc_st_project_tasks
26313: SET st_transaction_id = msc_st_project_tasks_s.NEXTVAL,
26314: refresh_id = v_refresh_id,
26315: last_update_date = v_current_date,
26316: last_updated_by = v_current_user,
26317: creation_date = v_current_date,

Line 26329: p_token_value1 => 'MSC_ST_PROJECT_TASKS');

26325: p_error_code => 'MSC_PP_NO_DELETION',
26326: p_message_text => lv_message_text,
26327: p_error_text => lv_error_text,
26328: p_token1 => 'TABLE_NAME',
26329: p_token_value1 => 'MSC_ST_PROJECT_TASKS');
26330:
26331: IF lv_return <> 0 THEN
26332: RAISE ex_logging_err;
26333: END IF;

Line 26338: ' UPDATE msc_st_project_tasks '

26334:
26335: --Deletion is not allowed on this table.
26336: v_sql_stmt := 06;
26337: lv_sql_stmt :=
26338: ' UPDATE msc_st_project_tasks '
26339: ||' SET process_flag = '||G_ERROR_FLG||','
26340: ||' error_text = '||''''||lv_message_text||''''
26341: ||' WHERE deleted_flag = '||SYS_YES
26342: ||' AND process_flag = '||G_IN_PROCESS

Line 26368: ' UPDATE msc_st_project_tasks '

26364: -- Error out record if project_number is NULL
26365:
26366: v_sql_stmt := 07;
26367: lv_sql_stmt :=
26368: ' UPDATE msc_st_project_tasks '
26369: ||' SET process_flag = '||G_ERROR_FLG||','
26370: ||' error_text = '||''''||lv_message_text||''''
26371: ||' WHERE NVL(project_number,'||''''||NULL_CHAR||''''||')'
26372: ||' = '||''''||NULL_CHAR||''''

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

26395: END IF;
26396:
26397: -- Derive organization id
26398: lv_return :=
26399: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name =>'MSC_ST_PROJECT_TASKS',
26400: p_org_partner_name =>'ORGANIZATION_CODE',
26401: p_org_partner_id =>'ORGANIZATION_ID',
26402: p_instance_code => v_instance_code,
26403: p_partner_type => G_ORGANIZATION,

Line 26436: (p_table_name => 'MSC_ST_PROJECT_TASKS',

26432: lv_where_str :=
26433: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
26434:
26435: lv_return := MSC_ST_UTIL.LOG_ERROR
26436: (p_table_name => 'MSC_ST_PROJECT_TASKS',
26437: p_instance_code => v_instance_code,
26438: p_row => lv_column_names,
26439: p_severity => G_SEV_WARNING,
26440: p_message_text => lv_message_text,

Line 26474: (p_table_name => 'MSC_ST_PROJECT_TASKS',

26470:
26471: lv_where_str := ' AND NVL(seiban_number_flag,'||NULL_VALUE||') NOT IN (1,2) ';
26472:
26473: lv_return := MSC_ST_UTIL.LOG_ERROR
26474: (p_table_name => 'MSC_ST_PROJECT_TASKS',
26475: p_instance_code => v_instance_code,
26476: p_row => lv_column_names,
26477: p_severity => G_SEV_WARNING,
26478: p_message_text => lv_message_text,

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

26488: END IF;
26489:
26490: -- Derive Project id
26491: lv_return :=
26492: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name => 'MSC_ST_PROJECT_TASKS',
26493: p_proj_col_name => 'PROJECT_NUMBER',
26494: p_proj_task_col_id => 'PROJECT_ID',
26495: p_instance_code => v_instance_code,
26496: p_entity_name => 'PROJECT_ID',

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

26504: END IF;
26505:
26506: -- Derive task id
26507: lv_return :=
26508: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name =>'MSC_ST_PROJECT_TASKS',
26509: p_proj_col_name =>'PROJECT_NUMBER',
26510: p_proj_task_col_id =>'TASK_ID',
26511: p_task_col_name =>'TASK_NUMBER',
26512: p_instance_code => v_instance_code,

Line 26527: 'UPDATE msc_st_project_tasks '

26523: -- UPdate task_name with the task_number
26524:
26525: v_sql_stmt := 07;
26526: lv_sql_stmt :=
26527: 'UPDATE msc_st_project_tasks '
26528: ||' SET task_name = task_number'
26529: ||' WHERE sr_instance_code = :v_instance_code'
26530: ||' AND process_flag = '||G_IN_PROCESS
26531: ||' AND NVL(task_number,'||''''||NULL_CHAR||''''||') '

Line 26546: 'UPDATE msc_st_project_tasks mstp'

26542:
26543: v_sql_stmt := 08;
26544:
26545: lv_sql_stmt :=
26546: 'UPDATE msc_st_project_tasks mstp'
26547: ||' SET costing_group_id = ( SELECT local_id '
26548: ||' FROM msc_local_id_misc mlim'
26549: ||' WHERE mlim.char1 = mstp.sr_instance_code'
26550: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 26573: pEntityName => 'MSC_ST_PROJECT_TASKS',

26569: (ERRBUF => lv_error_text,
26570: RETCODE => lv_return,
26571: pBatchID => lv_batch_id,
26572: pInstanceCode => v_instance_code,
26573: pEntityName => 'MSC_ST_PROJECT_TASKS',
26574: pInstanceID => v_instance_id);
26575:
26576: IF NVL(lv_return,0) <> 0 THEN
26577: RAISE ex_logging_err;

Line 26591: UPDATE msc_st_project_tasks

26587: IF c5%ROWCOUNT > 0 THEN
26588:
26589: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26590:
26591: UPDATE msc_st_project_tasks
26592: SET costing_group_id = msc_st_costing_group_id_s.NEXTVAL
26593: WHERE rowid = lb_rowid(j);
26594:
26595:

Line 26633: FROM msc_st_project_tasks

26629: v_current_date,
26630: v_current_user,
26631: v_current_date,
26632: v_current_user
26633: FROM msc_st_project_tasks
26634: WHERE rowid = lb_rowid(j);
26635: END IF;
26636: CLOSE c5;
26637:

Line 26643: 'UPDATE msc_st_project_tasks mstp'

26639:
26640: v_sql_stmt := 11;
26641:
26642: lv_sql_stmt :=
26643: 'UPDATE msc_st_project_tasks mstp'
26644: ||' SET costing_group_id = ( SELECT local_id '
26645: ||' FROM msc_local_id_misc mlim'
26646: ||' WHERE mlim.char1 = mstp.sr_instance_code'
26647: ||' AND NVL(mlim.char2,'||''''||NULL_CHAR||''''||') '

Line 26676: UPDATE msc_st_project_tasks

26672: IF c3%ROWCOUNT > 0 THEN
26673:
26674: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26675:
26676: UPDATE msc_st_project_tasks
26677: SET project_id = msc_st_project_id_s.NEXTVAL
26678: WHERE rowid = lb_rowid(j);
26679:
26680:

Line 26720: FROM msc_st_project_tasks

26716: v_current_date,
26717: v_current_user,
26718: v_current_date,
26719: v_current_user
26720: FROM msc_st_project_tasks
26721: WHERE rowid = lb_rowid(j);
26722: END IF;
26723:
26724: CLOSE c3;

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

26724: CLOSE c3;
26725:
26726: -- Derive Project id
26727: lv_return :=
26728: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name => 'MSC_ST_PROJECT_TASKS',
26729: p_proj_col_name => 'PROJECT_NUMBER',
26730: p_proj_task_col_id => 'PROJECT_ID',
26731: p_instance_code => v_instance_code,
26732: p_entity_name => 'PROJECT_ID',

Line 26753: UPDATE msc_st_project_tasks

26749: IF c4%ROWCOUNT > 0 THEN
26750:
26751: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26752:
26753: UPDATE msc_st_project_tasks
26754: SET task_id = msc_st_task_id_s.NEXTVAL
26755: WHERE rowid = lb_rowid(j);
26756:
26757: v_sql_stmt := 15;

Line 26800: FROM msc_st_project_tasks

26796: v_current_date,
26797: v_current_user,
26798: v_current_date,
26799: v_current_user
26800: FROM msc_st_project_tasks
26801: WHERE rowid = lb_rowid(j);
26802: END IF;
26803: CLOSE c4;
26804:

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

26803: CLOSE c4;
26804:
26805: -- Derive task id
26806: lv_return :=
26807: MSC_ST_UTIL.DERIVE_PROJ_TASK_ID(p_table_name =>'MSC_ST_PROJECT_TASKS',
26808: p_proj_col_name =>'PROJECT_NUMBER',
26809: p_proj_task_col_id =>'TASK_ID',
26810: p_task_col_name =>'TASK_NUMBER',
26811: p_instance_code => v_instance_code,

Line 26865: ||' FROM msc_st_project_tasks'

26861: ||' last_update_date,'
26862: ||' last_updated_by,'
26863: ||' creation_date,'
26864: ||' created_by'
26865: ||' FROM msc_st_project_tasks'
26866: ||' WHERE sr_instance_code = :v_instance_code'
26867: ||' AND process_flag = '||G_IN_PROCESS
26868: ||' AND batch_id = :lv_batch_id' ;
26869:

Line 26876: ' DELETE FROM msc_st_project_tasks '

26872: -- Delete all the records from msc_st_projects_tasks where task number is NULL
26873: -- This is done as records with only task name is inserted in msc_st_projects_tasks
26874:
26875: lv_sql_stmt :=
26876: ' DELETE FROM msc_st_project_tasks '
26877: ||' WHERE NVL(task_number, '||''''||NULL_CHAR||''''||') '
26878: ||' = '||''''||NULL_CHAR||''''
26879: ||' AND sr_instance_code = :v_instance_code'
26880: ||' AND process_flag = '||G_IN_PROCESS

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

26883: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
26884:
26885: -- Set the process flag as Valid and poulate instance_id
26886: lv_return :=
26887: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_PROJECT_TASKS',
26888: p_instance_id => v_instance_id,
26889: p_instance_code => v_instance_code,
26890: p_process_flag => G_VALID,
26891: p_error_text => lv_error_text,

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

26899:
26900: -- At the end calling the LOG_ERROR for logging all errored out records
26901:
26902: lv_return :=
26903: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_PROJECT_TASKS',
26904: p_instance_code => v_instance_code,
26905: p_row => lv_column_names,
26906: p_severity => G_SEV_ERROR,
26907: p_message_text => NULL,

Line 30537: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

30533: p_token1 => 'COLUMN_NAMES',
30534: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
30535: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
30536: p_token2 => 'MASTER_TABLE',
30537: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
30538:
30539: IF lv_return <> 0 THEN
30540: RAISE ex_logging_err;
30541: END IF;

Line 30570: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

30566: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
30567: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
30568: ||' TASK_NUMBER',
30569: p_token2 => 'MASTER_TABLE',
30570: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
30571:
30572: IF lv_return <> 0 THEN
30573: RAISE ex_logging_err;
30574: END IF;

Line 32255: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

32251: p_token1 => 'COLUMN_NAMES',
32252: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
32253: ||'ORGANIZATION_CODE,PROJECT_NUMBER',
32254: p_token2 => 'MASTER_TABLE',
32255: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
32256:
32257: IF lv_return <> 0 THEN
32258: RAISE ex_logging_err;
32259: END IF;

Line 32289: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

32285: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
32286: ||'ORGANIZATION_CODE,PROJECT_NUMBER,'
32287: ||'TASK_NUMBER' ,
32288: p_token2 => 'MASTER_TABLE',
32289: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
32290:
32291: IF lv_return <> 0 THEN
32292: RAISE ex_logging_err;
32293: END IF;

Line 33737: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

33733: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
33734: ||'ORGANIZATION_CODE,PROJECT_NUMBER'
33735: ||'TASK_NUMBER' ,
33736: p_token2 => 'MASTER_TABLE',
33737: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
33738:
33739: IF lv_return <> 0 THEN
33740: RAISE ex_logging_err;
33741: END IF;

Line 34371: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

34367: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
34368: ||'ORGANIZATION_CODE,PROJECT_NUMBER'
34369: ||'TASK_NUMBER' ,
34370: p_token2 => 'MASTER_TABLE',
34371: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
34372:
34373: IF lv_return <> 0 THEN
34374: RAISE ex_logging_err;
34375: END IF;

Line 39151: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

39147: p_token1 => 'COLUMN_NAMES',
39148: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
39149: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
39150: p_token2 => 'MASTER_TABLE',
39151: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
39152:
39153: IF lv_return <> 0 THEN
39154: RAISE ex_logging_err;
39155: END IF;

Line 39185: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

39181: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
39182: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
39183: ||' TASK_NUMBER',
39184: p_token2 => 'MASTER_TABLE',
39185: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
39186:
39187: IF lv_return <> 0 THEN
39188: RAISE ex_logging_err;
39189: END IF;

Line 43356: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

43352: p_token1 => 'COLUMN_NAMES',
43353: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
43354: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
43355: p_token2 => 'MASTER_TABLE',
43356: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
43357:
43358: IF lv_return <> 0 THEN
43359: RAISE ex_logging_err;
43360: END IF;

Line 43389: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

43385: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
43386: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
43387: ||' TASK_NUMBER',
43388: p_token2 => 'MASTER_TABLE',
43389: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
43390:
43391: IF lv_return <> 0 THEN
43392: RAISE ex_logging_err;
43393: END IF;

Line 45479: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

45475: p_token1 => 'COLUMN_NAMES',
45476: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
45477: ||' ORGANIZATION_CODE AND PROJECT_NUMBER',
45478: p_token2 => 'MASTER_TABLE',
45479: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
45480:
45481: IF lv_return <> 0 THEN
45482: RAISE ex_logging_err;
45483: END IF;

Line 45513: p_token_value2 => 'MSC_ST_PROJECT_TASKS');

45509: p_token_value1 => ' SR_INSTANCE_CODE, COMPANY_NAME,'
45510: ||' ORGANIZATION_CODE, PROJECT_NUMBER,'
45511: ||' TASK_NUMBER',
45512: p_token2 => 'MASTER_TABLE',
45513: p_token_value2 => 'MSC_ST_PROJECT_TASKS');
45514:
45515: IF lv_return <> 0 THEN
45516: RAISE ex_logging_err;
45517: END IF;

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

51052: End IF;
51053: END IF;
51054:
51055: IF v_project_enabled = SYS_YES THEN
51056: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_PROJECT_TASKS');
51057: IF lv_count > 0 Then
51058: prec.project_flag:= SYS_YES;
51059: End IF;
51060: END IF;