14: ------------------------------------------------------------------------------
15: -- Global Constants
16: ------------------------------------------------------------------------------
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_CREDIT_MEMO_PUB';
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
21: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
22:
55: * @rep:lifecycle active
56: * @rep:category BUSINESS_ENTITY OKL_COLLECTION
57: */
58: PROCEDURE insert_request(p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
60: --p_lsm_id IN NUMBER,
61: p_tld_id IN NUMBER,-- 5897792
62: p_credit_amount IN NUMBER,
63: p_credit_sty_id IN NUMBER DEFAULT NULL,
73: x_msg_data OUT NOCOPY VARCHAR2);
74:
75:
76: PROCEDURE insert_request(p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
78: --p_lsm_id IN NUMBER,
79: p_tld_id IN NUMBER,-- 5897792
80: p_credit_amount IN NUMBER,
81: p_credit_sty_id IN NUMBER DEFAULT NULL,
90: x_msg_data OUT NOCOPY VARCHAR2);
91:
92: --rkuttiya added for bug # 4341480
93: PROCEDURE insert_on_acc_cm_request(p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
95: --p_lsm_id IN NUMBER,
96: p_tld_id IN NUMBER,-- 5897792
97: p_credit_amount IN NUMBER,
98: p_credit_sty_id IN NUMBER DEFAULT NULL,
127: * @rep:lifecycle active
128: * @rep:category BUSINESS_ENTITY OKL_COLLECTION
129: */
130: PROCEDURE insert_request(p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
132: p_credit_list IN credit_tbl,
133: p_transaction_source IN VARCHAR2 DEFAULT NULL,--5897792
134: p_source_trx_number IN VARCHAR2 DEFAULT NULL,
135: x_taiv_tbl OUT NOCOPY taiv_tbl_type,