DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_TRX_CONTRACTS_PVT

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

1017: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
1018: --Bug# 6619311
1019: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
1020: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
1021: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
1022: x_return_status OUT NOCOPY VARCHAR2,
1023: x_msg_count OUT NOCOPY NUMBER,
1024: x_msg_data OUT NOCOPY VARCHAR2) IS
1025:

Line 1027: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1023: x_msg_count OUT NOCOPY NUMBER,
1024: x_msg_data OUT NOCOPY VARCHAR2) IS
1025:
1026: -- Define PL/SQL Records and Tables
1027: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1028: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1029:
1030: -- Define variables
1031: l_sysdate DATE;

Line 1028: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1024: x_msg_data OUT NOCOPY VARCHAR2) IS
1025:
1026: -- Define PL/SQL Records and Tables
1027: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1028: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1029:
1030: -- Define variables
1031: l_sysdate DATE;
1032: l_sysdate_trunc DATE;

Line 1080: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1076: l_transaction_type VARCHAR2(256) := p_transaction_type;
1077: l_transaction_id NUMBER;
1078:
1079: --Bug# 3153003
1080: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1081: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1082:
1083: pop_trx_failed exception;
1084:

Line 1081: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1077: l_transaction_id NUMBER;
1078:
1079: --Bug# 3153003
1080: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1081: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1082:
1083: pop_trx_failed exception;
1084:
1085: --Added by dpsingh for LE uptake

Line 3177: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type

3173:
3174: PROCEDURE populate_account_data(
3175: p_api_version IN NUMBER
3176: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3177: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
3178: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
3179: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
3180: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
3181: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type

Line 3178: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type

3174: PROCEDURE populate_account_data(
3175: p_api_version IN NUMBER
3176: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3177: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
3178: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
3179: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
3180: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
3181: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type
3182: ,x_return_status OUT NOCOPY VARCHAR2

Line 3740: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

3736: AND tax_line_status_code = 'INACTIVE'
3737: AND adjusted_doc_trx_id IS NOT NULL
3738: AND adjusted_doc_trx_line_id IS NOT NULL);
3739:
3740: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3741: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3742:
3743:
3744: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;

Line 3741: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

3737: AND adjusted_doc_trx_id IS NOT NULL
3738: AND adjusted_doc_trx_line_id IS NOT NULL);
3739:
3740: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3741: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3742:
3743:
3744: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3745: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;

Line 3758: l_trxh_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

3754: counter NUMBER := 0;
3755: j NUMBER := 0;
3756: l_trx_id NUMBER;
3757: l_fnd_rec fnd_lookups_csr%ROWTYPE;
3758: l_trxh_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
3759: l_financed_sty_id NUMBER;
3760: l_capitalized_sty_id NUMBER;
3761: l_upfront_trx_exists NUMBER := 0;
3762: l_rule_info_csr rule_info_csr%ROWTYPE;

Line 5325: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5321: x_msg_count OUT NOCOPY NUMBER,
5322: x_msg_data OUT NOCOPY VARCHAR2) IS
5323:
5324: -- Define PL/SQL Records and Tables
5325: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5326: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5327: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5328: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5329:

Line 5326: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

5322: x_msg_data OUT NOCOPY VARCHAR2) IS
5323:
5324: -- Define PL/SQL Records and Tables
5325: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5326: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5327: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5328: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5329:
5330: -- Define variables

Line 5327: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5323:
5324: -- Define PL/SQL Records and Tables
5325: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5326: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5327: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5328: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5329:
5330: -- Define variables
5331: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 5328: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

5324: -- Define PL/SQL Records and Tables
5325: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5326: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5327: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5328: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5329:
5330: -- Define variables
5331: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5332: l_transaction_id NUMBER;