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_BOOK_CONTROLLER_PVT dependencies on OKL_BOOK_CONTROLLER_TRX

Line 116: l_batch_num OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE;

112: -- History : XX-XXX-XXXX vthiruva Created
113: -- End of comments
114:
115: FUNCTION get_batch_id RETURN NUMBER IS
116: l_batch_num OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE;
117:
118: CURSOR get_batch_num IS
119: SELECT OKL_BKG_CONTL_SEQ.NEXTVAL
120: FROM DUAL;

Line 150: p_batch_num IN OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE,

146: -- History : XX-XXX-XXXX vthiruva Created
147: -- End of comments
148:
149: FUNCTION populate_ctrl_trx_rec(
150: p_batch_num IN OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE,
151: p_srl_num IN OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER%TYPE,
152: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
153: p_prog_name IN OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE,
154: p_prog_short_name IN OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE,

Line 151: p_srl_num IN OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER%TYPE,

147: -- End of comments
148:
149: FUNCTION populate_ctrl_trx_rec(
150: p_batch_num IN OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE,
151: p_srl_num IN OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER%TYPE,
152: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
153: p_prog_name IN OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE,
154: p_prog_short_name IN OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE,
155: p_active_flag IN VARCHAR2 DEFAULT NULL,

Line 153: p_prog_name IN OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE,

149: FUNCTION populate_ctrl_trx_rec(
150: p_batch_num IN OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE,
151: p_srl_num IN OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER%TYPE,
152: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
153: p_prog_name IN OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE,
154: p_prog_short_name IN OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE,
155: p_active_flag IN VARCHAR2 DEFAULT NULL,
156: p_progress_status IN OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE)
157: RETURN bct_rec_type IS

Line 154: p_prog_short_name IN OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE,

150: p_batch_num IN OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE,
151: p_srl_num IN OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER%TYPE,
152: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
153: p_prog_name IN OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE,
154: p_prog_short_name IN OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE,
155: p_active_flag IN VARCHAR2 DEFAULT NULL,
156: p_progress_status IN OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE)
157: RETURN bct_rec_type IS
158:

Line 156: p_progress_status IN OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE)

152: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
153: p_prog_name IN OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE,
154: p_prog_short_name IN OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE,
155: p_active_flag IN VARCHAR2 DEFAULT NULL,
156: p_progress_status IN OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE)
157: RETURN bct_rec_type IS
158:
159: l_bct_rec bct_rec_type;
160: BEGIN

Line 209: l_batch_num OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE;

205: x_batch_number OUT NOCOPY NUMBER) IS
206:
207: l_api_name CONSTANT VARCHAR2(30) := 'populate_book_ctrl_trx';
208: l_api_version CONSTANT NUMBER := 1.0;
209: l_batch_num OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE;
210: l_bct_tbl bct_tbl_type;
211: lx_bct_tbl bct_tbl_type;
212: i NUMBER;
213:

Line 216: FROM okl_book_controller_trx

212: i NUMBER;
213:
214: CURSOR c_book_ctrl_trx(p_khr_id NUMBER) IS
215: SELECT *
216: FROM okl_book_controller_trx
217: WHERE khr_id = p_khr_id
218: AND NVL(active_flag,'N') = 'Y';
219:
220: l_book_ctrl_trx c_book_ctrl_trx%ROWTYPE;

Line 221: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;

217: WHERE khr_id = p_khr_id
218: AND NVL(active_flag,'N') = 'Y';
219:
220: l_book_ctrl_trx c_book_ctrl_trx%ROWTYPE;
221: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;
222: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;
223: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;
224: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
225: lx_batch_number NUMBER;

Line 222: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;

218: AND NVL(active_flag,'N') = 'Y';
219:
220: l_book_ctrl_trx c_book_ctrl_trx%ROWTYPE;
221: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;
222: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;
223: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;
224: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
225: lx_batch_number NUMBER;
226:

Line 223: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;

219:
220: l_book_ctrl_trx c_book_ctrl_trx%ROWTYPE;
221: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;
222: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;
223: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;
224: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
225: lx_batch_number NUMBER;
226:
227: BEGIN

Line 224: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;

