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_INVOICE_CHANGES_PKG dependencies on FND_API

Line 51: DECODE(p_invoice_changes_all_rec.INVOICE_CHANGE_ID, FND_API.G_MISS_NUM, NULL,

47: LAST_UPDATE_LOGIN,
48: OBJECT_VERSION_NUMBER,
49: COMM_LINES_API_ID)
50: select
51: DECODE(p_invoice_changes_all_rec.INVOICE_CHANGE_ID, FND_API.G_MISS_NUM, NULL,
52: p_invoice_changes_all_rec.INVOICE_CHANGE_ID),
53: DECODE(p_invoice_changes_all_rec.SALESREP_ID, FND_API.G_MISS_NUM, NULL,
54: p_invoice_changes_all_rec.SALESREP_ID),
55: DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER, FND_API.G_MISS_CHAR, NULL,

Line 53: DECODE(p_invoice_changes_all_rec.SALESREP_ID, FND_API.G_MISS_NUM, NULL,

49: COMM_LINES_API_ID)
50: select
51: DECODE(p_invoice_changes_all_rec.INVOICE_CHANGE_ID, FND_API.G_MISS_NUM, NULL,
52: p_invoice_changes_all_rec.INVOICE_CHANGE_ID),
53: DECODE(p_invoice_changes_all_rec.SALESREP_ID, FND_API.G_MISS_NUM, NULL,
54: p_invoice_changes_all_rec.SALESREP_ID),
55: DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER, FND_API.G_MISS_CHAR, NULL,
56: p_invoice_changes_all_rec.INVOICE_NUMBER),
57: DECODE(p_invoice_changes_all_rec.LINE_NUMBER, FND_API.G_MISS_NUM, NULL,

Line 55: DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER, FND_API.G_MISS_CHAR, NULL,

51: DECODE(p_invoice_changes_all_rec.INVOICE_CHANGE_ID, FND_API.G_MISS_NUM, NULL,
52: p_invoice_changes_all_rec.INVOICE_CHANGE_ID),
53: DECODE(p_invoice_changes_all_rec.SALESREP_ID, FND_API.G_MISS_NUM, NULL,
54: p_invoice_changes_all_rec.SALESREP_ID),
55: DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER, FND_API.G_MISS_CHAR, NULL,
56: p_invoice_changes_all_rec.INVOICE_NUMBER),
57: DECODE(p_invoice_changes_all_rec.LINE_NUMBER, FND_API.G_MISS_NUM, NULL,
58: p_invoice_changes_all_rec.LINE_NUMBER),
59: DECODE(p_invoice_changes_all_rec.REVENUE_TYPE, FND_API.G_MISS_CHAR, NULL,

Line 57: DECODE(p_invoice_changes_all_rec.LINE_NUMBER, FND_API.G_MISS_NUM, NULL,

53: DECODE(p_invoice_changes_all_rec.SALESREP_ID, FND_API.G_MISS_NUM, NULL,
54: p_invoice_changes_all_rec.SALESREP_ID),
55: DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER, FND_API.G_MISS_CHAR, NULL,
56: p_invoice_changes_all_rec.INVOICE_NUMBER),
57: DECODE(p_invoice_changes_all_rec.LINE_NUMBER, FND_API.G_MISS_NUM, NULL,
58: p_invoice_changes_all_rec.LINE_NUMBER),
59: DECODE(p_invoice_changes_all_rec.REVENUE_TYPE, FND_API.G_MISS_CHAR, NULL,
60: p_invoice_changes_all_rec.REVENUE_TYPE),
61: DECODE(p_invoice_changes_all_rec.SPLIT_PCT, FND_API.G_MISS_NUM, NULL,

Line 59: DECODE(p_invoice_changes_all_rec.REVENUE_TYPE, FND_API.G_MISS_CHAR, NULL,

55: DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER, FND_API.G_MISS_CHAR, NULL,
56: p_invoice_changes_all_rec.INVOICE_NUMBER),
57: DECODE(p_invoice_changes_all_rec.LINE_NUMBER, FND_API.G_MISS_NUM, NULL,
58: p_invoice_changes_all_rec.LINE_NUMBER),
59: DECODE(p_invoice_changes_all_rec.REVENUE_TYPE, FND_API.G_MISS_CHAR, NULL,
60: p_invoice_changes_all_rec.REVENUE_TYPE),
61: DECODE(p_invoice_changes_all_rec.SPLIT_PCT, FND_API.G_MISS_NUM, NULL,
62: p_invoice_changes_all_rec.SPLIT_PCT),
63: DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

Line 61: DECODE(p_invoice_changes_all_rec.SPLIT_PCT, FND_API.G_MISS_NUM, NULL,

57: DECODE(p_invoice_changes_all_rec.LINE_NUMBER, FND_API.G_MISS_NUM, NULL,
58: p_invoice_changes_all_rec.LINE_NUMBER),
59: DECODE(p_invoice_changes_all_rec.REVENUE_TYPE, FND_API.G_MISS_CHAR, NULL,
60: p_invoice_changes_all_rec.REVENUE_TYPE),
61: DECODE(p_invoice_changes_all_rec.SPLIT_PCT, FND_API.G_MISS_NUM, NULL,
62: p_invoice_changes_all_rec.SPLIT_PCT),
63: DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
64: p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY),
65: DECODE(p_invoice_changes_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,

Line 63: DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

59: DECODE(p_invoice_changes_all_rec.REVENUE_TYPE, FND_API.G_MISS_CHAR, NULL,
60: p_invoice_changes_all_rec.REVENUE_TYPE),
61: DECODE(p_invoice_changes_all_rec.SPLIT_PCT, FND_API.G_MISS_NUM, NULL,
62: p_invoice_changes_all_rec.SPLIT_PCT),
63: DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
64: p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY),
65: DECODE(p_invoice_changes_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
66: p_invoice_changes_all_rec.ATTRIBUTE1),
67: DECODE(p_invoice_changes_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

Line 65: DECODE(p_invoice_changes_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,

61: DECODE(p_invoice_changes_all_rec.SPLIT_PCT, FND_API.G_MISS_NUM, NULL,
62: p_invoice_changes_all_rec.SPLIT_PCT),
63: DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
64: p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY),
65: DECODE(p_invoice_changes_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
66: p_invoice_changes_all_rec.ATTRIBUTE1),
67: DECODE(p_invoice_changes_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
68: p_invoice_changes_all_rec.ATTRIBUTE2),
69: DECODE(p_invoice_changes_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

Line 67: DECODE(p_invoice_changes_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

63: DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
64: p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY),
65: DECODE(p_invoice_changes_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
66: p_invoice_changes_all_rec.ATTRIBUTE1),
67: DECODE(p_invoice_changes_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
68: p_invoice_changes_all_rec.ATTRIBUTE2),
69: DECODE(p_invoice_changes_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
70: p_invoice_changes_all_rec.ATTRIBUTE3),
71: DECODE(p_invoice_changes_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

Line 69: DECODE(p_invoice_changes_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

65: DECODE(p_invoice_changes_all_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
66: p_invoice_changes_all_rec.ATTRIBUTE1),
67: DECODE(p_invoice_changes_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
68: p_invoice_changes_all_rec.ATTRIBUTE2),
69: DECODE(p_invoice_changes_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
70: p_invoice_changes_all_rec.ATTRIBUTE3),
71: DECODE(p_invoice_changes_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
72: p_invoice_changes_all_rec.ATTRIBUTE4),
73: DECODE(p_invoice_changes_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

Line 71: DECODE(p_invoice_changes_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

67: DECODE(p_invoice_changes_all_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
68: p_invoice_changes_all_rec.ATTRIBUTE2),
69: DECODE(p_invoice_changes_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
70: p_invoice_changes_all_rec.ATTRIBUTE3),
71: DECODE(p_invoice_changes_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
72: p_invoice_changes_all_rec.ATTRIBUTE4),
73: DECODE(p_invoice_changes_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
74: p_invoice_changes_all_rec.ATTRIBUTE5),
75: DECODE(p_invoice_changes_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

Line 73: DECODE(p_invoice_changes_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

69: DECODE(p_invoice_changes_all_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
70: p_invoice_changes_all_rec.ATTRIBUTE3),
71: DECODE(p_invoice_changes_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
72: p_invoice_changes_all_rec.ATTRIBUTE4),
73: DECODE(p_invoice_changes_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
74: p_invoice_changes_all_rec.ATTRIBUTE5),
75: DECODE(p_invoice_changes_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
76: p_invoice_changes_all_rec.ATTRIBUTE6),
77: DECODE(p_invoice_changes_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

Line 75: DECODE(p_invoice_changes_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

71: DECODE(p_invoice_changes_all_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
72: p_invoice_changes_all_rec.ATTRIBUTE4),
73: DECODE(p_invoice_changes_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
74: p_invoice_changes_all_rec.ATTRIBUTE5),
75: DECODE(p_invoice_changes_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
76: p_invoice_changes_all_rec.ATTRIBUTE6),
77: DECODE(p_invoice_changes_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
78: p_invoice_changes_all_rec.ATTRIBUTE7),
79: DECODE(p_invoice_changes_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

Line 77: DECODE(p_invoice_changes_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

73: DECODE(p_invoice_changes_all_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
74: p_invoice_changes_all_rec.ATTRIBUTE5),
75: DECODE(p_invoice_changes_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
76: p_invoice_changes_all_rec.ATTRIBUTE6),
77: DECODE(p_invoice_changes_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
78: p_invoice_changes_all_rec.ATTRIBUTE7),
79: DECODE(p_invoice_changes_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
80: p_invoice_changes_all_rec.ATTRIBUTE8),
81: DECODE(p_invoice_changes_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

Line 79: DECODE(p_invoice_changes_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

75: DECODE(p_invoice_changes_all_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
76: p_invoice_changes_all_rec.ATTRIBUTE6),
77: DECODE(p_invoice_changes_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
78: p_invoice_changes_all_rec.ATTRIBUTE7),
79: DECODE(p_invoice_changes_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
80: p_invoice_changes_all_rec.ATTRIBUTE8),
81: DECODE(p_invoice_changes_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
82: p_invoice_changes_all_rec.ATTRIBUTE9),
83: DECODE(p_invoice_changes_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

Line 81: DECODE(p_invoice_changes_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

77: DECODE(p_invoice_changes_all_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
78: p_invoice_changes_all_rec.ATTRIBUTE7),
79: DECODE(p_invoice_changes_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
80: p_invoice_changes_all_rec.ATTRIBUTE8),
81: DECODE(p_invoice_changes_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
82: p_invoice_changes_all_rec.ATTRIBUTE9),
83: DECODE(p_invoice_changes_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
84: p_invoice_changes_all_rec.ATTRIBUTE10),
85: DECODE(p_invoice_changes_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

Line 83: DECODE(p_invoice_changes_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

79: DECODE(p_invoice_changes_all_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
80: p_invoice_changes_all_rec.ATTRIBUTE8),
81: DECODE(p_invoice_changes_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
82: p_invoice_changes_all_rec.ATTRIBUTE9),
83: DECODE(p_invoice_changes_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
84: p_invoice_changes_all_rec.ATTRIBUTE10),
85: DECODE(p_invoice_changes_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
86: p_invoice_changes_all_rec.ATTRIBUTE11),
87: DECODE(p_invoice_changes_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

Line 85: DECODE(p_invoice_changes_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

81: DECODE(p_invoice_changes_all_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
82: p_invoice_changes_all_rec.ATTRIBUTE9),
83: DECODE(p_invoice_changes_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
84: p_invoice_changes_all_rec.ATTRIBUTE10),
85: DECODE(p_invoice_changes_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
86: p_invoice_changes_all_rec.ATTRIBUTE11),
87: DECODE(p_invoice_changes_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
88: p_invoice_changes_all_rec.ATTRIBUTE12),
89: DECODE(p_invoice_changes_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

Line 87: DECODE(p_invoice_changes_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

83: DECODE(p_invoice_changes_all_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
84: p_invoice_changes_all_rec.ATTRIBUTE10),
85: DECODE(p_invoice_changes_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
86: p_invoice_changes_all_rec.ATTRIBUTE11),
87: DECODE(p_invoice_changes_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
88: p_invoice_changes_all_rec.ATTRIBUTE12),
89: DECODE(p_invoice_changes_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
90: p_invoice_changes_all_rec.ATTRIBUTE13),
91: DECODE(p_invoice_changes_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

Line 89: DECODE(p_invoice_changes_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

85: DECODE(p_invoice_changes_all_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
86: p_invoice_changes_all_rec.ATTRIBUTE11),
87: DECODE(p_invoice_changes_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
88: p_invoice_changes_all_rec.ATTRIBUTE12),
89: DECODE(p_invoice_changes_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
90: p_invoice_changes_all_rec.ATTRIBUTE13),
91: DECODE(p_invoice_changes_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
92: p_invoice_changes_all_rec.ATTRIBUTE14),
93: DECODE(p_invoice_changes_all_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

Line 91: DECODE(p_invoice_changes_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

87: DECODE(p_invoice_changes_all_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
88: p_invoice_changes_all_rec.ATTRIBUTE12),
89: DECODE(p_invoice_changes_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
90: p_invoice_changes_all_rec.ATTRIBUTE13),
91: DECODE(p_invoice_changes_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
92: p_invoice_changes_all_rec.ATTRIBUTE14),
93: DECODE(p_invoice_changes_all_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
94: p_invoice_changes_all_rec.ATTRIBUTE15),
95: Sysdate,

Line 93: DECODE(p_invoice_changes_all_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

89: DECODE(p_invoice_changes_all_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
90: p_invoice_changes_all_rec.ATTRIBUTE13),
91: DECODE(p_invoice_changes_all_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
92: p_invoice_changes_all_rec.ATTRIBUTE14),
93: DECODE(p_invoice_changes_all_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
94: p_invoice_changes_all_rec.ATTRIBUTE15),
95: Sysdate,
96: fnd_global.user_id,
97: Sysdate,

Line 101: DECODE(p_invoice_changes_all_rec.COMM_LINES_API_ID, FND_API.G_MISS_NUM, NULL,

97: Sysdate,
98: fnd_global.user_id,
99: fnd_global.login_id,
100: 1,
101: DECODE(p_invoice_changes_all_rec.COMM_LINES_API_ID, FND_API.G_MISS_NUM, NULL,
102: p_invoice_changes_all_rec.COMM_LINES_API_ID)
103: from dual;
104:
105: END insert_row;

Line 127: FND_API.G_MISS_NUM,

123:
124: UPDATE CN_INVOICE_CHANGES_ALL oldrec
125: SET
126: SALESREP_ID = DECODE(p_invoice_changes_all_rec.SALESREP_ID,
127: FND_API.G_MISS_NUM,
128: oldrec.SALESREP_ID,
129: p_invoice_changes_all_rec.SALESREP_ID),
130: INVOICE_NUMBER = DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER,
131: FND_API.G_MISS_CHAR,

Line 131: FND_API.G_MISS_CHAR,

127: FND_API.G_MISS_NUM,
128: oldrec.SALESREP_ID,
129: p_invoice_changes_all_rec.SALESREP_ID),
130: INVOICE_NUMBER = DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER,
131: FND_API.G_MISS_CHAR,
132: oldrec.INVOICE_NUMBER,
133: p_invoice_changes_all_rec.INVOICE_NUMBER),
134: LINE_NUMBER = DECODE(p_invoice_changes_all_rec.LINE_NUMBER,
135: FND_API.G_MISS_NUM,

Line 135: FND_API.G_MISS_NUM,

131: FND_API.G_MISS_CHAR,
132: oldrec.INVOICE_NUMBER,
133: p_invoice_changes_all_rec.INVOICE_NUMBER),
134: LINE_NUMBER = DECODE(p_invoice_changes_all_rec.LINE_NUMBER,
135: FND_API.G_MISS_NUM,
136: oldrec.LINE_NUMBER,
137: p_invoice_changes_all_rec.LINE_NUMBER),
138: REVENUE_TYPE = DECODE(p_invoice_changes_all_rec.REVENUE_TYPE,
139: FND_API.G_MISS_CHAR,

Line 139: FND_API.G_MISS_CHAR,

135: FND_API.G_MISS_NUM,
136: oldrec.LINE_NUMBER,
137: p_invoice_changes_all_rec.LINE_NUMBER),
138: REVENUE_TYPE = DECODE(p_invoice_changes_all_rec.REVENUE_TYPE,
139: FND_API.G_MISS_CHAR,
140: oldrec.REVENUE_TYPE,
141: p_invoice_changes_all_rec.REVENUE_TYPE),
142: SPLIT_PCT = DECODE(p_invoice_changes_all_rec.SPLIT_PCT,
143: FND_API.G_MISS_NUM,

Line 143: FND_API.G_MISS_NUM,

139: FND_API.G_MISS_CHAR,
140: oldrec.REVENUE_TYPE,
141: p_invoice_changes_all_rec.REVENUE_TYPE),
142: SPLIT_PCT = DECODE(p_invoice_changes_all_rec.SPLIT_PCT,
143: FND_API.G_MISS_NUM,
144: oldrec.SPLIT_PCT,
145: p_invoice_changes_all_rec.SPLIT_PCT),
146: ATTRIBUTE_CATEGORY = DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY,
147: FND_API.G_MISS_CHAR,

Line 147: FND_API.G_MISS_CHAR,

143: FND_API.G_MISS_NUM,
144: oldrec.SPLIT_PCT,
145: p_invoice_changes_all_rec.SPLIT_PCT),
146: ATTRIBUTE_CATEGORY = DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY,
147: FND_API.G_MISS_CHAR,
148: oldrec.ATTRIBUTE_CATEGORY,
149: p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY),
150: ATTRIBUTE1 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE1,
151: FND_API.G_MISS_CHAR,

Line 151: FND_API.G_MISS_CHAR,

147: FND_API.G_MISS_CHAR,
148: oldrec.ATTRIBUTE_CATEGORY,
149: p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY),
150: ATTRIBUTE1 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE1,
151: FND_API.G_MISS_CHAR,
152: oldrec.ATTRIBUTE1,
153: p_invoice_changes_all_rec.ATTRIBUTE1),
154: ATTRIBUTE2 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE2,
155: FND_API.G_MISS_CHAR,

Line 155: FND_API.G_MISS_CHAR,

151: FND_API.G_MISS_CHAR,
152: oldrec.ATTRIBUTE1,
153: p_invoice_changes_all_rec.ATTRIBUTE1),
154: ATTRIBUTE2 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE2,
155: FND_API.G_MISS_CHAR,
156: oldrec.ATTRIBUTE2,
157: p_invoice_changes_all_rec.ATTRIBUTE2),
158: ATTRIBUTE3 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE3,
159: FND_API.G_MISS_CHAR,

Line 159: FND_API.G_MISS_CHAR,

155: FND_API.G_MISS_CHAR,
156: oldrec.ATTRIBUTE2,
157: p_invoice_changes_all_rec.ATTRIBUTE2),
158: ATTRIBUTE3 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE3,
159: FND_API.G_MISS_CHAR,
160: oldrec.ATTRIBUTE3,
161: p_invoice_changes_all_rec.ATTRIBUTE3),
162: ATTRIBUTE4 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE4,
163: FND_API.G_MISS_CHAR,

Line 163: FND_API.G_MISS_CHAR,

159: FND_API.G_MISS_CHAR,
160: oldrec.ATTRIBUTE3,
161: p_invoice_changes_all_rec.ATTRIBUTE3),
162: ATTRIBUTE4 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE4,
163: FND_API.G_MISS_CHAR,
164: oldrec.ATTRIBUTE4,
165: p_invoice_changes_all_rec.ATTRIBUTE4),
166: ATTRIBUTE5 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE5,
167: FND_API.G_MISS_CHAR,

Line 167: FND_API.G_MISS_CHAR,

163: FND_API.G_MISS_CHAR,
164: oldrec.ATTRIBUTE4,
165: p_invoice_changes_all_rec.ATTRIBUTE4),
166: ATTRIBUTE5 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE5,
167: FND_API.G_MISS_CHAR,
168: oldrec.ATTRIBUTE5,
169: p_invoice_changes_all_rec.ATTRIBUTE5),
170: ATTRIBUTE6 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE6,
171: FND_API.G_MISS_CHAR,

Line 171: FND_API.G_MISS_CHAR,

167: FND_API.G_MISS_CHAR,
168: oldrec.ATTRIBUTE5,
169: p_invoice_changes_all_rec.ATTRIBUTE5),
170: ATTRIBUTE6 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE6,
171: FND_API.G_MISS_CHAR,
172: oldrec.ATTRIBUTE6,
173: p_invoice_changes_all_rec.ATTRIBUTE6),
174: ATTRIBUTE7 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE7,
175: FND_API.G_MISS_CHAR,

Line 175: FND_API.G_MISS_CHAR,

171: FND_API.G_MISS_CHAR,
172: oldrec.ATTRIBUTE6,
173: p_invoice_changes_all_rec.ATTRIBUTE6),
174: ATTRIBUTE7 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE7,
175: FND_API.G_MISS_CHAR,
176: oldrec.ATTRIBUTE7,
177: p_invoice_changes_all_rec.ATTRIBUTE7),
178: ATTRIBUTE8 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE8,
179: FND_API.G_MISS_CHAR,

Line 179: FND_API.G_MISS_CHAR,

175: FND_API.G_MISS_CHAR,
176: oldrec.ATTRIBUTE7,
177: p_invoice_changes_all_rec.ATTRIBUTE7),
178: ATTRIBUTE8 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE8,
179: FND_API.G_MISS_CHAR,
180: oldrec.ATTRIBUTE8,
181: p_invoice_changes_all_rec.ATTRIBUTE8),
182: ATTRIBUTE9 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE9,
183: FND_API.G_MISS_CHAR,

Line 183: FND_API.G_MISS_CHAR,

179: FND_API.G_MISS_CHAR,
180: oldrec.ATTRIBUTE8,
181: p_invoice_changes_all_rec.ATTRIBUTE8),
182: ATTRIBUTE9 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE9,
183: FND_API.G_MISS_CHAR,
184: oldrec.ATTRIBUTE9,
185: p_invoice_changes_all_rec.ATTRIBUTE9),
186: ATTRIBUTE10 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE10,
187: FND_API.G_MISS_CHAR,

Line 187: FND_API.G_MISS_CHAR,

183: FND_API.G_MISS_CHAR,
184: oldrec.ATTRIBUTE9,
185: p_invoice_changes_all_rec.ATTRIBUTE9),
186: ATTRIBUTE10 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE10,
187: FND_API.G_MISS_CHAR,
188: oldrec.ATTRIBUTE10,
189: p_invoice_changes_all_rec.ATTRIBUTE10),
190: ATTRIBUTE11 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE11,
191: FND_API.G_MISS_CHAR,

Line 191: FND_API.G_MISS_CHAR,

187: FND_API.G_MISS_CHAR,
188: oldrec.ATTRIBUTE10,
189: p_invoice_changes_all_rec.ATTRIBUTE10),
190: ATTRIBUTE11 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE11,
191: FND_API.G_MISS_CHAR,
192: oldrec.ATTRIBUTE11,
193: p_invoice_changes_all_rec.ATTRIBUTE11),
194: ATTRIBUTE12 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE12,
195: FND_API.G_MISS_CHAR,

Line 195: FND_API.G_MISS_CHAR,

191: FND_API.G_MISS_CHAR,
192: oldrec.ATTRIBUTE11,
193: p_invoice_changes_all_rec.ATTRIBUTE11),
194: ATTRIBUTE12 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE12,
195: FND_API.G_MISS_CHAR,
196: oldrec.ATTRIBUTE12,
197: p_invoice_changes_all_rec.ATTRIBUTE12),
198: ATTRIBUTE13 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE13,
199: FND_API.G_MISS_CHAR,

Line 199: FND_API.G_MISS_CHAR,

195: FND_API.G_MISS_CHAR,
196: oldrec.ATTRIBUTE12,
197: p_invoice_changes_all_rec.ATTRIBUTE12),
198: ATTRIBUTE13 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE13,
199: FND_API.G_MISS_CHAR,
200: oldrec.ATTRIBUTE13,
201: p_invoice_changes_all_rec.ATTRIBUTE13),
202: ATTRIBUTE14 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE14,
203: FND_API.G_MISS_CHAR,

