[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| PROCEDURE : INSERT_row
| DESCRIPTION : INSERTs a row in pn_addresses_all
| SCOPE : PUBLIC
| INVOKED FROM :
| ARGUMENTS : IN : 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
| 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,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
| AND x_ORg_id
| OUT : NONE
| RETURNS : NONE
| HISTORY :
| 28-APR-05 : piagrawa o ModIFied the SELECT statements to retrieve VALUES
| FROM pn_addresses_all instead of pn_addresses
+=============================================================================*/
PROCEDURE INSERT_row ( x_address_id IN OUT NOCOPY 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_lASt_UPDATE_date DATE,
x_lASt_UPDATEd_by NUMBER,
x_creation_date DATE,
x_created_by NUMBER,
x_lASt_UPDATE_login NUMBER,
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_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 ADDR IS
SELECT address_id
FROM pn_addresses_all
WHERE address_id = x_address_id;
SELECT pn_addresses_s.nextval
INTO x_address_id
FROM dual;
INSERT INTO pn_addresses_all ( address_id,
address_line1,
address_line2,
address_line3,
address_line4,
county,
city,
state,
province,
zip_code,
country,
territORy_id,
lASt_UPDATE_date,
lASt_UPDATEd_by,
creation_date,
created_by,
lASt_UPDATE_login,
attribute_categORy,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
addr_attribute_categORy,
addr_attribute1,
addr_attribute2,
addr_attribute3,
addr_attribute4,
addr_attribute5,
addr_attribute6,
addr_attribute7,
addr_attribute8,
addr_attribute9,
addr_attribute10,
addr_attribute11,
addr_attribute12,
addr_attribute13,
addr_attribute14,
addr_attribute15,
ORg_id
)
VALUES
(
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,
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,
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,
x_ORg_id
);
END INSERT_row;
PROCEDURE UPDATE_row ( 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_lASt_UPDATE_date DATE,
x_lASt_UPDATEd_by NUMBER,
x_lASt_UPDATE_login NUMBER,
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_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
UPDATE pn_addresses_all /* hrodda_MOAC - changed to tablename_all*/
SET
address_line1 = x_address_line1,
address_line2 = x_address_line2,
address_line3 = x_address_line3,
address_line4 = x_address_line4,
county = x_county,
city = x_city,
state = x_state,
province = x_province,
zip_code = x_zip_code,
country = x_country,
territORy_id = x_territORy_id,
lASt_UPDATE_date = x_lASt_UPDATE_date,
lASt_UPDATEd_by = x_lASt_UPDATEd_by,
lASt_UPDATE_login = x_lASt_UPDATE_login,
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,
addr_attribute_categORy = x_addr_attribute_categORy,
addr_attribute1 = x_addr_attribute1,
addr_attribute2 = x_addr_attribute2,
addr_attribute3 = x_addr_attribute3,
addr_attribute4 = x_addr_attribute4,
addr_attribute5 = x_addr_attribute5,
addr_attribute6 = x_addr_attribute6,
addr_attribute7 = x_addr_attribute7,
addr_attribute8 = x_addr_attribute8,
addr_attribute9 = x_addr_attribute9,
addr_attribute10 = x_addr_attribute10,
addr_attribute11 = x_addr_attribute11,
addr_attribute12 = x_addr_attribute12,
addr_attribute13 = x_addr_attribute13,
addr_attribute14 = x_addr_attribute14,
addr_attribute15 = x_addr_attribute15
WHERE address_id = x_address_id;
END UPDATE_row;
SELECT *
FROM pn_addresses_all /* hrodda_MOAC -changed to tablename_All*/
WHERE address_id = x_address_id
FOR UPDATE of address_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');