APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_K_CONTROL

Line 80: from okl_k_control nbd,

76: is
77:
78: cursor khr_bill_date_csr( p_khr_id NUMBER ) is
79: select nbd.khr_id
80: from okl_k_control nbd,
81: okl_k_headers_full_v khr
82: where nbd.khr_id = khr.id
83: and khr.id = p_khr_id;
84:

Line 89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;

85: l_khr_id number;
86: l_next_bill_date date;
87:
88: -- Org Id and standard who columns
89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
93:

Line 90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;

86: l_next_bill_date date;
87:
88: -- Org Id and standard who columns
89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
93:
94: begin

Line 91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;

87:
88: -- Org Id and standard who columns
89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
93:
94: begin
95:

Line 92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

88: -- Org Id and standard who columns
89: l_last_updated_by okl_k_control.last_updated_by%TYPE := Fnd_Global.USER_ID;
90: l_last_update_login okl_k_control.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
91: l_request_id okl_k_control.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
92: l_program_id okl_k_control.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
93:
94: begin
95:
96: if p_khr_id is null then

Line 113: update okl_k_control

109:
110: -- if a record exists in NBD, then update it, else create a new entry
111: if l_khr_id is not null then
112:
113: update okl_k_control
114: set EARLIEST_STRM_BILL_DATE = l_next_bill_date,
115: LAST_UPDATE_DATE = sysdate,
116: LAST_UPDATED_BY = l_last_updated_by,
117: LAST_UPDATE_LOGIN = l_last_update_login,

Line 125: INSERT INTO okl_k_control

121: where khr_id = l_khr_id;
122:
123: else -- if no entry exists in NBD
124:
125: INSERT INTO okl_k_control
126: (
127: khr_id, EARLIEST_STRM_BILL_DATE,
128: CREATED_BY,CREATION_DATE,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,
129: REQUEST_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE

Line 757: okl_k_control nbd -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636)

753: cursor chk_update_header_csr ( p_date date, orgId VARCHAr2 ) is -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636)
754: -- -- bug# 5872306 (ssiruvol)
755: SELECT khr.contract_number contract_number, khr.id khr_id
756: FROM okc_k_headers_b khr, -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636)
757: okl_k_control nbd -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636)
758: WHERE ((p_contract_number is not null and KHR.CONTRACT_NUMBER=p_contract_number)
759: or (p_contract_number is null and KHR.CONTRACT_NUMBER=KHR.CONTRACT_NUMBER))
760: AND ((p_cust_acct_id is not null and KHR.CUST_ACCT_ID=p_cust_acct_id)
761: or (p_cust_acct_id is null and KHR.CUST_ACCT_ID=KHR.CUST_ACCT_ID))

Line 902: okl_k_control nbd,

898: -- modified by zrehman for Bug#6788005 on 01-Feb-2008 start
899: UNION
900: SELECT khr.contract_number contract_number, khr.id khr_id
901: FROM okc_k_headers_b khr,
902: okl_k_control nbd,
903: okc_k_lines_b cle
904: WHERE ((p_contract_number is not null and KHR.CONTRACT_NUMBER=p_contract_number)
905: or (p_contract_number is null and KHR.CONTRACT_NUMBER=KHR.CONTRACT_NUMBER))
906: AND ((p_inv_cust_acct_id is not null and cle.CUST_ACCT_ID IS NOT NULL AND cle.CUST_ACCT_ID = p_inv_cust_acct_id )

Line 1332: from okl_k_control nbd

1328: -- rmunjulu R12 Forward Port bug 5634652 logic to check print lead days
1329: + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)
1330: -- rmunjulu R12 Forward Port bug 5710903 Add ONE to account for scenario where these dates are same
1331: - nbd.earliest_strm_bill_date + 1)/30)
1332: from okl_k_control nbd
1333: where nbd.khr_id = opp.khr_id)
1334:
1335: WHERE OPP.ASSIGNED_PROCESS = TO_CHAR(l_seq_next); -- bug# 5872306 (ssiruvol)
1336: commit;