DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_PUB dependencies on MTL_CATEGORIES_B

Line 72: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM

68: -- Category Record Type
69: -----------------------------------------------------------------------------
70: TYPE CATEGORY_REC_TYPE IS RECORD
71: (
72: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM
73: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM
74: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR
75: ,SEGMENT1 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
76: ,SEGMENT2 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 73: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM

69: -----------------------------------------------------------------------------
70: TYPE CATEGORY_REC_TYPE IS RECORD
71: (
72: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM
73: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM
74: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR
75: ,SEGMENT1 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
76: ,SEGMENT2 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
77: ,SEGMENT3 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 75: ,SEGMENT1 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

71: (
72: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM
73: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM
74: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR
75: ,SEGMENT1 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
76: ,SEGMENT2 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
77: ,SEGMENT3 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
78: ,SEGMENT4 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 76: ,SEGMENT2 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

72: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM
73: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM
74: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR
75: ,SEGMENT1 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
76: ,SEGMENT2 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
77: ,SEGMENT3 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
78: ,SEGMENT4 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 77: ,SEGMENT3 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

73: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM
74: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR
75: ,SEGMENT1 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
76: ,SEGMENT2 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
77: ,SEGMENT3 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
78: ,SEGMENT4 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 78: ,SEGMENT4 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

74: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR
75: ,SEGMENT1 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
76: ,SEGMENT2 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
77: ,SEGMENT3 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
78: ,SEGMENT4 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

75: ,SEGMENT1 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
76: ,SEGMENT2 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
77: ,SEGMENT3 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
78: ,SEGMENT4 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

76: ,SEGMENT2 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
77: ,SEGMENT3 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
78: ,SEGMENT4 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

77: ,SEGMENT3 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
78: ,SEGMENT4 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

78: ,SEGMENT4 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

79: ,SEGMENT5 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

80: ,SEGMENT6 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

81: ,SEGMENT7 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

82: ,SEGMENT8 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

83: ,SEGMENT9 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
91: ,SEGMENT17 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

84: ,SEGMENT10 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
91: ,SEGMENT17 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
92: ,SEGMENT18 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

85: ,SEGMENT11 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
91: ,SEGMENT17 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
92: ,SEGMENT18 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
93: ,SEGMENT19 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

86: ,SEGMENT12 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
91: ,SEGMENT17 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
92: ,SEGMENT18 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
93: ,SEGMENT19 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
94: ,SEGMENT20 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

Line 91: ,SEGMENT17 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

87: ,SEGMENT13 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
91: ,SEGMENT17 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
92: ,SEGMENT18 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
93: ,SEGMENT19 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
94: ,SEGMENT20 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
95: -- Changing the default value as per CRM requirements.

Line 92: ,SEGMENT18 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

88: ,SEGMENT14 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
91: ,SEGMENT17 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
92: ,SEGMENT18 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
93: ,SEGMENT19 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
94: ,SEGMENT20 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
95: -- Changing the default value as per CRM requirements.
96: -- Since these are NOT NULL columns.

Line 93: ,SEGMENT19 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

89: ,SEGMENT15 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
91: ,SEGMENT17 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
92: ,SEGMENT18 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
93: ,SEGMENT19 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
94: ,SEGMENT20 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
95: -- Changing the default value as per CRM requirements.
96: -- Since these are NOT NULL columns.
97: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

Line 94: ,SEGMENT20 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR

90: ,SEGMENT16 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
91: ,SEGMENT17 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
92: ,SEGMENT18 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
93: ,SEGMENT19 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
94: ,SEGMENT20 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
95: -- Changing the default value as per CRM requirements.
96: -- Since these are NOT NULL columns.
97: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR
98: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

Line 97: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

93: ,SEGMENT19 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
94: ,SEGMENT20 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
95: -- Changing the default value as per CRM requirements.
96: -- Since these are NOT NULL columns.
97: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR
98: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR
99: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE
100: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE
101: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

Line 98: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

94: ,SEGMENT20 MTL_CATEGORIES_B.SEGMENT1%TYPE := g_MISS_CHAR
95: -- Changing the default value as per CRM requirements.
96: -- Since these are NOT NULL columns.
97: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR
98: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR
99: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE
100: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE
101: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE
102: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

Line 99: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

95: -- Changing the default value as per CRM requirements.
96: -- Since these are NOT NULL columns.
97: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR
98: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR
99: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE
100: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE
101: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE
102: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR
103: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

Line 100: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

96: -- Since these are NOT NULL columns.
97: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR
98: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR
99: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE
100: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE
101: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE
102: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR
103: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR
104: ,ATTRIBUTE1 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 101: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

97: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR
98: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR
99: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE
100: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE
101: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE
102: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR
103: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR
104: ,ATTRIBUTE1 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
105: ,ATTRIBUTE2 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 103: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

99: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE
100: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE
101: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE
102: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR
103: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR
104: ,ATTRIBUTE1 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
105: ,ATTRIBUTE2 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
106: ,ATTRIBUTE3 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 104: ,ATTRIBUTE1 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

100: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE
101: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE
102: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR
103: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR
104: ,ATTRIBUTE1 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
105: ,ATTRIBUTE2 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
106: ,ATTRIBUTE3 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 105: ,ATTRIBUTE2 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

101: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE
102: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR
103: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR
104: ,ATTRIBUTE1 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
105: ,ATTRIBUTE2 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
106: ,ATTRIBUTE3 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 106: ,ATTRIBUTE3 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

102: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR
103: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR
104: ,ATTRIBUTE1 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
105: ,ATTRIBUTE2 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
106: ,ATTRIBUTE3 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

103: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR
104: ,ATTRIBUTE1 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
105: ,ATTRIBUTE2 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
106: ,ATTRIBUTE3 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

104: ,ATTRIBUTE1 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
105: ,ATTRIBUTE2 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
106: ,ATTRIBUTE3 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

105: ,ATTRIBUTE2 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
106: ,ATTRIBUTE3 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

106: ,ATTRIBUTE3 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

107: ,ATTRIBUTE4 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
115: ,ATTRIBUTE12 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

108: ,ATTRIBUTE5 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
115: ,ATTRIBUTE12 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
116: ,ATTRIBUTE13 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

109: ,ATTRIBUTE6 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
115: ,ATTRIBUTE12 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
116: ,ATTRIBUTE13 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
117: ,ATTRIBUTE14 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

110: ,ATTRIBUTE7 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
115: ,ATTRIBUTE12 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
116: ,ATTRIBUTE13 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
117: ,ATTRIBUTE14 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
118: ,ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

Line 115: ,ATTRIBUTE12 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

111: ,ATTRIBUTE8 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
115: ,ATTRIBUTE12 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
116: ,ATTRIBUTE13 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
117: ,ATTRIBUTE14 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
118: ,ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
119: --Bug: 2430879

Line 116: ,ATTRIBUTE13 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

112: ,ATTRIBUTE9 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
115: ,ATTRIBUTE12 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
116: ,ATTRIBUTE13 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
117: ,ATTRIBUTE14 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
118: ,ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
119: --Bug: 2430879
120: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

Line 117: ,ATTRIBUTE14 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

113: ,ATTRIBUTE10 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
115: ,ATTRIBUTE12 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
116: ,ATTRIBUTE13 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
117: ,ATTRIBUTE14 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
118: ,ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
119: --Bug: 2430879
120: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR
121: --Bug: 2645153

Line 118: ,ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR

114: ,ATTRIBUTE11 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
115: ,ATTRIBUTE12 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
116: ,ATTRIBUTE13 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
117: ,ATTRIBUTE14 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
118: ,ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
119: --Bug: 2430879
120: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR
121: --Bug: 2645153
122: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

Line 120: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

116: ,ATTRIBUTE13 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
117: ,ATTRIBUTE14 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
118: ,ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
119: --Bug: 2430879
120: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR
121: --Bug: 2645153
122: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR
123: );
124: -----------------------------------------------------------------------------

Line 122: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

118: ,ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE1%TYPE := g_MISS_CHAR
119: --Bug: 2430879
120: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR
121: --Bug: 2645153
122: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR
123: );
124: -----------------------------------------------------------------------------
125:
126: -- 1. Create_Category

Line 135: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM

131: * record type passed in p_category_rec is as follows:
132: *



133:   TYPE CATEGORY_REC_TYPE IS RECORD

134:   (

135:       CATEGORY_ID               MTL_CATEGORIES_B.CATEGORY_ID%TYPE                       :=  g_MISS_NUM

136:      ,STRUCTURE_ID              MTL_CATEGORIES_B.STRUCTURE_ID%TYPE                      :=  g_MISS_NUM

137:      ,STRUCTURE_CODE            FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE      :=  g_MISS_CHAR

138:      ,Columns SEGMENT1 to SEGMENT20               MTL_CATEGORIES_B.SEGMENT(n)%TYPE      :=  g_MISS_CHAR

139:      ,SUMMARY_FLAG              MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE                      :=  g_MISS_CHAR




Line 136: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM



132: *


133:   TYPE CATEGORY_REC_TYPE IS RECORD

134:   (

135:       CATEGORY_ID               MTL_CATEGORIES_B.CATEGORY_ID%TYPE                       :=  g_MISS_NUM

136:      ,STRUCTURE_ID              MTL_CATEGORIES_B.STRUCTURE_ID%TYPE                      :=  g_MISS_NUM

137:      ,STRUCTURE_CODE            FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE      :=  g_MISS_CHAR

138:      ,Columns SEGMENT1 to SEGMENT20               MTL_CATEGORIES_B.SEGMENT(n)%TYPE      :=  g_MISS_CHAR

139:      ,SUMMARY_FLAG              MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE                      :=  g_MISS_CHAR

140:      ,ENABLED_FLAG              MTL_CATEGORIES_B.ENABLED_FLAG%TYPE                      :=  g_MISS_CHAR




Line 138: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR



134: (

135: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM

136: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM

137: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR

138: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

139: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

140: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

141: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

142: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE




Line 139: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR



135: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM

136: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM

137: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR

138: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

139: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

140: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

141: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

142: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

143: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE




Line 140: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR



136: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM

137: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR

138: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

139: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

140: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

141: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

142: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

143: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

144: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR




Line 141: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE



137: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR

138: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

139: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

140: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

141: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

142: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

143: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

144: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

145: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR




Line 142: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE



138: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

139: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

140: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

141: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

142: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

143: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

144: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

145: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

146: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR




Line 143: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE



139: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

140: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

141: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

142: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

143: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

144: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

145: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

146: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

147: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR




Line 145: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR



141: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

142: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

143: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

144: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

145: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

146: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

147: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

148: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

149: );




Line 146: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR



142: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

143: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

144: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

145: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

146: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

147: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

148: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

149: );

150: *





Line 147: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR



143: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

144: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

145: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

146: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

147: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

148: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

149: );

150: *

151: * 





Line 148: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR



144: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

145: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

146: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

147: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

148: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

149: );

