528: l_loading_status VARCHAR2 (1000);
529: --clku bug 2376751
530: l_row_id NUMBER;
531: g_last_update_date DATE := SYSDATE;
532: g_last_updated_by NUMBER := fnd_global.user_id;
533: g_creation_date DATE := SYSDATE;
534: g_created_by NUMBER := fnd_global.user_id;
535: g_last_update_login NUMBER := fnd_global.login_id;
536: l_rev_class_name cn_revenue_classes.NAME%TYPE;
530: l_row_id NUMBER;
531: g_last_update_date DATE := SYSDATE;
532: g_last_updated_by NUMBER := fnd_global.user_id;
533: g_creation_date DATE := SYSDATE;
534: g_created_by NUMBER := fnd_global.user_id;
535: g_last_update_login NUMBER := fnd_global.login_id;
536: l_rev_class_name cn_revenue_classes.NAME%TYPE;
537: l_factor_name VARCHAR2(200);
538: l_note_msg VARCHAR2 (2000);
531: g_last_update_date DATE := SYSDATE;
532: g_last_updated_by NUMBER := fnd_global.user_id;
533: g_creation_date DATE := SYSDATE;
534: g_created_by NUMBER := fnd_global.user_id;
535: g_last_update_login NUMBER := fnd_global.login_id;
536: l_rev_class_name cn_revenue_classes.NAME%TYPE;
537: l_factor_name VARCHAR2(200);
538: l_note_msg VARCHAR2 (2000);
539: l_note_id NUMBER;