Line 203: FND_API.G_MISS_CHAR,

199: FND_API.G_MISS_CHAR,
200: oldrec.ATTRIBUTE13,
201: p_invoice_changes_all_rec.ATTRIBUTE13),
202: ATTRIBUTE14 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE14,
203: FND_API.G_MISS_CHAR,
204: oldrec.ATTRIBUTE14,
205: p_invoice_changes_all_rec.ATTRIBUTE14),
206: ATTRIBUTE15 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE15,
207: FND_API.G_MISS_CHAR,

Line 207: FND_API.G_MISS_CHAR,

203: FND_API.G_MISS_CHAR,
204: oldrec.ATTRIBUTE14,
205: p_invoice_changes_all_rec.ATTRIBUTE14),
206: ATTRIBUTE15 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE15,
207: FND_API.G_MISS_CHAR,
208: oldrec.ATTRIBUTE15,
209: p_invoice_changes_all_rec.ATTRIBUTE15),
210: LAST_UPDATE_DATE = Sysdate,
211: LAST_UPDATED_BY = fnd_global.user_id,

Line 215: FND_API.G_MISS_NUM,

211: LAST_UPDATED_BY = fnd_global.user_id,
212: LAST_UPDATE_LOGIN = fnd_global.login_id,
213: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
214: COMM_LINES_API_ID = DECODE(p_invoice_changes_all_rec.COMM_LINES_API_ID,
215: FND_API.G_MISS_NUM,
216: oldrec.COMM_LINES_API_ID,
217: p_invoice_changes_all_rec.COMM_LINES_API_ID)
218: WHERE invoice_change_id = p_invoice_changes_all_rec.invoice_change_id;
219:

Line 255: raise fnd_api.g_exc_unexpected_error;

251: if (c%notfound) then
252: close c;
253: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
254: fnd_msg_pub.add;
255: raise fnd_api.g_exc_unexpected_error;
256: end if;
257: close c;
258:
259: if (tlinfo.object_version_number <> p_invoice_changes_all_rec.object_version_number) then

Line 262: raise fnd_api.g_exc_unexpected_error;

258:
259: if (tlinfo.object_version_number <> p_invoice_changes_all_rec.object_version_number) then
260: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
261: fnd_msg_pub.add;
262: raise fnd_api.g_exc_unexpected_error;
263: end if;
264: UPDATE CN_INVOICE_CHANGES_ALL oldrec
265: SET
266: SALESREP_ID = DECODE(p_invoice_changes_all_rec.SALESREP_ID,

Line 267: FND_API.G_MISS_NUM,

263: end if;
264: UPDATE CN_INVOICE_CHANGES_ALL oldrec
265: SET
266: SALESREP_ID = DECODE(p_invoice_changes_all_rec.SALESREP_ID,
267: FND_API.G_MISS_NUM,
268: oldrec.SALESREP_ID,
269: p_invoice_changes_all_rec.SALESREP_ID),
270: INVOICE_NUMBER = DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER,
271: FND_API.G_MISS_CHAR,

Line 271: FND_API.G_MISS_CHAR,

267: FND_API.G_MISS_NUM,
268: oldrec.SALESREP_ID,
269: p_invoice_changes_all_rec.SALESREP_ID),
270: INVOICE_NUMBER = DECODE(p_invoice_changes_all_rec.INVOICE_NUMBER,
271: FND_API.G_MISS_CHAR,
272: oldrec.INVOICE_NUMBER,
273: p_invoice_changes_all_rec.INVOICE_NUMBER),
274: LINE_NUMBER = DECODE(p_invoice_changes_all_rec.LINE_NUMBER,
275: FND_API.G_MISS_NUM,

Line 275: FND_API.G_MISS_NUM,

271: FND_API.G_MISS_CHAR,
272: oldrec.INVOICE_NUMBER,
273: p_invoice_changes_all_rec.INVOICE_NUMBER),
274: LINE_NUMBER = DECODE(p_invoice_changes_all_rec.LINE_NUMBER,
275: FND_API.G_MISS_NUM,
276: oldrec.LINE_NUMBER,
277: p_invoice_changes_all_rec.LINE_NUMBER),
278: REVENUE_TYPE = DECODE(p_invoice_changes_all_rec.REVENUE_TYPE,
279: FND_API.G_MISS_CHAR,

Line 279: FND_API.G_MISS_CHAR,

275: FND_API.G_MISS_NUM,
276: oldrec.LINE_NUMBER,
277: p_invoice_changes_all_rec.LINE_NUMBER),
278: REVENUE_TYPE = DECODE(p_invoice_changes_all_rec.REVENUE_TYPE,
279: FND_API.G_MISS_CHAR,
280: oldrec.REVENUE_TYPE,
281: p_invoice_changes_all_rec.REVENUE_TYPE),
282: SPLIT_PCT = DECODE(p_invoice_changes_all_rec.SPLIT_PCT,
283: FND_API.G_MISS_NUM,

Line 283: FND_API.G_MISS_NUM,

279: FND_API.G_MISS_CHAR,
280: oldrec.REVENUE_TYPE,
281: p_invoice_changes_all_rec.REVENUE_TYPE),
282: SPLIT_PCT = DECODE(p_invoice_changes_all_rec.SPLIT_PCT,
283: FND_API.G_MISS_NUM,
284: oldrec.SPLIT_PCT,
285: p_invoice_changes_all_rec.SPLIT_PCT),
286: ATTRIBUTE_CATEGORY = DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY,
287: FND_API.G_MISS_CHAR,

