APPS.EGO_CATALOG_GROUP_UTIL dependencies on EGO_GLOBALS

Line 45: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name);

41: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
42: l_dummy varchar2(10);
43: BEGIN
44: Error_Handler.Write_Debug('Performing Query Row for catalog group ' ||
45: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name);
46:
47: SELECT item_catalog_group_id
48: , parent_catalog_group_id
49: , summary_flag

Line 90: INTO EGO_Globals.G_Old_Catalog_Group_Rec.catalog_group_id

86: , attribute12
87: , attribute13
88: , attribute14
89: , attribute15
90: INTO EGO_Globals.G_Old_Catalog_Group_Rec.catalog_group_id
91: , EGO_Globals.G_Old_Catalog_Group_Rec.parent_catalog_group_id
92: , EGO_Globals.G_Old_Catalog_Group_Rec.summary_flag
93: , EGO_Globals.G_Old_Catalog_Group_Rec.enabled_flag
94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date

Line 91: , EGO_Globals.G_Old_Catalog_Group_Rec.parent_catalog_group_id

87: , attribute13
88: , attribute14
89: , attribute15
90: INTO EGO_Globals.G_Old_Catalog_Group_Rec.catalog_group_id
91: , EGO_Globals.G_Old_Catalog_Group_Rec.parent_catalog_group_id
92: , EGO_Globals.G_Old_Catalog_Group_Rec.summary_flag
93: , EGO_Globals.G_Old_Catalog_Group_Rec.enabled_flag
94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date
95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag

Line 92: , EGO_Globals.G_Old_Catalog_Group_Rec.summary_flag

88: , attribute14
89: , attribute15
90: INTO EGO_Globals.G_Old_Catalog_Group_Rec.catalog_group_id
91: , EGO_Globals.G_Old_Catalog_Group_Rec.parent_catalog_group_id
92: , EGO_Globals.G_Old_Catalog_Group_Rec.summary_flag
93: , EGO_Globals.G_Old_Catalog_Group_Rec.enabled_flag
94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date
95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag
96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description

Line 93: , EGO_Globals.G_Old_Catalog_Group_Rec.enabled_flag

89: , attribute15
90: INTO EGO_Globals.G_Old_Catalog_Group_Rec.catalog_group_id
91: , EGO_Globals.G_Old_Catalog_Group_Rec.parent_catalog_group_id
92: , EGO_Globals.G_Old_Catalog_Group_Rec.summary_flag
93: , EGO_Globals.G_Old_Catalog_Group_Rec.enabled_flag
94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date
95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag
96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description
97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1

Line 94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date

90: INTO EGO_Globals.G_Old_Catalog_Group_Rec.catalog_group_id
91: , EGO_Globals.G_Old_Catalog_Group_Rec.parent_catalog_group_id
92: , EGO_Globals.G_Old_Catalog_Group_Rec.summary_flag
93: , EGO_Globals.G_Old_Catalog_Group_Rec.enabled_flag
94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date
95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag
96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description
97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1
98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2

Line 95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag

91: , EGO_Globals.G_Old_Catalog_Group_Rec.parent_catalog_group_id
92: , EGO_Globals.G_Old_Catalog_Group_Rec.summary_flag
93: , EGO_Globals.G_Old_Catalog_Group_Rec.enabled_flag
94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date
95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag
96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description
97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1
98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2
99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3

Line 96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description

92: , EGO_Globals.G_Old_Catalog_Group_Rec.summary_flag
93: , EGO_Globals.G_Old_Catalog_Group_Rec.enabled_flag
94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date
95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag
96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description
97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1
98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2
99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3
100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4

Line 97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1

93: , EGO_Globals.G_Old_Catalog_Group_Rec.enabled_flag
94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date
95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag
96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description
97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1
98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2
99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3
100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4
101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5

Line 98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2

94: , EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date
95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag
96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description
97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1
98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2
99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3
100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4
101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5
102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6

Line 99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3

95: , EGO_Globals.G_Old_Catalog_Group_Rec.Item_Creation_Allowed_Flag
96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description
97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1
98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2
99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3
100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4
101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5
102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6
103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7

Line 100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4

96: , EGO_Globals.G_Old_Catalog_Group_Rec.Description
97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1
98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2
99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3
100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4
101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5
102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6
103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7
104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8

Line 101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5

97: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment1
98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2
99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3
100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4
101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5
102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6
103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7
104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8
105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9

Line 102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6

98: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment2
99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3
100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4
101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5
102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6
103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7
104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8
105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9
106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10

Line 103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7

99: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment3
100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4
101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5
102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6
103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7
104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8
105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9
106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10
107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11

Line 104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8

100: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment4
101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5
102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6
103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7
104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8
105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9
106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10
107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11
108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12

Line 105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9

101: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment5
102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6
103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7
104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8
105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9
106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10
107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11
108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12
109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13

Line 106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10

102: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment6
103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7
104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8
105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9
106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10
107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11
108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12
109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13
110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14

Line 107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11

103: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment7
104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8
105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9
106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10
107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11
108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12
109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13
110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14
111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15

Line 108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12

104: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment8
105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9
106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10
107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11
108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12
109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13
110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14
111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15
112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16

Line 109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13

105: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment9
106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10
107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11
108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12
109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13
110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14
111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15
112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16
113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17

Line 110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14

106: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment10
107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11
108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12
109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13
110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14
111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15
112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16
113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17
114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18

