APPS.CN_IMPORT_TYPES_PKG dependencies on FND_API

Line 49: DECODE(p_import_types_rec.IMPORT_TYPE_ID, FND_API.G_MISS_NUM, NULL,

45: LAST_UPDATE_DATE,
46: LAST_UPDATED_BY,
47: LAST_UPDATE_LOGIN)
48: select
49: DECODE(p_import_types_rec.IMPORT_TYPE_ID, FND_API.G_MISS_NUM, NULL,
50: p_import_types_rec.IMPORT_TYPE_ID),
51: DECODE(p_import_types_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,
52: p_import_types_rec.IMPORT_TYPE_CODE),
53: DECODE(p_import_types_rec.VIEW_NAME, FND_API.G_MISS_CHAR, NULL,

Line 51: DECODE(p_import_types_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,

47: LAST_UPDATE_LOGIN)
48: select
49: DECODE(p_import_types_rec.IMPORT_TYPE_ID, FND_API.G_MISS_NUM, NULL,
50: p_import_types_rec.IMPORT_TYPE_ID),
51: DECODE(p_import_types_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,
52: p_import_types_rec.IMPORT_TYPE_CODE),
53: DECODE(p_import_types_rec.VIEW_NAME, FND_API.G_MISS_CHAR, NULL,
54: p_import_types_rec.VIEW_NAME),
55: DECODE(p_import_types_rec.CONC_PROGRAM, FND_API.G_MISS_CHAR, NULL,

Line 53: DECODE(p_import_types_rec.VIEW_NAME, FND_API.G_MISS_CHAR, NULL,

49: DECODE(p_import_types_rec.IMPORT_TYPE_ID, FND_API.G_MISS_NUM, NULL,
50: p_import_types_rec.IMPORT_TYPE_ID),
51: DECODE(p_import_types_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,
52: p_import_types_rec.IMPORT_TYPE_CODE),
53: DECODE(p_import_types_rec.VIEW_NAME, FND_API.G_MISS_CHAR, NULL,
54: p_import_types_rec.VIEW_NAME),
55: DECODE(p_import_types_rec.CONC_PROGRAM, FND_API.G_MISS_CHAR, NULL,
56: p_import_types_rec.CONC_PROGRAM),
57: DECODE(p_import_types_rec.TABLE_ID, FND_API.G_MISS_NUM, NULL,

Line 55: DECODE(p_import_types_rec.CONC_PROGRAM, FND_API.G_MISS_CHAR, NULL,

51: DECODE(p_import_types_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,
52: p_import_types_rec.IMPORT_TYPE_CODE),
53: DECODE(p_import_types_rec.VIEW_NAME, FND_API.G_MISS_CHAR, NULL,
54: p_import_types_rec.VIEW_NAME),
55: DECODE(p_import_types_rec.CONC_PROGRAM, FND_API.G_MISS_CHAR, NULL,
56: p_import_types_rec.CONC_PROGRAM),
57: DECODE(p_import_types_rec.TABLE_ID, FND_API.G_MISS_NUM, NULL,
58: p_import_types_rec.TABLE_ID),
59: 1,

Line 57: DECODE(p_import_types_rec.TABLE_ID, FND_API.G_MISS_NUM, NULL,

53: DECODE(p_import_types_rec.VIEW_NAME, FND_API.G_MISS_CHAR, NULL,
54: p_import_types_rec.VIEW_NAME),
55: DECODE(p_import_types_rec.CONC_PROGRAM, FND_API.G_MISS_CHAR, NULL,
56: p_import_types_rec.CONC_PROGRAM),
57: DECODE(p_import_types_rec.TABLE_ID, FND_API.G_MISS_NUM, NULL,
58: p_import_types_rec.TABLE_ID),
59: 1,
60: DECODE(p_import_types_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
61: p_import_types_rec.ATTRIBUTE_CATEGORY),

Line 60: DECODE(p_import_types_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

56: p_import_types_rec.CONC_PROGRAM),
57: DECODE(p_import_types_rec.TABLE_ID, FND_API.G_MISS_NUM, NULL,
58: p_import_types_rec.TABLE_ID),
59: 1,
60: DECODE(p_import_types_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
61: p_import_types_rec.ATTRIBUTE_CATEGORY),
62: DECODE(p_import_types_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
63: p_import_types_rec.ATTRIBUTE1),
64: DECODE(p_import_types_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

Line 62: DECODE(p_import_types_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,

58: p_import_types_rec.TABLE_ID),
59: 1,
60: DECODE(p_import_types_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
61: p_import_types_rec.ATTRIBUTE_CATEGORY),
62: DECODE(p_import_types_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
63: p_import_types_rec.ATTRIBUTE1),
64: DECODE(p_import_types_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
65: p_import_types_rec.ATTRIBUTE2),
66: DECODE(p_import_types_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

Line 64: DECODE(p_import_types_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

60: DECODE(p_import_types_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
61: p_import_types_rec.ATTRIBUTE_CATEGORY),
62: DECODE(p_import_types_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
63: p_import_types_rec.ATTRIBUTE1),
64: DECODE(p_import_types_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
65: p_import_types_rec.ATTRIBUTE2),
66: DECODE(p_import_types_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
67: p_import_types_rec.ATTRIBUTE3),
68: DECODE(p_import_types_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

Line 66: DECODE(p_import_types_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

62: DECODE(p_import_types_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
63: p_import_types_rec.ATTRIBUTE1),
64: DECODE(p_import_types_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
65: p_import_types_rec.ATTRIBUTE2),
66: DECODE(p_import_types_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
67: p_import_types_rec.ATTRIBUTE3),
68: DECODE(p_import_types_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
69: p_import_types_rec.ATTRIBUTE4),
70: DECODE(p_import_types_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

Line 68: DECODE(p_import_types_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

64: DECODE(p_import_types_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
65: p_import_types_rec.ATTRIBUTE2),
66: DECODE(p_import_types_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
67: p_import_types_rec.ATTRIBUTE3),
68: DECODE(p_import_types_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
69: p_import_types_rec.ATTRIBUTE4),
70: DECODE(p_import_types_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
71: p_import_types_rec.ATTRIBUTE5),
72: DECODE(p_import_types_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

Line 70: DECODE(p_import_types_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

66: DECODE(p_import_types_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
67: p_import_types_rec.ATTRIBUTE3),
68: DECODE(p_import_types_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
69: p_import_types_rec.ATTRIBUTE4),
70: DECODE(p_import_types_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
71: p_import_types_rec.ATTRIBUTE5),
72: DECODE(p_import_types_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
73: p_import_types_rec.ATTRIBUTE6),
74: DECODE(p_import_types_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

Line 72: DECODE(p_import_types_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

68: DECODE(p_import_types_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
69: p_import_types_rec.ATTRIBUTE4),
70: DECODE(p_import_types_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
71: p_import_types_rec.ATTRIBUTE5),
72: DECODE(p_import_types_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
73: p_import_types_rec.ATTRIBUTE6),
74: DECODE(p_import_types_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
75: p_import_types_rec.ATTRIBUTE7),
76: DECODE(p_import_types_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

Line 74: DECODE(p_import_types_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

70: DECODE(p_import_types_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
71: p_import_types_rec.ATTRIBUTE5),
72: DECODE(p_import_types_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
73: p_import_types_rec.ATTRIBUTE6),
74: DECODE(p_import_types_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
75: p_import_types_rec.ATTRIBUTE7),
76: DECODE(p_import_types_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
77: p_import_types_rec.ATTRIBUTE8),
78: DECODE(p_import_types_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

Line 76: DECODE(p_import_types_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

72: DECODE(p_import_types_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
73: p_import_types_rec.ATTRIBUTE6),
74: DECODE(p_import_types_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
75: p_import_types_rec.ATTRIBUTE7),
76: DECODE(p_import_types_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
77: p_import_types_rec.ATTRIBUTE8),
78: DECODE(p_import_types_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
79: p_import_types_rec.ATTRIBUTE9),
80: DECODE(p_import_types_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

Line 78: DECODE(p_import_types_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

74: DECODE(p_import_types_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
75: p_import_types_rec.ATTRIBUTE7),
76: DECODE(p_import_types_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
77: p_import_types_rec.ATTRIBUTE8),
78: DECODE(p_import_types_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
79: p_import_types_rec.ATTRIBUTE9),
80: DECODE(p_import_types_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
81: p_import_types_rec.ATTRIBUTE10),
82: DECODE(p_import_types_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

Line 80: DECODE(p_import_types_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

76: DECODE(p_import_types_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
77: p_import_types_rec.ATTRIBUTE8),
78: DECODE(p_import_types_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
79: p_import_types_rec.ATTRIBUTE9),
80: DECODE(p_import_types_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
81: p_import_types_rec.ATTRIBUTE10),
82: DECODE(p_import_types_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
83: p_import_types_rec.ATTRIBUTE11),
84: DECODE(p_import_types_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

Line 82: DECODE(p_import_types_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

78: DECODE(p_import_types_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
79: p_import_types_rec.ATTRIBUTE9),
80: DECODE(p_import_types_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
81: p_import_types_rec.ATTRIBUTE10),
82: DECODE(p_import_types_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
83: p_import_types_rec.ATTRIBUTE11),
84: DECODE(p_import_types_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
85: p_import_types_rec.ATTRIBUTE12),
86: DECODE(p_import_types_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

Line 84: DECODE(p_import_types_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

80: DECODE(p_import_types_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
81: p_import_types_rec.ATTRIBUTE10),
82: DECODE(p_import_types_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
83: p_import_types_rec.ATTRIBUTE11),
84: DECODE(p_import_types_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
85: p_import_types_rec.ATTRIBUTE12),
86: DECODE(p_import_types_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
87: p_import_types_rec.ATTRIBUTE13),
88: DECODE(p_import_types_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

Line 86: DECODE(p_import_types_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

82: DECODE(p_import_types_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
83: p_import_types_rec.ATTRIBUTE11),
84: DECODE(p_import_types_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
85: p_import_types_rec.ATTRIBUTE12),
86: DECODE(p_import_types_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
87: p_import_types_rec.ATTRIBUTE13),
88: DECODE(p_import_types_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
89: p_import_types_rec.ATTRIBUTE14),
90: DECODE(p_import_types_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

Line 88: DECODE(p_import_types_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

84: DECODE(p_import_types_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
85: p_import_types_rec.ATTRIBUTE12),
86: DECODE(p_import_types_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
87: p_import_types_rec.ATTRIBUTE13),
88: DECODE(p_import_types_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
89: p_import_types_rec.ATTRIBUTE14),
90: DECODE(p_import_types_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
91: p_import_types_rec.ATTRIBUTE15),
92: Sysdate,

Line 90: DECODE(p_import_types_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

86: DECODE(p_import_types_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
87: p_import_types_rec.ATTRIBUTE13),
88: DECODE(p_import_types_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
89: p_import_types_rec.ATTRIBUTE14),
90: DECODE(p_import_types_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
91: p_import_types_rec.ATTRIBUTE15),
92: Sysdate,
93: fnd_global.user_id,
94: Sysdate,

Line 121: FND_API.G_MISS_CHAR,

117:
118: UPDATE CN_IMPORT_TYPES oldrec
119: SET
120: IMPORT_TYPE_CODE = DECODE(p_import_types_rec.IMPORT_TYPE_CODE,
121: FND_API.G_MISS_CHAR,
122: oldrec.IMPORT_TYPE_CODE,
123: p_import_types_rec.IMPORT_TYPE_CODE),
124: VIEW_NAME = DECODE(p_import_types_rec.VIEW_NAME,
125: FND_API.G_MISS_CHAR,

Line 125: FND_API.G_MISS_CHAR,

121: FND_API.G_MISS_CHAR,
122: oldrec.IMPORT_TYPE_CODE,
123: p_import_types_rec.IMPORT_TYPE_CODE),
124: VIEW_NAME = DECODE(p_import_types_rec.VIEW_NAME,
125: FND_API.G_MISS_CHAR,
126: oldrec.VIEW_NAME,
127: p_import_types_rec.VIEW_NAME),
128: CONC_PROGRAM = DECODE(p_import_types_rec.CONC_PROGRAM,
129: FND_API.G_MISS_CHAR,

Line 129: FND_API.G_MISS_CHAR,

125: FND_API.G_MISS_CHAR,
126: oldrec.VIEW_NAME,
127: p_import_types_rec.VIEW_NAME),
128: CONC_PROGRAM = DECODE(p_import_types_rec.CONC_PROGRAM,
129: FND_API.G_MISS_CHAR,
130: oldrec.CONC_PROGRAM,
131: p_import_types_rec.CONC_PROGRAM),
132: TABLE_ID = DECODE(p_import_types_rec.TABLE_ID,
133: FND_API.G_MISS_NUM,

Line 133: FND_API.G_MISS_NUM,

129: FND_API.G_MISS_CHAR,
130: oldrec.CONC_PROGRAM,
131: p_import_types_rec.CONC_PROGRAM),
132: TABLE_ID = DECODE(p_import_types_rec.TABLE_ID,
133: FND_API.G_MISS_NUM,
134: oldrec.TABLE_ID,
135: p_import_types_rec.TABLE_ID),
136: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
137: ATTRIBUTE_CATEGORY = DECODE(p_import_types_rec.ATTRIBUTE_CATEGORY,

Line 138: FND_API.G_MISS_CHAR,

134: oldrec.TABLE_ID,
135: p_import_types_rec.TABLE_ID),
136: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
137: ATTRIBUTE_CATEGORY = DECODE(p_import_types_rec.ATTRIBUTE_CATEGORY,
138: FND_API.G_MISS_CHAR,
139: oldrec.ATTRIBUTE_CATEGORY,
140: p_import_types_rec.ATTRIBUTE_CATEGORY),
141: ATTRIBUTE1 = DECODE(p_import_types_rec.ATTRIBUTE1,
142: FND_API.G_MISS_CHAR,

Line 142: FND_API.G_MISS_CHAR,

138: FND_API.G_MISS_CHAR,
139: oldrec.ATTRIBUTE_CATEGORY,
140: p_import_types_rec.ATTRIBUTE_CATEGORY),
141: ATTRIBUTE1 = DECODE(p_import_types_rec.ATTRIBUTE1,
142: FND_API.G_MISS_CHAR,
143: oldrec.ATTRIBUTE1,
144: p_import_types_rec.ATTRIBUTE1),
145: ATTRIBUTE2 = DECODE(p_import_types_rec.ATTRIBUTE2,
146: FND_API.G_MISS_CHAR,

Line 146: FND_API.G_MISS_CHAR,

142: FND_API.G_MISS_CHAR,
143: oldrec.ATTRIBUTE1,
144: p_import_types_rec.ATTRIBUTE1),
145: ATTRIBUTE2 = DECODE(p_import_types_rec.ATTRIBUTE2,
146: FND_API.G_MISS_CHAR,
147: oldrec.ATTRIBUTE2,
148: p_import_types_rec.ATTRIBUTE2),
149: ATTRIBUTE3 = DECODE(p_import_types_rec.ATTRIBUTE3,
150: FND_API.G_MISS_CHAR,

Line 150: FND_API.G_MISS_CHAR,

146: FND_API.G_MISS_CHAR,
147: oldrec.ATTRIBUTE2,
148: p_import_types_rec.ATTRIBUTE2),
149: ATTRIBUTE3 = DECODE(p_import_types_rec.ATTRIBUTE3,
150: FND_API.G_MISS_CHAR,
151: oldrec.ATTRIBUTE3,
152: p_import_types_rec.ATTRIBUTE3),
153: ATTRIBUTE4 = DECODE(p_import_types_rec.ATTRIBUTE4,
154: FND_API.G_MISS_CHAR,

Line 154: FND_API.G_MISS_CHAR,

150: FND_API.G_MISS_CHAR,
151: oldrec.ATTRIBUTE3,
152: p_import_types_rec.ATTRIBUTE3),
153: ATTRIBUTE4 = DECODE(p_import_types_rec.ATTRIBUTE4,
154: FND_API.G_MISS_CHAR,
155: oldrec.ATTRIBUTE4,
156: p_import_types_rec.ATTRIBUTE4),
157: ATTRIBUTE5 = DECODE(p_import_types_rec.ATTRIBUTE5,
158: FND_API.G_MISS_CHAR,

Line 158: FND_API.G_MISS_CHAR,

154: FND_API.G_MISS_CHAR,
155: oldrec.ATTRIBUTE4,
156: p_import_types_rec.ATTRIBUTE4),
157: ATTRIBUTE5 = DECODE(p_import_types_rec.ATTRIBUTE5,
158: FND_API.G_MISS_CHAR,
159: oldrec.ATTRIBUTE5,
160: p_import_types_rec.ATTRIBUTE5),
161: ATTRIBUTE6 = DECODE(p_import_types_rec.ATTRIBUTE6,
162: FND_API.G_MISS_CHAR,

Line 162: FND_API.G_MISS_CHAR,

158: FND_API.G_MISS_CHAR,
159: oldrec.ATTRIBUTE5,
160: p_import_types_rec.ATTRIBUTE5),
161: ATTRIBUTE6 = DECODE(p_import_types_rec.ATTRIBUTE6,
162: FND_API.G_MISS_CHAR,
163: oldrec.ATTRIBUTE6,
164: p_import_types_rec.ATTRIBUTE6),
165: ATTRIBUTE7 = DECODE(p_import_types_rec.ATTRIBUTE7,
166: FND_API.G_MISS_CHAR,

Line 166: FND_API.G_MISS_CHAR,

162: FND_API.G_MISS_CHAR,
163: oldrec.ATTRIBUTE6,
164: p_import_types_rec.ATTRIBUTE6),
165: ATTRIBUTE7 = DECODE(p_import_types_rec.ATTRIBUTE7,
166: FND_API.G_MISS_CHAR,
167: oldrec.ATTRIBUTE7,
168: p_import_types_rec.ATTRIBUTE7),
169: ATTRIBUTE8 = DECODE(p_import_types_rec.ATTRIBUTE8,
170: FND_API.G_MISS_CHAR,

Line 170: FND_API.G_MISS_CHAR,

166: FND_API.G_MISS_CHAR,
167: oldrec.ATTRIBUTE7,
168: p_import_types_rec.ATTRIBUTE7),
169: ATTRIBUTE8 = DECODE(p_import_types_rec.ATTRIBUTE8,
170: FND_API.G_MISS_CHAR,
171: oldrec.ATTRIBUTE8,
172: p_import_types_rec.ATTRIBUTE8),
173: ATTRIBUTE9 = DECODE(p_import_types_rec.ATTRIBUTE9,
174: FND_API.G_MISS_CHAR,

Line 174: FND_API.G_MISS_CHAR,

170: FND_API.G_MISS_CHAR,
171: oldrec.ATTRIBUTE8,
172: p_import_types_rec.ATTRIBUTE8),
173: ATTRIBUTE9 = DECODE(p_import_types_rec.ATTRIBUTE9,
174: FND_API.G_MISS_CHAR,
175: oldrec.ATTRIBUTE9,
176: p_import_types_rec.ATTRIBUTE9),
177: ATTRIBUTE10 = DECODE(p_import_types_rec.ATTRIBUTE10,
178: FND_API.G_MISS_CHAR,

Line 178: FND_API.G_MISS_CHAR,

174: FND_API.G_MISS_CHAR,
175: oldrec.ATTRIBUTE9,
176: p_import_types_rec.ATTRIBUTE9),
177: ATTRIBUTE10 = DECODE(p_import_types_rec.ATTRIBUTE10,
178: FND_API.G_MISS_CHAR,
179: oldrec.ATTRIBUTE10,
180: p_import_types_rec.ATTRIBUTE10),
181: ATTRIBUTE11 = DECODE(p_import_types_rec.ATTRIBUTE11,
182: FND_API.G_MISS_CHAR,

Line 182: FND_API.G_MISS_CHAR,

178: FND_API.G_MISS_CHAR,
179: oldrec.ATTRIBUTE10,
180: p_import_types_rec.ATTRIBUTE10),
181: ATTRIBUTE11 = DECODE(p_import_types_rec.ATTRIBUTE11,
182: FND_API.G_MISS_CHAR,
183: oldrec.ATTRIBUTE11,
184: p_import_types_rec.ATTRIBUTE11),
185: ATTRIBUTE12 = DECODE(p_import_types_rec.ATTRIBUTE12,
186: FND_API.G_MISS_CHAR,

Line 186: FND_API.G_MISS_CHAR,

182: FND_API.G_MISS_CHAR,
183: oldrec.ATTRIBUTE11,
184: p_import_types_rec.ATTRIBUTE11),
185: ATTRIBUTE12 = DECODE(p_import_types_rec.ATTRIBUTE12,
186: FND_API.G_MISS_CHAR,
187: oldrec.ATTRIBUTE12,
188: p_import_types_rec.ATTRIBUTE12),
189: ATTRIBUTE13 = DECODE(p_import_types_rec.ATTRIBUTE13,
190: FND_API.G_MISS_CHAR,

Line 190: FND_API.G_MISS_CHAR,

186: FND_API.G_MISS_CHAR,
187: oldrec.ATTRIBUTE12,
188: p_import_types_rec.ATTRIBUTE12),
189: ATTRIBUTE13 = DECODE(p_import_types_rec.ATTRIBUTE13,
190: FND_API.G_MISS_CHAR,
191: oldrec.ATTRIBUTE13,
192: p_import_types_rec.ATTRIBUTE13),
193: ATTRIBUTE14 = DECODE(p_import_types_rec.ATTRIBUTE14,
194: FND_API.G_MISS_CHAR,

Line 194: FND_API.G_MISS_CHAR,

190: FND_API.G_MISS_CHAR,
191: oldrec.ATTRIBUTE13,
192: p_import_types_rec.ATTRIBUTE13),
193: ATTRIBUTE14 = DECODE(p_import_types_rec.ATTRIBUTE14,
194: FND_API.G_MISS_CHAR,
195: oldrec.ATTRIBUTE14,
196: p_import_types_rec.ATTRIBUTE14),
197: ATTRIBUTE15 = DECODE(p_import_types_rec.ATTRIBUTE15,
198: FND_API.G_MISS_CHAR,

Line 198: FND_API.G_MISS_CHAR,

194: FND_API.G_MISS_CHAR,
195: oldrec.ATTRIBUTE14,
196: p_import_types_rec.ATTRIBUTE14),
197: ATTRIBUTE15 = DECODE(p_import_types_rec.ATTRIBUTE15,
198: FND_API.G_MISS_CHAR,
199: oldrec.ATTRIBUTE15,
200: p_import_types_rec.ATTRIBUTE15),
201: LAST_UPDATE_DATE = Sysdate,
202: LAST_UPDATED_BY = fnd_global.user_id,

Line 241: raise fnd_api.g_exc_unexpected_error;

237: if (c%notfound) then
238: close c;
239: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
240: fnd_msg_pub.add;
241: raise fnd_api.g_exc_unexpected_error;
242: end if;
243: close c;
244:
245: if (tlinfo.object_version_number <> p_import_types_rec.object_version_number) then

Line 248: raise fnd_api.g_exc_unexpected_error;

244:
245: if (tlinfo.object_version_number <> p_import_types_rec.object_version_number) then
246: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
247: fnd_msg_pub.add;
248: raise fnd_api.g_exc_unexpected_error;
249: end if;
250: UPDATE CN_IMPORT_TYPES oldrec
251: SET
252: IMPORT_TYPE_CODE = DECODE(p_import_types_rec.IMPORT_TYPE_CODE,

Line 253: FND_API.G_MISS_CHAR,

249: end if;
250: UPDATE CN_IMPORT_TYPES oldrec
251: SET
252: IMPORT_TYPE_CODE = DECODE(p_import_types_rec.IMPORT_TYPE_CODE,
253: FND_API.G_MISS_CHAR,
254: oldrec.IMPORT_TYPE_CODE,
255: p_import_types_rec.IMPORT_TYPE_CODE),
256: VIEW_NAME = DECODE(p_import_types_rec.VIEW_NAME,
257: FND_API.G_MISS_CHAR,

Line 257: FND_API.G_MISS_CHAR,

253: FND_API.G_MISS_CHAR,
254: oldrec.IMPORT_TYPE_CODE,
255: p_import_types_rec.IMPORT_TYPE_CODE),
256: VIEW_NAME = DECODE(p_import_types_rec.VIEW_NAME,
257: FND_API.G_MISS_CHAR,
258: oldrec.VIEW_NAME,
259: p_import_types_rec.VIEW_NAME),
260: CONC_PROGRAM = DECODE(p_import_types_rec.CONC_PROGRAM,
261: FND_API.G_MISS_CHAR,

Line 261: FND_API.G_MISS_CHAR,

257: FND_API.G_MISS_CHAR,
258: oldrec.VIEW_NAME,
259: p_import_types_rec.VIEW_NAME),
260: CONC_PROGRAM = DECODE(p_import_types_rec.CONC_PROGRAM,
261: FND_API.G_MISS_CHAR,
262: oldrec.CONC_PROGRAM,
263: p_import_types_rec.CONC_PROGRAM),
264: TABLE_ID = DECODE(p_import_types_rec.TABLE_ID,
265: FND_API.G_MISS_NUM,

Line 265: FND_API.G_MISS_NUM,

261: FND_API.G_MISS_CHAR,
262: oldrec.CONC_PROGRAM,
263: p_import_types_rec.CONC_PROGRAM),
264: TABLE_ID = DECODE(p_import_types_rec.TABLE_ID,
265: FND_API.G_MISS_NUM,
266: oldrec.TABLE_ID,
267: p_import_types_rec.TABLE_ID),
268: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
269: ATTRIBUTE_CATEGORY = DECODE(p_import_types_rec.ATTRIBUTE_CATEGORY,

Line 270: FND_API.G_MISS_CHAR,

266: oldrec.TABLE_ID,
267: p_import_types_rec.TABLE_ID),
268: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
269: ATTRIBUTE_CATEGORY = DECODE(p_import_types_rec.ATTRIBUTE_CATEGORY,
270: FND_API.G_MISS_CHAR,
271: oldrec.ATTRIBUTE_CATEGORY,
272: p_import_types_rec.ATTRIBUTE_CATEGORY),
273: ATTRIBUTE1 = DECODE(p_import_types_rec.ATTRIBUTE1,
274: FND_API.G_MISS_CHAR,

Line 274: FND_API.G_MISS_CHAR,

270: FND_API.G_MISS_CHAR,
271: oldrec.ATTRIBUTE_CATEGORY,
272: p_import_types_rec.ATTRIBUTE_CATEGORY),
273: ATTRIBUTE1 = DECODE(p_import_types_rec.ATTRIBUTE1,
274: FND_API.G_MISS_CHAR,
275: oldrec.ATTRIBUTE1,
276: p_import_types_rec.ATTRIBUTE1),
277: ATTRIBUTE2 = DECODE(p_import_types_rec.ATTRIBUTE2,
278: FND_API.G_MISS_CHAR,

Line 278: FND_API.G_MISS_CHAR,

274: FND_API.G_MISS_CHAR,
275: oldrec.ATTRIBUTE1,
276: p_import_types_rec.ATTRIBUTE1),
277: ATTRIBUTE2 = DECODE(p_import_types_rec.ATTRIBUTE2,
278: FND_API.G_MISS_CHAR,
279: oldrec.ATTRIBUTE2,
280: p_import_types_rec.ATTRIBUTE2),
281: ATTRIBUTE3 = DECODE(p_import_types_rec.ATTRIBUTE3,
282: FND_API.G_MISS_CHAR,

Line 282: FND_API.G_MISS_CHAR,

278: FND_API.G_MISS_CHAR,
279: oldrec.ATTRIBUTE2,
280: p_import_types_rec.ATTRIBUTE2),
281: ATTRIBUTE3 = DECODE(p_import_types_rec.ATTRIBUTE3,
282: FND_API.G_MISS_CHAR,
283: oldrec.ATTRIBUTE3,
284: p_import_types_rec.ATTRIBUTE3),
285: ATTRIBUTE4 = DECODE(p_import_types_rec.ATTRIBUTE4,
286: FND_API.G_MISS_CHAR,

Line 286: FND_API.G_MISS_CHAR,

282: FND_API.G_MISS_CHAR,
283: oldrec.ATTRIBUTE3,
284: p_import_types_rec.ATTRIBUTE3),
285: ATTRIBUTE4 = DECODE(p_import_types_rec.ATTRIBUTE4,
286: FND_API.G_MISS_CHAR,
287: oldrec.ATTRIBUTE4,
288: p_import_types_rec.ATTRIBUTE4),
289: ATTRIBUTE5 = DECODE(p_import_types_rec.ATTRIBUTE5,
290: FND_API.G_MISS_CHAR,

Line 290: FND_API.G_MISS_CHAR,

286: FND_API.G_MISS_CHAR,
287: oldrec.ATTRIBUTE4,
288: p_import_types_rec.ATTRIBUTE4),
289: ATTRIBUTE5 = DECODE(p_import_types_rec.ATTRIBUTE5,
290: FND_API.G_MISS_CHAR,
291: oldrec.ATTRIBUTE5,
292: p_import_types_rec.ATTRIBUTE5),
293: ATTRIBUTE6 = DECODE(p_import_types_rec.ATTRIBUTE6,
294: FND_API.G_MISS_CHAR,

Line 294: FND_API.G_MISS_CHAR,

290: FND_API.G_MISS_CHAR,
291: oldrec.ATTRIBUTE5,
292: p_import_types_rec.ATTRIBUTE5),
293: ATTRIBUTE6 = DECODE(p_import_types_rec.ATTRIBUTE6,
294: FND_API.G_MISS_CHAR,
295: oldrec.ATTRIBUTE6,
296: p_import_types_rec.ATTRIBUTE6),
297: ATTRIBUTE7 = DECODE(p_import_types_rec.ATTRIBUTE7,
298: FND_API.G_MISS_CHAR,

Line 298: FND_API.G_MISS_CHAR,

294: FND_API.G_MISS_CHAR,
295: oldrec.ATTRIBUTE6,
296: p_import_types_rec.ATTRIBUTE6),
297: ATTRIBUTE7 = DECODE(p_import_types_rec.ATTRIBUTE7,
298: FND_API.G_MISS_CHAR,
299: oldrec.ATTRIBUTE7,
300: p_import_types_rec.ATTRIBUTE7),
301: ATTRIBUTE8 = DECODE(p_import_types_rec.ATTRIBUTE8,
302: FND_API.G_MISS_CHAR,

Line 302: FND_API.G_MISS_CHAR,

298: FND_API.G_MISS_CHAR,
299: oldrec.ATTRIBUTE7,
300: p_import_types_rec.ATTRIBUTE7),
301: ATTRIBUTE8 = DECODE(p_import_types_rec.ATTRIBUTE8,
302: FND_API.G_MISS_CHAR,
303: oldrec.ATTRIBUTE8,
304: p_import_types_rec.ATTRIBUTE8),
305: ATTRIBUTE9 = DECODE(p_import_types_rec.ATTRIBUTE9,
306: FND_API.G_MISS_CHAR,

Line 306: FND_API.G_MISS_CHAR,

302: FND_API.G_MISS_CHAR,
303: oldrec.ATTRIBUTE8,
304: p_import_types_rec.ATTRIBUTE8),
305: ATTRIBUTE9 = DECODE(p_import_types_rec.ATTRIBUTE9,
306: FND_API.G_MISS_CHAR,
307: oldrec.ATTRIBUTE9,
308: p_import_types_rec.ATTRIBUTE9),
309: ATTRIBUTE10 = DECODE(p_import_types_rec.ATTRIBUTE10,
310: FND_API.G_MISS_CHAR,

Line 310: FND_API.G_MISS_CHAR,

306: FND_API.G_MISS_CHAR,
307: oldrec.ATTRIBUTE9,
308: p_import_types_rec.ATTRIBUTE9),
309: ATTRIBUTE10 = DECODE(p_import_types_rec.ATTRIBUTE10,
310: FND_API.G_MISS_CHAR,
311: oldrec.ATTRIBUTE10,
312: p_import_types_rec.ATTRIBUTE10),
313: ATTRIBUTE11 = DECODE(p_import_types_rec.ATTRIBUTE11,
314: FND_API.G_MISS_CHAR,

Line 314: FND_API.G_MISS_CHAR,

310: FND_API.G_MISS_CHAR,
311: oldrec.ATTRIBUTE10,
312: p_import_types_rec.ATTRIBUTE10),
313: ATTRIBUTE11 = DECODE(p_import_types_rec.ATTRIBUTE11,
314: FND_API.G_MISS_CHAR,
315: oldrec.ATTRIBUTE11,
316: p_import_types_rec.ATTRIBUTE11),
317: ATTRIBUTE12 = DECODE(p_import_types_rec.ATTRIBUTE12,
318: FND_API.G_MISS_CHAR,

Line 318: FND_API.G_MISS_CHAR,

314: FND_API.G_MISS_CHAR,
315: oldrec.ATTRIBUTE11,
316: p_import_types_rec.ATTRIBUTE11),
317: ATTRIBUTE12 = DECODE(p_import_types_rec.ATTRIBUTE12,
318: FND_API.G_MISS_CHAR,
319: oldrec.ATTRIBUTE12,
320: p_import_types_rec.ATTRIBUTE12),
321: ATTRIBUTE13 = DECODE(p_import_types_rec.ATTRIBUTE13,
322: FND_API.G_MISS_CHAR,

Line 322: FND_API.G_MISS_CHAR,

318: FND_API.G_MISS_CHAR,
319: oldrec.ATTRIBUTE12,
320: p_import_types_rec.ATTRIBUTE12),
321: ATTRIBUTE13 = DECODE(p_import_types_rec.ATTRIBUTE13,
322: FND_API.G_MISS_CHAR,
323: oldrec.ATTRIBUTE13,
324: p_import_types_rec.ATTRIBUTE13),
325: ATTRIBUTE14 = DECODE(p_import_types_rec.ATTRIBUTE14,
326: FND_API.G_MISS_CHAR,

Line 326: FND_API.G_MISS_CHAR,

322: FND_API.G_MISS_CHAR,
323: oldrec.ATTRIBUTE13,
324: p_import_types_rec.ATTRIBUTE13),
325: ATTRIBUTE14 = DECODE(p_import_types_rec.ATTRIBUTE14,
326: FND_API.G_MISS_CHAR,
327: oldrec.ATTRIBUTE14,
328: p_import_types_rec.ATTRIBUTE14),
329: ATTRIBUTE15 = DECODE(p_import_types_rec.ATTRIBUTE15,
330: FND_API.G_MISS_CHAR,

Line 330: FND_API.G_MISS_CHAR,

326: FND_API.G_MISS_CHAR,
327: oldrec.ATTRIBUTE14,
328: p_import_types_rec.ATTRIBUTE14),
329: ATTRIBUTE15 = DECODE(p_import_types_rec.ATTRIBUTE15,
330: FND_API.G_MISS_CHAR,
331: oldrec.ATTRIBUTE15,
332: p_import_types_rec.ATTRIBUTE15),
333: LAST_UPDATE_DATE = Sysdate,
334: LAST_UPDATED_BY = fnd_global.user_id,