Line 287: FND_API.G_MISS_CHAR,

283: FND_API.G_MISS_NUM,
284: oldrec.SPLIT_PCT,
285: p_invoice_changes_all_rec.SPLIT_PCT),
286: ATTRIBUTE_CATEGORY = DECODE(p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY,
287: FND_API.G_MISS_CHAR,
288: oldrec.ATTRIBUTE_CATEGORY,
289: p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY),
290: ATTRIBUTE1 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE1,
291: FND_API.G_MISS_CHAR,

Line 291: FND_API.G_MISS_CHAR,

287: FND_API.G_MISS_CHAR,
288: oldrec.ATTRIBUTE_CATEGORY,
289: p_invoice_changes_all_rec.ATTRIBUTE_CATEGORY),
290: ATTRIBUTE1 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE1,
291: FND_API.G_MISS_CHAR,
292: oldrec.ATTRIBUTE1,
293: p_invoice_changes_all_rec.ATTRIBUTE1),
294: ATTRIBUTE2 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE2,
295: FND_API.G_MISS_CHAR,

Line 295: FND_API.G_MISS_CHAR,

291: FND_API.G_MISS_CHAR,
292: oldrec.ATTRIBUTE1,
293: p_invoice_changes_all_rec.ATTRIBUTE1),
294: ATTRIBUTE2 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE2,
295: FND_API.G_MISS_CHAR,
296: oldrec.ATTRIBUTE2,
297: p_invoice_changes_all_rec.ATTRIBUTE2),
298: ATTRIBUTE3 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE3,
299: FND_API.G_MISS_CHAR,