Line 111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15

107: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment11
108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12
109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13
110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14
111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15
112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16
113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17
114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18
115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19

Line 112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16

108: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment12
109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13
110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14
111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15
112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16
113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17
114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18
115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19
116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20

Line 113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17

109: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment13
110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14
111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15
112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16
113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17
114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18
115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19
116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20
117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category

Line 114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18

110: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment14
111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15
112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16
113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17
114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18
115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19
116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20
117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category
118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1

Line 115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19

111: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment15
112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16
113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17
114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18
115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19
116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20
117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category
118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1
119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2

Line 116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20

112: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment16
113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17
114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18
115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19
116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20
117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category
118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1
119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2
120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3

Line 117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category

113: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment17
114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18
115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19
116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20
117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category
118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1
119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2
120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3
121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4

Line 118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1

114: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment18
115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19
116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20
117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category
118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1
119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2
120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3
121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4
122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5

Line 119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2

115: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment19
116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20
117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category
118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1
119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2
120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3
121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4
122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5
123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6

Line 120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3

116: , EGO_Globals.G_Old_Catalog_Group_Rec.Segment20
117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category
118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1
119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2
120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3
121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4
122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5
123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6
124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7

Line 121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4

117: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute_category
118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1
119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2
120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3
121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4
122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5
123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6
124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7
125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8

Line 122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5

118: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute1
119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2
120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3
121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4
122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5
123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6
124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7
125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8
126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9

Line 123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6

119: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute2
120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3
121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4
122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5
123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6
124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7
125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8
126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9
127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10

Line 124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7

120: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute3
121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4
122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5
123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6
124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7
125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8
126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9
127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10
128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11

Line 125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8

121: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute4
122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5
123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6
124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7
125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8
126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9
127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10
128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11
129: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute12

Line 126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9

122: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute5
123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6
124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7
125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8
126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9
127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10
128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11
129: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute12
130: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute13

Line 127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10

123: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute6
124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7
125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8
126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9
127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10
128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11
129: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute12
130: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute13
131: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute14

Line 128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11

124: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute7
125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8
126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9
127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10
128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11
129: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute12
130: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute13
131: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute14
132: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute15

Line 129: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute12

125: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute8
126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9
127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10
128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11
129: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute12
130: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute13
131: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute14
132: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute15
133: FROM mtl_item_catalog_groups_vl

Line 130: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute13

126: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute9
127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10
128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11
129: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute12
130: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute13
131: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute14
132: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute15
133: FROM mtl_item_catalog_groups_vl
134: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;

Line 131: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute14

127: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute10
128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11
129: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute12
130: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute13
131: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute14
132: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute15
133: FROM mtl_item_catalog_groups_vl
134: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;
135:

Line 132: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute15

128: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute11
129: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute12
130: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute13
131: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute14
132: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute15
133: FROM mtl_item_catalog_groups_vl
134: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;
135:
136: -- Bug 3324531

Line 134: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;

130: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute13
131: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute14
132: , EGO_Globals.G_Old_Catalog_Group_Rec.attribute15
133: FROM mtl_item_catalog_groups_vl
134: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;
135:
136: -- Bug 3324531
137: -- changed the global Bom_Globals.G_RECORD_FOUND to EGO_Globals.G_RECORD_FOUND
138: x_return_status := EGO_Globals.G_RECORD_FOUND;

Line 137: -- changed the global Bom_Globals.G_RECORD_FOUND to EGO_Globals.G_RECORD_FOUND

133: FROM mtl_item_catalog_groups_vl
134: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;
135:
136: -- Bug 3324531
137: -- changed the global Bom_Globals.G_RECORD_FOUND to EGO_Globals.G_RECORD_FOUND
138: x_return_status := EGO_Globals.G_RECORD_FOUND;
139:
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN

Line 138: x_return_status := EGO_Globals.G_RECORD_FOUND;

134: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id;
135:
136: -- Bug 3324531
137: -- changed the global Bom_Globals.G_RECORD_FOUND to EGO_Globals.G_RECORD_FOUND
138: x_return_status := EGO_Globals.G_RECORD_FOUND;
139:
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN
142: -- Bug 3324531

Line 143: -- changed the global Bom_Globals.G_RECORD_NOT_FOUND to EGO_Globals.G_RECORD_NOT_FOUND

139:
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN
142: -- Bug 3324531
143: -- changed the global Bom_Globals.G_RECORD_NOT_FOUND to EGO_Globals.G_RECORD_NOT_FOUND
144: x_return_status := EGO_Globals.G_RECORD_NOT_FOUND;
145: WHEN OTHERS THEN
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147:

Line 144: x_return_status := EGO_Globals.G_RECORD_NOT_FOUND;

140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN
142: -- Bug 3324531
143: -- changed the global Bom_Globals.G_RECORD_NOT_FOUND to EGO_Globals.G_RECORD_NOT_FOUND
144: x_return_status := EGO_Globals.G_RECORD_NOT_FOUND;
145: WHEN OTHERS THEN
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147:
148: END Query_Row;

Line 163: l_LanguageCode VARCHAR2(4) := EGO_Globals.Get_Language_Code;

159: , x_return_Status OUT NOCOPY VARCHAR2
160: )
161: IS
162: l_UserId NUMBER := FND_GLOBAL.User_Id;
163: l_LanguageCode VARCHAR2(4) := EGO_Globals.Get_Language_Code;
164:
165: BEGIN
166:
167: Error_Handler.Write_Debug('Inserting Catalog Group . . . ');