220: l_book_ctrl_trx c_book_ctrl_trx%ROWTYPE;
221: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;
222: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;
223: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;
224: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
225: lx_batch_number NUMBER;
226:
227: BEGIN
228: x_batch_number := null;

Line 247: -- Initialize records in okl_book_controller_trx table

243: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
244: RAISE OKL_API.G_EXCEPTION_ERROR;
245: END IF;
246:
247: -- Initialize records in okl_book_controller_trx table
248:
249: OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx(
250: p_api_version => p_api_version,
251: p_init_msg_list => p_init_msg_list,

Line 427: p_batch_num IN okl_book_controller_trx.batch_number%TYPE,

423: -- History : XX-XXX-XXXX vthiruva Created
424: -- End of comments
425:
426: PROCEDURE update_book_ctrl_trx(
427: p_batch_num IN okl_book_controller_trx.batch_number%TYPE,
428: p_srl_num IN okl_book_controller_trx.processing_srl_number%TYPE,
429: p_prog_status IN okl_book_controller_trx.progress_status%TYPE,
430: p_request_id IN okl_book_controller_trx.conc_req_id%TYPE,
431: x_return_status OUT NOCOPY VARCHAR2) IS

Line 428: p_srl_num IN okl_book_controller_trx.processing_srl_number%TYPE,

424: -- End of comments
425:
426: PROCEDURE update_book_ctrl_trx(
427: p_batch_num IN okl_book_controller_trx.batch_number%TYPE,
428: p_srl_num IN okl_book_controller_trx.processing_srl_number%TYPE,
429: p_prog_status IN okl_book_controller_trx.progress_status%TYPE,
430: p_request_id IN okl_book_controller_trx.conc_req_id%TYPE,
431: x_return_status OUT NOCOPY VARCHAR2) IS
432:

Line 429: p_prog_status IN okl_book_controller_trx.progress_status%TYPE,

425:
426: PROCEDURE update_book_ctrl_trx(
427: p_batch_num IN okl_book_controller_trx.batch_number%TYPE,
428: p_srl_num IN okl_book_controller_trx.processing_srl_number%TYPE,
429: p_prog_status IN okl_book_controller_trx.progress_status%TYPE,
430: p_request_id IN okl_book_controller_trx.conc_req_id%TYPE,
431: x_return_status OUT NOCOPY VARCHAR2) IS
432:
433: l_api_name CONSTANT VARCHAR2(30) := 'update_book_ctrl_trx';

Line 430: p_request_id IN okl_book_controller_trx.conc_req_id%TYPE,

426: PROCEDURE update_book_ctrl_trx(
427: p_batch_num IN okl_book_controller_trx.batch_number%TYPE,
428: p_srl_num IN okl_book_controller_trx.processing_srl_number%TYPE,
429: p_prog_status IN okl_book_controller_trx.progress_status%TYPE,
430: p_request_id IN okl_book_controller_trx.conc_req_id%TYPE,
431: x_return_status OUT NOCOPY VARCHAR2) IS
432:
433: l_api_name CONSTANT VARCHAR2(30) := 'update_book_ctrl_trx';
434: l_api_version CONSTANT NUMBER := 1.0;

Line 463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:batch number is null in call to update okl_book_controller_trx');

459: END IF;
460:
461: --check batch number is not null
462: IF (p_batch_num IS NULL OR p_batch_num = OKL_API.G_MISS_NUM) THEN
463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:batch number is null in call to update okl_book_controller_trx');
464: RAISE OKL_API.G_EXCEPTION_ERROR;
465: ELSE
466: l_bct_rec.batch_number := p_batch_num;
467: END IF;

Line 471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:processing srl number is null in call to update okl_book_controller_trx');

467: END IF;
468:
469: --check processing serial number is not null
470: IF (p_srl_num IS NULL OR p_srl_num = OKL_API.G_MISS_NUM) THEN
471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:processing srl number is null in call to update okl_book_controller_trx');
472: RAISE OKL_API.G_EXCEPTION_ERROR;
473: ELSE
474: l_bct_rec.processing_srl_number := p_srl_num;
475: END IF;

Line 487: --call TAPI to update okl_book_controller_trx

483: IF (p_request_id IS NOT NULL AND p_request_id <> OKL_API.G_MISS_NUM) THEN
484: l_bct_rec.conc_req_id := p_request_id;
485: END IF;
486:
487: --call TAPI to update okl_book_controller_trx
488: okl_bct_pvt.update_row(
489: p_api_version => l_api_version,
490: p_init_msg_list => l_init_msg_list,
491: x_return_status => l_return_status,

Line 567: l_batch_number okl_book_controller_trx.batch_number%TYPE;

563: l_req_id NUMBER := 0;
564:
565: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
566: l_init_msg_list VARCHAR2(1) := 'T';
567: l_batch_number okl_book_controller_trx.batch_number%TYPE;
568: l_msg_count NUMBER;
569: l_msg_data VARCHAR2(2000);
570: l_curr_sts_code okc_k_headers_b.sts_code%TYPE;
571:

Line 707: p_khr_id okl_book_controller_trx.khr_id%TYPE) IS

703: --cursor to check if the contract passed is being
704: --booked through concurrent requests and has been
705: --requested for Activation.
706: CURSOR book_ctrl_trx_csr(
707: p_khr_id okl_book_controller_trx.khr_id%TYPE) IS
708: SELECT '1'
709: FROM okl_book_controller_trx
710: WHERE khr_id = p_khr_id
711: AND progress_status = 'PENDING'

Line 709: FROM okl_book_controller_trx

705: --requested for Activation.
706: CURSOR book_ctrl_trx_csr(
707: p_khr_id okl_book_controller_trx.khr_id%TYPE) IS
708: SELECT '1'
709: FROM okl_book_controller_trx
710: WHERE khr_id = p_khr_id
711: AND progress_status = 'PENDING'
712: AND prog_short_name = 'OKLBCTBK'
713: AND NVL(active_flag,'N') = 'N';

Line 1109: l_batch_number okl_book_controller_trx.batch_number%TYPE;

1105: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1106: l_init_msg_list VARCHAR2(1) := 'T';
1107: l_msg_count NUMBER;
1108: l_msg_data VARCHAR2(2000);
1109: l_batch_number okl_book_controller_trx.batch_number%TYPE;
1110: l_curr_sts_code okc_k_headers_b.sts_code%TYPE;
1111: l_approval_path VARCHAR2(30) := 'NONE';
1112: l_req_status VARCHAR2(1);
1113: USER_EXCEPTION EXCEPTION;

Line 1121: SELECT * FROM okl_book_controller_trx

1117: --cursor to fetch the processes/steps to be executed
1118: --for the passed batch number.
1119: CURSOR book_ctrl_trx_csr(
1120: p_khr_id NUMBER) IS
1121: SELECT * FROM okl_book_controller_trx
1122: WHERE khr_id = p_khr_id
1123: AND progress_status = 'PENDING'
1124: AND nvl(active_flag,'N') = 'N'
1125: ORDER BY processing_srl_number;

Line 1509: p_khr_id okl_book_controller_trx.khr_id%TYPE) IS

