1 PACKAGE PO_NOTES_SV AUTHID CURRENT_USER AS
2
3 /* $Header: poxcenh.pls 115.0 99/07/17 02:29:05 porting ship $ */
4
5
6 /* Declare global variables */
7
8 msgbuf varchar2(2000);
9
10 /*===========================================================================
11 FUNCTION NAME: copy_notes
12
13 DESCRIPTION: Copy references from all standard notes under orig_id,
14 orig_column, orig_table to new_id, new_column,
15 new_table.
16
17 Copy One time notes associated with orig_id and
18 rename them with Name_extention and copy a refernece
19
20 PARAMETERS: X_orig_id IN NUMBER,
21 X_orig_column IN VARCHAR2,
22 X_orig_table IN VARCHAR2,
23 X_add_on_title IN VARCHAR2,
24 X_new_id IN NUMBER,
25 X_new_column IN VARCHAR2,
26 X_new_table IN VARCHAR2,
27 X_last_updated_by IN NUMBER
28
29
30 NOTES:
31
32 OPEN ISSUES:
33
34 CLOSED ISSUES:
35
36 CHANGE HISTORY:
37 ===========================================================================*/
38
39 PROCEDURE copy_notes (X_orig_id IN NUMBER,
40 X_orig_column IN VARCHAR2,
41 X_orig_table IN VARCHAR2,
42 X_add_on_title IN VARCHAR2,
43 X_new_id IN NUMBER,
44 X_new_column IN VARCHAR2,
45 X_new_table IN VARCHAR2,
46 X_last_updated_by IN NUMBER,
47 X_last_update_login IN NUMBER);
48
49 END PO_NOTES_SV;
50