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 711: ||' on MSC_ST_RESERVATIONS '

707: application_short_name => 'MSC',
708: statement_type => AD_DDL.CREATE_INDEX,
709: statement =>
710: 'create index MSC_ST_RESERVE_N1_'||v_instance_code
711: ||' on MSC_ST_RESERVATIONS '
712: ||'(sr_instance_code,sales_order_number, line_num,organization_code,company_name ) '
713: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
714: object_name =>'MSC_ST_RESERVE_N1_'||v_instance_code);
715:

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

720: WHEN OTHERS THEN
721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RESERVE_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
722: END;
723:
724: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESERVATIONS', v_instance_id, -1);
725:
726: END IF;
727:
728:

Line 37479: FROM msc_st_reservations

37475: ex_logging_err EXCEPTION;
37476:
37477: CURSOR c1(p_batch_id NUMBER) IS
37478: SELECT rowid
37479: FROM msc_st_reservations
37480: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
37481: AND sr_instance_code = v_instance_code
37482: AND batch_id = p_batch_id;
37483:

Line 37496: --Validation check for the table MSC_ST_RESERVATIONS

37492: IF lv_return <> 0 THEN
37493: RAISE ex_logging_err;
37494: END IF;
37495:
37496: --Validation check for the table MSC_ST_RESERVATIONS
37497:
37498: --Duplicate records check for the records whose source is other than XML
37499: --Different SQL is used because in XML we can identify the latest records
37500: --whereas in batch load we cannot.

Line 37504: 'UPDATE msc_st_reservations msr1 '

37500: --whereas in batch load we cannot.
37501:
37502: v_sql_stmt := 01;
37503: lv_sql_stmt :=
37504: 'UPDATE msc_st_reservations msr1 '
37505: ||' SET process_flag = '||G_ERROR_FLG||','
37506: ||' error_text = '||''''||lv_message_text||''''
37507: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37508: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

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

37503: lv_sql_stmt :=
37504: 'UPDATE msc_st_reservations msr1 '
37505: ||' SET process_flag = '||G_ERROR_FLG||','
37506: ||' error_text = '||''''||lv_message_text||''''
37507: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37508: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
37509: ||' AND msr2.sales_order_number = msr1.sales_order_number'
37510: ||' AND msr2.line_num = msr1.line_num'
37511: ||' AND msr2.organization_code = msr1.organization_code'

Line 37534: 'UPDATE msc_st_reservations msr1 '

37530:
37531: --Duplicate records check for the records whose source is XML
37532: v_sql_stmt := 02;
37533: lv_sql_stmt :=
37534: 'UPDATE msc_st_reservations msr1 '
37535: ||' SET process_flag = '||G_ERROR_FLG||','
37536: ||' error_text = '||''''||lv_message_text||''''
37537: ||' WHERE message_id < ( SELECT max(message_id) '
37538: ||' FROM msc_st_reservations msr2'

Line 37538: ||' FROM msc_st_reservations msr2'

37534: 'UPDATE msc_st_reservations msr1 '
37535: ||' SET process_flag = '||G_ERROR_FLG||','
37536: ||' error_text = '||''''||lv_message_text||''''
37537: ||' WHERE message_id < ( SELECT max(message_id) '
37538: ||' FROM msc_st_reservations msr2'
37539: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
37540: ||' AND msr2.sales_order_number = msr1.sales_order_number'
37541: ||' AND msr2.line_num = msr1.line_num'
37542: ||' AND msr2.organization_code = msr1.organization_code'

Line 37562: 'UPDATE msc_st_reservations msr1 '

37558:
37559:
37560: /*duplicate records for reservation_type =3 */
37561: lv_sql_stmt :=
37562: 'UPDATE msc_st_reservations msr1 '
37563: ||' SET process_flag = '||G_ERROR_FLG||','
37564: ||' error_text = '||''''||lv_message_text||''''
37565: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37566: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

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