Line 168: -- dbms_output.put_line('Inserting Catalog Group . . . ID' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_id);

164:
165: BEGIN
166:
167: Error_Handler.Write_Debug('Inserting Catalog Group . . . ');
168: -- dbms_output.put_line('Inserting Catalog Group . . . ID' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_id);
169:
170: INSERT INTO mtl_Item_Catalog_Groups_b
171: ( item_catalog_group_id
172: , parent_catalog_group_id

Line 220: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id

216: , last_updated_by
217: , last_update_login
218: )
219: VALUES
220: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
221: , EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
222: , EGO_Globals.G_Catalog_Group_Rec.summary_flag
223: , EGO_Globals.G_Catalog_Group_Rec.enabled_flag
224: , EGO_Globals.G_Catalog_Group_Rec.inactive_date

Line 221: , EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

217: , last_update_login
218: )
219: VALUES
220: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
221: , EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
222: , EGO_Globals.G_Catalog_Group_Rec.summary_flag
223: , EGO_Globals.G_Catalog_Group_Rec.enabled_flag
224: , EGO_Globals.G_Catalog_Group_Rec.inactive_date
225: , EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag

Line 222: , EGO_Globals.G_Catalog_Group_Rec.summary_flag

218: )
219: VALUES
220: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
221: , EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
222: , EGO_Globals.G_Catalog_Group_Rec.summary_flag
223: , EGO_Globals.G_Catalog_Group_Rec.enabled_flag
224: , EGO_Globals.G_Catalog_Group_Rec.inactive_date
225: , EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag
226: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(1)

Line 223: , EGO_Globals.G_Catalog_Group_Rec.enabled_flag

219: VALUES
220: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
221: , EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
222: , EGO_Globals.G_Catalog_Group_Rec.summary_flag
223: , EGO_Globals.G_Catalog_Group_Rec.enabled_flag
224: , EGO_Globals.G_Catalog_Group_Rec.inactive_date
225: , EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag
226: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(1)
227: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(2)

Line 224: , EGO_Globals.G_Catalog_Group_Rec.inactive_date