Line 299: FND_API.G_MISS_CHAR,

295: FND_API.G_MISS_CHAR,
296: oldrec.ATTRIBUTE2,
297: p_invoice_changes_all_rec.ATTRIBUTE2),
298: ATTRIBUTE3 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE3,
299: FND_API.G_MISS_CHAR,
300: oldrec.ATTRIBUTE3,
301: p_invoice_changes_all_rec.ATTRIBUTE3),
302: ATTRIBUTE4 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE4,
303: FND_API.G_MISS_CHAR,

Line 303: FND_API.G_MISS_CHAR,

299: FND_API.G_MISS_CHAR,
300: oldrec.ATTRIBUTE3,
301: p_invoice_changes_all_rec.ATTRIBUTE3),
302: ATTRIBUTE4 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE4,
303: FND_API.G_MISS_CHAR,
304: oldrec.ATTRIBUTE4,
305: p_invoice_changes_all_rec.ATTRIBUTE4),
306: ATTRIBUTE5 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE5,
307: FND_API.G_MISS_CHAR,

Line 307: FND_API.G_MISS_CHAR,

303: FND_API.G_MISS_CHAR,
304: oldrec.ATTRIBUTE4,
305: p_invoice_changes_all_rec.ATTRIBUTE4),
306: ATTRIBUTE5 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE5,
307: FND_API.G_MISS_CHAR,
308: oldrec.ATTRIBUTE5,
309: p_invoice_changes_all_rec.ATTRIBUTE5),
310: ATTRIBUTE6 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE6,
311: FND_API.G_MISS_CHAR,

