APPS.JTF_PERZ_DATA_PVT dependencies on JTF_PERZ_DATA_PUB

Line 267: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE

263: p_perz_data_id IN NUMBER,
264: p_perz_data_name IN VARCHAR2,
265: p_perz_data_type IN VARCHAR2,
266: p_perz_data_desc IN VARCHAR2,
267: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
268: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
269:
270: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
271: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 268: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,

264: p_perz_data_name IN VARCHAR2,
265: p_perz_data_type IN VARCHAR2,
266: p_perz_data_desc IN VARCHAR2,
267: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
268: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
269:
270: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
271: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
272: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 511: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE

507: p_perz_data_id IN NUMBER,
508: p_perz_data_name IN VARCHAR2,
509: p_perz_data_type IN VARCHAR2,
510: p_perz_data_desc IN VARCHAR2,
511: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
512: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
513:
514: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
515: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 512: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,

508: p_perz_data_name IN VARCHAR2,
509: p_perz_data_type IN VARCHAR2,
510: p_perz_data_desc IN VARCHAR2,
511: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
512: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
513:
514: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
515: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
516: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

682: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
683: x_perz_data_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
684: x_perz_data_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
685: x_perz_data_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
686: x_data_attrib_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE,
687:
688: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
689: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
690: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 701: l_data_out_tbl JTF_PERZ_DATA_PUB.DATA_OUT_TBL_TYPE;

697:
698: -- ******* Get_Perz_Data Local Variables ********
699: l_perz_data_id NUMBER := p_perz_data_id;
700: l_count NUMBER := NULL;
701: l_data_out_tbl JTF_PERZ_DATA_PUB.DATA_OUT_TBL_TYPE;
702:
703: -- temp variables
704:
705: l_PERZ_DATA_ATTRIB_ID_temp NUMBER := NULL;

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

867: p_perz_data_id IN NUMBER,
868: p_perz_data_name IN VARCHAR2,
869: p_perz_data_type IN VARCHAR2 := NULL,
870:
871: x_data_out_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DATA_PUB.DATA_OUT_TBL_TYPE,
872:
873: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
874: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
875: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 890: l_perz_data_temp_rec JTF_PERZ_DATA_PUB.DATA_OUT_REC_TYPE;

886: l_count NUMBER := NULL;
887:
888: -- Temporary Variables
889: -- SMATTEGU Enhancement #1181062 Begin
890: l_perz_data_temp_rec JTF_PERZ_DATA_PUB.DATA_OUT_REC_TYPE;
891: -- Instead of individual temp variables, this will be referred in the select
892: -- into statements etc.
893: -- SMATTEGU Enhancement #1181062 End
894: /*

Line 1239: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE

1235: p_perz_data_id IN NUMBER,
1236: p_perz_data_name IN VARCHAR2,
1237: p_perz_data_type IN VARCHAR2 := NULL,
1238: p_perz_data_desc IN VARCHAR2,
1239: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
1240: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
1241:
1242: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1243: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1240: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,

1236: p_perz_data_name IN VARCHAR2,
1237: p_perz_data_type IN VARCHAR2 := NULL,
1238: p_perz_data_desc IN VARCHAR2,
1239: p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
1240: := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
1241:
1242: x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1243: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1244: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,