1 PACKAGE ARP_CORRECT_CCID AUTHID CURRENT_USER AS
2 /* $Header: ARCCCIDS.pls 120.1 2004/12/03 01:17:07 orashid noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 /*=======================================================================+
9 | Declare PUBLIC Exceptions
10 +=======================================================================*/
11
12 /*========================================================================
13 | PUBLIC PROCEDURE Correct_Lines_CCID
14 |
15 | DESCRIPTION
16 | This procedure will correct all the specific lines that have been
17 | choosen for correction.
18 |
19 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
20 | Enter a list of all local procedures and functions which
21 | are call this package.
22 |
23 |
24 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
25 | Enter a list of all local procedures and cuntions which
26 | this package calls.
27 |
28 | PARAMETERS
29 | p_distribution_id IN This will be the primary key of
30 | the table we will be updating.
31 | p_old_ccid IN This is the CCID which is invalid and
32 | must be replaced.
33 | p_new_ccid IN This is the CCID that the user has
34 | choosen to replace the invalid CCID
35 | p_category_type IN Type of trx we are processing
36 | p_dist_type IN Distribution Type
37 | p_parent_id IN primary key of parent table
38 | p_source_table IN Code for parent id source table.
39 |
40 | KNOWN ISSUES
41 | Enter business functionality which was de-scoped as part of the
42 | implementation. Ideally this should never be used.
43 |
44 | NOTES
45 | Any interesting aspect of the code in the package body which needs
46 | to be stated.
47 |
48 | MODIFICATION HISTORY
49 | Date Author Description of Changes
50 | 10-Nov-2003 Debbie Sue Jancis Created
51 *=======================================================================*/
52 PROCEDURE Correct_Lines_CCID ( p_distribution_id IN NUMBER,
53 p_old_ccid IN NUMBER,
54 p_new_ccid IN NUMBER,
55 p_category_type IN VARCHAR2,
56 p_dist_type IN VARCHAR2,
57 p_parent_id IN NUMBER,
58 p_source_table IN VARCHAR2);
59
60
61 /*========================================================================
62 | PUBLIC PROCEDURE lock_and_update
63 |
64 | DESCRIPTION
65 | This procedure will take an invalid CCID and lock and update all
66 | rows in the ar_ccid_corrections table.
67 |
68 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
69 | This is called from the form ARXGLCOR.fmb
70 |
71 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
72 |
73 | PARAMETERS
74 | p_old_ccid IN OLD CCID
75 | p_new_ccid_id IN NEW CCID to be replaced.
76 | p_category_type IN Transaction Code
77 | p_dist_type IN Distribution code
78 | p_seq_id IN Submission id generated from sequence
79 |
80 | KNOWN ISSUES
81 | none
82 |
83 |
84 | NOTES
85 |
86 | MODIFICATION HISTORY
87 | Date Author Description of Changes
88 | 17-Nov-2003 Debbie Sue Jancis Created
89 *=======================================================================*/
90 PROCEDURE lock_and_update ( p_old_ccid IN NUMBER,
91 p_new_ccid IN NUMBER,
92 p_category_type IN VARCHAR2,
93 p_dist_type IN VARCHAR2,
94 p_seq_id IN NUMBER);
95
96 /*========================================================================
97 | PUBLIC PROCEDURE Correct_All_Invalid_CCID
98 |
99 | DESCRIPTION
100 | This procedure will take an invalid CCID and do a global replacement
101 | in all tables, with a new Valid CCID in order to enable records
102 | to post.
103 |
104 | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
105 | Enter a list of all local procedures and functions which
106 | are call this package.
107 |
108 |
109 | CALLS PROCEDURES/FUNCTIONS (local to this package body)
110 |
111 | PARAMETERS
112 | p_parameter1 IN Description of usage
113 |
114 | KNOWN ISSUES
115 | Enter business functionality which was de-scoped as part of the
116 | implementation. Ideally this should never be used.
117 |
118 | NOTES
119 | Any interesting aspect of the code in the package body which needs
120 | to be stated.
121 |
122 | MODIFICATION HISTORY
123 | Date Author Description of Changes
124 | 10-Nov-2003 Debbie Sue Jancis Created
125 *=======================================================================*/
126 PROCEDURE Correct_All_Invalid_CCID(p_errbuff OUT NOCOPY VARCHAR2,
127 p_retcode OUT NOCOPY NUMBER,
128 p_submission_id IN number);
129
130 END ARP_CORRECT_CCID;