220: ( EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
221: , EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
222: , EGO_Globals.G_Catalog_Group_Rec.summary_flag
223: , EGO_Globals.G_Catalog_Group_Rec.enabled_flag
224: , EGO_Globals.G_Catalog_Group_Rec.inactive_date
225: , EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag
226: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(1)
227: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(2)
228: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(3)

Line 225: , EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag

221: , EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
222: , EGO_Globals.G_Catalog_Group_Rec.summary_flag
223: , EGO_Globals.G_Catalog_Group_Rec.enabled_flag
224: , EGO_Globals.G_Catalog_Group_Rec.inactive_date
225: , EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag
226: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(1)
227: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(2)
228: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(3)
229: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(4)

Line 246: , EGO_Globals.G_Catalog_Group_Rec.attribute_category

242: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(17)
243: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(18)
244: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(19)
245: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(20)
246: , EGO_Globals.G_Catalog_Group_Rec.attribute_category
247: , EGO_Globals.G_Catalog_Group_Rec.attribute1
248: , EGO_Globals.G_Catalog_Group_Rec.attribute2
249: , EGO_Globals.G_Catalog_Group_Rec.attribute3
250: , EGO_Globals.G_Catalog_Group_Rec.attribute4

Line 247: , EGO_Globals.G_Catalog_Group_Rec.attribute1

243: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(18)
244: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(19)
245: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(20)
246: , EGO_Globals.G_Catalog_Group_Rec.attribute_category
247: , EGO_Globals.G_Catalog_Group_Rec.attribute1
248: , EGO_Globals.G_Catalog_Group_Rec.attribute2
249: , EGO_Globals.G_Catalog_Group_Rec.attribute3
250: , EGO_Globals.G_Catalog_Group_Rec.attribute4
251: , EGO_Globals.G_Catalog_Group_Rec.attribute5

Line 248: , EGO_Globals.G_Catalog_Group_Rec.attribute2

244: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(19)
245: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(20)
246: , EGO_Globals.G_Catalog_Group_Rec.attribute_category
247: , EGO_Globals.G_Catalog_Group_Rec.attribute1
248: , EGO_Globals.G_Catalog_Group_Rec.attribute2
249: , EGO_Globals.G_Catalog_Group_Rec.attribute3
250: , EGO_Globals.G_Catalog_Group_Rec.attribute4
251: , EGO_Globals.G_Catalog_Group_Rec.attribute5
252: , EGO_Globals.G_Catalog_Group_Rec.attribute6

Line 249: , EGO_Globals.G_Catalog_Group_Rec.attribute3

245: , EGO_Item_Catalog_Pub.G_KF_Segment_Values(20)
246: , EGO_Globals.G_Catalog_Group_Rec.attribute_category
247: , EGO_Globals.G_Catalog_Group_Rec.attribute1
248: , EGO_Globals.G_Catalog_Group_Rec.attribute2
249: , EGO_Globals.G_Catalog_Group_Rec.attribute3
250: , EGO_Globals.G_Catalog_Group_Rec.attribute4
251: , EGO_Globals.G_Catalog_Group_Rec.attribute5
252: , EGO_Globals.G_Catalog_Group_Rec.attribute6
253: , EGO_Globals.G_Catalog_Group_Rec.attribute7

Line 250: , EGO_Globals.G_Catalog_Group_Rec.attribute4

246: , EGO_Globals.G_Catalog_Group_Rec.attribute_category
247: , EGO_Globals.G_Catalog_Group_Rec.attribute1
248: , EGO_Globals.G_Catalog_Group_Rec.attribute2
249: , EGO_Globals.G_Catalog_Group_Rec.attribute3
250: , EGO_Globals.G_Catalog_Group_Rec.attribute4
251: , EGO_Globals.G_Catalog_Group_Rec.attribute5
252: , EGO_Globals.G_Catalog_Group_Rec.attribute6
253: , EGO_Globals.G_Catalog_Group_Rec.attribute7
254: , EGO_Globals.G_Catalog_Group_Rec.attribute8

Line 251: , EGO_Globals.G_Catalog_Group_Rec.attribute5

247: , EGO_Globals.G_Catalog_Group_Rec.attribute1
248: , EGO_Globals.G_Catalog_Group_Rec.attribute2
249: , EGO_Globals.G_Catalog_Group_Rec.attribute3
250: , EGO_Globals.G_Catalog_Group_Rec.attribute4
251: , EGO_Globals.G_Catalog_Group_Rec.attribute5
252: , EGO_Globals.G_Catalog_Group_Rec.attribute6
253: , EGO_Globals.G_Catalog_Group_Rec.attribute7
254: , EGO_Globals.G_Catalog_Group_Rec.attribute8
255: , EGO_Globals.G_Catalog_Group_Rec.attribute9

Line 252: , EGO_Globals.G_Catalog_Group_Rec.attribute6

248: , EGO_Globals.G_Catalog_Group_Rec.attribute2
249: , EGO_Globals.G_Catalog_Group_Rec.attribute3
250: , EGO_Globals.G_Catalog_Group_Rec.attribute4
251: , EGO_Globals.G_Catalog_Group_Rec.attribute5
252: , EGO_Globals.G_Catalog_Group_Rec.attribute6
253: , EGO_Globals.G_Catalog_Group_Rec.attribute7
254: , EGO_Globals.G_Catalog_Group_Rec.attribute8
255: , EGO_Globals.G_Catalog_Group_Rec.attribute9
256: , EGO_Globals.G_Catalog_Group_Rec.attribute10

Line 253: , EGO_Globals.G_Catalog_Group_Rec.attribute7

249: , EGO_Globals.G_Catalog_Group_Rec.attribute3
250: , EGO_Globals.G_Catalog_Group_Rec.attribute4
251: , EGO_Globals.G_Catalog_Group_Rec.attribute5
252: , EGO_Globals.G_Catalog_Group_Rec.attribute6
253: , EGO_Globals.G_Catalog_Group_Rec.attribute7
254: , EGO_Globals.G_Catalog_Group_Rec.attribute8
255: , EGO_Globals.G_Catalog_Group_Rec.attribute9
256: , EGO_Globals.G_Catalog_Group_Rec.attribute10
257: , EGO_Globals.G_Catalog_Group_Rec.attribute11

Line 254: , EGO_Globals.G_Catalog_Group_Rec.attribute8

250: , EGO_Globals.G_Catalog_Group_Rec.attribute4
251: , EGO_Globals.G_Catalog_Group_Rec.attribute5
252: , EGO_Globals.G_Catalog_Group_Rec.attribute6
253: , EGO_Globals.G_Catalog_Group_Rec.attribute7
254: , EGO_Globals.G_Catalog_Group_Rec.attribute8
255: , EGO_Globals.G_Catalog_Group_Rec.attribute9
256: , EGO_Globals.G_Catalog_Group_Rec.attribute10
257: , EGO_Globals.G_Catalog_Group_Rec.attribute11
258: , EGO_Globals.G_Catalog_Group_Rec.attribute12

Line 255: , EGO_Globals.G_Catalog_Group_Rec.attribute9

251: , EGO_Globals.G_Catalog_Group_Rec.attribute5
252: , EGO_Globals.G_Catalog_Group_Rec.attribute6
253: , EGO_Globals.G_Catalog_Group_Rec.attribute7
254: , EGO_Globals.G_Catalog_Group_Rec.attribute8
255: , EGO_Globals.G_Catalog_Group_Rec.attribute9
256: , EGO_Globals.G_Catalog_Group_Rec.attribute10
257: , EGO_Globals.G_Catalog_Group_Rec.attribute11
258: , EGO_Globals.G_Catalog_Group_Rec.attribute12
259: , EGO_Globals.G_Catalog_Group_Rec.attribute13

Line 256: , EGO_Globals.G_Catalog_Group_Rec.attribute10

252: , EGO_Globals.G_Catalog_Group_Rec.attribute6
253: , EGO_Globals.G_Catalog_Group_Rec.attribute7
254: , EGO_Globals.G_Catalog_Group_Rec.attribute8
255: , EGO_Globals.G_Catalog_Group_Rec.attribute9
256: , EGO_Globals.G_Catalog_Group_Rec.attribute10
257: , EGO_Globals.G_Catalog_Group_Rec.attribute11
258: , EGO_Globals.G_Catalog_Group_Rec.attribute12
259: , EGO_Globals.G_Catalog_Group_Rec.attribute13
260: , EGO_Globals.G_Catalog_Group_Rec.attribute14

Line 257: , EGO_Globals.G_Catalog_Group_Rec.attribute11

253: , EGO_Globals.G_Catalog_Group_Rec.attribute7
254: , EGO_Globals.G_Catalog_Group_Rec.attribute8
255: , EGO_Globals.G_Catalog_Group_Rec.attribute9
256: , EGO_Globals.G_Catalog_Group_Rec.attribute10
257: , EGO_Globals.G_Catalog_Group_Rec.attribute11
258: , EGO_Globals.G_Catalog_Group_Rec.attribute12
259: , EGO_Globals.G_Catalog_Group_Rec.attribute13
260: , EGO_Globals.G_Catalog_Group_Rec.attribute14
261: , EGO_Globals.G_Catalog_Group_Rec.attribute15

Line 258: , EGO_Globals.G_Catalog_Group_Rec.attribute12

254: , EGO_Globals.G_Catalog_Group_Rec.attribute8
255: , EGO_Globals.G_Catalog_Group_Rec.attribute9
256: , EGO_Globals.G_Catalog_Group_Rec.attribute10
257: , EGO_Globals.G_Catalog_Group_Rec.attribute11
258: , EGO_Globals.G_Catalog_Group_Rec.attribute12
259: , EGO_Globals.G_Catalog_Group_Rec.attribute13
260: , EGO_Globals.G_Catalog_Group_Rec.attribute14
261: , EGO_Globals.G_Catalog_Group_Rec.attribute15
262: , SYSDATE

Line 259: , EGO_Globals.G_Catalog_Group_Rec.attribute13

255: , EGO_Globals.G_Catalog_Group_Rec.attribute9
256: , EGO_Globals.G_Catalog_Group_Rec.attribute10
257: , EGO_Globals.G_Catalog_Group_Rec.attribute11
258: , EGO_Globals.G_Catalog_Group_Rec.attribute12
259: , EGO_Globals.G_Catalog_Group_Rec.attribute13
260: , EGO_Globals.G_Catalog_Group_Rec.attribute14
261: , EGO_Globals.G_Catalog_Group_Rec.attribute15
262: , SYSDATE
263: , FND_Global.User_Id

Line 260: , EGO_Globals.G_Catalog_Group_Rec.attribute14

256: , EGO_Globals.G_Catalog_Group_Rec.attribute10
257: , EGO_Globals.G_Catalog_Group_Rec.attribute11
258: , EGO_Globals.G_Catalog_Group_Rec.attribute12
259: , EGO_Globals.G_Catalog_Group_Rec.attribute13
260: , EGO_Globals.G_Catalog_Group_Rec.attribute14
261: , EGO_Globals.G_Catalog_Group_Rec.attribute15
262: , SYSDATE
263: , FND_Global.User_Id
264: , SYSDATE

Line 261: , EGO_Globals.G_Catalog_Group_Rec.attribute15

257: , EGO_Globals.G_Catalog_Group_Rec.attribute11
258: , EGO_Globals.G_Catalog_Group_Rec.attribute12
259: , EGO_Globals.G_Catalog_Group_Rec.attribute13
260: , EGO_Globals.G_Catalog_Group_Rec.attribute14
261: , EGO_Globals.G_Catalog_Group_Rec.attribute15
262: , SYSDATE
263: , FND_Global.User_Id
264: , SYSDATE
265: , FND_Global.User_Id

Line 287: SELECT EGO_Globals.G_Catalog_Group_Rec.catalog_group_id

283: , Last_Updated_By
284: , Last_Update_Date
285: , Description
286: )
287: SELECT EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
288: , lang.language_code
289: , l_LanguageCode
290: , l_UserId
291: , SYSDATE

