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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: -----------------------------------------------------------------------------
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
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
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
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
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
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
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
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
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
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: );
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: *
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: *
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: *
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: *
275: * PARAMETERS