DBA Data[Home] [Help]

APPS.OKC_XPRT_RULE_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL

Line 99: RULE_ID OKC_XPRT_RULE_HDRS_ALL.RULE_ID%TYPE := OKC_API.G_MISS_NUM

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

Line 100: ,ORG_ID OKC_XPRT_RULE_HDRS_ALL.ORG_ID%TYPE := OKC_API.G_MISS_NUM

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

Line 101: ,INTENT OKC_XPRT_RULE_HDRS_ALL.INTENT%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

Line 102: ,STATUS_CODE OKC_XPRT_RULE_HDRS_ALL.STATUS_CODE%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

Line 103: ,RULE_NAME OKC_XPRT_RULE_HDRS_ALL.RULE_NAME%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

Line 104: ,RULE_DESCRIPTION OKC_XPRT_RULE_HDRS_ALL.RULE_DESCRIPTION%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

Line 105: ,ORG_WIDE_FLAG OKC_XPRT_RULE_HDRS_ALL.ORG_WIDE_FLAG%TYPE := OKC_API.G_MISS_CHAR

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

Line 106: ,PUBLISHED_FLAG OKC_XPRT_RULE_HDRS_ALL.PUBLISHED_FLAG%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

Line 107: ,CONDITION_EXPR_CODE OKC_XPRT_RULE_HDRS_ALL.CONDITION_EXPR_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
111: ,OBJECT_VERSION_NUMBER OKC_XPRT_RULE_HDRS_ALL.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM

Line 109: ,RULE_TYPE OKC_XPRT_RULE_HDRS_ALL.RULE_TYPE%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
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

Line 110: ,LINE_LEVEL_FLAG OKC_XPRT_RULE_HDRS_ALL.LINE_LEVEL_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
114: ,LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM

Line 111: ,OBJECT_VERSION_NUMBER OKC_XPRT_RULE_HDRS_ALL.OBJECT_VERSION_NUMBER%TYPE := 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

Line 113: ,CREATION_DATE OKC_XPRT_RULE_HDRS_ALL.CREATION_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

Line 115: ,LAST_UPDATE_DATE OKC_XPRT_RULE_HDRS_ALL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 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