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

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

18: ------------------------------------------------------------------------------
19: -- Global Variables
20:
21: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_FE_STD_RATE_TMP_PUB';
22: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
23: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
24: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
25: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
26:

Line 38: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
40: ,x_msg_count OUT NOCOPY NUMBER
41: ,x_msg_data OUT NOCOPY VARCHAR2
42: ,p_srt_id IN NUMBER

Line 54: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
56: ,x_msg_count OUT NOCOPY NUMBER
57: ,x_msg_data OUT NOCOPY VARCHAR2
58: ,p_srt_id IN NUMBER

Line 68: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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

Line 78: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
80: ,x_msg_count OUT NOCOPY NUMBER
81: ,x_msg_data OUT NOCOPY VARCHAR2
82: ,p_srtv_rec IN okl_srtv_rec

Line 90: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
92: ,x_msg_count OUT NOCOPY NUMBER
93: ,x_msg_data OUT NOCOPY VARCHAR2
94: ,p_srv_rec IN okl_srv_rec

Line 100: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

96:
97: -- procedure to raise the workflow which submits the record and changes the status.
98:
99: PROCEDURE submit_srt(p_api_version IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
101: ,x_return_status OUT NOCOPY VARCHAR2
102: ,x_msg_count OUT NOCOPY NUMBER
103: ,x_msg_data OUT NOCOPY VARCHAR2
104: ,p_version_id IN NUMBER);

Line 109: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

105:
106: -- procedure to handle when the process is going through the process of approval
107:
108: PROCEDURE handle_approval(p_api_version IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
110: ,x_return_status OUT NOCOPY VARCHAR2
111: ,x_msg_count OUT NOCOPY NUMBER
112: ,x_msg_data OUT NOCOPY VARCHAR2
113: ,p_version_id IN NUMBER);

Line 118: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

114:
115: -- to find the list of all the invalid object refernces
116:
117: PROCEDURE invalid_objects(p_api_version IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
119: ,x_return_status OUT NOCOPY VARCHAR2
120: ,x_msg_count OUT NOCOPY NUMBER
121: ,x_msg_data OUT NOCOPY VARCHAR2
122: ,p_version_id IN NUMBER

Line 128: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

124:
125: -- to calculate the start date of the new version
126:
127: PROCEDURE calc_start_date(p_api_version IN NUMBER
128: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
129: ,x_return_status OUT NOCOPY VARCHAR2
130: ,x_msg_count OUT NOCOPY NUMBER
131: ,x_msg_data OUT NOCOPY VARCHAR2
132: ,p_srv_rec IN okl_srv_rec

Line 138: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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
140: ,x_msg_count OUT NOCOPY NUMBER
141: ,x_msg_data OUT NOCOPY VARCHAR2
142: ,p_srt_id IN NUMBER);