APPS.MSC_IMPORT_UTIL dependencies on MSC_ST_ITEM_ATTRIBUTES

Line 7: g_attr_val - List of attribute values for a particular record in msc_st_item_attributes

3:
4: /*=============================================================================
5: Four global Variables
6: g_attr_name - List of attribute names
7: g_attr_val - List of attribute values for a particular record in msc_st_item_attributes
8: g_attr_type - lov type-1:Number 2: Char 6:Date
9: g_sql_stmt - If lov type is 2 then use this sql stmt to get the hidden value
10: =============================================================================*/
11:

Line 720: delete from msc_st_item_attributes where rowid=stg_rec_rowid;

716: msc_util.msc_debug('insert stmt:'||l_insert_stmt);
717: msc_Get_name.execute_dsql(l_insert_stmt);
718: end if;
719:
720: delete from msc_st_item_attributes where rowid=stg_rec_rowid;
721: commit;
722: end update_record_to_db;
723:
724: function sim_set(p_plan_id number) return varchar2 is

Line 971: stg_tbl in varchar2 Default 'MSC_ST_ITEM_ATTRIBUTES'

967: PROCEDURE load_frm_stg_tbl (
968: errbuf OUT NOCOPY VARCHAR2,
969: retcode OUT NOCOPY NUMBER,
970: req_id in number,
971: stg_tbl in varchar2 Default 'MSC_ST_ITEM_ATTRIBUTES'
972: ) is
973:
974: Type imm_stg_tbl is REF CURSOR;
975: c_imm_stg_tbl imm_stg_tbl;

Line 980: select count(*) from msc_st_item_attributes where request_id=l_req_id;

976: l_imm_stg_rec imm_stg_rec;
977:
978:
979: cursor c_imm_stg_rec_count(l_req_id number) is
980: select count(*) from msc_st_item_attributes where request_id=l_req_id;
981:
982: cursor c_max_req_id is
983: select max(request_id) from msc_st_item_attributes;
984:

Line 983: select max(request_id) from msc_st_item_attributes;

979: cursor c_imm_stg_rec_count(l_req_id number) is
980: select count(*) from msc_st_item_attributes where request_id=l_req_id;
981:
982: cursor c_max_req_id is
983: select max(request_id) from msc_st_item_attributes;
984:
985: cursor c_imm_stg(l_req_id number) is
986: select
987: ROWID,

Line 1079: from MSC_ST_ITEM_ATTRIBUTES where request_id=l_req_id;

1075: ROP_SAFETY_STOCK,
1076: COMPUTE_SS,
1077: COMPUTE_EOQ,
1078: ORDER_COST
1079: from MSC_ST_ITEM_ATTRIBUTES where request_id=l_req_id;
1080:
1081:
1082: l_stg_rec_count number;
1083:

Line 1095: if stg_tbl='MSC_ST_ITEM_ATTRIBUTES' then

1091: BEGIN
1092: msc_util.msc_debug('Staging table name:'||stg_tbl);
1093: msc_util.msc_debug('Req Id of File Loader is:'||req_id);
1094:
1095: if stg_tbl='MSC_ST_ITEM_ATTRIBUTES' then
1096: open c_max_req_id;
1097: fetch c_max_req_id into l_req_id;
1098: close c_max_req_id;
1099:

Line 1101: msc_util.msc_debug('No records in staging table MSC_ST_ITEM_ATTRIBUTES');

1097: fetch c_max_req_id into l_req_id;
1098: close c_max_req_id;
1099:
1100: if l_req_id is null then
1101: msc_util.msc_debug('No records in staging table MSC_ST_ITEM_ATTRIBUTES');
1102: return;
1103: end if;
1104:
1105: open c_imm_stg_rec_count(l_req_id);

Line 1112: msc_util.msc_debug('No rows available in MSC_ST_ITEM_ATTRIBUTES');

1108:
1109: msc_util.msc_debug('No. of records in staging table:'||l_stg_rec_count);
1110:
1111: if l_stg_rec_count = 0 then
1112: msc_util.msc_debug('No rows available in MSC_ST_ITEM_ATTRIBUTES');
1113: raise exc_load_fail;
1114: end if;
1115: init; -- This will prepare attribute_names, lov_type, sql_stmt list
1116:

Line 1128: l_sql_stmt := l_sql_stmt||' from msc_st_item_attributes' ;

1124: l_sql_stmt := l_sql_stmt||', ';
1125: i:=i+1;
1126: end loop;
1127:
1128: l_sql_stmt := l_sql_stmt||' from msc_st_item_attributes' ;
1129: --msc_util.msc_debug('l_sql_stmt='||l_sql_stmt);
1130: */
1131:
1132: