APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_K_CONTROL

Line 577: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;

573:
574: -- ----------------------
575: -- Std Who columns
576: -- ----------------------
577: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
578: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
579: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
580: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
581: -- End Bug 4520466

Line 578: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;

574: -- ----------------------
575: -- Std Who columns
576: -- ----------------------
577: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
578: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
579: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
580: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
581: -- End Bug 4520466
582:

Line 579: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;

575: -- Std Who columns
576: -- ----------------------
577: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
578: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
579: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
580: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
581: -- End Bug 4520466
582:
583: ---- Added by Vpanwar --- Code for new accounting API uptake

Line 580: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

576: -- ----------------------
577: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
578: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
579: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
580: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
581: -- End Bug 4520466
582:
583: ---- Added by Vpanwar --- Code for new accounting API uptake
584: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;

Line 672: -- update okl_k_control table

668: INSERT INTO OKL_TRX_AR_INVOICES_B
669: VALUES tai_tbl(indx);
670:
671: -- Start Bug 4520466
672: -- update okl_k_control table
673:
674: -- Clear all table entries, if any
675: dist_khr_id_tbl.delete;
676:

Line 1008: -- Start Bug 4520466 stmathew update okl_k_control

1004: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG 14742784 change ends here
1005: WHERE id = sel_id_tbl(indx);
1006: END IF;
1007:
1008: -- Start Bug 4520466 stmathew update okl_k_control
1009:
1010: if dist_khr_id_tbl.count > 0 then
1011: forall indx in dist_khr_id_tbl.first..dist_khr_id_tbl.last
1012: save exceptions

Line 1013: UPDATE okl_k_control nbd

1009:
1010: if dist_khr_id_tbl.count > 0 then
1011: forall indx in dist_khr_id_tbl.first..dist_khr_id_tbl.last
1012: save exceptions
1013: UPDATE okl_k_control nbd
1014: set EARLIEST_STRM_BILL_DATE = (
1015: SELECT MIN(ste.stream_element_date)
1016: FROM OKL_STRM_ELEMENTS ste,
1017: OKL_STREAMS stm,

Line 1063: -- End Bug 4520466 stmathew update okl_k_control

1059: end if; -- if dist_khr_id_tbl count > 0
1060:
1061: dist_khr_id_tbl.delete;
1062:
1063: -- End Bug 4520466 stmathew update okl_k_control
1064:
1065: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1066: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done updating status of records in tai and sel database tables'); -- rmunjulu R12 Fixes REMOVED XSI FROM COMMENTS
1067: