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_ITEM_SOURCING

Line 1293: ||' on MSC_ST_ITEM_SOURCING '

1289: application_short_name => 'MSC',
1290: statement_type => AD_DDL.CREATE_INDEX,
1291: statement =>
1292: 'create index MSC_ST_ITEM_SRC_N1_'||v_instance_code
1293: ||' on MSC_ST_ITEM_SOURCING '
1294: ||'(sr_instance_code, sourcing_rule_name, assignment_set_name, organization_code, company_name, receipt_organization_code, source_organization_code) '
1295: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1296: object_name =>'MSC_ST_ITEM_SRC_N1_'||v_instance_code);
1297:

Line 1379: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_SOURCING', v_instance_id, -1);

1375: WHEN OTHERS THEN
1376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_REGION_SITE_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1377: END;
1378:
1379: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_SOURCING', v_instance_id, -1);
1380: msc_analyse_tables_pk.analyse_table( 'MSC_ST_REGIONS', v_instance_id, -1);
1381: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ZONE_REGIONS', v_instance_id, -1);
1382: msc_analyse_tables_pk.analyse_table( 'MSC_ST_REGION_LOCATIONS', v_instance_id, -1);
1383: msc_analyse_tables_pk.analyse_table( 'MSC_ST_REGION_SITES', v_instance_id, -1);

Line 24149: lv_default_sourcing_rule msc_st_item_sourcing.sourcing_rule_name%TYPE

24145: lv_where_str VARCHAR2(5000);
24146: lv_sql_stmt VARCHAR2(5000);
24147: lv_cursor_stmt VARCHAR2(5000);
24148:
24149: lv_default_sourcing_rule msc_st_item_sourcing.sourcing_rule_name%TYPE
24150: := v_instance_code||':'||'SRULE' ;
24151: lv_default_assignment_set msc_st_item_sourcing.sourcing_rule_name%TYPE
24152: := 'ASET' ;
24153: lv_default_category_set msc_st_category_sets.category_set_name%TYPE := NULL_CHAR ;

Line 24151: lv_default_assignment_set msc_st_item_sourcing.sourcing_rule_name%TYPE

24147: lv_cursor_stmt VARCHAR2(5000);
24148:
24149: lv_default_sourcing_rule msc_st_item_sourcing.sourcing_rule_name%TYPE
24150: := v_instance_code||':'||'SRULE' ;
24151: lv_default_assignment_set msc_st_item_sourcing.sourcing_rule_name%TYPE
24152: := 'ASET' ;
24153: lv_default_category_set msc_st_category_sets.category_set_name%TYPE := NULL_CHAR ;
24154: lv_batch_id msc_st_item_sourcing.batch_id%TYPE;
24155: lv_message_text msc_errors.error_text%TYPE;

Line 24154: lv_batch_id msc_st_item_sourcing.batch_id%TYPE;

24150: := v_instance_code||':'||'SRULE' ;
24151: lv_default_assignment_set msc_st_item_sourcing.sourcing_rule_name%TYPE
24152: := 'ASET' ;
24153: lv_default_category_set msc_st_category_sets.category_set_name%TYPE := NULL_CHAR ;
24154: lv_batch_id msc_st_item_sourcing.batch_id%TYPE;
24155: lv_message_text msc_errors.error_text%TYPE;
24156:
24157: ex_logging_err EXCEPTION;
24158:

Line 24162: FROM msc_st_item_sourcing

24158:
24159:
24160: CURSOR c2(p_batch_id NUMBER) IS
24161: SELECT rowid
24162: FROM msc_st_item_sourcing
24163: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
24164: AND sr_instance_code = v_instance_code
24165: AND batch_id = p_batch_id;
24166:

Line 24169: FROM msc_st_item_sourcing

24165: AND batch_id = p_batch_id;
24166:
24167: CURSOR c3(p_batch_id NUMBER) IS
24168: SELECT max(rowid)
24169: FROM msc_st_item_sourcing
24170: WHERE process_flag = G_IN_PROCESS
24171: AND sr_instance_code = v_instance_code
24172: AND batch_id = p_batch_id
24173: AND NVL(sourcing_rule_id,NULL_VALUE) = NULL_VALUE

Line 24180: FROM msc_st_item_sourcing

24176: organization_code,sourcing_rule_name;
24177:
24178: CURSOR c4(p_batch_id NUMBER) IS
24179: SELECT max(rowid)
24180: FROM msc_st_item_sourcing
24181: WHERE process_flag = G_IN_PROCESS
24182: AND sr_instance_code = v_instance_code
24183: AND batch_id = p_batch_id
24184: AND NVL(assignment_set_id,NULL_VALUE) = NULL_VALUE

