APPS.ARP_TMP_PKG dependencies on DBMS_SQL

Line 34: l_loc_id_tab DBMS_SQL.NUMBER_TABLE;

30: AND NVL(p_STATE,'XXX') = NVL(state,'XXX')
31: AND NVL(p_PROVINCE,'XXX') = NVL(province,'XXX')
32: AND NVL(p_COUNTY,'XXX') = NVL(county,'XXX');
33:
34: l_loc_id_tab DBMS_SQL.NUMBER_TABLE;
35:
36: l_loc_id NUMBER;
37:
38: psite_rec hz_party_site_v2pub.party_site_rec_type;