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 1229: -- FUNCTION get_rec for: OKL_K_PARTY_ROLES

1225: END get_ppydv_rec;
1226:
1227: --Bug# 4558486
1228: ---------------------------------------------------------------------------
1229: -- FUNCTION get_rec for: OKL_K_PARTY_ROLES
1230: ---------------------------------------------------------------------------
1231: FUNCTION get_kplv_rec (
1232: p_kplv_rec IN kplv_rec_type,
1233: x_no_data_found OUT NOCOPY BOOLEAN

Line 1235: CURSOR okl_k_party_roles_v_pk_csr (p_id IN NUMBER) IS

1231: FUNCTION get_kplv_rec (
1232: p_kplv_rec IN kplv_rec_type,
1233: x_no_data_found OUT NOCOPY BOOLEAN
1234: ) RETURN kplv_rec_type IS
1235: CURSOR okl_k_party_roles_v_pk_csr (p_id IN NUMBER) IS
1236: SELECT
1237: ID,
1238: OBJECT_VERSION_NUMBER,
1239: ATTRIBUTE_CATEGORY,

Line 1260: FROM Okl_K_Party_Roles_V

1256: CREATION_DATE,
1257: LAST_UPDATED_BY,
1258: LAST_UPDATE_DATE,
1259: LAST_UPDATE_LOGIN
1260: FROM Okl_K_Party_Roles_V
1261: WHERE okl_k_party_roles_v.id = p_id;
1262: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1263: l_kplv_rec kplv_rec_type;
1264: BEGIN

Line 1261: WHERE okl_k_party_roles_v.id = p_id;

1257: LAST_UPDATED_BY,
1258: LAST_UPDATE_DATE,
1259: LAST_UPDATE_LOGIN
1260: FROM Okl_K_Party_Roles_V
1261: WHERE okl_k_party_roles_v.id = p_id;
1262: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1263: l_kplv_rec kplv_rec_type;
1264: BEGIN
1265: x_no_data_found := TRUE;

Line 1262: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;

1258: LAST_UPDATE_DATE,
1259: LAST_UPDATE_LOGIN
1260: FROM Okl_K_Party_Roles_V
1261: WHERE okl_k_party_roles_v.id = p_id;
1262: l_okl_k_party_roles_v_pk okl_k_party_roles_v_pk_csr%ROWTYPE;
1263: l_kplv_rec kplv_rec_type;
1264: BEGIN
1265: x_no_data_found := TRUE;
1266: -- Get current database values

Line 1267: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);

1263: l_kplv_rec kplv_rec_type;
1264: BEGIN
1265: x_no_data_found := TRUE;
1266: -- Get current database values
1267: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);
1268: FETCH okl_k_party_roles_v_pk_csr INTO
1269: l_kplv_rec.id,
1270: l_kplv_rec.object_version_number,
1271: l_kplv_rec.attribute_category,

Line 1268: FETCH okl_k_party_roles_v_pk_csr INTO

1264: BEGIN
1265: x_no_data_found := TRUE;
1266: -- Get current database values
1267: OPEN okl_k_party_roles_v_pk_csr (p_kplv_rec.id);
1268: FETCH okl_k_party_roles_v_pk_csr INTO
1269: l_kplv_rec.id,
1270: l_kplv_rec.object_version_number,
1271: l_kplv_rec.attribute_category,
1272: l_kplv_rec.attribute1,

Line 1292: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;

1288: l_kplv_rec.creation_date,
1289: l_kplv_rec.last_updated_by,
1290: l_kplv_rec.last_update_date,
1291: l_kplv_rec.last_update_login;
1292: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;
1293: CLOSE okl_k_party_roles_v_pk_csr;
1294: RETURN(l_kplv_rec);
1295: END get_kplv_rec;
1296: ------------------------------------------------------------------

Line 1293: CLOSE okl_k_party_roles_v_pk_csr;

