PACKAGE: APPS.CSC_PROFILE_CHECK_RULES_PKG

Source

1 PACKAGE CSC_PROFILE_CHECK_RULES_PKG AUTHID CURRENT_USER as
2 /* $Header: csctpcrs.pls 115.15 2002/12/03 17:56:06 jamose ship $ */
3 -- Start of Comments
4 -- Package name     : CSC_PROFILE_CHECK_RULES_PKG
5 -- Purpose          :
6 -- History          :26 Nov 02 jamose made changes for the NOCOPY and FND_API.G_MISS*
7 -- 08-NOV-00  madhavan Added procedures translate_row and load_row. Fix to
8 --                     bug # 1491205
9 -- NOTE             :
10 -- End of Comments
11 
12 PROCEDURE Insert_Row(
13           p_CHECK_ID   IN NUMBER,
14           p_SEQUENCE    NUMBER,
15           p_CREATED_BY    NUMBER,
16           p_CREATION_DATE    DATE,
17           p_LAST_UPDATED_BY    NUMBER,
18           p_LAST_UPDATE_DATE    DATE,
19           p_LAST_UPDATE_LOGIN    NUMBER,
20           p_LOGICAL_OPERATOR    VARCHAR2,
21           p_LEFT_PAREN    VARCHAR2,
22           p_BLOCK_ID    NUMBER,
23           p_COMPARISON_OPERATOR    VARCHAR2,
24           p_EXPRESSION    VARCHAR2,
25           p_EXPR_TO_BLOCK_ID    NUMBER,
26           p_RIGHT_PAREN    VARCHAR2,
27           p_SEEDED_FLAG    VARCHAR2,
28           X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER);
29 
30 PROCEDURE Update_Row(
31           p_CHECK_ID    NUMBER,
32           p_SEQUENCE    NUMBER,
33           p_LAST_UPDATED_BY    NUMBER,
34           p_LAST_UPDATE_DATE    DATE,
35           p_LAST_UPDATE_LOGIN    NUMBER,
36           p_LOGICAL_OPERATOR    VARCHAR2,
37           p_LEFT_PAREN    VARCHAR2,
38           p_BLOCK_ID    NUMBER,
39           p_COMPARISON_OPERATOR    VARCHAR2,
40           p_EXPRESSION    VARCHAR2,
41           p_EXPR_TO_BLOCK_ID    NUMBER,
42           p_RIGHT_PAREN    VARCHAR2,
43           p_SEEDED_FLAG    VARCHAR2,
44           px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER );
45 
46 procedure LOCK_ROW (
47   P_CHECK_ID in NUMBER,
48   P_SEQUENCE IN NUMBER,
49   P_OBJECT_VERSION_NUMBER in NUMBER );
50 
51 procedure DELETE_ROW (
52   P_CHECK_ID    NUMBER,
53   P_SEQUENCE    NUMBER,
54   P_OBJECT_VERSION_NUMBER NUMBER  );
55 
56 procedure ADD_LANGUAGE;
57 
58 procedure TRANSLATE_ROW (
59   p_check_id      IN    NUMBER,
60   p_sequence      IN    NUMBER,
61   p_expression    IN    VARCHAR2,
62   p_owner         IN    VARCHAR2);
63 
64 PROCEDURE LOAD_ROW (
65             p_CHECK_ID                IN NUMBER,
66             p_SEQUENCE                IN NUMBER,
67             p_LAST_UPDATED_BY         IN NUMBER,
68             p_LAST_UPDATE_DATE        IN DATE,
69             p_LAST_UPDATE_LOGIN       IN NUMBER,
70             p_LOGICAL_OPERATOR        IN VARCHAR2,
71             p_LEFT_PAREN              IN VARCHAR2,
72             p_BLOCK_ID                IN NUMBER,
73             p_COMPARISON_OPERATOR     IN VARCHAR2,
74             p_EXPRESSION              IN VARCHAR2,
75             p_EXPR_TO_BLOCK_ID        IN NUMBER,
76             p_RIGHT_PAREN             IN VARCHAR2,
77             p_SEEDED_FLAG             IN VARCHAR2,
78             px_OBJECT_VERSION_NUMBER  IN OUT NOCOPY NUMBER,
79             p_OWNER                   IN VARCHAR2);
80 
81 End CSC_PROFILE_CHECK_RULES_PKG;