APPS.PNT_COMP_PKG dependencies on PN_COMPANIES_ALL

Line 35: from pn_companies_all

31: select 1
32: into dummy
33: from dual
34: where not exists ( select 1
35: from pn_companies_all
36: where name = p_company_name
37: and (( p_rowid is null ) or (rowid <> p_rowid))
38: and org_id = p_org_id
39: );

Line 80: FROM pn_companies_all

76: SELECT 1
77: INTO dummy
78: FROM dual
79: WHERE NOT EXISTS ( SELECT 1
80: FROM pn_companies_all
81: WHERE company_number = p_company_number
82: AND (( p_rowid is null ) or (rowid <> p_rowid))
83: AND org_id = p_org_id
84: );

Line 96: | DESCRIPTION : inserts a row in pn_companies_all

92: END check_unique_company_number;
93:
94: /*===========================================================================+
95: | PROCEDURE : insert_row
96: | DESCRIPTION : inserts a row in pn_companies_all
97: | SCOPE : PUBLIC
98: | INVOKED FROM :
99: | ARGUMENTS : IN : x_rowid, x_company_id, x_company_number,
100: | x_last_update_date, x_last_updated_by, x_creation_date

Line 112: | from pn_companies_all instead of pn_companies_all

108: | OUT : NONE
109: | RETURNS : NONE
110: | HISTORY :
111: | 26-APR-05 piagrawa o Modified the select statements to retrieve values
112: | from pn_companies_all instead of pn_companies_all
113: | 28-NOV-05 pikhar o fetched org_id using cursor
114: +===========================================================================*/
115: PROCEDURE insert_row ( x_rowid IN OUT NOCOPY VARCHAR2,
116: x_company_id IN OUT NOCOPY NUMBER,

Line 147: FROM pn_companies_all

143: ) IS
144:
145: CURSOR C is
146: SELECT rowid
147: FROM pn_companies_all
148: WHERE company_id = x_company_id;
149:
150: BEGIN
151:

Line 171: insert into pn_companies_all (

167: from dual;
168:
169: END IF;
170:
171: insert into pn_companies_all (
172: company_id,
173: company_number,
174: last_update_date,
175: last_updated_by,

Line 282: FROM pn_companies_all

278: BEGIN
279:
280: SELECT org_id
281: INTO l_org_id
282: FROM pn_companies_all
283: WHERE company_id = x_company_id;
284:
285: check_unique_company_number ( x_rowid,
286: x_company_number,

Line 289: UPDATE pn_companies_all

285: check_unique_company_number ( x_rowid,
286: x_company_number,
287: l_org_id
288: );
289: UPDATE pn_companies_all
290: SET company_number = x_company_number,
291: last_update_date = x_last_update_date,
292: last_updated_by = x_last_updated_by,
293: last_update_login = x_last_update_login,

Line 353: FROM pn_companies_all

349: x_attribute15 VARCHAR2
350: ) IS
351: CURSOR C IS
352: SELECT *
353: FROM pn_companies_all
354: WHERE rowid = x_rowid
355: FOR UPDATE OF company_id NOWAIT;
356:
357: Recinfo C%ROWTYPE;