32: NULL;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_AE_TMPT_SETS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_aes_rec IN aes_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN
38: FUNCTION get_rec (
39: p_aes_rec IN aes_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN
41: ) RETURN aes_rec_type IS
42: CURSOR okl_ae_tmpt_sets_pk_csr (p_id IN NUMBER) IS
43: SELECT
44: ID,
45: NAME,
46: VERSION,
54: LAST_UPDATED_BY,
55: LAST_UPDATE_DATE,
56: LAST_UPDATE_LOGIN,
57: GTS_ID
58: FROM Okl_Ae_Tmpt_Sets
59: WHERE okl_ae_tmpt_sets.id = p_id;
60: l_okl_ae_tmpt_sets_pk okl_ae_tmpt_sets_pk_csr%ROWTYPE;
61: l_aes_rec aes_rec_type;
62: BEGIN
55: LAST_UPDATE_DATE,
56: LAST_UPDATE_LOGIN,
57: GTS_ID
58: FROM Okl_Ae_Tmpt_Sets
59: WHERE okl_ae_tmpt_sets.id = p_id;
60: l_okl_ae_tmpt_sets_pk okl_ae_tmpt_sets_pk_csr%ROWTYPE;
61: l_aes_rec aes_rec_type;
62: BEGIN
63: x_no_data_found := TRUE;
56: LAST_UPDATE_LOGIN,
57: GTS_ID
58: FROM Okl_Ae_Tmpt_Sets
59: WHERE okl_ae_tmpt_sets.id = p_id;
60: l_okl_ae_tmpt_sets_pk okl_ae_tmpt_sets_pk_csr%ROWTYPE;
61: l_aes_rec aes_rec_type;
62: BEGIN
63: x_no_data_found := TRUE;
64: -- Get current database values
61: l_aes_rec aes_rec_type;
62: BEGIN
63: x_no_data_found := TRUE;
64: -- Get current database values
65: OPEN okl_ae_tmpt_sets_pk_csr (p_aes_rec.id);
66: FETCH okl_ae_tmpt_sets_pk_csr INTO
67: l_aes_rec.ID,
68: l_aes_rec.NAME,
69: l_aes_rec.VERSION,
62: BEGIN
63: x_no_data_found := TRUE;
64: -- Get current database values
65: OPEN okl_ae_tmpt_sets_pk_csr (p_aes_rec.id);
66: FETCH okl_ae_tmpt_sets_pk_csr INTO
67: l_aes_rec.ID,
68: l_aes_rec.NAME,
69: l_aes_rec.VERSION,
70: l_aes_rec.START_DATE,
77: l_aes_rec.LAST_UPDATED_BY,
78: l_aes_rec.LAST_UPDATE_DATE,
79: l_aes_rec.LAST_UPDATE_LOGIN,
80: l_aes_rec.ORG_ID;
81: x_no_data_found := okl_ae_tmpt_sets_pk_csr%NOTFOUND;
82: CLOSE okl_ae_tmpt_sets_pk_csr;
83: RETURN(l_aes_rec);
84: END get_rec;
85:
78: l_aes_rec.LAST_UPDATE_DATE,
79: l_aes_rec.LAST_UPDATE_LOGIN,
80: l_aes_rec.ORG_ID;
81: x_no_data_found := okl_ae_tmpt_sets_pk_csr%NOTFOUND;
82: CLOSE okl_ae_tmpt_sets_pk_csr;
83: RETURN(l_aes_rec);
84: END get_rec;
85:
86: FUNCTION get_rec (
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
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
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;
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
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
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:
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
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,
578: ---------------------------------------------------------------------------
579: -- PROCEDURE insert_row
580: ---------------------------------------------------------------------------
581: -------------------------------------
582: -- insert_row for:OKL_AE_TMPT_SETS --
583: -------------------------------------
584: PROCEDURE insert_row(
585: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
586: x_return_status OUT NOCOPY VARCHAR2,
594: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
595: l_aes_rec aes_rec_type := p_aes_rec;
596: l_def_aes_rec aes_rec_type;
597: -----------------------------------------
598: -- Set_Attributes for:OKL_AE_TMPT_SETS --
599: -----------------------------------------
600: FUNCTION Set_Attributes (
601: p_aes_rec IN aes_rec_type,
602: x_aes_rec OUT NOCOPY aes_rec_type
625: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
626: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
627: RAISE Okc_Api.G_EXCEPTION_ERROR;
628: END IF;
629: INSERT INTO OKL_AE_TMPT_SETS(
630: id,
631: name,
632: version,
633: start_date,
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,
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
916: ---------------------------------------------------------------------------
917: -- PROCEDURE lock_row
918: ---------------------------------------------------------------------------
919: -----------------------------------
920: -- lock_row for:OKL_AE_TMPT_SETS --
921: -----------------------------------
922: PROCEDURE lock_row(
923: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
924: x_return_status OUT NOCOPY VARCHAR2,
929: E_Resource_Busy EXCEPTION;
930: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
931: CURSOR lock_csr (p_aes_rec IN aes_rec_type) IS
932: SELECT OBJECT_VERSION_NUMBER
933: FROM OKL_AE_TMPT_SETS
934: WHERE ID = p_aes_rec.id
935: AND OBJECT_VERSION_NUMBER = p_aes_rec.object_version_number
936: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
937:
936: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
937:
938: CURSOR lchk_csr (p_aes_rec IN aes_rec_type) IS
939: SELECT OBJECT_VERSION_NUMBER
940: FROM OKL_AE_TMPT_SETS
941: WHERE ID = p_aes_rec.id;
942: l_api_version CONSTANT NUMBER := 1;
943: l_api_name CONSTANT VARCHAR2(30) := 'SETS_lock_row';
944: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
941: WHERE ID = p_aes_rec.id;
942: l_api_version CONSTANT NUMBER := 1;
943: l_api_name CONSTANT VARCHAR2(30) := 'SETS_lock_row';
944: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
945: l_object_version_number OKL_AE_TMPT_SETS.OBJECT_VERSION_NUMBER%TYPE;
946: lc_object_version_number OKL_AE_TMPT_SETS.OBJECT_VERSION_NUMBER%TYPE;
947: l_row_notfound BOOLEAN := FALSE;
948: lc_row_notfound BOOLEAN := FALSE;
949: BEGIN
942: l_api_version CONSTANT NUMBER := 1;
943: l_api_name CONSTANT VARCHAR2(30) := 'SETS_lock_row';
944: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
945: l_object_version_number OKL_AE_TMPT_SETS.OBJECT_VERSION_NUMBER%TYPE;
946: lc_object_version_number OKL_AE_TMPT_SETS.OBJECT_VERSION_NUMBER%TYPE;
947: l_row_notfound BOOLEAN := FALSE;
948: lc_row_notfound BOOLEAN := FALSE;
949: BEGIN
950: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
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,
1179: ---------------------------------------------------------------------------
1180: -- PROCEDURE update_row
1181: ---------------------------------------------------------------------------
1182: -------------------------------------
1183: -- update_row for:OKL_AE_TMPT_SETS --
1184: -------------------------------------
1185: PROCEDURE update_row(
1186: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1187: x_return_status OUT NOCOPY VARCHAR2,
1271: END IF;
1272: RETURN(l_return_status);
1273: END populate_new_record;
1274: -----------------------------------------
1275: -- Set_Attributes for:OKL_AE_TMPT_SETS --
1276: -----------------------------------------
1277: FUNCTION Set_Attributes (
1278: p_aes_rec IN aes_rec_type,
1279: x_aes_rec OUT NOCOPY aes_rec_type
1308: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1309: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1310: RAISE Okc_Api.G_EXCEPTION_ERROR;
1311: END IF;
1312: UPDATE OKL_AE_TMPT_SETS
1313: SET NAME = l_def_aes_rec.name,
1314: VERSION = l_def_aes_rec.version,
1315: START_DATE = l_def_aes_rec.start_date,
1316: OBJECT_VERSION_NUMBER = l_def_aes_rec.object_version_number,
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,
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
1660: ---------------------------------------------------------------------------
1661: -- PROCEDURE delete_row
1662: ---------------------------------------------------------------------------
1663: -------------------------------------
1664: -- delete_row for:OKL_AE_TMPT_SETS --
1665: -------------------------------------
1666: PROCEDURE delete_row(
1667: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1668: x_return_status OUT NOCOPY VARCHAR2,
1685: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1686: RAISE Okc_Api.G_EXCEPTION_ERROR;
1687: END IF;
1688:
1689: DELETE FROM OKL_AE_TMPT_SETS
1690: WHERE ID = l_aes_rec.id;
1691:
1692: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1693:
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,