1094: l_count NUMBER := 0;
1095: l_min_id NUMBER := 0;
1096: l_max_id NUMBER := 0;
1097: l_debug BOOLEAN := false;
1098: l_last_updated_by NUMBER := fnd_global.user_id;
1099: l_last_update_login NUMBER := fnd_global.conc_login_id;
1100: G_BATCH_SIZE NUMBER ;
1101: l_lead_flag VARCHAR2(1);
1102: l_opp_flag VARCHAR2(1);
1095: l_min_id NUMBER := 0;
1096: l_max_id NUMBER := 0;
1097: l_debug BOOLEAN := false;
1098: l_last_updated_by NUMBER := fnd_global.user_id;
1099: l_last_update_login NUMBER := fnd_global.conc_login_id;
1100: G_BATCH_SIZE NUMBER ;
1101: l_lead_flag VARCHAR2(1);
1102: l_opp_flag VARCHAR2(1);
1103: l_status BOOLEAN;
1568: l_count NUMBER := 0;
1569: l_min_id NUMBER := 0;
1570: l_max_id NUMBER := 0;
1571: l_debug BOOLEAN := false;
1572: l_last_updated_by NUMBER:= fnd_global.user_id;
1573: l_last_update_login NUMBER:= fnd_global.conc_login_id;
1574: G_BATCH_SIZE NUMBER := 10000;
1575: l_lead_flag VARCHAR2(1);
1576: l_status BOOLEAN;
1569: l_min_id NUMBER := 0;
1570: l_max_id NUMBER := 0;
1571: l_debug BOOLEAN := false;
1572: l_last_updated_by NUMBER:= fnd_global.user_id;
1573: l_last_update_login NUMBER:= fnd_global.conc_login_id;
1574: G_BATCH_SIZE NUMBER := 10000;
1575: l_lead_flag VARCHAR2(1);
1576: l_status BOOLEAN;
1577:
2021: l_count NUMBER := 0;
2022: l_min_id NUMBER := 0;
2023: l_max_id NUMBER := 0;
2024: l_debug BOOLEAN := false;
2025: l_last_updated_by NUMBER:= fnd_global.user_id;
2026: l_last_update_login NUMBER:= fnd_global.conc_login_id;
2027: G_BATCH_SIZE NUMBER := 10000;
2028: l_opp_flag VARCHAR2(1);
2029: l_status BOOLEAN;
2022: l_min_id NUMBER := 0;
2023: l_max_id NUMBER := 0;
2024: l_debug BOOLEAN := false;
2025: l_last_updated_by NUMBER:= fnd_global.user_id;
2026: l_last_update_login NUMBER:= fnd_global.conc_login_id;
2027: G_BATCH_SIZE NUMBER := 10000;
2028: l_opp_flag VARCHAR2(1);
2029: l_status BOOLEAN;
2030: