1 PACKAGE JL_BR_SPED_PUB AUTHID CURRENT_USER AS
2 /* $Header: jlspedps.pls 120.0.12010000.2 2008/11/13 08:01:49 pakumare noship $ */
3
4 -- UPDATE_ATTRIBUTES Procedure - To update the attributes
5
6 PROCEDURE UPDATE_ATTRIBUTES (
7 P_API_VERSION IN NUMBER DEFAULT 1.0,
8 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9 P_CUSTOMER_TRX_ID IN NUMBER,
10 P_ELECT_INV_WEB_ADDRESS IN VARCHAR2,
11 P_ELECT_INV_STATUS IN VARCHAR2,
12 P_ELECT_INV_ACCESS_KEY IN VARCHAR2,
13 P_ELECT_INV_PROTOCOL IN VARCHAR2,
14 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
15 X_MSG_DATA OUT NOCOPY VARCHAR2);
16
17 -- INSERT_LOG Procedure - To insert the log
18
19 PROCEDURE INSERT_LOG (
20 P_API_VERSION IN NUMBER DEFAULT 1.0,
21 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 P_CUSTOMER_TRX_ID IN NUMBER,
23 P_OCCURRENCE_DATE IN DATE,
24 P_ELECT_INV_STATUS IN VARCHAR2,
25 P_MESSAGE_TEXT IN VARCHAR2,
26 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
27 X_MSG_DATA OUT NOCOPY VARCHAR2);
28
29
30 -- GET_IBGE_CODES Procedure - To retrieve IBGE code for a given Location
31
32 PROCEDURE GET_IBGE_CODES (
33 P_API_VERSION IN NUMBER DEFAULT 1.0,
34 P_LOCATION_ID IN NUMBER ,
35 X_STATE_CODE OUT NOCOPY VARCHAR2,
36 X_CITY_CODE OUT NOCOPY VARCHAR2,
37 X_CENTRAL_BANK_CODE OUT NOCOPY VARCHAR2,
38 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
39 X_MSG_DATA OUT NOCOPY VARCHAR2);
40
41
42 END JL_BR_SPED_PUB;