86: -----------------------------------------------------------------------------
87: -- Start of comments
88: --
89: -- Procedure Name : init_book_controller_trx
90: -- Description : Procedure to insert 4 records into OKL_BOOK_CONTROLLER_TRX
91: -- Called from OKL_CONTRACT_BOOK_PVT.execute_qa_check_list
92: -- Business Rules :
93: -- Parameters : p_khr_id
94: -- Version : 1.0
109: -----------------------------------------------------------------------------
110: -- Start of comments
111: --
112: -- Procedure Name : update_book_controller_trx
113: -- Description : Procedure to update status of records in OKL_BOOK_CONTROLLER_TRX table
114: -- Called from OKL_CONTRACT_BOOK_PVT.execute_qa_check_list
115: -- Business Rules :
116: -- Parameters : p_khr_id p_prog_short_name p_progress_status
117: -- Version : 1.0
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_khr_id IN okc_k_headers_b.id%TYPE,
128: p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
129: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
130: p_progress_status IN okl_book_controller_trx.progress_status%TYPE);
131:
132: -----------------------------------------------------------------------------
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_khr_id IN okc_k_headers_b.id%TYPE,
128: p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
129: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
130: p_progress_status IN okl_book_controller_trx.progress_status%TYPE);
131:
132: -----------------------------------------------------------------------------
133: -- PROCEDURE cancel_contract_activation
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_khr_id IN okc_k_headers_b.id%TYPE,
128: p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
129: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
130: p_progress_status IN okl_book_controller_trx.progress_status%TYPE);
131:
132: -----------------------------------------------------------------------------
133: -- PROCEDURE cancel_contract_activation
134: -----------------------------------------------------------------------------
134: -----------------------------------------------------------------------------
135: -- Start of comments
136: --
137: -- Procedure Name : cancel_contract_activation
138: -- Description : Procedure to update status of contract header, line and records in okl_book_controller_trx table
139: -- Called from Authoring UI
140: -- Business Rules :
141: -- Parameters : p_khr_id
142: -- Version : 1.0