[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(1)
INTO dummy
FROM pn_company_sites_all cs
WHERE cs.company_id = p_company_id
AND cs.lease_role_type = p_lease_role_type
AND ((p_company_site_id is null) or cs.company_site_id <> p_company_site_id )
AND org_id = p_org_id;
SELECT descr.descriptive_flex_context_code
FROM fnd_lookups f
,fnd_descr_flex_contexts descr
WHERE f.lookup_type = 'ADDRESS_STYLE'
AND descr.descriptive_flexfield_name = 'Flexible Address Format'
AND descr.application_ID = 240
AND descr.descriptive_flex_context_code = f.lookup_code
AND f.lookup_code = p_addr_code;
PROCEDURE insert_row ( x_rowid IN OUT NOCOPY VARCHAR2,
x_company_site_id IN OUT NOCOPY NUMBER,
x_last_update_date DATE,
x_last_updated_by NUMBER,
x_creation_date DATE,
x_created_by NUMBER,
x_last_update_login NUMBER,
x_name VARCHAR2,
x_company_id NUMBER,
x_enabled_flag VARCHAR2,
x_company_site_code VARCHAR2,
x_address_id IN OUT NOCOPY NUMBER,
x_lease_role_type VARCHAR2,
x_attribute_category VARCHAR2,
x_attribute1 VARCHAR2,
x_attribute2 VARCHAR2,
x_attribute3 VARCHAR2,
x_attribute4 VARCHAR2,
x_attribute5 VARCHAR2,
x_attribute6 VARCHAR2,
x_attribute7 VARCHAR2,
x_attribute8 VARCHAR2,
x_attribute9 VARCHAR2,
x_attribute10 VARCHAR2,
x_attribute11 VARCHAR2,
x_attribute12 VARCHAR2,
x_attribute13 VARCHAR2,
x_attribute14 VARCHAR2,
x_attribute15 VARCHAR2,
x_address_line1 VARCHAR2,
x_address_line2 VARCHAR2,
x_address_line3 VARCHAR2,
x_address_line4 VARCHAR2,
x_county VARCHAR2,
x_city VARCHAR2,
x_state VARCHAR2,
x_province VARCHAR2,
x_zip_code VARCHAR2,
x_country VARCHAR2,
x_territory_id NUMBER,
x_addr_last_update_date DATE,
x_addr_last_updated_by NUMBER,
x_addr_creation_date DATE,
x_addr_created_by NUMBER,
x_addr_last_update_login NUMBER,
x_addr_attribute_category VARCHAR2,
x_addr_attribute1 VARCHAR2,
x_addr_attribute2 VARCHAR2,
x_addr_attribute3 VARCHAR2,
x_addr_attribute4 VARCHAR2,
x_addr_attribute5 VARCHAR2,
x_addr_attribute6 VARCHAR2,
x_addr_attribute7 VARCHAR2,
x_addr_attribute8 VARCHAR2,
x_addr_attribute9 VARCHAR2,
x_addr_attribute10 VARCHAR2,
x_addr_attribute11 VARCHAR2,
x_addr_attribute12 VARCHAR2,
x_addr_attribute13 VARCHAR2,
x_addr_attribute14 VARCHAR2,
x_addr_attribute15 VARCHAR2,
x_org_id NUMBER
) IS
CURSOR C IS
SELECT rowid
FROM pn_company_sites_all
WHERE company_site_id = x_company_site_id;
SELECT org_id
FROM pn_companies_all
WHERE company_id = x_company_id;
PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.insert_row (+)');
PNT_ADDR_PKG.insert_row ( x_address_id,
x_address_line1,
x_address_line2,
x_address_line3,
x_address_line4,
x_county,
x_city,
x_state,
x_province,
x_zip_code,
x_country,
x_territory_id,
x_last_update_date,
x_last_updated_by,
x_creation_date,
x_created_by,
x_last_update_login,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
x_addr_attribute_category,
x_addr_attribute1,
x_addr_attribute2,
x_addr_attribute3,
x_addr_attribute4,
x_addr_attribute5,
x_addr_attribute6,
x_addr_attribute7,
x_addr_attribute8,
x_addr_attribute9,
x_addr_attribute10,
x_addr_attribute11,
x_addr_attribute12,
x_addr_attribute13,
x_addr_attribute14,
x_addr_attribute15,
l_org_id
);
SELECT pn_company_sites_s.nextval
INTO x_company_site_id
FROM dual;
INSERT INTO pn_company_sites_all (
company_site_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
name,
company_id,
enabled_flag,
company_site_code,
address_id,
lease_role_type,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
org_id
)
VALUES
(
x_company_site_id,
x_last_update_date,
x_last_updated_by,
x_creation_date,
x_created_by,
x_last_update_login,
x_name,
x_company_id,
x_enabled_flag,
x_company_site_code,
x_address_id,
x_lease_role_type,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
l_org_id
);
PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.insert_row (-)');
END insert_row;
PROCEDURE update_row ( x_rowid VARCHAR2,
x_company_id NUMBER,
x_company_site_id NUMBER,
x_last_update_date DATE,
x_last_updated_by NUMBER,
x_last_update_login NUMBER,
x_name VARCHAR2,
x_enabled_flag VARCHAR2,
x_company_site_code VARCHAR2,
x_lease_role_type VARCHAR2,
x_attribute_category VARCHAR2,
x_attribute1 VARCHAR2,
x_attribute2 VARCHAR2,
x_attribute3 VARCHAR2,
x_attribute4 VARCHAR2,
x_attribute5 VARCHAR2,
x_attribute6 VARCHAR2,
x_attribute7 VARCHAR2,
x_attribute8 VARCHAR2,
x_attribute9 VARCHAR2,
x_attribute10 VARCHAR2,
x_attribute11 VARCHAR2,
x_attribute12 VARCHAR2,
x_attribute13 VARCHAR2,
x_attribute14 VARCHAR2,
x_attribute15 VARCHAR2,
x_address_id NUMBER,
x_address_line1 VARCHAR2,
x_address_line2 VARCHAR2,
x_address_line3 VARCHAR2,
x_address_line4 VARCHAR2,
x_county VARCHAR2,
x_city VARCHAR2,
x_state VARCHAR2,
x_province VARCHAR2,
x_zip_code VARCHAR2,
x_country VARCHAR2,
x_territory_id NUMBER,
x_addr_last_update_date DATE,
x_addr_last_updated_by NUMBER,
x_addr_last_update_login NUMBER,
x_addr_attribute_category VARCHAR2,
x_addr_attribute1 VARCHAR2,
x_addr_attribute2 VARCHAR2,
x_addr_attribute3 VARCHAR2,
x_addr_attribute4 VARCHAR2,
x_addr_attribute5 VARCHAR2,
x_addr_attribute6 VARCHAR2,
x_addr_attribute7 VARCHAR2,
x_addr_attribute8 VARCHAR2,
x_addr_attribute9 VARCHAR2,
x_addr_attribute10 VARCHAR2,
x_addr_attribute11 VARCHAR2,
x_addr_attribute12 VARCHAR2,
x_addr_attribute13 VARCHAR2,
x_addr_attribute14 VARCHAR2,
x_addr_attribute15 VARCHAR2
) IS
BEGIN
PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.update_row (+)');
UPDATE pn_company_sites_all
SET
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login,
name = x_name,
enabled_flag = x_enabled_flag,
company_site_code = x_company_site_code,
lease_role_type = x_lease_role_type,
attribute_category = x_attribute_category,
attribute1 = x_attribute1,
attribute2 = x_attribute2,
attribute3 = x_attribute3,
attribute4 = x_attribute4,
attribute5 = x_attribute5,
attribute6 = x_attribute6,
attribute7 = x_attribute7,
attribute8 = x_attribute8,
attribute9 = x_attribute9,
attribute10 = x_attribute10,
attribute11 = x_attribute11,
attribute12 = x_attribute12,
attribute13 = x_attribute13,
attribute14 = x_attribute14,
attribute15 = x_attribute15
WHERE company_site_id = x_company_site_id
AND rowid = x_rowid;
PNT_ADDR_PKG.update_row ( x_address_id,
x_address_line1,
x_address_line2,
x_address_line3,
x_address_line4,
x_county,
x_city,
x_state,
x_province,
x_zip_code,
x_country,
x_territory_id,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
x_addr_attribute_category,
x_addr_attribute1,
x_addr_attribute2,
x_addr_attribute3,
x_addr_attribute4,
x_addr_attribute5,
x_addr_attribute6,
x_addr_attribute7,
x_addr_attribute8,
x_addr_attribute9,
x_addr_attribute10,
x_addr_attribute11,
x_addr_attribute12,
x_addr_attribute13,
x_addr_attribute14,
x_addr_attribute15
);
PNP_DEBUG_PKG.debug ('PNT_COMP_SITE_PKG.update_row (-)');
END update_row;
SELECT *
FROM pn_company_sites_all
WHERE rowid = x_rowid
FOR update of company_site_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');