DBA Data[Home] [Help]

APPS.OKL_FE_STD_RATE_TMPL_PUB dependencies on STANDARD

Line 6: SUBTYPE okl_srtv_rec IS okl_fe_std_rate_tmpl_pvt.okl_srtv_rec; -- standard rate template header record

2: /* $Header: OKLPSRTS.pls 120.0 2005/07/07 10:42:03 viselvar noship $ */
3:
4: -- record structures used in the package
5:
6: SUBTYPE okl_srtv_rec IS okl_fe_std_rate_tmpl_pvt.okl_srtv_rec; -- standard rate template header record
7:
8: SUBTYPE okl_srv_rec IS okl_fe_std_rate_tmpl_pvt.okl_srv_rec; -- standard rate template version record
9:
10: SUBTYPE okl_ech_rec IS okl_fe_std_rate_tmpl_pvt.okl_ech_rec; -- Eligibility Criteria set record

Line 8: SUBTYPE okl_srv_rec IS okl_fe_std_rate_tmpl_pvt.okl_srv_rec; -- standard rate template version record

4: -- record structures used in the package
5:
6: SUBTYPE okl_srtv_rec IS okl_fe_std_rate_tmpl_pvt.okl_srtv_rec; -- standard rate template header record
7:
8: SUBTYPE okl_srv_rec IS okl_fe_std_rate_tmpl_pvt.okl_srv_rec; -- standard rate template version record
9:
10: SUBTYPE okl_ech_rec IS okl_fe_std_rate_tmpl_pvt.okl_ech_rec; -- Eligibility Criteria set record
11:
12: SUBTYPE okl_ecl_tbl IS okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl; -- Eligibility Criteria table

Line 34: -- procedure to give the details of the Standard Rate Template

30:
31: g_exception_halt_validation EXCEPTION;
32:
33: ------------------------------------------------------------------------------
34: -- procedure to give the details of the Standard Rate Template
35: --given the Standard Rate Template id and the version number
36:
37: PROCEDURE get_version(p_api_version IN NUMBER
38: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

Line 35: --given the Standard Rate Template id and the version number

31: g_exception_halt_validation EXCEPTION;
32:
33: ------------------------------------------------------------------------------
34: -- procedure to give the details of the Standard Rate Template
35: --given the Standard Rate Template id and the version number
36:
37: PROCEDURE get_version(p_api_version IN NUMBER
38: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
39: ,x_return_status OUT NOCOPY VARCHAR2

Line 50: -- procedure to give the details of the latest version of Standard Rate Template

46: ,x_ech_rec OUT NOCOPY okl_ech_rec
47: ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
48: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
49:
50: -- procedure to give the details of the latest version of Standard Rate Template
51: -- given the Standard Rate Template Id
52:
53: PROCEDURE get_version(p_api_version IN NUMBER
54: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

Line 51: -- given the Standard Rate Template Id

47: ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
48: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
49:
50: -- procedure to give the details of the latest version of Standard Rate Template
51: -- given the Standard Rate Template Id
52:
53: PROCEDURE get_version(p_api_version IN NUMBER
54: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
55: ,x_return_status OUT NOCOPY VARCHAR2

Line 65: -- procedure to create a new version of the Standard Rate Template

61: ,x_ech_rec OUT NOCOPY okl_ech_rec
62: ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
63: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
64:
65: -- procedure to create a new version of the Standard Rate Template
66:
67: PROCEDURE create_version(p_api_version IN NUMBER
68: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
69: ,x_return_status OUT NOCOPY VARCHAR2

Line 75: --procedure to create a Standard Rate Template with the associated Eligibility Criteria

71: ,x_msg_data OUT NOCOPY VARCHAR2
72: ,p_srv_rec IN okl_srv_rec
73: ,x_srv_rec OUT NOCOPY okl_srv_rec);
74:
75: --procedure to create a Standard Rate Template with the associated Eligibility Criteria
76:
77: PROCEDURE insert_srt(p_api_version IN NUMBER
78: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
79: ,x_return_status OUT NOCOPY VARCHAR2

Line 87: -- procedure to update a particular version of the Standard Rate Template

83: ,p_srv_rec IN okl_srv_rec
84: ,x_srtv_rec OUT NOCOPY okl_srtv_rec
85: ,x_srv_rec OUT NOCOPY okl_srv_rec);
86:
87: -- procedure to update a particular version of the Standard Rate Template
88:
89: PROCEDURE update_srt(p_api_version IN NUMBER
90: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
91: ,x_return_status OUT NOCOPY VARCHAR2

Line 135: -- procedure to set the default Standard Rate Template

131: ,x_msg_data OUT NOCOPY VARCHAR2
132: ,p_srv_rec IN okl_srv_rec
133: ,x_cal_eff_from OUT NOCOPY DATE);
134:
135: -- procedure to set the default Standard Rate Template
136:
137: PROCEDURE update_default(p_api_version IN NUMBER
138: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
139: ,x_return_status OUT NOCOPY VARCHAR2