Line 24191: FROM msc_st_item_sourcing

24187: assignment_set_name;
24188:
24189: CURSOR c5(p_batch_id NUMBER) IS
24190: SELECT max(rowid)
24191: FROM msc_st_item_sourcing
24192: WHERE process_flag = G_IN_PROCESS
24193: AND sr_instance_code = v_instance_code
24194: AND batch_id = p_batch_id
24195: AND NVL(sr_receipt_id,NULL_VALUE) = NULL_VALUE

Line 24203: FROM msc_st_item_sourcing

24199: receipt_organization_code,receipt_org_instance_code,effective_date;
24200:
24201: CURSOR c6(p_batch_id NUMBER) IS
24202: SELECT max(rowid)
24203: FROM msc_st_item_sourcing
24204: WHERE process_flag = G_IN_PROCESS
24205: AND sr_instance_code = v_instance_code
24206: AND batch_id = p_batch_id
24207: AND NVL(sr_source_id,NULL_VALUE) = NULL_VALUE

Line 24218: FROM msc_st_item_sourcing

24214: effective_date;
24215:
24216: CURSOR c7(p_batch_id NUMBER) IS
24217: SELECT max(rowid)
24218: FROM msc_st_item_sourcing
24219: WHERE process_flag = G_IN_PROCESS
24220: AND sr_instance_code = v_instance_code
24221: AND batch_id = p_batch_id
24222: AND NVL(assignment_id,NULL_VALUE) = NULL_VALUE

Line 24246: 'UPDATE msc_st_item_sourcing msis1'

24242:
24243: v_sql_stmt := 01;
24244:
24245: lv_sql_stmt :=
24246: 'UPDATE msc_st_item_sourcing msis1'
24247: ||' SET process_flag ='||G_ERROR_FLG||','
24248: ||' error_text = '||''''||lv_message_text||''''
24249: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_item_sourcing msis2'
24250: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'

Line 24249: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_item_sourcing msis2'

24245: lv_sql_stmt :=
24246: 'UPDATE msc_st_item_sourcing msis1'
24247: ||' SET process_flag ='||G_ERROR_FLG||','
24248: ||' error_text = '||''''||lv_message_text||''''
24249: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_item_sourcing msis2'
24250: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'
24251: ||' AND NVL(msis2.organization_code,'||''''||NULL_CHAR||''''||') '
24252: ||' = NVL(msis1.organization_code,'||''''||NULL_CHAR||''''||') '
24253: ||' AND NVL(msis2.sourcing_rule_name,'||''''||NULL_CHAR||''''||') '

Line 24296: 'UPDATE msc_st_item_sourcing msis1'

24292:
24293: v_sql_stmt := 02;
24294:
24295: lv_sql_stmt :=
24296: 'UPDATE msc_st_item_sourcing msis1'
24297: ||' SET process_flag ='||G_ERROR_FLG||','
24298: ||' error_text = '||''''||lv_message_text||''''
24299: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_item_sourcing msis2'
24300: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'

Line 24299: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_item_sourcing msis2'

24295: lv_sql_stmt :=
24296: 'UPDATE msc_st_item_sourcing msis1'
24297: ||' SET process_flag ='||G_ERROR_FLG||','
24298: ||' error_text = '||''''||lv_message_text||''''
24299: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_item_sourcing msis2'
24300: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'
24301: ||' AND NVL(msis2.organization_code,'||''''||NULL_CHAR||''''||') '
24302: ||' = NVL(msis1.organization_code,'||''''||NULL_CHAR||''''||') '
24303: ||' AND NVL(msis2.sourcing_rule_name,'||''''||NULL_CHAR||''''||') '

Line 24436: ' UPDATE msc_st_item_sourcing '

24432: CLOSE c1;
24433:
24434: v_sql_stmt := 04;
24435: lv_sql_stmt :=
24436: ' UPDATE msc_st_item_sourcing '
24437: ||' SET batch_id = :lv_batch_id'
24438: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
24439: ||' AND sr_instance_code = :v_instance_code'
24440: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 24456: UPDATE msc_st_item_sourcing