150: *

151: * 


152:  * PARAMETERS




Line 258: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM



254: * record type passed in p_category_rec is as follows:

255: *


256:   TYPE CATEGORY_REC_TYPE IS RECORD

257:   (

258:       CATEGORY_ID               MTL_CATEGORIES_B.CATEGORY_ID%TYPE                       :=  g_MISS_NUM

259:      ,STRUCTURE_ID              MTL_CATEGORIES_B.STRUCTURE_ID%TYPE                      :=  g_MISS_NUM

260:      ,STRUCTURE_CODE            FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE      :=  g_MISS_CHAR

261:      ,Columns SEGMENT1 to SEGMENT20               MTL_CATEGORIES_B.SEGMENT(n)%TYPE      :=  g_MISS_CHAR

262:      ,SUMMARY_FLAG              MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE                      :=  g_MISS_CHAR




Line 259: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM



255: *


256:   TYPE CATEGORY_REC_TYPE IS RECORD

257:   (

258:       CATEGORY_ID               MTL_CATEGORIES_B.CATEGORY_ID%TYPE                       :=  g_MISS_NUM

259:      ,STRUCTURE_ID              MTL_CATEGORIES_B.STRUCTURE_ID%TYPE                      :=  g_MISS_NUM

260:      ,STRUCTURE_CODE            FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE      :=  g_MISS_CHAR

261:      ,Columns SEGMENT1 to SEGMENT20               MTL_CATEGORIES_B.SEGMENT(n)%TYPE      :=  g_MISS_CHAR

262:      ,SUMMARY_FLAG              MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE                      :=  g_MISS_CHAR

263:      ,ENABLED_FLAG              MTL_CATEGORIES_B.ENABLED_FLAG%TYPE                      :=  g_MISS_CHAR




Line 261: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR



257: (

258: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM

259: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM

260: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR

261: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

262: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

263: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

264: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

265: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE




Line 262: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR



258: CATEGORY_ID MTL_CATEGORIES_B.CATEGORY_ID%TYPE := g_MISS_NUM

259: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM

260: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR

261: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

262: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

263: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

264: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

265: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

266: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE




Line 263: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR



259: ,STRUCTURE_ID MTL_CATEGORIES_B.STRUCTURE_ID%TYPE := g_MISS_NUM

260: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR

261: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

262: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

263: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

264: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

265: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

266: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

267: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR




Line 264: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE



260: ,STRUCTURE_CODE FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE := g_MISS_CHAR

261: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

262: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

263: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

264: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

265: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

266: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

267: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

268: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR




Line 265: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE



261: ,Columns SEGMENT1 to SEGMENT20 MTL_CATEGORIES_B.SEGMENT(n)%TYPE := g_MISS_CHAR

262: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

263: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

264: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

265: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

266: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

267: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

268: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

269: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR




Line 266: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE



262: ,SUMMARY_FLAG MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE := g_MISS_CHAR

263: ,ENABLED_FLAG MTL_CATEGORIES_B.ENABLED_FLAG%TYPE := g_MISS_CHAR

264: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

265: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

266: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

267: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

268: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

269: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

270: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR




Line 268: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR



264: ,START_DATE_ACTIVE MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE := g_MISS_DATE

265: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

266: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

267: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

268: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

269: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

270: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

271: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

272: );




Line 269: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR



265: ,END_DATE_ACTIVE MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE := g_MISS_DATE

266: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

267: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

268: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

269: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

270: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

271: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

272: );

273: *





Line 270: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR



266: ,DISABLE_DATE MTL_CATEGORIES_B.DISABLE_DATE%TYPE := g_MISS_DATE

267: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

268: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

269: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

270: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

271: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

272: );

273: *


274: * 





Line 271: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR



267: ,DESCRIPTION MTL_CATEGORIES_TL.DESCRIPTION%TYPE := g_MISS_CHAR

268: ,ATTRIBUTE_CATEGORY MTL_CATEGORIES_B.ATTRIBUTE_CATEGORY%TYPE := g_MISS_CHAR

269: ,Columns ATTRIBUTE1 to ATTRIBUTE15 MTL_CATEGORIES_B.ATTRIBUTE(n)%TYPE := g_MISS_CHAR

270: ,WEB_STATUS MTL_CATEGORIES_B.WEB_STATUS%TYPE := g_MISS_CHAR

271: ,SUPPLIER_ENABLED_FLAG MTL_CATEGORIES_B.SUPPLIER_ENABLED_FLAG%TYPE := g_MISS_CHAR

272: );

273: *


274: * 


275:  * PARAMETERS