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.OKL_RULE_EXTRACT_PVT dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 34: Type rule_rec_type is record ( rgs_code FND_DESCR_FLEX_COL_USAGE_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE := OKC_API.G_MISS_CHAR,

30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RULE_EXTRACT_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
32: ---------------------------------------------------------------------------
33: --structures to hold rule code records
34: Type rule_rec_type is record ( rgs_code FND_DESCR_FLEX_COL_USAGE_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
36: column_seq_num VARCHAR2(3) := OKC_API.G_MISS_CHAR);
37: Type rule_tbl_type is table of rule_rec_type index by BINARY_INTEGER;
38: --structures to hold subclass-rulegroup records

Line 35: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,

31: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
32: ---------------------------------------------------------------------------
33: --structures to hold rule code records
34: Type rule_rec_type is record ( rgs_code FND_DESCR_FLEX_COL_USAGE_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
36: column_seq_num VARCHAR2(3) := OKC_API.G_MISS_CHAR);
37: Type rule_tbl_type is table of rule_rec_type index by BINARY_INTEGER;
38: --structures to hold subclass-rulegroup records
39: Type sc_rg_rec_type is record (scs_code OKC_SUBCLASS_RG_DEFS.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 47: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,

43: Type sc_rg_tbl_type is table of sc_rg_Rec_Type index by BINARY_INTEGER;
44: --structures to hold rule group - rules records
45: Type rg_rules_rec_type is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: rdf_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
47: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
48: column_seq_num VARCHAR2(3) := OKC_API.G_MISS_CHAR,
49: optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
50: min_cardinality VARCHAR2(9) := OKC_API.G_MISS_CHAR,
51: max_cardinality VARCHAR2(9) := OKC_API.G_MISS_CHAR);

Line 58: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,

54: --this will hold the retreived metadata for rendering of
55: --rule segments
56: Type rul_segment_rec_type is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
57: rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
59: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
60: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
61: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,

Line 59: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,

55: --rule segments
56: Type rul_segment_rec_type is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
57: rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
59: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
60: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
61: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,

Line 61: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,

57: rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
58: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
59: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
60: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
61: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
65: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,

Line 62: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,

58: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
59: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
60: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
61: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
65: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,
66: select_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,

Line 63: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,

59: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
60: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
61: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
65: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,
66: select_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
67: from_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,

Line 65: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,

61: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64: default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
65: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,
66: select_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
67: from_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
68: where_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
69: order_by_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,

Line 72: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,

68: where_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
69: order_by_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
70: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
71: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
72: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
73: id1_col varchar2(30),
74: id2_col varchar2(30),
75: rule_info_col varchar2(30),
76: name_col varchar2(30),

Line 84: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,

80:
81: -- bug 3029276
82: Type rule_segment_rec_type2 is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
84: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
86: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
87: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,

Line 85: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,

81: -- bug 3029276
82: Type rule_segment_rec_type2 is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
84: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
86: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
87: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
89: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,

Line 87: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,

83: rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
84: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
86: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
87: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
89: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
91: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,

Line 88: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,

84: application_column_name FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
86: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
87: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
89: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
91: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,
92: select_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,

Line 89: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,

85: end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE := OKC_API.G_MISS_CHAR,
86: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,
87: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
89: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
91: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,
92: select_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
93: from_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,

Line 91: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,

87: enabled_flag FND_DESCR_FLEX_COL_USAGE_VL.ENABLED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: displayed_flag FND_DESCR_FLEX_COL_USAGE_VL.DISPLAY_FLAG%TYPE := OKC_API.G_MISS_CHAR,
89: required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
90: default_size VARCHAR2(3) := OKC_API.G_MISS_CHAR,
91: left_prompt FND_DESCR_FLEX_COL_USAGE_VL.FORM_LEFT_PROMPT%TYPE := OKC_API.G_MISS_CHAR,
92: select_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
93: from_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
94: where_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
95: order_by_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,

Line 98: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,

94: where_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
95: order_by_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
96: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
97: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
98: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
99: id1_col varchar2(30),
100: id2_col varchar2(30),
101: rule_info_col varchar2(30),
102: name_col varchar2(30),