eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_K_PARTY_ROLES

Line 1247: -- FUNCTION get_rec for: OKL_K_PARTY_ROLES

1243: END get_ppydv_rec;
1244:
1245: --Bug# 4558486
1246: ---------------------------------------------------------------------------
1247: -- FUNCTION get_rec for: OKL_K_PARTY_ROLES
1248: ---------------------------------------------------------------------------
1249: FUNCTION get_kplv_rec (
1250: p_kplv_rec IN kplv_rec_type,
1251: x_no_data_found OUT NOCOPY BOOLEAN

Line 1253: CURSOR okl_k_party_roles_v_pk_csr (p_id IN NUMBER) IS

1249: FUNCTION get_kplv_rec (
1250: p_kplv_rec IN kplv_rec_type,
1251: x_no_data_found OUT NOCOPY BOOLEAN
1252: ) RETURN kplv_rec_type IS
1253: CURSOR okl_k_party_roles_v_pk_csr (p_id IN NUMBER) IS
1254: SELECT
1255: ID,
1256: OBJECT_VERSION_NUMBER,
1257: ATTRIBUTE_CATEGORY,

Line 1278: FROM Okl_K_Party_Roles_V

1274: CREATION_DATE,
1275: LAST_UPDATED_BY,
1276: LAST_UPDATE_DATE,
1277: LAST_UPDATE_LOGIN
1278: FROM Okl_K_Party_Roles_V
1279: WHERE okl_k_party_roles_v.id = p_id;
1280: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1281: l_kplv_rec kplv_rec_type;
1282: BEGIN

Line 1279: WHERE okl_k_party_roles_v.id = p_id;

1275: LAST_UPDATED_BY,
1276: LAST_UPDATE_DATE,
1277: LAST_UPDATE_LOGIN
1278: FROM Okl_K_Party_Roles_V
1279: WHERE okl_k_party_roles_v.id = p_id;
1280: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1281: l_kplv_rec kplv_rec_type;
1282: BEGIN
1283: x_no_data_found := TRUE;

Line 1280: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;

1276: LAST_UPDATE_DATE,
1277: LAST_UPDATE_LOGIN
1278: FROM Okl_K_Party_Roles_V
1279: WHERE okl_k_party_roles_v.id = p_id;
1280: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1281: l_kplv_rec kplv_rec_type;
1282: BEGIN
1283: x_no_data_found := TRUE;
1284: -- Get current database values

Line 1285: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);

1281: l_kplv_rec kplv_rec_type;
1282: BEGIN
1283: x_no_data_found := TRUE;
1284: -- Get current database values
1285: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);
1286: FETCH okl_k_party_roles_v_pk_csr INTO
1287: l_kplv_rec.id,
1288: l_kplv_rec.object_version_number,
1289: l_kplv_rec.attribute_category,

Line 1286: FETCH okl_k_party_roles_v_pk_csr INTO

1282: BEGIN
1283: x_no_data_found := TRUE;
1284: -- Get current database values
1285: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);
1286: FETCH okl_k_party_roles_v_pk_csr INTO
1287: l_kplv_rec.id,
1288: l_kplv_rec.object_version_number,
1289: l_kplv_rec.attribute_category,
1290: l_kplv_rec.attribute1,

Line 1310: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;

1306: l_kplv_rec.creation_date,
1307: l_kplv_rec.last_updated_by,
1308: l_kplv_rec.last_update_date,
1309: l_kplv_rec.last_update_login;
1310: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;
1311: CLOSE okl_k_party_roles_v_pk_csr;
1312: RETURN(l_kplv_rec);
1313: END get_kplv_rec;
1314: ------------------------------------------------------------------

Line 1311: CLOSE okl_k_party_roles_v_pk_csr;

1307: l_kplv_rec.last_updated_by,
1308: l_kplv_rec.last_update_date,
1309: l_kplv_rec.last_update_login;
1310: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;
1311: CLOSE okl_k_party_roles_v_pk_csr;
1312: RETURN(l_kplv_rec);
1313: END get_kplv_rec;
1314: ------------------------------------------------------------------
1315: -- This version of get_rec sets error messages if no data found --

