4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- okl_pmt_channel_methods Record Spec
7: TYPE pcm_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,org_id NUMBER := OKL_API.G_MISS_NUM
11: ,receipt_method_id NUMBER := OKL_API.G_MISS_NUM
12: ,payment_channel_code okl_pmt_channel_methods.payment_channel_code%TYPE := OKL_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- okl_pmt_channel_methods Record Spec
7: TYPE pcm_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,org_id NUMBER := OKL_API.G_MISS_NUM
11: ,receipt_method_id NUMBER := OKL_API.G_MISS_NUM
12: ,payment_channel_code okl_pmt_channel_methods.payment_channel_code%TYPE := OKL_API.G_MISS_CHAR
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
6: -- okl_pmt_channel_methods Record Spec
7: TYPE pcm_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,org_id NUMBER := OKL_API.G_MISS_NUM
11: ,receipt_method_id NUMBER := OKL_API.G_MISS_NUM
12: ,payment_channel_code okl_pmt_channel_methods.payment_channel_code%TYPE := OKL_API.G_MISS_CHAR
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date okl_pmt_channel_methods.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
7: TYPE pcm_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,org_id NUMBER := OKL_API.G_MISS_NUM
11: ,receipt_method_id NUMBER := OKL_API.G_MISS_NUM
12: ,payment_channel_code okl_pmt_channel_methods.payment_channel_code%TYPE := OKL_API.G_MISS_CHAR
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date okl_pmt_channel_methods.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,org_id NUMBER := OKL_API.G_MISS_NUM
11: ,receipt_method_id NUMBER := OKL_API.G_MISS_NUM
12: ,payment_channel_code okl_pmt_channel_methods.payment_channel_code%TYPE := OKL_API.G_MISS_CHAR
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date okl_pmt_channel_methods.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date okl_pmt_channel_methods.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,org_id NUMBER := OKL_API.G_MISS_NUM
11: ,receipt_method_id NUMBER := OKL_API.G_MISS_NUM
12: ,payment_channel_code okl_pmt_channel_methods.payment_channel_code%TYPE := OKL_API.G_MISS_CHAR
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date okl_pmt_channel_methods.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date okl_pmt_channel_methods.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
10: ,org_id NUMBER := OKL_API.G_MISS_NUM
11: ,receipt_method_id NUMBER := OKL_API.G_MISS_NUM
12: ,payment_channel_code okl_pmt_channel_methods.payment_channel_code%TYPE := OKL_API.G_MISS_CHAR
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date okl_pmt_channel_methods.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date okl_pmt_channel_methods.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
18: G_Miss_pcm_rec pcm_rec_type;
11: ,receipt_method_id NUMBER := OKL_API.G_MISS_NUM
12: ,payment_channel_code okl_pmt_channel_methods.payment_channel_code%TYPE := OKL_API.G_MISS_CHAR
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date okl_pmt_channel_methods.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date okl_pmt_channel_methods.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
18: G_Miss_pcm_rec pcm_rec_type;
19: TYPE pcm_tbl_type IS TABLE OF pcm_rec_type
12: ,payment_channel_code okl_pmt_channel_methods.payment_channel_code%TYPE := OKL_API.G_MISS_CHAR
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date okl_pmt_channel_methods.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date okl_pmt_channel_methods.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
18: G_Miss_pcm_rec pcm_rec_type;
19: TYPE pcm_tbl_type IS TABLE OF pcm_rec_type
20: INDEX BY BINARY_INTEGER;
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date okl_pmt_channel_methods.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date okl_pmt_channel_methods.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
18: G_Miss_pcm_rec pcm_rec_type;
19: TYPE pcm_tbl_type IS TABLE OF pcm_rec_type
20: INDEX BY BINARY_INTEGER;
21: ---------------------------------------------------------------------------
20: INDEX BY BINARY_INTEGER;
21: ---------------------------------------------------------------------------
22: -- GLOBAL MESSAGE CONSTANTS
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
21: ---------------------------------------------------------------------------
22: -- GLOBAL MESSAGE CONSTANTS
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
22: -- GLOBAL MESSAGE CONSTANTS
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
24: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
35: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
35: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
36: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
35: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
36: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
37:
44: ---------------------------------------------------------------------------
45: -- GLOBAL VARIABLES
46: ---------------------------------------------------------------------------
47: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PCM_PVT';
48: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
49: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
50: ---------------------------------------------------------------------------
51: -- Procedures and Functions
52: ---------------------------------------------------------------------------
69: x_msg_count OUT NOCOPY NUMBER,
70: x_msg_data OUT NOCOPY VARCHAR2,
71: p_pcm_tbl IN pcm_tbl_type,
72: x_pcm_tbl OUT NOCOPY pcm_tbl_type,
73: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
74: PROCEDURE insert_row(
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2,
77: x_return_status OUT NOCOPY VARCHAR2,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_pcm_tbl IN pcm_tbl_type,
96: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
97: PROCEDURE lock_row(
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2,
100: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_pcm_tbl IN pcm_tbl_type,
119: x_pcm_tbl OUT NOCOPY pcm_tbl_type,
120: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
121: PROCEDURE update_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2,
124: x_return_status OUT NOCOPY VARCHAR2,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_pcm_tbl IN pcm_tbl_type,
143: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
144: PROCEDURE delete_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2,
147: x_return_status OUT NOCOPY VARCHAR2,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_pcm_tbl IN pcm_tbl_type,
165: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
166: PROCEDURE validate_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2,
169: x_return_status OUT NOCOPY VARCHAR2,