DBA Data[Home] [Help]

APPS.JTF_PERZ_DATA_PUB dependencies on JTF_PERZ_DATA_PUB

Line 1: PACKAGE BODY JTF_PERZ_DATA_PUB as

1: PACKAGE BODY JTF_PERZ_DATA_PUB as
2: /* $Header: jtfzppdb.pls 120.2 2005/11/02 03:46:52 skothe ship $ */
3: --
4: --
5: -- Start of Comments

Line 8: -- JTF_PERZ_DATA_PUB

4: --
5: -- Start of Comments
6: --
7: -- NAME
8: -- JTF_PERZ_DATA_PUB
9: --
10: -- PURPOSE
11: -- Public API for creating, getting and updating personalized data objects
12: -- in the Personalization Framework.

Line 26: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_DATA_PUB';

22: -- End of Comments
23: -- *****************************************************************************
24:
25:
26: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_DATA_PUB';
27: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfppzdb.pls';
28:
29:
30: -- *****************************************************************************

Line 48: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE

44: p_perz_data_id IN NUMBER,
45: p_perz_data_name IN VARCHAR2,
46: p_perz_data_type IN VARCHAR2,
47: p_perz_data_desc IN VARCHAR2,
48: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
49: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
50:
51: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
52: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 49: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,

45: p_perz_data_name IN VARCHAR2,
46: p_perz_data_type IN VARCHAR2,
47: p_perz_data_desc IN VARCHAR2,
48: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
49: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
50:
51: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
52: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
53: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 172: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE

168: p_perz_data_id IN NUMBER,
169: p_perz_data_name IN VARCHAR2,
170: p_perz_data_type IN VARCHAR2,
171: p_perz_data_desc IN VARCHAR2,
172: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
173: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
174:
175: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
176: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 173: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,

169: p_perz_data_name IN VARCHAR2,
170: p_perz_data_type IN VARCHAR2,
171: p_perz_data_desc IN VARCHAR2,
172: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
173: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
174:
175: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
176: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
177: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 298: x_data_attrib_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE,

294: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
295: x_perz_data_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
296: x_perz_data_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
297: x_perz_data_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
298: x_data_attrib_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE,
299:
300: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
301: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
302: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 405: x_data_out_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DATA_PUB.DATA_OUT_TBL_TYPE,

401: p_perz_data_id IN NUMBER,
402: p_perz_data_name IN VARCHAR2,
403: p_perz_data_type IN VARCHAR2 := NULL,
404:
405: x_data_out_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DATA_PUB.DATA_OUT_TBL_TYPE,
406:
407: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
408: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
409: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 504: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE

500: p_perz_data_id IN NUMBER,
501: p_perz_data_name IN VARCHAR2,
502: p_perz_data_type IN VARCHAR2 := NULL,
503: p_perz_data_desc IN VARCHAR2,
504: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
505: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
506:
507: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
508: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 505: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,

501: p_perz_data_name IN VARCHAR2,
502: p_perz_data_type IN VARCHAR2 := NULL,
503: p_perz_data_desc IN VARCHAR2,
504: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
505: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
506:
507: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
508: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
509: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 725: END JTF_PERZ_DATA_PUB;

721: -- *****************************************************************************
722: -- *****************************************************************************
723:
724:
725: END JTF_PERZ_DATA_PUB;