eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

PACKAGE: APPS.OKC_XPRT_QUESTION_PVT

Source


1 PACKAGE OKC_XPRT_QUESTION_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVXIQS.pls 120.1 2011/03/10 18:16:51 harchand noship $ */
3 
4 
5   TYPE xprt_qn_const_rec_type IS RECORD(
6     QN_CONST_ID            OKC_XPRT_QUESTIONS_B.QUESTION_ID%TYPE := OKC_API.G_MISS_NUM,
7     QN_CONST_TYPE          OKC_XPRT_QUESTIONS_B.QUESTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
8     QN_CONST_INTENT        OKC_XPRT_QUESTIONS_B.QUESTION_INTENT%TYPE := OKC_API.G_MISS_CHAR,
9     DISABLED_FLAG          OKC_XPRT_QUESTIONS_B.DISABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
10     QUESTION_DATATYPE      OKC_XPRT_QUESTIONS_B.QUESTION_DATATYPE%TYPE := OKC_API.G_MISS_CHAR,
11     VALUE_SET_NAME         OKC_XPRT_QUESTIONS_B.VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR,
12     DEFAULT_VALUE          OKC_XPRT_QUESTIONS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_NUM,
13     MINIMUM_VALUE          OKC_XPRT_QUESTIONS_B.MINIMUM_VALUE%TYPE := OKC_API.G_MISS_NUM,
14     MAXIMUM_VALUE          OKC_XPRT_QUESTIONS_B.MAXIMUM_VALUE%TYPE := OKC_API.G_MISS_NUM,
15     QUESTION_SYNC_FLAG     OKC_XPRT_QUESTIONS_B.QUESTION_SYNC_FLAG%TYPE := OKC_API.G_MISS_CHAR,
16     OBJECT_VERSION_NUMBER  OKC_XPRT_QUESTIONS_B.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM,
17     CREATED_BY             NUMBER := OKC_API.G_MISS_NUM,
18     CREATION_DATE          OKC_XPRT_QUESTIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19     LAST_UPDATED_BY        NUMBER := OKC_API.G_MISS_NUM,
20     LAST_UPDATE_DATE       OKC_XPRT_QUESTIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21     LAST_UPDATE_LOGIN      NUMBER := OKC_API.G_MISS_NUM,
22     PROGRAM_ID             NUMBER := OKC_API.G_MISS_NUM,
23     REQUEST_ID             NUMBER := OKC_API.G_MISS_NUM,
24     PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM,
25     PROGRAM_UPDATE_DATE    OKC_XPRT_QUESTIONS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
26     QN_CONST_NAME          OKC_XPRT_QUESTIONS_TL.QUESTION_NAME%TYPE := OKC_API.G_MISS_CHAR,
27     LANG                   OKC_XPRT_QUESTIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
28     SOURCE_LANG            OKC_XPRT_QUESTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
29     DESCRIPTION            OKC_XPRT_QUESTIONS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
30     PROMPT                 OKC_XPRT_QUESTIONS_TL.PROMPT%TYPE := OKC_API.G_MISS_CHAR,
31     STS                    VARCHAR2(1),
32     MSG                    VARCHAR2(2000));
33 
34   TYPE xprt_qn_const_tbl_type IS TABLE OF xprt_qn_const_rec_type INDEX BY PLS_INTEGER;
35 
36   PROCEDURE create_question(p_xprt_question_rec IN OUT NOCOPY xprt_qn_const_rec_type,
37                             p_commit                       IN VARCHAR2 := FND_API.G_FALSE,
38                             x_return_status     OUT NOCOPY VARCHAR2,
39                             x_msg_data          OUT NOCOPY VARCHAR2);
40 
41   PROCEDURE update_question(p_xprt_update_question_rec IN OUT NOCOPY xprt_qn_const_rec_type,
42                             p_commit                   IN VARCHAR2 := FND_API.G_FALSE,
43                             x_return_status            OUT NOCOPY VARCHAR2,
44                             x_msg_data                 OUT NOCOPY VARCHAR2);
45 
46 END OKC_XPRT_QUESTION_PVT;