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_FE_STD_RATE_TMPL_PVT dependencies on OKL_API

Line 34: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;

30: ------------------------------------------------------------------------------
31: -- Global Variables
32:
33: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_FE_STD_RATE_TMPL_PVT';
34: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
35: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
36: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
37: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
38: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;

Line 38: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;

34: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
35: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
36: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
37: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
38: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
39: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
40:
41: ------------------------------------------------------------------------------
42: --Global Exception

Line 39: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;

35: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
36: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
37: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
38: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
39: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
40:
41: ------------------------------------------------------------------------------
42: --Global Exception
43: ------------------------------------------------------------------------------

Line 52: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
53: ,x_return_status OUT NOCOPY VARCHAR2
54: ,x_msg_count OUT NOCOPY NUMBER
55: ,x_msg_data OUT NOCOPY VARCHAR2
56: ,p_srt_id IN NUMBER

Line 68: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
70: ,x_msg_count OUT NOCOPY NUMBER
71: ,x_msg_data OUT NOCOPY VARCHAR2
72: ,p_srt_id IN NUMBER

Line 82: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
84: ,x_msg_count OUT NOCOPY NUMBER
85: ,x_msg_data OUT NOCOPY VARCHAR2
86: ,p_srv_rec IN okl_srv_rec

Line 92: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
94: ,x_msg_count OUT NOCOPY NUMBER
95: ,x_msg_data OUT NOCOPY VARCHAR2
96: ,p_srtv_rec IN okl_srtv_rec

Line 104: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
106: ,x_msg_count OUT NOCOPY NUMBER
107: ,x_msg_data OUT NOCOPY VARCHAR2
108: ,p_srv_rec IN okl_srv_rec

Line 114: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

110:
111: -- procedure to raise the workflow which submits the record and changes the status.
112:
113: PROCEDURE submit_srt(p_api_version IN NUMBER
114: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER
117: ,x_msg_data OUT NOCOPY VARCHAR2
118: ,p_version_id IN NUMBER);

Line 123: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

119:
120: -- procedure to handle when the process is going through the process of approval
121:
122: PROCEDURE handle_approval(p_api_version IN NUMBER
123: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
124: ,x_return_status OUT NOCOPY VARCHAR2
125: ,x_msg_count OUT NOCOPY NUMBER
126: ,x_msg_data OUT NOCOPY VARCHAR2
127: ,p_version_id IN NUMBER);

Line 132: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
134: ,x_msg_count OUT NOCOPY NUMBER
135: ,x_msg_data OUT NOCOPY VARCHAR2
136: ,p_srt_id IN NUMBER);

Line 141: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

137:
138: -- to find the list of all the invalid object refernces
139:
140: PROCEDURE invalid_objects(p_api_version IN NUMBER
141: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
142: ,x_return_status OUT NOCOPY VARCHAR2
143: ,x_msg_count OUT NOCOPY NUMBER
144: ,x_msg_data OUT NOCOPY VARCHAR2
145: ,p_version_id IN NUMBER

Line 151: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

147:
148: -- to calculate the start date of the new version
149:
150: PROCEDURE calc_start_date(p_api_version IN NUMBER
151: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
154: ,x_msg_data OUT NOCOPY VARCHAR2
155: ,p_srv_rec IN okl_srv_rec

Line 159: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

155: ,p_srv_rec IN okl_srv_rec
156: ,x_cal_eff_from OUT NOCOPY DATE);
157:
158: PROCEDURE enddate_std_rate_tmpl(p_api_version IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_count OUT NOCOPY NUMBER
162: ,x_msg_data OUT NOCOPY VARCHAR2
163: ,p_srv_id_tbl IN okl_number_table