APPS.PNT_ADDR_PKG dependencies on PN_ADDRESSES_ALL

Line 6: | DESCRIPTION : INSERTs a row in pn_addresses_all

2: -- $Header: PNTADDRB.pls 120.2 2005/08/02 06:18:06 appldev ship $
3:
4: /*=============================================================================+
5: | PROCEDURE : INSERT_row
6: | DESCRIPTION : INSERTs a row in pn_addresses_all
7: | SCOPE : PUBLIC
8: | INVOKED FROM :
9: | ARGUMENTS : IN : x_address_id, x_address_line1, x_address_line2,
10: | x_address_line3, x_address_line4, x_county, x_city,

Line 30: | FROM pn_addresses_all instead of pn_addresses

26: | OUT : NONE
27: | RETURNS : NONE
28: | HISTORY :
29: | 28-APR-05 : piagrawa o ModIFied the SELECT statements to retrieve VALUES
30: | FROM pn_addresses_all instead of pn_addresses
31: +=============================================================================*/
32: PROCEDURE INSERT_row ( x_address_id IN OUT NOCOPY NUMBER,
33: x_address_line1 VARCHAR2,
34: x_address_line2 VARCHAR2,

Line 85: FROM pn_addresses_all

81: x_ORg_id NUMBER
82: ) IS
83: CURSOR ADDR IS
84: SELECT address_id
85: FROM pn_addresses_all
86: WHERE address_id = x_address_id;
87:
88: BEGIN
89:

Line 97: INSERT INTO pn_addresses_all ( address_id,

93: SELECT pn_addresses_s.nextval
94: INTO x_address_id
95: FROM dual;
96:
97: INSERT INTO pn_addresses_all ( address_id,
98: address_line1,
99: address_line2,
100: address_line3,
101: address_line4,

Line 269: UPDATE pn_addresses_all /* hrodda_MOAC - changed to tablename_all*/

265: x_addr_attribute15 VARCHAR2
266: ) IS
267: BEGIN
268:
269: UPDATE pn_addresses_all /* hrodda_MOAC - changed to tablename_all*/
270: SET
271: address_line1 = x_address_line1,
272: address_line2 = x_address_line2,
273: address_line3 = x_address_line3,

Line 379: FROM pn_addresses_all /* hrodda_MOAC -changed to tablename_All*/

375: x_addr_attribute15 VARCHAR2
376: ) IS
377: CURSOR ADDR IS
378: SELECT *
379: FROM pn_addresses_all /* hrodda_MOAC -changed to tablename_All*/
380: WHERE address_id = x_address_id
381: FOR UPDATE of address_id NOWAIT;
382:
383: Recinfo ADDR%ROWTYPE;