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 1139: lv_message_text msc_errors.error_text%TYPE;

1135: lv_error_text VARCHAR2(250);
1136: lv_where_str VARCHAR2(5000);
1137: lv_sql_stmt VARCHAR2(5000);
1138: lv_column_names VARCHAR2(5000); --stores concatenated column names
1139: lv_message_text msc_errors.error_text%TYPE;
1140: lv_batch_id msc_st_supplies.batch_id%TYPE;
1141: ex_logging_err EXCEPTION;
1142:
1143: CURSOR c1(p_batch_id NUMBER) IS

Line 2243: lv_message_text msc_errors.error_text%TYPE;

2239: lv_where_str VARCHAR2(5000);
2240: lv_sql_stmt VARCHAR2(5000);
2241: lv_cursor_stmt VARCHAR2(5000);
2242: lv_batch_id msc_st_demands.batch_id%TYPE;
2243: lv_message_text msc_errors.error_text%TYPE;
2244:
2245: ex_logging_err EXCEPTION;
2246:
2247: CURSOR c1(p_batch_id NUMBER) IS