eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DMEXTRACT_PVT dependencies on DBMS_SQL

Line 1479: l_age_list dbms_sql.NUMBER_table;

1475:
1476: l_master_table l_master_table_type;
1477: l_party_list t_number_table;
1478:
1479: l_age_list dbms_sql.NUMBER_table;
1480: l_days_since_last_school_list dbms_sql.NUMBER_table;
1481: l_days_since_last_event_list dbms_sql.NUMBER_table;
1482: l_num_times_tgt_list dbms_sql.NUMBER_table;
1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;

Line 1480: l_days_since_last_school_list dbms_sql.NUMBER_table;

1476: l_master_table l_master_table_type;
1477: l_party_list t_number_table;
1478:
1479: l_age_list dbms_sql.NUMBER_table;
1480: l_days_since_last_school_list dbms_sql.NUMBER_table;
1481: l_days_since_last_event_list dbms_sql.NUMBER_table;
1482: l_num_times_tgt_list dbms_sql.NUMBER_table;
1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
1484: l_times_tgt_month_list dbms_sql.NUMBER_table;

Line 1481: l_days_since_last_event_list dbms_sql.NUMBER_table;

1477: l_party_list t_number_table;
1478:
1479: l_age_list dbms_sql.NUMBER_table;
1480: l_days_since_last_school_list dbms_sql.NUMBER_table;
1481: l_days_since_last_event_list dbms_sql.NUMBER_table;
1482: l_num_times_tgt_list dbms_sql.NUMBER_table;
1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
1484: l_times_tgt_month_list dbms_sql.NUMBER_table;
1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;

Line 1482: l_num_times_tgt_list dbms_sql.NUMBER_table;

1478:
1479: l_age_list dbms_sql.NUMBER_table;
1480: l_days_since_last_school_list dbms_sql.NUMBER_table;
1481: l_days_since_last_event_list dbms_sql.NUMBER_table;
1482: l_num_times_tgt_list dbms_sql.NUMBER_table;
1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
1484: l_times_tgt_month_list dbms_sql.NUMBER_table;
1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;
1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;

Line 1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;

1479: l_age_list dbms_sql.NUMBER_table;
1480: l_days_since_last_school_list dbms_sql.NUMBER_table;
1481: l_days_since_last_event_list dbms_sql.NUMBER_table;
1482: l_num_times_tgt_list dbms_sql.NUMBER_table;
1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
1484: l_times_tgt_month_list dbms_sql.NUMBER_table;
1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;
1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;
1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;

Line 1484: l_times_tgt_month_list dbms_sql.NUMBER_table;

1480: l_days_since_last_school_list dbms_sql.NUMBER_table;
1481: l_days_since_last_event_list dbms_sql.NUMBER_table;
1482: l_num_times_tgt_list dbms_sql.NUMBER_table;
1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
1484: l_times_tgt_month_list dbms_sql.NUMBER_table;
1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;
1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;
1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;
1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;

Line 1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;

1481: l_days_since_last_event_list dbms_sql.NUMBER_table;
1482: l_num_times_tgt_list dbms_sql.NUMBER_table;
1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
1484: l_times_tgt_month_list dbms_sql.NUMBER_table;
1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;
1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;
1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;
1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;

Line 1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;

1482: l_num_times_tgt_list dbms_sql.NUMBER_table;
1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
1484: l_times_tgt_month_list dbms_sql.NUMBER_table;
1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;
1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;
1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;
1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;
1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;

Line 1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;

1483: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
1484: l_times_tgt_month_list dbms_sql.NUMBER_table;
1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;
1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;
1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;
1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;
1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;

Line 1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;

1484: l_times_tgt_month_list dbms_sql.NUMBER_table;
1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;
1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;
1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;
1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;
1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;

Line 1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;

1485: l_times_tgt_3months_list dbms_sql.NUMBER_table;
1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;
1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;
1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;
1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;

Line 1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;

1486: l_times_tgt_6months_list dbms_sql.NUMBER_table;
1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;
1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;
1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;
1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;

Line 1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;

1487: l_times_tgt_12months_list dbms_sql.NUMBER_table;
1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;
1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;
1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;
1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;

Line 1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;

1488: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;
1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;
1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;
1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;

Line 1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;

1489: l_avg_disc_offered_list dbms_sql.NUMBER_table;
1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;
1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;
1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;

Line 1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;

1490: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;
1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;
1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
1498: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;

Line 1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;

1491: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;
1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;
1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
1498: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
1499: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;

Line 1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;

1492: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;
1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;
1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
1498: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
1499: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
1500: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;

Line 1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;

1493: l_days_since_acct_term_list dbms_sql.NUMBER_table;
1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;
1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
1498: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
1499: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
1500: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
1501: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;

Line 1498: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;

1494: l_days_since_acct_act_list dbms_sql.NUMBER_table;
1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
1498: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
1499: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
1500: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
1501: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;
1502:

Line 1499: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;

1495: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
1498: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
1499: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
1500: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
1501: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;
1502:
1503: l_count NUMBER := 1;

Line 1500: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;

1496: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
1498: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
1499: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
1500: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
1501: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;
1502:
1503: l_count NUMBER := 1;
1504:

Line 1501: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;

1497: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
1498: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
1499: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
1500: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
1501: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;
1502:
1503: l_count NUMBER := 1;
1504:
1505: l_return_status VARCHAR2(1);

Line 2127: l_all_party_id_list dbms_sql.NUMBER_table;

2123: TYPE t_number_table IS TABLE OF NUMBER(15)
2124: INDEX BY BINARY_INTEGER;
2125:
2126: l_bs_rows NUMBER;
2127: l_all_party_id_list dbms_sql.NUMBER_table;
2128:
2129: l_master_party_id_list t_number_table;
2130: l_master_rec AMS_DM_AGG_STG_ORG_REC_TYPE;
2131: l_master_table l_master_table_type;

Line 2134: l_days_since_last_event_list dbms_sql.NUMBER_table;

2130: l_master_rec AMS_DM_AGG_STG_ORG_REC_TYPE;
2131: l_master_table l_master_table_type;
2132:
2133: l_party_list t_number_table;
2134: l_days_since_last_event_list dbms_sql.NUMBER_table;
2135: l_num_times_tgt_list dbms_sql.NUMBER_table;
2136: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
2137: l_times_tgt_month_list dbms_sql.NUMBER_table;
2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;

Line 2135: l_num_times_tgt_list dbms_sql.NUMBER_table;

2131: l_master_table l_master_table_type;
2132:
2133: l_party_list t_number_table;
2134: l_days_since_last_event_list dbms_sql.NUMBER_table;
2135: l_num_times_tgt_list dbms_sql.NUMBER_table;
2136: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
2137: l_times_tgt_month_list dbms_sql.NUMBER_table;
2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;
2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;

Line 2136: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;

2132:
2133: l_party_list t_number_table;
2134: l_days_since_last_event_list dbms_sql.NUMBER_table;
2135: l_num_times_tgt_list dbms_sql.NUMBER_table;
2136: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
2137: l_times_tgt_month_list dbms_sql.NUMBER_table;
2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;
2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;
2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;

Line 2137: l_times_tgt_month_list dbms_sql.NUMBER_table;

2133: l_party_list t_number_table;
2134: l_days_since_last_event_list dbms_sql.NUMBER_table;
2135: l_num_times_tgt_list dbms_sql.NUMBER_table;
2136: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
2137: l_times_tgt_month_list dbms_sql.NUMBER_table;
2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;
2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;
2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;
2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;

Line 2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;

2134: l_days_since_last_event_list dbms_sql.NUMBER_table;
2135: l_num_times_tgt_list dbms_sql.NUMBER_table;
2136: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
2137: l_times_tgt_month_list dbms_sql.NUMBER_table;
2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;
2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;
2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;
2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;

Line 2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;

2135: l_num_times_tgt_list dbms_sql.NUMBER_table;
2136: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
2137: l_times_tgt_month_list dbms_sql.NUMBER_table;
2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;
2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;
2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;
2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;
2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;

Line 2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;

2136: l_last_targeted_ch_code_list dbms_sql.VARCHAR2_table;
2137: l_times_tgt_month_list dbms_sql.NUMBER_table;
2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;
2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;
2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;
2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;
2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;

Line 2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;

2137: l_times_tgt_month_list dbms_sql.NUMBER_table;
2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;
2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;
2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;
2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;
2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;

Line 2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;

2138: l_times_tgt_3months_list dbms_sql.NUMBER_table;
2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;
2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;
2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;
2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;

Line 2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;

2139: l_times_tgt_6months_list dbms_sql.NUMBER_table;
2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;
2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;
2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;
2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;

Line 2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;

2140: l_times_tgt_12months_list dbms_sql.NUMBER_table;
2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;
2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;
2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;
2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;

Line 2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;

2141: l_days_since_last_tgt_list dbms_sql.NUMBER_table;
2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;
2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;
2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;
2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;

Line 2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;

2142: l_avg_disc_offered_list dbms_sql.NUMBER_table;
2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;
2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;
2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;

Line 2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;

2143: l_num_types_disc_offered_list dbms_sql.NUMBER_table;
2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;
2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;
2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
2151: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;

Line 2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;

2144: l_days_since_first_cnt_list dbms_sql.NUMBER_table;
2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;
2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;
2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
2151: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
2152: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;

Line 2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;

2145: l_days_since_acct_estb_list dbms_sql.NUMBER_table;
2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;
2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;
2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
2151: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
2152: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
2153: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;

Line 2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;

2146: l_days_since_acct_term_list dbms_sql.NUMBER_table;
2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;
2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
2151: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
2152: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
2153: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
2154: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;

Line 2151: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;

2147: l_days_since_acct_act_list dbms_sql.NUMBER_table;
2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
2151: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
2152: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
2153: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
2154: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;
2155:

Line 2152: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;

2148: l_num_times_tgt_email_list dbms_sql.NUMBER_table;
2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
2151: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
2152: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
2153: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
2154: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;
2155:
2156: l_count NUMBER := 1;

Line 2153: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;

2149: l_num_times_tgt_telemkt_list dbms_sql.NUMBER_table;
2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
2151: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
2152: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
2153: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
2154: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;
2155:
2156: l_count NUMBER := 1;
2157: BEGIN

Line 2154: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;

2150: l_num_times_tgt_direct_list dbms_sql.NUMBER_table;
2151: l_num_tgt_by_offr_typ1_list dbms_sql.NUMBER_table;
2152: l_num_tgt_by_offr_typ2_list dbms_sql.NUMBER_table;
2153: l_num_tgt_by_offr_typ3_list dbms_sql.NUMBER_table;
2154: l_num_tgt_by_offr_typ4_list dbms_sql.NUMBER_table;
2155:
2156: l_count NUMBER := 1;
2157: BEGIN
2158: --------------------- initialize -----------------------