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_DESIGNATORS

Line 21306: | msc_st_designators. |

21302: END LOAD_UOM_CLASS_CONV;
21303:
21304: /*==========================================================================+
21305: | DESCRIPTION : This procedure validates the records and updates the table |
21306: | msc_st_designators. |
21307: | |
21308: | Designator Types Type Code |
21309: | ---------------------------------------------------------- |
21310: | Manual MDS 1 |

Line 21323: lv_batch_id msc_st_designators.batch_id%TYPE;

21319: lv_where_str VARCHAR2(5000);
21320: lv_sql_stmt VARCHAR2(5000);
21321: lv_return NUMBER;
21322:
21323: lv_batch_id msc_st_designators.batch_id%TYPE;
21324: lv_message_text msc_errors.error_text%TYPE;
21325: ex_logging_err EXCEPTION;
21326:
21327: CURSOR c1(lv_batch_id NUMBER) IS

Line 21329: FROM msc_st_designators

21325: ex_logging_err EXCEPTION;
21326:
21327: CURSOR c1(lv_batch_id NUMBER) IS
21328: SELECT rowid
21329: FROM msc_st_designators
21330: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
21331: AND sr_instance_code = v_instance_code
21332: AND batch_id = lv_batch_id;
21333:

Line 21350: 'UPDATE msc_st_designators msd1 '

21346: --Duplicate records check for the records whose source is XML
21347: --Based on bug#2736771 UDK has been changed.
21348: v_sql_stmt := 01;
21349: lv_sql_stmt :=
21350: 'UPDATE msc_st_designators msd1 '
21351: ||' SET process_flag = '||G_ERROR_FLG||','
21352: ||' error_text = '||''''||lv_message_text||''''
21353: ||' WHERE message_id < (SELECT MAX(message_id)'
21354: ||' FROM msc_st_designators msd2'

Line 21354: ||' FROM msc_st_designators msd2'

21350: 'UPDATE msc_st_designators msd1 '
21351: ||' SET process_flag = '||G_ERROR_FLG||','
21352: ||' error_text = '||''''||lv_message_text||''''
21353: ||' WHERE message_id < (SELECT MAX(message_id)'
21354: ||' FROM msc_st_designators msd2'
21355: ||' WHERE msd2.sr_instance_code = msd1.sr_instance_code'
21356: ||' AND NVL(msd2.company_name, '||''''||NULL_CHAR||''''||') = '
21357: ||' NVL(msd1.company_name, '||''''||NULL_CHAR||''''||')'
21358: ||' AND msd2.organization_code = msd1.organization_code'

Line 21388: 'UPDATE msc_st_designators msd1'

21384: --Different SQL is used because in XML we can identify the latest records
21385: --whereas in batch load we cannot.
21386: v_sql_stmt := 02;
21387: lv_sql_stmt :=
21388: 'UPDATE msc_st_designators msd1'
21389: ||' SET process_flag = '||G_ERROR_FLG||','
21390: ||' error_text = '||''''||lv_message_text||''''
21391: ||' WHERE EXISTS( SELECT 1 '
21392: ||' FROM msc_st_designators msd2'

Line 21392: ||' FROM msc_st_designators msd2'

21388: 'UPDATE msc_st_designators msd1'
21389: ||' SET process_flag = '||G_ERROR_FLG||','
21390: ||' error_text = '||''''||lv_message_text||''''
21391: ||' WHERE EXISTS( SELECT 1 '
21392: ||' FROM msc_st_designators msd2'
21393: ||' WHERE msd2.sr_instance_code = msd1.sr_instance_code'
21394: ||' AND NVL(msd2.company_name, '||''''||NULL_CHAR||''''||') = '
21395: ||' NVL(msd1.company_name, '||''''||NULL_CHAR||''''||')'
21396: ||' AND msd2.organization_code = msd1.organization_code'

Line 21450: 'UPDATE msc_st_designators '

21446: FROM dual;
21447:
21448: v_sql_stmt := 04;
21449: lv_sql_stmt :=
21450: 'UPDATE msc_st_designators '
21451: ||' SET batch_id = :lv_batch_id'
21452: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
21453: ||' AND sr_instance_code = :v_instance_code'
21454: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 21472: UPDATE msc_st_designators

21468: CLOSE c1;
21469:
21470: v_sql_stmt := 05;
21471: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
21472: UPDATE msc_st_designators
21473: SET st_transaction_id = msc_st_designators_s.NEXTVAL,
21474: refresh_id = v_refresh_id,
21475: last_update_date = v_current_date,
21476: last_updated_by = v_current_user,

Line 21473: SET st_transaction_id = msc_st_designators_s.NEXTVAL,

21469:
21470: v_sql_stmt := 05;
21471: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
21472: UPDATE msc_st_designators
21473: SET st_transaction_id = msc_st_designators_s.NEXTVAL,
21474: refresh_id = v_refresh_id,
21475: last_update_date = v_current_date,
21476: last_updated_by = v_current_user,
21477: creation_date = v_current_date,

Line 21495: 'UPDATE msc_st_designators '

21491: END IF;
21492:
21493: v_sql_stmt := 06;
21494: lv_sql_stmt :=
21495: 'UPDATE msc_st_designators '
21496: ||' SET error_text = '||''''||lv_message_text||''''||','
21497: ||' process_flag = '||G_ERROR_FLG
21498: ||' WHERE nvl(designator_type,'||NULL_VALUE||') NOT IN(1,2,6)'
21499: ||' AND deleted_flag = '||SYS_NO

Line 21519: p_token_value1 => 'MSC_ST_DESIGNATORS');

21515: p_error_code => 'MSC_PP_NO_DELETION',
21516: p_message_text => lv_message_text,
21517: p_error_text => lv_error_text,
21518: p_token1 => 'TABLE_NAME',
21519: p_token_value1 => 'MSC_ST_DESIGNATORS');
21520:
21521: IF lv_return <> 0 THEN
21522: RAISE ex_logging_err;
21523: END IF;

Line 21528: 'UPDATE msc_st_designators '

21524:
21525: -- Deletion is not allowed for this table
21526: v_sql_stmt := 07;
21527: lv_sql_stmt :=
21528: 'UPDATE msc_st_designators '
21529: ||' SET process_flag = '||G_ERROR_FLG||','
21530: ||' error_text = '||''''||lv_message_text||''''
21531: ||' WHERE deleted_flag = '||SYS_YES
21532: ||' AND process_flag = '||G_IN_PROCESS

Line 21565: (p_table_name => 'MSC_ST_DESIGNATORS',

21561:
21562: --Log a warning for those records where the deleted_flag has a value other
21563: --SYS_NO
21564: lv_return := MSC_ST_UTIL.LOG_ERROR
21565: (p_table_name => 'MSC_ST_DESIGNATORS',
21566: p_instance_code => v_instance_code,
21567: p_row => lv_column_names,
21568: p_severity => G_SEV_WARNING,
21569: p_message_text => lv_message_text,

Line 21595: (p_table_name => 'MSC_ST_DESIGNATORS',

21591: END IF;
21592:
21593: --Derive Organization_id
21594: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
21595: (p_table_name => 'MSC_ST_DESIGNATORS',
21596: p_org_partner_name => 'ORGANIZATION_CODE',
21597: p_org_partner_id => 'ORGANIZATION_ID',
21598: p_instance_code => v_instance_code,
21599: p_partner_type => G_ORGANIZATION,

Line 21625: 'UPDATE msc_st_designators '

21621: END IF;
21622:
21623: v_sql_stmt := 08;
21624: lv_sql_stmt :=
21625: 'UPDATE msc_st_designators '
21626: ||' SET error_text = '||''''||lv_message_text||''''||','
21627: ||' process_flag = '||G_ERROR_FLG
21628: ||' WHERE NVL(designator,'||''''||NULL_CHAR||''''||')'
21629: ||' = '||''''||NULL_CHAR||''''

Line 21657: MSC_ST_UTIL.VALIDATE_DMD_CLASS(p_table_name => 'MSC_ST_DESIGNATORS',

21653:
21654: -- Validate Demand Class, if value provided it should exists
21655: -- in ODS or staging table
21656: lv_return :=
21657: MSC_ST_UTIL.VALIDATE_DMD_CLASS(p_table_name => 'MSC_ST_DESIGNATORS',
21658: p_dmd_class_column => 'DEMAND_CLASS',
21659: p_instance_id => v_instance_id,
21660: p_instance_code => v_instance_code,
21661: p_severity => G_SEV3_ERROR,

Line 21674: 'UPDATE msc_st_designators '

21670:
21671:
21672: v_sql_stmt := 10;
21673: lv_sql_stmt :=
21674: 'UPDATE msc_st_designators '
21675: ||' SET inventory_atp_flag = '||G_FOR_INV_ATP_FLAG
21676: --||' mps_relief = '||G_FOR_MPS_RELIEF ||','
21677: --||' consume_forecast = '||G_CONSUME_FORECAST ||','
21678: --||' update_type = '||G_UPDATE_TYPE

Line 21694: 'UPDATE msc_st_designators '

21690: v_instance_code;
21691:
21692: v_sql_stmt := 11;
21693: lv_sql_stmt :=
21694: 'UPDATE msc_st_designators '
21695: ||' SET inventory_atp_flag = '||G_INV_ATP_FLAG
21696: ||' WHERE NVL(inventory_atp_flag,'||NULL_VALUE||') NOT IN(1,2)'
21697: ||' AND NVL(designator_type,'||NULL_VALUE||') IN(1,2)'
21698: ||' AND process_flag = '||G_IN_PROCESS

Line 21711: 'UPDATE msc_st_designators '

21707: v_instance_code;
21708:
21709: v_sql_stmt := 12;
21710: lv_sql_stmt :=
21711: 'UPDATE msc_st_designators '
21712: ||' SET mps_relief = '||G_MPS_RELIEF
21713: ||' WHERE designator_type IN(1,2)'
21714: ||' AND process_flag ='|| G_IN_PROCESS
21715: ||' AND batch_id = :lv_batch_id'

Line 21727: ' UPDATE msc_st_designators '

21723: v_instance_code;
21724:
21725: v_sql_stmt := 13;
21726: lv_sql_stmt :=
21727: ' UPDATE msc_st_designators '
21728: ||' SET bucket_type = '||G_BUCKET_TYPE
21729: ||' WHERE NVL(bucket_type,'||NULL_VALUE||') NOT IN(1,2,3,'||NULL_VALUE||')'
21730: ||' AND designator_type = 6'
21731: ||' AND process_flag = '||G_IN_PROCESS

Line 21757: (p_table_name => 'MSC_ST_DESIGNATORS',

21753: END IF;
21754:
21755: --Derive Customer_id
21756: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
21757: (p_table_name => 'MSC_ST_DESIGNATORS',
21758: p_org_partner_name => 'CUSTOMER_NAME',
21759: p_org_partner_id => 'CUSTOMER_ID',
21760: p_instance_code => v_instance_code,
21761: p_partner_type => G_CUSTOMER,

Line 21787: (p_table_name => 'MSC_ST_DESIGNATORS',

21783: END IF;
21784:
21785: --Derive Bill_id
21786: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
21787: (p_table_name => 'MSC_ST_DESIGNATORS',
21788: p_partner_name => 'CUSTOMER_NAME',
21789: p_partner_site_code => 'BILL_TO_SITE_CODE',
21790: p_partner_site_id => 'BILL_ID',
21791: p_instance_code => v_instance_code,

Line 21818: (p_table_name => 'MSC_ST_DESIGNATORS',

21814: END IF;
21815:
21816: --Derive Ship_id
21817: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
21818: (p_table_name => 'MSC_ST_DESIGNATORS',
21819: p_partner_name => 'CUSTOMER_NAME',
21820: p_partner_site_code => 'SHIP_TO_SITE_CODE',
21821: p_partner_site_id => 'SHIP_ID',
21822: p_instance_code => v_instance_code,

Line 21841: pEntityName => 'MSC_ST_DESIGNATORS',

21837: (ERRBUF => lv_error_text,
21838: RETCODE => lv_return,
21839: pBatchID => lv_batch_id,
21840: pInstanceCode => v_instance_code,
21841: pEntityName => 'MSC_ST_DESIGNATORS',
21842: pInstanceID => v_instance_id);
21843:
21844: IF NVL(lv_return,0) <> 0 THEN
21845: RAISE ex_logging_err;

Line 21867: 'UPDATE msc_st_designators msd'

21863: END IF;
21864:
21865:
21866: lv_sql_stmt :=
21867: 'UPDATE msc_st_designators msd'
21868: ||' SET error_text = '||''''||lv_message_text||''''||','
21869: ||' process_flag = '||G_ERROR_FLG
21870: ||' WHERE EXISTS (SELECT 1 '
21871: ||' FROM msc_designators md'

Line 21896: 'insert into MSC_ST_DESIGNATORS'

21892: -- Insert record in staging for forecast set
21893:
21894: v_sql_stmt := 14;
21895: lv_sql_stmt :=
21896: 'insert into MSC_ST_DESIGNATORS'
21897: ||' ( DESIGNATOR,'
21898: ||' FORECAST_SET,'
21899: ||' COMPANY_ID,'
21900: ||' ORGANIZATION_ID,'

Line 21952: ||' from MSC_ST_DESIGNATORS msd'

21948: ||' MESSAGE_ID,'
21949: ||' DATA_SOURCE_TYPE,'
21950: || G_IN_PROCESS||','
21951: ||' SR_INSTANCE_CODE'
21952: ||' from MSC_ST_DESIGNATORS msd'
21953: ||' WHERE NOT EXISTS ('
21954: /* Bug 13114192
21955: ||' SELECT 1 FROM MSC_DESIGNATORS md'
21956: ||' WHERE md.designator = msd.forecast_set'

Line 21963: ||' FROM msc_st_designators msd1'

21959: ||' AND md.sr_instance_id = :v_instance_id'
21960: ||' UNION'
21961: */
21962: ||' SELECT 1'
21963: ||' FROM msc_st_designators msd1'
21964: ||' WHERE msd.forecast_set = msd1.designator'
21965: ||' AND msd.organization_code = msd1.organization_code'
21966: ||' AND msd1.sr_instance_code = :v_instance_code'
21967: ||' AND msd1.designator_type = 6'

