[Home] [Help]
PACKAGE: APPS.QLTTRAFB
Source
1 PACKAGE QLTTRAFB AUTHID CURRENT_USER as
2 /* $Header: qlttrafb.pls 120.1 2005/10/10 02:55:22 ntungare noship $ */
3
4 -- 5/21/96 - CREATED
5 -- Paul Mishkin
6
7 FUNCTION FORMAT_SQL_VALIDATION_STRING (X_STRING VARCHAR2) RETURN VARCHAR2;
8 FUNCTION VALIDATE_TYPE(X_VALUE VARCHAR2, X_DATATYPE NUMBER) RETURN BOOLEAN;
9 PROCEDURE EXEC_SQL (STRING IN VARCHAR2);
10 FUNCTION DECODE_ACTION_VALUE_LOOKUP (NUM NUMBER) RETURN VARCHAR2;
11 FUNCTION DECODE_OPERATOR (OP NUMBER) RETURN VARCHAR2;
12
13 PROCEDURE VALIDATE_DISABLED(COL_NAME VARCHAR2,
14 ERROR_COL_NAME VARCHAR2,
15 ERROR_MESSAGE VARCHAR2,
16 X_GROUP_ID NUMBER,
17 X_USER_ID NUMBER,
18 X_LAST_UPDATE_LOGIN NUMBER,
19 X_REQUEST_ID NUMBER,
20 X_PROGRAM_APPLICATION_ID NUMBER,
21 X_PROGRAM_ID NUMBER);
22
23 PROCEDURE VALIDATE_MANDATORY(COL_NAME VARCHAR2,
24 ERROR_COL_NAME VARCHAR2,
25 ERROR_MESSAGE VARCHAR2,
26 X_GROUP_ID NUMBER,
27 X_USER_ID NUMBER,
28 X_LAST_UPDATE_LOGIN NUMBER,
29 X_REQUEST_ID NUMBER,
30 X_PROGRAM_APPLICATION_ID NUMBER,
31 X_PROGRAM_ID NUMBER,
32 PARENT_COL_NAME VARCHAR2,
33 ERROR_COL_LIST VARCHAR2);
34
35 PROCEDURE VALIDATE_LOOKUPS(COL_NAME VARCHAR2,
36 ERROR_COL_NAME VARCHAR2,
37 ERROR_MESSAGE VARCHAR2,
38 X_GROUP_ID NUMBER,
39 X_USER_ID NUMBER,
40 X_LAST_UPDATE_LOGIN NUMBER,
41 X_REQUEST_ID NUMBER,
42 X_PROGRAM_APPLICATION_ID NUMBER,
43 X_PROGRAM_ID NUMBER,
44 X_CHAR_ID NUMBER,
45 X_PLAN_ID NUMBER,
46 ERROR_COL_LIST VARCHAR2);
47
48 PROCEDURE VALIDATE_PARENT_ENTERED(COL_NAME VARCHAR2,
49 ERROR_COL_NAME VARCHAR2,
50 ERROR_MESSAGE VARCHAR2,
51 X_GROUP_ID NUMBER,
52 X_USER_ID NUMBER,
53 X_LAST_UPDATE_LOGIN NUMBER,
54 X_REQUEST_ID NUMBER,
55 X_PROGRAM_APPLICATION_ID NUMBER,
56 X_PROGRAM_ID NUMBER,
57 PARENT_COL_NAME VARCHAR2,
58 ERROR_COL_LIST VARCHAR2);
59
60 -- Tracking Bug : 3104827. Review Tracking Bug : 3148873
61 -- Added for Read Only for Flag Collection Plan Elements
62 -- saugupta Thu Aug 28 08:59:59 PDT 2003
63 PROCEDURE VALIDATE_READ_ONLY(P_COL_NAME VARCHAR2,
64 P_ERROR_COL_NAME VARCHAR2,
65 P_ERROR_MESSAGE VARCHAR2,
66 P_GROUP_ID NUMBER,
67 P_USER_ID NUMBER,
68 P_LAST_UPDATE_LOGIN NUMBER,
69 P_REQUEST_ID NUMBER,
70 P_PROGRAM_APPLICATION_ID NUMBER,
71 P_PROGRAM_ID NUMBER,
72 P_PARENT_COL_NAME VARCHAR2,
73 P_ERROR_COL_LIST VARCHAR2);
74
75 --
76 -- BUG 4635316
77 -- Added the Function already present in the Package Body to the spec
78 -- Replaces every occurrence of X_OLD_TOKEN, in upper, lower, or mixed
79 -- case, with X_NEW_TOKEN. Assumes that both tokens are sent in upper case.
80 -- ntungare Sun Oct 9 23:54:14 PDT 2005
81 --
82 FUNCTION REPLACE_TOKEN( X_STRING VARCHAR2,
83 X_OLD_TOKEN VARCHAR2,
84 X_NEW_TOKEN VARCHAR2 ) RETURN VARCHAR2;
85
86
87 END QLTTRAFB;
88