APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_CALENDAR_MONTHS

Line 12397: FROM msc_st_calendar_months

12393: lv_column_names VARCHAR2(5000);
12394:
12395: CURSOR c1 IS
12396: SELECT rowid
12397: FROM msc_st_calendar_months
12398: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
12399: AND sr_instance_code = v_instance_code;
12400:
12401:

Line 12427: UPDATE msc_st_calendar_months

12423: CLOSE c1;
12424:
12425: v_sql_stmt := 01;
12426: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
12427: UPDATE msc_st_calendar_months
12428: SET st_transaction_id = msc_st_calendar_months_s.NEXTVAL,
12429: last_update_date = lv_current_date,
12430: last_updated_by = lv_current_user,
12431: creation_date = lv_current_date,

Line 12428: SET st_transaction_id = msc_st_calendar_months_s.NEXTVAL,

12424:
12425: v_sql_stmt := 01;
12426: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
12427: UPDATE msc_st_calendar_months
12428: SET st_transaction_id = msc_st_calendar_months_s.NEXTVAL,
12429: last_update_date = lv_current_date,
12430: last_updated_by = lv_current_user,
12431: creation_date = lv_current_date,
12432: created_by = lv_current_user

Line 12468: 'UPDATE msc_st_calendar_months'

12464: -- Date is not provided.
12465:
12466: v_sql_stmt := 02;
12467: lv_sql_stmt :=
12468: 'UPDATE msc_st_calendar_months'
12469: ||' SET process_flag = '||G_ERROR_FLG||','
12470: ||' error_text = '||''''||lv_message_text||''''
12471: ||' WHERE ( year IS NULL'
12472: ||' OR year_description IS NULL'

Line 12509: 'UPDATE msc_st_calendar_months'

12505: -- All the start date should be less than end date
12506:
12507: v_sql_stmt := 03;
12508: lv_sql_stmt :=
12509: 'UPDATE msc_st_calendar_months'
12510: ||' SET process_flag = '||G_ERROR_FLG||','
12511: ||' error_text = '||''''||lv_message_text||''''
12512: ||' WHERE (year_start_date >= year_end_date'
12513: ||' OR quarter_start_date >= quarter_end_date'

Line 12530: pEntityName => 'MSC_ST_CALENDAR_MONTHS',

12526: (ERRBUF => lv_error_text,
12527: RETCODE => lv_return,
12528: pBatchID => NULL,
12529: pInstanceCode => v_instance_code,
12530: pEntityName => 'MSC_ST_CALENDAR_MONTHS',
12531: pInstanceID => v_instance_id);
12532:
12533: IF NVL(lv_return,0) <> 0 THEN
12534: RAISE ex_logging_err;

Line 12538: (p_table_name => 'MSC_ST_CALENDAR_MONTHS',

12534: RAISE ex_logging_err;
12535: END IF;
12536: -- Set the process flag as Valid and populate instance_id
12537: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
12538: (p_table_name => 'MSC_ST_CALENDAR_MONTHS',
12539: p_instance_id => v_instance_id,
12540: p_instance_code => v_instance_code,
12541: p_process_flag => G_VALID,
12542: p_error_text => lv_error_text,

Line 12552: (p_table_name => 'MSC_ST_CALENDAR_MONTHS',

12548:
12549: -- Inserting all the errored out records into MSC_ERRORS:
12550:
12551: lv_return := MSC_ST_UTIL.LOG_ERROR
12552: (p_table_name => 'MSC_ST_CALENDAR_MONTHS',
12553: p_instance_code => v_instance_code,
12554: p_row => lv_column_names,
12555: p_severity => G_SEV_ERROR,
12556: p_error_text => lv_error_text,

Line 56067: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_MONTHS', p_company_name_col => FALSE);

56063: End IF;
56064: END IF;
56065:
56066: IF v_fiscal_calendar_enabled = SYS_YES THEN
56067: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_MONTHS', p_company_name_col => FALSE);
56068: IF lv_count > 0 Then
56069: prec.fiscal_calendar_flag:= SYS_YES;
56070: End IF;
56071: END IF;