APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_OPERATION_LINES

Line 1481: FROM okc_operation_lines

1477: -- If the new_chrId is from a renewed contract this cursor will return a record.
1478: -- It will not return any records if new_chrId is from a copied contract.
1479: Cursor got_renewed(new_chrId number) IS
1480: SELECT subject_chr_id new_chr_id
1481: FROM okc_operation_lines
1482: WHERE subject_chr_id =new_chrId;
1483:
1484: -- gets old and new item instance
1485: Cursor get_item_instance(chrId number, cleId number) IS

Line 1500: -- Renewed contracts have a record in okc_operation_lines

1496:
1497: Begin
1498: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1499: l_intent := p_intent; --'RENEW' or NULL
1500: -- Renewed contracts have a record in okc_operation_lines
1501: If p_intent is null then
1502: open got_renewed(p_new_chr_id);
1503: Fetch got_renewed into l_temp;
1504: If got_renewed%NOTFOUND Then

Line 2672: FROM okc_operation_lines

2668: --get_old_chr_id_rec get_old_chr_id_csr%ROWTYPE;
2669:
2670: Cursor got_renewed(l_new_chr_id number) IS
2671: SELECT object_chr_id old_chr_id
2672: FROM okc_operation_lines
2673: WHERE subject_chr_id =l_new_chr_id and object_chr_id is not null;
2674:
2675: Cursor is_terminated(l_old_chr_id number) IS
2676: select line_number

Line 4667: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c

4663: x_msg_data OUT NOCOPY VARCHAR2) IS
4664:
4665: CURSOR cur_has_lines_been_renewed_h IS -- header
4666: SELECT 1
4667: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c
4668: where a.object_chr_id= p_chr_id and
4669: c.id=b.cop_id and
4670: c.opn_code in('RENEWAL', 'REN_CON') and
4671: a.oie_id=b.id and

Line 4677: FROM okc_operation_lines a,

4673:
4674:
4675: CURSOR cur_has_lines_been_renewed_l IS -- topline
4676: SELECT subject_cle_id
4677: FROM okc_operation_lines a,
4678: okc_operation_instances b,
4679: okc_class_operations c,
4680: okc_k_lines_b d
4681: where a.object_cle_id = d.id and

Line 4693: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c

4689:
4690:
4691: CURSOR cur_has_lines_been_renewed_s IS -- Subline
4692: SELECT subject_chr_id
4693: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c
4694: where a.object_cle_id= p_cle_id and -- subline id
4695: c.id=b.cop_id and
4696: c.opn_code in('RENEWAL', 'REN_CON') and
4697: a.oie_id=b.id and

Line 4709: l_sub_cle_id okc_operation_lines.subject_cle_id%TYPE;

4705: From okc_k_headers_b b
4706: where id = p_subject_chr_id;
4707:
4708: l_result NUMBER;
4709: l_sub_cle_id okc_operation_lines.subject_cle_id%TYPE;
4710: l_sub_chr_id okc_operation_lines.subject_chr_id%TYPE;
4711: l_contract_number OKC_K_HEADERS_B.contract_number%type;
4712: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type;
4713:

Line 4710: l_sub_chr_id okc_operation_lines.subject_chr_id%TYPE;

4706: where id = p_subject_chr_id;
4707:
4708: l_result NUMBER;
4709: l_sub_cle_id okc_operation_lines.subject_cle_id%TYPE;
4710: l_sub_chr_id okc_operation_lines.subject_chr_id%TYPE;
4711: l_contract_number OKC_K_HEADERS_B.contract_number%type;
4712: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type;
4713:
4714: BEGIN