APPS.JTF_TERRITORY_PUB dependencies on JTF_TERR_DATE_LIST

Line 81: CREATE TYPE jtf_terr_date_list IS VARRAY(1000000) OF DATE;

77: ** on the database as a workaround for:
78: ** If type created internally with procedure PL/SQL error raised
79: ** PLS-00457: in USING clause expressions have to be of SQL types
80: ** They are listed here for informational purposes
81: CREATE TYPE jtf_terr_date_list IS VARRAY(1000000) OF DATE;
82: CREATE TYPE jtf_terr_number_list IS VARRAY(1000000) OF NUMBER;
83: CREATE TYPE jtf_terr_char_1list IS VARRAY(1000000) OF VARCHAR2(1);
84: CREATE TYPE jtf_terr_char_360list IS VARRAY(1000000) OF VARCHAR2(15);
85: CREATE TYPE jtf_terr_char_360list IS VARRAY(1000000) OF VARCHAR2(25);

Line 367: pricing_date jtf_terr_date_list := jtf_terr_date_list(),

363: party_relationship_id jtf_terr_number_list := jtf_terr_number_list(),
364: sic_code jtf_terr_char_360list := jtf_terr_char_360list(),
365: budget_amount jtf_terr_number_list := jtf_terr_number_list(),
366: currency_code jtf_terr_char_360list := jtf_terr_char_360list(),
367: pricing_date jtf_terr_date_list := jtf_terr_date_list(),
368: source_promotion_id jtf_terr_number_list := jtf_terr_number_list(),
369: inventory_item_id jtf_terr_number_list := jtf_terr_number_list(),
370: lead_interest_type_id jtf_terr_number_list := jtf_terr_number_list(),
371: lead_primary_interest_id jtf_terr_number_list := jtf_terr_number_list(),

Line 438: pricing_date jtf_terr_date_list := jtf_terr_date_list(),

434: sic_code jtf_terr_char_360list := jtf_terr_char_360list(),
435: target_segment_current jtf_terr_char_360list := jtf_terr_char_360list(),
436: total_amount jtf_terr_number_list := jtf_terr_number_list (),
437: currency_code jtf_terr_char_360list := jtf_terr_char_360list(),
438: pricing_date jtf_terr_date_list := jtf_terr_date_list(),
439: channel_code jtf_terr_char_360list := jtf_terr_char_360list(),
440: inventory_item_id jtf_terr_number_list := jtf_terr_number_list (),
441: opp_interest_type_id jtf_terr_number_list := jtf_terr_number_list (),
442: opp_primary_interest_id jtf_terr_number_list := jtf_terr_number_list (),