1 PACKAGE OKL_ACCT_SOURCES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPASES.pls 120.2 2005/10/30 04:01:23 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
10
11 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
12 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_ACCT_SOURCES_PUB';
13
14 SUBTYPE asev_rec_type IS Okl_Ase_Pvt.asev_rec_type;
15 SUBTYPE asev_tbl_type IS Okl_Ase_Pvt.asev_tbl_type;
16
17
18 /*============================================================================
19 | |
20 | Procedure : update_acct_src_custom_status |
21 | Description : Procedure to update only the custom status. This will be |
22 | updated once the accounting sources are processed by the |
23 | customer. This will be used at customization. |
24 | Parameters : p_account_source_id - ID of the account sources record |
25 | which requires to be updated. |
26 | p_custom_status - New status to which the account sources |
27 | record to be updated |
28 | History : 07-05-04 santonyr -- Created |
29 | |
30 *============================================================================*/
31
32
33 PROCEDURE update_acct_src_custom_status(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_account_source_id IN NUMBER,
40 p_custom_status IN VARCHAR2);
41
42 END Okl_acct_sources_Pub;