APPS.PNT_COMP_SITE_PKG dependencies on PN_COMPANY_SITES_ALL

Line 30: FROM pn_company_sites_all cs

26: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.check_unique_company_role (+)');
27:
28: SELECT count(1)
29: INTO dummy
30: FROM pn_company_sites_all cs
31: WHERE cs.company_id = p_company_id
32: AND cs.lease_role_type = p_lease_role_type
33: AND ((p_company_site_id is null) or cs.company_site_id <> p_company_site_id )
34: AND org_id = p_org_id;

Line 164: FROM pn_company_sites_all

160: x_org_id NUMBER
161: ) IS
162: CURSOR C IS
163: SELECT rowid
164: FROM pn_company_sites_all
165: WHERE company_site_id = x_company_site_id;
166:
167: CURSOR org_cur IS
168: SELECT org_id

Line 251: INSERT INTO pn_company_sites_all (

247: SELECT pn_company_sites_s.nextval
248: INTO x_company_site_id
249: FROM dual;
250:
251: INSERT INTO pn_company_sites_all (
252: company_site_id,
253: last_update_date,
254: last_updated_by,
255: creation_date,

Line 397: UPDATE pn_company_sites_all

393: BEGIN
394:
395: PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.update_row (+)');
396:
397: UPDATE pn_company_sites_all
398: SET
399: last_update_date = x_last_update_date,
400: last_updated_by = x_last_updated_by,
401: last_update_login = x_last_update_login,

Line 549: FROM pn_company_sites_all

545: x_addr_attribute15 VARCHAR2
546: ) IS
547: CURSOR C IS
548: SELECT *
549: FROM pn_company_sites_all
550: WHERE rowid = x_rowid
551: FOR update of company_site_id NOWAIT;
552:
553: Recinfo C%ROWTYPE;