APPS.JTF_TERRITORY_PUB dependencies on JTF_TERR_DATE_LIST

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

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

Line 365: pricing_date jtf_terr_date_list := jtf_terr_date_list(),

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

Line 436: pricing_date jtf_terr_date_list := jtf_terr_date_list(),

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