APPS.OKL_AES_PVT dependencies on OKL_AE_TMPT_SETS_V

Line 94: -- FUNCTION get_rec for: OKL_AE_TMPT_SETS_V

90: BEGIN
91: RETURN(get_rec(p_aes_rec, l_row_notfound));
92: END get_rec;
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_AE_TMPT_SETS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_aesv_rec IN aesv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 116: FROM Okl_Ae_Tmpt_Sets_V

112: LAST_UPDATED_BY,
113: LAST_UPDATE_DATE,
114: LAST_UPDATE_LOGIN,
115: GTS_ID
116: FROM Okl_Ae_Tmpt_Sets_V
117: WHERE okl_ae_tmpt_sets_v.id = p_id;
118: l_okl_aesv_pk okl_aesv_pk_csr%ROWTYPE;
119: l_aesv_rec aesv_rec_type;
120: BEGIN

Line 117: WHERE okl_ae_tmpt_sets_v.id = p_id;

113: LAST_UPDATE_DATE,
114: LAST_UPDATE_LOGIN,
115: GTS_ID
116: FROM Okl_Ae_Tmpt_Sets_V
117: WHERE okl_ae_tmpt_sets_v.id = p_id;
118: l_okl_aesv_pk okl_aesv_pk_csr%ROWTYPE;
119: l_aesv_rec aesv_rec_type;
120: BEGIN
121: x_no_data_found := TRUE;

Line 153: -- FUNCTION null_out_defaults for: OKL_AE_TMPT_SETS_V --

149: RETURN(get_rec(p_aesv_rec, l_row_notfound));
150: END get_rec;
151:
152: --------------------------------------------------------
153: -- FUNCTION null_out_defaults for: OKL_AE_TMPT_SETS_V --
154: --------------------------------------------------------
155: FUNCTION null_out_defaults (
156: p_aesv_rec IN aesv_rec_type
157: ) RETURN aesv_rec_type IS

Line 248: -- Validate_Attributes for:OKL_AE_TMPT_SETS_V --

244: END Validate_Enddate;
245:
246:
247: ------------------------------------------------
248: -- Validate_Attributes for:OKL_AE_TMPT_SETS_V --
249: ------------------------------------------------
250: FUNCTION Validate_Attributes (
251: p_aesv_rec IN aesv_rec_type
252: ) RETURN VARCHAR2 IS

Line 329: FROM Okl_Ae_Tmpt_Sets_V

325:
326: CURSOR l_namever_csr
327: IS
328: SELECT '1'
329: FROM Okl_Ae_Tmpt_Sets_V
330: WHERE name = trim(p_aesv_rec.name) -- trim added by prasjain for bug# 6439908
331: AND version = p_aesv_rec.version
332: AND ID <> p_aesv_rec.ID;
333:

Line 365: -- Validate_Record for:OKL_AE_TMPT_SETS_V --

361: ---------------------------------------------------------------------------
362: -- PROCEDURE Validate_Record
363: ---------------------------------------------------------------------------
364: --------------------------------------------
365: -- Validate_Record for:OKL_AE_TMPT_SETS_V --
366: --------------------------------------------
367: FUNCTION Validate_Record (
368: p_aesv_rec IN aesv_rec_type
369: ) RETURN VARCHAR2 IS

Line 430: -- validate_row for:OKL_AE_TMPT_SETS_V --

426: ---------------------------------------------------------------------------
427: -- PROCEDURE validate_row
428: ---------------------------------------------------------------------------
429: -----------------------------------------
430: -- validate_row for:OKL_AE_TMPT_SETS_V --
431: -----------------------------------------
432: PROCEDURE validate_row(
433: p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 695: -- insert_row for:OKL_AE_TMPT_SETS_V --

691: '_PVT'
692: );
693: END insert_row;
694: ---------------------------------------
695: -- insert_row for:OKL_AE_TMPT_SETS_V --
696: ---------------------------------------
697: PROCEDURE insert_row(
698: p_api_version IN NUMBER,
699: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 729: -- Set_Attributes for:OKL_AE_TMPT_SETS_V --

725: l_aesv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
726: RETURN(l_aesv_rec);
727: END fill_who_columns;
728: -------------------------------------------
729: -- Set_Attributes for:OKL_AE_TMPT_SETS_V --
730: -------------------------------------------
731: FUNCTION Set_Attributes (
732: p_aesv_rec IN aesv_rec_type,
733: x_aesv_rec OUT NOCOPY aesv_rec_type

Line 1026: -- lock_row for:OKL_AE_TMPT_SETS_V --

1022: '_PVT'
1023: );
1024: END lock_row;
1025: -------------------------------------
1026: -- lock_row for:OKL_AE_TMPT_SETS_V --
1027: -------------------------------------
1028: PROCEDURE lock_row(
1029: p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1363: -- update_row for:OKL_AE_TMPT_SETS_V --

1359: '_PVT'
1360: );
1361: END update_row;
1362: ---------------------------------------
1363: -- update_row for:OKL_AE_TMPT_SETS_V --
1364: ---------------------------------------
1365: PROCEDURE update_row(
1366: p_api_version IN NUMBER,
1367: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1470: -- Set_Attributes for:OKL_AE_TMPT_SETS_V --

1466: END IF;
1467: RETURN(l_return_status);
1468: END populate_new_record;
1469: -------------------------------------------
1470: -- Set_Attributes for:OKL_AE_TMPT_SETS_V --
1471: -------------------------------------------
1472: FUNCTION Set_Attributes (
1473: p_aesv_rec IN aesv_rec_type,
1474: x_aesv_rec OUT NOCOPY aesv_rec_type

Line 1727: -- delete_row for:OKL_AE_TMPT_SETS_V --

1723: '_PVT'
1724: );
1725: END delete_row;
1726: ---------------------------------------
1727: -- delete_row for:OKL_AE_TMPT_SETS_V --
1728: ---------------------------------------
1729: PROCEDURE delete_row(
1730: p_api_version IN NUMBER,
1731: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,