DBA Data[Home] [Help]

APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on STANDARD

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

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

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

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

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

44:
45: g_exception_halt_validation EXCEPTION;
46:
47: ------------------------------------------------------------------------------
48: -- procedure to give the details of the Standard Rate Template given the Standard
49: -- Rate Template id and the version number
50:
51: PROCEDURE get_version(p_api_version IN NUMBER
52: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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

60: ,x_ech_rec OUT NOCOPY okl_ech_rec
61: ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
62: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
63:
64: -- procedure to give the details of the latest version of Standard Rate Template
65: -- given the Standard Rate Template id
66:
67: PROCEDURE get_version(p_api_version IN NUMBER
68: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

Line 65: -- given the Standard Rate Template id

61: ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
62: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
63:
64: -- procedure to give the details of the latest version of Standard Rate Template
65: -- given the Standard Rate Template id
66:
67: PROCEDURE get_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 79: -- procedure to create a new version of the Standard Rate Template

75: ,x_ech_rec OUT NOCOPY okl_ech_rec
76: ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
77: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
78:
79: -- procedure to create a new version of the Standard Rate Template
80:
81: PROCEDURE create_version(p_api_version IN NUMBER
82: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
83: ,x_return_status OUT NOCOPY VARCHAR2

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

85: ,x_msg_data OUT NOCOPY VARCHAR2
86: ,p_srv_rec IN okl_srv_rec
87: ,x_srv_rec OUT NOCOPY okl_srv_rec);
88:
89: --procedure to create a Standard Rate Template with the associated Eligibility Criteria
90:
91: PROCEDURE insert_srt(p_api_version IN NUMBER
92: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
93: ,x_return_status OUT NOCOPY VARCHAR2

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

97: ,p_srv_rec IN okl_srv_rec
98: ,x_srtv_rec OUT NOCOPY okl_srtv_rec
99: ,x_srv_rec OUT NOCOPY okl_srv_rec);
100:
101: -- procedure to update a particular version of the Standard Rate Template
102:
103: PROCEDURE update_srt(p_api_version IN NUMBER
104: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
105: ,x_return_status OUT NOCOPY VARCHAR2

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

125: ,x_msg_count OUT NOCOPY NUMBER
126: ,x_msg_data OUT NOCOPY VARCHAR2
127: ,p_version_id IN NUMBER);
128:
129: -- procedure to set the default Standard Rate Template
130:
131: PROCEDURE update_default(p_api_version IN NUMBER
132: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
133: ,x_return_status OUT NOCOPY VARCHAR2