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_SETUPPRODUCTS_PVT dependencies on OKL_PDT_STYS_PUB

Line 20: SUBTYPE psyv_rec_type IS Okl_Pdt_Stys_Pub.psyv_rec_type;

16: G_PDT_VALDTION_NOT_VALID CONSTANT VARCHAR2(200) := 'OKL_PDT_VALDTION_NOT_VALID';
17:
18:
19: -- product Stream Type
20: SUBTYPE psyv_rec_type IS Okl_Pdt_Stys_Pub.psyv_rec_type;
21: SUBTYPE psyv_tbl_type IS Okl_Pdt_Stys_Pub.psyv_tbl_type;
22:
23: ---------------------------------------------------------------------------
24: -- PROCEDURE get_rec for: OKL_PRODUCTS_V

Line 21: SUBTYPE psyv_tbl_type IS Okl_Pdt_Stys_Pub.psyv_tbl_type;

17:
18:
19: -- product Stream Type
20: SUBTYPE psyv_rec_type IS Okl_Pdt_Stys_Pub.psyv_rec_type;
21: SUBTYPE psyv_tbl_type IS Okl_Pdt_Stys_Pub.psyv_tbl_type;
22:
23: ---------------------------------------------------------------------------
24: -- PROCEDURE get_rec for: OKL_PRODUCTS_V
25: ---------------------------------------------------------------------------

Line 229: l_del_psyv_tbl Okl_Pdt_Stys_Pub.psyv_tbl_type;

225: ,x_msg_data OUT NOCOPY VARCHAR2
226: ,p_pdtv_rec IN pdtv_rec_type) IS
227: i PLS_INTEGER :=0;
228: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
229: l_del_psyv_tbl Okl_Pdt_Stys_Pub.psyv_tbl_type;
230:
231: CURSOR psy_csr IS
232: SELECT psyv.id
233: FROM okl_prod_strm_types_v psyv

Line 246: Okl_Pdt_Stys_Pub.delete_pdt_stys(p_api_version => p_api_version,

242: END LOOP;
243:
244: IF l_del_psyv_tbl.COUNT > 0 THEN
245:
246: Okl_Pdt_Stys_Pub.delete_pdt_stys(p_api_version => p_api_version,
247: p_init_msg_list => p_init_msg_list,
248: x_return_status => l_return_status,
249: x_msg_count => x_msg_count,
250: x_msg_data => x_msg_data,

Line 3633: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys

3629: END IF;
3630:
3631: IF l_pqv_count > 0 THEN
3632: IF p_flag = G_UPDATE THEN
3633: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3634: IF(L_DEBUG_ENABLED='Y') THEN
3635: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3636: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3637: END IF;

Line 3640: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');

3636: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3637: END IF;
3638: IF(IS_DEBUG_PROCEDURE_ON) THEN
3639: BEGIN
3640: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3641: END;
3642: END IF;
3643: Okl_Pdt_Stys_Pub.update_pdt_stys(p_api_version => p_api_version,
3644: p_init_msg_list => p_init_msg_list,

Line 3643: Okl_Pdt_Stys_Pub.update_pdt_stys(p_api_version => p_api_version,

3639: BEGIN
3640: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3641: END;
3642: END IF;
3643: Okl_Pdt_Stys_Pub.update_pdt_stys(p_api_version => p_api_version,
3644: p_init_msg_list => p_init_msg_list,
3645: x_return_status => l_return_status,
3646:
3647: x_msg_count => x_msg_count,

Line 3653: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');

3649: p_psyv_tbl => l_psyv_tbl,
3650: x_psyv_tbl => l_out_psyv_tbl);
3651: IF(IS_DEBUG_PROCEDURE_ON) THEN
3652: BEGIN
3653: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3654: END;
3655: END IF;
3656: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3657: ELSE

Line 3656: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys

3652: BEGIN
3653: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3654: END;
3655: END IF;
3656: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3657: ELSE
3658: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3659: IF(IS_DEBUG_PROCEDURE_ON) THEN
3660: BEGIN

Line 3658: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys

3654: END;
3655: END IF;
3656: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3657: ELSE
3658: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3659: IF(IS_DEBUG_PROCEDURE_ON) THEN
3660: BEGIN
3661: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3662: END;

Line 3661: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');

3657: ELSE
3658: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3659: IF(IS_DEBUG_PROCEDURE_ON) THEN
3660: BEGIN
3661: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3662: END;
3663: END IF;
3664: Okl_Pdt_Stys_Pub.insert_pdt_stys(p_api_version => p_api_version,
3665: p_init_msg_list => p_init_msg_list,

Line 3664: Okl_Pdt_Stys_Pub.insert_pdt_stys(p_api_version => p_api_version,

3660: BEGIN
3661: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3662: END;
3663: END IF;
3664: Okl_Pdt_Stys_Pub.insert_pdt_stys(p_api_version => p_api_version,
3665: p_init_msg_list => p_init_msg_list,
3666: x_return_status => l_return_status,
3667: x_msg_count => x_msg_count,
3668: x_msg_data => x_msg_data,

Line 3673: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');

3669: p_psyv_tbl => l_psyv_tbl,
3670: x_psyv_tbl => l_out_psyv_tbl);
3671: IF(IS_DEBUG_PROCEDURE_ON) THEN
3672: BEGIN
3673: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3674:
3675: END;
3676: END IF;
3677: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys

Line 3677: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys

3673: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3674:
3675: END;
3676: END IF;
3677: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3678: END IF;
3679: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
3680: x_return_status := Okl_Api.G_RET_STS_ERROR;
3681: RAISE G_EXCEPTION_HALT_PROCESSING;