DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PUB dependencies on OKC_CONTRACT_PUB

Line 99: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

95: l_api_name CONSTANT VARCHAR2(30) := 'Update_Hdr_Amount';
96: l_api_version Number := 1.0;
97:
98: --Contract Header
99: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
100: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
101:
102:
103: Cursor l_line_csr Is Select Sum(Nvl(PRICE_NEGOTIATED,0))

Line 100: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

96: l_api_version Number := 1.0;
97:
98: --Contract Header
99: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
100: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
101:
102:
103: Cursor l_line_csr Is Select Sum(Nvl(PRICE_NEGOTIATED,0))
104: From OKC_K_LINES_B

Line 131: okc_contract_pub.update_contract_header

127:
128: l_chrv_tbl_in(1).id := p_chr_id;
129: l_chrv_tbl_in(1).estimated_amount := l_hdr_amount;
130:
131: okc_contract_pub.update_contract_header
132: (
133: p_api_version => l_api_version,
134: p_init_msg_list => p_init_msg_list,
135: x_return_status => x_return_status,

Line 1040: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;

1036: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type ;
1037: l_cvmv_upd_rec OKC_CVM_PVT.cvmv_rec_type ;
1038: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;
1039: l_cvmv_upd_out_rec OKC_CVM_PVT.cvmv_rec_type ;
1040: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
1041: l_chrv_upd_rec OKC_CONTRACT_PUB.chrv_rec_type;
1042: l_chrv_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
1043: l_chrv_upd_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
1044: l_e_contract_number VARCHAR2(120);

Line 1041: l_chrv_upd_rec OKC_CONTRACT_PUB.chrv_rec_type;

1037: l_cvmv_upd_rec OKC_CVM_PVT.cvmv_rec_type ;
1038: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;
1039: l_cvmv_upd_out_rec OKC_CVM_PVT.cvmv_rec_type ;
1040: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
1041: l_chrv_upd_rec OKC_CONTRACT_PUB.chrv_rec_type;
1042: l_chrv_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
1043: l_chrv_upd_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
1044: l_e_contract_number VARCHAR2(120);
1045: l_e_contract_number_mod VARCHAR2(120);

Line 1042: l_chrv_out_rec OKC_CONTRACT_PUB.chrv_rec_type;

1038: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;
1039: l_cvmv_upd_out_rec OKC_CVM_PVT.cvmv_rec_type ;
1040: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
1041: l_chrv_upd_rec OKC_CONTRACT_PUB.chrv_rec_type;
1042: l_chrv_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
1043: l_chrv_upd_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
1044: l_e_contract_number VARCHAR2(120);
1045: l_e_contract_number_mod VARCHAR2(120);
1046: l_f_chr_id NUMBER;

Line 1043: l_chrv_upd_out_rec OKC_CONTRACT_PUB.chrv_rec_type;

1039: l_cvmv_upd_out_rec OKC_CVM_PVT.cvmv_rec_type ;
1040: l_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
1041: l_chrv_upd_rec OKC_CONTRACT_PUB.chrv_rec_type;
1042: l_chrv_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
1043: l_chrv_upd_out_rec OKC_CONTRACT_PUB.chrv_rec_type;
1044: l_e_contract_number VARCHAR2(120);
1045: l_e_contract_number_mod VARCHAR2(120);
1046: l_f_chr_id NUMBER;
1047: l_terr_res VARCHAR2(3);

Line 2673: OKC_CONTRACT_PUB.update_contract_header(p_api_version => l_api_version,

2669: || l_return_status );
2670: END IF;
2671: l_chrv_rec.id := l_ctcv_rec_out_ins.dnz_chr_id;
2672: l_chrv_rec.last_update_date := sysdate;
2673: OKC_CONTRACT_PUB.update_contract_header(p_api_version => l_api_version,
2674: p_init_msg_list => OKC_API.G_TRUE,
2675: x_return_status => l_return_status,
2676: x_msg_count => l_msg_count,
2677: x_msg_data => l_msg_data,