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 OKC_API

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 36: column_seq_num VARCHAR2(3) := OKC_API.G_MISS_CHAR);

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,
40: rgd_code OKC_SUBCLASS_RG_DEFS.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 39: Type sc_rg_rec_type is record (scs_code OKC_SUBCLASS_RG_DEFS.SCS_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,
40: rgd_code OKC_SUBCLASS_RG_DEFS.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
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;

Line 40: rgd_code OKC_SUBCLASS_RG_DEFS.RGD_CODE%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,
40: rgd_code OKC_SUBCLASS_RG_DEFS.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
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

Line 41: meaning FND_LOOKUPS.MEANING%TYPE := 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,
40: rgd_code OKC_SUBCLASS_RG_DEFS.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
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,

Line 42: description FND_LOOKUPS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);

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,
40: rgd_code OKC_SUBCLASS_RG_DEFS.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
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,

Line 45: Type rg_rules_rec_type is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,

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,

Line 46: rdf_code OKC_RG_DEF_RULES.RDF_CODE%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,

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 48: column_seq_num VARCHAR2(3) := OKC_API.G_MISS_CHAR,

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);
52: Type rg_rules_tbl_type is table of rg_rules_rec_type index by BINARY_INTEGER;

Line 49: optional_yn OKC_RG_DEF_RULES.OPTIONAL_YN%TYPE := 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

Line 50: min_cardinality VARCHAR2(9) := 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
54: --this will hold the retreived metadata for rendering of

Line 51: max_cardinality VARCHAR2(9) := 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
54: --this will hold the retreived metadata for rendering of
55: --rule segments

Line 56: Type rul_segment_rec_type is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%TYPE := 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
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,

Line 57: rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := 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,

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 60: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,

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,
64: default_size VARCHAR2(3) := 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 64: default_size VARCHAR2(3) := 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,
68: where_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 66: select_clause VARCHAR2(2000) := 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,
70: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 67: from_clause VARCHAR2(2000) := 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,
70: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
71: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,

Line 68: where_clause VARCHAR2(2000) := 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,
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,

Line 69: order_by_clause VARCHAR2(2000) := 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,
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 DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

Line 70: object_code JTF_OBJECTS_B.OBJECT_CODE%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,
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 DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
74: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

Line 71: longlist_flag VARCHAR2(1) := 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,
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 DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
74: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
75: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

Line 82: Type rule_segment_rec_type2 is record (rgd_code OKC_RG_DEF_RULES.RGD_CODE%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,

Line 83: rgs_code OKC_RG_DEF_RULES.RDF_CODE%TYPE := 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,

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 86: sequence VARCHAR2(3) := OKC_API.G_MISS_CHAR,

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,
90: default_size VARCHAR2(3) := 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 90: default_size VARCHAR2(3) := 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,
94: where_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 92: select_clause VARCHAR2(2000) := 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,
96: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 93: from_clause VARCHAR2(2000) := 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,
96: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
97: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,

Line 94: where_clause VARCHAR2(2000) := 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,
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,

Line 95: order_by_clause VARCHAR2(2000) := 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,
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 DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

Line 96: object_code JTF_OBJECTS_B.OBJECT_CODE%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,
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 DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
100: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

Line 97: longlist_flag VARCHAR2(1) := 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,
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 DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
100: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
101: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

Line 105: x_id1 VARCHAR2(300) := OKC_API.G_MISS_CHAR,

101: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
102: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
103: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
104: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE,
105: x_id1 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
106: x_id2 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
107: x_name VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
108: x_desc VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
109: x_segment_status VARCHAR2(7) := 'VALID'

Line 106: x_id2 VARCHAR2(300) := OKC_API.G_MISS_CHAR,

102: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
103: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
104: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE,
105: x_id1 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
106: x_id2 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
107: x_name VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
108: x_desc VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
109: x_segment_status VARCHAR2(7) := 'VALID'
110: );

Line 107: x_name VARCHAR2(1000) := OKC_API.G_MISS_CHAR,

103: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
104: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE,
105: x_id1 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
106: x_id2 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
107: x_name VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
108: x_desc VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
109: x_segment_status VARCHAR2(7) := 'VALID'
110: );
111: Type rule_segment_tbl_type2 is table of rule_segment_rec_type2 index by BINARY_INTEGER;

Line 108: x_desc VARCHAR2(1000) := OKC_API.G_MISS_CHAR,

104: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE,
105: x_id1 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
106: x_id2 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
107: x_name VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
108: x_desc VARCHAR2(1000) := OKC_API.G_MISS_CHAR,
109: x_segment_status VARCHAR2(7) := 'VALID'
110: );
111: Type rule_segment_tbl_type2 is table of rule_segment_rec_type2 index by BINARY_INTEGER;
112:

Line 164: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE := OKC_API.G_MISS_NUM,

160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_rgd_code IN VARCHAR2,
162: p_rgs_code IN VARCHAR2,
163: p_buy_or_sell IN VARCHAR2,
164: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE := OKC_API.G_MISS_NUM,
165: p_line_id IN OKC_K_LINES_B.ID%TYPE := OKC_API.G_MISS_NUM,
166: p_party_id IN OKC_K_PARTY_ROLES_B.ID%TYPE := OKC_API.G_MISS_NUM,
167: p_template_table IN VARCHAR2,
168: p_rule_id_column IN VARCHAR2,

Line 165: p_line_id IN OKC_K_LINES_B.ID%TYPE := OKC_API.G_MISS_NUM,

161: p_rgd_code IN VARCHAR2,
162: p_rgs_code IN VARCHAR2,
163: p_buy_or_sell IN VARCHAR2,
164: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE := OKC_API.G_MISS_NUM,
165: p_line_id IN OKC_K_LINES_B.ID%TYPE := OKC_API.G_MISS_NUM,
166: p_party_id IN OKC_K_PARTY_ROLES_B.ID%TYPE := OKC_API.G_MISS_NUM,
167: p_template_table IN VARCHAR2,
168: p_rule_id_column IN VARCHAR2,
169: p_entity_column IN VARCHAR2,

Line 166: p_party_id IN OKC_K_PARTY_ROLES_B.ID%TYPE := OKC_API.G_MISS_NUM,

162: p_rgs_code IN VARCHAR2,
163: p_buy_or_sell IN VARCHAR2,
164: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE := OKC_API.G_MISS_NUM,
165: p_line_id IN OKC_K_LINES_B.ID%TYPE := OKC_API.G_MISS_NUM,
166: p_party_id IN OKC_K_PARTY_ROLES_B.ID%TYPE := OKC_API.G_MISS_NUM,
167: p_template_table IN VARCHAR2,
168: p_rule_id_column IN VARCHAR2,
169: p_entity_column IN VARCHAR2,
170: x_rule_segment_tbl OUT NOCOPY rule_segment_tbl_type2);