1505:
1506: --cursor to fetch the processes/steps to be executed
1507: --for the passed batch number.
1508: CURSOR book_ctrl_trx_csr(
1509: p_khr_id okl_book_controller_trx.khr_id%TYPE) IS
1510: SELECT * FROM okl_book_controller_trx
1511: WHERE khr_id = p_khr_id
1512: AND progress_status = 'PENDING'
1513: AND nvl(active_flag,'N') = 'N'

Line 1510: SELECT * FROM okl_book_controller_trx

1506: --cursor to fetch the processes/steps to be executed
1507: --for the passed batch number.
1508: CURSOR book_ctrl_trx_csr(
1509: p_khr_id okl_book_controller_trx.khr_id%TYPE) IS
1510: SELECT * FROM okl_book_controller_trx
1511: WHERE khr_id = p_khr_id
1512: AND progress_status = 'PENDING'
1513: AND nvl(active_flag,'N') = 'N'
1514: ORDER BY processing_srl_number;

Line 2964: -- Description : Procedure to insert 4 records into OKL_BOOK_CONTROLLER_TRX

2960: -----------------------------------------------------------------------------
2961: -- Start of comments
2962: --
2963: -- Procedure Name : init_book_controller_trx
2964: -- Description : Procedure to insert 4 records into OKL_BOOK_CONTROLLER_TRX
2965: -- Called from OKL_CONTRACT_BOOK_PVT.execute_qa_check_list
2966: -- Business Rules :
2967: -- Parameters : p_khr_id
2968: -- Version : 1.0

