[Home] [Help]
PACKAGE: APPS.JL_BR_INSCRIPTION_NUMBER
Source
1 PACKAGE JL_BR_INSCRIPTION_NUMBER AUTHID CURRENT_USER as
2 /* $Header: jlbrsics.pls 115.1 2002/11/14 18:55:21 thwon ship $ */
3
4 /*----------------------------------------------------------------------------*
5 | PUBLIC FUNCTIONS/PROCEDURES |
6 *----------------------------------------------------------------------------*/
7
8 /*----------------------------------------------------------------------------*
9 | PROCEDURE |
10 | validate_inscription_number |
11 | |
12 | DESCRIPTION |
13 | |
14 | PARAMETERS |
15 | INPUT |
16 | p_inscription_type VARCHAR2 -- Inscription Type: CPF = '1' |
17 | CGC = '2' |
18 | Other = '3' |
19 | p_inscription_number VARCHAR2 -- Inscription Number |
20 | p_inscription_branch VARCHAR2 -- Inscription Branch |
21 | p_inscription_digit VARCHAR2 -- Inscription Digit |
22 | |
23 | OUTPUT |
24 | p_errbuf VARCHAR2 -- Error lookup code |
25 | (Lookup type = |
26 | 'JLBR_INSCRIPTION_NUM_ERRORS')|
27 | p_retcode NUMBER -- Return Code: |
28 | 0 = Validation Succeds |
29 | -1 = Validation Fails |
30 | |
31 | HISTORY |
32 | 15-OCT-97 Marcia Toriyama Created |
33 *----------------------------------------------------------------------------*/
34 PROCEDURE validate_inscription_number (
35 p_inscription_type IN VARCHAR2,
36 p_inscription_number IN VARCHAR2,
37 p_inscription_branch IN VARCHAR2,
38 p_inscription_digit IN VARCHAR2,
39 p_errbuf IN OUT NOCOPY VARCHAR2,
40 p_retcode IN OUT NOCOPY NUMBER );
41
42 END JL_BR_INSCRIPTION_NUMBER;