DBA Data[Home] [Help]

APPS.OKL_PTL_PVT dependencies on OKL_PDT_TEMPLATES

Line 36: -- FUNCTION get_rec for: OKL_PDT_TEMPLATES

32: NULL;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_PDT_TEMPLATES
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_ptl_rec IN ptl_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 42: CURSOR okl_pdt_templates_pk_csr (p_id IN NUMBER) IS

38: FUNCTION get_rec (
39: p_ptl_rec IN ptl_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN
41: ) RETURN ptl_rec_type IS
42: CURSOR okl_pdt_templates_pk_csr (p_id IN NUMBER) IS
43: SELECT
44: ID,
45: NAME,
46: VERSION,

Line 56: FROM Okl_Pdt_Templates

52: CREATION_DATE,
53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okl_Pdt_Templates
57: WHERE okl_pdt_templates.id = p_id;
58: l_okl_pdt_templates_pk okl_pdt_templates_pk_csr%ROWTYPE;
59: l_ptl_rec ptl_rec_type;
60: BEGIN

Line 57: WHERE okl_pdt_templates.id = p_id;

53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okl_Pdt_Templates
57: WHERE okl_pdt_templates.id = p_id;
58: l_okl_pdt_templates_pk okl_pdt_templates_pk_csr%ROWTYPE;
59: l_ptl_rec ptl_rec_type;
60: BEGIN
61: x_no_data_found := TRUE;

Line 58: l_okl_pdt_templates_pk okl_pdt_templates_pk_csr%ROWTYPE;

54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okl_Pdt_Templates
57: WHERE okl_pdt_templates.id = p_id;
58: l_okl_pdt_templates_pk okl_pdt_templates_pk_csr%ROWTYPE;
59: l_ptl_rec ptl_rec_type;
60: BEGIN
61: x_no_data_found := TRUE;
62: -- Get current database values

Line 63: OPEN okl_pdt_templates_pk_csr (p_ptl_rec.id);

59: l_ptl_rec ptl_rec_type;
60: BEGIN
61: x_no_data_found := TRUE;
62: -- Get current database values
63: OPEN okl_pdt_templates_pk_csr (p_ptl_rec.id);
64: FETCH okl_pdt_templates_pk_csr INTO
65: l_ptl_rec.ID,
66: l_ptl_rec.NAME,
67: l_ptl_rec.VERSION,

Line 64: FETCH okl_pdt_templates_pk_csr INTO

60: BEGIN
61: x_no_data_found := TRUE;
62: -- Get current database values
63: OPEN okl_pdt_templates_pk_csr (p_ptl_rec.id);
64: FETCH okl_pdt_templates_pk_csr INTO
65: l_ptl_rec.ID,
66: l_ptl_rec.NAME,
67: l_ptl_rec.VERSION,
68: l_ptl_rec.OBJECT_VERSION_NUMBER,

Line 77: x_no_data_found := okl_pdt_templates_pk_csr%NOTFOUND;

73: l_ptl_rec.CREATION_DATE,
74: l_ptl_rec.LAST_UPDATED_BY,
75: l_ptl_rec.LAST_UPDATE_DATE,
76: l_ptl_rec.LAST_UPDATE_LOGIN;
77: x_no_data_found := okl_pdt_templates_pk_csr%NOTFOUND;
78: CLOSE okl_pdt_templates_pk_csr;
79: RETURN(l_ptl_rec);
80: END get_rec;
81:

Line 78: CLOSE okl_pdt_templates_pk_csr;

