APPS.OKS_MASS_UPD_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 285: FROM okc_k_headers_all_b

281: IF l_mass_update_eff_tbl(i).sub_line_id IS NULL THEN
282:
283: SELECT start_date, end_date
284: INTO l_k_start_date, l_k_end_date
285: FROM okc_k_headers_all_b
286: where id = l_mass_update_eff_tbl(i).chr_id;
287:
288: IF (l_mass_update_eff_tbl(i)
289: .start_date < l_k_start_date OR l_mass_update_eff_tbl(i)

Line 349: FROM okc_k_headers_all_b

345: END IF;
346:
347: SELECT start_date, end_date
348: INTO l_k_start_date, l_k_end_date
349: FROM okc_k_headers_all_b
350: WHERE id = l_mass_update_eff_tbl(i).chr_id;
351:
352: IF (l_mass_update_eff_tbl(i)
353: .start_date < l_k_start_date OR l_mass_update_eff_tbl(i)

Line 429: FROM okc_k_headers_all_b

425: l_k_n_display VARCHAR2(240);
426:
427: CURSOR k_details_csr IS
428: SELECT Decode(contract_number_modifier, NULL, contract_number, contract_number ||' - '||contract_number_modifier) contract_number
429: FROM okc_k_headers_all_b
430: WHERE id = p_contract_id;
431:
432: BEGIN
433: --retcode := 2; --0 for success, 1 for warning, 2 for error

Line 513: FROM okc_k_headers_all_b

509: x_msg_count OUT NOCOPY NUMBER) IS
510:
511: CURSOR header_details(p_contract_id NUMBER) IS
512: SELECT authoring_org_id, inv_organization_id
513: FROM okc_k_headers_all_b
514: WHERE id = p_contract_id;
515:
516: cursor cur_line(p_subline_id in number) is
517: SELECT cleb.price_negotiated, kln.tax_amount

Line 1305: FROM okc_k_headers_all_b

1301:
1302:
1303: CURSOR header_details(p_contract_id NUMBER) IS
1304: SELECT authoring_org_id, inv_organization_id
1305: FROM okc_k_headers_all_b
1306: WHERE id = p_contract_id;
1307:
1308: Cursor ste_code_csr(p_sts_code in varchar2) is
1309: select ste_code from okc_statuses_b where code = p_sts_code;

Line 1569: FROM okc_k_headers_all_b

1565: L_GET_TOP_LINE_DATE_REC L_GET_TOP_LINE_DATE_CSR%ROWTYPE;
1566:
1567: CURSOR L_GET_HDR_DATES_CSR(P_HDR_ID IN NUMBER) IS
1568: SELECT TRUNC(START_DATE) START_DATE, TRUNC(END_DATE) END_DATE
1569: FROM okc_k_headers_all_b
1570: WHERE ID = P_HDR_ID;
1571:
1572: L_GET_HDR_DATES_REC L_GET_HDR_DATES_CSR%ROWTYPE;
1573:

Line 1701: FROM okc_k_headers_all_b

1697: exception_yn := 'N'; -- Defaulting value
1698: fnd_file.put_line (fnd_file.log, l_api_name || ', Checking Contract Line Effectivity for line number: ' || p_line_number);
1699: SELECT start_date, end_date
1700: INTO l_k_start_date, l_k_end_date
1701: FROM okc_k_headers_all_b
1702: where id = p_chr_id;
1703:
1704: IF (p_start_date < l_k_start_date OR p_start_date > l_k_end_date) THEN
1705: UPDATE oks_lines_temp

Line 1801: FROM okc_k_headers_all_b

1797: END IF;
1798:
1799: SELECT start_date, end_date
1800: INTO l_k_start_date, l_k_end_date
1801: FROM okc_k_headers_all_b
1802: WHERE id = l_chr_id;
1803:
1804: IF (p_start_date < l_k_start_date OR p_start_date > l_k_end_date) THEN
1805:

Line 2781: FROM okc_k_headers_all_b

2777: SYSDATE,
2778: FND_GLOBAL.USER_ID,
2779: SYSDATE,
2780: FND_GLOBAL.LOGIN_ID
2781: FROM okc_k_headers_all_b
2782: WHERE id = p_contract_id;
2783:
2784: INSERT INTO oks_lines_temp
2785: (id,id_char,

Line 3445: FROM okc_k_headers_all_b WHERE ID = p_contract_id AND rownum=1))

3441: CURSOR c_modified IS
3442: WITH a AS (select Nvl(PRECISION,2) prc
3443: from FND_CURRENCIES c
3444: where currency_code = (SELECT currency_code
3445: FROM okc_k_headers_all_b WHERE ID = p_contract_id AND rownum=1))
3446: SELECT tmp.id,
3447: Decode(tmp.start_date, lin.start_date, 'N', 'Y') start_date_change,
3448: Decode(tmp.end_date, lin.end_date, 'N', 'Y') end_date_change,
3449: Decode(Round(tmp.price_negotiated,(SELECT prc FROM a)), Round(lin.price_negotiated,(SELECT prc FROM a)), 'N', 'Y') Price_change,