Line 21992: (p_table_name => 'MSC_ST_DESIGNATORS',

21988:
21989:
21990:
21991: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
21992: (p_table_name => 'MSC_ST_DESIGNATORS',
21993: p_instance_id => v_instance_id,
21994: p_instance_code => v_instance_code,
21995: p_process_flag => G_VALID,
21996: p_error_text => lv_error_text,

Line 22005: (p_table_name => 'MSC_ST_DESIGNATORS',

22001: RAISE ex_logging_err;
22002: END IF;
22003:
22004: lv_return := MSC_ST_UTIL.LOG_ERROR
22005: (p_table_name => 'MSC_ST_DESIGNATORS',
22006: p_instance_code => v_instance_code,
22007: p_row => lv_column_names,
22008: p_severity => G_SEV_ERROR,
22009: p_message_text => NULL,

Line 34802: p_token_value2 => 'MSC_ST_DESIGNATORS',

34798: ||' ORGANIZATION_CODE,'
34799: ||' DESIGNATOR_TYPE AND'
34800: ||' DESIGNATOR',
34801: p_token2 => 'MASTER_TABLE',
34802: p_token_value2 => 'MSC_ST_DESIGNATORS',
34803: p_token3 => 'CHILD_TABLE',
34804: p_token_value3 => 'MSC_ST_SUPPLIES');
34805:
34806: IF lv_return <> 0 THEN

Line 34816: ||' FROM msc_st_designators msd'

34812: 'UPDATE msc_st_supplies mss'
34813: ||' SET process_flag = '||G_ERROR_FLG||','
34814: ||' error_text = '||''''||lv_message_text||''''
34815: ||' WHERE NOT EXISTS(SELECT 1'
34816: ||' FROM msc_st_designators msd'
34817: ||' WHERE msd.designator = mss.schedule_designator'
34818: ||' AND msd.organization_code = mss.organization_code'
34819: ||' AND NVL(msd.company_name,'||''''||NULL_CHAR||''''||') = '
34820: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 34854: ||' FROM msc_st_designators msd'

34850: 'UPDATE msc_st_supplies mss'
34851: ||' SET process_flag = '||G_ERROR_FLG||','
34852: ||' error_text = '||''''||lv_message_text||''''
34853: ||' WHERE NOT EXISTS(SELECT 1'
34854: ||' FROM msc_st_designators msd'
34855: ||' WHERE msd.designator = mss.schedule_designator'
34856: ||' AND msd.organization_code = mss.organization_code'
34857: ||' AND NVL(msd.company_name,'||''''||NULL_CHAR||''''||') = '
34858: ||' NVL(mss.company_name,'||''''||NULL_CHAR||''''||') '

