1: Package Body JTF_TERR_JSP_LOV_RECS_PUB AS
2: /* $Header: jtfpjlvb.pls 120.5.12010000.2 2008/08/20 08:26:15 rajukum ship $ */
3:
4: ---------------------------------------------------------
5: -- Start of Comments
3:
4: ---------------------------------------------------------
5: -- Start of Comments
6: -- ---------------------------------------------------
7: -- PACKAGE NAME: JTF_TERR_JSP_LOV_RECS_PUB
8: -- ---------------------------------------------------
9: -- PURPOSE
10: -- JTF/A Territories LOV Package
11: -- NOTES
24: --
25: -- ***************************************************
26: -- GLOBAL VARIABLES
27: -- ***************************************************
28: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_JSP_LOV_RECS_PUB';
29: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfpjlvb.pls';
30:
31: G_NEW_LINE VARCHAR2(02);
32: G_APPL_ID NUMBER;
36: G_REQUEST_ID NUMBER;
37: G_APP_SHORT_NAME VARCHAR2(15);
38: G_test_var NUMBER;
39: G_test_var2 NUMBER;
40: G_dyn_result_tbl JTF_TERR_JSP_LOV_RECS_PUB.lov_output_tbl_type;
41:
42: --TYPE GenericCurTyp IS REF CURSOR;
43: TYPE Lov_output_cur_type IS REF CURSOR RETURN lov_inout_rec_type;
44:
556: end if; -- qualifier_values or other data group?
557:
558: END Get_LOV_Records;
559:
560: END JTF_TERR_JSP_LOV_RECS_PUB;