DBA Data[Home] [Help]

APPS.CN_PROCESS_AUDITS_PKG dependencies on CN_PROCESS_AUDITS

Line 1: PACKAGE CN_PROCESS_AUDITS_PKG AUTHID CURRENT_USER AS

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: --

Line 9: -- Insert a new record in the cn_process_audits table.

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 (

Line 15: X_process_audit_id IN OUT NOCOPY cn_process_audits.process_audit_id%TYPE,

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,

Line 16: X_parent_process_audit_id cn_process_audits.parent_process_audit_id%TYPE,

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,

Line 17: X_process_type cn_process_audits.process_type%TYPE,

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,

Line 18: X_description cn_process_audits.description%TYPE,

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,

Line 19: X_statement_text cn_process_audits.statement_text%TYPE,

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,

Line 20: X_execution_code cn_process_audits.execution_code%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,

Line 21: X_error_message cn_process_audits.error_message%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,

Line 22: X_module_id cn_process_audits.module_id%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);

Line 23: X_object_id cn_process_audits.object_id%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:

Line 24: X_timestamp_start cn_process_audits.timestamp_start%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: --

Line 25: X_timestamp_end cn_process_audits.timestamp_end%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

Line 26: x_org_id cn_process_audits.org_id%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

Line 37: recinfo IN OUT NOCOPY cn_process_audits%ROWTYPE);

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

Line 44: -- Update execution code for cn_process_audits

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 (

Line 49: X_process_audit_id cn_process_audits.process_audit_id%TYPE,

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);

Line 50: X_module_id cn_process_audits.module_id%TYPE,

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:

Line 51: X_timestamp_end cn_process_audits.timestamp_end%TYPE,

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:

Line 52: X_execution_code cn_process_audits.execution_code%TYPE,

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;

Line 53: X_error_message cn_process_audits.error_message%TYPE);

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;

Line 56: END cn_process_audits_pkg;

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;