APPS.IGP_VW_PORT_ACTIVITIES_PKG dependencies on IGP_VW_PORT_ACTIVITIES

Line 1: PACKAGE BODY IGP_VW_PORT_ACTIVITIES_PKG AS

1: PACKAGE BODY IGP_VW_PORT_ACTIVITIES_PKG AS
2: /* $Header: IGSPVWCB.pls 120.0 2005/06/01 15:02:16 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGP_VW_PORT_ACTIVITIES%ROWTYPE;

Line 5: old_references IGP_VW_PORT_ACTIVITIES%ROWTYPE;

1: PACKAGE BODY IGP_VW_PORT_ACTIVITIES_PKG AS
2: /* $Header: IGSPVWCB.pls 120.0 2005/06/01 15:02:16 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGP_VW_PORT_ACTIVITIES%ROWTYPE;
6: new_references IGP_VW_PORT_ACTIVITIES%ROWTYPE;
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGP_VW_PORT_ACTIVITIES_PKG';
9: apps_exception EXCEPTION ;

Line 6: new_references IGP_VW_PORT_ACTIVITIES%ROWTYPE;

2: /* $Header: IGSPVWCB.pls 120.0 2005/06/01 15:02:16 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGP_VW_PORT_ACTIVITIES%ROWTYPE;
6: new_references IGP_VW_PORT_ACTIVITIES%ROWTYPE;
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGP_VW_PORT_ACTIVITIES_PKG';
9: apps_exception EXCEPTION ;
10: PRAGMA EXCEPTION_INIT(apps_exception, -20001);

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGP_VW_PORT_ACTIVITIES_PKG';

4: l_rowid VARCHAR2(25);
5: old_references IGP_VW_PORT_ACTIVITIES%ROWTYPE;
6: new_references IGP_VW_PORT_ACTIVITIES%ROWTYPE;
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGP_VW_PORT_ACTIVITIES_PKG';
9: apps_exception EXCEPTION ;
10: PRAGMA EXCEPTION_INIT(apps_exception, -20001);
11:
12: PROCEDURE set_column_values (

Line 42: FROM IGP_VW_PORT_ACTIVITIES

38: */
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM IGP_VW_PORT_ACTIVITIES
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 309: fnd_message.set_token ('ROUTINE', 'IGP_VW_PORT_ACTIVITIES_PKG.INSERT_ROW');

305: x_last_update_login := -1;
306: END IF;
307: ELSE
308: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
309: fnd_message.set_token ('ROUTINE', 'IGP_VW_PORT_ACTIVITIES_PKG.INSERT_ROW');
310: igs_ge_msg_stack.add;
311: app_exception.raise_exception;
312: END IF;
313:

Line 335: INSERT INTO IGP_VW_PORT_ACTIVITIES (

331: x_last_updated_by => x_last_updated_by,
332: x_last_update_login => x_last_update_login
333: );
334:
335: INSERT INTO IGP_VW_PORT_ACTIVITIES (
336: activity_id,
337: portfolio_id,
338: org_party_id,
339: access_date,

Line 351: IGP_VW_PORT_ACTIVITIES_S.NEXTVAL,

347: last_update_date,
348: last_updated_by,
349: last_update_login
350: ) VALUES (
351: IGP_VW_PORT_ACTIVITIES_S.NEXTVAL,
352: new_references.portfolio_id,
353: new_references.org_party_id,
354: new_references.access_date,
355: new_references.note,

Line 369: END IGP_VW_PORT_ACTIVITIES_pkg;

365: ) RETURNING ROWID, activity_id INTO x_rowid, x_activity_id;
366:
367: END insert_row;
368:
369: END IGP_VW_PORT_ACTIVITIES_pkg;