[Home] [Help]
7794: And (Hdr.scs_code = 'SERVICE' OR
7795: /* This code is added for warranty lines that are renewed */
7796: (Hdr.scs_code = 'WARRANTY' AND Hdr.chr_id_renewed IS not Null))
7797: And Hdr.Template_yn = 'N'
7798: And OKC_ASSENT_PUB.line_operation_allowed(line.id,'INVOICE')= 'T'
7799: And Hdr.id = p_contract_id
7800: --And Hdr.Contract_number = NVL(p_contract_number,hdr.contract_number)
7801:
7802: For Update;
8401: AND (p_termination_date <= Nvl(l_last_day_term+1,p_termination_date))
8402: AND p_termination_date <= sysdate THEN
8403:
8404: IF l_status_code in ('ACTIVE','HOLD','SIGNED','EXPIRED') then
8405: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
8406: p_status_type => 'TERMINATED',
8407: x_status_code => l_ter_status_code );
8408:
8409: IF l_return_status <> 'S' THEN
8412:
8413:
8414: l_clev_tbl_in(1).sts_code := l_ter_status_code;
8415: ELSIF l_status_code = 'ENTERED' then
8416: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
8417: p_status_type => 'CANCELLED',
8418: x_status_code => l_can_status_code);
8419:
8420: IF l_return_status <> 'S' THEN
8914: AND (p_termination_date <= Nvl(l_last_day_term+1,p_termination_date))
8915: AND p_termination_date <= sysdate THEN
8916:
8917: IF l_status in ('ACTIVE','HOLD','SIGNED','EXPIRED') then
8918: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
8919: p_status_type => 'TERMINATED',
8920: x_status_code => l_ter_status_code );
8921:
8922: IF l_return_status <> 'S' THEN
8925:
8926:
8927: l_clev_tbl_in(1).sts_code := l_ter_status_code;
8928: ELSIF l_status = 'ENTERED' then
8929: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
8930: p_status_type => 'CANCELLED',
8931: x_status_code => l_can_status_code);
8932:
8933: IF l_return_status <> 'S' THEN