24452: CLOSE c2;
24453:
24454: v_sql_stmt := 05;
24455: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
24456: UPDATE msc_st_item_sourcing
24457: SET st_transaction_id = msc_st_item_sourcing_s.NEXTVAL,
24458: refresh_id = v_refresh_id,
24459: last_update_date = v_current_date,
24460: last_updated_by = v_current_user,

Line 24457: SET st_transaction_id = msc_st_item_sourcing_s.NEXTVAL,

24453:
24454: v_sql_stmt := 05;
24455: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
24456: UPDATE msc_st_item_sourcing
24457: SET st_transaction_id = msc_st_item_sourcing_s.NEXTVAL,
24458: refresh_id = v_refresh_id,
24459: last_update_date = v_current_date,
24460: last_updated_by = v_current_user,
24461: creation_date = v_current_date,

Line 24473: p_token_value1 => 'MSC_ST_ITEM_SOURCING');

24469: p_error_code => 'MSC_PP_NO_DELETION',
24470: p_message_text => lv_message_text,
24471: p_error_text => lv_error_text,
24472: p_token1 => 'TABLE_NAME',
24473: p_token_value1 => 'MSC_ST_ITEM_SOURCING');
24474:
24475: IF lv_return <> 0 THEN
24476: RAISE ex_logging_err;
24477: END IF;

Line 24483: ' UPDATE msc_st_item_sourcing '

24479: --Deletion is not allowed on this table.
24480:
24481: v_sql_stmt := 06;
24482: lv_sql_stmt :=
24483: ' UPDATE msc_st_item_sourcing '
24484: ||' SET process_flag = '||G_ERROR_FLG||','
24485: ||' error_text = '||''''||lv_message_text||''''
24486: ||' WHERE deleted_flag = '||SYS_YES
24487: ||' AND process_flag = '||G_IN_PROCESS

