DBA Data[Home] [Help]

APPS.OKC_EXTEND_PVT dependencies on OKC_CONTRACT_PUB

Line 600: p_chr_rec IN okc_contract_pub.chrv_rec_type,

596: p_init_msg_list IN VARCHAR2 ,
597: x_return_status OUT NOCOPY VARCHAR2,
598: x_msg_count OUT NOCOPY NUMBER,
599: x_msg_data OUT NOCOPY VARCHAR2,
600: p_chr_rec IN okc_contract_pub.chrv_rec_type,
601: p_new_end_date IN DATE ) is
602:
603: -- bug#5757116 added trunc in the where clause of the cursor.
604: CURSOR cur_k_lines is

Line 625: l_chr_rec okc_contract_pub.chrv_rec_type := p_chr_rec;

621: SELECT ste_code
622: FROM okc_statuses_b
623: WHERE code = p_sts_code;
624:
625: l_chr_rec okc_contract_pub.chrv_rec_type := p_chr_rec;
626: i_chr_rec okc_contract_pub.chrv_rec_type;
627:
628: l_cle_rec okc_contract_pub.clev_rec_type;
629: i_cle_rec okc_contract_pub.clev_rec_type;

Line 626: i_chr_rec okc_contract_pub.chrv_rec_type;

622: FROM okc_statuses_b
623: WHERE code = p_sts_code;
624:
625: l_chr_rec okc_contract_pub.chrv_rec_type := p_chr_rec;
626: i_chr_rec okc_contract_pub.chrv_rec_type;
627:
628: l_cle_rec okc_contract_pub.clev_rec_type;
629: i_cle_rec okc_contract_pub.clev_rec_type;
630:

Line 628: l_cle_rec okc_contract_pub.clev_rec_type;

624:
625: l_chr_rec okc_contract_pub.chrv_rec_type := p_chr_rec;
626: i_chr_rec okc_contract_pub.chrv_rec_type;
627:
628: l_cle_rec okc_contract_pub.clev_rec_type;
629: i_cle_rec okc_contract_pub.clev_rec_type;
630:
631: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
632: l_api_name constant varchar2(30) := 'update_enddate';

Line 629: i_cle_rec okc_contract_pub.clev_rec_type;

625: l_chr_rec okc_contract_pub.chrv_rec_type := p_chr_rec;
626: i_chr_rec okc_contract_pub.chrv_rec_type;
627:
628: l_cle_rec okc_contract_pub.clev_rec_type;
629: i_cle_rec okc_contract_pub.clev_rec_type;
630:
631: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
632: l_api_name constant varchar2(30) := 'update_enddate';
633: l_status_code okc_statuses_v.ste_code%type;

Line 690: OKC_CONTRACT_PUB.update_contract_header ( p_api_version => 1,

686:
687:
688: END IF;
689: END IF;
690: OKC_CONTRACT_PUB.update_contract_header ( p_api_version => 1,
691: p_init_msg_list => OKC_API.G_FALSE,
692: x_return_status => l_return_status,
693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data,

Line 752: OKC_CONTRACT_PUB.update_contract_line ( p_api_version => 1,

748: -- Bug# 1405237. Avoide calling action assembler
749: --
750: l_cle_rec.call_action_asmblr := 'N';
751:
752: OKC_CONTRACT_PUB.update_contract_line ( p_api_version => 1,
753: p_init_msg_list => OKC_API.G_FALSE,
754: x_return_status => l_return_status,
755: x_msg_count => x_msg_count,
756: x_msg_data => x_msg_data,

Line 1176: rec_k_header OKC_CONTRACT_PUB.chrv_rec_type;

1172: and trunc(start_date) = trunc(p_extend_in_parameters_rec.p_orig_start_date)
1173: and trunc(end_date) = trunc(p_extend_in_parameters_rec.p_orig_end_date)
1174: FOR UPDATE OF start_date NOWAIT;
1175:
1176: rec_k_header OKC_CONTRACT_PUB.chrv_rec_type;
1177:
1178: CURSOR lock_lines is
1179: SELECT *
1180: FROM okc_k_lines_v

Line 1545: i_cle_rec okc_contract_pub.clev_rec_type;

1541: l_kl_sts_code okc_k_lines_v.sts_code%type;
1542: l_scs_code okc_subclasses_v.code%type;
1543: l_cls_code okc_subclasses_v.cls_code%type;
1544: l_price_negotiated number;
1545: i_cle_rec okc_contract_pub.clev_rec_type;
1546: l_cle_rec okc_contract_pub.clev_rec_type;
1547: l_status varchar2(30);
1548: l_status_code okc_statuses_v.code%type;
1549:

Line 1546: l_cle_rec okc_contract_pub.clev_rec_type;

1542: l_scs_code okc_subclasses_v.code%type;
1543: l_cls_code okc_subclasses_v.cls_code%type;
1544: l_price_negotiated number;
1545: i_cle_rec okc_contract_pub.clev_rec_type;
1546: l_cle_rec okc_contract_pub.clev_rec_type;
1547: l_status varchar2(30);
1548: l_status_code okc_statuses_v.code%type;
1549:
1550:

Line 1673: OKC_CONTRACT_PUB.update_contract_line ( p_api_version => 1,

1669: --
1670: l_cle_rec.call_action_asmblr := 'N';
1671:
1672:
1673: OKC_CONTRACT_PUB.update_contract_line ( p_api_version => 1,
1674: p_init_msg_list => OKC_API.G_FALSE,
1675: x_return_status => l_return_status,
1676: x_msg_count => x_msg_count,
1677: x_msg_data => x_msg_data,