APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_K_CONTROL

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

514:
515: -- ----------------------
516: -- Std Who columns
517: -- ----------------------
518: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
519: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
520: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
521: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
522: -- End Bug 4520466

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

515: -- ----------------------
516: -- Std Who columns
517: -- ----------------------
518: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
519: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
520: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
521: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
522: -- End Bug 4520466
523:

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

516: -- Std Who columns
517: -- ----------------------
518: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
519: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
520: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
521: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
522: -- End Bug 4520466
523:
524: ---- Added by Vpanwar --- Code for new accounting API uptake

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

517: -- ----------------------
518: lx_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
519: lx_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
520: lx_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
521: lx_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
522: -- End Bug 4520466
523:
524: ---- Added by Vpanwar --- Code for new accounting API uptake
525: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;

Line 613: -- update okl_k_control table

609: INSERT INTO OKL_TRX_AR_INVOICES_B
610: VALUES tai_tbl(indx);
611:
612: -- Start Bug 4520466
613: -- update okl_k_control table
614:
615: -- Clear all table entries, if any
616: dist_khr_id_tbl.delete;
617:

Line 946: -- Start Bug 4520466 stmathew update okl_k_control

942: SET date_billed = SYSDATE
943: WHERE id = sel_id_tbl(indx);
944: END IF;
945:
946: -- Start Bug 4520466 stmathew update okl_k_control
947:
948: if dist_khr_id_tbl.count > 0 then
949: forall indx in dist_khr_id_tbl.first..dist_khr_id_tbl.last
950: save exceptions

Line 951: UPDATE okl_k_control nbd

947:
948: if dist_khr_id_tbl.count > 0 then
949: forall indx in dist_khr_id_tbl.first..dist_khr_id_tbl.last
950: save exceptions
951: UPDATE okl_k_control nbd
952: set EARLIEST_STRM_BILL_DATE = (
953: SELECT MIN(ste.stream_element_date)
954: FROM OKL_STRM_ELEMENTS ste,
955: OKL_STREAMS stm,

Line 1001: -- End Bug 4520466 stmathew update okl_k_control

997: end if; -- if dist_khr_id_tbl count > 0
998:
999: dist_khr_id_tbl.delete;
1000:
1001: -- End Bug 4520466 stmathew update okl_k_control
1002:
1003: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1004: 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
1005: