APPS.OKL_SETUPOVDTEMPLATES_PVT dependencies on OKL_OVD_RUL_TMLS_V

Line 5: -- PROCEDURE get_rec for: OKL_OVD_RUL_TMLS_V

1: PACKAGE BODY Okl_Setupovdtemplates_Pvt AS
2: /* $Header: OKLRSVTB.pls 115.8 2003/10/15 23:26:30 sgorantl noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: OKL_OVD_RUL_TMLS_V
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (
8: p_ovtv_rec IN ovtv_rec_type,
9: x_return_status OUT NOCOPY VARCHAR2,

Line 25: FROM Okl_Ovd_Rul_Tmls_V

21: CREATION_DATE,
22: LAST_UPDATED_BY,
23: LAST_UPDATE_DATE,
24: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
25: FROM Okl_Ovd_Rul_Tmls_V
26: WHERE Okl_Ovd_Rul_Tmls_V.id = p_id;
27: l_okl_ovtv_pk okl_ovtv_pk_csr%ROWTYPE;
28: l_ovtv_rec ovtv_rec_type;
29: BEGIN

Line 26: WHERE Okl_Ovd_Rul_Tmls_V.id = p_id;

22: LAST_UPDATED_BY,
23: LAST_UPDATE_DATE,
24: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
25: FROM Okl_Ovd_Rul_Tmls_V
26: WHERE Okl_Ovd_Rul_Tmls_V.id = p_id;
27: l_okl_ovtv_pk okl_ovtv_pk_csr%ROWTYPE;
28: l_ovtv_rec ovtv_rec_type;
29: BEGIN
30: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 68: -- PROCEDURE verify_context for: OKL_OVD_RUL_TMLS_V

64:
65: END get_rec;
66:
67: ---------------------------------------------------------------------------
68: -- PROCEDURE verify_context for: OKL_OVD_RUL_TMLS_V
69: ---------------------------------------------------------------------------
70: FUNCTION verify_context (
71: p_org_id IN NUMBER,
72: p_inv_org_id IN NUMBER,

Line 111: -- PROCEDURE check_constraints for: OKL_OVD_RUL_TMLS_V

107: RETURN(l_return_status);
108: END verify_context;
109:
110: ---------------------------------------------------------------------------
111: -- PROCEDURE check_constraints for: OKL_OVD_RUL_TMLS_V
112: -- To verify whether an addition of new option value rule template
113: -- is ok with rest of the product - contract relationships
114: ---------------------------------------------------------------------------
115: PROCEDURE check_constraints (

Line 201: p_token1_value => 'Okl_Ovd_Rul_Tmls_V',

197: IF l_row_not_found = FALSE THEN
198: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
199: p_msg_name => G_IN_USE,
200: p_token1 => G_PARENT_TABLE_TOKEN,
201: p_token1_value => 'Okl_Ovd_Rul_Tmls_V',
202: p_token2 => G_CHILD_TABLE_TOKEN,
203: p_token2_value => 'Okl_Slctd_Optns_V');
204: x_valid := FALSE;
205: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 359: p_token1_value => 'Okl_Ovd_Rul_Tmls_V',

355: IF l_no_data_found = FALSE THEN
356: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
357: p_msg_name => G_DATES_MISMATCH,
358: p_token1 => G_PARENT_TABLE_TOKEN,
359: p_token1_value => 'Okl_Ovd_Rul_Tmls_V',
360: p_token2 => G_CHILD_TABLE_TOKEN,
361: p_token2_value => 'Okc_Rule_Def_Sources_V');
362: x_valid := FALSE;
363: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 403: -- PROCEDURE insert_ovdtemplates for: OKL_OVD_RUL_TMLS_V

399:
400: END check_constraints;
401:
402: ---------------------------------------------------------------------------
403: -- PROCEDURE insert_ovdtemplates for: OKL_OVD_RUL_TMLS_V
404: ---------------------------------------------------------------------------
405: PROCEDURE insert_ovdtemplates(p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
407: x_return_status OUT NOCOPY VARCHAR2,

Line 499: -- PROCEDURE delete_ovdtemplates for: OKL_OVD_RUL_TMLS_V

495:
496: END insert_ovdtemplates;
497:
498: ---------------------------------------------------------------------------
499: -- PROCEDURE delete_ovdtemplates for: OKL_OVD_RUL_TMLS_V
500: -- This allows the user to delete table of records
501: ---------------------------------------------------------------------------
502: PROCEDURE delete_ovdtemplates(p_api_version IN NUMBER,
503: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,