eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_TRANS_PRICING_PARAMS_PVT dependencies on OKL_API

Line 5: gtp_id NUMBER DEFAULT Okl_Api.G_MISS_NUM

1: Package okl_trans_pricing_params_pvt as
2: /* $Header: OKLRSPMS.pls 120.3 2005/10/30 03:17:23 appldev noship $*/
3:
4: TYPE tpp_rec_type IS RECORD (
5: gtp_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
6: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR);
7:
8: ---------------------------------------------------------------------------
9: -- GLOBAL VARIABLES

Line 6: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR);

2: /* $Header: OKLRSPMS.pls 120.3 2005/10/30 03:17:23 appldev noship $*/
3:
4: TYPE tpp_rec_type IS RECORD (
5: gtp_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
6: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR);
7:
8: ---------------------------------------------------------------------------
9: -- GLOBAL VARIABLES
10: ---------------------------------------------------------------------------

Line 20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;

16: G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
17: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
18: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
19: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
24: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

Line 21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;

17: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
18: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
19: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
24: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_TRANS_PRICING_PARAMS_PVT';

Line 22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;

18: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
19: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
24: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_TRANS_PRICING_PARAMS_PVT';
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;

Line 24: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
24: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_TRANS_PRICING_PARAMS_PVT';
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;

Line 26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;

22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
24: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_TRANS_PRICING_PARAMS_PVT';
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;

Line 27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;

23: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
24: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_TRANS_PRICING_PARAMS_PVT';
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
31: G_INIT_VERSION CONSTANT NUMBER := 1.0;

Line 28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;

24: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_TRANS_PRICING_PARAMS_PVT';
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
31: G_INIT_VERSION CONSTANT NUMBER := 1.0;
32: G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;

Line 29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;

25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_TRANS_PRICING_PARAMS_PVT';
26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
31: G_INIT_VERSION CONSTANT NUMBER := 1.0;
32: G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
33: G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';

Line 30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;

26: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
27: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
28: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
29: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
31: G_INIT_VERSION CONSTANT NUMBER := 1.0;
32: G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
33: G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
34: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';

Line 34: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';

30: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
31: G_INIT_VERSION CONSTANT NUMBER := 1.0;
32: G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
33: G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
34: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
35: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
36: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 35: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';

31: G_INIT_VERSION CONSTANT NUMBER := 1.0;
32: G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
33: G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
34: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
35: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
36: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 36: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

32: G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
33: G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
34: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
35: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
36: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40:

Line 37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

33: G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
34: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
35: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
36: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40:
41: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

Line 38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

34: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
35: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
36: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
37: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
38: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
39: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40:
41: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
42: G_EXCEPTION_HALT_PROCESSING EXCEPTION;

Line 60: ,p_chr_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM

56: ,x_return_status OUT NOCOPY VARCHAR2
57: ,x_msg_count OUT NOCOPY NUMBER
58: ,x_msg_data OUT NOCOPY VARCHAR2
59: ,p_tpp_rec IN tpp_rec_type
60: ,p_chr_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM
61: ,p_gts_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM
62: ,p_sif_id IN NUMBER
63: );
64:

Line 61: ,p_gts_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM

57: ,x_msg_count OUT NOCOPY NUMBER
58: ,x_msg_data OUT NOCOPY VARCHAR2
59: ,p_tpp_rec IN tpp_rec_type
60: ,p_chr_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM
61: ,p_gts_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM
62: ,p_sif_id IN NUMBER
63: );
64:
65: PROCEDURE create_trans_pricing_params(

Line 72: ,p_chr_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM

68: ,x_return_status OUT NOCOPY VARCHAR2
69: ,x_msg_count OUT NOCOPY NUMBER
70: ,x_msg_data OUT NOCOPY VARCHAR2
71: ,p_tpp_tbl IN tpp_tbl_type
72: ,p_chr_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM
73: ,p_gts_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM
74: ,p_sif_id IN NUMBER
75: );
76:

Line 73: ,p_gts_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM

69: ,x_msg_count OUT NOCOPY NUMBER
70: ,x_msg_data OUT NOCOPY VARCHAR2
71: ,p_tpp_tbl IN tpp_tbl_type
72: ,p_chr_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM
73: ,p_gts_id IN NUMBER DEFAULT Okl_Api.G_MISS_NUM
74: ,p_sif_id IN NUMBER
75: );
76:
77: PROCEDURE delete_pricing_params (