Line 34900: p_token_value2 => 'MSC_ST_DESIGNATORS',

34896: p_error_text => lv_error_text,
34897: p_token1 => 'COLUMN_NAMES',
34898: p_token_value1 => 'SHIP_TO_PARTY_NAME',
34899: p_token2 => 'MASTER_TABLE',
34900: p_token_value2 => 'MSC_ST_DESIGNATORS',
34901: p_token3 => 'CHILD_TABLE',
34902: p_token_value3 => 'MSC_ST_SUPPLIES');
34903:
34904: IF lv_return <> 0 THEN

Line 34939: p_token_value2 => 'MSC_ST_DESIGNATORS',

34935: p_token1 => 'COLUMN_NAMES',
34936: p_token_value1 => 'SHIP_TO_PARTY_NAME AND'
34937: ||' SHIP_TO_SITE_CODE',
34938: p_token2 => 'MASTER_TABLE',
34939: p_token_value2 => 'MSC_ST_DESIGNATORS',
34940: p_token3 => 'CHILD_TABLE',
34941: p_token_value3 => 'MSC_ST_SUPPLIES');
34942:
34943: IF lv_return <> 0 THEN

Line 39193: p_token_value2 => 'MSC_ST_DESIGNATORS',

39189: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
39190: ||' ORGANIZATION_CODE,'
39191: ||' DEMAND_SCHEDULE_NAME',
39192: p_token2 => 'MASTER_TABLE',
39193: p_token_value2 => 'MSC_ST_DESIGNATORS',
39194: p_token3 => 'CHILD_TABLE' ,
39195: p_token_value3 => 'MSC_ST_DEMANDS' );
39196:
39197: IF lv_return <> 0 THEN