Line 311: FND_API.G_MISS_CHAR,

307: FND_API.G_MISS_CHAR,
308: oldrec.ATTRIBUTE5,
309: p_invoice_changes_all_rec.ATTRIBUTE5),
310: ATTRIBUTE6 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE6,
311: FND_API.G_MISS_CHAR,
312: oldrec.ATTRIBUTE6,
313: p_invoice_changes_all_rec.ATTRIBUTE6),
314: ATTRIBUTE7 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE7,
315: FND_API.G_MISS_CHAR,

Line 315: FND_API.G_MISS_CHAR,

311: FND_API.G_MISS_CHAR,
312: oldrec.ATTRIBUTE6,
313: p_invoice_changes_all_rec.ATTRIBUTE6),
314: ATTRIBUTE7 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE7,
315: FND_API.G_MISS_CHAR,
316: oldrec.ATTRIBUTE7,
317: p_invoice_changes_all_rec.ATTRIBUTE7),
318: ATTRIBUTE8 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE8,
319: FND_API.G_MISS_CHAR,

Line 319: FND_API.G_MISS_CHAR,

315: FND_API.G_MISS_CHAR,
316: oldrec.ATTRIBUTE7,
317: p_invoice_changes_all_rec.ATTRIBUTE7),
318: ATTRIBUTE8 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE8,
319: FND_API.G_MISS_CHAR,
320: oldrec.ATTRIBUTE8,
321: p_invoice_changes_all_rec.ATTRIBUTE8),
322: ATTRIBUTE9 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE9,
323: FND_API.G_MISS_CHAR,

