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_RESERVATIONS

Line 703: ||' on MSC_ST_RESERVATIONS '

699: application_short_name => 'MSC',
700: statement_type => AD_DDL.CREATE_INDEX,
701: statement =>
702: 'create index MSC_ST_RESERVE_N1_'||v_instance_code
703: ||' on MSC_ST_RESERVATIONS '
704: ||'(sr_instance_code,sales_order_number, line_num,organization_code,company_name ) '
705: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
706: object_name =>'MSC_ST_RESERVE_N1_'||v_instance_code);
707:

Line 716: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESERVATIONS', v_instance_id, -1);

712: WHEN OTHERS THEN
713: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RESERVE_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
714: END;
715:
716: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESERVATIONS', v_instance_id, -1);
717:
718: END IF;
719:
720:

Line 32764: FROM msc_st_reservations

32760: ex_logging_err EXCEPTION;
32761:
32762: CURSOR c1(p_batch_id NUMBER) IS
32763: SELECT rowid
32764: FROM msc_st_reservations
32765: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
32766: AND sr_instance_code = v_instance_code
32767: AND batch_id = p_batch_id;
32768:

Line 32781: --Validation check for the table MSC_ST_RESERVATIONS

32777: IF lv_return <> 0 THEN
32778: RAISE ex_logging_err;
32779: END IF;
32780:
32781: --Validation check for the table MSC_ST_RESERVATIONS
32782:
32783: --Duplicate records check for the records whose source is other than XML
32784: --Different SQL is used because in XML we can identify the latest records
32785: --whereas in batch load we cannot.

Line 32789: 'UPDATE msc_st_reservations msr1 '

32785: --whereas in batch load we cannot.
32786:
32787: v_sql_stmt := 01;
32788: lv_sql_stmt :=
32789: 'UPDATE msc_st_reservations msr1 '
32790: ||' SET process_flag = '||G_ERROR_FLG||','
32791: ||' error_text = '||''''||lv_message_text||''''
32792: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32793: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

Line 32792: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '

32788: lv_sql_stmt :=
32789: 'UPDATE msc_st_reservations msr1 '
32790: ||' SET process_flag = '||G_ERROR_FLG||','
32791: ||' error_text = '||''''||lv_message_text||''''
32792: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32793: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
32794: ||' AND msr2.sales_order_number = msr1.sales_order_number'
32795: ||' AND msr2.line_num = msr1.line_num'
32796: ||' AND msr2.organization_code = msr1.organization_code'

Line 32819: 'UPDATE msc_st_reservations msr1 '

32815:
32816: --Duplicate records check for the records whose source is XML
32817: v_sql_stmt := 02;
32818: lv_sql_stmt :=
32819: 'UPDATE msc_st_reservations msr1 '
32820: ||' SET process_flag = '||G_ERROR_FLG||','
32821: ||' error_text = '||''''||lv_message_text||''''
32822: ||' WHERE message_id < ( SELECT max(message_id) '
32823: ||' FROM msc_st_reservations msr2'

Line 32823: ||' FROM msc_st_reservations msr2'

32819: 'UPDATE msc_st_reservations msr1 '
32820: ||' SET process_flag = '||G_ERROR_FLG||','
32821: ||' error_text = '||''''||lv_message_text||''''
32822: ||' WHERE message_id < ( SELECT max(message_id) '
32823: ||' FROM msc_st_reservations msr2'
32824: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
32825: ||' AND msr2.sales_order_number = msr1.sales_order_number'
32826: ||' AND msr2.line_num = msr1.line_num'
32827: ||' AND msr2.organization_code = msr1.organization_code'

Line 32847: 'UPDATE msc_st_reservations msr1 '

32843:
32844:
32845: /*duplicate records for reservation_type =3 */
32846: lv_sql_stmt :=
32847: 'UPDATE msc_st_reservations msr1 '
32848: ||' SET process_flag = '||G_ERROR_FLG||','
32849: ||' error_text = '||''''||lv_message_text||''''
32850: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32851: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