37561: lv_sql_stmt :=
37562: 'UPDATE msc_st_reservations msr1 '
37563: ||' SET process_flag = '||G_ERROR_FLG||','
37564: ||' error_text = '||''''||lv_message_text||''''
37565: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37566: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
37567: ||' AND msr2.supply_order_number = msr1.supply_order_number'
37568: ||' AND msr2.organization_code = msr1.organization_code'
37569: ||' AND msr2.process_flag = msr1.process_flag'

Line 37588: 'UPDATE msc_st_reservations msr1 '

37584: USING v_instance_code;
37585:
37586: /*duplicate records for reservation_type =4 */
37587: lv_sql_stmt :=
37588: 'UPDATE msc_st_reservations msr1 '
37589: ||' SET process_flag = '||G_ERROR_FLG||','
37590: ||' error_text = '||''''||lv_message_text||''''
37591: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37592: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

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

37587: lv_sql_stmt :=
37588: 'UPDATE msc_st_reservations msr1 '
37589: ||' SET process_flag = '||G_ERROR_FLG||','
37590: ||' error_text = '||''''||lv_message_text||''''
37591: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37592: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
37593: ||' AND msr2.supply_order_number = msr1.supply_order_number'
37594: ||' AND msr2.purch_line_num = msr1.purch_line_num'
37595: ||' AND msr2.organization_code = msr1.organization_code'

Line 37617: 'UPDATE msc_st_reservations msr1 '

37613: USING v_instance_code;
37614:
37615: /*duplicate records for reservation_type =5 */
37616: lv_sql_stmt :=
37617: 'UPDATE msc_st_reservations msr1 '
37618: ||' SET process_flag = '||G_ERROR_FLG||','
37619: ||' error_text = '||''''||lv_message_text||''''
37620: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37621: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

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

37616: lv_sql_stmt :=
37617: 'UPDATE msc_st_reservations msr1 '
37618: ||' SET process_flag = '||G_ERROR_FLG||','
37619: ||' error_text = '||''''||lv_message_text||''''
37620: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37621: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
37622: ||' AND msr2.supply_order_number = msr1.supply_order_number'
37623: ||' AND msr2.organization_code = msr1.organization_code'
37624: ||' AND msr2.supply_org_code = msr1.supply_org_code'

Line 37649: 'UPDATE msc_st_reservations msr1 '

37645:
37646: /*duplicate records for reservation_type = 7 */
37647:
37648: lv_sql_stmt :=
37649: 'UPDATE msc_st_reservations msr1 '
37650: ||' SET process_flag = '||G_ERROR_FLG||','
37651: ||' error_text = '||''''||lv_message_text||''''
37652: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37653: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

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

37648: lv_sql_stmt :=
37649: 'UPDATE msc_st_reservations msr1 '
37650: ||' SET process_flag = '||G_ERROR_FLG||','
37651: ||' error_text = '||''''||lv_message_text||''''
37652: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_reservations msr2 '
37653: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
37654: ||' AND msr2.supply_order_number = msr1.supply_order_number'
37655: ||' AND msr2.organization_code = msr1.organization_code'
37656: ||' AND msr2.process_flag = msr1.process_flag'

Line 37701: 'UPDATE msc_st_reservations '

37697: FROM DUAL;
37698:
37699: v_sql_stmt := 04;
37700: lv_sql_stmt :=
37701: 'UPDATE msc_st_reservations '
37702: ||' SET batch_id = :lv_batch_id '
37703: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
37704: ||' AND sr_instance_code = :v_instance_code'
37705: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 37723: UPDATE msc_st_reservations

37719: CLOSE c1;
37720:
37721: v_sql_stmt := 05;
37722: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37723: UPDATE msc_st_reservations
37724: SET st_transaction_id = msc_st_demand_classes_s.NEXTVAL,
37725: refresh_id = v_refresh_id,
37726: last_update_date = v_current_date,
37727: last_updated_by = v_current_user,