Line 1659: Procedure copy_okl_k_party_roles

1655: '_PVT');
1656: End copy_party_pymt_dtls;
1657:
1658: --Bug# 4558486
1659: Procedure copy_okl_k_party_roles
1660: (p_api_version IN NUMBER,
1661: p_init_msg_list IN VARCHAR2 ,
1662: x_return_status OUT NOCOPY VARCHAR2,
1663: x_msg_count OUT NOCOPY NUMBER,

Line 1674: l_api_name CONSTANT varchar2(30) := 'COPY_OKL_K_PARTY_ROLES';

1670: l_kplv_rec kplv_rec_type;
1671: lx_kplv_rec kplv_rec_type;
1672:
1673: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
1674: l_api_name CONSTANT varchar2(30) := 'COPY_OKL_K_PARTY_ROLES';
1675: l_api_version CONSTANT NUMBER := 1.0;
1676:
1677: Begin
1678: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1748: End copy_okl_k_party_roles;

1744: 'OTHERS',
1745: x_msg_count,
1746: x_msg_data,
1747: '_PVT');
1748: End copy_okl_k_party_roles;
1749: --Bug# 4558486
1750: --Bug# 3143522: 11.5.10 Subsidies
1751: --------------------------------------------------------------------------------
1752: -- Start of comments

Line 3915: from okl_k_party_roles kpl

3911:
3912: --Bug# 4558486
3913: Cursor l_kpl_csr (p_cpl_id in number) is
3914: Select kpl.id
3915: from okl_k_party_roles kpl
3916: where kpl.id = p_cpl_id;
3917:
3918: lx_kpl_id okl_k_party_roles.ID%TYPE;
3919:

Line 3918: lx_kpl_id okl_k_party_roles.ID%TYPE;

3914: Select kpl.id
3915: from okl_k_party_roles kpl
3916: where kpl.id = p_cpl_id;
3917:
3918: lx_kpl_id okl_k_party_roles.ID%TYPE;
3919:
3920: BEGIN
3921: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
3922: G_PKG_NAME,

Line 3986: copy_okl_k_party_roles

