APPS.MSC_CL_RPO_PRE_PROCESS dependencies on MSC_ERRORS

Line 13: lv_message_text msc_errors.error_text%TYPE;

9: lv_where_str VARCHAR2(5000);
10: lv_sql_stmt VARCHAR2(5000);
11: lv_column_names VARCHAR2(5000);
12: lv_batch_id msc_st_supplies.batch_id%TYPE;
13: lv_message_text msc_errors.error_text%TYPE;
14:
15: ex_logging_err EXCEPTION;
16:
17: CURSOR c1(p_batch_id NUMBER) IS

Line 648: lv_message_text msc_errors.error_text%TYPE;

644: lv_where_str VARCHAR2(5000);
645: lv_sql_stmt VARCHAR2(5000);
646: lv_column_names VARCHAR2(5000);
647: lv_batch_id msc_st_demands.batch_id%TYPE;
648: lv_message_text msc_errors.error_text%TYPE;
649:
650: ex_logging_err EXCEPTION;
651:
652: CURSOR c1(p_batch_id NUMBER) IS

Line 1170: lv_message_text msc_errors.error_text%TYPE;

1166: lv_error_text VARCHAR2(250);
1167: lv_where_str VARCHAR2(5000);
1168: lv_sql_stmt VARCHAR2(5000);
1169: lv_column_names VARCHAR2(5000); --stores concatenated column names
1170: lv_message_text msc_errors.error_text%TYPE;
1171: lv_batch_id msc_st_supplies.batch_id%TYPE;
1172: ex_logging_err EXCEPTION;
1173:
1174: CURSOR c1(p_batch_id NUMBER) IS

Line 2274: lv_message_text msc_errors.error_text%TYPE;

2270: lv_where_str VARCHAR2(5000);
2271: lv_sql_stmt VARCHAR2(5000);
2272: lv_cursor_stmt VARCHAR2(5000);
2273: lv_batch_id msc_st_demands.batch_id%TYPE;
2274: lv_message_text msc_errors.error_text%TYPE;
2275:
2276: ex_logging_err EXCEPTION;
2277:
2278: CURSOR c1(p_batch_id NUMBER) IS