1289: l_kplv_rec.last_updated_by,
1290: l_kplv_rec.last_update_date,
1291: l_kplv_rec.last_update_login;
1292: x_no_data_found := okl_k_party_roles_v_pk_csr%NOTFOUND;
1293: CLOSE okl_k_party_roles_v_pk_csr;
1294: RETURN(l_kplv_rec);
1295: END get_kplv_rec;
1296: ------------------------------------------------------------------
1297: -- This version of get_rec sets error messages if no data found --

Line 1634: Procedure copy_okl_k_party_roles

1630: '_PVT');
1631: End copy_party_pymt_dtls;
1632:
1633: --Bug# 4558486
1634: Procedure copy_okl_k_party_roles
1635: (p_api_version IN NUMBER,
1636: p_init_msg_list IN VARCHAR2 ,
1637: x_return_status OUT NOCOPY VARCHAR2,
1638: x_msg_count OUT NOCOPY NUMBER,

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

1645: l_kplv_rec kplv_rec_type;
1646: lx_kplv_rec kplv_rec_type;
1647:
1648: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
1649: l_api_name CONSTANT varchar2(30) := 'COPY_OKL_K_PARTY_ROLES';
1650: l_api_version CONSTANT NUMBER := 1.0;
1651:
1652: Begin
1653: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1723: End copy_okl_k_party_roles;

1719: 'OTHERS',
1720: x_msg_count,
1721: x_msg_data,
1722: '_PVT');
1723: End copy_okl_k_party_roles;
1724: --Bug# 4558486
1725: --Bug# 3143522: 11.5.10 Subsidies
1726: --------------------------------------------------------------------------------
1727: -- Start of comments

Line 3849: from okl_k_party_roles kpl

3845:
3846: --Bug# 4558486
3847: Cursor l_kpl_csr (p_cpl_id in number) is
3848: Select kpl.id
3849: from okl_k_party_roles kpl
3850: where kpl.id = p_cpl_id;
3851:
3852: lx_kpl_id okl_k_party_roles.ID%TYPE;
3853:

Line 3852: lx_kpl_id okl_k_party_roles.ID%TYPE;

3848: Select kpl.id
3849: from okl_k_party_roles kpl
3850: where kpl.id = p_cpl_id;
3851:
3852: lx_kpl_id okl_k_party_roles.ID%TYPE;
3853:
3854: BEGIN
3855: l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
3856: G_PKG_NAME,

Line 3920: copy_okl_k_party_roles

3916:
3917: --Bug# 4558486
3918: For l_kpl_rec in l_kpl_csr(p_cpl_id => p_cpl_id)
3919: Loop
3920: copy_okl_k_party_roles
3921: (p_api_version => p_api_version,
3922: p_init_msg_list => p_init_msg_list,
3923: x_return_status => x_return_status,
3924: x_msg_count => x_msg_count,

Line 5497: -- For okl_k_party_roles begin

5493:
5494: 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);
5495: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;
5496:
5497: -- For okl_k_party_roles begin
5498: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5499: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5500: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5501: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;

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

5494: 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);
5495: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;
5496:
5497: -- For okl_k_party_roles begin
5498: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5499: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5500: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5501: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5502: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;

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

5495: TYPE l_txl_id_mapping_tab_type IS TABLE OF l_txl_id_mapping_type INDEX BY BINARY_INTEGER;
5496:
5497: -- For okl_k_party_roles begin
5498: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5499: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5500: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5501: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5502: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5503: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;

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

5496:
5497: -- For okl_k_party_roles begin
5498: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5499: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5500: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5501: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5502: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5503: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5504: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;

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

5497: -- For okl_k_party_roles begin
5498: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5499: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5500: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5501: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5502: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5503: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5504: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5505: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;

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

5498: TYPE l_plid_type is table of okl_k_party_roles.id%TYPE index by binary_integer;
5499: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5500: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5501: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5502: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5503: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5504: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5505: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5506: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;

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

5499: TYPE l_plobject_version_number_type is table of okl_k_party_roles.object_version_number%TYPE index by binary_integer;
5500: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5501: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5502: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5503: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5504: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5505: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5506: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5507: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;

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

5500: TYPE l_plattribute_category_type is table of okl_k_party_roles.attribute_category%TYPE index by binary_integer;
5501: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5502: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5503: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5504: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5505: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5506: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5507: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5508: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;

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