Line 37748: 'UPDATE msc_st_reservations '

37744:
37745: v_sql_stmt := 04;
37746:
37747: lv_sql_stmt :=
37748: 'UPDATE msc_st_reservations '
37749: ||' SET process_flag = '||G_ERROR_FLG||','
37750: ||' error_text = '||''''||lv_message_text||''''
37751: ||' WHERE ( NVL(line_num,'||NULL_VALUE||') = '||NULL_VALUE
37752: ||' OR NVL(sales_order_number,'||''''||NULL_CHAR||''''||') '

Line 37779: 'UPDATE msc_st_reservations '

37775: END IF;
37776:
37777:
37778: lv_sql_stmt :=
37779: 'UPDATE msc_st_reservations '
37780: ||' SET process_flag = '||G_ERROR_FLG||','
37781: ||' error_text = '||''''||lv_message_text||''''
37782: ||' WHERE NVL(supply_order_number,'||''''||NULL_CHAR||''''||') = '||''''||NULL_CHAR||''''||''
37783: ||' AND process_flag = '||G_IN_PROCESS

Line 37808: 'UPDATE msc_st_reservations '

37804: END IF;
37805:
37806:
37807: lv_sql_stmt :=
37808: 'UPDATE msc_st_reservations '
37809: ||' SET process_flag = '||G_ERROR_FLG||','
37810: ||' error_text = '||''''||lv_message_text||''''
37811: ||' WHERE NVL(purch_line_num,'||NULL_VALUE||') = '||NULL_VALUE
37812: ||' AND process_flag = '||G_IN_PROCESS

Line 37837: 'UPDATE msc_st_reservations '

37833: END IF;
37834:
37835:
37836: lv_sql_stmt :=
37837: 'UPDATE msc_st_reservations '
37838: ||' SET process_flag = '||G_ERROR_FLG||','
37839: ||' error_text = '||''''||lv_message_text||''''
37840: ||' WHERE NVL(supply_org_code,'||''''||NULL_CHAR||''''||') = '||''''||NULL_CHAR||''''||''
37841: ||' AND process_flag = '||G_IN_PROCESS

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

