DBA Data[Home] [Help]

APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_CONTRACT_PUB

Line 39: l_line := okc_contract_pub.get_concat_line_no(p_cle_id,

35: l_token4_value Varchar2(200) := p_token4_value;
36: l_return_status Varchar2(3);
37: BEGIN
38: If p_cle_id Is Not Null Then
39: l_line := okc_contract_pub.get_concat_line_no(p_cle_id,
40: l_return_status);
41: If p_token1 = g_line Then
42: l_token1_value := l_line;
43: Elsif p_token2 = g_line Then

Line 1827: l_line_name := okc_contract_pub.get_concat_line_no(l_cle_rec.id, l_return_status);

1823: END IF;
1824: --at below if statement,added second condition for bug#3339185
1825: If (Instr(l_error_number, '1') > 0 or Instr(l_error_number, '2') > 0) Then
1826: x_return_status := OKC_API.G_RET_STS_ERROR;
1827: l_line_name := okc_contract_pub.get_concat_line_no(l_cle_rec.id, l_return_status);
1828: IF l_return_status <> okc_api.g_ret_sts_success THEN
1829: l_line_name := 'Unknown';
1830: END IF;
1831:

Line 1929: l_line_name := okc_contract_pub.get_concat_line_no(l_id_tbl(i), l_return_status);

1925: END IF;
1926: --at below if statement,added second condition for bug#3339185
1927: If (Instr(l_error_number, '1') > 0 or Instr(l_error_number, '2') > 0) Then
1928: x_return_status := OKC_API.G_RET_STS_ERROR;
1929: l_line_name := okc_contract_pub.get_concat_line_no(l_id_tbl(i), l_return_status);
1930: IF l_return_status <> okc_api.g_ret_sts_success THEN
1931: l_line_name := 'Unknown';
1932: END IF;
1933: