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.

APPS.OKC_XPRT_RULE_PVT dependencies on OKC_API

Line 15: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

11: ---------------------------------------------------------------------------
12: -- GLOBAL VARIABLES
13: ---------------------------------------------------------------------------
14: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_RULE_PVT';
15: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16:
17: ------------------------------------------------------------------------------
18: -- GLOBAL CONSTANTS
19: ------------------------------------------------------------------------------

Line 31: ( template_rule_id OKC_XPRT_TEMPLATE_RULES.template_rule_id%TYPE := OKC_API.G_MISS_NUM

27:
28:
29: TYPE template_rules_rec_type
30: IS RECORD
31: ( template_rule_id OKC_XPRT_TEMPLATE_RULES.template_rule_id%TYPE := OKC_API.G_MISS_NUM
32: , template_id OKC_XPRT_TEMPLATE_RULES.template_id%TYPE := OKC_API.G_MISS_NUM
33: , rule_id OKC_XPRT_TEMPLATE_RULES.rule_id%TYPE := OKC_API.G_MISS_NUM
34: , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR
35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR

Line 32: , template_id OKC_XPRT_TEMPLATE_RULES.template_id%TYPE := OKC_API.G_MISS_NUM

28:
29: TYPE template_rules_rec_type
30: IS RECORD
31: ( template_rule_id OKC_XPRT_TEMPLATE_RULES.template_rule_id%TYPE := OKC_API.G_MISS_NUM
32: , template_id OKC_XPRT_TEMPLATE_RULES.template_id%TYPE := OKC_API.G_MISS_NUM
33: , rule_id OKC_XPRT_TEMPLATE_RULES.rule_id%TYPE := OKC_API.G_MISS_NUM
34: , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR
35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR
36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM

Line 33: , rule_id OKC_XPRT_TEMPLATE_RULES.rule_id%TYPE := OKC_API.G_MISS_NUM

29: TYPE template_rules_rec_type
30: IS RECORD
31: ( template_rule_id OKC_XPRT_TEMPLATE_RULES.template_rule_id%TYPE := OKC_API.G_MISS_NUM
32: , template_id OKC_XPRT_TEMPLATE_RULES.template_id%TYPE := OKC_API.G_MISS_NUM
33: , rule_id OKC_XPRT_TEMPLATE_RULES.rule_id%TYPE := OKC_API.G_MISS_NUM
34: , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR
35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR
36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM
37: , created_by NUMBER := OKC_API.G_MISS_NUM

Line 34: , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR

30: IS RECORD
31: ( template_rule_id OKC_XPRT_TEMPLATE_RULES.template_rule_id%TYPE := OKC_API.G_MISS_NUM
32: , template_id OKC_XPRT_TEMPLATE_RULES.template_id%TYPE := OKC_API.G_MISS_NUM
33: , rule_id OKC_XPRT_TEMPLATE_RULES.rule_id%TYPE := OKC_API.G_MISS_NUM
34: , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR
35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR
36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM
37: , created_by NUMBER := OKC_API.G_MISS_NUM
38: , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE

Line 35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR

31: ( template_rule_id OKC_XPRT_TEMPLATE_RULES.template_rule_id%TYPE := OKC_API.G_MISS_NUM
32: , template_id OKC_XPRT_TEMPLATE_RULES.template_id%TYPE := OKC_API.G_MISS_NUM
33: , rule_id OKC_XPRT_TEMPLATE_RULES.rule_id%TYPE := OKC_API.G_MISS_NUM
34: , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR
35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR
36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM
37: , created_by NUMBER := OKC_API.G_MISS_NUM
38: , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE
39: , last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM

32: , template_id OKC_XPRT_TEMPLATE_RULES.template_id%TYPE := OKC_API.G_MISS_NUM
33: , rule_id OKC_XPRT_TEMPLATE_RULES.rule_id%TYPE := OKC_API.G_MISS_NUM
34: , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR
35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR
36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM
37: , created_by NUMBER := OKC_API.G_MISS_NUM
38: , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE
39: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: , last_update_date OKC_XPRT_TEMPLATE_RULES.last_update_date%TYPE := OKC_API.G_MISS_DATE

Line 37: , created_by NUMBER := OKC_API.G_MISS_NUM

33: , rule_id OKC_XPRT_TEMPLATE_RULES.rule_id%TYPE := OKC_API.G_MISS_NUM
34: , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR
35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR
36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM
37: , created_by NUMBER := OKC_API.G_MISS_NUM
38: , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE
39: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: , last_update_date OKC_XPRT_TEMPLATE_RULES.last_update_date%TYPE := OKC_API.G_MISS_DATE
41: , last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 38: , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE

34: , deleted_flag OKC_XPRT_TEMPLATE_RULES.deleted_flag%TYPE := OKC_API.G_MISS_CHAR
35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR
36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM
37: , created_by NUMBER := OKC_API.G_MISS_NUM
38: , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE
39: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: , last_update_date OKC_XPRT_TEMPLATE_RULES.last_update_date%TYPE := OKC_API.G_MISS_DATE
41: , last_update_login NUMBER := OKC_API.G_MISS_NUM
42: );

Line 39: , last_updated_by NUMBER := OKC_API.G_MISS_NUM

35: , published_flag OKC_XPRT_TEMPLATE_RULES.published_flag%TYPE := OKC_API.G_MISS_CHAR
36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM
37: , created_by NUMBER := OKC_API.G_MISS_NUM
38: , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE
39: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: , last_update_date OKC_XPRT_TEMPLATE_RULES.last_update_date%TYPE := OKC_API.G_MISS_DATE
41: , last_update_login NUMBER := OKC_API.G_MISS_NUM
42: );
43: TYPE template_rules_tbl_type IS TABLE OF template_rules_rec_type INDEX BY PLS_INTEGER;

Line 40: , last_update_date OKC_XPRT_TEMPLATE_RULES.last_update_date%TYPE := OKC_API.G_MISS_DATE

36: , object_version_number OKC_XPRT_TEMPLATE_RULES.object_version_number%TYPE := OKC_API.G_MISS_NUM
37: , created_by NUMBER := OKC_API.G_MISS_NUM
38: , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE
39: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: , last_update_date OKC_XPRT_TEMPLATE_RULES.last_update_date%TYPE := OKC_API.G_MISS_DATE
41: , last_update_login NUMBER := OKC_API.G_MISS_NUM
42: );
43: TYPE template_rules_tbl_type IS TABLE OF template_rules_rec_type INDEX BY PLS_INTEGER;
44:

Line 41: , last_update_login NUMBER := OKC_API.G_MISS_NUM

37: , created_by NUMBER := OKC_API.G_MISS_NUM
38: , creation_date OKC_XPRT_TEMPLATE_RULES.creation_date%TYPE := OKC_API.G_MISS_DATE
39: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: , last_update_date OKC_XPRT_TEMPLATE_RULES.last_update_date%TYPE := OKC_API.G_MISS_DATE
41: , last_update_login NUMBER := OKC_API.G_MISS_NUM
42: );
43: TYPE template_rules_tbl_type IS TABLE OF template_rules_rec_type INDEX BY PLS_INTEGER;
44:
45:

Line 47: ( RULE_OUTCOME_ID OKC_XPRT_RULE_OUTCOMES.RULE_OUTCOME_ID%TYPE := OKC_API.G_MISS_NUM

43: TYPE template_rules_tbl_type IS TABLE OF template_rules_rec_type INDEX BY PLS_INTEGER;
44:
45:
46: TYPE rule_outcome_rec_type IS RECORD
47: ( RULE_OUTCOME_ID OKC_XPRT_RULE_OUTCOMES.RULE_OUTCOME_ID%TYPE := OKC_API.G_MISS_NUM
48: , RULE_ID OKC_XPRT_RULE_OUTCOMES.RULE_ID%TYPE := OKC_API.G_MISS_NUM
49: , OBJECT_TYPE OKC_XPRT_RULE_OUTCOMES.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM

Line 48: , RULE_ID OKC_XPRT_RULE_OUTCOMES.RULE_ID%TYPE := OKC_API.G_MISS_NUM

44:
45:
46: TYPE rule_outcome_rec_type IS RECORD
47: ( RULE_OUTCOME_ID OKC_XPRT_RULE_OUTCOMES.RULE_OUTCOME_ID%TYPE := OKC_API.G_MISS_NUM
48: , RULE_ID OKC_XPRT_RULE_OUTCOMES.RULE_ID%TYPE := OKC_API.G_MISS_NUM
49: , OBJECT_TYPE OKC_XPRT_RULE_OUTCOMES.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM

Line 49: , OBJECT_TYPE OKC_XPRT_RULE_OUTCOMES.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR

45:
46: TYPE rule_outcome_rec_type IS RECORD
47: ( RULE_OUTCOME_ID OKC_XPRT_RULE_OUTCOMES.RULE_OUTCOME_ID%TYPE := OKC_API.G_MISS_NUM
48: , RULE_ID OKC_XPRT_RULE_OUTCOMES.RULE_ID%TYPE := OKC_API.G_MISS_NUM
49: , OBJECT_TYPE OKC_XPRT_RULE_OUTCOMES.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 50: , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM

46: TYPE rule_outcome_rec_type IS RECORD
47: ( RULE_OUTCOME_ID OKC_XPRT_RULE_OUTCOMES.RULE_OUTCOME_ID%TYPE := OKC_API.G_MISS_NUM
48: , RULE_ID OKC_XPRT_RULE_OUTCOMES.RULE_ID%TYPE := OKC_API.G_MISS_NUM
49: , OBJECT_TYPE OKC_XPRT_RULE_OUTCOMES.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM

Line 51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM

47: ( RULE_OUTCOME_ID OKC_XPRT_RULE_OUTCOMES.RULE_OUTCOME_ID%TYPE := OKC_API.G_MISS_NUM
48: , RULE_ID OKC_XPRT_RULE_OUTCOMES.RULE_ID%TYPE := OKC_API.G_MISS_NUM
49: , OBJECT_TYPE OKC_XPRT_RULE_OUTCOMES.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
55: , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM

48: , RULE_ID OKC_XPRT_RULE_OUTCOMES.RULE_ID%TYPE := OKC_API.G_MISS_NUM
49: , OBJECT_TYPE OKC_XPRT_RULE_OUTCOMES.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
55: , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM

Line 53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

49: , OBJECT_TYPE OKC_XPRT_RULE_OUTCOMES.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
50: , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
55: , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
57: , MANDATORY_YN OKC_XPRT_RULE_OUTCOMES.MANDATORY_YN%TYPE := OKC_API.G_MISS_CHAR

Line 54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM

50: , OBJECT_VALUE_ID OKC_XPRT_RULE_OUTCOMES.OBJECT_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
55: , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
57: , MANDATORY_YN OKC_XPRT_RULE_OUTCOMES.MANDATORY_YN%TYPE := OKC_API.G_MISS_CHAR
58: , MANDATORY_RWA OKC_XPRT_RULE_OUTCOMES.MANDATORY_RWA%TYPE := OKC_API.G_MISS_CHAR

Line 55: , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

51: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_OUTCOMES.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
55: , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
57: , MANDATORY_YN OKC_XPRT_RULE_OUTCOMES.MANDATORY_YN%TYPE := OKC_API.G_MISS_CHAR
58: , MANDATORY_RWA OKC_XPRT_RULE_OUTCOMES.MANDATORY_RWA%TYPE := OKC_API.G_MISS_CHAR
59: );

Line 56: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM

52: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
55: , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
57: , MANDATORY_YN OKC_XPRT_RULE_OUTCOMES.MANDATORY_YN%TYPE := OKC_API.G_MISS_CHAR
58: , MANDATORY_RWA OKC_XPRT_RULE_OUTCOMES.MANDATORY_RWA%TYPE := OKC_API.G_MISS_CHAR
59: );
60: TYPE rule_outcome_tbl_type IS TABLE OF rule_outcome_rec_type INDEX BY PLS_INTEGER;

Line 57: , MANDATORY_YN OKC_XPRT_RULE_OUTCOMES.MANDATORY_YN%TYPE := OKC_API.G_MISS_CHAR

53: , CREATION_DATE OKC_XPRT_RULE_OUTCOMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
55: , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
57: , MANDATORY_YN OKC_XPRT_RULE_OUTCOMES.MANDATORY_YN%TYPE := OKC_API.G_MISS_CHAR
58: , MANDATORY_RWA OKC_XPRT_RULE_OUTCOMES.MANDATORY_RWA%TYPE := OKC_API.G_MISS_CHAR
59: );
60: TYPE rule_outcome_tbl_type IS TABLE OF rule_outcome_rec_type INDEX BY PLS_INTEGER;
61:

Line 58: , MANDATORY_RWA OKC_XPRT_RULE_OUTCOMES.MANDATORY_RWA%TYPE := OKC_API.G_MISS_CHAR

54: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
55: , LAST_UPDATE_DATE OKC_XPRT_RULE_OUTCOMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
56: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
57: , MANDATORY_YN OKC_XPRT_RULE_OUTCOMES.MANDATORY_YN%TYPE := OKC_API.G_MISS_CHAR
58: , MANDATORY_RWA OKC_XPRT_RULE_OUTCOMES.MANDATORY_RWA%TYPE := OKC_API.G_MISS_CHAR
59: );
60: TYPE rule_outcome_tbl_type IS TABLE OF rule_outcome_rec_type INDEX BY PLS_INTEGER;
61:
62: TYPE rule_cond_vals_rec_type IS RECORD

Line 64: RULE_CONDITION_VALUE_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_VALUE_ID%TYPE := OKC_API.G_MISS_NUM

60: TYPE rule_outcome_tbl_type IS TABLE OF rule_outcome_rec_type INDEX BY PLS_INTEGER;
61:
62: TYPE rule_cond_vals_rec_type IS RECORD
63: (
64: RULE_CONDITION_VALUE_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
65: , RULE_CONDITION_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
66: , OBJECT_VALUE_CODE OKC_XPRT_RULE_COND_VALS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
67: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM

Line 65: , RULE_CONDITION_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM

61:
62: TYPE rule_cond_vals_rec_type IS RECORD
63: (
64: RULE_CONDITION_VALUE_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
65: , RULE_CONDITION_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
66: , OBJECT_VALUE_CODE OKC_XPRT_RULE_COND_VALS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
67: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
69: , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 66: , OBJECT_VALUE_CODE OKC_XPRT_RULE_COND_VALS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR

62: TYPE rule_cond_vals_rec_type IS RECORD
63: (
64: RULE_CONDITION_VALUE_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
65: , RULE_CONDITION_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
66: , OBJECT_VALUE_CODE OKC_XPRT_RULE_COND_VALS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
67: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
69: , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM

Line 67: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM

63: (
64: RULE_CONDITION_VALUE_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
65: , RULE_CONDITION_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
66: , OBJECT_VALUE_CODE OKC_XPRT_RULE_COND_VALS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
67: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
69: , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
71: , LAST_UPDATE_DATE OKC_XPRT_RULE_COND_VALS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM

64: RULE_CONDITION_VALUE_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_VALUE_ID%TYPE := OKC_API.G_MISS_NUM
65: , RULE_CONDITION_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
66: , OBJECT_VALUE_CODE OKC_XPRT_RULE_COND_VALS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
67: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
69: , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
71: , LAST_UPDATE_DATE OKC_XPRT_RULE_COND_VALS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM

Line 69: , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

65: , RULE_CONDITION_ID OKC_XPRT_RULE_COND_VALS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
66: , OBJECT_VALUE_CODE OKC_XPRT_RULE_COND_VALS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
67: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
69: , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
71: , LAST_UPDATE_DATE OKC_XPRT_RULE_COND_VALS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
73: );

Line 70: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM

66: , OBJECT_VALUE_CODE OKC_XPRT_RULE_COND_VALS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
67: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
69: , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
71: , LAST_UPDATE_DATE OKC_XPRT_RULE_COND_VALS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
73: );
74: TYPE rule_cond_vals_tbl_type IS TABLE OF rule_cond_vals_rec_type INDEX BY PLS_INTEGER;

Line 71: , LAST_UPDATE_DATE OKC_XPRT_RULE_COND_VALS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

67: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_COND_VALS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
69: , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
71: , LAST_UPDATE_DATE OKC_XPRT_RULE_COND_VALS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
73: );
74: TYPE rule_cond_vals_tbl_type IS TABLE OF rule_cond_vals_rec_type INDEX BY PLS_INTEGER;
75:

Line 72: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM

68: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
69: , CREATION_DATE OKC_XPRT_RULE_COND_VALS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
71: , LAST_UPDATE_DATE OKC_XPRT_RULE_COND_VALS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
73: );
74: TYPE rule_cond_vals_tbl_type IS TABLE OF rule_cond_vals_rec_type INDEX BY PLS_INTEGER;
75:
76: TYPE rule_condition_rec_type IS RECORD

Line 78: RULE_CONDITION_ID OKC_XPRT_RULE_CONDITIONS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM

74: TYPE rule_cond_vals_tbl_type IS TABLE OF rule_cond_vals_rec_type INDEX BY PLS_INTEGER;
75:
76: TYPE rule_condition_rec_type IS RECORD
77: (
78: RULE_CONDITION_ID OKC_XPRT_RULE_CONDITIONS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
79: , RULE_ID OKC_XPRT_RULE_CONDITIONS.RULE_ID%TYPE := OKC_API.G_MISS_NUM
80: , OBJECT_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
81: , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR
82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR

Line 79: , RULE_ID OKC_XPRT_RULE_CONDITIONS.RULE_ID%TYPE := OKC_API.G_MISS_NUM

75:
76: TYPE rule_condition_rec_type IS RECORD
77: (
78: RULE_CONDITION_ID OKC_XPRT_RULE_CONDITIONS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
79: , RULE_ID OKC_XPRT_RULE_CONDITIONS.RULE_ID%TYPE := OKC_API.G_MISS_NUM
80: , OBJECT_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
81: , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR
82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR
83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR

Line 80: , OBJECT_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR

76: TYPE rule_condition_rec_type IS RECORD
77: (
78: RULE_CONDITION_ID OKC_XPRT_RULE_CONDITIONS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
79: , RULE_ID OKC_XPRT_RULE_CONDITIONS.RULE_ID%TYPE := OKC_API.G_MISS_NUM
80: , OBJECT_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
81: , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR
82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR
83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR
84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 81: , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR

77: (
78: RULE_CONDITION_ID OKC_XPRT_RULE_CONDITIONS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
79: , RULE_ID OKC_XPRT_RULE_CONDITIONS.RULE_ID%TYPE := OKC_API.G_MISS_NUM
80: , OBJECT_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
81: , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR
82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR
83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR
84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR
85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR

78: RULE_CONDITION_ID OKC_XPRT_RULE_CONDITIONS.RULE_CONDITION_ID%TYPE := OKC_API.G_MISS_NUM
79: , RULE_ID OKC_XPRT_RULE_CONDITIONS.RULE_ID%TYPE := OKC_API.G_MISS_NUM
80: , OBJECT_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
81: , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR
82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR
83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR
84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR
85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR
86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR

79: , RULE_ID OKC_XPRT_RULE_CONDITIONS.RULE_ID%TYPE := OKC_API.G_MISS_NUM
80: , OBJECT_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
81: , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR
82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR
83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR
84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR
85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR
86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM

Line 84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR

80: , OBJECT_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_TYPE%TYPE := OKC_API.G_MISS_CHAR
81: , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR
82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR
83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR
84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR
85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR
86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM

Line 85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR

81: , OBJECT_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR
82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR
83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR
84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR
85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR
86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
89: , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR

82: , OBJECT_CODE_DATATYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_CODE_DATATYPE%TYPE := OKC_API.G_MISS_CHAR
83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR
84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR
85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR
86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
89: , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM

Line 87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM

83: , OPERATOR OKC_XPRT_RULE_CONDITIONS.OPERATOR%TYPE := OKC_API.G_MISS_CHAR
84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR
85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR
86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
89: , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
91: , LAST_UPDATE_DATE OKC_XPRT_RULE_CONDITIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM

84: , OBJECT_VALUE_SET_NAME OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_SET_NAME%TYPE := OKC_API.G_MISS_CHAR
85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR
86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
89: , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
91: , LAST_UPDATE_DATE OKC_XPRT_RULE_CONDITIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM

Line 89: , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

85: , OBJECT_VALUE_TYPE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_TYPE%TYPE := OKC_API.G_MISS_CHAR
86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
89: , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
91: , LAST_UPDATE_DATE OKC_XPRT_RULE_CONDITIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
93: , rule_cond_vals_tbl rule_cond_vals_tbl_type

Line 90: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM

86: , OBJECT_VALUE_CODE OKC_XPRT_RULE_CONDITIONS.OBJECT_VALUE_CODE%TYPE := OKC_API.G_MISS_CHAR
87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
89: , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
91: , LAST_UPDATE_DATE OKC_XPRT_RULE_CONDITIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
93: , rule_cond_vals_tbl rule_cond_vals_tbl_type
94: );

Line 91: , LAST_UPDATE_DATE OKC_XPRT_RULE_CONDITIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

87: , OBJECT_VERSION_NUMBER OKC_XPRT_RULE_CONDITIONS.OBJECT_VERSION_NUMBER%TYPE := OKC_API.G_MISS_NUM
88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
89: , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
91: , LAST_UPDATE_DATE OKC_XPRT_RULE_CONDITIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
93: , rule_cond_vals_tbl rule_cond_vals_tbl_type
94: );
95: TYPE rule_condition_tbl_type IS TABLE OF rule_condition_rec_type INDEX BY PLS_INTEGER;

Line 92: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM

88: , CREATED_BY NUMBER := OKC_API.G_MISS_NUM
89: , CREATION_DATE OKC_XPRT_RULE_CONDITIONS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
90: , LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM
91: , LAST_UPDATE_DATE OKC_XPRT_RULE_CONDITIONS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: , LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM
93: , rule_cond_vals_tbl rule_cond_vals_tbl_type
94: );
95: TYPE rule_condition_tbl_type IS TABLE OF rule_condition_rec_type INDEX BY PLS_INTEGER;
96:

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 108: ,REQUEST_ID NUMBER := OKC_API.G_MISS_NUM

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
112: ,CREATED_BY NUMBER := 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 112: ,CREATED_BY NUMBER := OKC_API.G_MISS_NUM

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
116: ,LAST_UPDATE_LOGIN NUMBER := OKC_API.G_MISS_NUM

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 114: ,LAST_UPDATED_BY NUMBER := OKC_API.G_MISS_NUM

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
118: ,PROGRAM_APPLICATION_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 116: ,LAST_UPDATE_LOGIN NUMBER := 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
120: );

Line 117: ,PROGRAM_ID 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
120: );
121: TYPE rule_header_tbl_type IS TABLE OF rule_header_rec_type INDEX BY PLS_INTEGER;

Line 118: ,PROGRAM_APPLICATION_ID NUMBER := OKC_API.G_MISS_NUM

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
120: );
121: TYPE rule_header_tbl_type IS TABLE OF rule_header_rec_type INDEX BY PLS_INTEGER;
122:

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