APPS.MSC_CL_PRE_PROCESS dependencies on MSD_ST_LEVEL_VALUES

Line 6162: -- Call the procedure to insert categories into msd_st_level_values

6158:
6159: COMMIT;
6160:
6161: -- ODP change
6162: -- Call the procedure to insert categories into msd_st_level_values
6163: IF(v_install_msd) THEN
6164:
6165: lv_sql_stmt := ' DECLARE errbuf varchar2(250);'
6166: ||' retcode number ;'

Line 7606: -- Call the procedure to insert all org/customer into the msd_st_level_values

7602: END IF;
7603: COMMIT;
7604:
7605: -- ODP change
7606: -- Call the procedure to insert all org/customer into the msd_st_level_values
7607: IF(v_install_msd) THEN
7608: lv_sql_stmt := 'DECLARE errbuf varchar2(250);'
7609: ||' retcode number;'
7610: ||' BEGIN '

Line 8519: -- Call the procedure to insert site into the msd_st_level_values

8515: COMMIT;
8516:
8517:
8518: -- ODP change
8519: -- Call the procedure to insert site into the msd_st_level_values
8520: IF(v_install_msd) THEN
8521: lv_sql_stmt := ' DECLARE errbuf varchar2(250);'
8522: ||' retcode number ;'
8523: ||' BEGIN '

Line 24216: -- Call the procedure to insert all items into the msd_st_level_values

24212: CLOSE c_lock;
24213: END IF;
24214:
24215: -- ODP change
24216: -- Call the procedure to insert all items into the msd_st_level_values
24217: IF(v_install_msd) THEN
24218: lv_sql_stmt := ' DECLARE errbuf varchar2(250);'
24219: ||' retcode number ;'
24220: ||' BEGIN '

Line 27572: -- Call the procedure to insert categories into msd_st_level_values

27568: END IF;
27569: COMMIT;
27570:
27571: -- ODP change
27572: -- Call the procedure to insert categories into msd_st_level_values
27573: IF(v_install_msd) THEN
27574: lv_sql_stmt := ' DECLARE errbuf varchar2(250);'
27575: ||' retcode number ;'
27576: || ' BEGIN '

Line 54836: 'UPDATE msd_st_level_values mlv1'

54832: END IF;
54833:
54834: v_sql_stmt := 01;
54835: lv_sql_stmt :=
54836: 'UPDATE msd_st_level_values mlv1'
54837: ||' SET process_flag = '||G_ERROR_FLG||','
54838: ||' error_text = '||''''||lv_message_text||''''
54839: ||' WHERE EXISTS ( SELECT 1 FROM msd_st_level_values mlv2'
54840: ||' WHERE mlv1.level_name = mlv2.level_name'

Line 54839: ||' WHERE EXISTS ( SELECT 1 FROM msd_st_level_values mlv2'

54835: lv_sql_stmt :=
54836: 'UPDATE msd_st_level_values mlv1'
54837: ||' SET process_flag = '||G_ERROR_FLG||','
54838: ||' error_text = '||''''||lv_message_text||''''
54839: ||' WHERE EXISTS ( SELECT 1 FROM msd_st_level_values mlv2'
54840: ||' WHERE mlv1.level_name = mlv2.level_name'
54841: ||' AND mlv1.level_value = mlv2.level_value'
54842: ||' AND mlv1.process_flag = mlv2.process_flag'
54843: ||' AND mlv1.sr_instance_code = mlv2.sr_instance_code'

Line 56134: lv_count:= SET_IN_PROCESS (p_table_name => 'MSD_ST_LEVEL_VALUES',p_instance_id_col => 'INSTANCE',p_company_name_col => FALSE, p_erp_enabled => 'Y');

56130: End IF;
56131: END IF;
56132:
56133: IF v_level_value_enabled = SYS_YES THEN
56134: lv_count:= SET_IN_PROCESS (p_table_name => 'MSD_ST_LEVEL_VALUES',p_instance_id_col => 'INSTANCE',p_company_name_col => FALSE, p_erp_enabled => 'Y');
56135: lv_count:= SET_IN_PROCESS (p_table_name => 'MSD_ST_LEVEL_ORG_ASSCNS',p_instance_id_col => 'INSTANCE',p_company_name_col => FALSE, p_erp_enabled => 'Y');
56136: lv_count:= SET_IN_PROCESS (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',p_instance_id_col => 'INSTANCE_ID',p_company_name_col => FALSE, p_erp_enabled => 'Y');
56137: /*
56138: IF lv_count = 0 Then

Line 59277: cursor c2 is SELECT rowid FROM msd_st_level_values

59273: lv_batch_id PLS_INTEGER;
59274: lv_batch_start PLS_INTEGER;
59275: lv_batch_last PLS_INTEGER;
59276:
59277: cursor c2 is SELECT rowid FROM msd_st_level_values
59278: WHERE PROCESS_FLAG IN(G_IN_PROCESS,G_ERROR_FLG)
59279: AND NVL(batch_id,NULL_VALUE) = NULL_VALUE
59280: AND sr_instance_code = v_instance_code;
59281:

Line 59305: UPDATE msd_st_level_values

59301:
59302: lv_batch_last := lv_batch_id;
59303:
59304: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
59305: UPDATE msd_st_level_values
59306: SET batch_id = lb_batch(j)
59307: WHERE rowid = lb_rowid(j);
59308:
59309: commit;