Line 32850: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '

32846: lv_sql_stmt :=
32847: 'UPDATE msc_st_reservations msr1 '
32848: ||' SET process_flag = '||G_ERROR_FLG||','
32849: ||' error_text = '||''''||lv_message_text||''''
32850: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32851: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
32852: ||' AND msr2.supply_order_number = msr1.supply_order_number'
32853: ||' AND msr2.organization_code = msr1.organization_code'
32854: ||' AND msr2.process_flag = msr1.process_flag'

Line 32873: 'UPDATE msc_st_reservations msr1 '

32869: USING v_instance_code;
32870:
32871: /*duplicate records for reservation_type =4 */
32872: lv_sql_stmt :=
32873: 'UPDATE msc_st_reservations msr1 '
32874: ||' SET process_flag = '||G_ERROR_FLG||','
32875: ||' error_text = '||''''||lv_message_text||''''
32876: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32877: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

Line 32876: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '

32872: lv_sql_stmt :=
32873: 'UPDATE msc_st_reservations msr1 '
32874: ||' SET process_flag = '||G_ERROR_FLG||','
32875: ||' error_text = '||''''||lv_message_text||''''
32876: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32877: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
32878: ||' AND msr2.supply_order_number = msr1.supply_order_number'
32879: ||' AND msr2.purch_line_num = msr1.purch_line_num'
32880: ||' AND msr2.organization_code = msr1.organization_code'

Line 32902: 'UPDATE msc_st_reservations msr1 '

32898: USING v_instance_code;
32899:
32900: /*duplicate records for reservation_type =5 */
32901: lv_sql_stmt :=
32902: 'UPDATE msc_st_reservations msr1 '
32903: ||' SET process_flag = '||G_ERROR_FLG||','
32904: ||' error_text = '||''''||lv_message_text||''''
32905: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32906: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

Line 32905: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '

32901: lv_sql_stmt :=
32902: 'UPDATE msc_st_reservations msr1 '
32903: ||' SET process_flag = '||G_ERROR_FLG||','
32904: ||' error_text = '||''''||lv_message_text||''''
32905: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32906: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
32907: ||' AND msr2.supply_order_number = msr1.supply_order_number'
32908: ||' AND msr2.organization_code = msr1.organization_code'
32909: ||' AND msr2.supply_org_code = msr1.supply_org_code'

Line 32934: 'UPDATE msc_st_reservations msr1 '

32930:
32931: /*duplicate records for reservation_type = 7 */
32932:
32933: lv_sql_stmt :=
32934: 'UPDATE msc_st_reservations msr1 '
32935: ||' SET process_flag = '||G_ERROR_FLG||','
32936: ||' error_text = '||''''||lv_message_text||''''
32937: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32938: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

Line 32937: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '

32933: lv_sql_stmt :=
32934: 'UPDATE msc_st_reservations msr1 '
32935: ||' SET process_flag = '||G_ERROR_FLG||','
32936: ||' error_text = '||''''||lv_message_text||''''
32937: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
32938: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
32939: ||' AND msr2.supply_order_number = msr1.supply_order_number'
32940: ||' AND msr2.organization_code = msr1.organization_code'
32941: ||' AND msr2.process_flag = msr1.process_flag'

Line 32986: 'UPDATE msc_st_reservations '

32982: FROM DUAL;
32983:
32984: v_sql_stmt := 04;
32985: lv_sql_stmt :=
32986: 'UPDATE msc_st_reservations '
32987: ||' SET batch_id = :lv_batch_id '
32988: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
32989: ||' AND sr_instance_code = :v_instance_code'
32990: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 33008: UPDATE msc_st_reservations

33004: CLOSE c1;
33005:
33006: v_sql_stmt := 05;
33007: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
33008: UPDATE msc_st_reservations
33009: SET st_transaction_id = msc_st_demand_classes_s.NEXTVAL,
33010: refresh_id = v_refresh_id,
33011: last_update_date = v_current_date,
33012: last_updated_by = v_current_user,

