eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_IMP_HEADERS_PKG dependencies on FND_API

Line 61: DECODE(p_imp_headers_rec.IMP_HEADER_ID, FND_API.G_MISS_NUM, NULL,

57: LAST_UPDATE_DATE,
58: LAST_UPDATED_BY,
59: LAST_UPDATE_LOGIN)
60: select
61: DECODE(p_imp_headers_rec.IMP_HEADER_ID, FND_API.G_MISS_NUM, NULL,
62: p_imp_headers_rec.IMP_HEADER_ID),
63: DECODE(p_imp_headers_rec.NAME, FND_API.G_MISS_CHAR, NULL,
64: p_imp_headers_rec.NAME),
65: DECODE(p_imp_headers_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,

Line 63: DECODE(p_imp_headers_rec.NAME, FND_API.G_MISS_CHAR, NULL,

59: LAST_UPDATE_LOGIN)
60: select
61: DECODE(p_imp_headers_rec.IMP_HEADER_ID, FND_API.G_MISS_NUM, NULL,
62: p_imp_headers_rec.IMP_HEADER_ID),
63: DECODE(p_imp_headers_rec.NAME, FND_API.G_MISS_CHAR, NULL,
64: p_imp_headers_rec.NAME),
65: DECODE(p_imp_headers_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
66: p_imp_headers_rec.DESCRIPTION),
67: DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,

Line 65: DECODE(p_imp_headers_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,

61: DECODE(p_imp_headers_rec.IMP_HEADER_ID, FND_API.G_MISS_NUM, NULL,
62: p_imp_headers_rec.IMP_HEADER_ID),
63: DECODE(p_imp_headers_rec.NAME, FND_API.G_MISS_CHAR, NULL,
64: p_imp_headers_rec.NAME),
65: DECODE(p_imp_headers_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
66: p_imp_headers_rec.DESCRIPTION),
67: DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,
68: p_imp_headers_rec.IMPORT_TYPE_CODE),
69: DECODE(p_imp_headers_rec.OPERATION, FND_API.G_MISS_CHAR, NULL,

Line 67: DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,

63: DECODE(p_imp_headers_rec.NAME, FND_API.G_MISS_CHAR, NULL,
64: p_imp_headers_rec.NAME),
65: DECODE(p_imp_headers_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
66: p_imp_headers_rec.DESCRIPTION),
67: DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,
68: p_imp_headers_rec.IMPORT_TYPE_CODE),
69: DECODE(p_imp_headers_rec.OPERATION, FND_API.G_MISS_CHAR, NULL,
70: p_imp_headers_rec.OPERATION),
71: DECODE(p_imp_headers_rec.SERVER_FLAG, FND_API.G_MISS_CHAR, NULL,

Line 69: DECODE(p_imp_headers_rec.OPERATION, FND_API.G_MISS_CHAR, NULL,

65: DECODE(p_imp_headers_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
66: p_imp_headers_rec.DESCRIPTION),
67: DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,
68: p_imp_headers_rec.IMPORT_TYPE_CODE),
69: DECODE(p_imp_headers_rec.OPERATION, FND_API.G_MISS_CHAR, NULL,
70: p_imp_headers_rec.OPERATION),
71: DECODE(p_imp_headers_rec.SERVER_FLAG, FND_API.G_MISS_CHAR, NULL,
72: p_imp_headers_rec.SERVER_FLAG),
73: DECODE(p_imp_headers_rec.USER_FILENAME, FND_API.G_MISS_CHAR, NULL,

Line 71: DECODE(p_imp_headers_rec.SERVER_FLAG, FND_API.G_MISS_CHAR, NULL,

67: DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,
68: p_imp_headers_rec.IMPORT_TYPE_CODE),
69: DECODE(p_imp_headers_rec.OPERATION, FND_API.G_MISS_CHAR, NULL,
70: p_imp_headers_rec.OPERATION),
71: DECODE(p_imp_headers_rec.SERVER_FLAG, FND_API.G_MISS_CHAR, NULL,
72: p_imp_headers_rec.SERVER_FLAG),
73: DECODE(p_imp_headers_rec.USER_FILENAME, FND_API.G_MISS_CHAR, NULL,
74: p_imp_headers_rec.USER_FILENAME),
75: DECODE(p_imp_headers_rec.DATA_FILENAME, FND_API.G_MISS_CHAR, NULL,

Line 73: DECODE(p_imp_headers_rec.USER_FILENAME, FND_API.G_MISS_CHAR, NULL,

69: DECODE(p_imp_headers_rec.OPERATION, FND_API.G_MISS_CHAR, NULL,
70: p_imp_headers_rec.OPERATION),
71: DECODE(p_imp_headers_rec.SERVER_FLAG, FND_API.G_MISS_CHAR, NULL,
72: p_imp_headers_rec.SERVER_FLAG),
73: DECODE(p_imp_headers_rec.USER_FILENAME, FND_API.G_MISS_CHAR, NULL,
74: p_imp_headers_rec.USER_FILENAME),
75: DECODE(p_imp_headers_rec.DATA_FILENAME, FND_API.G_MISS_CHAR, NULL,
76: p_imp_headers_rec.DATA_FILENAME),
77: DECODE(p_imp_headers_rec.TERMINATED_BY, FND_API.G_MISS_CHAR, NULL,

Line 75: DECODE(p_imp_headers_rec.DATA_FILENAME, FND_API.G_MISS_CHAR, NULL,

71: DECODE(p_imp_headers_rec.SERVER_FLAG, FND_API.G_MISS_CHAR, NULL,
72: p_imp_headers_rec.SERVER_FLAG),
73: DECODE(p_imp_headers_rec.USER_FILENAME, FND_API.G_MISS_CHAR, NULL,
74: p_imp_headers_rec.USER_FILENAME),
75: DECODE(p_imp_headers_rec.DATA_FILENAME, FND_API.G_MISS_CHAR, NULL,
76: p_imp_headers_rec.DATA_FILENAME),
77: DECODE(p_imp_headers_rec.TERMINATED_BY, FND_API.G_MISS_CHAR, NULL,
78: p_imp_headers_rec.TERMINATED_BY),
79: DECODE(p_imp_headers_rec.ENCLOSED_BY, FND_API.G_MISS_CHAR, NULL,

Line 77: DECODE(p_imp_headers_rec.TERMINATED_BY, FND_API.G_MISS_CHAR, NULL,

73: DECODE(p_imp_headers_rec.USER_FILENAME, FND_API.G_MISS_CHAR, NULL,
74: p_imp_headers_rec.USER_FILENAME),
75: DECODE(p_imp_headers_rec.DATA_FILENAME, FND_API.G_MISS_CHAR, NULL,
76: p_imp_headers_rec.DATA_FILENAME),
77: DECODE(p_imp_headers_rec.TERMINATED_BY, FND_API.G_MISS_CHAR, NULL,
78: p_imp_headers_rec.TERMINATED_BY),
79: DECODE(p_imp_headers_rec.ENCLOSED_BY, FND_API.G_MISS_CHAR, NULL,
80: p_imp_headers_rec.ENCLOSED_BY),
81: DECODE(p_imp_headers_rec.HEADINGS_FLAG, FND_API.G_MISS_CHAR, NULL,

Line 79: DECODE(p_imp_headers_rec.ENCLOSED_BY, FND_API.G_MISS_CHAR, NULL,

75: DECODE(p_imp_headers_rec.DATA_FILENAME, FND_API.G_MISS_CHAR, NULL,
76: p_imp_headers_rec.DATA_FILENAME),
77: DECODE(p_imp_headers_rec.TERMINATED_BY, FND_API.G_MISS_CHAR, NULL,
78: p_imp_headers_rec.TERMINATED_BY),
79: DECODE(p_imp_headers_rec.ENCLOSED_BY, FND_API.G_MISS_CHAR, NULL,
80: p_imp_headers_rec.ENCLOSED_BY),
81: DECODE(p_imp_headers_rec.HEADINGS_FLAG, FND_API.G_MISS_CHAR, NULL,
82: p_imp_headers_rec.HEADINGS_FLAG),
83: DECODE(p_imp_headers_rec.STAGED_ROW, FND_API.G_MISS_NUM, NULL,

Line 81: DECODE(p_imp_headers_rec.HEADINGS_FLAG, FND_API.G_MISS_CHAR, NULL,

77: DECODE(p_imp_headers_rec.TERMINATED_BY, FND_API.G_MISS_CHAR, NULL,
78: p_imp_headers_rec.TERMINATED_BY),
79: DECODE(p_imp_headers_rec.ENCLOSED_BY, FND_API.G_MISS_CHAR, NULL,
80: p_imp_headers_rec.ENCLOSED_BY),
81: DECODE(p_imp_headers_rec.HEADINGS_FLAG, FND_API.G_MISS_CHAR, NULL,
82: p_imp_headers_rec.HEADINGS_FLAG),
83: DECODE(p_imp_headers_rec.STAGED_ROW, FND_API.G_MISS_NUM, NULL,
84: p_imp_headers_rec.STAGED_ROW),
85: DECODE(p_imp_headers_rec.PROCESSED_ROW, FND_API.G_MISS_NUM, NULL,

Line 83: DECODE(p_imp_headers_rec.STAGED_ROW, FND_API.G_MISS_NUM, NULL,

79: DECODE(p_imp_headers_rec.ENCLOSED_BY, FND_API.G_MISS_CHAR, NULL,
80: p_imp_headers_rec.ENCLOSED_BY),
81: DECODE(p_imp_headers_rec.HEADINGS_FLAG, FND_API.G_MISS_CHAR, NULL,
82: p_imp_headers_rec.HEADINGS_FLAG),
83: DECODE(p_imp_headers_rec.STAGED_ROW, FND_API.G_MISS_NUM, NULL,
84: p_imp_headers_rec.STAGED_ROW),
85: DECODE(p_imp_headers_rec.PROCESSED_ROW, FND_API.G_MISS_NUM, NULL,
86: p_imp_headers_rec.PROCESSED_ROW),
87: DECODE(p_imp_headers_rec.FAILED_ROW, FND_API.G_MISS_NUM, NULL,

Line 85: DECODE(p_imp_headers_rec.PROCESSED_ROW, FND_API.G_MISS_NUM, NULL,

81: DECODE(p_imp_headers_rec.HEADINGS_FLAG, FND_API.G_MISS_CHAR, NULL,
82: p_imp_headers_rec.HEADINGS_FLAG),
83: DECODE(p_imp_headers_rec.STAGED_ROW, FND_API.G_MISS_NUM, NULL,
84: p_imp_headers_rec.STAGED_ROW),
85: DECODE(p_imp_headers_rec.PROCESSED_ROW, FND_API.G_MISS_NUM, NULL,
86: p_imp_headers_rec.PROCESSED_ROW),
87: DECODE(p_imp_headers_rec.FAILED_ROW, FND_API.G_MISS_NUM, NULL,
88: p_imp_headers_rec.FAILED_ROW),
89: DECODE(p_imp_headers_rec.STATUS_CODE, FND_API.G_MISS_CHAR, NULL,

Line 87: DECODE(p_imp_headers_rec.FAILED_ROW, FND_API.G_MISS_NUM, NULL,

83: DECODE(p_imp_headers_rec.STAGED_ROW, FND_API.G_MISS_NUM, NULL,
84: p_imp_headers_rec.STAGED_ROW),
85: DECODE(p_imp_headers_rec.PROCESSED_ROW, FND_API.G_MISS_NUM, NULL,
86: p_imp_headers_rec.PROCESSED_ROW),
87: DECODE(p_imp_headers_rec.FAILED_ROW, FND_API.G_MISS_NUM, NULL,
88: p_imp_headers_rec.FAILED_ROW),
89: DECODE(p_imp_headers_rec.STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
90: p_imp_headers_rec.STATUS_CODE),
91: DECODE(p_imp_headers_rec.IMP_MAP_ID, FND_API.G_MISS_NUM, NULL,

Line 89: DECODE(p_imp_headers_rec.STATUS_CODE, FND_API.G_MISS_CHAR, NULL,

85: DECODE(p_imp_headers_rec.PROCESSED_ROW, FND_API.G_MISS_NUM, NULL,
86: p_imp_headers_rec.PROCESSED_ROW),
87: DECODE(p_imp_headers_rec.FAILED_ROW, FND_API.G_MISS_NUM, NULL,
88: p_imp_headers_rec.FAILED_ROW),
89: DECODE(p_imp_headers_rec.STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
90: p_imp_headers_rec.STATUS_CODE),
91: DECODE(p_imp_headers_rec.IMP_MAP_ID, FND_API.G_MISS_NUM, NULL,
92: p_imp_headers_rec.IMP_MAP_ID),
93: DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM, FND_API.G_MISS_NUM, NULL,

Line 91: DECODE(p_imp_headers_rec.IMP_MAP_ID, FND_API.G_MISS_NUM, NULL,

87: DECODE(p_imp_headers_rec.FAILED_ROW, FND_API.G_MISS_NUM, NULL,
88: p_imp_headers_rec.FAILED_ROW),
89: DECODE(p_imp_headers_rec.STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
90: p_imp_headers_rec.STATUS_CODE),
91: DECODE(p_imp_headers_rec.IMP_MAP_ID, FND_API.G_MISS_NUM, NULL,
92: p_imp_headers_rec.IMP_MAP_ID),
93: DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM, FND_API.G_MISS_NUM, NULL,
94: p_imp_headers_rec.SOURCE_COLUMN_NUM),
95: 1,

Line 93: DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM, FND_API.G_MISS_NUM, NULL,

89: DECODE(p_imp_headers_rec.STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
90: p_imp_headers_rec.STATUS_CODE),
91: DECODE(p_imp_headers_rec.IMP_MAP_ID, FND_API.G_MISS_NUM, NULL,
92: p_imp_headers_rec.IMP_MAP_ID),
93: DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM, FND_API.G_MISS_NUM, NULL,
94: p_imp_headers_rec.SOURCE_COLUMN_NUM),
95: 1,
96: DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
97: p_imp_headers_rec.ATTRIBUTE_CATEGORY),

Line 96: DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

92: p_imp_headers_rec.IMP_MAP_ID),
93: DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM, FND_API.G_MISS_NUM, NULL,
94: p_imp_headers_rec.SOURCE_COLUMN_NUM),
95: 1,
96: DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
97: p_imp_headers_rec.ATTRIBUTE_CATEGORY),
98: DECODE(p_imp_headers_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
99: p_imp_headers_rec.ATTRIBUTE1),
100: DECODE(p_imp_headers_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

Line 98: DECODE(p_imp_headers_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,

94: p_imp_headers_rec.SOURCE_COLUMN_NUM),
95: 1,
96: DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
97: p_imp_headers_rec.ATTRIBUTE_CATEGORY),
98: DECODE(p_imp_headers_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
99: p_imp_headers_rec.ATTRIBUTE1),
100: DECODE(p_imp_headers_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
101: p_imp_headers_rec.ATTRIBUTE2),
102: DECODE(p_imp_headers_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

Line 100: DECODE(p_imp_headers_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

96: DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
97: p_imp_headers_rec.ATTRIBUTE_CATEGORY),
98: DECODE(p_imp_headers_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
99: p_imp_headers_rec.ATTRIBUTE1),
100: DECODE(p_imp_headers_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
101: p_imp_headers_rec.ATTRIBUTE2),
102: DECODE(p_imp_headers_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
103: p_imp_headers_rec.ATTRIBUTE3),
104: DECODE(p_imp_headers_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

Line 102: DECODE(p_imp_headers_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

98: DECODE(p_imp_headers_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
99: p_imp_headers_rec.ATTRIBUTE1),
100: DECODE(p_imp_headers_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
101: p_imp_headers_rec.ATTRIBUTE2),
102: DECODE(p_imp_headers_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
103: p_imp_headers_rec.ATTRIBUTE3),
104: DECODE(p_imp_headers_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
105: p_imp_headers_rec.ATTRIBUTE4),
106: DECODE(p_imp_headers_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

Line 104: DECODE(p_imp_headers_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

100: DECODE(p_imp_headers_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
101: p_imp_headers_rec.ATTRIBUTE2),
102: DECODE(p_imp_headers_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
103: p_imp_headers_rec.ATTRIBUTE3),
104: DECODE(p_imp_headers_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
105: p_imp_headers_rec.ATTRIBUTE4),
106: DECODE(p_imp_headers_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
107: p_imp_headers_rec.ATTRIBUTE5),
108: DECODE(p_imp_headers_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

Line 106: DECODE(p_imp_headers_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

102: DECODE(p_imp_headers_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
103: p_imp_headers_rec.ATTRIBUTE3),
104: DECODE(p_imp_headers_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
105: p_imp_headers_rec.ATTRIBUTE4),
106: DECODE(p_imp_headers_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
107: p_imp_headers_rec.ATTRIBUTE5),
108: DECODE(p_imp_headers_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
109: p_imp_headers_rec.ATTRIBUTE6),
110: DECODE(p_imp_headers_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

Line 108: DECODE(p_imp_headers_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

104: DECODE(p_imp_headers_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
105: p_imp_headers_rec.ATTRIBUTE4),
106: DECODE(p_imp_headers_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
107: p_imp_headers_rec.ATTRIBUTE5),
108: DECODE(p_imp_headers_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
109: p_imp_headers_rec.ATTRIBUTE6),
110: DECODE(p_imp_headers_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
111: p_imp_headers_rec.ATTRIBUTE7),
112: DECODE(p_imp_headers_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

Line 110: DECODE(p_imp_headers_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

106: DECODE(p_imp_headers_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
107: p_imp_headers_rec.ATTRIBUTE5),
108: DECODE(p_imp_headers_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
109: p_imp_headers_rec.ATTRIBUTE6),
110: DECODE(p_imp_headers_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
111: p_imp_headers_rec.ATTRIBUTE7),
112: DECODE(p_imp_headers_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
113: p_imp_headers_rec.ATTRIBUTE8),
114: DECODE(p_imp_headers_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

Line 112: DECODE(p_imp_headers_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

108: DECODE(p_imp_headers_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
109: p_imp_headers_rec.ATTRIBUTE6),
110: DECODE(p_imp_headers_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
111: p_imp_headers_rec.ATTRIBUTE7),
112: DECODE(p_imp_headers_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
113: p_imp_headers_rec.ATTRIBUTE8),
114: DECODE(p_imp_headers_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
115: p_imp_headers_rec.ATTRIBUTE9),
116: DECODE(p_imp_headers_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

Line 114: DECODE(p_imp_headers_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

110: DECODE(p_imp_headers_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
111: p_imp_headers_rec.ATTRIBUTE7),
112: DECODE(p_imp_headers_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
113: p_imp_headers_rec.ATTRIBUTE8),
114: DECODE(p_imp_headers_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
115: p_imp_headers_rec.ATTRIBUTE9),
116: DECODE(p_imp_headers_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
117: p_imp_headers_rec.ATTRIBUTE10),
118: DECODE(p_imp_headers_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

Line 116: DECODE(p_imp_headers_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

112: DECODE(p_imp_headers_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
113: p_imp_headers_rec.ATTRIBUTE8),
114: DECODE(p_imp_headers_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
115: p_imp_headers_rec.ATTRIBUTE9),
116: DECODE(p_imp_headers_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
117: p_imp_headers_rec.ATTRIBUTE10),
118: DECODE(p_imp_headers_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
119: p_imp_headers_rec.ATTRIBUTE11),
120: DECODE(p_imp_headers_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

Line 118: DECODE(p_imp_headers_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

114: DECODE(p_imp_headers_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
115: p_imp_headers_rec.ATTRIBUTE9),
116: DECODE(p_imp_headers_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
117: p_imp_headers_rec.ATTRIBUTE10),
118: DECODE(p_imp_headers_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
119: p_imp_headers_rec.ATTRIBUTE11),
120: DECODE(p_imp_headers_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
121: p_imp_headers_rec.ATTRIBUTE12),
122: DECODE(p_imp_headers_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

Line 120: DECODE(p_imp_headers_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

116: DECODE(p_imp_headers_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
117: p_imp_headers_rec.ATTRIBUTE10),
118: DECODE(p_imp_headers_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
119: p_imp_headers_rec.ATTRIBUTE11),
120: DECODE(p_imp_headers_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
121: p_imp_headers_rec.ATTRIBUTE12),
122: DECODE(p_imp_headers_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
123: p_imp_headers_rec.ATTRIBUTE13),
124: DECODE(p_imp_headers_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

Line 122: DECODE(p_imp_headers_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

118: DECODE(p_imp_headers_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
119: p_imp_headers_rec.ATTRIBUTE11),
120: DECODE(p_imp_headers_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
121: p_imp_headers_rec.ATTRIBUTE12),
122: DECODE(p_imp_headers_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
123: p_imp_headers_rec.ATTRIBUTE13),
124: DECODE(p_imp_headers_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
125: p_imp_headers_rec.ATTRIBUTE14),
126: DECODE(p_imp_headers_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

Line 124: DECODE(p_imp_headers_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

120: DECODE(p_imp_headers_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
121: p_imp_headers_rec.ATTRIBUTE12),
122: DECODE(p_imp_headers_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
123: p_imp_headers_rec.ATTRIBUTE13),
124: DECODE(p_imp_headers_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
125: p_imp_headers_rec.ATTRIBUTE14),
126: DECODE(p_imp_headers_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
127: p_imp_headers_rec.ATTRIBUTE15),
128: Sysdate,

Line 126: DECODE(p_imp_headers_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

122: DECODE(p_imp_headers_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
123: p_imp_headers_rec.ATTRIBUTE13),
124: DECODE(p_imp_headers_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
125: p_imp_headers_rec.ATTRIBUTE14),
126: DECODE(p_imp_headers_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
127: p_imp_headers_rec.ATTRIBUTE15),
128: Sysdate,
129: fnd_global.user_id,
130: Sysdate,

Line 157: FND_API.G_MISS_CHAR,

153:
154: UPDATE CN_IMP_HEADERS oldrec
155: SET
156: NAME = DECODE(p_imp_headers_rec.NAME,
157: FND_API.G_MISS_CHAR,
158: oldrec.NAME,
159: p_imp_headers_rec.NAME),
160: DESCRIPTION = DECODE(p_imp_headers_rec.DESCRIPTION,
161: FND_API.G_MISS_CHAR,

Line 161: FND_API.G_MISS_CHAR,

157: FND_API.G_MISS_CHAR,
158: oldrec.NAME,
159: p_imp_headers_rec.NAME),
160: DESCRIPTION = DECODE(p_imp_headers_rec.DESCRIPTION,
161: FND_API.G_MISS_CHAR,
162: oldrec.DESCRIPTION,
163: p_imp_headers_rec.DESCRIPTION),
164: IMPORT_TYPE_CODE = DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE,
165: FND_API.G_MISS_CHAR,

Line 165: FND_API.G_MISS_CHAR,

161: FND_API.G_MISS_CHAR,
162: oldrec.DESCRIPTION,
163: p_imp_headers_rec.DESCRIPTION),
164: IMPORT_TYPE_CODE = DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE,
165: FND_API.G_MISS_CHAR,
166: oldrec.IMPORT_TYPE_CODE,
167: p_imp_headers_rec.IMPORT_TYPE_CODE),
168: OPERATION = DECODE(p_imp_headers_rec.OPERATION,
169: FND_API.G_MISS_CHAR,

Line 169: FND_API.G_MISS_CHAR,

165: FND_API.G_MISS_CHAR,
166: oldrec.IMPORT_TYPE_CODE,
167: p_imp_headers_rec.IMPORT_TYPE_CODE),
168: OPERATION = DECODE(p_imp_headers_rec.OPERATION,
169: FND_API.G_MISS_CHAR,
170: oldrec.OPERATION,
171: p_imp_headers_rec.OPERATION),
172: SERVER_FLAG = DECODE(p_imp_headers_rec.SERVER_FLAG,
173: FND_API.G_MISS_CHAR,

Line 173: FND_API.G_MISS_CHAR,

169: FND_API.G_MISS_CHAR,
170: oldrec.OPERATION,
171: p_imp_headers_rec.OPERATION),
172: SERVER_FLAG = DECODE(p_imp_headers_rec.SERVER_FLAG,
173: FND_API.G_MISS_CHAR,
174: oldrec.SERVER_FLAG,
175: p_imp_headers_rec.SERVER_FLAG),
176: USER_FILENAME = DECODE(p_imp_headers_rec.USER_FILENAME,
177: FND_API.G_MISS_CHAR,

Line 177: FND_API.G_MISS_CHAR,

173: FND_API.G_MISS_CHAR,
174: oldrec.SERVER_FLAG,
175: p_imp_headers_rec.SERVER_FLAG),
176: USER_FILENAME = DECODE(p_imp_headers_rec.USER_FILENAME,
177: FND_API.G_MISS_CHAR,
178: oldrec.USER_FILENAME,
179: p_imp_headers_rec.USER_FILENAME),
180: DATA_FILENAME = DECODE(p_imp_headers_rec.DATA_FILENAME,
181: FND_API.G_MISS_CHAR,

Line 181: FND_API.G_MISS_CHAR,

177: FND_API.G_MISS_CHAR,
178: oldrec.USER_FILENAME,
179: p_imp_headers_rec.USER_FILENAME),
180: DATA_FILENAME = DECODE(p_imp_headers_rec.DATA_FILENAME,
181: FND_API.G_MISS_CHAR,
182: oldrec.DATA_FILENAME,
183: p_imp_headers_rec.DATA_FILENAME),
184: TERMINATED_BY = DECODE(p_imp_headers_rec.TERMINATED_BY,
185: FND_API.G_MISS_CHAR,

Line 185: FND_API.G_MISS_CHAR,

181: FND_API.G_MISS_CHAR,
182: oldrec.DATA_FILENAME,
183: p_imp_headers_rec.DATA_FILENAME),
184: TERMINATED_BY = DECODE(p_imp_headers_rec.TERMINATED_BY,
185: FND_API.G_MISS_CHAR,
186: oldrec.TERMINATED_BY,
187: p_imp_headers_rec.TERMINATED_BY),
188: ENCLOSED_BY = DECODE(p_imp_headers_rec.ENCLOSED_BY,
189: FND_API.G_MISS_CHAR,

Line 189: FND_API.G_MISS_CHAR,

185: FND_API.G_MISS_CHAR,
186: oldrec.TERMINATED_BY,
187: p_imp_headers_rec.TERMINATED_BY),
188: ENCLOSED_BY = DECODE(p_imp_headers_rec.ENCLOSED_BY,
189: FND_API.G_MISS_CHAR,
190: oldrec.ENCLOSED_BY,
191: p_imp_headers_rec.ENCLOSED_BY),
192: HEADINGS_FLAG = DECODE(p_imp_headers_rec.HEADINGS_FLAG,
193: FND_API.G_MISS_CHAR,

Line 193: FND_API.G_MISS_CHAR,

189: FND_API.G_MISS_CHAR,
190: oldrec.ENCLOSED_BY,
191: p_imp_headers_rec.ENCLOSED_BY),
192: HEADINGS_FLAG = DECODE(p_imp_headers_rec.HEADINGS_FLAG,
193: FND_API.G_MISS_CHAR,
194: oldrec.HEADINGS_FLAG,
195: p_imp_headers_rec.HEADINGS_FLAG),
196: STAGED_ROW = DECODE(p_imp_headers_rec.STAGED_ROW,
197: FND_API.G_MISS_NUM,

Line 197: FND_API.G_MISS_NUM,

193: FND_API.G_MISS_CHAR,
194: oldrec.HEADINGS_FLAG,
195: p_imp_headers_rec.HEADINGS_FLAG),
196: STAGED_ROW = DECODE(p_imp_headers_rec.STAGED_ROW,
197: FND_API.G_MISS_NUM,
198: oldrec.STAGED_ROW,
199: p_imp_headers_rec.STAGED_ROW),
200: PROCESSED_ROW = DECODE(p_imp_headers_rec.PROCESSED_ROW,
201: FND_API.G_MISS_NUM,

Line 201: FND_API.G_MISS_NUM,

197: FND_API.G_MISS_NUM,
198: oldrec.STAGED_ROW,
199: p_imp_headers_rec.STAGED_ROW),
200: PROCESSED_ROW = DECODE(p_imp_headers_rec.PROCESSED_ROW,
201: FND_API.G_MISS_NUM,
202: oldrec.PROCESSED_ROW,
203: p_imp_headers_rec.PROCESSED_ROW),
204: FAILED_ROW = DECODE(p_imp_headers_rec.FAILED_ROW,
205: FND_API.G_MISS_NUM,

Line 205: FND_API.G_MISS_NUM,

201: FND_API.G_MISS_NUM,
202: oldrec.PROCESSED_ROW,
203: p_imp_headers_rec.PROCESSED_ROW),
204: FAILED_ROW = DECODE(p_imp_headers_rec.FAILED_ROW,
205: FND_API.G_MISS_NUM,
206: oldrec.FAILED_ROW,
207: p_imp_headers_rec.FAILED_ROW),
208: STATUS_CODE = DECODE(p_imp_headers_rec.STATUS_CODE,
209: FND_API.G_MISS_CHAR,

Line 209: FND_API.G_MISS_CHAR,

205: FND_API.G_MISS_NUM,
206: oldrec.FAILED_ROW,
207: p_imp_headers_rec.FAILED_ROW),
208: STATUS_CODE = DECODE(p_imp_headers_rec.STATUS_CODE,
209: FND_API.G_MISS_CHAR,
210: oldrec.STATUS_CODE,
211: p_imp_headers_rec.STATUS_CODE),
212: IMP_MAP_ID = DECODE(p_imp_headers_rec.IMP_MAP_ID,
213: FND_API.G_MISS_NUM,

Line 213: FND_API.G_MISS_NUM,

209: FND_API.G_MISS_CHAR,
210: oldrec.STATUS_CODE,
211: p_imp_headers_rec.STATUS_CODE),
212: IMP_MAP_ID = DECODE(p_imp_headers_rec.IMP_MAP_ID,
213: FND_API.G_MISS_NUM,
214: oldrec.IMP_MAP_ID,
215: p_imp_headers_rec.IMP_MAP_ID),
216: SOURCE_COLUMN_NUM = DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM,
217: FND_API.G_MISS_NUM,

Line 217: FND_API.G_MISS_NUM,

213: FND_API.G_MISS_NUM,
214: oldrec.IMP_MAP_ID,
215: p_imp_headers_rec.IMP_MAP_ID),
216: SOURCE_COLUMN_NUM = DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM,
217: FND_API.G_MISS_NUM,
218: oldrec.SOURCE_COLUMN_NUM,
219: p_imp_headers_rec.SOURCE_COLUMN_NUM),
220: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
221: ATTRIBUTE_CATEGORY = DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY,

Line 222: FND_API.G_MISS_CHAR,

218: oldrec.SOURCE_COLUMN_NUM,
219: p_imp_headers_rec.SOURCE_COLUMN_NUM),
220: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
221: ATTRIBUTE_CATEGORY = DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY,
222: FND_API.G_MISS_CHAR,
223: oldrec.ATTRIBUTE_CATEGORY,
224: p_imp_headers_rec.ATTRIBUTE_CATEGORY),
225: ATTRIBUTE1 = DECODE(p_imp_headers_rec.ATTRIBUTE1,
226: FND_API.G_MISS_CHAR,

Line 226: FND_API.G_MISS_CHAR,

222: FND_API.G_MISS_CHAR,
223: oldrec.ATTRIBUTE_CATEGORY,
224: p_imp_headers_rec.ATTRIBUTE_CATEGORY),
225: ATTRIBUTE1 = DECODE(p_imp_headers_rec.ATTRIBUTE1,
226: FND_API.G_MISS_CHAR,
227: oldrec.ATTRIBUTE1,
228: p_imp_headers_rec.ATTRIBUTE1),
229: ATTRIBUTE2 = DECODE(p_imp_headers_rec.ATTRIBUTE2,
230: FND_API.G_MISS_CHAR,

Line 230: FND_API.G_MISS_CHAR,

226: FND_API.G_MISS_CHAR,
227: oldrec.ATTRIBUTE1,
228: p_imp_headers_rec.ATTRIBUTE1),
229: ATTRIBUTE2 = DECODE(p_imp_headers_rec.ATTRIBUTE2,
230: FND_API.G_MISS_CHAR,
231: oldrec.ATTRIBUTE2,
232: p_imp_headers_rec.ATTRIBUTE2),
233: ATTRIBUTE3 = DECODE(p_imp_headers_rec.ATTRIBUTE3,
234: FND_API.G_MISS_CHAR,

Line 234: FND_API.G_MISS_CHAR,

230: FND_API.G_MISS_CHAR,
231: oldrec.ATTRIBUTE2,
232: p_imp_headers_rec.ATTRIBUTE2),
233: ATTRIBUTE3 = DECODE(p_imp_headers_rec.ATTRIBUTE3,
234: FND_API.G_MISS_CHAR,
235: oldrec.ATTRIBUTE3,
236: p_imp_headers_rec.ATTRIBUTE3),
237: ATTRIBUTE4 = DECODE(p_imp_headers_rec.ATTRIBUTE4,
238: FND_API.G_MISS_CHAR,

Line 238: FND_API.G_MISS_CHAR,

234: FND_API.G_MISS_CHAR,
235: oldrec.ATTRIBUTE3,
236: p_imp_headers_rec.ATTRIBUTE3),
237: ATTRIBUTE4 = DECODE(p_imp_headers_rec.ATTRIBUTE4,
238: FND_API.G_MISS_CHAR,
239: oldrec.ATTRIBUTE4,
240: p_imp_headers_rec.ATTRIBUTE4),
241: ATTRIBUTE5 = DECODE(p_imp_headers_rec.ATTRIBUTE5,
242: FND_API.G_MISS_CHAR,

Line 242: FND_API.G_MISS_CHAR,

238: FND_API.G_MISS_CHAR,
239: oldrec.ATTRIBUTE4,
240: p_imp_headers_rec.ATTRIBUTE4),
241: ATTRIBUTE5 = DECODE(p_imp_headers_rec.ATTRIBUTE5,
242: FND_API.G_MISS_CHAR,
243: oldrec.ATTRIBUTE5,
244: p_imp_headers_rec.ATTRIBUTE5),
245: ATTRIBUTE6 = DECODE(p_imp_headers_rec.ATTRIBUTE6,
246: FND_API.G_MISS_CHAR,

Line 246: FND_API.G_MISS_CHAR,

242: FND_API.G_MISS_CHAR,
243: oldrec.ATTRIBUTE5,
244: p_imp_headers_rec.ATTRIBUTE5),
245: ATTRIBUTE6 = DECODE(p_imp_headers_rec.ATTRIBUTE6,
246: FND_API.G_MISS_CHAR,
247: oldrec.ATTRIBUTE6,
248: p_imp_headers_rec.ATTRIBUTE6),
249: ATTRIBUTE7 = DECODE(p_imp_headers_rec.ATTRIBUTE7,
250: FND_API.G_MISS_CHAR,

Line 250: FND_API.G_MISS_CHAR,

246: FND_API.G_MISS_CHAR,
247: oldrec.ATTRIBUTE6,
248: p_imp_headers_rec.ATTRIBUTE6),
249: ATTRIBUTE7 = DECODE(p_imp_headers_rec.ATTRIBUTE7,
250: FND_API.G_MISS_CHAR,
251: oldrec.ATTRIBUTE7,
252: p_imp_headers_rec.ATTRIBUTE7),
253: ATTRIBUTE8 = DECODE(p_imp_headers_rec.ATTRIBUTE8,
254: FND_API.G_MISS_CHAR,

Line 254: FND_API.G_MISS_CHAR,

250: FND_API.G_MISS_CHAR,
251: oldrec.ATTRIBUTE7,
252: p_imp_headers_rec.ATTRIBUTE7),
253: ATTRIBUTE8 = DECODE(p_imp_headers_rec.ATTRIBUTE8,
254: FND_API.G_MISS_CHAR,
255: oldrec.ATTRIBUTE8,
256: p_imp_headers_rec.ATTRIBUTE8),
257: ATTRIBUTE9 = DECODE(p_imp_headers_rec.ATTRIBUTE9,
258: FND_API.G_MISS_CHAR,

Line 258: FND_API.G_MISS_CHAR,

254: FND_API.G_MISS_CHAR,
255: oldrec.ATTRIBUTE8,
256: p_imp_headers_rec.ATTRIBUTE8),
257: ATTRIBUTE9 = DECODE(p_imp_headers_rec.ATTRIBUTE9,
258: FND_API.G_MISS_CHAR,
259: oldrec.ATTRIBUTE9,
260: p_imp_headers_rec.ATTRIBUTE9),
261: ATTRIBUTE10 = DECODE(p_imp_headers_rec.ATTRIBUTE10,
262: FND_API.G_MISS_CHAR,

Line 262: FND_API.G_MISS_CHAR,

258: FND_API.G_MISS_CHAR,
259: oldrec.ATTRIBUTE9,
260: p_imp_headers_rec.ATTRIBUTE9),
261: ATTRIBUTE10 = DECODE(p_imp_headers_rec.ATTRIBUTE10,
262: FND_API.G_MISS_CHAR,
263: oldrec.ATTRIBUTE10,
264: p_imp_headers_rec.ATTRIBUTE10),
265: ATTRIBUTE11 = DECODE(p_imp_headers_rec.ATTRIBUTE11,
266: FND_API.G_MISS_CHAR,

Line 266: FND_API.G_MISS_CHAR,

262: FND_API.G_MISS_CHAR,
263: oldrec.ATTRIBUTE10,
264: p_imp_headers_rec.ATTRIBUTE10),
265: ATTRIBUTE11 = DECODE(p_imp_headers_rec.ATTRIBUTE11,
266: FND_API.G_MISS_CHAR,
267: oldrec.ATTRIBUTE11,
268: p_imp_headers_rec.ATTRIBUTE11),
269: ATTRIBUTE12 = DECODE(p_imp_headers_rec.ATTRIBUTE12,
270: FND_API.G_MISS_CHAR,

Line 270: FND_API.G_MISS_CHAR,

266: FND_API.G_MISS_CHAR,
267: oldrec.ATTRIBUTE11,
268: p_imp_headers_rec.ATTRIBUTE11),
269: ATTRIBUTE12 = DECODE(p_imp_headers_rec.ATTRIBUTE12,
270: FND_API.G_MISS_CHAR,
271: oldrec.ATTRIBUTE12,
272: p_imp_headers_rec.ATTRIBUTE12),
273: ATTRIBUTE13 = DECODE(p_imp_headers_rec.ATTRIBUTE13,
274: FND_API.G_MISS_CHAR,

Line 274: FND_API.G_MISS_CHAR,

270: FND_API.G_MISS_CHAR,
271: oldrec.ATTRIBUTE12,
272: p_imp_headers_rec.ATTRIBUTE12),
273: ATTRIBUTE13 = DECODE(p_imp_headers_rec.ATTRIBUTE13,
274: FND_API.G_MISS_CHAR,
275: oldrec.ATTRIBUTE13,
276: p_imp_headers_rec.ATTRIBUTE13),
277: ATTRIBUTE14 = DECODE(p_imp_headers_rec.ATTRIBUTE14,
278: FND_API.G_MISS_CHAR,

Line 278: FND_API.G_MISS_CHAR,

274: FND_API.G_MISS_CHAR,
275: oldrec.ATTRIBUTE13,
276: p_imp_headers_rec.ATTRIBUTE13),
277: ATTRIBUTE14 = DECODE(p_imp_headers_rec.ATTRIBUTE14,
278: FND_API.G_MISS_CHAR,
279: oldrec.ATTRIBUTE14,
280: p_imp_headers_rec.ATTRIBUTE14),
281: ATTRIBUTE15 = DECODE(p_imp_headers_rec.ATTRIBUTE15,
282: FND_API.G_MISS_CHAR,

Line 282: FND_API.G_MISS_CHAR,

278: FND_API.G_MISS_CHAR,
279: oldrec.ATTRIBUTE14,
280: p_imp_headers_rec.ATTRIBUTE14),
281: ATTRIBUTE15 = DECODE(p_imp_headers_rec.ATTRIBUTE15,
282: FND_API.G_MISS_CHAR,
283: oldrec.ATTRIBUTE15,
284: p_imp_headers_rec.ATTRIBUTE15),
285: LAST_UPDATE_DATE = Sysdate,
286: LAST_UPDATED_BY = fnd_global.user_id,

Line 325: raise fnd_api.g_exc_unexpected_error;

321: if (c%notfound) then
322: close c;
323: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
324: fnd_msg_pub.add;
325: raise fnd_api.g_exc_unexpected_error;
326: end if;
327: close c;
328:
329: if (tlinfo.object_version_number <> p_imp_headers_rec.object_version_number) then

Line 332: raise fnd_api.g_exc_unexpected_error;

328:
329: if (tlinfo.object_version_number <> p_imp_headers_rec.object_version_number) then
330: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
331: fnd_msg_pub.add;
332: raise fnd_api.g_exc_unexpected_error;
333: end if;
334: UPDATE CN_IMP_HEADERS oldrec
335: SET
336: NAME = DECODE(p_imp_headers_rec.NAME,

Line 337: FND_API.G_MISS_CHAR,

333: end if;
334: UPDATE CN_IMP_HEADERS oldrec
335: SET
336: NAME = DECODE(p_imp_headers_rec.NAME,
337: FND_API.G_MISS_CHAR,
338: oldrec.NAME,
339: p_imp_headers_rec.NAME),
340: DESCRIPTION = DECODE(p_imp_headers_rec.DESCRIPTION,
341: FND_API.G_MISS_CHAR,

Line 341: FND_API.G_MISS_CHAR,

337: FND_API.G_MISS_CHAR,
338: oldrec.NAME,
339: p_imp_headers_rec.NAME),
340: DESCRIPTION = DECODE(p_imp_headers_rec.DESCRIPTION,
341: FND_API.G_MISS_CHAR,
342: oldrec.DESCRIPTION,
343: p_imp_headers_rec.DESCRIPTION),
344: IMPORT_TYPE_CODE = DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE,
345: FND_API.G_MISS_CHAR,

Line 345: FND_API.G_MISS_CHAR,

341: FND_API.G_MISS_CHAR,
342: oldrec.DESCRIPTION,
343: p_imp_headers_rec.DESCRIPTION),
344: IMPORT_TYPE_CODE = DECODE(p_imp_headers_rec.IMPORT_TYPE_CODE,
345: FND_API.G_MISS_CHAR,
346: oldrec.IMPORT_TYPE_CODE,
347: p_imp_headers_rec.IMPORT_TYPE_CODE),
348: OPERATION = DECODE(p_imp_headers_rec.OPERATION,
349: FND_API.G_MISS_CHAR,

Line 349: FND_API.G_MISS_CHAR,

345: FND_API.G_MISS_CHAR,
346: oldrec.IMPORT_TYPE_CODE,
347: p_imp_headers_rec.IMPORT_TYPE_CODE),
348: OPERATION = DECODE(p_imp_headers_rec.OPERATION,
349: FND_API.G_MISS_CHAR,
350: oldrec.OPERATION,
351: p_imp_headers_rec.OPERATION),
352: SERVER_FLAG = DECODE(p_imp_headers_rec.SERVER_FLAG,
353: FND_API.G_MISS_CHAR,

Line 353: FND_API.G_MISS_CHAR,

349: FND_API.G_MISS_CHAR,
350: oldrec.OPERATION,
351: p_imp_headers_rec.OPERATION),
352: SERVER_FLAG = DECODE(p_imp_headers_rec.SERVER_FLAG,
353: FND_API.G_MISS_CHAR,
354: oldrec.SERVER_FLAG,
355: p_imp_headers_rec.SERVER_FLAG),
356: USER_FILENAME = DECODE(p_imp_headers_rec.USER_FILENAME,
357: FND_API.G_MISS_CHAR,

Line 357: FND_API.G_MISS_CHAR,

353: FND_API.G_MISS_CHAR,
354: oldrec.SERVER_FLAG,
355: p_imp_headers_rec.SERVER_FLAG),
356: USER_FILENAME = DECODE(p_imp_headers_rec.USER_FILENAME,
357: FND_API.G_MISS_CHAR,
358: oldrec.USER_FILENAME,
359: p_imp_headers_rec.USER_FILENAME),
360: DATA_FILENAME = DECODE(p_imp_headers_rec.DATA_FILENAME,
361: FND_API.G_MISS_CHAR,

Line 361: FND_API.G_MISS_CHAR,

357: FND_API.G_MISS_CHAR,
358: oldrec.USER_FILENAME,
359: p_imp_headers_rec.USER_FILENAME),
360: DATA_FILENAME = DECODE(p_imp_headers_rec.DATA_FILENAME,
361: FND_API.G_MISS_CHAR,
362: oldrec.DATA_FILENAME,
363: p_imp_headers_rec.DATA_FILENAME),
364: TERMINATED_BY = DECODE(p_imp_headers_rec.TERMINATED_BY,
365: FND_API.G_MISS_CHAR,

Line 365: FND_API.G_MISS_CHAR,

361: FND_API.G_MISS_CHAR,
362: oldrec.DATA_FILENAME,
363: p_imp_headers_rec.DATA_FILENAME),
364: TERMINATED_BY = DECODE(p_imp_headers_rec.TERMINATED_BY,
365: FND_API.G_MISS_CHAR,
366: oldrec.TERMINATED_BY,
367: p_imp_headers_rec.TERMINATED_BY),
368: ENCLOSED_BY = DECODE(p_imp_headers_rec.ENCLOSED_BY,
369: FND_API.G_MISS_CHAR,

Line 369: FND_API.G_MISS_CHAR,

365: FND_API.G_MISS_CHAR,
366: oldrec.TERMINATED_BY,
367: p_imp_headers_rec.TERMINATED_BY),
368: ENCLOSED_BY = DECODE(p_imp_headers_rec.ENCLOSED_BY,
369: FND_API.G_MISS_CHAR,
370: oldrec.ENCLOSED_BY,
371: p_imp_headers_rec.ENCLOSED_BY),
372: HEADINGS_FLAG = DECODE(p_imp_headers_rec.HEADINGS_FLAG,
373: FND_API.G_MISS_CHAR,

Line 373: FND_API.G_MISS_CHAR,

369: FND_API.G_MISS_CHAR,
370: oldrec.ENCLOSED_BY,
371: p_imp_headers_rec.ENCLOSED_BY),
372: HEADINGS_FLAG = DECODE(p_imp_headers_rec.HEADINGS_FLAG,
373: FND_API.G_MISS_CHAR,
374: oldrec.HEADINGS_FLAG,
375: p_imp_headers_rec.HEADINGS_FLAG),
376: STAGED_ROW = DECODE(p_imp_headers_rec.STAGED_ROW,
377: FND_API.G_MISS_NUM,

Line 377: FND_API.G_MISS_NUM,

373: FND_API.G_MISS_CHAR,
374: oldrec.HEADINGS_FLAG,
375: p_imp_headers_rec.HEADINGS_FLAG),
376: STAGED_ROW = DECODE(p_imp_headers_rec.STAGED_ROW,
377: FND_API.G_MISS_NUM,
378: oldrec.STAGED_ROW,
379: p_imp_headers_rec.STAGED_ROW),
380: PROCESSED_ROW = DECODE(p_imp_headers_rec.PROCESSED_ROW,
381: FND_API.G_MISS_NUM,

Line 381: FND_API.G_MISS_NUM,

377: FND_API.G_MISS_NUM,
378: oldrec.STAGED_ROW,
379: p_imp_headers_rec.STAGED_ROW),
380: PROCESSED_ROW = DECODE(p_imp_headers_rec.PROCESSED_ROW,
381: FND_API.G_MISS_NUM,
382: oldrec.PROCESSED_ROW,
383: p_imp_headers_rec.PROCESSED_ROW),
384: FAILED_ROW = DECODE(p_imp_headers_rec.FAILED_ROW,
385: FND_API.G_MISS_NUM,

Line 385: FND_API.G_MISS_NUM,

381: FND_API.G_MISS_NUM,
382: oldrec.PROCESSED_ROW,
383: p_imp_headers_rec.PROCESSED_ROW),
384: FAILED_ROW = DECODE(p_imp_headers_rec.FAILED_ROW,
385: FND_API.G_MISS_NUM,
386: oldrec.FAILED_ROW,
387: p_imp_headers_rec.FAILED_ROW),
388: STATUS_CODE = DECODE(p_imp_headers_rec.STATUS_CODE,
389: FND_API.G_MISS_CHAR,

Line 389: FND_API.G_MISS_CHAR,

385: FND_API.G_MISS_NUM,
386: oldrec.FAILED_ROW,
387: p_imp_headers_rec.FAILED_ROW),
388: STATUS_CODE = DECODE(p_imp_headers_rec.STATUS_CODE,
389: FND_API.G_MISS_CHAR,
390: oldrec.STATUS_CODE,
391: p_imp_headers_rec.STATUS_CODE),
392: IMP_MAP_ID = DECODE(p_imp_headers_rec.IMP_MAP_ID,
393: FND_API.G_MISS_NUM,

Line 393: FND_API.G_MISS_NUM,

389: FND_API.G_MISS_CHAR,
390: oldrec.STATUS_CODE,
391: p_imp_headers_rec.STATUS_CODE),
392: IMP_MAP_ID = DECODE(p_imp_headers_rec.IMP_MAP_ID,
393: FND_API.G_MISS_NUM,
394: oldrec.IMP_MAP_ID,
395: p_imp_headers_rec.IMP_MAP_ID),
396: SOURCE_COLUMN_NUM = DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM,
397: FND_API.G_MISS_NUM,

Line 397: FND_API.G_MISS_NUM,

393: FND_API.G_MISS_NUM,
394: oldrec.IMP_MAP_ID,
395: p_imp_headers_rec.IMP_MAP_ID),
396: SOURCE_COLUMN_NUM = DECODE(p_imp_headers_rec.SOURCE_COLUMN_NUM,
397: FND_API.G_MISS_NUM,
398: oldrec.SOURCE_COLUMN_NUM,
399: p_imp_headers_rec.SOURCE_COLUMN_NUM),
400: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
401: ATTRIBUTE_CATEGORY = DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY,

Line 402: FND_API.G_MISS_CHAR,

398: oldrec.SOURCE_COLUMN_NUM,
399: p_imp_headers_rec.SOURCE_COLUMN_NUM),
400: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
401: ATTRIBUTE_CATEGORY = DECODE(p_imp_headers_rec.ATTRIBUTE_CATEGORY,
402: FND_API.G_MISS_CHAR,
403: oldrec.ATTRIBUTE_CATEGORY,
404: p_imp_headers_rec.ATTRIBUTE_CATEGORY),
405: ATTRIBUTE1 = DECODE(p_imp_headers_rec.ATTRIBUTE1,
406: FND_API.G_MISS_CHAR,

Line 406: FND_API.G_MISS_CHAR,

402: FND_API.G_MISS_CHAR,
403: oldrec.ATTRIBUTE_CATEGORY,
404: p_imp_headers_rec.ATTRIBUTE_CATEGORY),
405: ATTRIBUTE1 = DECODE(p_imp_headers_rec.ATTRIBUTE1,
406: FND_API.G_MISS_CHAR,
407: oldrec.ATTRIBUTE1,
408: p_imp_headers_rec.ATTRIBUTE1),
409: ATTRIBUTE2 = DECODE(p_imp_headers_rec.ATTRIBUTE2,
410: FND_API.G_MISS_CHAR,

Line 410: FND_API.G_MISS_CHAR,

406: FND_API.G_MISS_CHAR,
407: oldrec.ATTRIBUTE1,
408: p_imp_headers_rec.ATTRIBUTE1),
409: ATTRIBUTE2 = DECODE(p_imp_headers_rec.ATTRIBUTE2,
410: FND_API.G_MISS_CHAR,
411: oldrec.ATTRIBUTE2,
412: p_imp_headers_rec.ATTRIBUTE2),
413: ATTRIBUTE3 = DECODE(p_imp_headers_rec.ATTRIBUTE3,
414: FND_API.G_MISS_CHAR,

Line 414: FND_API.G_MISS_CHAR,

410: FND_API.G_MISS_CHAR,
411: oldrec.ATTRIBUTE2,
412: p_imp_headers_rec.ATTRIBUTE2),
413: ATTRIBUTE3 = DECODE(p_imp_headers_rec.ATTRIBUTE3,
414: FND_API.G_MISS_CHAR,
415: oldrec.ATTRIBUTE3,
416: p_imp_headers_rec.ATTRIBUTE3),
417: ATTRIBUTE4 = DECODE(p_imp_headers_rec.ATTRIBUTE4,
418: FND_API.G_MISS_CHAR,

Line 418: FND_API.G_MISS_CHAR,

414: FND_API.G_MISS_CHAR,
415: oldrec.ATTRIBUTE3,
416: p_imp_headers_rec.ATTRIBUTE3),
417: ATTRIBUTE4 = DECODE(p_imp_headers_rec.ATTRIBUTE4,
418: FND_API.G_MISS_CHAR,
419: oldrec.ATTRIBUTE4,
420: p_imp_headers_rec.ATTRIBUTE4),
421: ATTRIBUTE5 = DECODE(p_imp_headers_rec.ATTRIBUTE5,
422: FND_API.G_MISS_CHAR,

Line 422: FND_API.G_MISS_CHAR,

418: FND_API.G_MISS_CHAR,
419: oldrec.ATTRIBUTE4,
420: p_imp_headers_rec.ATTRIBUTE4),
421: ATTRIBUTE5 = DECODE(p_imp_headers_rec.ATTRIBUTE5,
422: FND_API.G_MISS_CHAR,
423: oldrec.ATTRIBUTE5,
424: p_imp_headers_rec.ATTRIBUTE5),
425: ATTRIBUTE6 = DECODE(p_imp_headers_rec.ATTRIBUTE6,
426: FND_API.G_MISS_CHAR,

Line 426: FND_API.G_MISS_CHAR,

422: FND_API.G_MISS_CHAR,
423: oldrec.ATTRIBUTE5,
424: p_imp_headers_rec.ATTRIBUTE5),
425: ATTRIBUTE6 = DECODE(p_imp_headers_rec.ATTRIBUTE6,
426: FND_API.G_MISS_CHAR,
427: oldrec.ATTRIBUTE6,
428: p_imp_headers_rec.ATTRIBUTE6),
429: ATTRIBUTE7 = DECODE(p_imp_headers_rec.ATTRIBUTE7,
430: FND_API.G_MISS_CHAR,

Line 430: FND_API.G_MISS_CHAR,

426: FND_API.G_MISS_CHAR,
427: oldrec.ATTRIBUTE6,
428: p_imp_headers_rec.ATTRIBUTE6),
429: ATTRIBUTE7 = DECODE(p_imp_headers_rec.ATTRIBUTE7,
430: FND_API.G_MISS_CHAR,
431: oldrec.ATTRIBUTE7,
432: p_imp_headers_rec.ATTRIBUTE7),
433: ATTRIBUTE8 = DECODE(p_imp_headers_rec.ATTRIBUTE8,
434: FND_API.G_MISS_CHAR,

Line 434: FND_API.G_MISS_CHAR,

430: FND_API.G_MISS_CHAR,
431: oldrec.ATTRIBUTE7,
432: p_imp_headers_rec.ATTRIBUTE7),
433: ATTRIBUTE8 = DECODE(p_imp_headers_rec.ATTRIBUTE8,
434: FND_API.G_MISS_CHAR,
435: oldrec.ATTRIBUTE8,
436: p_imp_headers_rec.ATTRIBUTE8),
437: ATTRIBUTE9 = DECODE(p_imp_headers_rec.ATTRIBUTE9,
438: FND_API.G_MISS_CHAR,

Line 438: FND_API.G_MISS_CHAR,

434: FND_API.G_MISS_CHAR,
435: oldrec.ATTRIBUTE8,
436: p_imp_headers_rec.ATTRIBUTE8),
437: ATTRIBUTE9 = DECODE(p_imp_headers_rec.ATTRIBUTE9,
438: FND_API.G_MISS_CHAR,
439: oldrec.ATTRIBUTE9,
440: p_imp_headers_rec.ATTRIBUTE9),
441: ATTRIBUTE10 = DECODE(p_imp_headers_rec.ATTRIBUTE10,
442: FND_API.G_MISS_CHAR,

Line 442: FND_API.G_MISS_CHAR,

438: FND_API.G_MISS_CHAR,
439: oldrec.ATTRIBUTE9,
440: p_imp_headers_rec.ATTRIBUTE9),
441: ATTRIBUTE10 = DECODE(p_imp_headers_rec.ATTRIBUTE10,
442: FND_API.G_MISS_CHAR,
443: oldrec.ATTRIBUTE10,
444: p_imp_headers_rec.ATTRIBUTE10),
445: ATTRIBUTE11 = DECODE(p_imp_headers_rec.ATTRIBUTE11,
446: FND_API.G_MISS_CHAR,

Line 446: FND_API.G_MISS_CHAR,

442: FND_API.G_MISS_CHAR,
443: oldrec.ATTRIBUTE10,
444: p_imp_headers_rec.ATTRIBUTE10),
445: ATTRIBUTE11 = DECODE(p_imp_headers_rec.ATTRIBUTE11,
446: FND_API.G_MISS_CHAR,
447: oldrec.ATTRIBUTE11,
448: p_imp_headers_rec.ATTRIBUTE11),
449: ATTRIBUTE12 = DECODE(p_imp_headers_rec.ATTRIBUTE12,
450: FND_API.G_MISS_CHAR,

Line 450: FND_API.G_MISS_CHAR,

446: FND_API.G_MISS_CHAR,
447: oldrec.ATTRIBUTE11,
448: p_imp_headers_rec.ATTRIBUTE11),
449: ATTRIBUTE12 = DECODE(p_imp_headers_rec.ATTRIBUTE12,
450: FND_API.G_MISS_CHAR,
451: oldrec.ATTRIBUTE12,
452: p_imp_headers_rec.ATTRIBUTE12),
453: ATTRIBUTE13 = DECODE(p_imp_headers_rec.ATTRIBUTE13,
454: FND_API.G_MISS_CHAR,

Line 454: FND_API.G_MISS_CHAR,

450: FND_API.G_MISS_CHAR,
451: oldrec.ATTRIBUTE12,
452: p_imp_headers_rec.ATTRIBUTE12),
453: ATTRIBUTE13 = DECODE(p_imp_headers_rec.ATTRIBUTE13,
454: FND_API.G_MISS_CHAR,
455: oldrec.ATTRIBUTE13,
456: p_imp_headers_rec.ATTRIBUTE13),
457: ATTRIBUTE14 = DECODE(p_imp_headers_rec.ATTRIBUTE14,
458: FND_API.G_MISS_CHAR,

Line 458: FND_API.G_MISS_CHAR,

454: FND_API.G_MISS_CHAR,
455: oldrec.ATTRIBUTE13,
456: p_imp_headers_rec.ATTRIBUTE13),
457: ATTRIBUTE14 = DECODE(p_imp_headers_rec.ATTRIBUTE14,
458: FND_API.G_MISS_CHAR,
459: oldrec.ATTRIBUTE14,
460: p_imp_headers_rec.ATTRIBUTE14),
461: ATTRIBUTE15 = DECODE(p_imp_headers_rec.ATTRIBUTE15,
462: FND_API.G_MISS_CHAR,

Line 462: FND_API.G_MISS_CHAR,

458: FND_API.G_MISS_CHAR,
459: oldrec.ATTRIBUTE14,
460: p_imp_headers_rec.ATTRIBUTE14),
461: ATTRIBUTE15 = DECODE(p_imp_headers_rec.ATTRIBUTE15,
462: FND_API.G_MISS_CHAR,
463: oldrec.ATTRIBUTE15,
464: p_imp_headers_rec.ATTRIBUTE15),
465: LAST_UPDATE_DATE = Sysdate,
466: LAST_UPDATED_BY = fnd_global.user_id,