APPS.OKL_FE_ADJ_MATRIX_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_ADJ_MATRIX_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 adjustment matrix given the Adjustment
49: -- matrix 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_adj_mat_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 adjustment matrix
65: -- given the adjusment matrix 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_adj_mat_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 Pricing Adjustment Matrix
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_pal_rec IN okl_pal_rec

Line 92: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

88:
89: --procedure to create a Pricing Adjusment Matrix with the associated adjustment categories
90:
91: PROCEDURE insert_adj_mat(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_pamv_rec IN okl_pamv_rec

Line 104: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

100:
101: -- procedure to update a particular version of the Pricing Adjustment matrix
102:
103: PROCEDURE update_adj_mat(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_pal_rec IN okl_pal_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_adj_mat(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 validate the pricing adjustment matrix
121:
122: PROCEDURE validate_adj_mat(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_pal_rec IN okl_pal_rec

Line 135: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

131:
132: -- procedure to handle when the process is going through the process of approval
133:
134: PROCEDURE handle_approval(p_api_version IN NUMBER
135: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
136: ,x_return_status OUT NOCOPY VARCHAR2
137: ,x_msg_count OUT NOCOPY NUMBER
138: ,x_msg_data OUT NOCOPY VARCHAR2
139: ,p_version_id IN NUMBER);

Line 144: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

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

Line 154: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

150:
151: -- to calculate the start date of the new version
152:
153: PROCEDURE calc_start_date(p_api_version IN NUMBER
154: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
155: ,x_return_status OUT NOCOPY VARCHAR2
156: ,x_msg_count OUT NOCOPY NUMBER
157: ,x_msg_data OUT NOCOPY VARCHAR2
158: ,p_pal_rec IN okl_pal_rec