PACKAGE: APPS.CN_PROCESS_AUDITS_PKG

Source

1 PACKAGE CN_PROCESS_AUDITS_PKG AUTHID CURRENT_USER AS
2 -- $Header: cnrepas.pls 120.0 2005/10/10 07:17:09 apink noship $
3 
4 
5   --
6   -- Procedure Name
7   --   insert_row
8   -- Purpose
9   --   Insert a new record in the cn_process_audits table.
10   -- History
11   --   1/11/94		Devesh Khatu		Created
12   --
13   PROCEDURE insert_row (
14 	X_rowid		IN OUT	NOCOPY ROWID,
15 	X_process_audit_id	IN OUT	NOCOPY cn_process_audits.process_audit_id%TYPE,
16 	X_parent_process_audit_id	cn_process_audits.parent_process_audit_id%TYPE,
17 	X_process_type		cn_process_audits.process_type%TYPE,
18 	X_description		cn_process_audits.description%TYPE,
19 	X_statement_text	cn_process_audits.statement_text%TYPE,
20 	X_execution_code	cn_process_audits.execution_code%TYPE,
21 	X_error_message		cn_process_audits.error_message%TYPE,
22 	X_module_id		cn_process_audits.module_id%TYPE,
23 	X_object_id		cn_process_audits.object_id%TYPE,
24 	X_timestamp_start	cn_process_audits.timestamp_start%TYPE,
25 	X_timestamp_end		cn_process_audits.timestamp_end%TYPE,
26     x_org_id cn_process_audits.org_id%TYPE);
27 
28   --
29   -- Procedure Name
30   --   select_row
31   -- Purpose
32   --   Select a row from the table, given the primary key
33   -- History
34   --   1/11/94		Devesh Khatu		Created
35   --
36   PROCEDURE select_row (
37 	recinfo IN OUT NOCOPY cn_process_audits%ROWTYPE);
38 
39 
40   --
41   -- Procedure Name
42   --   update_row
43   -- Purpose
44   --   Update execution code for cn_process_audits
45   -- History
46   --   1/11/94		Devesh Khatu		Created
47   --
48   PROCEDURE update_row (
49 	X_process_audit_id	cn_process_audits.process_audit_id%TYPE,
50 	X_module_id		cn_process_audits.module_id%TYPE,
51 	X_timestamp_end		cn_process_audits.timestamp_end%TYPE,
52 	X_execution_code	cn_process_audits.execution_code%TYPE,
53 	X_error_message		cn_process_audits.error_message%TYPE);
54 
55 
56 END cn_process_audits_pkg;