Line 323: FND_API.G_MISS_CHAR,

319: FND_API.G_MISS_CHAR,
320: oldrec.ATTRIBUTE8,
321: p_invoice_changes_all_rec.ATTRIBUTE8),
322: ATTRIBUTE9 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE9,
323: FND_API.G_MISS_CHAR,
324: oldrec.ATTRIBUTE9,
325: p_invoice_changes_all_rec.ATTRIBUTE9),
326: ATTRIBUTE10 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE10,
327: FND_API.G_MISS_CHAR,

Line 327: FND_API.G_MISS_CHAR,

323: FND_API.G_MISS_CHAR,
324: oldrec.ATTRIBUTE9,
325: p_invoice_changes_all_rec.ATTRIBUTE9),
326: ATTRIBUTE10 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE10,
327: FND_API.G_MISS_CHAR,
328: oldrec.ATTRIBUTE10,
329: p_invoice_changes_all_rec.ATTRIBUTE10),
330: ATTRIBUTE11 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE11,
331: FND_API.G_MISS_CHAR,

Line 331: FND_API.G_MISS_CHAR,

327: FND_API.G_MISS_CHAR,
328: oldrec.ATTRIBUTE10,
329: p_invoice_changes_all_rec.ATTRIBUTE10),
330: ATTRIBUTE11 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE11,
331: FND_API.G_MISS_CHAR,
332: oldrec.ATTRIBUTE11,
333: p_invoice_changes_all_rec.ATTRIBUTE11),
334: ATTRIBUTE12 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE12,
335: FND_API.G_MISS_CHAR,

