APPS.OKC_TIME_RES_PVT dependencies on OKC_K_HEADERS_B

Line 18: from okc_k_headers_b

14: x_return_status OUT NOCOPY VARCHAR2) IS
15:
16: CURSOR chr_csr(p_chr_id IN NUMBER) is
17: select start_date, end_date
18: from okc_k_headers_b
19: where id = p_chr_id;
20:
21: CURSOR cle_csr(p_cle_id IN NUMBER) is
22: select start_date, end_date

Line 1255: update okc_k_headers_b

1251: null;
1252: end loop;
1253: close rule_csr;
1254: if l_pending_further_resolving = '1' Then
1255: update okc_k_headers_b
1256: set resolved_until = p_resolved_until_date
1257: where id = l_chr_id;
1258: elsif l_over_further_resolving = '1' Then
1259: update okc_k_headers_b

Line 1259: update okc_k_headers_b

1255: update okc_k_headers_b
1256: set resolved_until = p_resolved_until_date
1257: where id = l_chr_id;
1258: elsif l_over_further_resolving = '1' Then
1259: update okc_k_headers_b
1260: set resolved_until = NULL
1261: where id = l_chr_id;
1262: end if;
1263: l_pending_further_resolving := 'X';

Line 1320: SELECT resolved_until from okc_k_headers_b h, okc_k_lines_b l

1316: where ise.id = p_tve_id;
1317:
1318:
1319: CURSOR resolved_until_csr(p_cle_id IN NUMBER) is
1320: SELECT resolved_until from okc_k_headers_b h, okc_k_lines_b l
1321: where h.id = l.chr_id
1322: and l.id = p_cle_id;
1323:
1324: l_list_of_rules VARCHAR2(4000);

Line 1505: update okc_k_headers_b

1501: <>
1502: null;
1503: end loop;
1504: if l_pending_further_resolving = '1' Then
1505: update okc_k_headers_b
1506: set resolved_until = l_resolved_until_date
1507: where id = p_chr_id;
1508: elsif l_over_further_resolving = '1' Then
1509: update okc_k_headers_b

Line 1509: update okc_k_headers_b

1505: update okc_k_headers_b
1506: set resolved_until = l_resolved_until_date
1507: where id = p_chr_id;
1508: elsif l_over_further_resolving = '1' Then
1509: update okc_k_headers_b
1510: set resolved_until = NULL
1511: where id = p_chr_id;
1512: end if;
1513: l_pending_further_resolving := 'X';

Line 1545: SELECT resolved_until from okc_k_headers_b h

1541: TYPE tve_id_csr_type is REF CURSOR;
1542: tve_id_csr tve_id_csr_type;
1543:
1544: CURSOR resolved_until_csr(p_chr_id IN NUMBER) is
1545: SELECT resolved_until from okc_k_headers_b h
1546: where h.id = p_chr_id;
1547:
1548: l_list_of_rules VARCHAR2(4000);
1549: l_list_of_rules1 VARCHAR2(4000);

Line 1674: update okc_k_headers_b

1670: FETCH resolved_until_csr INTO l_resolved_until_date;
1671: CLOSE resolved_until_csr;
1672: IF l_resolved_until_date is NOT NULL then
1673: if p_end_date <= l_resolved_until_date then
1674: update okc_k_headers_b
1675: set resolved_until = NULL
1676: where id = p_chr_id;
1677: end if;
1678: end if;

Line 1863: SELECT contract_number, id, resolved_until from OKC_K_HEADERS_B

1859: END Create_Res_Time_N_Tasks;
1860:
1861: PROCEDURE Batch_Resolve_Time_N_Tasks IS
1862: CURSOR c_chr IS
1863: SELECT contract_number, id, resolved_until from OKC_K_HEADERS_B
1864: where resolved_until < add_months(sysdate, OKC_TIME_RES_PVT.PICKUP_UPTO_MONTHS)
1865: and resolved_until >= sysdate;
1866: x_return_status VARCHAR2(1);
1867: l_init_msg_list VARCHAR2(1) := 'F';