Line 2983: l_batch_num OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE;

2979: x_batch_number OUT NOCOPY NUMBER) IS
2980:
2981: l_api_name CONSTANT VARCHAR2(30) := 'init_book_controller_trx';
2982: l_api_version CONSTANT NUMBER := 1.0;
2983: l_batch_num OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE;
2984: l_bct_tbl bct_tbl_type;
2985: lx_bct_tbl bct_tbl_type;
2986: i NUMBER;
2987:

Line 2991: FROM OKL_BOOK_CONTROLLER_TRX

2987:
2988: --Cursor to check existence of contract trx records
2989: CURSOR c_book_ctrl_trx(p_khr_id IN NUMBER) IS
2990: SELECT 'Y'
2991: FROM OKL_BOOK_CONTROLLER_TRX
2992: WHERE khr_id = p_khr_id
2993: AND NVL(active_flag,'N') = 'Y';
2994:
2995: --cursor to fetch the current status of the contract

Line 3003: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;

2999: WHERE id = p_khr_id;
3000:
3001: l_exists VARCHAR2(1) DEFAULT 'N';
3002: l_curr_sts_code okc_k_headers_b.sts_code%TYPE;
3003: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;
3004: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;
3005: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;
3006: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
3007:

Line 3004: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;

3000:
3001: l_exists VARCHAR2(1) DEFAULT 'N';
3002: l_curr_sts_code okc_k_headers_b.sts_code%TYPE;
3003: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;
3004: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;
3005: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;
3006: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
3007:
3008: BEGIN

Line 3005: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;

3001: l_exists VARCHAR2(1) DEFAULT 'N';
3002: l_curr_sts_code okc_k_headers_b.sts_code%TYPE;
3003: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;
3004: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;
3005: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;
3006: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
3007:
3008: BEGIN
3009: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3006: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;

3002: l_curr_sts_code okc_k_headers_b.sts_code%TYPE;
3003: l_qa_progress_status okl_book_controller_trx.progress_status%TYPE;
3004: l_ut_progress_status okl_book_controller_trx.progress_status%TYPE;
3005: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;
3006: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
3007:
3008: BEGIN
3009: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'Begin(+)');

Line 3195: -- Description : Procedure to update status of records in OKL_BOOK_CONTROLLER_TRX table

3191: -----------------------------------------------------------------------------
3192: -- Start of comments
3193: --
3194: -- Procedure Name : update_book_controller_trx
3195: -- Description : Procedure to update status of records in OKL_BOOK_CONTROLLER_TRX table
3196: -- Called from OKL_CONTRACT_BOOK_PVT.execute_qa_check_list
3197: -- Business Rules :
3198: -- Parameters : p_khr_id p_prog_short_name p_progress_status
3199: -- Version : 1.0

Line 3210: p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,

3206: x_return_status OUT NOCOPY VARCHAR2,
3207: x_msg_count OUT NOCOPY NUMBER,
3208: x_msg_data OUT NOCOPY VARCHAR2,
3209: p_khr_id IN okc_k_headers_b.id%TYPE,
3210: p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
3211: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
3212: p_progress_status IN okl_book_controller_trx.progress_status%TYPE) IS
3213:
3214: l_api_name CONSTANT VARCHAR2(30) := 'update_book_controller_trx';

Line 3211: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,

3207: x_msg_count OUT NOCOPY NUMBER,
3208: x_msg_data OUT NOCOPY VARCHAR2,
3209: p_khr_id IN okc_k_headers_b.id%TYPE,
3210: p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
3211: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
3212: p_progress_status IN okl_book_controller_trx.progress_status%TYPE) IS
3213:
3214: l_api_name CONSTANT VARCHAR2(30) := 'update_book_controller_trx';
3215: l_api_version CONSTANT NUMBER := 1.0;

Line 3212: p_progress_status IN okl_book_controller_trx.progress_status%TYPE) IS

