APPS.OKL_AM_VENDOR_RES_SHARE_PVT dependencies on OKL_TRX_ASSETS

Line 721: lp_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

717: l_tplv_rec OKL_TPL_PVT.tplv_rec_type;
718: x_tplv_rec OKL_TPL_PVT.tplv_rec_type;
719:
720: l_add_params OKL_EXECUTE_FORMULA_PUB.ctxt_val_tbl_type;
721: lp_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
722: lx_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
723: lp_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
724: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
725: l_share_formula VARCHAR2(300);

Line 722: lx_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

718: x_tplv_rec OKL_TPL_PVT.tplv_rec_type;
719:
720: l_add_params OKL_EXECUTE_FORMULA_PUB.ctxt_val_tbl_type;
721: lp_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
722: lx_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
723: lp_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
724: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
725: l_share_formula VARCHAR2(300);
726: l_request_id NUMBER;

Line 1007: -- create header transaction record in okl_trx_assets

1003:
1004: RAISE OKL_API.G_EXCEPTION_ERROR;
1005: END IF;
1006:
1007: -- create header transaction record in okl_trx_assets
1008: lp_thpv_rec.tas_type := 'VRS'; -- new lookup seeded
1009: lp_thpv_rec.tsu_code := 'PROCESSED';
1010: lp_thpv_rec.try_id := l_residual_shr_try_id;
1011: lp_thpv_rec.date_trans_occurred := sysdate;

Line 1013: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

1009: lp_thpv_rec.tsu_code := 'PROCESSED';
1010: lp_thpv_rec.try_id := l_residual_shr_try_id;
1011: lp_thpv_rec.date_trans_occurred := sysdate;
1012:
1013: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
1014: p_api_version => p_api_version,
1015: p_init_msg_list => OKL_API.G_FALSE,
1016: x_return_status => l_return_status,
1017: x_msg_count => x_msg_count,

Line 1137: -- Insert transaction in transaction tables okl_trx_assets and okl_txl_assets

1133: END IF;
1134:
1135: /* 29-JAN-2007 ANSETHUR BUILD: R12 B DISBURSEMENT End changes */
1136:
1137: -- Insert transaction in transaction tables okl_trx_assets and okl_txl_assets
1138: lp_tlpv_rec.currency_code := l_contract_currency_code;
1139: lp_tlpv_rec.tas_id := lx_thpv_rec.id;
1140: lp_tlpv_rec.kle_id := l_kle_rec.id;
1141: lp_tlpv_rec.line_number := 1;

Line 1309: FROM OKL_TRX_ASSETS TAS,

1305:
1306: -- Asset is not Securitized is checked once the asset is obtained
1307: AND CLE.id NOT IN (-- residual share already done for that retirement transaction
1308: SELECT TAL.kle_id
1309: FROM OKL_TRX_ASSETS TAS,
1310: OKL_TXL_ASSETS_B TAL
1311: WHERE TAL.kle_id = CLE.id
1312: AND TAL.tas_id = TAS.id
1313: AND TAS.tas_type = 'VRS'

Line 1796: OKL_TRX_ASSETS TAS,

1792: FROM OKC_K_LINES_V CLE,
1793: OKC_K_HEADERS_B CHR,
1794: OKC_K_HEADERS_B VPA,
1795: OKL_K_HEADERS KHR,
1796: OKL_TRX_ASSETS TAS,
1797: OKL_TXL_ASSETS_B TAL,
1798: OKL_PARTY_PAYMENT_DTLS_UV PPD
1799: WHERE TAL.TAS_ID = TAS.ID
1800: AND TAS.TAS_TYPE = 'VRS'

Line 1871: l_from_sql_1 := ' FROM OKC_K_LINES_V CLE,OKC_K_HEADERS_B CHR,OKC_K_HEADERS_B VPA,OKL_K_HEADERS KHR,OKL_TRX_ASSETS TAS,OKL_TXL_ASSETS_B TAL,OKL_PARTY_PAYMENT_DTLS_UV PPD';

1867: l_api_version := TO_NUMBER(p_api_version);
1868:
1869: l_select_sql_1 := ' SELECT VPA.contract_number PROGRAM_AGREEMENT,CLE.name ASSET_NUMBER,CLE.item_description ASSET_DESCRIPTION,CHR.contract_number CONTRACT_NUMBER, ';
1870: l_select_sql_2 := ' CLE.date_terminated ASSET_TERMINATION_DATE,PPD.vendor_name VENDOR, TAL.fa_trx_date, TAL.residual_shr_amount ||' || ''' ''' || '|| TAL.currency_code VENDOR_SHARE';
1871: l_from_sql_1 := ' FROM OKC_K_LINES_V CLE,OKC_K_HEADERS_B CHR,OKC_K_HEADERS_B VPA,OKL_K_HEADERS KHR,OKL_TRX_ASSETS TAS,OKL_TXL_ASSETS_B TAL,OKL_PARTY_PAYMENT_DTLS_UV PPD';
1872: l_where_sql_1 := ' WHERE TAL.TAS_ID = TAS.ID AND TAS.TAS_TYPE = '||'''VRS'''||' AND TAL.TAL_TYPE = '||'''VRS'''||' ';
1873: l_where_sql_2 := ' AND TAL.KLE_ID = CLE.ID AND CLE.CHR_ID = CHR.ID AND CHR.ID = KHR.ID AND KHR.KHR_ID = VPA.ID AND PPD.CPL_ID = TAL.RESIDUAL_SHR_PARTY_ID ';
1874:
1875: l_total_sql := l_select_sql_1 || l_select_sql_2 ||