74: l_ptl_rec.LAST_UPDATED_BY,
75: l_ptl_rec.LAST_UPDATE_DATE,
76: l_ptl_rec.LAST_UPDATE_LOGIN;
77: x_no_data_found := okl_pdt_templates_pk_csr%NOTFOUND;
78: CLOSE okl_pdt_templates_pk_csr;
79: RETURN(l_ptl_rec);
80: END get_rec;
81:
82: FUNCTION get_rec (

Line 90: -- FUNCTION get_rec for: OKL_PDT_TEMPLATES_V

86: BEGIN
87: RETURN(get_rec(p_ptl_rec, l_row_notfound));
88: END get_rec;
89: ---------------------------------------------------------------------------
90: -- FUNCTION get_rec for: OKL_PDT_TEMPLATES_V
91: ---------------------------------------------------------------------------
92: FUNCTION get_rec (
93: p_ptlv_rec IN ptlv_rec_type,
94: x_no_data_found OUT NOCOPY BOOLEAN

Line 110: FROM Okl_Pdt_Templates_V

106: CREATION_DATE,
107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM Okl_Pdt_Templates_V
111: WHERE okl_pdt_templates_v.id = p_id;
112: l_okl_ptlv_pk okl_ptlv_pk_csr%ROWTYPE;
113: l_ptlv_rec ptlv_rec_type;
114: BEGIN

Line 111: WHERE okl_pdt_templates_v.id = p_id;

107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM Okl_Pdt_Templates_V
111: WHERE okl_pdt_templates_v.id = p_id;
112: l_okl_ptlv_pk okl_ptlv_pk_csr%ROWTYPE;
113: l_ptlv_rec ptlv_rec_type;
114: BEGIN
115: x_no_data_found := TRUE;

Line 145: -- FUNCTION null_out_defaults for: OKL_PDT_TEMPLATES_V --

141: RETURN(get_rec(p_ptlv_rec, l_row_notfound));
142: END get_rec;
143:
144: ---------------------------------------------------------
145: -- FUNCTION null_out_defaults for: OKL_PDT_TEMPLATES_V --
146: ---------------------------------------------------------
147: FUNCTION null_out_defaults (
148: p_ptlv_rec IN ptlv_rec_type
149: ) RETURN ptlv_rec_type IS

Line 194: -- Validate_Attributes for:OKL_PDT_TEMPLATES_V --

190: ---------------------------------------------------------------------------
191: -- PROCEDURE Validate_Attributes
192: ---------------------------------------------------------------------------
193: -------------------------------------------------
194: -- Validate_Attributes for:OKL_PDT_TEMPLATES_V --
195: -------------------------------------------------
196: FUNCTION Validate_Attributes (
197: p_ptlv_rec IN ptlv_rec_type
198: ) RETURN VARCHAR2 IS

Line 230: -- Validate_Record for:OKL_PDT_TEMPLATES_V --

226: ---------------------------------------------------------------------------
227: -- PROCEDURE Validate_Record
228: ---------------------------------------------------------------------------
229: ---------------------------------------------
230: -- Validate_Record for:OKL_PDT_TEMPLATES_V --
231: ---------------------------------------------
232: FUNCTION Validate_Record (
233: p_ptlv_rec IN ptlv_rec_type
234: ) RETURN VARCHAR2 IS

Line 689: CURSOR c1(p_name okl_pdt_templates_v.name%TYPE,

685: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
686: l_unq_tbl OKC_UTIL.unq_tbl_type;
687: l_pdt_status VARCHAR2(1);
688: l_row_found BOOLEAN := FALSE;
689: CURSOR c1(p_name okl_pdt_templates_v.name%TYPE,
690: p_version okl_pdt_templates_v.version%TYPE) IS
691: SELECT '1'
692: FROM okl_pdt_templates_v
693: WHERE name = p_name

Line 690: p_version okl_pdt_templates_v.version%TYPE) IS

686: l_unq_tbl OKC_UTIL.unq_tbl_type;
687: l_pdt_status VARCHAR2(1);
688: l_row_found BOOLEAN := FALSE;
689: CURSOR c1(p_name okl_pdt_templates_v.name%TYPE,
690: p_version okl_pdt_templates_v.version%TYPE) IS
691: SELECT '1'
692: FROM okl_pdt_templates_v
693: WHERE name = p_name
694: AND version = p_version

Line 692: FROM okl_pdt_templates_v

688: l_row_found BOOLEAN := FALSE;
689: CURSOR c1(p_name okl_pdt_templates_v.name%TYPE,
690: p_version okl_pdt_templates_v.version%TYPE) IS
691: SELECT '1'
692: FROM okl_pdt_templates_v
693: WHERE name = p_name
694: AND version = p_version
695: AND id <> NVL(p_ptlv_rec.id,-9999);
696:

Line 707: OKC_API.set_message('OKL',G_UNQS,G_TABLE_TOKEN, 'Okl_Pdt_Templates_V'); ---CHG001

703: FETCH c1 INTO l_pdt_status;
704: l_row_found := c1%FOUND;
705: CLOSE c1;
706: IF l_row_found THEN
707: OKC_API.set_message('OKL',G_UNQS,G_TABLE_TOKEN, 'Okl_Pdt_Templates_V'); ---CHG001
708: x_return_status := OKC_API.G_RET_STS_ERROR;
709: END IF;
710: EXCEPTION
711: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 840: -- validate_row for:OKL_PDT_TEMPLATES_V --

836: ---------------------------------------------------------------------------
837: -- PROCEDURE validate_row
838: ---------------------------------------------------------------------------
839: ------------------------------------------
840: -- validate_row for:OKL_PDT_TEMPLATES_V --
841: ------------------------------------------
842: PROCEDURE validate_row(
843: p_api_version IN NUMBER,
844: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 993: -- insert_row for:OKL_PDT_TEMPLATES --

989: ---------------------------------------------------------------------------
990: -- PROCEDURE insert_row
991: ---------------------------------------------------------------------------
992: --------------------------------------
993: -- insert_row for:OKL_PDT_TEMPLATES --
994: --------------------------------------
995: PROCEDURE insert_row(
996: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
997: x_return_status OUT NOCOPY VARCHAR2,

Line 1009: -- Set_Attributes for:OKL_PDT_TEMPLATES --

1005: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1006: l_ptl_rec ptl_rec_type := p_ptl_rec;
1007: l_def_ptl_rec ptl_rec_type;
1008: ------------------------------------------
1009: -- Set_Attributes for:OKL_PDT_TEMPLATES --
1010: ------------------------------------------
1011: FUNCTION Set_Attributes (
1012: p_ptl_rec IN ptl_rec_type,
1013: x_ptl_rec OUT NOCOPY ptl_rec_type

Line 1042: INSERT INTO OKL_PDT_TEMPLATES(

1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: -- defaulting to version 1.0 (suresh)
1041: l_ptl_rec.version := '1.0';
1042: INSERT INTO OKL_PDT_TEMPLATES(
1043: id,
1044: name,
1045: version,
1046: object_version_number,

Line 1104: -- insert_row for:OKL_PDT_TEMPLATES_V --

1100: '_PVT'
1101: );
1102: END insert_row;
1103: ----------------------------------------
1104: -- insert_row for:OKL_PDT_TEMPLATES_V --
1105: ----------------------------------------
1106: PROCEDURE insert_row(
1107: p_api_version IN NUMBER,
1108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1138: -- Set_Attributes for:OKL_PDT_TEMPLATES_V --

1134: l_ptlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1135: RETURN(l_ptlv_rec);
1136: END fill_who_columns;
1137: --------------------------------------------
1138: -- Set_Attributes for:OKL_PDT_TEMPLATES_V --
1139: --------------------------------------------
1140: FUNCTION Set_Attributes (
1141: p_ptlv_rec IN ptlv_rec_type,
1142: x_ptlv_rec OUT NOCOPY ptlv_rec_type

Line 1327: -- lock_row for:OKL_PDT_TEMPLATES --

1323: ---------------------------------------------------------------------------
1324: -- PROCEDURE lock_row
1325: ---------------------------------------------------------------------------
1326: ------------------------------------
1327: -- lock_row for:OKL_PDT_TEMPLATES --
1328: ------------------------------------
1329: PROCEDURE lock_row(
1330: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1331: x_return_status OUT NOCOPY VARCHAR2,

Line 1340: FROM OKL_PDT_TEMPLATES

1336: E_Resource_Busy EXCEPTION;
1337: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1338: CURSOR lock_csr (p_ptl_rec IN ptl_rec_type) IS
1339: SELECT OBJECT_VERSION_NUMBER
1340: FROM OKL_PDT_TEMPLATES
1341: WHERE ID = p_ptl_rec.id
1342: AND OBJECT_VERSION_NUMBER = p_ptl_rec.object_version_number
1343: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1344:

Line 1347: FROM OKL_PDT_TEMPLATES

1343: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1344:
1345: CURSOR lchk_csr (p_ptl_rec IN ptl_rec_type) IS
1346: SELECT OBJECT_VERSION_NUMBER
1347: FROM OKL_PDT_TEMPLATES
1348: WHERE ID = p_ptl_rec.id;
1349: l_api_version CONSTANT NUMBER := 1;
1350: l_api_name CONSTANT VARCHAR2(30) := 'TEMPLATES_lock_row';
1351: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1352: l_object_version_number OKL_PDT_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;

1348: WHERE ID = p_ptl_rec.id;
1349: l_api_version CONSTANT NUMBER := 1;
1350: l_api_name CONSTANT VARCHAR2(30) := 'TEMPLATES_lock_row';
1351: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1352: l_object_version_number OKL_PDT_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;
1353: lc_object_version_number OKL_PDT_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;
1354: l_row_notfound BOOLEAN := FALSE;
1355: lc_row_notfound BOOLEAN := FALSE;
1356: BEGIN

Line 1353: lc_object_version_number OKL_PDT_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;

1349: l_api_version CONSTANT NUMBER := 1;
1350: l_api_name CONSTANT VARCHAR2(30) := 'TEMPLATES_lock_row';
1351: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1352: l_object_version_number OKL_PDT_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;
1353: lc_object_version_number OKL_PDT_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;
1354: l_row_notfound BOOLEAN := FALSE;
1355: lc_row_notfound BOOLEAN := FALSE;
1356: BEGIN
1357: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1433: -- lock_row for:OKL_PDT_TEMPLATES_V --

1429: '_PVT'
1430: );
1431: END lock_row;
1432: --------------------------------------
1433: -- lock_row for:OKL_PDT_TEMPLATES_V --
1434: --------------------------------------
1435: PROCEDURE lock_row(
1436: p_api_version IN NUMBER,
1437: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1590: -- update_row for:OKL_PDT_TEMPLATES --

1586: ---------------------------------------------------------------------------
1587: -- PROCEDURE update_row
1588: ---------------------------------------------------------------------------
1589: --------------------------------------
1590: -- update_row for:OKL_PDT_TEMPLATES --
1591: --------------------------------------
1592: PROCEDURE update_row(
1593: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1594: x_return_status OUT NOCOPY VARCHAR2,

Line 1674: -- Set_Attributes for:OKL_PDT_TEMPLATES --

1670: END IF;
1671: RETURN(l_return_status);
1672: END populate_new_record;
1673: ------------------------------------------
1674: -- Set_Attributes for:OKL_PDT_TEMPLATES --
1675: ------------------------------------------
1676: FUNCTION Set_Attributes (
1677: p_ptl_rec IN ptl_rec_type,
1678: x_ptl_rec OUT NOCOPY ptl_rec_type

Line 1711: UPDATE OKL_PDT_TEMPLATES

1707: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1708: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1709: RAISE OKC_API.G_EXCEPTION_ERROR;
1710: END IF;
1711: UPDATE OKL_PDT_TEMPLATES
1712: SET NAME = l_def_ptl_rec.name,
1713: VERSION = l_def_ptl_rec.version,
1714: OBJECT_VERSION_NUMBER = l_def_ptl_rec.object_version_number,
1715: DESCRIPTION = l_def_ptl_rec.description,

Line 1760: -- update_row for:OKL_PDT_TEMPLATES_V --

1756: '_PVT'
1757: );
1758: END update_row;
1759: ----------------------------------------
1760: -- update_row for:OKL_PDT_TEMPLATES_V --
1761: ----------------------------------------
1762: PROCEDURE update_row(
1763: p_api_version IN NUMBER,
1764: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1859: -- Set_Attributes for:OKL_PDT_TEMPLATES_V --

1855: END IF;
1856: RETURN(l_return_status);
1857: END populate_new_record;
1858: --------------------------------------------
1859: -- Set_Attributes for:OKL_PDT_TEMPLATES_V --
1860: --------------------------------------------
1861: FUNCTION Set_Attributes (
1862: p_ptlv_rec IN ptlv_rec_type,
1863: x_ptlv_rec OUT NOCOPY ptlv_rec_type

Line 2051: -- delete_row for:OKL_PDT_TEMPLATES --

2047: ---------------------------------------------------------------------------
2048: -- PROCEDURE delete_row
2049: ---------------------------------------------------------------------------
2050: --------------------------------------
2051: -- delete_row for:OKL_PDT_TEMPLATES --
2052: --------------------------------------
2053: PROCEDURE delete_row(
2054: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2055: x_return_status OUT NOCOPY VARCHAR2,

Line 2075: DELETE FROM OKL_PDT_TEMPLATES

2071: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2072: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2073: RAISE OKC_API.G_EXCEPTION_ERROR;
2074: END IF;
2075: DELETE FROM OKL_PDT_TEMPLATES
2076: WHERE ID = l_ptl_rec.id;
2077:
2078: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2079: EXCEPTION

Line 2112: -- delete_row for:OKL_PDT_TEMPLATES_V --

2108: '_PVT'
2109: );
2110: END delete_row;
2111: ----------------------------------------
2112: -- delete_row for:OKL_PDT_TEMPLATES_V --
2113: ----------------------------------------
2114: PROCEDURE delete_row(
2115: p_api_version IN NUMBER,
2116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,