DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_TRX_CONTRACTS_PVT

Line 863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change

859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2) IS
867:

Line 869: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2) IS
867:
868: -- Define PL/SQL Records and Tables
869: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
870: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
871:
872: -- Define variables
873: l_sysdate DATE;

Line 870: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

866: x_msg_data OUT NOCOPY VARCHAR2) IS
867:
868: -- Define PL/SQL Records and Tables
869: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
870: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
871:
872: -- Define variables
873: l_sysdate DATE;
874: l_sysdate_trunc DATE;

Line 922: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

918: l_transaction_type VARCHAR2(256) := p_transaction_type;
919: l_transaction_id NUMBER;
920:
921: --Bug# 3153003
922: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
923: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
924:
925: pop_trx_failed exception;
926:

Line 923: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

919: l_transaction_id NUMBER;
920:
921: --Bug# 3153003
922: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
923: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
924:
925: pop_trx_failed exception;
926:
927: --Added by dpsingh for LE uptake

Line 2973: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type

2969:
2970: PROCEDURE populate_account_data(
2971: p_api_version IN NUMBER
2972: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2973: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
2974: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
2975: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
2976: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
2977: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type

Line 2974: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type

2970: PROCEDURE populate_account_data(
2971: p_api_version IN NUMBER
2972: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2973: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
2974: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
2975: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
2976: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
2977: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type
2978: ,x_return_status OUT NOCOPY VARCHAR2

Line 3536: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

3532: AND tax_line_status_code = 'INACTIVE'
3533: AND adjusted_doc_trx_id IS NOT NULL
3534: AND adjusted_doc_trx_line_id IS NOT NULL);
3535:
3536: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3537: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3538:
3539:
3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;

Line 3537: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

3533: AND adjusted_doc_trx_id IS NOT NULL
3534: AND adjusted_doc_trx_line_id IS NOT NULL);
3535:
3536: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3537: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3538:
3539:
3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3541: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;

Line 3554: l_trxh_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

3550: counter NUMBER := 0;
3551: j NUMBER := 0;
3552: l_trx_id NUMBER;
3553: l_fnd_rec fnd_lookups_csr%ROWTYPE;
3554: l_trxh_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
3555: l_financed_sty_id NUMBER;
3556: l_capitalized_sty_id NUMBER;
3557: l_upfront_trx_exists NUMBER := 0;
3558: l_rule_info_csr rule_info_csr%ROWTYPE;

Line 5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5117: x_msg_count OUT NOCOPY NUMBER,
5118: x_msg_data OUT NOCOPY VARCHAR2) IS
5119:
5120: -- Define PL/SQL Records and Tables
5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5125:

Line 5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

5118: x_msg_data OUT NOCOPY VARCHAR2) IS
5119:
5120: -- Define PL/SQL Records and Tables
5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5125:
5126: -- Define variables

Line 5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5119:
5120: -- Define PL/SQL Records and Tables
5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5125:
5126: -- Define variables
5127: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

5120: -- Define PL/SQL Records and Tables
5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5125:
5126: -- Define variables
5127: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5128: l_transaction_id NUMBER;