37866: -- Validate Demand Class, if value provided it should exists
37867: -- in ODS or staging table
37868:
37869: lv_return :=
37870: MSC_ST_UTIL.VALIDATE_DMD_CLASS(p_table_name => 'MSC_ST_RESERVATIONS',
37871: p_dmd_class_column => 'DEMAND_CLASS',
37872: p_instance_id => v_instance_id,
37873: p_instance_code => v_instance_code,
37874: p_severity => G_SEV3_ERROR,

Line 37907: (p_table_name => 'MSC_ST_RESERVATIONS',

37903: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
37904: ||' NOT IN(1,2)';
37905:
37906: lv_return := MSC_ST_UTIL.LOG_ERROR
37907: (p_table_name => 'MSC_ST_RESERVATIONS',
37908: p_instance_code => v_instance_code,
37909: p_row => lv_column_names,
37910: p_severity => G_SEV_WARNING,
37911: p_message_text => lv_message_text,

Line 37926: 'UPDATE msc_st_reservations '

37922:
37923:
37924:
37925: lv_sql_stmt :=
37926: 'UPDATE msc_st_reservations '
37927: ||' SET supply_source_type_id = 200,'
37928: ||' disposition_type =2 '
37929: ||' WHERE process_flag = '||G_IN_PROCESS
37930: ||' AND batch_id = :lv_batch_id'

Line 37941: 'UPDATE msc_st_reservations '

37937:
37938: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,v_instance_code;
37939:
37940: lv_sql_stmt :=
37941: 'UPDATE msc_st_reservations '
37942: ||' SET supply_source_type_id = 7,'
37943: ||' disposition_type =200 '
37944: ||' WHERE process_flag = '||G_IN_PROCESS
37945: ||' AND batch_id = :lv_batch_id'

Line 37956: 'UPDATE msc_st_reservations '

37952:
37953: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,v_instance_code;
37954:
37955: lv_sql_stmt :=
37956: 'UPDATE msc_st_reservations '
37957: ||' SET supply_source_type_id = 5,'
37958: ||' disposition_type =1 '
37959: ||' WHERE process_flag = '||G_IN_PROCESS
37960: ||' AND batch_id = :lv_batch_id'

Line 37971: 'UPDATE msc_st_reservations '

37967:
37968: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,v_instance_code;
37969:
37970: lv_sql_stmt :=
37971: 'UPDATE msc_st_reservations '
37972: ||' SET supply_source_type_id = 1,'
37973: ||' disposition_type =2 '
37974: ||' WHERE process_flag = '||G_IN_PROCESS
37975: ||' AND batch_id = :lv_batch_id'

Line 38004: (p_table_name => 'MSC_ST_RESERVATIONS',

38000: lv_where_str := ' AND NVL(disposition_type,'||NULL_VALUE||') '
38001: ||' <> 2 AND RESERVATION_TYPE =1';
38002:
38003: lv_return := MSC_ST_UTIL.LOG_ERROR
38004: (p_table_name => 'MSC_ST_RESERVATIONS',
38005: p_instance_code => v_instance_code,
38006: p_row => lv_column_names,
38007: p_severity => G_SEV_WARNING,
38008: p_message_text => lv_message_text,

Line 38040: (p_table_name => 'MSC_ST_RESERVATIONS',

38036: lv_where_str := ' AND NVL(reservation_type,'||NULL_VALUE||') '
38037: ||' <> 1 ';
38038:
38039: lv_return := MSC_ST_UTIL.LOG_ERROR
38040: (p_table_name => 'MSC_ST_RESERVATIONS',
38041: p_instance_code => v_instance_code,
38042: p_row => lv_column_names,
38043: p_severity => G_SEV_WARNING,
38044: p_message_text => lv_message_text,

Line 38072: (p_table_name => 'MSC_ST_RESERVATIONS',

38068: END IF;
38069:
38070: --Derive Organization_id
38071: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
38072: (p_table_name => 'MSC_ST_RESERVATIONS',
38073: p_org_partner_name => 'ORGANIZATION_CODE',
38074: p_org_partner_id => 'ORGANIZATION_ID',
38075: p_instance_code => v_instance_code,
38076: p_partner_type => G_ORGANIZATION,

Line 38105: (p_table_name => 'MSC_ST_RESERVATIONS',

38101: END IF;
38102:
38103: --Derive Inventory_item_id
38104: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
38105: (p_table_name => 'MSC_ST_RESERVATIONS',
38106: p_item_col_name => 'ITEM_NAME',
38107: p_item_col_id => 'INVENTORY_ITEM_ID',
38108: p_instance_id => v_instance_id,
38109: p_instance_code => v_instance_code,

Line 38125: 'UPDATE msc_st_reservations msr '

38121: -- Derive dispostion id
38122:
38123: v_sql_stmt := 5.0;
38124: lv_sql_stmt :=
38125: 'UPDATE msc_st_reservations msr '
38126: ||' SET disposition_id = (SELECT local_id'
38127: ||' FROM msc_local_id_demand mlid'
38128: ||' WHERE mlid.char1 = msr.sr_instance_code'
38129: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 38149: 'UPDATE msc_st_reservations msr '

38145:
38146: /* derive disposition_id for reservation_type in (3,7) */
38147: v_sql_stmt := 5.1;
38148: lv_sql_stmt :=
38149: 'UPDATE msc_st_reservations msr '
38150: ||' SET disposition_id = (SELECT local_id'
38151: ||' FROM msc_local_id_demand mlid'
38152: ||' WHERE mlid.char1 = msr.sr_instance_code'
38153: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 38174: 'UPDATE msc_st_reservations msr '

38170:
38171: /* derive disposition_id for reservation_type =4 */
38172: v_sql_stmt := 5.2;
38173: lv_sql_stmt :=
38174: 'UPDATE msc_st_reservations msr '
38175: ||' SET disposition_id =(SELECT local_id'
38176: ||' FROM msc_local_id_supply mls'
38177: ||' WHERE mls.char4 = msr.demand_order_number'
38178: ||' AND mls.char3 = msr.organization_code'

Line 38195: 'UPDATE msc_st_reservations msr '

38191:
38192: /* derive disposition_id for reservation_type =5 */
38193: v_sql_stmt := 5.3;
38194: lv_sql_stmt :=
38195: 'UPDATE msc_st_reservations msr '
38196: ||' SET disposition_id =(SELECT local_id'
38197: ||' FROM msc_local_id_supply mls'
38198: ||' WHERE mls.char3 = msr.demand_order_number'
38199: ||' AND mls.number1 = 74' -- order_type

Line 38219: 'UPDATE msc_st_reservations msr '

38215:
38216: /* derieve transaction_id for reservation_type =3 */
38217: v_sql_stmt := 5.5;
38218: lv_sql_stmt :=
38219: 'UPDATE msc_st_reservations msr '
38220: ||' SET transaction_id =(SELECT local_id'
38221: ||' FROM msc_local_id_supply mls'
38222: ||' WHERE mls.char4 = msr.supply_order_number'
38223: ||' AND mls.char3 = msr.organization_code'

Line 38240: 'UPDATE msc_st_reservations msr '

38236:
38237: /* derieve transaction_id for reservation_type =4 */
38238: v_sql_stmt := 5.5;
38239: lv_sql_stmt :=
38240: 'UPDATE msc_st_reservations msr '
38241: ||' SET transaction_id =(SELECT local_id'
38242: ||' FROM msc_local_id_supply mls'
38243: ||' WHERE mls.number1 = msr.purch_line_num'
38244: ||' AND mls.number2 =2' -- order_type

Line 38264: 'UPDATE msc_st_reservations msr '

38260:
38261: /* derieve transaction_id for reservation_type =5 */
38262: v_sql_stmt := 5.6;
38263: lv_sql_stmt :=
38264: 'UPDATE msc_st_reservations msr '
38265: ||' SET transaction_id =(SELECT local_id'
38266: ||' FROM msc_local_id_supply mls'
38267: ||' WHERE mls.char4 = msr.supply_order_number'
38268: ||' AND mls.char3 = msr.supply_org_code'

Line 38287: 'UPDATE msc_st_reservations msr '

38283:
38284: /* derieve transaction_id for reservation_type =7*/
38285: v_sql_stmt := 5.6;
38286: lv_sql_stmt :=
38287: 'UPDATE msc_st_reservations msr '
38288: ||' SET transaction_id =(SELECT local_id'
38289: ||' FROM msc_local_id_supply mls'
38290: ||' WHERE mls.char3 = msr.supply_order_number'
38291: ||' AND mls.number1 = 74' -- order_type

Line 38311: 'UPDATE msc_st_reservations msr '

38307: -- Derive parent_demand_id
38308:
38309: v_sql_stmt := 06;
38310: lv_sql_stmt :=
38311: 'UPDATE msc_st_reservations msr '
38312: ||' SET parent_demand_id = (SELECT local_id'
38313: ||' FROM msc_local_id_demand mlid'
38314: ||' WHERE mlid.char1 = msr.sr_instance_code'
38315: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 38357: 'UPDATE msc_st_reservations '

38353:
38354: v_sql_stmt := 07;
38355:
38356: lv_sql_stmt :=
38357: 'UPDATE msc_st_reservations '
38358: ||' SET process_flag ='||G_ERROR_FLG||','
38359: ||' error_text = '||''''||lv_message_text||''''
38360: ||' WHERE (NVL(disposition_id,'||NULL_VALUE||') = '||NULL_VALUE
38361: ||' OR NVL(parent_demand_id,'||NULL_VALUE||') = '||NULL_VALUE||')'

Line 38374: 'UPDATE msc_st_reservations '

38370: EXECUTE IMMEDIATE lv_sql_stmt USING lv_batch_id,v_instance_code;
38371:
38372: v_sql_stmt := 07.1;
38373: lv_sql_stmt :=
38374: 'UPDATE msc_st_reservations '
38375: ||' SET process_flag ='||G_ERROR_FLG||','
38376: ||' error_text = '||''''||lv_message_text||''''
38377: ||' WHERE (NVL(disposition_id,'||NULL_VALUE||') = '||NULL_VALUE
38378: ||' OR NVL(transaction_id,'||NULL_VALUE||') = '||NULL_VALUE||')'

Line 38394: 'UPDATE msc_st_reservations '

38390:
38391: v_sql_stmt := 07;
38392:
38393: lv_sql_stmt :=
38394: 'UPDATE msc_st_reservations '
38395: ||' SET transaction_id = parent_demand_id'
38396: ||' WHERE NVL(parent_demand_id,'||NULL_VALUE||') <> '||NULL_VALUE
38397: ||' AND process_flag ='||G_IN_PROCESS
38398: ||' AND batch_id = :lv_batch_id '

Line 38426: (p_table_name => 'MSC_ST_RESERVATIONS',

38422: END IF;
38423:
38424: --Derive Project Id.
38425: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
38426: (p_table_name => 'MSC_ST_RESERVATIONS',
38427: p_proj_col_name => 'PROJECT_NUMBER',
38428: p_proj_task_col_id => 'PROJECT_ID',
38429: p_instance_code => v_instance_code,
38430: p_entity_name => 'PROJECT_ID',

Line 38460: (p_table_name => 'MSC_ST_RESERVATIONS',

38456: END IF;
38457:
38458: --Derive Task Id.
38459: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
38460: (p_table_name => 'MSC_ST_RESERVATIONS',
38461: p_proj_col_name => 'PROJECT_NUMBER',
38462: p_proj_task_col_id => 'TASK_ID',
38463: p_instance_code => v_instance_code,
38464: p_entity_name => 'TASK_ID',

Line 38485: pEntityName => 'MSC_ST_RESERVATIONS',

38481: (ERRBUF => lv_error_text,
38482: RETCODE => lv_return,
38483: pBatchID => lv_batch_id,
38484: pInstanceCode => v_instance_code,
38485: pEntityName => 'MSC_ST_RESERVATIONS',
38486: pInstanceID => v_instance_id);
38487:
38488: IF NVL(lv_return,0) <> 0 THEN
38489: RAISE ex_logging_err;

Line 38495: (p_table_name => 'MSC_ST_RESERVATIONS',

38491:
38492:
38493: -- Set the process flag as Valid and populate instance_id
38494: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
38495: (p_table_name => 'MSC_ST_RESERVATIONS',
38496: p_instance_id => v_instance_id,
38497: p_instance_code => v_instance_code,
38498: p_process_flag => G_VALID,
38499: p_error_text => lv_error_text,

Line 38511: (p_table_name => 'MSC_ST_RESERVATIONS',

38507: -- At the end calling the LOG_ERROR for logging all
38508: -- errored out records.
38509:
38510: lv_return := MSC_ST_UTIL.LOG_ERROR
38511: (p_table_name => 'MSC_ST_RESERVATIONS',
38512: p_instance_code => v_instance_code,
38513: p_row => lv_column_names,
38514: p_severity => G_SEV_ERROR,
38515: p_message_text => NULL,

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

55751: End IF;
55752: END IF;
55753:
55754: IF v_reserve_enabled = SYS_YES THEN
55755: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESERVATIONS');
55756: IF lv_count > 0 Then
55757: prec.reserves_flag:= SYS_YES;
55758: End IF;
55759: END IF;