[Home] [Help]
84:
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;
168: l_xfer_cnt NUMBER;
169: l_prep_cnt NUMBER;
170:
171: -- Bug 4546873
172: -- Org Id and standard who columns
173: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
174: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
175: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
176: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
771: WHERE RGP.ID = RULE.RGP_ID AND RGP.DNZ_CHR_ID = KHR.ID
772: AND RGP.RGD_CODE = 'LABILL' AND RULE.RULE_INFORMATION_CATEGORY = 'LAINVD'
773: ),
774: (SELECT TERM.PRINTING_LEAD_DAYS FROM HZ_CUSTOMER_PROFILES CP,
775: RA_TERMS TERM where KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID AND CP.STANDARD_TERMS = TERM.TERM_ID)
776: ),0)
777: )
778:
779: -- OKL_STREAM_BILLING_PVT.get_printing_lead_days(khr.id)) -- Added for Bug#6794547
958: WHERE opp.khr_id = khr.id AND RGP.ID = RULE.RGP_ID AND RGP.DNZ_CHR_ID = KHR.ID
959: AND RGP.RGD_CODE = 'LABILL' AND RULE.RULE_INFORMATION_CATEGORY = 'LAINVD'
960: ),
961: (SELECT TERM.PRINTING_LEAD_DAYS FROM HZ_CUSTOMER_PROFILES CP, RA_TERMS TERM, okc_k_headers_b khr
962: WHERE opp.khr_id = khr.id AND KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID AND CP.STANDARD_TERMS = TERM.TERM_ID)
963: ),0)
964: --Bug# 7701159 - Susbtitute SQL query for PL//*/*SQL call
965: /*NVL((SELECT NVL(RULE.RULE_INFORMATION3,TERM.PRINTING_LEAD_DAYS)
966: FROM OKC_RULES_B RULE,
973: AND RGP.DNZ_CHR_ID = KHR.ID
974: AND RGP.RGD_CODE = 'LABILL'
975: AND RULE.RULE_INFORMATION_CATEGORY = 'LAINVD'
976: AND KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID
977: AND CP.STANDARD_TERMS = TERM.TERM_ID),
978: 0)*/
979: ) and
980: -- STE.STREAM_ELEMENT_DATE <= (NVL(p_date_to, SYSDATE) + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)) AND -- Bug 6377127
981: STE.AMOUNT <> 0 AND
1151: l_req_data VARCHAR2(10);
1152: l_req_counter NUMBER;
1153:
1154: -- Bug 4546873
1155: -- Org Id and standard who columns
1156: l_last_updated_by okl_parallel_processes.last_updated_by%TYPE := Fnd_Global.USER_ID;
1157: l_last_update_login okl_parallel_processes.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1158: l_request_id okl_parallel_processes.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1159: l_program_id okl_parallel_processes.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1369: WHERE opp.khr_id = khr.id AND RGP.ID = RULE.RGP_ID AND RGP.DNZ_CHR_ID = KHR.ID
1370: AND RGP.RGD_CODE = 'LABILL' AND RULE.RULE_INFORMATION_CATEGORY = 'LAINVD'
1371: ),
1372: (SELECT TERM.PRINTING_LEAD_DAYS FROM HZ_CUSTOMER_PROFILES CP, RA_TERMS TERM, okc_k_headers_b khr
1373: WHERE opp.khr_id = khr.id AND KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID AND CP.STANDARD_TERMS = TERM.TERM_ID)
1374: ),0)
1375: --Bug# 7701159 - Susbtitute SQL query for PL/SQL call
1376: /*NVL((SELECT NVL(RULE.RULE_INFORMATION3,TERM.PRINTING_LEAD_DAYS)
1377: FROM OKC_RULES_B RULE,
1384: AND RGP.DNZ_CHR_ID = KHR.ID
1385: AND RGP.RGD_CODE = 'LABILL'
1386: AND RULE.RULE_INFORMATION_CATEGORY = 'LAINVD'
1387: AND KHR.BILL_TO_SITE_USE_ID = CP.SITE_USE_ID
1388: AND CP.STANDARD_TERMS = TERM.TERM_ID),
1389: 0)*/
1390: -- + OKL_STREAM_BILLING_PVT.get_printing_lead_days(opp.khr_id)
1391: -- rmunjulu R12 Forward Port bug 5710903 Add ONE to account for scenario where these dates are same
1392: - nbd.earliest_strm_bill_date + 1)/30)