APPS.CN_PREPOSTDETAILS dependencies on CN_POSTING_DETAILS_S

Line 19: SELECT cn_posting_details_s.nextval

15: -- ----------------------------------------------------------------------------+
16: PROCEDURE Get_UID( x_posting_detail_id IN OUT NUMBER )
17: IS
18: CURSOR get_id IS
19: SELECT cn_posting_details_s.nextval
20: FROM dual;
21: BEGIN
22: OPEN get_id;
23: FETCH get_id INTO x_posting_detail_id;

Line 300: UPDATE cn_posting_details SET

296: open c;
297: fetch c into l_oldrec;
298: close c;
299:
300: UPDATE cn_posting_details SET
301: status = decode(x_status, FND_API.G_MISS_CHAR,
302: l_oldrec.status, x_status),
303: loaded_date = decode(x_loaded_date, FND_API.G_MISS_DATE,
304: l_oldrec.loaded_date, x_loaded_date),