[Home] [Help]
1345:
1346: l_progress := '000';
1347:
1348: -- update the record with the orig header id /trading partner id
1349: UPDATE pon_supplier_access
1350: SET active_flag = 'N'
1351: , last_update_date = l_sysdate
1352: , last_updated_by = l_user_id
1353: , last_update_login = l_login_id
1361:
1362: l_progress := '001';
1363:
1364: -- now insert the new record
1365: INSERT INTO pon_supplier_access(auction_header_id_orig_amend
1366: ,supplier_trading_partner_id
1367: ,lock_date
1368: ,buyer_tp_contact_id
1369: ,lock_status