Line 33033: 'UPDATE msc_st_reservations '

33029:
33030: v_sql_stmt := 04;
33031:
33032: lv_sql_stmt :=
33033: 'UPDATE msc_st_reservations '
33034: ||' SET process_flag = '||G_ERROR_FLG||','
33035: ||' error_text = '||''''||lv_message_text||''''
33036: ||' WHERE ( NVL(line_num,'||NULL_VALUE||') = '||NULL_VALUE
33037: ||' OR NVL(sales_order_number,'||''''||NULL_CHAR||''''||') '

Line 33064: 'UPDATE msc_st_reservations '

33060: END IF;
33061:
33062:
33063: lv_sql_stmt :=
33064: 'UPDATE msc_st_reservations '
33065: ||' SET process_flag = '||G_ERROR_FLG||','
33066: ||' error_text = '||''''||lv_message_text||''''
33067: ||' WHERE NVL(supply_order_number,'||''''||NULL_CHAR||''''||') = '||''''||NULL_CHAR||''''||''
33068: ||' AND process_flag = '||G_IN_PROCESS

Line 33093: 'UPDATE msc_st_reservations '

33089: END IF;
33090:
33091:
33092: lv_sql_stmt :=
33093: 'UPDATE msc_st_reservations '
33094: ||' SET process_flag = '||G_ERROR_FLG||','
33095: ||' error_text = '||''''||lv_message_text||''''
33096: ||' WHERE NVL(purch_line_num,'||NULL_VALUE||') = '||NULL_VALUE
33097: ||' AND process_flag = '||G_IN_PROCESS

Line 33122: 'UPDATE msc_st_reservations '

33118: END IF;
33119:
33120:
33121: lv_sql_stmt :=
33122: 'UPDATE msc_st_reservations '
33123: ||' SET process_flag = '||G_ERROR_FLG||','
33124: ||' error_text = '||''''||lv_message_text||''''
33125: ||' WHERE NVL(supply_org_code,'||''''||NULL_CHAR||''''||') = '||''''||NULL_CHAR||''''||''
33126: ||' AND process_flag = '||G_IN_PROCESS