Line 24519: (p_table_name => 'MSC_ST_ITEM_SOURCING',

24515: lv_where_str :=
24516: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
24517:
24518: lv_return := MSC_ST_UTIL.LOG_ERROR
24519: (p_table_name => 'MSC_ST_ITEM_SOURCING',
24520: p_instance_code => v_instance_code,
24521: p_row => lv_column_names,
24522: p_severity => G_SEV_WARNING,
24523: p_message_text => lv_message_text,

Line 24551: 'UPDATE msc_st_item_sourcing'

24547:
24548: -- Error out record where assignment_type is NOT IN (1,2,3,4,5,6)
24549: v_sql_stmt := 07;
24550: lv_sql_stmt:=
24551: 'UPDATE msc_st_item_sourcing'
24552: ||' SET process_flag = '||G_ERROR_FLG||','
24553: ||' error_text = '||''''||lv_message_text||''''
24554: ||' WHERE sr_instance_code = :v_instance_code'
24555: ||' AND batch_id = :lv_batch_id'

Line 24581: 'UPDATE msc_st_item_sourcing'

24577: -- Error out record where source_type is NOT IN (1,2,3)
24578:
24579: v_sql_stmt := 08;
24580: lv_sql_stmt:=
24581: 'UPDATE msc_st_item_sourcing'
24582: ||' SET process_flag = '||G_ERROR_FLG||','
24583: ||' error_text = '||''''||lv_message_text||''''
24584: ||' WHERE sr_instance_code = :v_instance_code'
24585: ||' AND batch_id = :lv_batch_id'

Line 24612: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_ITEM_SOURCING',

24608:
24609: -- Udpate organization_id for all the records
24610:
24611: lv_return :=
24612: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_ITEM_SOURCING',
24613: p_org_partner_name =>'ORGANIZATION_CODE',
24614: p_org_partner_id =>'ORGANIZATION_ID',
24615: p_instance_code => v_instance_code,
24616: p_partner_type => G_ORGANIZATION,

Line 24632: 'UPDATE msc_st_item_sourcing'

24628:
24629: v_sql_stmt := 09;
24630:
24631: lv_sql_stmt:=
24632: 'UPDATE msc_st_item_sourcing'
24633: ||' SET sourcing_rule_name = '||''''||lv_default_sourcing_rule||''''
24634: ||' WHERE sr_instance_code = :v_instance_code'
24635: ||' AND batch_id = :lv_batch_id'
24636: ||' AND process_flag ='||G_IN_PROCESS

Line 24651: 'UPDATE msc_st_item_sourcing'

24647:
24648: v_sql_stmt := 10;
24649:
24650: lv_sql_stmt:=
24651: 'UPDATE msc_st_item_sourcing'
24652: ||' SET assignment_set_name = '||''''||lv_default_assignment_set||''''
24653: ||' WHERE sr_instance_code = :v_instance_code'
24654: ||' AND batch_id = :lv_batch_id'
24655: ||' AND process_flag ='||G_IN_PROCESS

Line 24686: (p_table_name => 'MSC_ST_ITEM_SOURCING',

24682:
24683: lv_where_str := ' AND NVL(planning_active,'||NULL_VALUE||') NOT IN (1,2)';
24684:
24685: lv_return := MSC_ST_UTIL.LOG_ERROR
24686: (p_table_name => 'MSC_ST_ITEM_SOURCING',
24687: p_instance_code => v_instance_code,
24688: p_row => lv_column_names,
24689: p_severity => G_SEV_WARNING,
24690: p_message_text => lv_message_text,

Line 24722: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_ITEM_SOURCING',

24718: -- As of now our assumption is that receipt_org_instance_code is same as
24719: -- v_instance_code ,
24720:
24721: lv_return :=
24722: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_ITEM_SOURCING',
24723: p_org_partner_name =>'RECEIPT_ORGANIZATION_CODE',
24724: p_org_partner_id =>'RECEIPT_ORGANIZATION_ID',
24725: p_instance_code => v_instance_code,
24726: p_partner_type => G_ORGANIZATION,

Line 24742: 'UPDATE msc_st_item_sourcing msis'

24738: /* -- Update sr_receipt_org_instance_id
24739: v_sql_stmt := 09;
24740:
24741: lv_sql_stmt:=
24742: 'UPDATE msc_st_item_sourcing msis'
24743: ||' SET receipt_org_instance_id = ( SELECT instance_id FROM msc_apps_instances mai'
24744: ||' WHERE mai.instance_code = msis.sr_instance_code)'
24745: ||' WHERE sr_instance_code = :v_instance_code'
24746: ||' AND batch_id = :lv_batch_id'

Line 24759: 'UPDATE msc_st_item_sourcing msis'

24755:
24756: v_sql_stmt := 11;
24757:
24758: lv_sql_stmt:=
24759: 'UPDATE msc_st_item_sourcing msis'
24760: ||' SET receipt_org_instance_code = :v_instance_code ,'
24761: ||' source_org_instance_code = :v_instance_code'
24762: ||' WHERE sr_instance_code = :v_instance_code'
24763: ||' AND batch_id = :lv_batch_id'

Line 24790: msc_st_util.derive_item_id(p_table_name => 'MSC_ST_ITEM_SOURCING',

24786:
24787: -- Derive inventory_item_id
24788:
24789: lv_return :=
24790: msc_st_util.derive_item_id(p_table_name => 'MSC_ST_ITEM_SOURCING',
24791: p_item_col_name => 'ITEM_NAME',
24792: p_item_col_id => 'INVENTORY_ITEM_ID',
24793: p_instance_code => v_instance_code,
24794: p_instance_id => v_instance_id,

Line 24811: 'UPDATE msc_st_item_sourcing'

24807: -- If assignment_type = 3 or 6 ITEM_NAME should be valid
24808:
24809: v_sql_stmt:= 12;
24810: lv_sql_stmt:=
24811: 'UPDATE msc_st_item_sourcing'
24812: ||' SET process_flag = '||G_ERROR_FLG||','
24813: ||' error_text = '||''''||lv_message_text||''''
24814: ||' WHERE (assignment_type IN (3,6) '
24815: ||' AND NVL(inventory_item_id,'||NULL_VALUE||')'

Line 24843: 'UPDATE msc_st_item_sourcing '

24839:
24840: -- If assignment_type = 2 and 5 then category_name should not be NULL
24841: v_sql_stmt := 13;
24842: lv_sql_stmt :=
24843: 'UPDATE msc_st_item_sourcing '
24844: ||' SET process_flag = '||G_ERROR_FLG||','
24845: ||' error_text = '||''''||lv_message_text||''''
24846: ||' WHERE NVL(category_name,'||''''||NULL_CHAR||''''||') '
24847: ||' = '||''''||NULL_CHAR||''''

Line 24863: 'UPDATE MSC_ST_ITEM_SOURCING msis'

24859:
24860: v_sql_stmt :=14;
24861:
24862: lv_sql_stmt :=
24863: 'UPDATE MSC_ST_ITEM_SOURCING msis'
24864: ||' SET category_set_id = ( SELECT local_id FROM msc_local_id_misc mlim'
24865: ||' WHERE entity_name = ''SR_CATEGORY_SET_ID'' '
24866: ||' AND instance_id = '||v_instance_id
24867: ||' AND mlim.char1 = msis.sr_instance_code'

Line 24887: 'UPDATE MSC_ST_ITEM_SOURCING msis'

24883:
24884: v_sql_stmt :=15;
24885:
24886: lv_sql_stmt :=
24887: 'UPDATE MSC_ST_ITEM_SOURCING msis'
24888: ||' SET category_id = ( SELECT local_id FROM msc_local_id_misc mlim'
24889: ||' WHERE entity_name = ''SR_CATEGORY_ID'' '
24890: ||' AND instance_id = '||v_instance_id
24891: ||' AND mlim.char1 = msis.sr_instance_code'

Line 24923: 'UPDATE msc_st_item_sourcing '

24919: END IF;
24920:
24921: -- Error our records if category_id/category_set_id is NULL
24922: lv_sql_stmt :=
24923: 'UPDATE msc_st_item_sourcing '
24924: ||' SET process_flag = '||G_ERROR_FLG||','
24925: ||' error_text = '||''''||lv_message_text||''''
24926: ||' WHERE (NVL(category_id,'||NULL_VALUE||') = '||NULL_VALUE
24927: ||' OR NVL(category_set_id,'||NULL_VALUE||') = '||NULL_VALUE||')'

Line 24959: 'UPDATE MSC_ST_ITEM_SOURCING msis'

24955:
24956: v_sql_stmt :=16;
24957:
24958: lv_sql_stmt :=
24959: 'UPDATE MSC_ST_ITEM_SOURCING msis'
24960: ||' SET process_flag ='||G_ERROR_FLG||','
24961: ||' error_text = '||''''||lv_message_text||''''
24962: ||' WHERE NVL(source_partner_name,'||''''||NULL_CHAR||''''||') '
24963: ||' <> '||''''||NULL_CHAR||''''

Line 24996: 'UPDATE MSC_ST_ITEM_SOURCING msis'

24992:
24993: v_sql_stmt :=17;
24994:
24995: lv_sql_stmt :=
24996: 'UPDATE MSC_ST_ITEM_SOURCING msis'
24997: ||' SET process_flag ='||G_ERROR_FLG||','
24998: ||' error_text = '||''''||lv_message_text||''''
24999: ||' WHERE NVL(source_partner_name,'||''''||NULL_CHAR||''''||') '
25000: ||' = '||''''||NULL_CHAR||''''

Line 25028: msc_st_util.derive_partner_org_id(p_table_name => 'MSC_ST_ITEM_SOURCING',

25024:
25025:
25026: -- Now derive the source_partner_id
25027: lv_return :=
25028: msc_st_util.derive_partner_org_id(p_table_name => 'MSC_ST_ITEM_SOURCING',
25029: p_org_partner_name =>'SOURCE_PARTNER_NAME',
25030: p_org_partner_id =>'SOURCE_PARTNER_ID',
25031: p_instance_code => v_instance_code,
25032: p_partner_type => G_VENDOR,

Line 25061: (p_table_name => 'MSC_ST_ITEM_SOURCING',

25057:
25058: -- Derive source_partner_site_id
25059:
25060: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
25061: (p_table_name => 'MSC_ST_ITEM_SOURCING',
25062: p_partner_name => 'SOURCE_PARTNER_NAME',
25063: p_partner_site_code => 'SOURCE_PARTNER_SITE_CODE',
25064: p_partner_site_id => 'SOURCE_PARTNER_SITE_ID',
25065: p_instance_code => v_instance_code,

Line 25098: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25094:
25095: v_sql_stmt :=17;
25096:
25097: lv_sql_stmt :=
25098: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25099: ||' SET process_flag ='||G_ERROR_FLG||','
25100: ||' error_text = '||''''||lv_message_text||''''
25101: ||' WHERE NVL(source_organization_code,'||''''||NULL_CHAR||''''||') '
25102: ||' = '||''''||NULL_CHAR||''''

Line 25131: msc_st_util.derive_partner_org_id(p_table_name => 'MSC_ST_ITEM_SOURCING',

25127:
25128: -- Derive source_organization_id
25129:
25130: lv_return :=
25131: msc_st_util.derive_partner_org_id(p_table_name => 'MSC_ST_ITEM_SOURCING',
25132: p_org_partner_name =>'SOURCE_ORGANIZATION_CODE',
25133: p_org_partner_id =>'SOURCE_ORGANIZATION_ID',
25134: p_instance_code => v_instance_code,
25135: p_partner_type => G_ORGANIZATION,

Line 25150: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25146: -- Udpate SOURCING_RULE_ID
25147: v_sql_stmt := 18;
25148:
25149: lv_sql_stmt:=
25150: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25151: ||' SET sourcing_rule_id = (SELECT local_id '
25152: ||' FROM msc_local_id_misc mlim'
25153: ||' WHERE mlim.entity_name= ''SOURCING_RULE_ID'' '
25154: ||' AND mlim.char1 = msis.sr_instance_code'

Line 25172: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25168:
25169: -- Udpate ASSIGNMENT_SET_ID
25170: v_sql_stmt := 19;
25171: lv_sql_stmt:=
25172: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25173: ||' SET assignment_set_id = (SELECT local_id'
25174: ||' FROM msc_local_id_misc mlim'
25175: ||' WHERE mlim.entity_name= ''ASSIGNMENT_SET_ID'' '
25176: ||' AND mlim.char1 = msis.sr_instance_code'

Line 25194: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25190:
25191: v_sql_stmt := 20;
25192:
25193: lv_sql_stmt:=
25194: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25195: ||' SET sr_receipt_id = (SELECT local_id'
25196: ||' FROM msc_local_id_misc mlim'
25197: ||' WHERE mlim.entity_name= ''SR_RECEIPT_ID'' '
25198: ||' AND mlim.char1 = msis.sr_instance_code'

Line 25224: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25220: -- Udpate SR_SOURCE_ID
25221: v_sql_stmt := 21;
25222:
25223: lv_sql_stmt:=
25224: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25225: ||' SET sr_source_id = (SELECT local_id'
25226: ||' FROM msc_local_id_misc mlim'
25227: ||' WHERE mlim.entity_name= ''SR_SOURCE_ID'' '
25228: ||' AND mlim.char1 = msis.sr_instance_code'

Line 25261: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25257: -- Udpate assignment_id
25258: v_sql_stmt := 22;
25259:
25260: lv_sql_stmt:=
25261: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25262: ||' SET assignment_id = (SELECT local_id '
25263: ||' FROM msc_local_id_misc mlim'
25264: ||' WHERE mlim.entity_name= ''ASSIGNMENT_ID'' '
25265: ||' AND mlim.instance_id = '||v_instance_id

Line 25300: ' UPDATE MSC_ST_ITEM_SOURCING msis'

25296:
25297: -- Error out records if any id derivation fails and deleted_flag = 1
25298: v_sql_stmt := 23;
25299: lv_sql_stmt:=
25300: ' UPDATE MSC_ST_ITEM_SOURCING msis'
25301: ||' SET process_flag = '||G_ERROR_FLG||','
25302: ||' error_text = '||''''||lv_message_text||''''
25303: ||' WHERE ( NVL(sourcing_rule_id,'||NULL_VALUE||') ='||NULL_VALUE
25304: ||' OR NVL(sr_receipt_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 25323: pEntityName => 'MSC_ST_ITEM_SOURCING',

25319: (ERRBUF => lv_error_text,
25320: RETCODE => lv_return,
25321: pBatchID => lv_batch_id,
25322: pInstanceCode => v_instance_code,
25323: pEntityName => 'MSC_ST_ITEM_SOURCING',
25324: pInstanceID => v_instance_id);
25325:
25326: IF NVL(lv_return,0) <> 0 THEN
25327: RAISE ex_logging_err;

Line 25340: UPDATE msc_st_item_sourcing

25336: IF c3%ROWCOUNT > 0 THEN
25337:
25338: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25339:
25340: UPDATE msc_st_item_sourcing
25341: SET sourcing_rule_id = msc_st_sourcing_rule_id_s.NEXTVAL
25342: WHERE rowid = lb_rowid(j);
25343:
25344: v_sql_stmt := 25;

Line 25392: FROM msc_st_item_sourcing

25388: v_current_date,
25389: v_current_user,
25390: v_current_date,
25391: v_current_user
25392: FROM msc_st_item_sourcing
25393: WHERE rowid = lb_rowid(j);
25394:
25395: END IF;
25396: CLOSE c3;

Line 25402: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25398: -- Udpate SOURCING_RULE_ID
25399: v_sql_stmt := 26;
25400:
25401: lv_sql_stmt:=
25402: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25403: ||' SET sourcing_rule_id = (SELECT local_id '
25404: ||' FROM msc_local_id_misc mlim'
25405: ||' WHERE mlim.entity_name= ''SOURCING_RULE_ID'' '
25406: ||' AND mlim.char1 = msis.sr_instance_code'

Line 25434: UPDATE msc_st_item_sourcing

25430: IF c4%ROWCOUNT > 0 THEN
25431:
25432: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25433:
25434: UPDATE msc_st_item_sourcing
25435: SET assignment_set_id = msc_st_assignment_set_id_s.NEXTVAL
25436: WHERE rowid = lb_rowid(j);
25437:
25438: v_sql_stmt := 28;

Line 25472: FROM msc_st_item_sourcing

25468: v_current_date,
25469: v_current_user,
25470: v_current_date,
25471: v_current_user
25472: FROM msc_st_item_sourcing
25473: WHERE rowid = lb_rowid(j);
25474:
25475: END IF;
25476: CLOSE c4;

Line 25481: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25477:
25478: -- Udpate ASSIGNMENT_SET_ID
25479: v_sql_stmt := 29;
25480: lv_sql_stmt:=
25481: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25482: ||' SET assignment_set_id = (SELECT local_id'
25483: ||' FROM msc_local_id_misc mlim'
25484: ||' WHERE mlim.entity_name= ''ASSIGNMENT_SET_ID'' '
25485: ||' AND mlim.char1 = msis.sr_instance_code'

Line 25509: UPDATE msc_st_item_sourcing

25505: IF c5%ROWCOUNT > 0 THEN
25506:
25507: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25508:
25509: UPDATE msc_st_item_sourcing
25510: SET sr_receipt_id = msc_st_sr_receipt_id_s.NEXTVAL
25511: WHERE rowid = lb_rowid(j);
25512:
25513: v_sql_stmt := 31;

Line 25571: FROM msc_st_item_sourcing

25567: v_current_date,
25568: v_current_user,
25569: v_current_date,
25570: v_current_user
25571: FROM msc_st_item_sourcing
25572: WHERE rowid = lb_rowid(j);
25573:
25574: END IF;
25575: CLOSE c5;

Line 25582: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25578:
25579: v_sql_stmt := 32;
25580:
25581: lv_sql_stmt:=
25582: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25583: ||' SET sr_receipt_id = (SELECT local_id'
25584: ||' FROM msc_local_id_misc mlim'
25585: ||' WHERE mlim.entity_name= ''SR_RECEIPT_ID'' '
25586: ||' AND mlim.char1 = msis.sr_instance_code'

Line 25619: UPDATE msc_st_item_sourcing

25615: IF c6%ROWCOUNT > 0 THEN
25616:
25617: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25618:
25619: UPDATE msc_st_item_sourcing
25620: SET sr_source_id = msc_st_sr_source_id_s.NEXTVAL
25621: WHERE rowid = lb_rowid(j);
25622:
25623: v_sql_stmt := 34;

Line 25697: FROM msc_st_item_sourcing

25693: v_current_date,
25694: v_current_user,
25695: v_current_date,
25696: v_current_user
25697: FROM msc_st_item_sourcing
25698: WHERE rowid = lb_rowid(j);
25699:
25700: END IF;
25701: CLOSE c6;

Line 25707: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25703: -- Udpate SR_SOURCE_ID
25704: v_sql_stmt := 35;
25705:
25706: lv_sql_stmt:=
25707: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25708: ||' SET sr_source_id = (SELECT local_id'
25709: ||' FROM msc_local_id_misc mlim'
25710: ||' WHERE mlim.entity_name= ''SR_SOURCE_ID'' '
25711: ||' AND mlim.char1 = msis.sr_instance_code'

Line 25753: UPDATE msc_st_item_sourcing

25749: IF c7%ROWCOUNT > 0 THEN
25750:
25751: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
25752:
25753: UPDATE msc_st_item_sourcing
25754: SET assignment_id = msc_st_assignment_id_s.NEXTVAL
25755: WHERE rowid = lb_rowid(j);
25756:
25757: v_sql_stmt := 37;

Line 25808: FROM msc_st_item_sourcing

25804: v_current_date,
25805: v_current_user,
25806: v_current_date,
25807: v_current_user
25808: FROM msc_st_item_sourcing
25809: WHERE rowid = lb_rowid(j);
25810:
25811: END IF;
25812: CLOSE c7;

Line 25818: 'UPDATE MSC_ST_ITEM_SOURCING msis'

25814: -- Udpate assignment_id
25815: v_sql_stmt := 38;
25816:
25817: lv_sql_stmt:=
25818: 'UPDATE MSC_ST_ITEM_SOURCING msis'
25819: ||' SET assignment_id = (SELECT local_id '
25820: ||' FROM msc_local_id_misc mlim'
25821: ||' WHERE mlim.entity_name= ''ASSIGNMENT_ID'' '
25822: ||' AND mlim.instance_id = '||v_instance_id

Line 25876: ||' FROM MSC_ST_ITEM_SOURCING'

25872: ||' LAST_UPDATED_BY,'
25873: ||' LAST_UPDATE_DATE,'
25874: ||' CREATED_BY,'
25875: ||' CREATION_DATE '
25876: ||' FROM MSC_ST_ITEM_SOURCING'
25877: ||' WHERE SR_INSTANCE_CODE = :v_instance_code'
25878: ||' AND process_flag = '||G_IN_PROCESS
25879: ||' AND batch_id = :lv_batch_id' ;
25880:

Line 25916: ||' FROM MSC_ST_ITEM_SOURCING'

25912: ||' LAST_UPDATED_BY,'
25913: ||' LAST_UPDATE_DATE,'
25914: ||' CREATED_BY,'
25915: ||' CREATION_DATE '
25916: ||' FROM MSC_ST_ITEM_SOURCING'
25917: ||' WHERE SR_INSTANCE_CODE = :v_instance_code'
25918: ||' AND PROCESS_FLAG = '||G_IN_PROCESS
25919: ||' AND batch_id = :lv_batch_id' ;
25920:

Line 25965: ||' FROM MSC_ST_ITEM_SOURCING'

25961: ||' LAST_UPDATED_BY,'
25962: ||' LAST_UPDATE_DATE,'
25963: ||' CREATED_BY,'
25964: ||' CREATION_DATE '
25965: ||' FROM MSC_ST_ITEM_SOURCING'
25966: ||' where SR_INSTANCE_CODE = :v_instance_code'
25967: ||' AND PROCESS_FLAG = '||G_IN_PROCESS
25968: ||' AND batch_id = :lv_batch_id' ;
25969:

Line 26000: ||' FROM MSC_ST_ITEM_SOURCING'

25996: ||' LAST_UPDATED_BY,'
25997: ||' LAST_UPDATE_DATE,'
25998: ||' CREATED_BY,'
25999: ||' CREATION_DATE '
26000: ||' FROM MSC_ST_ITEM_SOURCING'
26001: ||' where SR_INSTANCE_CODE = :v_instance_code'
26002: ||' AND PROCESS_FLAG = '||G_IN_PROCESS
26003: ||' AND batch_id = :lv_batch_id' ;
26004:

Line 26048: ||' from MSC_ST_ITEM_SOURCING'

26044: ||' LAST_UPDATED_BY,'
26045: ||' LAST_UPDATE_DATE,'
26046: ||' CREATED_BY,'
26047: ||' CREATION_DATE '
26048: ||' from MSC_ST_ITEM_SOURCING'
26049: ||' where SR_INSTANCE_CODE = :v_instance_code'
26050: ||' AND PROCESS_FLAG = '||G_IN_PROCESS
26051: ||' AND batch_id = :lv_batch_id' ;
26052:

Line 26061: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_ITEM_SOURCING',

26057: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
26058:
26059: -- Set the processf flag as Valid and poulate instance_id
26060: lv_return :=
26061: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_ITEM_SOURCING',
26062: p_instance_id => v_instance_id,
26063: p_instance_code => v_instance_code,
26064: p_process_flag => G_VALID,
26065: p_error_text => lv_error_text,

Line 26076: msc_st_util.log_error(p_table_name => 'MSC_ST_ITEM_SOURCING',

26072:
26073: -- At the end calling the LOG_ERROR for logging all errored out records
26074:
26075: lv_return :=
26076: msc_st_util.log_error(p_table_name => 'MSC_ST_ITEM_SOURCING',
26077: p_instance_code => v_instance_code,
26078: p_row => lv_column_names,
26079: p_severity => G_SEV_ERROR,
26080: p_error_text => lv_error_text,

Line 50888: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_SOURCING');

50884: End IF;
50885: END IF;
50886:
50887: IF v_sourcing_enabled = SYS_YES THEN
50888: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_SOURCING');
50889: IF lv_count > 0 Then
50890: prec.sourcing_rule_flag:= SYS_YES;
50891: End IF;
50892: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_REGIONS');