1: PACKAGE BODY AST_API_RECORDS_PKG AS
2: /* $Header: astutirb.pls 120.4 2005/11/07 07:54:12 rkumares ship $ */
3:
4: -- *****************************************************
5: FUNCTION Init_JTF_Perz_Query_Raw_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE IS
6: l_return_rec JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE;
7: BEGIN
8: l_return_rec := JTF_PERZ_QUERY_PUB.G_MISS_QUERY_RAW_SQL_REC;
9: RETURN l_return_rec ;
2: /* $Header: astutirb.pls 120.4 2005/11/07 07:54:12 rkumares ship $ */
3:
4: -- *****************************************************
5: FUNCTION Init_JTF_Perz_Query_Raw_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE IS
6: l_return_rec JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE;
7: BEGIN
8: l_return_rec := JTF_PERZ_QUERY_PUB.G_MISS_QUERY_RAW_SQL_REC;
9: RETURN l_return_rec ;
10: END;
4: -- *****************************************************
5: FUNCTION Init_JTF_Perz_Query_Raw_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE IS
6: l_return_rec JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE;
7: BEGIN
8: l_return_rec := JTF_PERZ_QUERY_PUB.G_MISS_QUERY_RAW_SQL_REC;
9: RETURN l_return_rec ;
10: END;
11: -- *****************************************************
12: FUNCTION Init_JTF_Perz_Query_Param_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE IS
8: l_return_rec := JTF_PERZ_QUERY_PUB.G_MISS_QUERY_RAW_SQL_REC;
9: RETURN l_return_rec ;
10: END;
11: -- *****************************************************
12: FUNCTION Init_JTF_Perz_Query_Param_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE IS
13: l_return_rec JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE;
14: BEGIN
15: RETURN l_return_rec ;
16: END;
9: RETURN l_return_rec ;
10: END;
11: -- *****************************************************
12: FUNCTION Init_JTF_Perz_Query_Param_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE IS
13: l_return_rec JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE;
14: BEGIN
15: RETURN l_return_rec ;
16: END;
17: -- *****************************************************
14: BEGIN
15: RETURN l_return_rec ;
16: END;
17: -- *****************************************************
18: FUNCTION Init_JTF_Perz_Query_Order_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE IS
19: l_return_rec JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE;
20: BEGIN
21: RETURN l_return_rec ;
22: END;
15: RETURN l_return_rec ;
16: END;
17: -- *****************************************************
18: FUNCTION Init_JTF_Perz_Query_Order_Rec RETURN JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE IS
19: l_return_rec JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE;
20: BEGIN
21: RETURN l_return_rec ;
22: END;
23: -- *****************************************************
26: BEGIN
27: RETURN l_return_rec ;
28: END;
29: -- *****************************************************
30: PROCEDURE Init_Record ( x_query_raw_rec IN OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_QUERY_PUB.QUERY_RAW_SQL_REC_TYPE) IS
31: BEGIN
32: x_query_raw_rec := Init_JTF_Perz_Query_Raw_Rec;
33: END;
34: -- *****************************************************
31: BEGIN
32: x_query_raw_rec := Init_JTF_Perz_Query_Raw_Rec;
33: END;
34: -- *****************************************************
35: PROCEDURE Init_Record ( x_query_param_rec IN OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_QUERY_PUB.QUERY_PARAMETER_REC_TYPE) IS
36: BEGIN
37: x_query_param_rec := Init_JTF_Perz_Query_Param_Rec;
38: END;
39: -- *****************************************************
36: BEGIN
37: x_query_param_rec := Init_JTF_Perz_Query_Param_Rec;
38: END;
39: -- *****************************************************
40: PROCEDURE Init_Record ( x_query_order_rec IN OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_QUERY_PUB.QUERY_ORDER_BY_REC_TYPE) IS
41: BEGIN
42: x_query_order_rec := Init_JTF_Perz_Query_Order_Rec;
43: END;
44: -- *****************************************************