3982:
3983: --Bug# 4558486
3984: For l_kpl_rec in l_kpl_csr(p_cpl_id => p_cpl_id)
3985: Loop
3986: copy_okl_k_party_roles
3987: (p_api_version => p_api_version,
3988: p_init_msg_list => p_init_msg_list,
3989: x_return_status => x_return_status,
3990: x_msg_count => x_msg_count,

Line 5573: -- For okl_k_party_roles begin

5569:
5570: TYPE l_txl_id_mapping_type IS RECORD (old_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM);
5571: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;
5572:
5573: -- For okl_k_party_roles begin
5574: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5575: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5576: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;

Line 5574: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;

5570: TYPE l_txl_id_mapping_type IS RECORD (old_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM, new_id okl_txl_assets_b.id%TYPE := OKC_API.G_MISS_NUM);
5571: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;
5572:
5573: -- For okl_k_party_roles begin
5574: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5575: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5576: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;

Line 5575: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;

5571: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;
5572:
5573: -- For okl_k_party_roles begin
5574: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5575: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5576: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;

Line 5576: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;

5572:
5573: -- For okl_k_party_roles begin
5574: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5575: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5576: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;

Line 5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;

5573: -- For okl_k_party_roles begin
5574: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5575: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5576: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;

Line 5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;

5574: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5575: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5576: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;

Line 5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;

5575: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5576: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;

Line 5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;

5576: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;

Line 5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;

5577: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;

Line 5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;

5578: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;

Line 5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;

5579: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;

Line 5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;

5580: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;

Line 5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;

5581: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5589: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;

Line 5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;

5582: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5589: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5590: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;

Line 5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;

5583: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5589: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5590: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5591: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;

Line 5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;

5584: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5589: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5590: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5591: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5592: -- For okl_k_party_roles end

Line 5589: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;

5585: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5589: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5590: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5591: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5592: -- For okl_k_party_roles end
5593:

Line 5590: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;

5586: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5589: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5590: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5591: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5592: -- For okl_k_party_roles end
5593:
5594: -- For party_roles_tl Begin

Line 5591: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;

5587: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5589: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5590: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5591: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5592: -- For okl_k_party_roles end
5593:
5594: -- For party_roles_tl Begin
5595: TYPE l_pid_type IS TABLE OF okc_k_party_roles_tl.id%TYPE INDEX BY BINARY_INTEGER;

Line 5592: -- For okl_k_party_roles end

5588: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5589: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5590: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5591: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5592: -- For okl_k_party_roles end
5593:
5594: -- For party_roles_tl Begin
5595: TYPE l_pid_type IS TABLE OF okc_k_party_roles_tl.id%TYPE INDEX BY BINARY_INTEGER;
5596: TYPE l_planguage_type IS TABLE OF okc_k_party_roles_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;

Line 6288: -- For okl_k_party_roles Begin

6284: l_supp_invoice_dtls_counter NUMBER := 1;
6285:
6286: -- For okl_supp_invlice_dtls End
6287:
6288: -- For okl_k_party_roles Begin
6289: l_plid_tab l_plid_type;
6290: l_plobject_version_number_tab l_plobject_version_number_type;
6291: l_plattribute_category_tab l_plattribute_category_type;
6292: l_plattribute1_tab l_plattribute1_type;

Line 6308: l_okl_k_party_roles_counter number := 1;

6304: l_plattribute13_tab l_plattribute13_type;
6305: l_plattribute14_tab l_plattribute14_type;
6306: l_plattribute15_tab l_plattribute15_type;
6307:
6308: l_okl_k_party_roles_counter number := 1;
6309:
6310: -- For okl_k_party_roles End
6311:
6312: -- For party_roles_tl Begin

Line 6310: -- For okl_k_party_roles End

6306: l_plattribute15_tab l_plattribute15_type;
6307:
6308: l_okl_k_party_roles_counter number := 1;
6309:
6310: -- For okl_k_party_roles End
6311:
6312: -- For party_roles_tl Begin
6313: l_pid_tab l_pid_type;
6314: l_planguage_tab l_planguage_type;

Line 11720: PROCEDURE prepare_okl_party_roles (p_old_id IN okl_k_party_roles.id%TYPE,

11716: END LOOP;
11717: RETURN -1;
11718: END; /* find_party_mapping_id */
11719:
11720: PROCEDURE prepare_okl_party_roles (p_old_id IN okl_k_party_roles.id%TYPE,
11721: p_new_id IN okl_k_party_roles.id%TYPE,
11722: p_flush IN VARCHAR2) IS
11723: CURSOR c30(p_id okl_k_party_roles.id%TYPE) IS
11724: SELECT

Line 11721: p_new_id IN okl_k_party_roles.id%TYPE,

11717: RETURN -1;
11718: END; /* find_party_mapping_id */
11719:
11720: PROCEDURE prepare_okl_party_roles (p_old_id IN okl_k_party_roles.id%TYPE,
11721: p_new_id IN okl_k_party_roles.id%TYPE,
11722: p_flush IN VARCHAR2) IS
11723: CURSOR c30(p_id okl_k_party_roles.id%TYPE) IS
11724: SELECT
11725: a.id, a.object_version_number, a.attribute_category,

Line 11723: CURSOR c30(p_id okl_k_party_roles.id%TYPE) IS

11719:
11720: PROCEDURE prepare_okl_party_roles (p_old_id IN okl_k_party_roles.id%TYPE,
11721: p_new_id IN okl_k_party_roles.id%TYPE,
11722: p_flush IN VARCHAR2) IS
11723: CURSOR c30(p_id okl_k_party_roles.id%TYPE) IS
11724: SELECT
11725: a.id, a.object_version_number, a.attribute_category,
11726: a.attribute1, a.attribute2, a.attribute3,
11727: a.attribute4, a.attribute5, a.attribute6,

Line 11731: FROM okl_k_party_roles a

11727: a.attribute4, a.attribute5, a.attribute6,
11728: a.attribute7, a.attribute8, a.attribute9,
11729: a.attribute10, a.attribute11, a.attribute12,
11730: a.attribute13, a.attribute14, a.attribute15
11731: FROM okl_k_party_roles a
11732: WHERE id = p_id;
11733:
11734: l_plid_tab2 l_plid_type;
11735: l_plobject_version_number_tab2 l_plobject_version_number_type;

Line 11773: l_plid_tab(l_okl_k_party_roles_counter) := l_plid_tab2(i);

11769: EXIT WHEN l_plid_tab2.COUNT = 0;
11770:
11771: FOR i IN l_plid_tab2.first..l_plid_tab2.last
11772: LOOP
11773: l_plid_tab(l_okl_k_party_roles_counter) := l_plid_tab2(i);
11774: -- Replace id
11775: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11776:
11777: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);

Line 11775: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;

11771: FOR i IN l_plid_tab2.first..l_plid_tab2.last
11772: LOOP
11773: l_plid_tab(l_okl_k_party_roles_counter) := l_plid_tab2(i);
11774: -- Replace id
11775: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11776:
11777: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11778: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11779: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);

