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.MSD_CL_PRE_PROCESS dependencies on MSD_ST_ITEM_RELATIONSHIPS

Line 7914: lv_batch_id msd_st_item_relationships.batch_id%TYPE;

7910: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
7911:
7912: lb_rowid RowidTab;
7913: lv_sql_stmt VARCHAR2(4000);
7914: lv_batch_id msd_st_item_relationships.batch_id%TYPE;
7915: lv_message_text msc_errors.error_text%TYPE;
7916: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
7917: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
7918: lv_current_date DATE := msc_cl_pre_process.v_current_date;

Line 7931: FROM msd_st_item_relationships

7927:
7928:
7929: CURSOR c1(p_batch_id NUMBER)IS
7930: SELECT rowid
7931: FROM msd_st_item_relationships
7932: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
7933: AND sr_instance_code = p_instance_code
7934: AND batch_id = p_batch_id;
7935:

Line 7954: 'UPDATE msd_st_item_relationships'

7950:
7951: v_sql_stmt := 02;
7952:
7953: lv_sql_stmt :=
7954: 'UPDATE msd_st_item_relationships'
7955: ||' SET batch_id = :lv_batch_id '
7956: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
7957: ||' AND sr_instance_code = :lv_instance_code'
7958: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 7977: UPDATE msd_st_item_relationships

7973: CLOSE c1;
7974:
7975: v_sql_stmt := 03;
7976: FORALL j IN 1..lb_rowid.COUNT
7977: UPDATE msd_st_item_relationships
7978: SET st_transaction_id = msd_st_item_relationships_s.NEXTVAL,
7979: last_update_date = lv_current_date,
7980: last_updated_by = lv_current_user,
7981: creation_date = lv_current_date,

Line 7978: SET st_transaction_id = msd_st_item_relationships_s.NEXTVAL,

7974:
7975: v_sql_stmt := 03;
7976: FORALL j IN 1..lb_rowid.COUNT
7977: UPDATE msd_st_item_relationships
7978: SET st_transaction_id = msd_st_item_relationships_s.NEXTVAL,
7979: last_update_date = lv_current_date,
7980: last_updated_by = lv_current_user,
7981: creation_date = lv_current_date,
7982: created_by = lv_current_user

Line 8002: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',

7998:
7999: -- Derive INVENTORY_ITEM_ID from msd_st_level_values and msd_level_values
8000:
8001: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
8002: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',
8003: p_column_name => 'INVENTORY_ITEM',
8004: p_pk_col_name => 'INVENTORY_ITEM_ID',
8005: p_level_id => 1,
8006: p_instance_code => p_instance_code,

Line 8033: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',

8029:
8030: -- Derive RELATED_ITEM_ID from msd_st_level_values and msd_level_values
8031:
8032: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
8033: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',
8034: p_column_name => 'RELATED_ITEM',
8035: p_pk_col_name => 'RELATED_ITEM_ID',
8036: p_level_id => 1,
8037: p_instance_code => p_instance_code,

Line 8050: 'UPDATE msd_st_item_relationships t1'

8046: END IF;
8047:
8048: v_sql_stmt := 04;
8049: lv_sql_Stmt:=
8050: 'UPDATE msd_st_item_relationships t1'
8051: ||' SET t1.relationship_type_id = 8 ' -- Relationship Type - Superseded
8052: ||' WHERE t1.process_flag ='|| G_IN_PROCESS
8053: ||' AND t1.batch_id = :lv_batch_id'
8054: ||' AND t1.sr_instance_code = :p_instance_code';

Line 8071: 'UPDATE msd_st_item_relationships t1'

8067:
8068: /*
8069: v_sql_stmt := 04;
8070: lv_sql_Stmt:=
8071: 'UPDATE msd_st_item_relationships t1'
8072: ||' SET t1.relationship_type_id = ( select lookup_code '
8073: ||' from mfg_lookups t2 '
8074: ||' where t1.relationship_type = t2.meaning '
8075: ||' and t2.lookup_type =''MTL_RELATIONSHIP_TYPES'' )'

Line 8105: 'UPDATE msd_st_item_relationships '

8101: --error out records if relationship_type is not valid.
8102: v_sql_stmt := 05;
8103:
8104: lv_sql_Stmt:=
8105: 'UPDATE msd_st_item_relationships '
8106: ||' SET process_flag ='||G_ERROR_FLG||','
8107: ||' error_text = '||''''||lv_message_text||''''
8108: ||' WHERE NVL(RELATIONSHIP_TYPE_ID,'||NULL_VALUE||') = '||NULL_VALUE
8109: ||' AND process_flag ='|| G_IN_PROCESS

Line 8129: pEntityName => 'MSD_ST_ITEM_RELATIONSHIPS',

8125: (ERRBUF => lv_error_text,
8126: RETCODE => lv_return,
8127: pBatchID => lv_batch_id,
8128: pInstanceCode => p_instance_code,
8129: pEntityName => 'MSD_ST_ITEM_RELATIONSHIPS',
8130: pInstanceID => p_instance_id);
8131:
8132: IF NVL(lv_return,0) <> 0 THEN
8133: RAISE ex_logging_err;

Line 8138: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',

8134: END IF;
8135:
8136: -- Set the process flag as Valid and populate instance_id
8137: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
8138: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',
8139: p_instance_id => p_instance_id,
8140: p_instance_code => p_instance_code,
8141: p_process_flag => G_VALID,
8142: p_error_text => lv_error_text,

Line 8153: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',

8149:
8150: -- Inserting all the errored out records into MSC_ERRORS:
8151:
8152: lv_return := MSC_ST_UTIL.LOG_ERROR
8153: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',
8154: p_instance_code => p_instance_code,
8155: p_row => lv_column_names,
8156: p_severity => G_SEV_ERROR,
8157: p_error_text => lv_error_text,