Line 294: , EGO_Globals.G_Catalog_Group_Rec.description

290: , l_UserId
291: , SYSDATE
292: , l_UserId
293: , SYSDATE
294: , EGO_Globals.G_Catalog_Group_Rec.description
295: FROM FND_LANGUAGES lang
296: WHERE lang.installed_flag in ('I', 'B')
297: AND NOT EXISTS
298: ( SELECT NULL

Line 300: WHERE tl.item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id

296: WHERE lang.installed_flag in ('I', 'B')
297: AND NOT EXISTS
298: ( SELECT NULL
299: FROM Mtl_Item_Catalog_Groups_tl TL
300: WHERE tl.item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
301: AND tl.language = lang.language_code
302: );
303: -- call the sync Catalog Group function.
304: EGO_BROWSE_PVT.Sync_ICG_Denorm_Hier_Table

Line 305: (p_catalog_group_id => EGO_Globals.G_Catalog_Group_Rec.catalog_group_id

301: AND tl.language = lang.language_code
302: );
303: -- call the sync Catalog Group function.
304: EGO_BROWSE_PVT.Sync_ICG_Denorm_Hier_Table
305: (p_catalog_group_id => EGO_Globals.G_Catalog_Group_Rec.catalog_group_id
306: ,p_old_parent_id => NULL
307: ,x_return_status => x_return_status
308: );
309:

Line 358: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;

354: SELECT parent_catalog_group_id
355: INTO l_old_parent_id
356: FROM mtl_item_catalog_groups_b
357: WHERE item_catalog_group_id =
358: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
359:
360: UPDATE mtl_item_catalog_groups_b
361: SET Item_Creation_Allowed_Flag = EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag
362: , parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

Line 361: SET Item_Creation_Allowed_Flag = EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag

357: WHERE item_catalog_group_id =
358: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
359:
360: UPDATE mtl_item_catalog_groups_b
361: SET Item_Creation_Allowed_Flag = EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag
362: , parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
363: , Segment1 = EGO_Item_Catalog_Pub.G_KF_Segment_Values(1)
364: , Segment2 = EGO_Item_Catalog_Pub.G_KF_Segment_Values(2)
365: , Segment3 = EGO_Item_Catalog_Pub.G_KF_Segment_Values(3)

Line 362: , parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id

358: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
359:
360: UPDATE mtl_item_catalog_groups_b
361: SET Item_Creation_Allowed_Flag = EGO_Globals.G_Catalog_Group_Rec.Item_Creation_Allowed_Flag
362: , parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id
363: , Segment1 = EGO_Item_Catalog_Pub.G_KF_Segment_Values(1)
364: , Segment2 = EGO_Item_Catalog_Pub.G_KF_Segment_Values(2)
365: , Segment3 = EGO_Item_Catalog_Pub.G_KF_Segment_Values(3)
366: , Segment4 = EGO_Item_Catalog_Pub.G_KF_Segment_Values(4)

Line 383: , description = EGO_Globals.G_Catalog_Group_Rec.description

379: , Segment17= EGO_Item_Catalog_Pub.G_KF_Segment_Values(17)
380: , Segment18= EGO_Item_Catalog_Pub.G_KF_Segment_Values(18)
381: , Segment19= EGO_Item_Catalog_Pub.G_KF_Segment_Values(19)
382: , Segment20= EGO_Item_Catalog_Pub.G_KF_Segment_Values(20)
383: , description = EGO_Globals.G_Catalog_Group_Rec.description
384: , last_update_date = SYSDATE
385: , last_updated_by = FND_Global.User_Id
386: , last_update_login = FND_Global.User_Id
387: , attribute_category = EGO_Globals.G_Catalog_Group_Rec.attribute_category

Line 387: , attribute_category = EGO_Globals.G_Catalog_Group_Rec.attribute_category

383: , description = EGO_Globals.G_Catalog_Group_Rec.description
384: , last_update_date = SYSDATE
385: , last_updated_by = FND_Global.User_Id
386: , last_update_login = FND_Global.User_Id
387: , attribute_category = EGO_Globals.G_Catalog_Group_Rec.attribute_category
388: , attribute1 = EGO_Globals.G_Catalog_Group_Rec.attribute1
389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2
390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3
391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4

Line 388: , attribute1 = EGO_Globals.G_Catalog_Group_Rec.attribute1

384: , last_update_date = SYSDATE
385: , last_updated_by = FND_Global.User_Id
386: , last_update_login = FND_Global.User_Id
387: , attribute_category = EGO_Globals.G_Catalog_Group_Rec.attribute_category
388: , attribute1 = EGO_Globals.G_Catalog_Group_Rec.attribute1
389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2
390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3
391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4
392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5

Line 389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2

385: , last_updated_by = FND_Global.User_Id
386: , last_update_login = FND_Global.User_Id
387: , attribute_category = EGO_Globals.G_Catalog_Group_Rec.attribute_category
388: , attribute1 = EGO_Globals.G_Catalog_Group_Rec.attribute1
389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2
390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3
391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4
392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5
393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6

Line 390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3

386: , last_update_login = FND_Global.User_Id
387: , attribute_category = EGO_Globals.G_Catalog_Group_Rec.attribute_category
388: , attribute1 = EGO_Globals.G_Catalog_Group_Rec.attribute1
389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2
390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3
391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4
392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5
393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6
394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7

Line 391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4

387: , attribute_category = EGO_Globals.G_Catalog_Group_Rec.attribute_category
388: , attribute1 = EGO_Globals.G_Catalog_Group_Rec.attribute1
389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2
390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3
391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4
392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5
393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6
394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7
395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8

Line 392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5

388: , attribute1 = EGO_Globals.G_Catalog_Group_Rec.attribute1
389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2
390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3
391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4
392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5
393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6
394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7
395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8
396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9

Line 393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6

389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2
390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3
391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4
392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5
393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6
394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7
395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8
396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9
397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10

Line 394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7

390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3
391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4
392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5
393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6
394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7
395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8
396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9
397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10
398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11

Line 395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8

391: , attribute4 = EGO_Globals.G_Catalog_Group_Rec.attribute4
392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5
393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6
394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7
395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8
396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9
397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10
398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11
399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12

Line 396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9

392: , attribute5 = EGO_Globals.G_Catalog_Group_Rec.attribute5
393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6
394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7
395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8
396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9
397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10
398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11
399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12
400: , attribute13= EGO_Globals.G_Catalog_Group_Rec.attribute13

Line 397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10

393: , attribute6 = EGO_Globals.G_Catalog_Group_Rec.attribute6
394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7
395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8
396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9
397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10
398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11
399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12
400: , attribute13= EGO_Globals.G_Catalog_Group_Rec.attribute13
401: , attribute14= EGO_Globals.G_Catalog_Group_Rec.attribute14

Line 398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11

394: , attribute7 = EGO_Globals.G_Catalog_Group_Rec.attribute7
395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8
396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9
397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10
398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11
399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12
400: , attribute13= EGO_Globals.G_Catalog_Group_Rec.attribute13
401: , attribute14= EGO_Globals.G_Catalog_Group_Rec.attribute14
402: , attribute15= EGO_Globals.G_Catalog_Group_Rec.attribute15

Line 399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12

395: , attribute8 = EGO_Globals.G_Catalog_Group_Rec.attribute8
396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9
397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10
398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11
399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12
400: , attribute13= EGO_Globals.G_Catalog_Group_Rec.attribute13
401: , attribute14= EGO_Globals.G_Catalog_Group_Rec.attribute14
402: , attribute15= EGO_Globals.G_Catalog_Group_Rec.attribute15
403: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;

Line 400: , attribute13= EGO_Globals.G_Catalog_Group_Rec.attribute13

396: , attribute9 = EGO_Globals.G_Catalog_Group_Rec.attribute9
397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10
398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11
399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12
400: , attribute13= EGO_Globals.G_Catalog_Group_Rec.attribute13
401: , attribute14= EGO_Globals.G_Catalog_Group_Rec.attribute14
402: , attribute15= EGO_Globals.G_Catalog_Group_Rec.attribute15
403: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
404:

Line 401: , attribute14= EGO_Globals.G_Catalog_Group_Rec.attribute14

397: , attribute10= EGO_Globals.G_Catalog_Group_Rec.attribute10
398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11
399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12
400: , attribute13= EGO_Globals.G_Catalog_Group_Rec.attribute13
401: , attribute14= EGO_Globals.G_Catalog_Group_Rec.attribute14
402: , attribute15= EGO_Globals.G_Catalog_Group_Rec.attribute15
403: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
404:
405:

Line 402: , attribute15= EGO_Globals.G_Catalog_Group_Rec.attribute15

398: , attribute11= EGO_Globals.G_Catalog_Group_Rec.attribute11
399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12
400: , attribute13= EGO_Globals.G_Catalog_Group_Rec.attribute13
401: , attribute14= EGO_Globals.G_Catalog_Group_Rec.attribute14
402: , attribute15= EGO_Globals.G_Catalog_Group_Rec.attribute15
403: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
404:
405:
406: /* Update the TL table description */

Line 403: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;

399: , attribute12= EGO_Globals.G_Catalog_Group_Rec.attribute12
400: , attribute13= EGO_Globals.G_Catalog_Group_Rec.attribute13
401: , attribute14= EGO_Globals.G_Catalog_Group_Rec.attribute14
402: , attribute15= EGO_Globals.G_Catalog_Group_Rec.attribute15
403: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
404:
405:
406: /* Update the TL table description */
407:

Line 409: SET description = EGO_Globals.G_Catalog_Group_Rec.description

405:
406: /* Update the TL table description */
407:
408: UPDATE Mtl_Item_Catalog_Groups_TL
409: SET description = EGO_Globals.G_Catalog_Group_Rec.description
410: , last_updated_by = FND_Global.User_Id
411: , last_update_date = SYSDATE
412: WHERE item_catalog_group_id =
413: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id

Line 413: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id

409: SET description = EGO_Globals.G_Catalog_Group_Rec.description
410: , last_updated_by = FND_Global.User_Id
411: , last_update_date = SYSDATE
412: WHERE item_catalog_group_id =
413: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id
414: AND LANGUAGE = EGO_Globals.Get_Language_Code;
415:
416: /* Update for the end date */
417:

Line 414: AND LANGUAGE = EGO_Globals.Get_Language_Code;

410: , last_updated_by = FND_Global.User_Id
411: , last_update_date = SYSDATE
412: WHERE item_catalog_group_id =
413: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id
414: AND LANGUAGE = EGO_Globals.Get_Language_Code;
415:
416: /* Update for the end date */
417:
418: IF EGO_Globals.G_Catalog_Group_Rec.inactive_date IS NOT NULL

Line 418: IF EGO_Globals.G_Catalog_Group_Rec.inactive_date IS NOT NULL

414: AND LANGUAGE = EGO_Globals.Get_Language_Code;
415:
416: /* Update for the end date */
417:
418: IF EGO_Globals.G_Catalog_Group_Rec.inactive_date IS NOT NULL
419: THEN
420: -- If old end date is null or the old end date is
421: -- different from the new end date
422:

Line 423: IF EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NULL

419: THEN
420: -- If old end date is null or the old end date is
421: -- different from the new end date
422:
423: IF EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NULL
424: OR (EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NOT NULL AND
425: trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) <>
426: trunc(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date))
427: THEN