Line 11777: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);

11773: l_plid_tab(l_okl_k_party_roles_counter) := l_plid_tab2(i);
11774: -- Replace id
11775: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11776:
11777: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11778: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11779: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11780: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);

Line 11778: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);

11774: -- Replace id
11775: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11776:
11777: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11778: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11779: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11780: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);

Line 11779: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);

11775: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11776:
11777: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11778: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11779: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11780: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);

Line 11780: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);

11776:
11777: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11778: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11779: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11780: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);

Line 11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);

11777: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11778: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11779: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11780: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);

Line 11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);

11778: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11779: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11780: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);

Line 11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);

11779: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11780: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);

Line 11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);

11780: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);

Line 11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);

11781: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);

Line 11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);

11782: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11790: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);

Line 11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);

11783: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11790: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11791: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);

Line 11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);

11784: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11790: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11791: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11792: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);

Line 11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);

11785: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11790: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11791: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11792: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11793: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);

Line 11790: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);

11786: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11790: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11791: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11792: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11793: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11794:

Line 11791: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);

11787: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11790: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11791: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11792: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11793: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11794:
11795: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;

Line 11792: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);

11788: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11790: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11791: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11792: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11793: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11794:
11795: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;
11796:

Line 11793: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);

11789: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11790: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11791: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11792: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11793: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11794:
11795: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;
11796:
11797: END LOOP;

Line 11795: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;

11791: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11792: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11793: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11794:
11795: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;
11796:
11797: END LOOP;
11798:
11799: END LOOP;

Line 11804: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_okl_k_party_roles_counter='|| l_okl_k_party_roles_counter || ' l_plid_tab.count='|| l_plid_tab.COUNT);

11800: CLOSE c30;
11801:
11802: IF (p_flush = 'Y') THEN
11803: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
11804: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_okl_k_party_roles_counter='|| l_okl_k_party_roles_counter || ' l_plid_tab.count='|| l_plid_tab.COUNT);
11805: END IF;
11806: IF (l_plid_tab.COUNT > 0) THEN
11807: forall i IN l_plid_tab.first..l_plid_tab.last
11808: INSERT INTO okl_k_party_roles (

Line 11808: INSERT INTO okl_k_party_roles (

11804: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_okl_k_party_roles_counter='|| l_okl_k_party_roles_counter || ' l_plid_tab.count='|| l_plid_tab.COUNT);
11805: END IF;
11806: IF (l_plid_tab.COUNT > 0) THEN
11807: forall i IN l_plid_tab.first..l_plid_tab.last
11808: INSERT INTO okl_k_party_roles (
11809: id, object_version_number, attribute_category,
11810: attribute1, attribute2, attribute3,
11811: attribute4, attribute5, attribute6,
11812: attribute7, attribute8, attribute9,