41: meaning FND_LOOKUPS.MEANING%TYPE := OKC_API.G_MISS_CHAR,
42: description FND_LOOKUPS.DESCRIPTION%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,
42: description FND_LOOKUPS.DESCRIPTION%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,
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);
52: Type rg_rules_tbl_type is table of rg_rules_rec_type index by BINARY_INTEGER;
53: --structures to hold rule-segment records
52: Type rg_rules_tbl_type is table of rg_rules_rec_type index by BINARY_INTEGER;
53: --structures to hold rule-segment records
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,
53: --structures to hold rule-segment records
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,
78: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE);
79: Type rule_segment_tbl_type is table of rul_segment_rec_type index by BINARY_INTEGER;
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,
79: Type rule_segment_tbl_type is table of rul_segment_rec_type index by BINARY_INTEGER;
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,