Line 424: OR (EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NOT NULL AND

420: -- If old end date is null or the old end date is
421: -- different from the new end date
422:
423: IF EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NULL
424: OR (EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NOT NULL AND
425: trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) <>
426: trunc(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date))
427: THEN
428: /* Propagate the new end date to all the recursive childs of this catalog */

Line 425: trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) <>

421: -- different from the new end date
422:
423: IF EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NULL
424: OR (EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NOT NULL AND
425: trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) <>
426: trunc(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date))
427: THEN
428: /* Propagate the new end date to all the recursive childs of this catalog */
429: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)

Line 426: trunc(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date))

422:
423: IF EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NULL
424: OR (EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date IS NOT NULL AND
425: trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) <>
426: trunc(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date))
427: THEN
428: /* Propagate the new end date to all the recursive childs of this catalog */
429: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)
430: LOOP

Line 429: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)

425: trunc(EGO_Globals.G_Catalog_Group_Rec.inactive_date) <>
426: trunc(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date))
427: THEN
428: /* Propagate the new end date to all the recursive childs of this catalog */
429: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)
430: LOOP
431: UPDATE mtl_item_catalog_groups_b
432: SET inactive_date = EGO_Globals.G_Catalog_Group_Rec.inactive_date
433: WHERE item_catalog_group_id = r1.item_catalog_group_id;

