[Home] [Help]
95: TYPE rule_condition_tbl_type IS TABLE OF rule_condition_rec_type INDEX BY PLS_INTEGER;
96:
97: TYPE rule_header_rec_type IS RECORD
98: (
99: RULE_ID OKC_XPRT_RULE_HDRS_ALL.RULE_ID%TYPE := OKC_API.G_MISS_NUM
100: ,ORG_ID OKC_XPRT_RULE_HDRS_ALL.ORG_ID%TYPE := OKC_API.G_MISS_NUM
101: ,INTENT OKC_XPRT_RULE_HDRS_ALL.INTENT%TYPE := OKC_API.G_MISS_CHAR
102: ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
96:
97: TYPE rule_header_rec_type IS RECORD
98: (
99: RULE_ID OKC_XPRT_RULE_HDRS_ALL.RULE_ID%TYPE := OKC_API.G_MISS_NUM
100: ,ORG_ID OKC_XPRT_RULE_HDRS_ALL.ORG_ID%TYPE := OKC_API.G_MISS_NUM
101: ,INTENT OKC_XPRT_RULE_HDRS_ALL.INTENT%TYPE := OKC_API.G_MISS_CHAR
102: ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
104: ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
97: TYPE rule_header_rec_type IS RECORD
98: (
99: RULE_ID OKC_XPRT_RULE_HDRS_ALL.RULE_ID%TYPE := OKC_API.G_MISS_NUM
100: ,ORG_ID OKC_XPRT_RULE_HDRS_ALL.ORG_ID%TYPE := OKC_API.G_MISS_NUM
101: ,INTENT OKC_XPRT_RULE_HDRS_ALL.INTENT%TYPE := OKC_API.G_MISS_CHAR
102: ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
104: ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
105: ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR
98: (
99: RULE_ID OKC_XPRT_RULE_HDRS_ALL.RULE_ID%TYPE := OKC_API.G_MISS_NUM
100: ,ORG_ID OKC_XPRT_RULE_HDRS_ALL.ORG_ID%TYPE := OKC_API.G_MISS_NUM
101: ,INTENT OKC_XPRT_RULE_HDRS_ALL.INTENT%TYPE := OKC_API.G_MISS_CHAR
102: ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
104: ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
105: ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR
106: ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%TYPE := OKC_API.G_MISS_CHAR
99: RULE_ID OKC_XPRT_RULE_HDRS_ALL.RULE_ID%TYPE := OKC_API.G_MISS_NUM
100: ,ORG_ID OKC_XPRT_RULE_HDRS_ALL.ORG_ID%TYPE := OKC_API.G_MISS_NUM
101: ,INTENT OKC_XPRT_RULE_HDRS_ALL.INTENT%TYPE := OKC_API.G_MISS_CHAR
102: ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
104: ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
105: ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR
106: ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%TYPE := OKC_API.G_MISS_CHAR
107: ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_CODE%TYPE := OKC_API.G_MISS_CHAR
100: ,ORG_ID OKC_XPRT_RULE_HDRS_ALL.ORG_ID%TYPE := OKC_API.G_MISS_NUM
101: ,INTENT OKC_XPRT_RULE_HDRS_ALL.INTENT%TYPE := OKC_API.G_MISS_CHAR
102: ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
104: ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
105: ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR
106: ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%TYPE := OKC_API.G_MISS_CHAR
107: ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,REQUEST_ID NUMBER := OKC_API.G_MISS_NUM
101: ,INTENT OKC_XPRT_RULE_HDRS_ALL.INTENT%TYPE := OKC_API.G_MISS_CHAR
102: ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
104: ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
105: ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR
106: ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%TYPE := OKC_API.G_MISS_CHAR
107: ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,REQUEST_ID NUMBER := OKC_API.G_MISS_NUM
109: ,RULE_TYPE OKC_XPRT_RULE_HDRS_ALL.RULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
102: ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
104: ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
105: ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR
106: ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%TYPE := OKC_API.G_MISS_CHAR
107: ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,REQUEST_ID NUMBER := OKC_API.G_MISS_NUM
109: ,RULE_TYPE OKC_XPRT_RULE_HDRS_ALL.RULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
110: ,LINE_LEVEL_FLAG OKC_XPRT_RULE_HDRS_ALL.LINE_LEVEL_FLAG%TYPE := OKC_API.G_MISS_CHAR
103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%TYPE := OKC_API.G_MISS_CHAR
104: ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
105: ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR
106: ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%TYPE := OKC_API.G_MISS_CHAR
107: ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,REQUEST_ID NUMBER := OKC_API.G_MISS_NUM
109: ,RULE_TYPE OKC_XPRT_RULE_HDRS_ALL.RULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
110: ,LINE_LEVEL_FLAG OKC_XPRT_RULE_HDRS_ALL.LINE_LEVEL_FLAG%TYPE := OKC_API.G_MISS_CHAR
111: ,OBJECT_VERSION_NUMBER OKC_XPRT_RULE_HDRS_ALL.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
105: ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR
106: ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%TYPE := OKC_API.G_MISS_CHAR
107: ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,REQUEST_ID NUMBER := OKC_API.G_MISS_NUM
109: ,RULE_TYPE OKC_XPRT_RULE_HDRS_ALL.RULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
110: ,LINE_LEVEL_FLAG OKC_XPRT_RULE_HDRS_ALL.LINE_LEVEL_FLAG%TYPE := OKC_API.G_MISS_CHAR
111: ,OBJECT_VERSION_NUMBER OKC_XPRT_RULE_HDRS_ALL.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
112: ,CREATED_BY NUMBER := OKC_API.G_MISS_NUM
113: ,CREATION_DATE OKC_XPRT_RULE_HDRS_ALL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%TYPE := OKC_API.G_MISS_CHAR
107: ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,REQUEST_ID NUMBER := OKC_API.G_MISS_NUM
109: ,RULE_TYPE OKC_XPRT_RULE_HDRS_ALL.RULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
110: ,LINE_LEVEL_FLAG OKC_XPRT_RULE_HDRS_ALL.LINE_LEVEL_FLAG%TYPE := OKC_API.G_MISS_CHAR
111: ,OBJECT_VERSION_NUMBER OKC_XPRT_RULE_HDRS_ALL.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
112: ,CREATED_BY NUMBER := OKC_API.G_MISS_NUM
113: ,CREATION_DATE OKC_XPRT_RULE_HDRS_ALL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
107: ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,REQUEST_ID NUMBER := OKC_API.G_MISS_NUM
109: ,RULE_TYPE OKC_XPRT_RULE_HDRS_ALL.RULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
110: ,LINE_LEVEL_FLAG OKC_XPRT_RULE_HDRS_ALL.LINE_LEVEL_FLAG%TYPE := OKC_API.G_MISS_CHAR
111: ,OBJECT_VERSION_NUMBER OKC_XPRT_RULE_HDRS_ALL.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
112: ,CREATED_BY NUMBER := OKC_API.G_MISS_NUM
113: ,CREATION_DATE OKC_XPRT_RULE_HDRS_ALL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
115: ,LAST_UPDATE_DATE OKC_XPRT_RULE_HDRS_ALL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
109: ,RULE_TYPE OKC_XPRT_RULE_HDRS_ALL.RULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
110: ,LINE_LEVEL_FLAG OKC_XPRT_RULE_HDRS_ALL.LINE_LEVEL_FLAG%TYPE := OKC_API.G_MISS_CHAR
111: ,OBJECT_VERSION_NUMBER OKC_XPRT_RULE_HDRS_ALL.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
112: ,CREATED_BY NUMBER := OKC_API.G_MISS_NUM
113: ,CREATION_DATE OKC_XPRT_RULE_HDRS_ALL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
115: ,LAST_UPDATE_DATE OKC_XPRT_RULE_HDRS_ALL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
116: ,LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
117: ,PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM
111: ,OBJECT_VERSION_NUMBER OKC_XPRT_RULE_HDRS_ALL.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
112: ,CREATED_BY NUMBER := OKC_API.G_MISS_NUM
113: ,CREATION_DATE OKC_XPRT_RULE_HDRS_ALL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
115: ,LAST_UPDATE_DATE OKC_XPRT_RULE_HDRS_ALL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
116: ,LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
117: ,PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM
118: ,PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM
119: ,PROGRAM_UPDATE_DATE OKC_XPRT_RULE_HDRS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
115: ,LAST_UPDATE_DATE OKC_XPRT_RULE_HDRS_ALL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
116: ,LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
117: ,PROGRAM_ID NUMBER := OKC_API.G_MISS_NUM
118: ,PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM
119: ,PROGRAM_UPDATE_DATE OKC_XPRT_RULE_HDRS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
120: );
121: TYPE rule_header_tbl_type IS TABLE OF rule_header_rec_type INDEX BY PLS_INTEGER;
122:
123: TYPE rule_rec_type IS RECORD