Line 39209: ||' FROM msc_st_designators msd'

39205: 'UPDATE msc_st_demands msdm'
39206: ||' SET process_flag = '||G_ERROR_FLG||','
39207: ||' error_text = '||''''||lv_message_text||''''
39208: ||' WHERE NOT EXISTS(SELECT 1'
39209: ||' FROM msc_st_designators msd'
39210: ||' WHERE msd.designator = msdm.demand_schedule_name'
39211: ||' AND NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
39212: ||' = NVL(msdm.company_name,'||''''||NULL_CHAR||''''||') '
39213: ||' AND msd.organization_code = msdm.organization_code'

Line 39291: p_token_value2 => 'MSC_ST_DESIGNATORS',

39287: p_token1 => 'COLUMN_NAMES',
39288: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
39289: ||'ORGANIZATION_CODE,FORECAST_DESIGNATOR',
39290: p_token2 => 'MASTER_TABLE',
39291: p_token_value2 => 'MSC_ST_DESIGNATORS',
39292: p_token3 => 'CHILD_TABLE' ,
39293: p_token_value3 => 'MSC_ST_DEMANDS' );
39294:
39295: IF lv_return <> 0 THEN

Line 39307: ||' FROM msc_st_designators msd'

39303: 'UPDATE msc_st_demands msdm'
39304: ||' SET process_flag = '||G_ERROR_FLG||','
39305: ||' error_text = '||''''||lv_message_text||''''
39306: ||' WHERE NOT EXISTS(SELECT 1'
39307: ||' FROM msc_st_designators msd'
39308: ||' WHERE msd.designator = msdm.forecast_designator'
39309: ||' AND NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
39310: ||' = NVL(msd.company_name,'||''''||NULL_CHAR||''''||') '
39311: ||' AND msd.organization_code = msdm.organization_code'

Line 55793: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_DESIGNATORS',p_erp_enabled => 'Y');

55789: End IF;
55790: END IF;
55791:
55792: IF v_desig_enabled = SYS_YES THEN
55793: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_DESIGNATORS',p_erp_enabled => 'Y');
55794: IF lv_count > 0 Then
55795: prec.mds_flag:= SYS_YES;
55796: prec.forecast_flag:= SYS_YES;
55797: prec.mps_flag:= SYS_YES;