5501: TYPE l_plattribute1_type is table of okl_k_party_roles.attribute1%TYPE index by binary_integer;
5502: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5503: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5504: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5505: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5506: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5507: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5508: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5509: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;

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

5502: TYPE l_plattribute2_type is table of okl_k_party_roles.attribute2%TYPE index by binary_integer;
5503: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5504: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5505: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5506: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5507: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5508: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5509: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5510: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;

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

5503: TYPE l_plattribute3_type is table of okl_k_party_roles.attribute3%TYPE index by binary_integer;
5504: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5505: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5506: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5507: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5508: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5509: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5510: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5511: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;

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

5504: TYPE l_plattribute4_type is table of okl_k_party_roles.attribute4%TYPE index by binary_integer;
5505: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5506: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5507: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5508: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5509: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5510: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5511: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5512: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;

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

5505: TYPE l_plattribute5_type is table of okl_k_party_roles.attribute5%TYPE index by binary_integer;
5506: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5507: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5508: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5509: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5510: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5511: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5512: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5513: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;

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

5506: TYPE l_plattribute6_type is table of okl_k_party_roles.attribute6%TYPE index by binary_integer;
5507: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5508: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5509: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5510: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5511: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5512: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5513: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5514: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;

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

5507: TYPE l_plattribute7_type is table of okl_k_party_roles.attribute7%TYPE index by binary_integer;
5508: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5509: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5510: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5511: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5512: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5513: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5514: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5515: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;

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

5508: TYPE l_plattribute8_type is table of okl_k_party_roles.attribute8%TYPE index by binary_integer;
5509: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5510: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5511: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5512: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5513: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5514: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5515: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5516: -- For okl_k_party_roles end

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

5509: TYPE l_plattribute9_type is table of okl_k_party_roles.attribute9%TYPE index by binary_integer;
5510: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5511: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5512: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5513: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5514: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5515: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5516: -- For okl_k_party_roles end
5517:

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

5510: TYPE l_plattribute10_type is table of okl_k_party_roles.attribute10%TYPE index by binary_integer;
5511: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5512: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5513: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5514: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5515: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5516: -- For okl_k_party_roles end
5517:
5518: -- For party_roles_tl Begin

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

5511: TYPE l_plattribute11_type is table of okl_k_party_roles.attribute11%TYPE index by binary_integer;
5512: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5513: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5514: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5515: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5516: -- For okl_k_party_roles end
5517:
5518: -- For party_roles_tl Begin
5519: TYPE l_pid_type IS TABLE OF okc_k_party_roles_tl.id%TYPE INDEX BY BINARY_INTEGER;

Line 5516: -- For okl_k_party_roles end

5512: TYPE l_plattribute12_type is table of okl_k_party_roles.attribute12%TYPE index by binary_integer;
5513: TYPE l_plattribute13_type is table of okl_k_party_roles.attribute13%TYPE index by binary_integer;
5514: TYPE l_plattribute14_type is table of okl_k_party_roles.attribute14%TYPE index by binary_integer;
5515: TYPE l_plattribute15_type is table of okl_k_party_roles.attribute15%TYPE index by binary_integer;
5516: -- For okl_k_party_roles end
5517:
5518: -- For party_roles_tl Begin
5519: TYPE l_pid_type IS TABLE OF okc_k_party_roles_tl.id%TYPE INDEX BY BINARY_INTEGER;
5520: TYPE l_planguage_type IS TABLE OF okc_k_party_roles_tl.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;

Line 6208: -- For okl_k_party_roles Begin

6204: l_supp_invoice_dtls_counter NUMBER := 1;
6205:
6206: -- For okl_supp_invlice_dtls End
6207:
6208: -- For okl_k_party_roles Begin
6209: l_plid_tab l_plid_type;
6210: l_plobject_version_number_tab l_plobject_version_number_type;
6211: l_plattribute_category_tab l_plattribute_category_type;
6212: l_plattribute1_tab l_plattribute1_type;

Line 6228: l_okl_k_party_roles_counter number := 1;