Line 33155: MSC_ST_UTIL.VALIDATE_DMD_CLASS(p_table_name => 'MSC_ST_RESERVATIONS',

33151: -- Validate Demand Class, if value provided it should exists
33152: -- in ODS or staging table
33153:
33154: lv_return :=
33155: MSC_ST_UTIL.VALIDATE_DMD_CLASS(p_table_name => 'MSC_ST_RESERVATIONS',
33156: p_dmd_class_column => 'DEMAND_CLASS',
33157: p_instance_id => v_instance_id,
33158: p_instance_code => v_instance_code,
33159: p_severity => G_SEV3_ERROR,

Line 33192: (p_table_name => 'MSC_ST_RESERVATIONS',

33188: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
33189: ||' NOT IN(1,2)';
33190:
33191: lv_return := MSC_ST_UTIL.LOG_ERROR
33192: (p_table_name => 'MSC_ST_RESERVATIONS',
33193: p_instance_code => v_instance_code,
33194: p_row => lv_column_names,
33195: p_severity => G_SEV_WARNING,
33196: p_message_text => lv_message_text,

Line 33211: 'UPDATE msc_st_reservations '

33207:
33208:
33209:
33210: lv_sql_stmt :=
33211: 'UPDATE msc_st_reservations '
33212: ||' SET supply_source_type_id = 200,'
33213: ||' disposition_type =2 '
33214: ||' WHERE process_flag = '||G_IN_PROCESS
33215: ||' AND batch_id = :lv_batch_id'

Line 33226: 'UPDATE msc_st_reservations '

33222:
33223: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,v_instance_code;
33224:
33225: lv_sql_stmt :=
33226: 'UPDATE msc_st_reservations '
33227: ||' SET supply_source_type_id = 7,'
33228: ||' disposition_type =200 '
33229: ||' WHERE process_flag = '||G_IN_PROCESS
33230: ||' AND batch_id = :lv_batch_id'

Line 33241: 'UPDATE msc_st_reservations '

33237:
33238: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,v_instance_code;
33239:
33240: lv_sql_stmt :=
33241: 'UPDATE msc_st_reservations '
33242: ||' SET supply_source_type_id = 5,'
33243: ||' disposition_type =1 '
33244: ||' WHERE process_flag = '||G_IN_PROCESS
33245: ||' AND batch_id = :lv_batch_id'

Line 33256: 'UPDATE msc_st_reservations '

33252:
33253: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,v_instance_code;
33254:
33255: lv_sql_stmt :=
33256: 'UPDATE msc_st_reservations '
33257: ||' SET supply_source_type_id = 1,'
33258: ||' disposition_type =2 '
33259: ||' WHERE process_flag = '||G_IN_PROCESS
33260: ||' AND batch_id = :lv_batch_id'

Line 33289: (p_table_name => 'MSC_ST_RESERVATIONS',

33285: lv_where_str := ' AND NVL(disposition_type,'||NULL_VALUE||') '
33286: ||' <> 2 AND RESERVATION_TYPE =1';
33287:
33288: lv_return := MSC_ST_UTIL.LOG_ERROR
33289: (p_table_name => 'MSC_ST_RESERVATIONS',
33290: p_instance_code => v_instance_code,
33291: p_row => lv_column_names,
33292: p_severity => G_SEV_WARNING,
33293: p_message_text => lv_message_text,

Line 33325: (p_table_name => 'MSC_ST_RESERVATIONS',

33321: lv_where_str := ' AND NVL(reservation_type,'||NULL_VALUE||') '
33322: ||' <> 1 ';
33323:
33324: lv_return := MSC_ST_UTIL.LOG_ERROR
33325: (p_table_name => 'MSC_ST_RESERVATIONS',
33326: p_instance_code => v_instance_code,
33327: p_row => lv_column_names,
33328: p_severity => G_SEV_WARNING,
33329: p_message_text => lv_message_text,

Line 33357: (p_table_name => 'MSC_ST_RESERVATIONS',

33353: END IF;
33354:
33355: --Derive Organization_id
33356: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
33357: (p_table_name => 'MSC_ST_RESERVATIONS',
33358: p_org_partner_name => 'ORGANIZATION_CODE',
33359: p_org_partner_id => 'ORGANIZATION_ID',
33360: p_instance_code => v_instance_code,
33361: p_partner_type => G_ORGANIZATION,

Line 33390: (p_table_name => 'MSC_ST_RESERVATIONS',

33386: END IF;
33387:
33388: --Derive Inventory_item_id
33389: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
33390: (p_table_name => 'MSC_ST_RESERVATIONS',
33391: p_item_col_name => 'ITEM_NAME',
33392: p_item_col_id => 'INVENTORY_ITEM_ID',
33393: p_instance_id => v_instance_id,
33394: p_instance_code => v_instance_code,

Line 33410: 'UPDATE msc_st_reservations msr '

33406: -- Derive dispostion id
33407:
33408: v_sql_stmt := 5.0;
33409: lv_sql_stmt :=
33410: 'UPDATE msc_st_reservations msr '
33411: ||' SET disposition_id = (SELECT local_id'
33412: ||' FROM msc_local_id_demand mlid'
33413: ||' WHERE mlid.char1 = msr.sr_instance_code'
33414: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 33434: 'UPDATE msc_st_reservations msr '

33430:
33431: /* derive disposition_id for reservation_type in (3,7) */
33432: v_sql_stmt := 5.1;
33433: lv_sql_stmt :=
33434: 'UPDATE msc_st_reservations msr '
33435: ||' SET disposition_id = (SELECT local_id'
33436: ||' FROM msc_local_id_demand mlid'
33437: ||' WHERE mlid.char1 = msr.sr_instance_code'
33438: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 33459: 'UPDATE msc_st_reservations msr '

33455:
33456: /* derive disposition_id for reservation_type =4 */
33457: v_sql_stmt := 5.2;
33458: lv_sql_stmt :=
33459: 'UPDATE msc_st_reservations msr '
33460: ||' SET disposition_id =(SELECT local_id'
33461: ||' FROM msc_local_id_supply mls'
33462: ||' WHERE mls.char4 = msr.demand_order_number'
33463: ||' AND mls.char3 = msr.organization_code'

Line 33480: 'UPDATE msc_st_reservations msr '

33476:
33477: /* derive disposition_id for reservation_type =5 */
33478: v_sql_stmt := 5.3;
33479: lv_sql_stmt :=
33480: 'UPDATE msc_st_reservations msr '
33481: ||' SET disposition_id =(SELECT local_id'
33482: ||' FROM msc_local_id_supply mls'
33483: ||' WHERE mls.char3 = msr.demand_order_number'
33484: ||' AND mls.number1 = 74' -- order_type

Line 33504: 'UPDATE msc_st_reservations msr '

33500:
33501: /* derieve transaction_id for reservation_type =3 */
33502: v_sql_stmt := 5.5;
33503: lv_sql_stmt :=
33504: 'UPDATE msc_st_reservations msr '
33505: ||' SET transaction_id =(SELECT local_id'
33506: ||' FROM msc_local_id_supply mls'
33507: ||' WHERE mls.char4 = msr.supply_order_number'
33508: ||' AND mls.char3 = msr.organization_code'

Line 33525: 'UPDATE msc_st_reservations msr '

33521:
33522: /* derieve transaction_id for reservation_type =4 */
33523: v_sql_stmt := 5.5;
33524: lv_sql_stmt :=
33525: 'UPDATE msc_st_reservations msr '
33526: ||' SET transaction_id =(SELECT local_id'
33527: ||' FROM msc_local_id_supply mls'
33528: ||' WHERE mls.number1 = msr.purch_line_num'
33529: ||' AND mls.number2 =2' -- order_type

Line 33549: 'UPDATE msc_st_reservations msr '

33545:
33546: /* derieve transaction_id for reservation_type =5 */
33547: v_sql_stmt := 5.6;
33548: lv_sql_stmt :=
33549: 'UPDATE msc_st_reservations msr '
33550: ||' SET transaction_id =(SELECT local_id'
33551: ||' FROM msc_local_id_supply mls'
33552: ||' WHERE mls.char4 = msr.supply_order_number'
33553: ||' AND mls.char3 = msr.supply_org_code'

Line 33572: 'UPDATE msc_st_reservations msr '

33568:
33569: /* derieve transaction_id for reservation_type =7*/
33570: v_sql_stmt := 5.6;
33571: lv_sql_stmt :=
33572: 'UPDATE msc_st_reservations msr '
33573: ||' SET transaction_id =(SELECT local_id'
33574: ||' FROM msc_local_id_supply mls'
33575: ||' WHERE mls.char3 = msr.supply_order_number'
33576: ||' AND mls.number1 = 74' -- order_type

Line 33596: 'UPDATE msc_st_reservations msr '

33592: -- Derive parent_demand_id
33593:
33594: v_sql_stmt := 06;
33595: lv_sql_stmt :=
33596: 'UPDATE msc_st_reservations msr '
33597: ||' SET parent_demand_id = (SELECT local_id'
33598: ||' FROM msc_local_id_demand mlid'
33599: ||' WHERE mlid.char1 = msr.sr_instance_code'
33600: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 33642: 'UPDATE msc_st_reservations '

33638:
33639: v_sql_stmt := 07;
33640:
33641: lv_sql_stmt :=
33642: 'UPDATE msc_st_reservations '
33643: ||' SET process_flag ='||G_ERROR_FLG||','
33644: ||' error_text = '||''''||lv_message_text||''''
33645: ||' WHERE (NVL(disposition_id,'||NULL_VALUE||') = '||NULL_VALUE
33646: ||' OR NVL(parent_demand_id,'||NULL_VALUE||') = '||NULL_VALUE||')'

Line 33659: 'UPDATE msc_st_reservations '

33655: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,v_instance_code;
33656:
33657: v_sql_stmt := 07.1;
33658: lv_sql_stmt :=
33659: 'UPDATE msc_st_reservations '
33660: ||' SET process_flag ='||G_ERROR_FLG||','
33661: ||' error_text = '||''''||lv_message_text||''''
33662: ||' WHERE (NVL(disposition_id,'||NULL_VALUE||') = '||NULL_VALUE
33663: ||' OR NVL(transaction_id,'||NULL_VALUE||') = '||NULL_VALUE||')'

Line 33679: 'UPDATE msc_st_reservations '

33675:
33676: v_sql_stmt := 07;
33677:
33678: lv_sql_stmt :=
33679: 'UPDATE msc_st_reservations '
33680: ||' SET transaction_id = parent_demand_id'
33681: ||' WHERE NVL(parent_demand_id,'||NULL_VALUE||') <> '||NULL_VALUE
33682: ||' AND process_flag ='||G_IN_PROCESS
33683: ||' AND batch_id = :lv_batch_id '

Line 33711: (p_table_name => 'MSC_ST_RESERVATIONS',

33707: END IF;
33708:
33709: --Derive Project Id.
33710: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
33711: (p_table_name => 'MSC_ST_RESERVATIONS',
33712: p_proj_col_name => 'PROJECT_NUMBER',
33713: p_proj_task_col_id => 'PROJECT_ID',
33714: p_instance_code => v_instance_code,
33715: p_entity_name => 'PROJECT_ID',

Line 33745: (p_table_name => 'MSC_ST_RESERVATIONS',

33741: END IF;
33742:
33743: --Derive Task Id.
33744: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
33745: (p_table_name => 'MSC_ST_RESERVATIONS',
33746: p_proj_col_name => 'PROJECT_NUMBER',
33747: p_proj_task_col_id => 'TASK_ID',
33748: p_instance_code => v_instance_code,
33749: p_entity_name => 'TASK_ID',

Line 33770: pEntityName => 'MSC_ST_RESERVATIONS',

33766: (ERRBUF => lv_error_text,
33767: RETCODE => lv_return,
33768: pBatchID => lv_batch_id,
33769: pInstanceCode => v_instance_code,
33770: pEntityName => 'MSC_ST_RESERVATIONS',
33771: pInstanceID => v_instance_id);
33772:
33773: IF NVL(lv_return,0) <> 0 THEN
33774: RAISE ex_logging_err;

Line 33780: (p_table_name => 'MSC_ST_RESERVATIONS',

33776:
33777:
33778: -- Set the process flag as Valid and populate instance_id
33779: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
33780: (p_table_name => 'MSC_ST_RESERVATIONS',
33781: p_instance_id => v_instance_id,
33782: p_instance_code => v_instance_code,
33783: p_process_flag => G_VALID,
33784: p_error_text => lv_error_text,

Line 33796: (p_table_name => 'MSC_ST_RESERVATIONS',

33792: -- At the end calling the LOG_ERROR for logging all
33793: -- errored out records.
33794:
33795: lv_return := MSC_ST_UTIL.LOG_ERROR
33796: (p_table_name => 'MSC_ST_RESERVATIONS',
33797: p_instance_code => v_instance_code,
33798: p_row => lv_column_names,
33799: p_severity => G_SEV_ERROR,
33800: p_message_text => NULL,

Line 50842: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESERVATIONS');

50838: End IF;
50839: END IF;
50840:
50841: IF v_reserve_enabled = SYS_YES THEN
50842: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESERVATIONS');
50843: IF lv_count > 0 Then
50844: prec.reserves_flag:= SYS_YES;
50845: End IF;
50846: END IF;