3208: x_msg_data OUT NOCOPY VARCHAR2,
3209: p_khr_id IN okc_k_headers_b.id%TYPE,
3210: p_prog_short_name IN okl_book_controller_trx.prog_short_name%TYPE,
3211: p_conc_req_id IN okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
3212: p_progress_status IN okl_book_controller_trx.progress_status%TYPE) IS
3213:
3214: l_api_name CONSTANT VARCHAR2(30) := 'update_book_controller_trx';
3215: l_api_version CONSTANT NUMBER := 1.0;
3216: l_bct_rec bct_rec_type;

Line 3221: FROM okl_book_controller_trx

3217: x_bct_rec bct_rec_type;
3218:
3219: CURSOR c_book_ctrl_trx(p_khr_id NUMBER,p_prog_short_name VARCHAR2) IS
3220: SELECT *
3221: FROM okl_book_controller_trx
3222: WHERE khr_id = p_khr_id
3223: AND prog_short_name = nvl(p_prog_short_name, prog_short_name)
3224: AND NVL(active_flag,'N') = 'Y';
3225:

Line 3275: --call TAPI to update okl_book_controller_trx

3271: END IF;
3272: l_bct_rec.progress_status := p_progress_status;
3273: l_bct_rec.active_flag := l_book_ctrl_trx.active_flag;
3274:
3275: --call TAPI to update okl_book_controller_trx
3276: okl_bct_pvt.update_row(
3277: p_api_version => p_api_version,
3278: p_init_msg_list => p_init_msg_list,
3279: x_return_status => x_return_status,

Line 3356: -- Description : Procedure to update status of contract header, line and records in okl_book_controller_trx table

3352: -----------------------------------------------------------------------------
3353: -- Start of comments
3354: --
3355: -- Procedure Name : cancel_contract_activation
3356: -- Description : Procedure to update status of contract header, line and records in okl_book_controller_trx table
3357: -- Called from Authoring UI
3358: -- Business Rules :
3359: -- Parameters : p_khr_id
3360: -- Version : 1.0

Line 3373: l_prog_short_name OKL_BOOK_CONTROLLER_TRX.prog_short_name%TYPE;

3369: x_msg_data OUT NOCOPY VARCHAR2,
3370: p_khr_id IN okc_k_headers_b.id%TYPE) IS
3371: l_api_name CONSTANT VARCHAR2(30) := 'cancel_contract_activation';
3372: l_api_version CONSTANT NUMBER := 1.0;
3373: l_prog_short_name OKL_BOOK_CONTROLLER_TRX.prog_short_name%TYPE;
3374: BEGIN
3375: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3376: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'Begin(+)');
3377: END IF;

Line 3531: FROM okl_book_controller_trx

3527: l_api_version CONSTANT NUMBER := 1.0;
3528:
3529: CURSOR c_book_ctrl_trx(p_khr_id NUMBER,p_prog_short_name VARCHAR2) IS
3530: SELECT progress_status
3531: FROM okl_book_controller_trx
3532: WHERE khr_id = p_khr_id
3533: AND prog_short_name = p_prog_short_name
3534: AND NVL(active_flag,'N') = 'Y';
3535:

Line 3536: l_progress_status okl_book_controller_trx.progress_status%TYPE;

3532: WHERE khr_id = p_khr_id
3533: AND prog_short_name = p_prog_short_name
3534: AND NVL(active_flag,'N') = 'Y';
3535:
3536: l_progress_status okl_book_controller_trx.progress_status%TYPE;
3537: x_process_status VARCHAR2(30);
3538: BEGIN
3539: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'Begin(+)');

Line 3666: FROM okl_book_controller_trx

3662: l_api_version CONSTANT NUMBER := 1.0;
3663:
3664: CURSOR c_book_ctrl_trx(p_khr_id NUMBER,p_prog_short_name VARCHAR2) IS
3665: SELECT progress_status
3666: FROM okl_book_controller_trx
3667: WHERE khr_id = p_khr_id
3668: AND prog_short_name = p_prog_short_name
3669: AND NVL(active_flag,'N') = 'Y';
3670:

Line 3671: l_progress_status okl_book_controller_trx.progress_status%TYPE;

3667: WHERE khr_id = p_khr_id
3668: AND prog_short_name = p_prog_short_name
3669: AND NVL(active_flag,'N') = 'Y';
3670:
3671: l_progress_status okl_book_controller_trx.progress_status%TYPE;
3672: x_process_status VARCHAR2(30);
3673: BEGIN
3674: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'Begin(+)');