6224: l_plattribute13_tab l_plattribute13_type;
6225: l_plattribute14_tab l_plattribute14_type;
6226: l_plattribute15_tab l_plattribute15_type;
6227:
6228: l_okl_k_party_roles_counter number := 1;
6229:
6230: -- For okl_k_party_roles End
6231:
6232: -- For party_roles_tl Begin

Line 6230: -- For okl_k_party_roles End

6226: l_plattribute15_tab l_plattribute15_type;
6227:
6228: l_okl_k_party_roles_counter number := 1;
6229:
6230: -- For okl_k_party_roles End
6231:
6232: -- For party_roles_tl Begin
6233: l_pid_tab l_pid_type;
6234: l_planguage_tab l_planguage_type;

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

11564: END LOOP;
11565: RETURN -1;
11566: END; /* find_party_mapping_id */
11567:
11568: PROCEDURE prepare_okl_party_roles (p_old_id IN okl_k_party_roles.id%TYPE,
11569: p_new_id IN okl_k_party_roles.id%TYPE,
11570: p_flush IN VARCHAR2) IS
11571: CURSOR c30(p_id okl_k_party_roles.id%TYPE) IS
11572: SELECT

Line 11569: p_new_id IN okl_k_party_roles.id%TYPE,

11565: RETURN -1;
11566: END; /* find_party_mapping_id */
11567:
11568: PROCEDURE prepare_okl_party_roles (p_old_id IN okl_k_party_roles.id%TYPE,
11569: p_new_id IN okl_k_party_roles.id%TYPE,
11570: p_flush IN VARCHAR2) IS
11571: CURSOR c30(p_id okl_k_party_roles.id%TYPE) IS
11572: SELECT
11573: a.id, a.object_version_number, a.attribute_category,

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

11567:
11568: PROCEDURE prepare_okl_party_roles (p_old_id IN okl_k_party_roles.id%TYPE,
11569: p_new_id IN okl_k_party_roles.id%TYPE,
11570: p_flush IN VARCHAR2) IS
11571: CURSOR c30(p_id okl_k_party_roles.id%TYPE) IS
11572: SELECT
11573: a.id, a.object_version_number, a.attribute_category,
11574: a.attribute1, a.attribute2, a.attribute3,
11575: a.attribute4, a.attribute5, a.attribute6,

Line 11579: FROM okl_k_party_roles a

11575: a.attribute4, a.attribute5, a.attribute6,
11576: a.attribute7, a.attribute8, a.attribute9,
11577: a.attribute10, a.attribute11, a.attribute12,
11578: a.attribute13, a.attribute14, a.attribute15
11579: FROM okl_k_party_roles a
11580: WHERE id = p_id;
11581:
11582: l_plid_tab2 l_plid_type;
11583: l_plobject_version_number_tab2 l_plobject_version_number_type;

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

11617: EXIT WHEN l_plid_tab2.COUNT = 0;
11618:
11619: FOR i IN l_plid_tab2.first..l_plid_tab2.last
11620: LOOP
11621: l_plid_tab(l_okl_k_party_roles_counter) := l_plid_tab2(i);
11622: -- Replace id
11623: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11624:
11625: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);

Line 11623: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;

11619: FOR i IN l_plid_tab2.first..l_plid_tab2.last
11620: LOOP
11621: l_plid_tab(l_okl_k_party_roles_counter) := l_plid_tab2(i);
11622: -- Replace id
11623: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11624:
11625: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11626: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11627: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);

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

11621: l_plid_tab(l_okl_k_party_roles_counter) := l_plid_tab2(i);
11622: -- Replace id
11623: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11624:
11625: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11626: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11627: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11628: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11629: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);

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

11622: -- Replace id
11623: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11624:
11625: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11626: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11627: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11628: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11629: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11630: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);

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

11623: l_plid_tab(l_okl_k_party_roles_counter) := p_new_id;
11624:
11625: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11626: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11627: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11628: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11629: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11630: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11631: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);

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

11624:
11625: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11626: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11627: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11628: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11629: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11630: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11631: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11632: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);

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

