APPS.PO_AGENTS_PKG dependencies on PO_AGENTS

Line 1: PACKAGE BODY PO_AGENTS_PKG as

1: PACKAGE BODY PO_AGENTS_PKG as
2: /* $Header: POXTIDBB.pls 115.2 2002/11/23 01:22:14 sbull ship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 35: CURSOR C IS SELECT rowid FROM PO_AGENTS

31: X_Attribute14 VARCHAR2,
32: X_Attribute15 VARCHAR2)
33:
34: IS
35: CURSOR C IS SELECT rowid FROM PO_AGENTS
36: WHERE agent_id = X_Agent_Id;
37:
38:
39: BEGIN

Line 42: INSERT INTO PO_AGENTS(

38:
39: BEGIN
40:
41:
42: INSERT INTO PO_AGENTS(
43: Agent_Id,
44: Last_Update_Date,
45: Last_Updated_By,
46: Last_Update_Login,

Line 136: FROM PO_AGENTS

132: X_Attribute15 VARCHAR2)
133: IS
134: CURSOR C IS
135: SELECT *
136: FROM PO_AGENTS
137: WHERE rowid = X_Rowid
138: FOR UPDATE of Agent_Id NOWAIT;
139: Recinfo C%ROWTYPE;
140:

Line 256: UPDATE PO_AGENTS

252: X_Attribute15 VARCHAR2)
253:
254: IS
255: BEGIN
256: UPDATE PO_AGENTS
257: SET agent_id = X_Agent_Id,
258: last_update_date = X_Last_Update_Date,
259: last_updated_by = X_Last_Updated_By,
260: last_update_login = X_Last_Update_Login,

Line 292: DELETE FROM PO_AGENTS

288: END Update_Row;
289:
290: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
291: BEGIN
292: DELETE FROM PO_AGENTS
293: WHERE rowid = X_Rowid;
294:
295: if (SQL%NOTFOUND) then
296: Raise NO_DATA_FOUND;

Line 300: END PO_AGENTS_PKG;

296: Raise NO_DATA_FOUND;
297: end if;
298: END Delete_Row;
299:
300: END PO_AGENTS_PKG;