[Home] [Help]
7762: And (Hdr.scs_code = 'SERVICE' OR
7763: /* This code is added for warranty lines that are renewed */
7764: (Hdr.scs_code = 'WARRANTY' AND Hdr.chr_id_renewed IS not Null))
7765: And Hdr.Template_yn = 'N'
7766: And OKC_ASSENT_PUB.line_operation_allowed(line.id,'INVOICE')= 'T'
7767: And Hdr.id = p_contract_id
7768: --And Hdr.Contract_number = NVL(p_contract_number,hdr.contract_number)
7769:
7770: For Update;
8364: AND (p_termination_date <= Nvl(l_last_day_term+1,p_termination_date))
8365: AND p_termination_date <= sysdate THEN
8366:
8367: IF l_status_code in ('ACTIVE','HOLD','SIGNED','EXPIRED') then
8368: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
8369: p_status_type => 'TERMINATED',
8370: x_status_code => l_ter_status_code );
8371:
8372: IF l_return_status <> 'S' THEN
8375:
8376:
8377: l_clev_tbl_in(1).sts_code := l_ter_status_code;
8378: ELSIF l_status_code = 'ENTERED' then
8379: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
8380: p_status_type => 'CANCELLED',
8381: x_status_code => l_can_status_code);
8382:
8383: IF l_return_status <> 'S' THEN
8872: AND (p_termination_date <= Nvl(l_last_day_term+1,p_termination_date))
8873: AND p_termination_date <= sysdate THEN
8874:
8875: IF l_status in ('ACTIVE','HOLD','SIGNED','EXPIRED') then
8876: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
8877: p_status_type => 'TERMINATED',
8878: x_status_code => l_ter_status_code );
8879:
8880: IF l_return_status <> 'S' THEN
8883:
8884:
8885: l_clev_tbl_in(1).sts_code := l_ter_status_code;
8886: ELSIF l_status = 'ENTERED' then
8887: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
8888: p_status_type => 'CANCELLED',
8889: x_status_code => l_can_status_code);
8890:
8891: IF l_return_status <> 'S' THEN