11625: l_plobject_version_number_tab(l_okl_k_party_roles_counter) := l_plobject_version_number_tab2(i);
11626: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11627: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11628: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11629: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11630: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11631: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11632: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11633: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);

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

11626: l_plattribute_category_tab(l_okl_k_party_roles_counter) := l_plattribute_category_tab2(i);
11627: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11628: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11629: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11630: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11631: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11632: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11633: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11634: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);

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

11627: l_plattribute1_tab(l_okl_k_party_roles_counter) := l_plattribute1_tab2(i);
11628: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11629: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11630: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11631: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11632: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11633: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11634: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11635: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);

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

11628: l_plattribute2_tab(l_okl_k_party_roles_counter) := l_plattribute2_tab2(i);
11629: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11630: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11631: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11632: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11633: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11634: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11635: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11636: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);

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

11629: l_plattribute3_tab(l_okl_k_party_roles_counter) := l_plattribute3_tab2(i);
11630: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11631: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11632: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11633: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11634: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11635: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11636: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11637: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);

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

11630: l_plattribute4_tab(l_okl_k_party_roles_counter) := l_plattribute4_tab2(i);
11631: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11632: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11633: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11634: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11635: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11636: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11637: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11638: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);

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

11631: l_plattribute5_tab(l_okl_k_party_roles_counter) := l_plattribute5_tab2(i);
11632: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11633: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11634: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11635: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11636: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11637: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11638: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11639: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);

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

11632: l_plattribute6_tab(l_okl_k_party_roles_counter) := l_plattribute6_tab2(i);
11633: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11634: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11635: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11636: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11637: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11638: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11639: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11640: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);

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

11633: l_plattribute7_tab(l_okl_k_party_roles_counter) := l_plattribute7_tab2(i);
11634: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11635: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11636: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11637: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11638: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11639: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11640: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11641: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);

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

11634: l_plattribute8_tab(l_okl_k_party_roles_counter) := l_plattribute8_tab2(i);
11635: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11636: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11637: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11638: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11639: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11640: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11641: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11642:

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

11635: l_plattribute9_tab(l_okl_k_party_roles_counter) := l_plattribute9_tab2(i);
11636: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11637: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11638: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11639: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11640: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11641: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11642:
11643: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;

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

11636: l_plattribute10_tab(l_okl_k_party_roles_counter) := l_plattribute10_tab2(i);
11637: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11638: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11639: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11640: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11641: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11642:
11643: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;
11644:

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

11637: l_plattribute11_tab(l_okl_k_party_roles_counter) := l_plattribute11_tab2(i);
11638: l_plattribute12_tab(l_okl_k_party_roles_counter) := l_plattribute12_tab2(i);
11639: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11640: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11641: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11642:
11643: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;
11644:
11645: END LOOP;

Line 11643: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;

11639: l_plattribute13_tab(l_okl_k_party_roles_counter) := l_plattribute13_tab2(i);
11640: l_plattribute14_tab(l_okl_k_party_roles_counter) := l_plattribute14_tab2(i);
11641: l_plattribute15_tab(l_okl_k_party_roles_counter) := l_plattribute15_tab2(i);
11642:
11643: l_okl_k_party_roles_counter := l_okl_k_party_roles_counter + 1;
11644:
11645: END LOOP;
11646:
11647: END LOOP;

Line 11652: 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);

11648: CLOSE c30;
11649:
11650: IF (p_flush = 'Y') THEN
11651: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
11652: 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);
11653: END IF;
11654: IF (l_plid_tab.COUNT > 0) THEN
11655: forall i IN l_plid_tab.first..l_plid_tab.last
11656: INSERT INTO okl_k_party_roles (

Line 11656: INSERT INTO okl_k_party_roles (

11652: 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);
11653: END IF;
11654: IF (l_plid_tab.COUNT > 0) THEN
11655: forall i IN l_plid_tab.first..l_plid_tab.last
11656: INSERT INTO okl_k_party_roles (
11657: id, object_version_number, attribute_category,
11658: attribute1, attribute2, attribute3,
11659: attribute4, attribute5, attribute6,
11660: attribute7, attribute8, attribute9,