PACKAGE: APPS.OKL_CASH_APPLN_RULE_PVT

Source

1 PACKAGE OKL_CASH_APPLN_RULE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRCSLS.pls 115.2 2002/12/24 00:07:36 pjgomes noship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   -- Sub type cash application rules header record
7   subtype cauv_rec_type is okl_cau_pvt.cauv_rec_type;
8   subtype cauv_tbl_type is okl_cau_pvt.cauv_tbl_type;
9 
10   -- Sub type cash application rules line record
11   subtype catv_rec_type is okl_cat_pvt.catv_rec_type;
12   subtype catv_tbl_type is okl_cat_pvt.catv_tbl_type;
13 
14   ------------------------------------------------------------------------------
15   -- Global Variables
16   ------------------------------------------------------------------------------
17   G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_CASH_APPLN_RULE_PVT';
18   G_APP_NAME             CONSTANT VARCHAR2(3)   := 'OKL';
19   G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
20   G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLERRM';
21   G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLCODE';
22 
23   ------------------------------------------------------------------------------
24    --Global Exception
25   ------------------------------------------------------------------------------
26    G_EXCEPTION_HALT_VALIDATION	EXCEPTION;
27 
28   PROCEDURE maint_cash_appln_rule(
29      p_api_version              IN NUMBER,
30      p_init_msg_list            IN VARCHAR2 DEFAULT okl_api.G_FALSE,
31      p_catv_tbl                 IN catv_tbl_type,
32      x_catv_tbl                 OUT NOCOPY catv_tbl_type,
33      x_return_status            OUT NOCOPY VARCHAR2,
34      x_msg_count                OUT NOCOPY NUMBER,
35      x_msg_data                 OUT NOCOPY VARCHAR2);
36 
37   --returns stream type allocation info
38   --if p_out_field='SEQ', sequence_number is returned
39   --if p_out_field='SAT', stream_allc_type is returned
40   --if p_out_field='ALL', $sequence_number$stream_allc_type is returned
41   FUNCTION get_strm_typ_allocs(
42      p_cat_id IN NUMBER,
43      p_sty_id IN NUMBER,
44      p_stream_allc_type IN VARCHAR2,
45      p_out_field IN VARCHAR2 DEFAULT 'ALL') RETURN VARCHAR2;
46 
47   PRAGMA RESTRICT_REFERENCES(get_strm_typ_allocs, wnds, wnps);
48 END OKL_CASH_APPLN_RULE_PVT;