Line 335: FND_API.G_MISS_CHAR,

331: FND_API.G_MISS_CHAR,
332: oldrec.ATTRIBUTE11,
333: p_invoice_changes_all_rec.ATTRIBUTE11),
334: ATTRIBUTE12 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE12,
335: FND_API.G_MISS_CHAR,
336: oldrec.ATTRIBUTE12,
337: p_invoice_changes_all_rec.ATTRIBUTE12),
338: ATTRIBUTE13 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE13,
339: FND_API.G_MISS_CHAR,

Line 339: FND_API.G_MISS_CHAR,

335: FND_API.G_MISS_CHAR,
336: oldrec.ATTRIBUTE12,
337: p_invoice_changes_all_rec.ATTRIBUTE12),
338: ATTRIBUTE13 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE13,
339: FND_API.G_MISS_CHAR,
340: oldrec.ATTRIBUTE13,
341: p_invoice_changes_all_rec.ATTRIBUTE13),
342: ATTRIBUTE14 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE14,
343: FND_API.G_MISS_CHAR,

Line 343: FND_API.G_MISS_CHAR,

339: FND_API.G_MISS_CHAR,
340: oldrec.ATTRIBUTE13,
341: p_invoice_changes_all_rec.ATTRIBUTE13),
342: ATTRIBUTE14 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE14,
343: FND_API.G_MISS_CHAR,
344: oldrec.ATTRIBUTE14,
345: p_invoice_changes_all_rec.ATTRIBUTE14),
346: ATTRIBUTE15 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE15,
347: FND_API.G_MISS_CHAR,

Line 347: FND_API.G_MISS_CHAR,

343: FND_API.G_MISS_CHAR,
344: oldrec.ATTRIBUTE14,
345: p_invoice_changes_all_rec.ATTRIBUTE14),
346: ATTRIBUTE15 = DECODE(p_invoice_changes_all_rec.ATTRIBUTE15,
347: FND_API.G_MISS_CHAR,
348: oldrec.ATTRIBUTE15,
349: p_invoice_changes_all_rec.ATTRIBUTE15),
350: LAST_UPDATE_DATE = Sysdate,
351: LAST_UPDATED_BY = fnd_global.user_id,

Line 355: FND_API.G_MISS_NUM,

351: LAST_UPDATED_BY = fnd_global.user_id,
352: LAST_UPDATE_LOGIN = fnd_global.login_id,
353: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
354: COMM_LINES_API_ID = DECODE(p_invoice_changes_all_rec.COMM_LINES_API_ID,
355: FND_API.G_MISS_NUM,
356: oldrec.COMM_LINES_API_ID,
357: p_invoice_changes_all_rec.COMM_LINES_API_ID)
358: WHERE invoice_change_id = p_invoice_changes_all_rec.invoice_change_id;
359: