APPS.HZ_ADDRESS_USAGES_PUB dependencies on HZ_ADDRESS_USAGE_DTLS_PKG

Line 170: hz_address_usage_dtls_pkg.insert_row(

166: SELECT HZ_ADDRESS_USAGES_S.nextval
167: INTO l_usage_dtl_id
168: FROM dual;
169:
170: hz_address_usage_dtls_pkg.insert_row(
171: x_usage_dtl_row_id,
172: l_usage_dtl_id,
173: l_usage_id,
174: p_address_usage_dtls_tbl(i).geography_type,

Line 625: hz_address_usage_dtls_pkg.insert_row(

621: SELECT HZ_ADDRESS_USAGES_S.nextval
622: INTO l_usage_dtl_id
623: FROM dual;
624:
625: hz_address_usage_dtls_pkg.insert_row(
626: x_usage_dtl_row_id,
627: l_usage_dtl_id,
628: p_usage_id,
629: p_address_usage_dtls_tbl(i).geography_type,

Line 820: hz_address_usage_dtls_pkg.delete_row(l_last_usg_dtl_id);

816:
817: -- delete the other usage detail also because it is only
818: -- one left can can not exist without any other usage detail
819: -- Bug 5096570 (Nishant 10-Apr-2006)
820: hz_address_usage_dtls_pkg.delete_row(l_last_usg_dtl_id);
821: hz_address_usages_pkg.delete_row(p_usage_id);
822: -- Set i to LAST, so that it does not check any other geo type
823: -- as there is no use (all are deleted)
824: i := p_address_usage_dtls_tbl.LAST;

Line 842: hz_address_usage_dtls_pkg.delete_row(l_usage_dtl_id);

838:
839: END IF;
840: END;
841:
842: hz_address_usage_dtls_pkg.delete_row(l_usage_dtl_id);
843: END IF;
844: EXIT WHEN i = p_address_usage_dtls_tbl.LAST;
845: i := p_address_usage_dtls_tbl.NEXT(i);
846: END LOOP;

Line 850: hz_address_usage_dtls_pkg.delete_row(i.usage_dtl_id);

846: END LOOP;
847: ELSE
848: FOR i IN c_address_usage_dtls
849: LOOP
850: hz_address_usage_dtls_pkg.delete_row(i.usage_dtl_id);
851: EXIT WHEN c_address_usage_dtls%NOTFOUND;
852: END LOOP;
853: hz_address_usages_pkg.delete_row(p_usage_id);
854: END IF;