Line 432: SET inactive_date = EGO_Globals.G_Catalog_Group_Rec.inactive_date

428: /* Propagate the new end date to all the recursive childs of this catalog */
429: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)
430: LOOP
431: UPDATE mtl_item_catalog_groups_b
432: SET inactive_date = EGO_Globals.G_Catalog_Group_Rec.inactive_date
433: WHERE item_catalog_group_id = r1.item_catalog_group_id;
434: END LOOP;
435: END IF;
436:

Line 440: IF trunc(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date) IS NOT NULL

436:
437: ELSE
438: -- If there exists an end date and the new end date is null
439:
440: IF trunc(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date) IS NOT NULL
441: THEN
442: /* Propagate null (remove end date) to all the recursive childs */
443: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)
444: LOOP

Line 443: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)

439:
440: IF trunc(EGO_Globals.G_Old_Catalog_Group_Rec.inactive_date) IS NOT NULL
441: THEN
442: /* Propagate null (remove end date) to all the recursive childs */
443: FOR r1 IN c1(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)
444: LOOP
445: UPDATE mtl_item_catalog_groups_b
446: SET inactive_date = null
447: WHERE item_catalog_group_id = r1.item_catalog_group_id;

Line 454: NVL(EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id,-1) THEN

450:
451: END IF;
452:
453: IF NVL(l_old_parent_id,-1) <>
454: NVL(EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id,-1) THEN
455: EGO_BROWSE_PVT.Sync_ICG_Denorm_Hier_Table
456: (p_catalog_group_id => EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id
457: ,p_old_parent_id => l_old_parent_id
458: ,x_return_status => x_return_status

Line 456: (p_catalog_group_id => EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id

452:
453: IF NVL(l_old_parent_id,-1) <>
454: NVL(EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_id,-1) THEN
455: EGO_BROWSE_PVT.Sync_ICG_Denorm_Hier_Table
456: (p_catalog_group_id => EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id
457: ,p_old_parent_id => l_old_parent_id
458: ,x_return_status => x_return_status
459: );
460: END IF;

Line 498: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id

494:
495: /* Delete from TL */
496:
497: DELETE FROM mtl_item_catalog_groups_tl WHERE
498: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id
499: AND LANGUAGE = EGO_Globals.Get_Language_Code;
500:
501: /* Delete from base table */
502:

Line 499: AND LANGUAGE = EGO_Globals.Get_Language_Code;

495: /* Delete from TL */
496:
497: DELETE FROM mtl_item_catalog_groups_tl WHERE
498: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id
499: AND LANGUAGE = EGO_Globals.Get_Language_Code;
500:
501: /* Delete from base table */
502:
503: DELETE FROM mtl_item_catalog_groups_b WHERE

Line 504: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;

500:
501: /* Delete from base table */
502:
503: DELETE FROM mtl_item_catalog_groups_b WHERE
504: item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id;
505:
506: EGO_BROWSE_PVT.Reload_ICG_Denorm_Hier_Table (x_return_status => x_return_status);
507:
508: EXCEPTION WHEN OTHERS

Line 541: IF EGO_Globals.G_Catalog_Group_Rec.transaction_type = EGO_GLOBALS.G_OPR_CREATE

537: IS
538: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
539: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
540: BEGIN
541: IF EGO_Globals.G_Catalog_Group_Rec.transaction_type = EGO_GLOBALS.G_OPR_CREATE
542: THEN
543: -- dbms_output.put_line('Inserting row . . . ');
544: Insert_Row
545: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 548: ELSIF EGO_Globals.G_Catalog_Group_Rec.transaction_type =

544: Insert_Row
545: ( x_mesg_token_Tbl => l_mesg_token_tbl
546: , x_return_Status => l_return_status
547: );
548: ELSIF EGO_Globals.G_Catalog_Group_Rec.transaction_type =
549: EGO_GLOBALS.G_OPR_UPDATE
550: THEN
551: -- dbms_output.put_line('Updating row . . . ');
552: Update_Row

Line 549: EGO_GLOBALS.G_OPR_UPDATE

545: ( x_mesg_token_Tbl => l_mesg_token_tbl
546: , x_return_Status => l_return_status
547: );
548: ELSIF EGO_Globals.G_Catalog_Group_Rec.transaction_type =
549: EGO_GLOBALS.G_OPR_UPDATE
550: THEN
551: -- dbms_output.put_line('Updating row . . . ');
552: Update_Row
553: ( x_mesg_token_Tbl => l_mesg_token_tbl

Line 557: ELSIF EGO_Globals.G_Catalog_Group_Rec.transaction_type =

553: ( x_mesg_token_Tbl => l_mesg_token_tbl
554: , x_return_Status => l_return_status
555: );
556:
557: ELSIF EGO_Globals.G_Catalog_Group_Rec.transaction_type =
558: EGO_GLOBALS.G_OPR_DELETE
559: THEN
560: -- dbms_output.put_line('Deleting row . . . ');
561: Delete_Row

Line 558: EGO_GLOBALS.G_OPR_DELETE

554: , x_return_Status => l_return_status
555: );
556:
557: ELSIF EGO_Globals.G_Catalog_Group_Rec.transaction_type =
558: EGO_GLOBALS.G_OPR_DELETE
559: THEN
560: -- dbms_output.put_line('Deleting row . . . ');
561: Delete_Row
562: ( x_mesg_token_Tbl => l_mesg_token_tbl