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 3662: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys

3658: END IF;
3659:
3660: IF l_pqv_count > 0 THEN
3661: IF p_flag = G_UPDATE THEN
3662: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3663: IF(L_DEBUG_ENABLED='Y') THEN
3664: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3665: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3666: END IF;

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

3665: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3666: END IF;
3667: IF(IS_DEBUG_PROCEDURE_ON) THEN
3668: BEGIN
3669: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3670: END;
3671: END IF;
3672: Okl_Pdt_Stys_Pub.update_pdt_stys(p_api_version => p_api_version,
3673: p_init_msg_list => p_init_msg_list,

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

3668: BEGIN
3669: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3670: END;
3671: END IF;
3672: Okl_Pdt_Stys_Pub.update_pdt_stys(p_api_version => p_api_version,
3673: p_init_msg_list => p_init_msg_list,
3674: x_return_status => l_return_status,
3675:
3676: x_msg_count => x_msg_count,

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

3678: p_psyv_tbl => l_psyv_tbl,
3679: x_psyv_tbl => l_out_psyv_tbl);
3680: IF(IS_DEBUG_PROCEDURE_ON) THEN
3681: BEGIN
3682: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3683: END;
3684: END IF;
3685: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3686: ELSE

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

3681: BEGIN
3682: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.update_pdt_stys ');
3683: END;
3684: END IF;
3685: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3686: ELSE
3687: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3688: IF(IS_DEBUG_PROCEDURE_ON) THEN
3689: BEGIN

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

3683: END;
3684: END IF;
3685: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.update_pdt_stys
3686: ELSE
3687: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3688: IF(IS_DEBUG_PROCEDURE_ON) THEN
3689: BEGIN
3690: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3691: END;

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

3686: ELSE
3687: -- Start of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3688: IF(IS_DEBUG_PROCEDURE_ON) THEN
3689: BEGIN
3690: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3691: END;
3692: END IF;
3693: Okl_Pdt_Stys_Pub.insert_pdt_stys(p_api_version => p_api_version,
3694: p_init_msg_list => p_init_msg_list,

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

3689: BEGIN
3690: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3691: END;
3692: END IF;
3693: Okl_Pdt_Stys_Pub.insert_pdt_stys(p_api_version => p_api_version,
3694: p_init_msg_list => p_init_msg_list,
3695: x_return_status => l_return_status,
3696: x_msg_count => x_msg_count,
3697: x_msg_data => x_msg_data,

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

3698: p_psyv_tbl => l_psyv_tbl,
3699: x_psyv_tbl => l_out_psyv_tbl);
3700: IF(IS_DEBUG_PROCEDURE_ON) THEN
3701: BEGIN
3702: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3703:
3704: END;
3705: END IF;
3706: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys

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

3702: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSPDB.pls call Okl_Pdt_Stys_Pub.insert_pdt_stys ');
3703:
3704: END;
3705: END IF;
3706: -- End of wraper code generated automatically by Debug code generator for Okl_Pdt_Stys_Pub.insert_pdt_stys
3707: END IF;
3708: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
3709: x_return_status := Okl_Api.G_RET_STS_ERROR;
3710: RAISE G_EXCEPTION_HALT_PROCESSING;