[Home] [Help]
41: IF FND_API.to_Boolean( p_init_msg_list) THEN
42: FND_MSG_PUB.initialize;
43: END IF;
44:
45: UPDATE pn_payment_terms
46: SET vendor_id = p_vendor_id,
47: vendor_site_id = p_vendor_site_id,
48: last_updated_by = p_last_updated_by,
49: last_update_date = sysdate
50: WHERE vendor_id = p_dup_vendor_id
51: AND vendor_site_id = p_dup_vendor_site_id;
52:
53: -- Prepare message name
54: FND_MESSAGE.SET_NAME('PN','PN_PAYMENT_TERMS');
55: IF SQL%FOUND THEN
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57: l_row_count := SQL%ROWCOUNT;
58: ELSE
103: FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);
104: -- Add message to API message list.
105: FND_MSG_PUB.Add;
106:
107: UPDATE pn_payment_terms_history
108: SET vendor_id = p_vendor_id,
109: vendor_site_id = p_vendor_site_id,
110: last_updated_by = p_last_updated_by,
111: last_update_date = sysdate
112: WHERE vendor_id = p_dup_vendor_id
113: AND vendor_site_id = p_dup_vendor_site_id;
114:
115: -- Prepare message name
116: FND_MESSAGE.SET_NAME('PN','PN_PAYMENT_TERMS_HISTORY');
117: IF SQL%FOUND THEN
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119: l_row_count := SQL%ROWCOUNT;
120: ELSE